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,

sum(RAW_AMOUNT_PRECISE) as RAW_AMOUNT_PRECISE, sum(AMOUNT) as AMOUNT, sum(AMOUNT_USD) as 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'

group by 1,2,3,4,5,6,7,8,12,13,14,15,16

union all

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

sum(AMOUNT_PRECISE_RAW) as RAW_AMOUNT_PRECISE, sum(AMOUNT) as AMOUNT, sum(AMOUNT_USD) as AMOUNT_USD, '', 'POL', 0, '', 0

from polygon.core.ez_native_transfers

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

group by 1,2,3,4,5,6,7,8,12,13,14,15,16),

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