select

DECODED_LOG:pool as pool_address,

DECODED_LOG:token0 as token0,

DECODED_LOG:token1 as token1

from blast.core.ez_decoded_event_logs

where contract_address = '0x792edade80af5fc680d96a2ed80a44247d2cf6fd'

and EVENT_NAME = 'PoolCreated'

and TX_STATUS = 'SUCCESS')

select

BLOCK_NUMBER,

BLOCK_TIMESTAMP,

TX_HASH,

EVENT_INDEX,

DECODED_LOG:amount0 as amount0,

DECODED_LOG:amount1 as amount1,

token0,

token1,

pool_address

from blast.core.ez_decoded_event_logs

join blast_pools on pool_address = contract_address

where TX_STATUS = 'SUCCESS'

and EVENT_NAME = 'Swap'

order by 1

limit 100