Updated 2022-10-06


    SELECT BLOCK_TIMESTAMP::date as daily , A.PLATFORM_NAME , count(tx_hash) as number ,
    sum(PRICE_USD) as volume
    from ethereum.core.ez_nft_sales A
    where BLOCK_TIMESTAMP > '2022-07-01'

    and CURRENCY_SYMBOL ilike '%ETH%'
    and ( A.PLATFORM_NAME = 'x2y2' or A.PLATFORM_NAME = 'looksrare' or A.PLATFORM_NAME = 'opensea' )
    and PLATFORM_FEE_USD > 0
    GROUP by 1 , 2

    Run a query to Download Data