CryptoIcicleSolana-96.Moving to Earn in the Bear Market - NFT Mints
    Updated 2022-07-13
    -- Payout 2.078 SOL
    -- Grand Prize6.23 SOL
    -- Level Intermediate

    -- Q96. Move to Earn projects have been growing in popularity, especially on Solana after the explosion of StepN.
    -- Projects like Genopets and Stepn both won Solana Hackathon awards and are two of the most popular games in the field.
    -- Each of their own NFT ecosystems and two native tokens ($GMT and $GST for StepN, $GENE and $KI for Genopets).
    -- Compare these two projects in terms of users, token flows, and NFT volume.
    -- How can these tokens stay popular in bear market and build their own resilient gaming economies?

    with nfts as (
    select
    label,
    address
    from solana.core.dim_labels
    where label = 'stepn' or label = 'genopets'
    )

    select
    date_trunc('month',block_timestamp) as date,
    label as type,
    count(distinct tx_id) as n_mints,
    sum(mint_price) as mint_volume
    from solana.core.fact_nft_mints m
    join nfts n on m.mint = n.address
    group by date, type
    Run a query to Download Data