binhachonLido vs. The Field
Updated 2022-04-05
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 staking_transaction as (
select
block_timestamp,
'Lido' as service,
from_address,
amount
from ethereum.udm_events
where 1 = 1 --tx_id = '0x77982683bd7834dd6b92226d590d59d4e2f392e3bc4914487fd524a76e7e1cef'
and origin_function_signature = '0xa1903eab'
and symbol = 'ETH'
-- ),
-- stakewise_staking_transaction as (
union all
select
block_timestamp,
'StakeWise' as service,
from_address,
amount
from ethereum.udm_events
where 1 = 1 --tx_id = '0x77982683bd7834dd6b92226d590d59d4e2f392e3bc4914487fd524a76e7e1cef'
and origin_function_signature in ('0x9cc776f5', '0x3a4b66f1')
and symbol = 'ETH'
-- ),
-- rocketpool_staking_transaction as (
union all
select
block_timestamp,
'RocketPool' as service,
from_address,
amount
from ethereum.udm_events
where 1 = 1 --tx_id = '0x77982683bd7834dd6b92226d590d59d4e2f392e3bc4914487fd524a76e7e1cef'
and origin_function_signature = '0xd0e30db0'
and symbol = 'ETH'
and to_address = '0x3bdc69c4e5e13e52a65f5583c23efb9636b469d6'
),
Run a query to Download Data