Updated 2022-10-06


    SELECT BLOCK_TIMESTAMP::date as daily , A.PLATFORM_NAME , 100*sum(CREATOR_FEE_USD)/sum(PRICE_USD) as CREATOR_percent,
    100*sum(PLATFORM_FEE_USD)/sum(PRICE_USD) as platform_percent , COUNT(DISTINCT BUYER_ADDRESS) as buyer , count(DISTINCT SELLER_ADDRESS) as seller
    from ethereum.core.ez_nft_sales A
    where BLOCK_TIMESTAMP >= CURRENT_DATE - 100

    and CURRENCY_SYMBOL ilike '%ETH%'
    and ( A.PLATFORM_NAME = 'x2y2' or A.PLATFORM_NAME = 'looksrare' or A.PLATFORM_NAME = 'opensea' )

    GROUP by 1 , 2

    Run a query to Download Data