SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS "Date",

COUNT(TX_HASH) AS "Minted",

COUNT(DISTINCT NFT_TO_ADDRESS) AS "Wallets"

FROM

base.nft.ez_nft_transfers

WHERE

EVENT_TYPE = 'mint'

AND PROJECT_NAME = 'Bridge to Base'

AND BLOCK_TIMESTAMP >= '2023-08-03'

AND NFT_from_Address='0x0000000000000000000000000000000000000000'

GROUP BY

DATE_TRUNC('day', BLOCK_TIMESTAMP)

"Date",

"Minted",

"Wallets",

SUM("Minted") OVER (ORDER BY "Date" ASC) AS "Total Minted",

SUM("Wallets") OVER (ORDER BY "Date" ASC) AS "Total Wallets"

daily_totals

ORDER BY

"Date" DESC;