WITH events AS (

select

--*

date_trunc('day', block_timestamp::date) as date,

count(distinct (tx_id)) as daily_events,

sum(daily_events) over (order by date) as total_events

FROM solana.core.fact_events

WHERE program_id = 'TESTWCwvEv2idx6eZVQrFFdvEJqGHfVA1soApk2NFKQ'

AND succeeded = 'true'

and block_timestamp > current_date-7 AND block_timestamp < current_date

group by 1

order by 1 desc

),

transactions AS (

select

--*

date_trunc('day', block_timestamp::date) as date,

max(block_timestamp) as last_updated,

count(tx_id) as txs,

sum(txs) over (order by date) as total_txs,

count(distinct signers[0]) as wallets,

count(case when log_messages::string LIKE '%GoToWarp%'

then tx_id end) as daily_warps,

count(case when log_messages::string LIKE '%CreateFleet%'

then tx_id end) as created_fleets,

count(case when log_messages::string LIKE '%DisbandFleet%'

then tx_id end) as disband_fleets,

created_fleets - disband_fleets as new_fleets,

sum(new_fleets) over (order by date) as total_fleets