0-MID2023-06-23 05:00 PM
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 act1 as (
with tab1 as (
select ADDRESS
,PROJECT_NAME
from polygon.core.dim_labels
where LABEL_TYPE='dex')
,tab2 as (
select
TX_HASH
,ORIGIN_TO_ADDRESS
from polygon.core.ez_token_transfers
where CONTRACT_ADDRESS in ( lower('0x2791bca1f2de4661ed88a30c99a7a9449aa84174'))
and ORIGIN_FROM_ADDRESS=TO_ADDRESS)
select
TX_HASH
from tab1
left join tab2
on tab1.ADDRESS=tab2.ORIGIN_TO_ADDRESS
),
act2 as (
with tab1 as (
select ADDRESS
,PROJECT_NAME
from polygon.core.dim_labels
where LABEL_TYPE='dex')
,tab2 as (
select
SYMBOL
,TX_HASH
,AMOUNT_USD
,ORIGIN_FROM_ADDRESS
,ORIGIN_TO_ADDRESS
from polygon.core.ez_token_transfers
where ORIGIN_FROM_ADDRESS=FROM_ADDRESS)
select SYMBOL
,TX_HASH
Run a query to Download Data