ErsvanAlgo volume per day per program
    Updated 2022-07-07
    SELECT DATE_TRUNC('DAY',BLOCK_TIMESTAMP) AS DAY, SWAP_PROGRAM, SUM(SWAP_FROM_AMOUNT) AS ALGO_VOLUME FROM (
    SELECT BLOCK_TIMESTAMP, TX_GROUP_ID, SWAPPER, SWAP_PROGRAM, split_part(L.ADDRESS_NAME,': ',2) AS DEX_NAME, SWAP_FROM_ASSET_ID, SWAP_FROM_AMOUNT
    FROM flipside_prod_db.algorand.swaps AS S
    JOIN flipside_prod_db.algorand.labels AS L ON S.POOL_ADDRESS = L.ADDRESS
    WHERE
    L.LABEL_TYPE = 'dex'
    AND BLOCK_TIMESTAMP BETWEEN '2022-05-01' AND '2022-06-30'
    AND SWAP_FROM_ASSET_ID = 0
    )
    GROUP BY SWAP_PROGRAM, DAY
    ORDER BY 1 DESC
    Run a query to Download Data