WITH sales as ( SELECT block_timestamp::date as date, tx_hash, buyer_address, price

FROM optimism.core.ez_nft_sales

WHERE platform_name = 'quixotic' and event_type = 'sale' and currency_symbol in ('ETH', 'OP')),

first_txns as ( SELECT buyer_address, min(date) as first_txn

FROM sales

GROUP BY buyer_address)

select first_txn, count(distinct buyer_address) as daily_new_user, sum(daily_new_user) OVER (ORDER BY first_txn ASC) as total_new_users

from first_txns

group by first_txn

order by first_txn desc