winnie-fstop_nfts_num_sales copy
Updated 2023-04-14
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
›
⌄
-- forked from LTirrell / top_nfts_num_sales @ https://flipsidecrypto.xyz/LTirrell/q/2023-03-21-07-46-pm-jwSt8A
select
case
when contains(project_name, 'wrapped ') then split_part(project_name, 'wrapped ', 2)
else project_name
end as "Collection",
ANY_VALUE(nft_address) as "NFT Address",
count(distinct tx_hash) as "Number of Sales",
sum(ifnull(price_usd, 0)) as "Total Sales ($)"
from
ethereum.core.ez_nft_sales
where
block_timestamp::date >= '2022-10-19' -- blur launch
and project_name is not NULL
or project_name != ''
group by
project_name
order by
"Number of Sales" desc,
"Total Sales ($)" desc
limit
15
Run a query to Download Data