with markets as

select

block_number,

block_timestamp,

tx_hash,

concat('0x',right(topics[1],40)) as market_address,

origin_from_address as market_creator

from

polygon.core.fact_event_logs

where block_timestamp::Date > '2023-01-30'::Date

and contract_address = lower('0x57bd82488017e1b32b3bed03389fbcb6d69750b8')

-- and tx_hash = lower('0x51030191c67a77e824750fa649875fdddd6d925fb0b39840a54e433ebfefc4de')

QUALIFY RANK() OVER (PARTITION BY tx_hash ORDER BY event_index desc) = 1

order by 1 desc

select

case

when ORIGIN_FUNCTION_SIGNATURE = '0xd2ef575e'

then 'signal'

when ORIGIN_FUNCTION_SIGNATURE = '0x269dde89'

then 'provide'

when ORIGIN_FUNCTION_SIGNATURE = '0x8ddad6ac'

then 'review'

when ORIGIN_FUNCTION_SIGNATURE = '0xdaa0aae9'

then 'signalReview'

when ORIGIN_FUNCTION_SIGNATURE = '0x5ea2be72'

then 'submitRequest'

-- when ORIGIN_FUNCTION_SIGNATURE = '0xd2ef575e'

-- then 'signal'

-- when ORIGIN_FUNCTION_SIGNATURE = '0x269dde89'

-- then 'provide'

-- when ORIGIN_FUNCTION_SIGNATURE = '0x8ddad6ac'

-- then 'review'

-- when ORIGIN_FUNCTION_SIGNATURE = '0xdaa0aae9'