adambalanoun140
Updated 2022-10-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
with eth as
(select
BLOCK_TIMESTAMP ::date as date ,
CREATOR_FEE ,
PRICE ,
PLATFORM_NAME
from
ethereum.core.ez_nft_sales where CURRENCY_ADDRESS='ETH' and EVENT_TYPE='sale' and
lower(NFT_ADDRESS)=lower('0x9c8ff314c9bc7f6e59a9d9225fb22946427edc03')
)
, ethh as (select
date ,
sum(CREATOR_FEE) as CREATOR_FEEs ,
sum(PRICE) as PRICEs ,PLATFORM_NAME
from eth group by 1,PLATFORM_NAME)
select date , (CREATOR_FEEs/PRICEs) *100 as "creator fee %" ,PLATFORM_NAME
from ethh
Run a query to Download Data