adambaladoodles139..
Updated 2023-04-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
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