SELECT

DATE(block_timestamp) AS mint_date,

COUNT(*) AS minted_nfts

FROM

aptos.nft.ez_nft_mints

GROUP BY

DATE(block_timestamp)

),

nft_sales AS (

SELECT

DATE(block_timestamp) AS sale_date,

COUNT(*) AS sold_nfts,

SUM(total_price) AS total_sales_value -- Replace total_price with the correct column name if necessary

FROM

aptos.nft.ez_nft_sales

GROUP BY

DATE(block_timestamp)

nm.mint_date,

nm.minted_nfts,

COALESCE(ns.sold_nfts, 0) AS sold_nfts,

COALESCE(ns.total_sales_value, 0) AS total_sales_value,

(COALESCE(ns.sold_nfts, 0) * 100.0 / nm.minted_nfts) AS conversion_rate

nft_minting nm

LEFT JOIN

nft_sales ns ON nm.mint_date = ns.sale_date

ORDER BY

nm.mint_date DESC;