nitsUSDC Volume Eth
Updated 2022-04-15
9
1
2
3
4
5
6
7
8
›
⌄
SELECT date(block_timestamp) as day, sum(amount_usd) as total_amt, sum(total_amt) over (order by day) as cumulative_amt, count(DISTINCT tx_id) as total_txs, sum(total_txs) over (order by day)
as cumulative_txs,
avg(amount_usd) as avg_amount_transferred, avg( avg_amount_transferred) over (ORDER by day ) as cumulative_avg_amount_transferred
from ethereum.udm_events
where symbol = 'USDC' and block_timestamp >= '2022-01-01' and amount_usd is not NULL
GROUP by 1
ORDER by 1
-- LIMIT 100
Run a query to Download Data