cypherLido active users
Updated 2022-04-10
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
27
28
29
30
31
32
33
34
35
36
›
⌄
with lido as (select
date_trunc('day', block_timestamp) as date,
count(distinct(origin_address)) as lido_daily_active_users,
count(distinct(tx_id)) as lido_daily_n_transactions
from ethereum.udm_events
where block_timestamp >= '2022-1-1'
and contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
group by date),
rocketpool as (
select
date_trunc('day', block_timestamp) as date,
count(distinct(origin_address)) as rp_daily_active_users,
count(distinct(tx_id)) as rp_daily_n_transactions
from ethereum.udm_events
where block_timestamp >= '2022-1-1'
and contract_address = lower('0xae78736Cd615f374D3085123A210448E74Fc6393')
group by date
),
ankr as (
select
date_trunc('day', block_timestamp) as date,
count(distinct(origin_address)) as ankr_daily_active_users,
count(distinct(tx_id)) as ankr_daily_n_transactions
from ethereum.udm_events
where block_timestamp >= '2022-1-1'
and contract_address = lower('0xE95A203B1a91a908F9B9CE46459d101078c2c3cb')
group by date
)
select * from lido
full outer join rocketpool using(date)
full outer join ankr using (date)
Run a query to Download Data