Bought SelectWhere on currency volume

Returns 10 DEX trades by token on Solana, where DEX protocol family is Raydium, block time since 2024-10-20 and side amount is above 0, sorted by volume USD, highest first: account owner, currency symbol, currency mint address, sum of trade amount and sum of trade side amount in USD.

By Aleksey · saved 4 November 2024 · run 5 times · Bitquery API v2

What it returns

Filters

The query

query DexMarkets {
  Solana {
    DEXTradeByTokens(
      orderBy: {descendingByField: "volumeUSD"}
      limit: {count: 10}
      where: {
        Block: {
            Time: {
                since: "2024-10-20T00:00:00Z"
            }
        },
        Trade: {
          Dex: {
            ProtocolFamily: {is: "Raydium"}
          }, 
          Side: {
            Amount: {gt: "0"}
          }
        }, 
        Transaction: {Result: {Success: true}}
      }
    ) {
      Trade {
        Account {
          Owner
        }
        Currency {
          Symbol
          MintAddress
        }
      }
      bought: sum(
        of: Trade_Amount
        if: {Trade: {Side: {Type: {is: buy}}}}
        selectWhere: {ge: "1000000"}
      )
      volumeUSD: sum(
        of: Trade_Side_AmountInUSD
      )
    }
  }
}

Similar queries