LittlerDataMDAO labor marketplace reviewers
Updated 2023-06-11
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
›
⌄
⌄
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')
),
reviewers as (
select
concat('0x',substr(topics[1], 27, 40)) reviewer
from polygon.core.fact_event_logs
where contract_address in (select address from labor_markets)
and origin_function_signature = '0x8ddad6ac'
and origin_to_address = contract_address
)
select
count (distinct reviewer) Reviewers
from reviewers
--0xb9756e83c99b44d3c2e54b074830da69e0526db3
/*
select
concat('0x',substr(data[0], 27, 40)) pool_token
,ethereum.public.udf_hex_to_int(data[1]) pool_amount
,ethereum.public.udf_hex_to_int(data[2]) deadline_expiration
,ethereum.public.udf_hex_to_int(data[3])submission_deadline_expiration
Run a query to Download Data