SleepyReviewers stats
    Updated 2023-06-30
    -- 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

    -- select
    -- count(distinct analyst) unique_analysts,
    -- count(distinct submission_id) total_submits,
    -- count(distinct marketplace) marketplace
    -- from
    --
    select
    count(distinct tx_hash) total_reviews,
    -- ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))::int bounty_id,
    -- ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))::int submission_id,
    count(distinct origin_from_address) reviewers
    from polygon.core.fact_event_logs
    where contract_address in ('0x280b3b748ccc42d5062ce59111fad08594f51d9f',
    '0x3e4f7978447e354e832d38363e927231e518e33a',
    '0xadfd6e51b1a8a4f6cd5bb2e1c33b08cbaf47b1e8',
    '0xacbf13fd19f35c2032d3030619318f5b595cc7d8',
    '0x3eeac7cf0526e4c26f9cd400fbea852715381709')
    and origin_function_signature = '0x8ddad6ac'





    Run a query to Download Data