Timestamp query

Returns 10 DEX trades by token on Solana, where currency symbol is gooch coin, DEX protocol name is pump and block time since 2024-12-20, sorted by block timefield: block time and trade price.

By Alex · saved 20 December 2024 · run 13 times · Bitquery API v2

What it returns

Filters

The query

{
  Solana {
    DEXTradeByTokens(
      limit: {count: 10}
      orderBy: {ascendingByField: "Block_Timefield"}
      where: {Trade: {Currency: {MintAddress: {}, Symbol: {is: "gooch coin"}}, Dex: {ProgramAddress: {}, ProtocolName: {is: "pump"}}, PriceAsymmetry: {lt: 0.1}}, Block: {Time: {since: "2024-12-20T19:40:50Z"}}}
    ) {
      Block {
        Timefield: Time
      }
      Trade {
				Price
      }
    }
  }
}

Similar queries