thea[Blur Mega] Marketplace Comparison - Total
    Updated 2023-04-13
    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