Pmisha-bmlMdxdeSods.1
Updated 2022-03-28
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
date_trunc('day',block_timestamp) as dt,
count(distinct purchaser) as uniqwl,
sum(sales_amount) as volume_sale,
count(tx_id) as no_transaction
from solana.fact_nft_sales
where dt >= '2022-01-01' and SUCCEEDED='TRUE'
and mint in(select
mint
from solana.dim_nft_metadata where CONTRACT_NAME='DeGods')
group by 1 order by 1
Run a query to Download Data