thea[Blur Mega] Marketplace Comparison - Total
Updated 2023-04-13Copy Reference Fork
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
29
30
31
32
33
34
›
⌄
with tx as (
select platform_name,
count(distinct tx_hash) as transaction_counts,
sum(price_usd) as transaction_volumes
from ethereum.core.ez_nft_sales
where block_timestamp > '2022-10-19'
and price_usd is not null
group by 1
),
trader as (
select platform_name,
count(distinct wallets) as traders
from (
select platform_name,
buyer_address as wallets
from ethereum.core.ez_nft_sales
where block_timestamp > '2022-10-19'
and price_usd is not null
union all
select platform_name,
seller_address as wallets
from ethereum.core.ez_nft_sales
where block_timestamp > '2022-10-19'
and price_usd is not null
)
group by 1
)
select tx.platform_name,
tx.transaction_counts / (select sum(transaction_counts) from tx) as trasnsaction_counts_pct,
tx.transaction_volumes / (select sum(transaction_volumes) from tx) as transaction_volumes_pct,
trader.traders / (select sum(traders) from trader) as trader_pct
from tx
left join trader on tx.platform_name = trader.platform_name
Run a query to Download Data