mondov2023-06-10 11:41 PM
Updated 2023-06-11
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT sum(amount_in) as volume, count(distinct trader) as traders,
count(distinct tx_hash) as transactions,
volume/transactions as average_per_transaction,
volume/traders as average_per_user,
'from USDT' as type, token_in, token_out
FROM near.core.ez_dex_swaps
WHERE lower(token_in) like '%usdt%' AND lower(token_out) like '%usdt%'
AND BLOCK_TIMESTAMP >= current_date - {{past_days}}
GROUP BY token_in, token_out
Run a query to Download Data