mohammadhUSDC Deposits 2
Updated 2022-06-22
9
1
2
3
4
5
6
7
8
9
›
⌄
select sum(AMOUNT) as usdc_volume,count(distinct(ORIGIN_FROM_ADDRESS)) as number_users,(usdc_volume/number_users) as avg_amount,
ORIGIN_FROM_ADDRESS
from ethereum.core.ez_token_transfers
where ORIGIN_TO_ADDRESS=lower('0xd89a09084555a7d0abe7b111b1f78dfeddd638be')
and block_timestamp >= current_date -31
and ORIGIN_FROM_ADDRESS=FROM_ADDRESS
and (ORIGIN_FUNCTION_SIGNATURE= '0xd7a169eb' OR ORIGIN_FUNCTION_SIGNATURE='0xffaad6a5')
group by ORIGIN_FROM_ADDRESS
Run a query to Download Data