ErsvanVolume per day in sales of NFD
    Updated 2022-06-23
    SELECT
    DATE_TRUNC('day', block_timestamp) AS DAY,
    SUM(AMOUNT) AS AMOUNT_PER_DAY,
    SUM(AMOUNT)-(SUM(AMOUNT)*.05) AS AMOUNT_PER_DAY_NO_FEE,
    (SUM(AMOUNT)*.05) AS FEE_CHARGED
    FROM flipside_prod_db.algorand.PAYMENT_TRANSACTION
    WHERE TX_GROUP_ID IN (
    (SELECT DISTINCT TX_GROUP_ID FROM flipside_prod_db.algorand.ASSET_TRANSFER_TRANSACTION WHERE ASSET_ID IN (
    SELECT ASSET_ID FROM flipside_prod_db.algorand.asset WHERE ASSET_NAME LIKE '%.algo'
    )AND ASSET_AMOUNT IS NOT NULL)
    )
    GROUP BY DAY
    ORDER BY 1 DESC
    Run a query to Download Data