strawbettyALGO transferred from CEXs to wallets
    Updated 2022-05-13

    with
    cex_address as (
    select distinct address,
    label
    from algorand.labels
    where label_type = 'cex' and label not like '%group%'
    ),
    cex_transfers as (
    select
    block_timestamp,
    tx_id,
    sender,
    receiver,
    amount,
    label as cex
    from algorand.payment_transaction x join cex_address y on (x.sender = y.address and x.receiver != y.address)
    where block_timestamp >= '2022-05-02'
    and block_timestamp <'2022-05-10'
    )

    select
    date_trunc('day', block_timestamp) as day,
    count(tx_id) as transactions,
    count(DISTINCT(receiver)) as wallets,
    sum(amount) as volume
    from cex_transfers
    group by 1
    order by 1 asc
    Run a query to Download Data