PapasotAlgo outflows from CEX
    Updated 2022-03-10
    select
    date_trunc('day',a.block_timestamp) as date,
    sum(amount) as Algos
    from algorand.payment_transaction a
    left join algorand.labels b on b.address = a.sender
    where a.block_timestamp >= '2022-02-07' AND
    a.block_timestamp < '2022-02-21' AND
    a.sender = b.address AND
    label_type = 'cex' AND
    asset_id = 0
    group by date
    order by date
    Run a query to Download Data