DATE_TRUNC('day', block_timestamp) AS day,

COUNT(DISTINCT ez_nft_transfers_id) AS nft_mint

FROM avalanche.nft.ez_nft_transfers

WHERE EVENT_TYPE = 'mint'

and block_timestamp >= DATEADD(month, -1, CURRENT_DATE())

GROUP BY day

),

nft_sales AS (

SELECT day,

SUM(nft_sale_usd) AS nft_sale_usd,

SUM(tx) AS tx,

SUM(SUM(nft_sale_usd)) OVER (ORDER BY day) AS cumulative_nft_sales_usd

FROM (SELECT DATE(block_timestamp) AS day,

SUM(price_usd) AS nft_sale_usd,

COUNT(*) AS tx

FROM avalanche.nft.ez_nft_sales

WHERE block_timestamp >= DATEADD(month, -1, CURRENT_DATE())

GROUP BY 1

UNION ALL

SELECT DATE(l.block_timestamp) AS day,

SUM(l.decoded_log:erc20TokenAmount * POW(10, -18) * p.price) AS nft_sale_usd,

COUNT(*) AS tx

FROM avalanche.core.ez_decoded_event_logs l

LEFT JOIN avalanche.price.ez_prices_hourly p

ON DATE_TRUNC('hour', l.block_timestamp) = p.hour

AND p.token_address = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'

WHERE l.contract_address = '0x398baa6ffc99126671ab6be565856105a6118a40'

AND l.event_name = 'ERC721OrderFilled'

AND l.tx_status = 'SUCCESS'

AND l.block_timestamp >= DATEADD(month, -1, CURRENT_DATE())

GROUP BY 1

UNION ALL