Sbhn_NPDaily FTX/Alameda Stablecoin Inflow and Outflow Volume
    Updated 2022-11-09
    --credit : alik110
    with alamedaftx as (
    select *
    from ethereum.core.dim_labels
    where label ilike '%alameda%' or label ilike 'ftx%' or address_name ilike 'ftx%' or address_name ilike '%alameda%'),
    Inflowt as (
    select block_timestamp::date as Inflow_Date,
    symbol as Symbol_IN,
    sum (amount_usd) as Inflow_Volume
    from ethereum.core.ez_token_transfers
    where to_address in (select distinct address from alamedaftx)
    and from_address not in (select distinct address from alamedaftx)
    and symbol in ('USDC','USDT','TUSD','BUSD','USDP','DAI')
    and block_timestamp > CURRENT_DATE - 30
    group by 1,2),

    Outflowt as (
    select block_timestamp::date as Outflow_Date,
    symbol as Symbol_Out,
    sum (amount_usd) as Outflow_Volume
    from ethereum.core.ez_token_transfers
    where from_address in (select distinct address from alamedaftx)
    and to_address not in (select distinct address from alamedaftx)
    and symbol in ('USDC','USDT','TUSD','BUSD','USDP','DAI')
    and block_timestamp > CURRENT_DATE - 30
    group by 1,2)


    select Inflow_Date,
    symbol_in,
    inflow_volume as Inflow,
    outflow_volume*-1 as Outflow,
    inflow_volume - outflow_volume as Net_Flow,
    sum (Net_Flow) over (partition by symbol_in order by inflow_date) as Cumulative_Net_Flow
    from Inflowt t1 join Outflowt t2 on t1.Inflow_Date = t2.Outflow_Date and t1.Symbol_IN = t2.Symbol_Out
    Run a query to Download Data