rackhaelCommunity members /analysts
Updated 2023-07-07
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
›
⌄
-- forked from LittlerData / Community members @ https://flipsidecrypto.xyz/LittlerData/q/metrics-dao-community-analists-GcXdRH
-- Ididn't add anything to this query but credits go to the original authors.
-- forked from MetricsDAO Community Analists @ https://flipsidecrypto.xyz/edit/queries/bb8baf3a-cc04-4808-9a34-db867ce62c3a
with submissions as (
select
origin_from_address submitter
,to_number(ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))) challenge_id
,to_number(ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))) submission_id
from polygon.core.fact_event_logs
where origin_function_signature = '0x269dde89'
and block_timestamp > '2023-01-01'
and contract_address in ('0xadfd6e51b1a8a4f6cd5bb2e1c33b08cbaf47b1e8', '0x280b3b748ccc42d5062ce59111fad08594f51d9f'
,'0x3e4f7978447e354e832d38363e927231e518e33a','0xacbf13fd19f35c2032d3030619318f5b595cc7d8'
, '0x3eeac7cf0526e4c26f9cd400fbea852715381709')
),
reviews as (
select
origin_from_address as reviewer
,to_number(ethereum.public.udf_hex_to_int(substr(topics[2], 3, 64))) challenge_id
,to_number(ethereum.public.udf_hex_to_int(substr(topics[3], 3, 64))) submission_id
,to_number(ethereum.public.udf_hex_to_int(substr(data, 3, 64))) score
from polygon.core.fact_event_logs
where contract_address = '0x280b3b748ccc42d5062ce59111fad08594f51d9f'
and origin_function_signature = '0x8ddad6ac'
and origin_to_address = '0x280b3b748ccc42d5062ce59111fad08594f51d9f'
),
submitting as (
select
submitter
,count(distinct challenge_id) Submissions
from submissions
group by 1
Run a query to Download Data