Liquidity-Update-of-a-Pool-on-Each-Day

Returns balance updates on Ethereum, where balance update address is 0x5c69…72F5, currency smart contract is 0x6e79…6615 or 0xc02a…6cc2 and block time since 2024-03-10, sorted by block date: currency name, sum of balance update amount and block time.

By Kshitij Mahajan · saved 10 July 2024 · run 8 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery {
  EVM(network: eth, dataset: combined) {
    BalanceUpdates(
      where: {BalanceUpdate: {Address: {is: "0x5c6919B79FAC1C3555675ae59A9ac2484f3972F5"}}, Currency: {SmartContract: {in: ["0x6e79b51959cf968d87826592f46f819f92466615", "0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2"]}}, Block: {Time: {since: "2024-03-10T08:32:47Z"}}}
      orderBy: {ascending: Block_Date}
    ) {
      Currency {
        Name
      }
      balance: sum(of: BalanceUpdate_Amount)
      Block {
        Time(interval: {count: 1, in: days})
      }
    }
  }
}

Similar queries