nitsNew Users on Ethereum
    Updated 2022-05-01
    SELECT date(first_use) as day, count(DISTINCT event_from ) as new_joiners ,sum(new_joiners) over (order by day) as cumulative_new_joiners
    from ( SELECT event_from, min(block_timestamp) as first_use
    from ethereum.nft_events
    where (event_type = 'mint' or event_type = 'sale')
    GROUP by 1 )
    where day >= '2022-01-01'
    GROUP by 1
    limit 150
    Run a query to Download Data