saeedmzn$MATIC Staking -
Updated 2022-09-20
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 maintable as (
select 'ETHEREUM' as chain,
origin_from_address,
origin_to_address,
tx_hash
from ethereum.core.fact_event_logs
where tx_status = 'SUCCESS'--and origin_to_address = '0x5089729df58c7f992f3fa6a6f8a51304a814e958'
and event_name ilike '%commit%'
and origin_function_signature in ('0x29762960','0xdc97e082')
union ALL
select 'POLYGON' as chain,
origin_from_address,
origin_to_address,
tx_hash
from polygon.core.fact_event_logs
where tx_status = 'SUCCESS'--and origin_to_address = '0x5089729df58c7f992f3fa6a6f8a51304a814e958'
and event_name ilike '%commit%'
and origin_function_signature in ('0x29762960','0xdc97e082')
union ALL
select 'BINANCE SMART CHAIN' as chain,
origin_from_address,
origin_to_address,
tx_hash
from bsc.core.fact_event_logs
where tx_status = 'SUCCESS'--and origin_to_address = '0x5089729df58c7f992f3fa6a6f8a51304a814e958'
and event_name ilike '%commit%'
and origin_function_signature in ('0x29762960','0xdc97e082')
UNION ALL
select 'ARBITRUM' as chain,
origin_from_address,
Run a query to Download Data