Top Traders on Solana
Historical data This query uses the realtime dataset (the default), which holds only a recent window - hours to days depending on the cube. For older data add a dataset to the top-level element: Solana(dataset: combined) archive full history combined archive + realtime in one result Archive and c
What it returns
- trader address
- sum of amounts in USD base
- sum of amounts base
- calculate
- count
Filters
- market network is Solana
The query
# Historical data
# This query uses the realtime dataset (the default), which holds only a
# recent window - hours to days depending on the cube.
#
# For older data add a dataset to the top-level element:
#
# Solana(dataset: combined)
#
# archive full history
# combined archive + realtime in one result
#
# Archive and combined need the historical data add-on:
# https://bitquery.io/pricing
#
# Datasets: https://docs.bitquery.io/docs/graphql/dataset/archive/
# Retention: https://docs.bitquery.io/docs/graphql/data-coverage-retention/
#
{
Trading {
Trades(
limit: {count: 10}
limitBy:{count:1 by:Trader_Address}
orderBy: {descendingByField: "PnL"}
where: {Block: {Time: {since_relative: {minutes_ago: 30}}}, Pair: {Market: {Network: {is: "Solana"}}}}
) {
Trader {
Address
}
Amount_Bought: sum(of: AmountsInUsd_Base, if: {Side: {is: "Buy"}})
Amount_Sold: sum(of: AmountsInUsd_Base, if: {Side: {is: "Sell"}})
Amount_Bought_native: sum(of: Amounts_Base, if: {Side: {is: "Buy"}})
Amount_Sold_native: sum(of: Amounts_Base, if: {Side: {is: "Sell"}})
PnL: calculate(expression: "$Amount_Sold - $Amount_Bought")
buys: count(if: {Side: {is: "Buy"}})
sells: count(if: {Side: {is: "Sell"}})
}
}
}
Similar queries
- Elysium latest trades of one token (WHYPE) · Trading (all chains) · Trades
- Elysium DEX protocols by trade count · Trading (all chains) · Trades
- FOMO App: Trades per Day (Trading API) · Trading (all chains) · Trades
- save with commit · Trading (all chains) · Tokens