Updated 2022-09-07Copy Reference Fork
9
1
2
3
4
5
6
7
8
›
⌄
select block_timestamp::date as days,
symbol,
sum(amount_usd)/10 as daily_volume_usd
from ethereum_core.ez_token_transfers transfers
where (lower(symbol) = 'dai' or lower(symbol) = 'tusd' or lower(symbol) = 'usdc' or lower(symbol) = 'busd' or lower(symbol) = 'usdt')
and block_timestamp::date >= '2022-01-01'
group by days, symbol
order by days
Run a query to Download Data