select

tx_hash as market_creation_tx,

block_number as market_creation_block,

origin_from_address as market_creator_address,

concat('0x', substring(data, 27, 40)) as market_address

from

avalanche.core.fact_event_logs

where

contract_address = lower('0x501ee2D4AA611C906F785e10cC868e145183FCE4')

and topics [0] = '0x7ee9fce77e7f00a078e57aa58ede501b9053c2fa51ef8e74a14e0af35c91dc68'

),

all_swaps as (

select

tx_hash,

block_number as swap_block,

origin_from_address as swap_origin_address,

contract_address as market_address

from

avalanche.core.fact_event_logs

where

contract_address in (

select

market_address

from

all_markets

)

and topics [0] = '0x51713e7418434a85621a281e8194f99f7ed2ac1375ced97d89fd54e8f774323f'

),

first_swaps as (

select

s.market_address,

s.swap_block,

s.swap_origin_address,

s.tx_hash,

row_number() over (