Ariolayerzero1
Updated 2023-08-13
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_ADDRESS,
tx_hash
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'
),
transfer as (
select
BLOCK_TIMESTAMP,
tx_hash,
SYMBOL,
AMOUNT_USD
from
polygon.core.ez_token_transfers
where tx_hash in (select tx_hash from tx_hashes)
and AMOUNT_USD is not null
and to_address not in ('0x0000000000000000000000000000000000000000', '0x0c1ebbb61374da1a8c57cb6681bf27178360d36f')
--and FROM_ADDRESS in (select FROM_ADDRESS from tx_hashes)
union all
select
BLOCK_TIMESTAMP,
tx_hash,
'MATIC' as SYMBOL,
AMOUNT_USD
from
polygon.core.ez_matic_transfers
Run a query to Download Data