mansaSOL NFT Collections
Updated 2022-09-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
›
⌄
with tab1 as (
SELECT
contract_name as cn,
SUM(solana.fact_nft_sales.sales_amount)
FROM solana.fact_nft_sales
LEFT OUTER JOIN solana.dim_nft_metadata
ON solana.fact_nft_sales.mint = solana.dim_nft_metadata.mint
WHERE not solana.fact_nft_sales.sales_amount is NULL
AND not contract_name is NULL
and block_timestamp::date >= '2022-08-01'
GROUP by 1
ORDER by 2 DESC
LIMIT 10
)
SELECT
date_trunc('day', block_timestamp),
contract_name as cn,
SUM(solana.fact_nft_sales.sales_amount) as sales_volume,
count(distinct(tx_id)) as sale_count
FROM solana.fact_nft_sales
LEFT OUTER JOIN solana.dim_nft_metadata
ON solana.fact_nft_sales.mint = solana.dim_nft_metadata.mint
WHERE not solana.fact_nft_sales.sales_amount is NULL
AND not contract_name is NULL
AND cn in (SELECT cn from tab1)
AND block_timestamp::date > '2022-08-01'
GROUP by 1,2
Run a query to Download Data