mehrancrypto-dxoepqUntitled Query
Updated 2022-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
›
⌄
select
date_trunc('day',block_timestamp) as date,
platform_name,
count (distinct tx_hash) as Sales,
count (distinct buyer_address) as Buyers,
count (distinct seller_address) as Sellers,
sum (price_usd) as Sales_Volume,
sum (creator_fee_usd) as Royalty_Fee,
sum (creator_fee_usd) / sum(price_usd) * 100 as Average_Creator_Fee_Ratio,
sum (Royalty_Fee) over (partition by platform_name order by date) as cumulative_royalty_fee
from ethereum.core.ez_nft_sales
where platform_name in ('opensea','looksrare','x2y2','rarible')
and creator_fee_usd >0
and date >= '2022-01-01'
group by 1,2
order by Royalty_Fee desc
Run a query to Download Data