maybeyonaslido_reth_deposit
Updated 2022-04-24
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
›
⌄
with
lido_daily as (
select
date(block_timestamp) as date,
sum(event_inputs:amount/pow(10,18)) as amount_staked,
count(distinct tx_hash) as txs
from ethereum_core.fact_event_logs
where contract_address = lower('0xae7ab96520de3a18e5e111b5eaab095312d7fe84')
and event_name = 'Submitted'
group by 1
order by date desc
),
rocket_daily as (
select
date(block_timestamp) as date,
sum(event_inputs:ethAmount/pow(10,18)) as amount_staked,
count(distinct tx_hash) as txs
from ethereum_core.fact_event_logs
where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')
and event_name = 'TokensMinted'
group by 1
order by date desc
)
-- select * from ethereum_core.fact_event_logs
-- where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')
-- -- and
-- limit 100
select *, 'lido' as type from lido_daily
union all
select *, 'rocket' as type from rocket_daily
Run a query to Download Data