eslamis-darkatNFT solana vs eth 7
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
›
⌄
with eth_buyer as (select block_timestamp, nft_address, buyer_address
from ethereum.core.ez_nft_sales
where event_type = 'sale' and price_usd > 0 and block_timestamp::date >= '2022-01-01'),
eth_holding_time as (select datediff(day, a.block_timestamp, b.block_timestamp) as holding_time
from ethereum.core.ez_nft_sales a
inner join eth_buyer b
on a.seller_address = b.buyer_address and a.nft_address = b.nft_address
where a.block_timestamp::date >= '2022-01-01' and holding_time > 0),
sol_buyer as (select block_timestamp, mint, purchaser
from solana.core.fact_nft_sales
where succeeded = 'TRUE' and block_timestamp::date >= '2022-01-01'),
sol_holding_time as (select datediff(day, a.block_timestamp, b.block_timestamp) as holding_time
from solana.core.fact_nft_sales a
inner join sol_buyer b on
a.seller = b.purchaser and a.mint = b.mint
where a.block_timestamp::date >= '2022-01-01' and holding_time > 0)
select avg(holding_time) as avg_holding_time, 'Ethereum' as network
from eth_holding_time
union all
select avg(holding_time) as avg_holding_time, 'Solana' as network
from sol_holding_time
Run a query to Download Data