eslamis-darkatNFT solana vs eth 1
Updated 2022-09-24
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
26
27
28
›
⌄
with price as (select date_trunc('day', hour) as dt_price, avg(price) as sol_price
from ethereum.core.fact_hourly_token_prices
where token_address = '0xd31a59c85ae9d8edefec411d448f90841571b89c'
group by dt_price)
select date_trunc('day', s.block_timestamp) as dt, count(distinct purchaser) as num_buyers,
sum(num_buyers) over (order by dt asc) as cumulative_num_buyers,
sum(sales_amount * sol_price) as sales_volume,
sum(sales_volume) over (order by dt asc) as cumulative_sales_volume,
'Solana' as network
from solana.core.fact_nft_sales s
inner join price p on
date_trunc('day', s.block_timestamp) = p.dt_price
where block_timestamp::date >= '2022-01-01'
group by 1
union all
select date_trunc('day', block_timestamp) as dt,
count(distinct buyer_address) as num_buyers ,
sum(num_buyers) over (order by dt asc) as cumulative_num_buyers,
sum(price_usd) as sales_volume,
sum(sales_volume) over (order by dt asc) as cumulative_sales_volume,
'Ethereum' as blockchain
from ethereum.core.ez_nft_sales
where block_timestamp::date >= '2022-01-01'
group by 1
Run a query to Download Data