MLDZMNcom6
Updated 2023-04-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select
s.BLOCK_TIMESTAMP::date as date,
case
when s.BLOCK_TIMESTAMP>='2023-04-06' then 'after announcement'
else 'before announcement' end as time_period,
count(distinct s.tx_id) as no_mint,
count(distinct PURCHASER) as no_minter,
count(distinct MINT) as no_NFTs,
sum(MINT_PRICE) as volume,
avg(MINT_PRICE)as average_volume,
Median(MINT_PRICE) as median_volume,
volume/count(distinct date_trunc(day, s.block_timestamp)) as average_volume_day,
no_NFTs/count(distinct date_trunc(day, s.block_timestamp)) as average_mint_day,
avg(fee/1e9) as avg_fee,
sum(fee/1e9) as total_fee
from solana.core.fact_nft_mints s
left join solana.core.fact_transactions a on s.tx_id=a.tx_id
where s.BLOCK_TIMESTAMP>='2023-03-15'
and s.SUCCEEDED='TRUE'
and MINT_PRICE > 0
and MINT_CURRENCY='So11111111111111111111111111111111111111111'
group by 1,2
Run a query to Download Data