select *

from $query('75f58bb3-b2cd-4208-85e9-e3d75d901a1c')

),

polygon_txs as (

select BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, CONTRACT_ADDRESS , FROM_ADDRESS, TO_ADDRESS,

RAW_AMOUNT_PRECISE, AMOUNT, AMOUNT_USD, b.*

from polygon.core.ez_token_transfers a

left join tokens_data b

on contract=CONTRACT_ADDRESS

where BLOCK_TIMESTAMP::date>='2025-01-27'

union all

select BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS, '' as CONTRACT_ADDRESS , FROM_ADDRESS, TO_ADDRESS,

AMOUNT_PRECISE_RAW, AMOUNT, AMOUNT_USD, '', 'POL', 0, '', 0

from polygon.core.ez_native_transfers

where BLOCK_TIMESTAMP::date>='2025-01-27'),

polygon_undetected_swaps_raw as

(select a.BLOCK_TIMESTAMP, a.TX_HASH, a.ORIGIN_FUNCTION_SIGNATURE, a.ORIGIN_FROM_ADDRESS, a.ORIGIN_TO_ADDRESS,

b.RAW_AMOUNT_PRECISE as AMOUNT_IN_UNADJ, b.AMOUNT as AMOUNT_IN, b.AMOUNT_USD as AMOUNT_IN_USD,

a.RAW_AMOUNT_PRECISE as AMOUNT_OUT_UNADJ, a.AMOUNT as AMOUNT_OUT, a.AMOUNT_USD as AMOUNT_OUT_USD, 'Other' as PLATFORM,

b.CONTRACT_ADDRESS as TOKEN_IN, a.CONTRACT_ADDRESS as TOKEN_OUT, b.SYMBOL as SYMBOL_IN, a.SYMBOL as SYMBOL_OUT

from polygon_txs a

join polygon_txs b

on a.TX_HASH=b.TX_HASH and a.ORIGIN_FROM_ADDRESS=a.FROM_ADDRESS and a.ORIGIN_FROM_ADDRESS=b.TO_ADDRESS

left join polygon_txs c

on a.TX_HASH=c.TX_HASH and a.ORIGIN_FROM_ADDRESS=a.FROM_ADDRESS and a.ORIGIN_FROM_ADDRESS=c.FROM_ADDRESS and a.symbol!=c.symbol

where TOKEN_OUT!=TOKEN_IN

and (TOKEN_IN in (select contract from tokens_data) or TOKEN_OUT in (select contract from tokens_data))

and a.tx_hash not in (select tx_hash from polygon.defi.ez_dex_swaps)

and c.tx_hash is null),

polygon_dexs_swaps as (

select BLOCK_TIMESTAMP, TX_HASH, ORIGIN_FUNCTION_SIGNATURE, ORIGIN_FROM_ADDRESS, ORIGIN_TO_ADDRESS,

AMOUNT_IN_UNADJ, AMOUNT_IN, AMOUNT_IN_USD, AMOUNT_OUT_UNADJ, AMOUNT_OUT, AMOUNT_OUT_USD, PLATFORM,