Ariolayerzero2
Updated 2023-08-16
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 tx_hashes as (
select
*
from
polygon.core.fact_traces
where
1 = 1
--and tx_hash = '0x0069936498eb7fec69a5d4fb83ab27d1382675c8fb39a9f031747223b42d1886'
and to_address = '0x3c2269811836af69497e5f486a85d7316753cf62'
and BLOCK_TIMESTAMP >= current_date - 30
and TX_STATUS = 'SUCCESS'
and TYPE = 'STATICCALL'
limit 1
)
select * from polygon.core.ez_token_transfers
where tx_hash in (select tx_hash from tx_hashes)
*/
/* select
a.*
c.decoded_log:dstChainId as chain_id
from polygon.core.fact_traces a join (
select
*
from
polygon.core.fact_traces
where
1 = 1
and to_address = '0x3c2269811836af69497e5f486a85d7316753cf62'
and BLOCK_TIMESTAMP >= current_date - 30
and TX_STATUS = 'SUCCESS'
and TYPE = 'STATICCALL'
) b on a.tx_hash = b.tx_hash
join polygon.core.ez_decoded_event_logs c on a.tx_hash = c.tx_hash
where a.IDENTIFIER = 'CALL_ORIGIN'
Run a query to Download Data