Flow AmbassadorsIncrement Fi Points Stats by wallet
Updated 2024-12-10
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 totals as (
select
distinct event_data:userAddr as account,
sum(event_data:amount) as points_claimed,
0 as points_minted
from
flow.core.fact_events
where
block_timestamp > '2024-03-01'
and event_contract = 'A.2093c0861ff1bd80.IncrementPoints'
and event_type = 'ClaimSnapshotPoints'
group by
1,
3
union
select
distinct event_data:userAddr as account,
0 as points_claimed,
sum(event_data:amount) as points_minted
from
flow.core.fact_events
where
block_timestamp > '2024-03-01'
and event_contract = 'A.2093c0861ff1bd80.IncrementPoints'
and event_type = 'PointsMinted'
group by
1,
2
order by
2 desc
)
select
distinct account as "Account",
sum(points_claimed) as "Points Claimed",
sum(points_minted) as "Points Minted"
from
QueryRunArchived: QueryRun has been archived