Solana Dexscreener Data

Returns DEX trades by token on Solana, where side currency mint address is So1111…1112: currency name, currency mint address, currency symbol, price in USD, protocol name, protocol family, program address and 6 more fields.

By Jastyne Anunciacion · saved 10 December 2024 · run 24 times · Bitquery API v2

What it returns

Filters

The query

query MyQuery($address: String!, $pair_address: String!, $time_5min_ago: DateTime!, $time_1h_ago: DateTime!, $time_6h_ago: DateTime!, $time_24h_ago: DateTime!) {
  Solana(dataset: realtime) {
    DEXTradeByTokens(
      where: {Transaction: {Result: {Success: true}}, Trade: {Currency: {MintAddress: {is: $address}}, Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}, Market: {MarketAddress: {is: $pair_address}}}, Block: {Time: {since: $time_24h_ago}}}
    ) {
      Trade {
        Currency {
          Name
          MintAddress
          Symbol
        }
        usd_24h: PriceInUSD(minimum: Block_Time)
        usd_6h: PriceInUSD(
          minimum: Block_Time
          if: {Block: {Time: {after: $time_6h_ago}}}
        )
        usd_1h: PriceInUSD(
          minimum: Block_Time
          if: {Block: {Time: {after: $time_1h_ago}}}
        )
        usd_5min: PriceInUSD(
          minimum: Block_Time
          if: {Block: {Time: {after: $time_5min_ago}}}
        )
        currentUSD: PriceInUSD(maximum: Block_Time)
        Dex {
          ProtocolName
          ProtocolFamily
          ProgramAddress
        }
        Market {
          MarketAddress
        }
        Side {
          Currency {
            Symbol
            Name
            MintAddress
          }
        }
      }
      makers_total: count(distinct: Transaction_Signer)
      makers_24h: count(
        distinct: Transaction_Signer
        if: {Block: {Time: {after: $time_24h_ago}}}
      )
      makers_6h: count(
        distinct: Transaction_Signer
        if: {Block: {Time: {after: $time_6h_ago}}}
      )
      makers_1h: count(
        distinct: Transaction_Signer
        if: {Block: {Time: {after: $time_1h_ago}}}
      )
      makers_5min: count(
        distinct: Transaction_Signer
        if: {Block: {Time: {after: $time_5min_ago}}}
      )
      buyers_total: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: buy}}}}
      )
      buyers_24h: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}}
      )
      buyers_6h: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_6h_ago}}}
      )
      buyers_1h: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}}
      )
      buyers_5min: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}}
      )
      sellers_total: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: sell}}}}
      )
      sellers_24h: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}}
      )
      sellers_6h: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_6h_ago}}}
      )
      sellers_1h: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}}
      )
      sellers_5min: count(
        distinct: Transaction_Signer
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}}
      )
      trades_total: count
      trades_24h: count(if: {Block: {Time: {after: $time_24h_ago}}})
      trades_6h: count(if: {Block: {Time: {after: $time_6h_ago}}})
      trades_1h: count(if: {Block: {Time: {after: $time_1h_ago}}})
      trades_5min: count(if: {Block: {Time: {after: $time_5min_ago}}})
      traded_volume_total: sum(of: Trade_Side_AmountInUSD)
      traded_volume_24h: sum(
        of: Trade_Side_AmountInUSD
        if: {Block: {Time: {after: $time_24h_ago}}}
      )
      traded_volume_6h: sum(
        of: Trade_Side_AmountInUSD
        if: {Block: {Time: {after: $time_6h_ago}}}
      )
      traded_volume_1h: sum(
        of: Trade_Side_AmountInUSD
        if: {Block: {Time: {after: $time_1h_ago}}}
      )
      traded_volume_5min: sum(
        of: Trade_Side_AmountInUSD
        if: {Block: {Time: {after: $time_5min_ago}}}
      )
      buy_volume_total: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}}
      )
      buy_volume_24h: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}}
      )
      buy_volume_6h: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_6h_ago}}}
      )
      buy_volume_1h: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}}
      )
      buy_volume_5min: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}}
      )
      sell_volume_total: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}}
      )
      sell_volume_24h: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}}
      )
      sell_volume_6h: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_6h_ago}}}
      )
      sell_volume_1h: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}}
      )
      sell_volume_5min: sum(
        of: Trade_Side_AmountInUSD
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}}
      )
      buys_total: count(if: {Trade: {Side: {Type: {is: buy}}}})
      buys_24h: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}}
      )
      buys_6h: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_6h_ago}}}
      )
      buys_1h: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}}
      )
      buys_5min: count(
        if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}}
      )
      sells_total: count(if: {Trade: {Side: {Type: {is: sell}}}})
      sells_24h: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}}
      )
      sells_6h: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_6h_ago}}}
      )
      sells_1h: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}}
      )
      sells_5min: count(
        if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}}
      )
    }
  }
}

Similar queries