avaemaDaily Data of 3 platforms(#1)
Updated 2022-09-04
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
›
⌄
with datas as
(
select ETH_VALUE ,TX_FEE ,ORIGIN_FROM_ADDRESS ,CONTRACT_ADDRESS as platform, ethereum.core.fact_event_logs.BLOCK_TIMESTAMP
from ethereum.core.fact_event_logs inner join ethereum.core.fact_transactions
on ethereum.core.fact_event_logs.TX_HASH=ethereum.core.fact_transactions.TX_HASH
where
(CONTRACT_ADDRESS= lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670') or
CONTRACT_ADDRESS= lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58') or
CONTRACT_ADDRESS= lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84') ) and ETH_VALUE>0
)
select 'stkr' as Staking_Platform , sum(ETH_VALUE) staked_amount, sum(TX_FEE) staked_fee , count(distinct ORIGIN_FROM_ADDRESS) as unique_depositors
, date_trunc('month', BLOCK_TIMESTAMP) as staked_date
from datas where platform = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
group by staked_date
having staked_amount!=0
UNION
select 'Rocket pool' as Staking_Platform , sum(ETH_VALUE) staked_amount, sum(TX_FEE) staked_fee , count(distinct ORIGIN_FROM_ADDRESS) as unique_depositors
, date_trunc('month', BLOCK_TIMESTAMP) as staked_date
from datas where platform = lower('0x4D05E3d48a938db4b7a9A59A802D5b45011BDe58')
group by staked_date
having staked_amount!=0
UNION
select 'Lido' as Staking_Platform, sum(ETH_VALUE) staked_amount, sum(TX_FEE) staked_fee , count(distinct ORIGIN_FROM_ADDRESS) as unique_depositors
, date_trunc('month', BLOCK_TIMESTAMP) as staked_date
from datas where platform = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
group by staked_date
having staked_amount!=0
Run a query to Download Data