Diamond$LOPPY Holders In / Out
Updated 2023-06-09
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 adriaparcerisas / sloppy holders flows @ https://flipsidecrypto.xyz/adriaparcerisas/q/2023-06-08-11-08-am-_pkBO7
--transfers flows
with
ins as (
select
trunc(block_timestamp,'day') as date,
event_data:to as wallet,
sum(event_data:amount) as volume_in
from flow.core.fact_events
where event_contract='A.53f389d96fb4ce5e.SloppyStakes'
and event_type='TokensDeposited'
group by 1,2
),
outs as (
select
trunc(block_timestamp,'day') as date,
event_data:from as wallet,
sum(event_data:amount) as volume_out
from flow.core.fact_events
where event_contract='A.53f389d96fb4ce5e.SloppyStakes'
and event_type='TokensWithdrawn'
group by 1,2
),
transfer_flow as (
SELECT
ifnull(x.date,y.date) as dates,
ifnull(x.wallet,y.wallet) as traders,
ifnull(volume_in,0) as volume_deposited,
sum(volume_deposited) over (partition by traders order by dates) as total_volume_in,
ifnull(volume_out,0) as volume_withdrawn,
sum(volume_withdrawn) over (partition by traders order by dates) as total_volume_out
from ins x left join outs y on x.date=y.date and x.wallet=y.wallet
),
final as (
SELECT
Run a query to Download Data