HosseinSolana vs Ethereum
Updated 2022-09-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
select * from (
select
'Solana' as network,
block_timestamp::date as day,
count(distinct(tx_id)) as mints_num,
sum(mint_price) as mint_volume,
count(distinct PURCHASER) as purchaser_num
from solana.core.fact_nft_mints
where block_timestamp::date >= current_date - interval '{{ months }} month'
and succeeded = 1
group by day
union
select
'Ethereum' as network,
block_timestamp::date as day,
count(distinct(tx_hash)) as mints_num,
sum(mint_price_eth) as mint_volume,
count(distinct (nft_to_address)) as purchaser_num
from ethereum.core.ez_nft_mints
where block_timestamp::date >= current_date - interval '{{ months }} month'
group by day
)
order by day asc
Run a query to Download Data