winnie-fstop_nfts_total_sales copy
Updated 2023-04-24
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
›
⌄
-- forked from LTirrell / top_nfts_total_sales @ https://staging.flipsidecrypto.xyz/LTirrell/q/2023-03-22-02-12-am-8rtJVG
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.nft.ez_nft_sales
where
block_timestamp::date >= '2022-10-19' -- blur launch
and project_name is not NULL
group by
"Collection"
order by
"Total Sales ($)" desc,
"Number of Sales" desc
limit 25
Run a query to Download Data