KaskoazulSCATTER VOL VS TXS
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select block_timestamp::date as fecha,
marketplace,
count(tx_id) as txs,
sum(sales_amount) as volume,
count(distinct purchaser) as daily_unique_buyers
from solana.core.fact_nft_sales
where marketplace in ('hadeswap', 'coral cube', 'hyperspace')
and block_timestamp >= '2022-10-01' and block_timestamp < CURRENT_DATE
and succeeded = True
group by 1,2
order by 1 desc
Run a query to Download Data