Yousefi_1994Unique depositors by platforms over time
Updated 2022-09-05
999
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with liquid_staking_by_lido as (
select
block_timestamp::date as days,
count(distinct origin_from_address) as number_of_depositors,
sum(number_of_depositors) over (order by days asc rows between unbounded preceding and current row) cumulative_number_of_depositors
from ethereum.core.ez_eth_transfers
where eth_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
group by days
order by days
),
lido_final_result as (
select
'Lido Liquid Staking' as platform_type,
*
from liquid_staking_by_lido
order by days
),
liquid_staking_by_stakewise as (
select
block_timestamp::date as days,
count(distinct origin_from_address) as number_of_depositors,
sum(number_of_depositors) over (order by days asc rows between unbounded preceding and current row) cumulative_number_of_depositors
from ethereum.core.ez_eth_transfers
where eth_to_address = '0xc874b064f465bdd6411d45734b56fac750cda29a'
group by days
order by days
),
stakewise_final_result as (
select
'Stakewise Liquid Staking' as platform_type,
*
from liquid_staking_by_stakewise
order by days
),
liquid_staking_by_rocket_pool as (
select
Run a query to Download Data