Diamond$LOPPY Holders In / Out
    Updated 2023-06-09
    -- 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