ciamakciamandVol Algo To Cex
    Updated 2022-04-17
    SELECT
    DATE_TRUNC('day', block_timestamp) AS date,
    label AS exchange_name,
    SUM(amount) AS volume
    FROM algorand.labels
    LEFT JOIN algorand.payment_transaction
    ON address = receiver
    WHERE date >= '2021-01-01'
    AND label_type = 'cex'
    AND label NOT LIKE 'group%'
    GROUP BY label, date
    ORDER BY date
    Run a query to Download Data