chainrunner_Deans list learn (NFT Sales)
Updated 2023-11-30
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
›
⌄
with table1 as (
select DISTINCT address
from solana.core.dim_labels
where address_name = 'claynosaurz'
)
SELECT
marketplace,
CASE
when sales_amount <= 30 then 'a/ Below 30 SOL'
when sales_amount between 30 and 35 then 'b/ 30 - 35 SOL'
when sales_amount between 35 and 40 then 'b/ 35 - 40 SOL'
when sales_amount >= 40 then 'c/ Over 40 SOL'
end as sale_group,
count(*) as sales,
sum(sales_amount) as sales_volume
FROM solana.nft.fact_nft_sales
WHERE SUCCEEDED = TRUE
and mint in (SELECT address from table1)
AND block_timestamp > current_date - 30
--AND marketplace = 'tensorswap'
GROUP by sale_group, marketplace
Run a query to Download Data