cheeyoung-kekUSDC sol 4
    Updated 2022-10-10
    select
    date_trunc('week', block_timestamp) as date,
    address_name,
    sum(amount) as "total outflow",
    sum("total outflow") over ( order by date ) as cum_outflow
    from solana.core.fact_transfers a
    join solana.core.dim_labels b
    on a.TX_TO = b.address
    where MINT in ('EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v')
    and label_type = 'cex'
    and date >= '2022-01-01'
    group by 1,2
    order by 1 desc
    Run a query to Download Data