NuveveCryptoArchivedTerra Cumulative NFT Projects Over Time
    Updated 2023-03-15
    with new_nfts as (
    select
    min(block_timestamp) as timestamp,
    contract_address
    from terra.core.fact_nft_mints
    group by contract_address
    ),

    weekly as (
    select
    date_trunc('week', timestamp) as week,
    count(contract_address) as nfts
    from new_nfts
    group by week
    )

    select
    week,
    sum(nfts) over(order by week) as nfts
    from weekly
    order by week asc
    Run a query to Download Data