crypto_edgar2023-12-21 11:25 AM
    Updated 2023-12-21
    with nft_mint_info as (
    select
    MIN(solana.nft.fact_nft_mints.BLOCK_TIMESTAMP) AS FIRST_MINT,
    MAX(solana.nft.fact_nft_mints.BLOCK_TIMESTAMP) AS LAST_MINT,
    solana.nft.dim_nft_metadata.NFT_COLLECTION_NAME,
    solana.nft.dim_nft_metadata.COLLECTION_ID
    from
    solana.nft.fact_nft_mints
    INNER JOIN solana.nft.dim_nft_metadata ON (
    solana.nft.fact_nft_mints.MINT = solana.nft.dim_nft_metadata.MINT
    )
    group by
    solana.nft.dim_nft_metadata.NFT_COLLECTION_NAME,
    solana.nft.dim_nft_metadata.COLLECTION_ID
    )
    select
    *
    from
    nft_mint_info
    ORDER BY
    FIRST_MINT ASC
    QueryRunArchived: QueryRun has been archived