Ariolayerzero3
Updated 2023-08-14
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
⌄
with tx_hashes as (
select
*
from
polygon.core.fact_traces
where
1 = 1
and tx_hash = '0xa0b7d1898ca847955ee2efe11a56251be51ab8a5558d990c430ee98ae7783a3f'
--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 * from tx_hashes
Run a query to Download Data