bachiaurory NFT sales
Updated 2022-07-20Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with aurory_nfts as (select * from solana.core.dim_nft_metadata where project_name = 'Aurory'
and contract_name = 'Aurory' and Token_name = 'Aurory')
select date(block_timestamp) as day,
count (distinct tx_id) as no_of_sales,
count (distinct purchaser) as no_of_buyers,
count (distinct seller) as no_of_sellers,
round(sum(sales_amount),2) as total_volume
from solana.core.fact_nft_sales
where SUCCEEDED = 'TRUE'
and mint in (select mint from aurory_nfts)
AND sales_amount > 0 and sales_amount is not null
group by day
order by day desc
Run a query to Download Data