LargestMonthly

Returns 5 balance updates on Ethereum, where currency smart contract is 0x4F60…5AD3, block date after 2024-12-01 and block date before 2025-01-01, sorted by balance, highest first: sum of balance update amount, currency name, currency symbol and balance update address.

By Felix Eligbue · saved 16 January 2025 · run 1 time · Bitquery API v2

What it returns

Filters

The query

query GetLargestMonthlyHolder(
  $network: evm_network, 
  $limit: Int,
  $after: String,
  $before: String
) {
  EVM(dataset: combined, network: $network) {
    BalanceUpdates(
      limit: {count: $limit}
      orderBy: {descendingByField: "Balance"}
      where: {Currency: {
        SmartContract: {
          is: "0x4F604735c1cF31399C6E711D5962b2B3E0225AD3"}}, 
        Block: {
          Date: {
            after: $after, 
            before:  $before
          }
        }
      }
    ) {
      Balance: sum(of: BalanceUpdate_Amount)
      Currency {
        Name
        Symbol
      }
      BalanceUpdate {
        Address
      }
    }
  }
}

Variables

{
  "network": "eth",
  "limit": 5,
   "after": "2024-12-01", 
            "before": "2025-01-01"
}

Similar queries