hbd19949. Liquid Staking Overview
Updated 2022-09-25
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 liquid_staking_data as (with ethprice as (select hour::date as date, avg (price) as usdprice from ethereum.core.fact_hourly_token_prices where symbol ='WETH' group by 1),
stakewise as (
select 'Stakewise' as platform,
block_number,
block_timestamp,
tx_hash,
origin_from_address,
event_inputs:value/1e18 as Volume,
event_inputs:value/1e18*usdprice as USD_Volume
from ethereum.core.fact_event_logs t1 join ethprice t2 on t1.block_timestamp::date = t2.date
where origin_to_address = lower('0xC874b064f465bdD6411D45734b56fac750Cda29A')
and origin_function_signature in ('0x4a58db19','0x3a4b66f1','0x040dee8a') -- Deposit , Stake , Stake With Referrer on Behalf
--and tx_hash = '0xe19adffef2cb5a7418a86318260959fcfd3b7ccddf7e3c563c8e5b1ef7bbd19c'
),
stkr as (
select 'stkr' as platform,
block_number,
block_timestamp,
tx_hash,
origin_from_address,
event_inputs:value/1e18 as Volume,
event_inputs:value/1e18*usdprice as USD_Volume
from ethereum.core.fact_event_logs t1 join ethprice t2 on t1.block_timestamp::date = t2.date
where origin_to_address = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
and origin_function_signature in ('0x9fa65c56','0xeb834a2c') -- Stake and Claim Aeth C , Stake and Claim Aeth B
and event_inputs:from = lower('0x84db6eE82b7Cf3b47E8F19270abdE5718B936670')
--and tx_hash = '0x4c5094f611c6b7a074374ef9fdfd063673124e7869cdf6f974f4d67d975c09b5'
),
Cream as (
select 'Cream' as platform,
block_number,
block_timestamp,
tx_hash,
origin_from_address,
event_inputs:value/1e18 as Volume,
Run a query to Download Data