(

-- ################ SWAP START ################

SELECT

block_number

,block_timestamp

,transaction_hash

,POSITION as pool_tx_index

,pool_log_index

,pool_topics

,pool_data

,proxy_topics

,proxy_data

,proxy_log_index

,'SWAP' as event_type

from

(

SELECT

BLOCK_NUMBER as block_number

,BLOCK_TIMESTAMP as block_timestamp

,TX_HASH as transaction_hash

-- , transaction_index as pool_tx_index

, EVENT_INDEX as pool_log_index

, TOPICS as pool_topics

, DATA as pool_data

, '[]' as proxy_topics

, '' as proxy_data

,null as proxy_log_index

FROM optimism.core.fact_event_logs

WHERE topics[0] in ('0xc42079f94a6350d7e6235f29174924f928cc2ac818eb64fed8004e115fbcca67')

AND date_trunc('day',BLOCK_TIMESTAMP) > '2023-11-15'

AND CONTRACT_ADDRESS =lower('0x36b18618c4131d8564a714fb6b4d2b1edadc0042')

) a

left join

(

SELECT