precision problem with USDC_oa
Returns DEX trades by token on Ethereum, where currency smart contract is 0xA0b8…eB48 and block time since 2024-10-31, sorted by volume sell at1 hour, highest first: count, sum of trade side amount in USD, currency name, smart contract, side smart contract, side currency name, side decimals and 2 more fields.
What it returns
- count
- sum of trade side amount in USD
- currency name
- smart contract
- side smart contract
- side currency name
- side decimals
- side currency symbol
- side protocol name
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}}}
orderBy: {descendingByField: "volumeSellAt1Hour"}
) {
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}}}
)
Trade {
Currency {
Name
SmartContract
}
Side {
Currency {
SmartContract
Name
Decimals
Symbol
ProtocolName
}
}
}
}
}
}
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