crypto_edgar2023-12-21 11:25 AM
Updated 2023-12-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
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