DiamondTables Information (Sloppy)
999
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
amount_in as (
select
date(block_timestamp) as date,
event_data:to as user,
event_data:amount as amount_in
from
flow.core.fact_events
where
event_type = 'TokensDeposited'
and event_contract = 'A.53f389d96fb4ce5e.SloppyStakes'
and tx_succeeded = 'TRUE'
),
amount_out as (
select
date(block_timestamp) as date,
event_data:
from
as user,
event_data:amount as amount_out
from
flow.core.fact_events
where
event_type = 'TokensWithdrawn'
and event_contract = 'A.53f389d96fb4ce5e.SloppyStakes'
and tx_succeeded = 'TRUE'
),
amount_in_total as (
select
date,
user,
sum(amount_in) as total_n,
sum(total_n) over (
partition by
user
order by
Run a query to Download Data