Token pairs

Returns 100 DEX trades by token on Solana, where block time after 2024-08-20, sorted by USD, highest first: currency symbol, currency name, currency mint address, side currency symbol, side currency name, side currency mint address, price in USD and 4 more fields.

By Aleksey · saved 21 August 2024 · run 3 times · Bitquery API v2

What it returns

Filters

The query

query($time_10min_ago: DateTime, $time_1h_ago: DateTime, $time_3h_ago: DateTime) {
  Solana(aggregates: only) {
    DEXTradeByTokens(
      where: {Transaction: {Result: {Success: true}}
      	Block: {
          Time: {
            after: $time_3h_ago
          }
        }
        
        any: [
          {Trade: {Side: {Currency: {MintAddress: {is: "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"}}}}}
          {Trade: {Currency: {MintAddress: {not: "EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"}} Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}}
          {Trade: {Currency: {MintAddress: {notIn: ["So11111111111111111111111111111111111111112","EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"]}} 
            Side: {Currency: {MintAddress: {notIn: ["So11111111111111111111111111111111111111112","EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v"]}}}}}
        ]
        
      }
    orderBy: {descendingByField: "usd"}
    limit: {count: 100}) {
      Trade {
        Currency {
          Symbol
          Name
          MintAddress
        }
        
        Side {
          Currency {
         		Symbol
          	Name
          	MintAddress
          }
        }
        price_last: PriceInUSD(maximum: Block_Slot)
        price_10min_ago: PriceInUSD(maximum: Block_Slot if: {Block: {Time: {before: $time_10min_ago}}})
        price_1h_ago: PriceInUSD(maximum: Block_Slot if: {Block: {Time: {before: $time_1h_ago}}})
        price_3h_ago: PriceInUSD(minimum: Block_Slot)
      }
      
    
      dexes: uniq(of: Trade_Dex_ProgramAddress)
      amount: sum(of: Trade_Side_Amount)
      usd: sum(of: Trade_Side_AmountInUSD )
      count(selectWhere: {ge: "100"} )
    }
  }
}

Variables

{"time_10min_ago": "2024-08-20T12:00:00Z",
  "time_1h_ago": "2024-08-20T11:00:00Z",
  "time_3h_ago": "2024-08-20T09:00:00Z"
}

Similar queries