freemartianCEX As Sender
    Updated 2022-03-10
    with source as (
    SELECT a.block_timestamp as date, a.sender, a.amount as amounts, b.address, b.label_type from algorand.payment_transaction a
    INNER JOIN algorand.labels b
    ON a.sender = b.address
    WHERE date >= '2022-02-05'
    AND date <= '2022-02-20'
    AND b.label_type = 'cex'
    )

    SELECT date_trunc(day,date) as time, sum(amounts) from aaaaaa
    GROUP by time
    order by time
    Run a query to Download Data