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