MadiUntitled Query
    Updated 2022-09-13
    WITH nft_allday AS (
    SELECT
    date_trunc('days', b.block_timestamp) AS date,
    b.NFT_ID as nft_id,
    b.MARKETPLACE as MARKETPLACE,
    b.price as price
    FROM flow.core.dim_allday_metadata a
    LEFT JOIN flow.core.ez_nft_sales b
    ON a.NFT_ID = b.NFT_ID
    )

    SELECT
    date,
    MARKETPLACE,
    ROUND(SUM(PRICE),2) as total_sales_volume
    FROM nft_allday
    GROUP BY date, MARKETPLACE
    ORDER BY total_sales_volume DESC



    Run a query to Download Data