alirsop-06-16dao
    Updated 2022-12-24
    select DATE_TRUNC('Day',BLOCK_TIMESTAMP) as Date, PLATFORM_NAME--,nvl(PROJECT_NAME,NFT_ADDRESS)as PROJECT_NAME,NFT_ADDRESS,EVENT_TYPE,
    ,sum(CREATOR_FEE_USD) as Royalty,sum(PRICE_USD ) as Volume, --,royalty / PRICE * 100 as Royality_Percent
    row_number() over (order by royalty DESC) as Rank,
    count(distinct buyer_address) as unique_Buyer_count,
    count(distinct tx_hash) as sales_count,
    count (distinct seller_address) as unique_Seller_count
    from ethereum.core.ez_nft_sales
    where PLATFORM_NAME in ('opensea','looksrare','rarible','x2y2','blur') and date(BLOCK_TIMESTAMP)>='2022-10-19' and
    date(BLOCK_TIMESTAMP)<CURRENT_DATE
    group by 1,2
    order by date
    Run a query to Download Data