Delamir-6014WC08 purchase
    Updated 2022-11-22
    with list as (
    select
    date(block_timestamp) as date,
    buyer_address,
    count (distinct tx_hash) as Number_Purchase,
    count (distinct tokenid) as Number_NFTS,
    avg (price_usd) as avg_purchase_Volume,
    min (price_usd) as min_purchase_Volume,
    max (price_usd) as max_purchase_Volume ,
    sum (price_usd) as Total_Purchase_Volume
    from ethereum.core.ez_nft_sales
    where NFT_ADDRESS = lower('0x629A673A8242c2AC4B7B8C5D8735fbeac21A6205')
    and PROJECT_NAME = 'sorare'
    and PLATFORM_NAME = 'opensea'
    group by 1,2
    order by 1
    )
    select
    'Sorare Footnal Market' as market,
    sum (Number_Purchase) as Num_purchase,
    sum(Number_NFTS) as num_NFTs,
    avg(avg_purchase_Volume) as avg_purchase_vol,
    min(min_purchase_Volume) as min_purchase_vol,
    max(max_purchase_Volume) as max_purchase_vol,
    sum(Total_Purchase_Volume) as total_purchase_vol
    from list
    group by 1


    Run a query to Download Data