adambaladoodles139..
    Updated 2023-04-13
    with eth as
    (select
    BLOCK_TIMESTAMP ::date as date ,
    CREATOR_FEE ,
    CREATOR_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
    date ,
    sum(CREATOR_FEE) as CREATOR_FEEs ,
    sum(CREATOR_FEE_USD) as CREATOR_FEE_USDs ,
    sum(CREATOR_FEEs) over (order by date) as "cum CREATOR FEE ETH" ,
    sum(CREATOR_FEE_USDs) over (order by date) as "cum CREATOR FEE USD"

    from eth group by 1)

    select *
    from ethh order by date asc


    Run a query to Download Data