rezarwzThe growth of the total amount of sales of NFTs in OpenSea
    Updated 2022-09-15
    SELECT
    block_timestamp::date as date,'solana' as chain,
    count(tx_id) as daily_sales,
    sum(daily_sales) over (order by date) as total_sales
    from solana.core.fact_nft_sales
    where marketplace='opensea' and succeeded='TRUE'
    GROUP BY 1,2
    union ALL
    SELECT
    block_timestamp::date as date,'ethereum' as chain,
    count(TX_HASH) as daily_sales,
    sum(daily_sales) over (order by date) as total_sales
    from ethereum.core.ez_nft_sales
    where platform_name='opensea' and event_type='sale'
    GROUP BY 1,2
    Run a query to Download Data