with eth as

(select

BLOCK_TIMESTAMP ::date as date ,

CREATOR_FEE ,

from

ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and

( lower(NFT_ADDRESS)=lower('0xb75f09b4340aeb85cd5f2dd87d31751edc11ed39') or

lower(NFT_ADDRESS)=lower('0x8a90CAb2b38dba80c64b7734e58Ee1dB38B8992e')

or lower(NFT_ADDRESS)=lower('0x1a83ea72e0cc8acce8f5f1eea404991e0083a0f3')

or lower(NFT_ADDRESS)=lower('0x466cfcd0525189b573e794f554b8a751279213ac'))

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