negin-khAmount of ETH staked before and after the Merge
Updated 2022-10-02
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 ethprice as (select hour::date as day, avg (price) as usdprice from ethereum.core.fact_hourly_token_prices where symbol ='WETH' group by 1),
stakewise as (
select 'Stakewise' as platform,
date_trunc (day,block_timestamp) as date,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (event_inputs:value/1e18) as Total_Volume,
sum (event_inputs:value/1e18*usdprice) as Total_USD_Volume,
sum (total_volume) over (order by date) as Cumulative_Volume,
sum (total_usd_volume) over (order by date) as Cumulative_USD_Volume
from ethereum.core.fact_event_logs t1 join ethprice t2 on t1.block_timestamp::date = t2.day
where origin_to_address = lower('0xC874b064f465bdD6411D45734b56fac750Cda29A')
and origin_function_signature in ('0x4a58db19','0x3a4b66f1','0x040dee8a')
and block_timestamp >= '2022-08-15'
group by date),
stkr as (
select 'stkr' as platform,
date_trunc (day,block_timestamp) as date,
count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (event_inputs:value/1e18) as Total_Volume,
sum (event_inputs:value/1e18*usdprice) as Total_USD_Volume,
sum (total_volume) over (order by date) as Cumulative_Volume,
sum (total_usd_volume) over (order by date) as Cumulative_USD_Volume
from ethereum.core.fact_event_logs t1 join ethprice t2 on t1.block_timestamp::date = t2.day
where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
and origin_function_signature in ('0x9fa65c56','0xeb834a2c')
and event_inputs:from = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
and block_timestamp >= '2022-08-15'
group by date),
Cream as (
select 'Cream' as platform,
date_trunc (day,block_timestamp) as date,
Run a query to Download Data