COUNT(nft_id_real) as "Daily Minted",

SUM(COUNT(nft_id_real)) OVER (ORDER BY date_trunc('day',block_timestamp) ASC) as "Total Minted",

FROM (

select block_number,

block_timestamp,

origin_from_address,

origin_to_address,

topics[1] as sender,

topics[2] as recipient,

topics[3] as nft,

utils.udf_hex_to_int(topics[3]) as nft_id_real,

tx_hash,

event_index

from blast.core.fact_event_logs

where LOWER(contract_address) = LOWER('0xe91a42e3078c6ad358417299e4300683de87f971')

and LOWER(topics[0]) = LOWER('0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef')

and LOWER(topics[1]) = LOWER('0x0000000000000000000000000000000000000000000000000000000000000000')

WHERE block_timestamp IS NOT NULL

GROUP BY 1

ORDER BY 1 DESC