LordkingMARKT..
    Updated 2022-11-09
    -- credit ali(king4)
    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'
    and PRICE >0
    and PRICE_USD >0
    )

    , opensea AS (
    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 ,
    Run a query to Download Data