select *

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

),

tokens_supply as (

select *

from $query('d113b02b-ad6c-4fc4-8bfb-df28c696d7da')

),

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, '', ''

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

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)),

polygon_dexs_swaps as (