SleepyReviewers stats
Updated 2023-06-30Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- 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