adambaladoodless-Sale’s activities
    Updated 2023-04-13
    with eth as
    (select
    PRICE as volume ,
    NFT_ADDRESS ,
    SELLER_ADDRESS as sellers ,
    BUYER_ADDRESS as buyers ,
    TX_HASH as sale_tx ,
    BLOCK_TIMESTAMP ::date as date ,
    TOKENID ,
    PRICE_USD ,
    TOTAL_FEES,
    PLATFORM_FEE ,
    CREATOR_FEE ,
    TOTAL_FEES_USD ,
    PLATFORM_FEE_USD ,
    CREATOR_FEE_USD,
    TX_FEE,
    TX_FEE_USD
    from
    ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and
    lower(NFT_ADDRESS)=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')
    )

    , ethh as (select
    count (distinct TOKENID) as "Number of TOKENID",
    count (distinct sellers) as "seller",
    count (distinct buyers) as "buyer",
    count (distinct sale_tx) as "sale_txs",
    sum(volume) as "volumes" ,
    sum(PRICE_USD) as PRICE_USDs ,
    sum(TOTAL_FEES) as TOTAL_FEESs ,
    sum(PLATFORM_FEE) as PLATFORM_FEEs ,
    sum(CREATOR_FEE) as CREATOR_FEEs ,
    sum(TOTAL_FEES_USD) as TOTAL_FEES_USDs ,
    sum(PLATFORM_FEE_USD) as PLATFORM_FEE_USDs ,
    sum(CREATOR_FEE_USD) as CREATOR_FEE_USDs ,
    Run a query to Download Data