dannerUser Action Totals
Updated 2023-04-22Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select
sum(tx_fee) as gas,
count(distinct tx_hash) as total_actions,
sum(case when origin_function_signature = '0x5ea2be72'
then 1 else 0 end ) as "Requests",
sum(case when origin_function_signature = '0xdaa0aae9'
then 1 else 0 end ) as "Review Signals",
sum(case when origin_function_signature = '0x8ddad6ac'
then 1 else 0 end ) as "Reviews",
sum(case when origin_function_signature = '0xd2ef575e'
then 1 else 0 end ) as "Submission Signals",
sum(case when origin_function_signature = '0x269dde89'
then 1 else 0 end ) as "Submissions",
sum(case when origin_function_signature = '0xddd5e1b2'
then 1 else 0 end ) as "Rewards Claimed",
count(distinct from_address) as "Users"
from
polygon.core.fact_transactions
where block_timestamp::date > '2023-03-21'::date
and to_address = lower('0x280b3b748Ccc42D5062CE59111fAd08594f51d9F')
Run a query to Download Data