edition_mints as (

select

block_timestamp,

tx_id,

instruction :accounts[1] as user_address -- Leaf Owner

from solana.core.fact_events

where succeeded

and block_timestamp >= '2023-03-16 17:34:49.000'

and program_id = 'BGUMAp9Gq7iTEuizy4pqaxsTyUCBK68MDfK752saRPUY' -- Bubblegum

and signers[0] = '4WCBsTL4fHpg8qCt1wxoqRzgj2CZepdpmS5NaaoxPUJh'

and signers[1] = 'EevH3LPRexR2431NSF6bCpBbPdQ2ViHbM1p84zujiEUs' -- Collection Authority

and instruction :accounts[8] = 'BNJifGQzycxU4oW27Mu7HjkW9aNSsPL7ZXFWfcHLuLRu' -- Dialect Genesis Mint pack

),

aggregated as (

select

date_trunc('hour',block_timestamp) as date,

count(distinct user_address) as collectors,

sum(collectors) over (order by date) as cumul

from edition_mints

left join solana.core.fact_transactions txs

using(tx_id, block_timestamp)

group by 1

select *