with base as (

select

BLOCK_TIMESTAMP as date,

tx_id,

EVENT_DATA:id as nft_id

from flow.core.fact_events

where event_contract = 'A.e5bf4d436ca23932.BBxBarbiePack'

and EVENT_TYPE = 'Mint'

and TX_SUCCEEDED = 'true'),

base3 as

(select

tx_id,

EVENT_DATA:to as minter

from flow.core.fact_events

where event_contract = 'A.e5bf4d436ca23932.BBxBarbiePack'

and EVENT_TYPE = 'Deposit'

and tx_id in (select distinct tx_id from base))

select

date(date) as "Date",

count(distinct tx_id) as "Daily Mint Transactions",

sum("Daily Mint Transactions") over (order by "Date") as "Cumulative Mint Transactions",

count(distinct nft_id) as "Daily Minted NFTs",

sum("Daily Minted NFTs") over (order by "Date") as "Cumulative Minted NFTs",

("Daily Minted NFTs" * 20) as "Daily Generated USD Volume",

sum("Daily Generated USD Volume") over (order by "Date") as "Cumulative Generated USD Volume",

count(distinct minter) as "Daily Unique Minters",

sum("Daily Unique Minters") over (order by "Date") as "Cumulative Minters"

from base

join base3 using(tx_id)

group by 1

order by 1