Token trades on Solana

Returns DEX trades by token on Solana, where currency mint address is 3NZ9JM…qmJh, sorted by USD, highest first: currency symbol, currency name, currency mint address, fungible, side currency symbol, side currency name, side currency mint address and 4 more fields.

By Aleksey · saved 19 August 2024 · run 2 times · Bitquery API v2

What it returns

Filters

The query

query($token: String, $time_10min_ago: DateTime, $time_1h_ago: DateTime, $time_3h_ago: DateTime) {
  Solana(aggregates: only) {
    DEXTradeByTokens(
      orderBy: {
        descendingByField: "usd"
      }
      where: {
        Trade: {
          Currency: {
            MintAddress: {
              is: $token
            }
          }
        }
        Transaction: {Result: {Success: true}}
      }
    	
    ) {
      Trade {
        Currency {
          Symbol
          Name
          MintAddress
          Fungible
        }
        
 				Side {
          Currency {
         		Symbol
          	Name
          	MintAddress
          }
        }
        price_usd: PriceInUSD(maximum: Block_Slot)
        price_last: Price(maximum: Block_Slot)
        price_10min_ago: Price(maximum: Block_Slot if: {Block: {Time: {before: $time_10min_ago}}})
        price_1h_ago: Price(maximum: Block_Slot if: {Block: {Time: {before: $time_1h_ago}}})
				price_3h_ago: Price(maximum: Block_Slot if: {Block: {Time: {before: $time_3h_ago}}})

      }
      usd: sum(of: Trade_AmountInUSD)
      count
    }
  }
}

Variables

{
  "token": "3NZ9JMVBmGAqocybic2c7LQCJScmgsAZ6vQqTDzcqmJh",
  "time_10min_ago": "2024-08-19T03:00:00Z",
  "time_1h_ago": "2024-08-19T04:00:00Z",
  "time_3h_ago": "2024-08-19T02:00:00Z"
}

Similar queries