tradingActivity
Returns DEX trades by token on Ethereum, where currency smart contract is 0x2260…c599: count and sum of trade side amount in USD.
What it returns
- count
- sum of trade side amount in USD
Filters
- currency smart contract is 0x2260…c599
The query
query getTradingActivity($network: evm_network, $token: String, $min5After: DateTime!, $hour1After: DateTime!, $hour6After: DateTime!, $hour24After: DateTime!) {
EVM(dataset: realtime, network: $network) {
DEXTradeByTokens(
where: {TransactionStatus: {Success: true}, Trade: {Currency: {SmartContract: {is: $token}}}}
) {
makersAt5Min: count(
distinct: Transaction_From
if: {Block: {Time: {after: $min5After}}}
)
makersAt1Hour: count(
distinct: Transaction_From
if: {Block: {Time: {after: $hour1After}}}
)
makersAt6Hour: count(
distinct: Transaction_From
if: {Block: {Time: {after: $hour6After}}}
)
makersAt24Hour: count(
distinct: Transaction_From
if: {Block: {Time: {after: $hour24After}}}
)
uniqueBuyersAt5Min: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $min5After}}}
)
uniqueBuyersAtHour1: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour1After}}}
)
uniqueBuyersAtHour6: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour6After}}}
)
uniqueBuyersAtHour24: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour24After}}}
)
uniqueSellersAt5Min: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $min5After}}}
)
uniqueSellersAt1Hour: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour1After}}}
)
uniqueSellersAt6Hour: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour6After}}}
)
uniqueSellersAt24Hour: count(
distinct: Transaction_From
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour24After}}}
)
volumeBuyAt5Min: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $min5After}}}
)
volumeBuyAt1Hour: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour1After}}}
)
volumeBuyAt6Hour: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour6After}}}
)
volumeBuyAt24Hour: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour24After}}}
)
volumeSellAt5Min: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $min5After}}}
)
volumeSellAt1Hour: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour1After}}}
)
volumeSellAt6Hour: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour6After}}}
)
volumeSellAt24Hour: sum(
of: Trade_Side_AmountInUSD
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour24After}}}
)
buysAt5Min: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $min5After}}}
)
buysAt1Hour: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour1After}}}
)
buysAt6Hour: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour6After}}}
)
buysAt24Hour: count(
if: {Trade: {Side: {Type: {is: sell}}}, Block: {Time: {after: $hour24After}}}
)
sellsAt5Min: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $min5After}}}
)
sellsAt1Hour: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour1After}}}
)
sellsAt6Hour: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour6After}}}
)
sellsAt24Hour: count(
if: {Trade: {Side: {Type: {is: buy}}}, Block: {Time: {after: $hour24After}}}
)
}
}
}
Variables
{
"network": "eth",
"token": "0x2260fac5e5542a773aa44fbcfedf7c193bc2c599",
"min5After": "2024-10-29T15:01:07.038Z",
"hour1After": "2024-10-29T14:01:07.338Z",
"hour6After": "2024-10-29T09:01:07.338Z",
"hour24After": "2024-10-28T15:01:07.338Z"
}
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