mariyaethereum - # of USDC transactions
Updated 2022-04-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with USDC_vol_ethereum as (
select sum(amount_usd) as USDC_amount ,to_date(block_timestamp) as swapdate from ethereum.dex_swaps where
swapdate >= '2022-01-01' and POOL_NAME like '%USDC%'
group by swapdate)
, USDC_num_ethereum as (select count(*) as USDC_count,to_date(block_timestamp) as swapdate from ethereum.dex_swaps where
swapdate >= '2022-01-01' and POOL_NAME like '%USDC%'
group by swapdate)
,USDC_avg_ethereum as (select (sum(amount_usd)/count(*)) as USDC_avg, sum(amount_usd),count(*) from ethereum.dex_swaps where
to_date(block_timestamp) >= '2022-01-01' and POOL_NAME like '%USDC%' and amount_usd is not null
)
select * from USDC_num_ethereum
Run a query to Download Data