nsa2000nfts8
    Updated 2023-01-05
    ---credit to Ali3N: https://app.flipsidecrypto.com/dashboard/RH4QME
    with mintable as (
    select nft_address,
    min (date_trunc(month,block_timestamp)) as mindate
    from ethereum.core.ez_nft_sales
    where block_timestamp::date >= '2022-01-01' and block_timestamp::date < '2023-01-01'
    group by 1),

    maxtable as (
    select nft_address,
    max (date_trunc(month,block_timestamp)) as maxdate
    from ethereum.core.ez_nft_sales
    where block_timestamp::date >= '2022-01-01' and block_timestamp::date < '2023-01-01'
    group by 1),

    previous_table as (
    select t1.nft_address,
    coalesce (initcap(project_name),initcap(address_name),initcap(t1.nft_address)) as Project_Title,
    median (price_usd) as Previous_Price
    from ethereum.core.ez_nft_sales t1 left outer join ethereum.core.dim_labels t2 on t1.nft_address = t2.address
    join mintable t3 on t1.nft_address = t3.nft_address
    where price_usd > 0
    and date_trunc(month,block_timestamp) = mindate
    group by 1,2)

    select Project_Title,
    case when project_title = '0x45b5e0a3c6dae8c8170fd78268f807758226b67f' then 'AnifruktNFT (AFT)'
    when project_title = '0x6d1b09ae12adeaa3aa5d6b574dbcfaf7343a0b04' then 'Space Eggs (SPACE EGGS)'
    when project_title = '0x3f427073af2e9a26b0d5897435af9edd8b00efa6' then 'Ethnology (ETL)'
    when project_title = '0xb77bb4bda2e4cfec036f214594e758ac380d0f45' then 'Cool Cats Research Lab (CCLAB)'
    when project_title = '0xf22b1af401ff439728f426190e0b3e7b354ff9fa' then 'Gates Of Oxya - Colony (GoOC)'
    when project_title = '0x4483fcb6c4ba5614b5a3b9a2ebf2410901ebe507' then 'MKSM'
    when project_title = '0x8d25f9f4cd1c42d817e619f334848db47ccc8dca' then 'Tiny Tears (CRY)'
    when project_title = '0xa18cb1cdeb75eda5ad4a0922331723451dbcf5ed' then 'TheSaudisGoblin (TSG)'
    when project_title = '0x7a48e016122b4786e3b96414598fc608c8dc3ad4' then 'Hype Pass (HYPE)'
    when project_title = '0x4a33f4f14989f5841a0807166bc43a7a7ec17c0c' then '0xy Utility Token'
    Run a query to Download Data