with

labor_markets as

select

block_timestamp as created_at,

origin_from_address as creator,

concat('0x',right(topics[1]::string,40)) as address

from

polygon.core.fact_event_logs

where block_timestamp::date > '2023-02-01'::date

and origin_to_address = lower('0x7b8f452916847f1bc04e187ce8a47462da44895c')

and contract_address = lower('0x7b8f452916847f1bc04e187ce8a47462da44895c')

),

market_actions as

select

case

when origin_function_signature = '0x5ea2be72' then 'create_request'

when origin_function_signature = '0x8ddad6ac' then 'review'

when origin_function_signature = '0x36ef3052' then 'create_market'

when origin_function_signature = '0x269dde89' then 'provide'

when origin_function_signature = '0xd2ef575e' then 'signal_provide'

when origin_function_signature = '0xdaa0aae9' then 'signal_review'

when origin_function_signature = '0xddd5e1b2' then 'claim_reward'

else origin_function_signature

end as action_type,

origin_from_address as actor_address,

tx_hash,

topics,

data,

event_index,

_log_id,