getTokensScreener
Returns DEX trades by token on Ethereum, where block time since 2024-09-23 and block time till 2024-09-30, sorted by volume24 h, highest first: block time, currency symbol, currency name, smart contract, trade price, amount in USD, trade amount and 6 more fields.
What it returns
- block time
- currency symbol
- currency name
- smart contract
- trade price
- amount in USD
- trade amount
- price in USD
- side currency name
- side currency symbol
- side smart contract
- sum of trade amount in USD
- count
Filters
- block time since 2024-09-23
- block time till 2024-09-30
The query
query getTokensScreener($dataset: dataset_arg_enum!, $network: evm_network!, $timeFrom1w: DateTime!, $timeFrom24h: DateTime!, $timeFrom6h: DateTime!, $timeFrom1h: DateTime!, $timeFrom5m: DateTime!, $timeTo: DateTime!) {
EVM(dataset: $dataset, network: $network) {
DEXTradeByTokens(
orderBy: {descendingByField: "volume24h"}
where: {Block: {Time: {since: $timeFrom1w, till: $timeTo}}}
) {
Block {
Time
}
Trade {
Currency {
Symbol
Name
SmartContract
}
open: Price(minimum: Block_Number)
close: Price(maximum: Block_Number)
high: Price(maximum: Trade_Price)
low: Price(minimum: Trade_Price)
AmountInUSD
Amount
PriceInUSD
Side {
Currency {
Name
Symbol
SmartContract
}
}
}
volume1w: sum(of: Trade_AmountInUSD)
volume24h: sum(
of: Trade_AmountInUSD
if: {Block: {Time: {since: $timeFrom24h}}}
)
volume6h: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom6h}}})
volume1h: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom1h}}})
volume5m: sum(of: Trade_AmountInUSD, if: {Block: {Time: {since: $timeFrom5m}}})
tradeCount1w: count
tradeCount24h: count(if: {Block: {Time: {since: $timeFrom24h}}})
tradeCount6h: count(if: {Block: {Time: {since: $timeFrom6h}}})
tradeCount1h: count(if: {Block: {Time: {since: $timeFrom1h}}})
tradeCount5m: count(if: {Block: {Time: {since: $timeFrom5m}}})
buys1w: count(if: {Trade: {Side: {Type: {is: sell}}}})
sells1w: count(if: {Trade: {Side: {Type: {is: buy}}}})
buys24h: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom24h}}}
)
sells24h: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom24h}}}
)
buys6h: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom6h}}}
)
sells6h: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom6h}}}
)
buys1h: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom1h}}}
)
sells1h: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom1h}}}
)
buys5m: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {since: $timeFrom5m}}}
)
sells5m: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {since: $timeFrom5m}}}
)
uniqueTraders1w: count(distinct: Trade_Buyer)
}
}
}
Variables
{
"dataset": "combined",
"network": "eth",
"timeFrom1w": "2024-09-23T11:18:10.032Z",
"timeFrom24h": "2024-09-29T11:18:35.132Z",
"timeFrom6h": "2024-09-30T05:19:21.512Z",
"timeFrom1h": "2024-09-30T10:19:35.032Z",
"timeFrom5m": "2024-09-30T11:14:50.312Z",
"timeTo": "2024-09-30T11:20:08.730Z"
}
Similar queries
- CRV hourly OHLC on Curve - Ethereum · Ethereum · DEXTradeByTokens
- Top Metric liquidity pools by 24h volume on Ethereum · Ethereum · DEXTradeByTokens
- ATH of eth token · Ethereum · DEXTradeByTokens
- historical price and historical volume · Ethereum · DEXTradeByTokens
- topTraders EVM · Ethereum · DEXTradeByTokens