Updated 2022-10-08
    select
    date_trunc('week',BLOCK_TIMESTAMP) as week,
    count(tx_hash) as no_sale,
    count(distinct BUYER_ADDRESS) as no_buyer,
    sum(price_usd) as volume,
    sum(CREATOR_FEE_USD) as Royalty_fee,
    sum(PLATFORM_FEE_USD) as platform_fees,
    avg(price_usd) as average_volume
    from ethereum.core.ez_nft_sales
    where PLATFORM_NAME='rarible'
    group by 1
    order by 1
    Run a query to Download Data