select *

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

),

tokens_supply as (

select *

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

),

tokens_liquidity as (

select *

from $query('52cdbf9a-9d77-4d72-a024-033253e91d6d')

),

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-02-08'

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-02-08'),

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