Alexaystaking daily
Updated 2022-09-12Copy Reference Fork
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
›
⌄
with lido as ( select block_timestamp::date as date, sum (raw_amount/1e18) as lido_amount
from ethereum.core.fact_token_transfers
where contract_address = lower('0xae7ab96520DE3A18E5e111B5EaAb095312D7fE84')
and from_address = '0x0000000000000000000000000000000000000000'
group by 1),
rocketpool as (select block_timestamp::date as date, sum (raw_amount/1e18) as rocket_amount
from ethereum.core.fact_token_transfers
where contract_address = lower('0xae78736cd615f374d3085123a210448e74fc6393')
and from_address = '0x0000000000000000000000000000000000000000'
group by 1),
ankr as ( select block_timestamp::date as date, sum (raw_amount/1e18) as ankr_amount
from ethereum.core.fact_token_transfers
where contract_address = lower('0xe95a203b1a91a908f9b9ce46459d101078c2c3cb')
and from_address = '0x0000000000000000000000000000000000000000'
group by 1)
select a.*, b.rocket_amount, c.ankr_amount
from lido a
full join rocketpool b on a.date = b.date
full join ankr c on a.date = c.date
where a.date >= '2022-01-01'
order by a.date desc
Run a query to Download Data