nitsNew Users Eth vs Sol
    Updated 2022-06-16
    with mints as
    (SELECT purchaser, min(block_timestamp) as first_use
    from solana.fact_nft_mints
    where succeeded = 'TRUE'
    GROUP by 1 ),
    sales as
    (SELECT purchaser, min(block_timestamp) as first_use
    from solana.fact_nft_sales
    where succeeded = 'TRUE'
    GROUP by 1 ),
    sol as
    (SELECT date(fu) as day, COUNT (DISTINCT purchaser) as new_users, sum(new_users) over (order by day) as cumulative_new_users, 'sol' as type from
    (SELECT purchaser, min(first_use ) as fu from
    (SELECT * from sales
    UNION ALL
    SELECT * from mints )
    GROUP by 1 )
    where fu >= CURRENT_DATE -120
    GROUP by 1 ),
    eth as
    ( SELECT date(first_use) as day, count(DISTINCT event_from ) as new_users ,sum(new_users) over (order by day) as cumulative_new_users, 'eth' as type
    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 >= CURRENT_DATE -120
    GROUP by 1
    )
    SELECT * from sol
    UNION ALL
    SELECT * FROM ETH
    -- limit 150

    Run a query to Download Data