mlhUntitled Query
Updated 2022-11-30
9
1
2
3
4
5
6
7
8
›
⌄
SELECT date_trunc('day', block_timestamp) as day,
count(DISTINCT TX_HASH) as transfers,
avg(amount_usd) as avg_USD_volume,
sum(amount_usd) as USD_volume,
count(DISTINCT ORIGIN_FROM_ADDRESS) as transferes
FROM avalanche.core.ez_avax_transfers
where day >= CURRENT_DATE - 90
GROUP BY 1
Run a query to Download Data