KaskoazulTaiyo Robotics - Solport vs Magic Eden
Updated 2022-04-04
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select block_timestamp::date as fecha,
marketplace,
sum(sales_amount) as daily_sales,
sum(daily_sales) over (partition by marketplace order by fecha) as cum_sales,
count(distinct purchaser) as u_buyers,
sum(u_buyers) over (partition by marketplace order by fecha) as cum_buyers
from solana.dim_nft_metadata nm
inner join solana.fact_nft_sales ns
on ns.mint = nm.mint
where project_name = 'Taiyo Robotics'
and succeeded = 'TRUE'
and program_id in ('SPf5WqNywtPrRXSU5enq5z9bPPhREaSYf2LhN5fUxcj', 'M2mx93ekt1fmXSVkTrUL9xVFHkmME8HTUi5Cyc5aF7K')
and fecha >= '2022-03-22'
and fecha < CURRENT_DATE - 1
group by 1,2
order by 1
Run a query to Download Data