strawbettyALGO Volume from CEX to Wallet
    Updated 2022-03-18


    select
    date_trunc('day', block_timestamp) as block_date
    , case when (block_timestamp >= '2022-02-10' and block_timestamp < '2022-02-17') then 'the week after announcement'
    when (block_timestamp >= '2022-01-26' and block_timestamp < '2022-02-10') then '2 Weeks before announcement'
    when (block_timestamp >= '2022-02-17' and block_timestamp < '2022-03-01') then '2 Weeks after the announcement week'
    end as period_label
    , lar.label_type
    , sum(amount) as amount
    from algorand.payment_transaction tx
    join algorand.labels la
    on tx.receiver = la.address
    and la.label_type = 'cex'
    left join algorand.labels lar
    on tx.sender = lar.address
    and lar.label_type != 'cex'
    where
    block_timestamp >= '2022-01-26'
    and block_timestamp < '2022-03-01'
    group by
    1,2,3

    Run a query to Download Data