(SELECT * from solana.core.fact_events

where program_id ilike '781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy')

SELECT date(FIRST_order) as day, count(DISTINCT addr) as total_addresses

, sum(total_addresses) over (order by day) as cumulative_addresses

from

(SELECT signers[0] as addr, min(block_timestamp) as first_order from solana.core.fact_transactions

WHERE tx_id in (SELECT tx_id from txs)

and succeeded = 'TRUE'

GROUP by 1)

GROUP by 1

-- limit 10