a.BLOCK_TIMESTAMP as "Date and Time",

a.TX_HASH as "Transaction Hash",

a.DECODED_LOG:pair as "Pool Address",

a.DECODED_LOG:token0 as "Token0 Address",

b.SYMBOL as "Token0 Symbol",

a.DECODED_LOG:token1 as "Token1 Address",

c.SYMBOL as "Token1 Symbol"

from blast.core.ez_decoded_event_logs a

left join blast.core.dim_contracts b on a.DECODED_LOG:token0 = b.ADDRESS

left join blast.core.dim_contracts c on a.DECODED_LOG:token1 = c.ADDRESS

where a.contract_address = '0x24f5ac9a706de0cf795a8193f6ab3966b14ecfe6'