misaghlbRocketPool Recent Activity - node and regular
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 node 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,
'run node and stake' 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'
and event_inputs:amount::float/1e18 >= 16
GROUP by date
),
stake 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,
'only stake' 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'
and event_inputs:amount::float/1e18 >= 0.01 and event_inputs:amount::float/1e18 < 16
GROUP by date
)
SELECT * from node
UNION
SELECT * from stake
Run a query to Download Data