Hadisehactivity on new collections and old collections
    Updated 2022-06-15
    with mint as ( select min(block_timestamp::date) as mint_date ,mint as new_sol_nft
    from solana.core.fact_nft_mints
    group by 2),
    new_sol_nft as ( select date(block_timestamp) as day , count(DISTINCT(tx_id)) as new_activities, sum(sales_amount) as new_volume
    from solana.core.fact_nft_sales x join mint y on x.mint = y.new_sol_nft
    where mint_date >= '2022-03-01'
    group by 1
    order by 1),
    old_sol_nft as ( select date(block_timestamp) as day_ , count(DISTINCT(tx_id)) as old_activities, sum(sales_amount) as old_volume
    from solana.core.fact_nft_sales x join mint y on x.mint = y.new_sol_nft
    where mint_date < '2022-03-01'
    group by 1
    order by 1)

    select day_ , new_activities , new_volume, old_activities, old_volume
    from old_sol_nft x left join new_sol_nft y on x.day_ = y.day
    where day_ > '2022-01-01'
    order by 1
    Run a query to Download Data