Updated 2022-10-06


    SELECT BLOCK_TIMESTAMP::date as daily , count(tx_hash) as number , sum(CREATOR_FEE_USD) as CREATOR_FEE_USD , sum(PRICE_USD) as sale_volume_usd ,
    sum(PLATFORM_FEE_USD) as PLATFORM_FEE_USD
    from ethereum.core.ez_nft_sales A
    where BLOCK_TIMESTAMP >= CURRENT_DATE - 100

    and CURRENCY_SYMBOL ilike '%ETH%'
    and A.PLATFORM_NAME = 'opensea'
    GROUP by 1


    Run a query to Download Data