h4wkPoolTogether USDC Daily Deposit
Updated 2022-06-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
-- Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)?
-- What’s the average deposit amount per user?
-- DEPOSIT USDC
select date_trunc(day, block_timestamp) as date,
count(tx_hash) as tx_count,
count(distinct from_address) as unique_user,
sum(raw_amount/pow(10,6)) as deposit_volume,
sum(deposit_volume) over (order by date) as cumulative_volume
from ethereum.core.fact_token_transfers
where contract_address = '0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48' and to_address = '0xd89a09084555a7d0abe7b111b1f78dfeddd638be'
and block_timestamp::date < CURRENT_DATE and block_timestamp::date >= CURRENT_DATE - 31
group by date order by date
-- and tx_status = 'SUCCESS'
Run a query to Download Data