jackguymdao data 3 copy copy
    Updated 2023-09-27
    -- forked from 2023-05-17 03:05 PM copy @ https://flipsidecrypto.xyz/edit/queries/7815312b-f5fc-492f-9304-af0a76d12bd7

    -- forked from 2023-05-17 03:05 PM @ https://flipsidecrypto.xyz/edit/queries/ecb86e7c-c9cb-422f-83e8-8a49c238d50a

    with tab1 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,
    block_timestamp,
    contract_address,
    case
    when origin_to_address = '0x280b3b748ccc42d5062ce59111fad08594f51d9f' then 'Metrics App Beta Launch'
    when origin_to_address = '0x3e4f7978447e354e832d38363e927231e518e33a' then 'MetricsDAO Marketplace'
    when origin_to_address = '0xadfd6e51b1a8a4f6cd5bb2e1c33b08cbaf47b1e8' then 'SkillForge'
    when origin_to_address = '0xacbf13fd19f35c2032d3030619318f5b595cc7d8' then 'Pine Analytics Marketplace'
    when origin_to_address = '0x3eeac7cf0526e4c26f9cd400fbea852715381709' then 'Flash Challenges Marketplace'
    else 'other'
    end as marketplace
    from
    polygon.core.fact_event_logs
    where block_timestamp::date > '2023-02-01'::date
    and contract_address in
    Run a query to Download Data