Eman-RazVolume of ETH Deposited per Day
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with tab1 as (select block_timestamp::date as date, sum(issued_tokens) as volume, 'Aave'
from ethereum.aave.ez_deposits
where date between '2022-09-01' and '2022-09-30'
and symbol='WETH'
group by 1,3
order by 1),
tab2 as (select block_timestamp::date as date, sum(amount_deposited) as volume_, 'Maker'
from ethereum.maker.ez_deposits
where date between '2022-09-01' and '2022-09-30'
and symbol='WETH'
group by 1,3
order by 1),
tab3 as (select block_timestamp::date as date, sum(SUPPLIED_BASE_ASSET) as volume__, 'Compound'
from ethereum.compound.ez_deposits
where date between '2022-09-01' and '2022-09-30'
and CTOKEN_SYMBOL='cETH'
group by 1,3
order by 1)
select * from tab1
UNION
select * from tab2
UNION
select * from tab3
Run a query to Download Data