mansaSnowball Sales
Updated 2022-07-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with general as(
SELECT
*
FROM solana.core.fact_nft_sales a
inner join solana.core.dim_nft_metadata b
on a.mint = b.mint
WHERE b.TOKEN_NAME = 'Pesky Penguins'
)
SELECT
date(general.block_timestamp) as dates,
sum(general.sales_amount) as snowball_sales,
sum(snowball_sales) over (order by dates) as cum_snowball_sales,
count(distinct(general.token_id)) as burnt_NFT,
sum(burnt_NFT) over (order by dates) as cum_burnt_NFT,
snowball_sales/burnt_NFT as average_cost
FROM GENERAL
where purchaser = 'pEsKYABNARLiDFYrjbjHDieD5h6gHrvYf9Vru62NX9k'
and dates >= '2022-02-18'
group by dates
order by dates asc
Run a query to Download Data