Eman-RazMaker: Deposit
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select block_timestamp::date as date, count(distinct depositor) as depositor_count,
count(distinct tx_hash) as "Deposit Count", sum(amount_deposited), case
when date='2022-09-15' then 'Merge Day'
when date>='2022-09-08' and date<='2022-09-14' then 'a Week Before Merge'
else 'Other Days'
end as day_type
from ethereum.maker.ez_deposits
where symbol='WETH' and date>current_date-30
group by 1,5
order by 1
Run a query to Download Data