konzy1Monthly Staking Data copy
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
›
⌄
-- forked from hess / Monthly Staking Data @ https://flipsidecrypto.xyz/hess/q/R4E2dd3ZtI6D/monthly-staking-data
with lido_hash as ( select tx_hash
from ethereum.core.fact_event_logs
where contract_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and event_name = 'Transfer' and event_inputs:from = '0x0000000000000000000000000000000000000000')
,
lido as ( select date(block_timestamp) as date, 'Lido' as platform, tx_hash , origin_from_address as address, amount, amount_usd
from ethereum.core.ez_eth_transfers
where origin_to_address = '0xae7ab96520de3a18e5e111b5eaab095312d7fe84'
and origin_from_address = eth_from_address and tx_hash in (select tx_hash from lido_hash))
,
rocket_hash as ( select tx_hash
from ethereum.core.fact_event_logs
where (origin_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' or origin_to_address = lower('0x2cac916b2a963bf162f076c0a8a4a8200bcfbfb4'))
and event_name = 'Transfer' and event_inputs:from = '0x0000000000000000000000000000000000000000')
,
rocket as ( select date(block_timestamp) as date,'RocketPool' as platform, tx_hash , origin_from_address as address, amount, amount_usd
from ethereum.core.ez_eth_transfers
where (origin_to_address = '0x4d05e3d48a938db4b7a9a59a802d5b45011bde58' or origin_to_address = lower('0x2cac916b2a963bf162f076c0a8a4a8200bcfbfb4'))
and origin_from_address = eth_from_address and tx_hash in (select tx_hash from rocket_hash))
,
Stakewise_hash as ( select tx_hash
from ethereum.core.fact_event_logs
where origin_to_address = '0xc874b064f465bdd6411d45734b56fac750cda29a'
and event_name = 'Transfer' and event_inputs:from = '0x0000000000000000000000000000000000000000')
,
Stakewise as ( select date(block_timestamp) as date,'Stakewise' as platform, tx_hash , origin_from_address as address, amount, amount_usd
from ethereum.core.ez_eth_transfers
where origin_to_address = '0xc874b064f465bdd6411d45734b56fac750cda29a'
and origin_from_address = eth_from_address and tx_hash in (select tx_hash from Stakewise_hash))
,
stkr_hash as ( select *
from ethereum.core.fact_event_logs
where origin_to_address = lower('0x84db6ee82b7cf3b47e8f19270abde5718b936670')
and event_name = 'Transfer' and event_inputs:from = '0x0000000000000000000000000000000000000000')
Run a query to Download Data