adambalaopensea
    Updated 2022-09-24
    with
    a as (
    select
    BLOCK_TIMESTAMP,
    TX_HASH ,
    SELLER_ADDRESS ,
    BUYER_ADDRESS ,
    NFT_ADDRESS ,
    PROJECT_NAME ,
    TOKENID ,
    CURRENCY_SYMBOL ,
    PRICE ,PRICE_USD
    from ethereum.core.ez_nft_sales
    where EVENT_TYPE='sale' and PLATFORM_name ='opensea' and BLOCK_TIMESTAMP::date > '2022-01-01'
    )

    select
    BLOCK_TIMESTAMP ::date as date ,
    count(distinct TX_HASH) as txs ,
    count(distinct BUYER_ADDRESS) as buyers ,
    count(distinct SELLER_ADDRESS) as sellers ,
    count(distinct TOKENID) as token_id ,
    count(distinct NFT_ADDRESS) as collections ,
    ------------------------------------------
    sum(PRICE) as CURRENCY ,
    sum(PRICE_USD) as USD ,
    ---------------------------------------
    avg(PRICE) as avg_CURRENCY ,
    avg(PRICE_USD) as avg_USD ,

    ---------------------------------------
    SUM(txs) OVER (ORDER BY DATE) AS CUM_txs,
    Run a query to Download Data