Updated 2022-11-01
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
BLOCK_TIMESTAMP::date as date,
count(ORIGIN_TO_ADDRESS)as number_USDC,
sum (AMOUNT / pow (10,b.decimals)) as a_amount_USDC
-- 'USDT' as Tag
from ethereum.core.ez_token_transfers a
join ethereum.core.dim_contracts b on b.address = a.ORIGIN_FROM_ADDRESS
where a.symbol = 'USDC'
group by 1
order by 1
Run a query to Download Data