precision problem with USDC
Returns DEX trades by token on Ethereum, where currency smart contract is 0xA0b8…eB48 and block time since 2024-10-31: 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 0xA0b8…eB48
- block time since 2024-10-31
The query
query getTradingActivity(
$network: evm_network,
$token: String,
$since: DateTime!,
$min5After: DateTime!,
$hour1After: DateTime!,
$hour6After: DateTime!,
$hour24After: DateTime!
) {
EVM(dataset: realtime, network: $network) {
DEXTradeByTokens(
where: {
TransactionStatus: {Success: true},
Trade: {Currency: {SmartContract: {is: $token}}},
Block: {Time: {since: $since}}}
) {
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": "0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48",
"since":"2024-10-31T19:18:00Z",
"min5After":"2024-11-01T19:13:00Z",
"hour1After":"2024-11-01T18:18:00Z",
"hour6After":"2024-11-01T13:18:00Z",
"hour24After":"2024-10-31T19:18:00Z"
}
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