KaskoazulIt's the Catalina Whale Mixer - history
Updated 2022-05-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select sales.block_timestamp::date as fecha,
sales.marketplace,
count (sales.tx_id) as number_sales,
sum (number_sales) over (order by fecha) as cumulative_sales,
sum (sales.sales_amount) as volume_sales,
sum (volume_sales) over (order by fecha) as cumulative_volume,
count (distinct purchaser) as unique_purchasers
from flipside_prod_db.solana.fact_nft_sales sales
inner join flipside_prod_db.solana.dim_nft_metadata dat
on sales.mint = dat.mint
where dat.project_name = 'Catalina Whale Mixer'
and sales.succeeded = 'TRUE'
group by 1,2
order by 1
Run a query to Download Data