FatemeTheLadyPooltogether deposit USDC
Updated 2022-06-23
9
1
2
3
4
5
6
7
›
⌄
SELECT date_trunc('day', block_timestamp) as date, sum(amount) as deposit_amount,
sum(deposit_amount) over(order by date) as deposit_amount_commulative,
count(distinct FROM_ADDRESS) as num_users, round(deposit_amount/num_users,3) as Avg_deposited
FROM ethereum.core.ez_token_transfers
WHERE ORIGIN_TO_ADDRESS='0xd89a09084555a7d0abe7b111b1f78dfeddd638be' AND SYMBOL = 'USDC' AND AMOUNT is not null
and block_timestamp::date <='2022-05-31' and block_timestamp::date >='2022-05-01'
GROUP BY 1 ORDER BY 1 asc
Run a query to Download Data