majidshiri171monthly tot
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
select 'Solana Network' as lbl , count(*) as number_of_mint
,sum(MINT_PRICE) as mint_amount
,count(distinct PURCHASER) as number_of_buyer
, trunc(block_timestamp, 'MONTH')
from solana.core.fact_nft_mints
where year(BLOCK_TIMESTAMP)=2022
group by trunc(block_timestamp, 'MONTH')
union all
select 'Ethereum Network' as lbl , count(*) as number_of_mint
,sum(MINT_PRICE_ETH)
,count(distinct NFT_TO_ADDRESS) as number_of_buyer
,trunc(block_timestamp, 'MONTH')
from ethereum.core.ez_nft_mints
where year(BLOCK_TIMESTAMP)=2022
group by trunc(block_timestamp, 'MONTH')
Run a query to Download Data