misaghlbRocketPool: User Profile - LIDO vs. RocketPool - mints
Updated 2022-04-23
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
33
34
35
36
›
⌄
with seth as (
SELECT
date(block_timestamp) as date,
sum(event_inputs:amount::float/1e18) as total,
count(DISTINCT tx_hash) as tx_count,
count(DISTINCT event_inputs:sender) as wallets_count,
avg(event_inputs:amount::float/1e18) as avg_deposited,
'stETH' as type
from ethereum_core.fact_event_logs
where date(block_timestamp) BETWEEN CURRENT_DATE - 90 and CURRENT_DATE - 2
-- and tx_hash = '0xb4c976e97d20c44e3478c76b92501d81d1827073028f70b3d01921d55822a8f6' -- sample depost
and contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84' -- stETH
and event_name = 'Submitted'
GROUP by date
),
reth as (
SELECT
date(block_timestamp) as date,
sum(event_inputs:amount::float/1e18) as total,
count(DISTINCT tx_hash) as tx_count,
count(DISTINCT event_inputs:to) as wallets_count,
avg(event_inputs:amount::float/1e18) as avg_deposited,
'rETH' as type
from ethereum_core.fact_event_logs
where date(block_timestamp) BETWEEN CURRENT_DATE - 90 and CURRENT_DATE - 2
-- and tx_hash = '0xc9695d83d2254b3247736deeb7a48abe36fad26a73d9b194df7dd1ba87131d16' -- sample depost
and contract_address = '0xae78736cd615f374d3085123a210448e74fc6393' -- rETH
and event_name = 'TokensMinted'
GROUP by date
)
SELECT * from seth
UNION
SELECT * from reth
Run a query to Download Data