eslamis-darkatNFT solana vs eth 1
    Updated 2022-09-24
    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