strawbettyALGO Daily Volume from Wallets to CEX
    Updated 2022-03-18
    SELECT date_trunc('day', block_timestamp) as date,
    count(DISTINCT tx_id) as n_txs,
    sum(amount) as amount,
    CASE WHEN (date>= '2022-02-10' and date<= '2022-02-17') then 'the week following announcement'
    else 'other days' end as specific_days

    FROM algorand.payment_transaction
    WHERE receiver in (SELECT address
    FROM algorand.labels
    WHERE label_type = 'cex')
    AND asset_id = 0
    AND date between '2022-01-15' and '2022-03-15'
    group by date

    Run a query to Download Data