trade_stat
Returns DEX trades by token on Solana, where currency mint address is 9yBr75…pump or CNx1Lr…pump and side currency mint address is So1111…1112: count, unique of trade account address, sum of trade side amount, sum of trade side amount in USD, price in USD, currency symbol, currency name and 4 more fields.
What it returns
- count
- unique of trade account address
- sum of trade side amount
- sum of trade side amount in USD
- price in USD
- currency symbol
- currency name
- currency mint address
- side currency symbol
- side currency name
- side currency mint address
Filters
- currency mint address is 9yBr75…pump or CNx1Lr…pump
- side currency mint address is So1111…1112
The query
query ($baseTokenAddresses: [String!], $time_5min_ago: DateTime, $time_15min_ago: DateTime, $time_30min_ago: DateTime, $time_1h_ago: DateTime, $time_4h_ago: DateTime, $time_24h_ago: DateTime) {
Solana{
DEXTradeByTokens(
where: {Transaction: {Result: {Success: true}}, Trade: {Currency: {MintAddress: {in: $baseTokenAddresses}}, Side: {Currency: {MintAddress: {is: "So11111111111111111111111111111111111111112"}}}}, Block: {Time: {after: $time_24h_ago}}}
) {
buys_m5: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
sells_m5: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
buyers_m5: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
sellers_m5: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_m5: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_m5: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_in_usd_m5: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_m5: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_5min_ago}}, Transaction: {Result: {Success: true}}}
)
buys_m15: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
sells_m15: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
buyers_m15: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
sellers_m15: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_m15: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_m15: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_in_usd_m15: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_m15: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_15min_ago}}, Transaction: {Result: {Success: true}}}
)
buys_m30: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
sells_m30: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
buyers_m30: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
sellers_m30: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_m30: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_m30: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_in_usd_m30: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_m30: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_30min_ago}}, Transaction: {Result: {Success: true}}}
)
buys_h1: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
sells_h1: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
buyers_h1: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
sellers_h1: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_h1: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_h1: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_in_usd_h1: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_h1: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_1h_ago}}, Transaction: {Result: {Success: true}}}
)
buys_h4: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
sells_h4: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
buyers_h4: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
sellers_h4: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_h4: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_h4: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_in_usd_h4: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_h4: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_4h_ago}}, Transaction: {Result: {Success: true}}}
)
buys_h24: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
sells_h24: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
buyers_h24: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
sellers_h24: uniq(
of: Trade_Account_Address
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_h24: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_h24: sum(
of: Trade_Side_Amount
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
buy_volume_in_usd_h24: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_h24: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
sell_volume_in_usd_h24: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $time_24h_ago}}, Transaction: {Result: {Success: true}}}
)
Trade {
start: PriceInUSD(minimum: Block_Time)
min5: PriceInUSD(
minimum: Block_Time
if: {Block: {Time: {after: $time_5min_ago}}}
)
end: PriceInUSD(maximum: Block_Time)
Currency {
Symbol
Name
MintAddress
}
Side {
Currency {
Symbol
Name
MintAddress
}
}
}
}
}
}
Variables
{
"$time_5min_ago": "2025-01-13T07:43:10Z",
"$time_15min_ago": "2025-01-13T07:33:10Z",
"$time_30min_ago": "2025-01-13T07:18:10Z",
"$time_1h_ago": "2025-01-13T06:48:10Z",
"$time_4h_ago": "2025-01-13T03:48:10Z",
"$time_24h_ago": "2025-01-12T07:43:10Z",
"baseTokenAddresses": ["9yBr75m6TBZzQqHeh1ztfv454pmqAiAvHUHdpPQcpump", "CNx1LrMuYCQx6hdfUDdWUE537sgkMj9kYb355cHZpump"]
}
Similar queries
- ANSEM daily traders, June 16 to 26, 2026 · Solana · DEXTradeByTokens
- ANSEM swaps per hour, June 27, 2026 · Solana · DEXTradeByTokens
- FOMO App: Top Tokens Bought, Last Hour (Solana) · Solana · DEXTradeByTokens
- FOMO App: Most Active Wallets, Last Hour (Solana) · Solana · DEXTradeByTokens
- Buys, Sells, BuyVolume, SellVolume, Makers, TotalTradedVolume, PriceinUSD for solana token pair · Solana · DEXTradeByTokens