PapasotAlgo withdrawals from centralised exchanges
    Updated 2023-01-03
    with cex_labels as (
    Select address, label_subtype, label
    from algorand.labels
    where label_type = 'cex'
    -- AND label NOT LIKE 'group%'
    )
    select block_timestamp::date as day,
    label as exchange,
    count(DISTINCT tx_id) as transactions,
    count(distinct receiver) as receivers,
    sum(amount) as amount
    from algorand.payment_transaction t inner join cex_labels l on t.sender = l.address
    where block_timestamp::date >= '2022-04-25'
    group by day, exchange
    order by receivers desc
    Run a query to Download Data