CartanGroupBraindrops Stats
Updated 2023-04-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
platform_name,
count(distinct(tx_hash)) AS "Total Sales",
sum(PRICE) as "Total Volume",
-- sum(price)/count(distinct(tx_hash)) as "Avg Price",
(sum(creator_fee)) as "Total Royalties Paid",
sum(CREATOR_FEE)/sum(PRICE) *100 AS "Effective Royalty Rate"
-- count(case when sum(CREATOR_FEE)/sum(PRICE) > 0.025 then (tx_hash) end)/ count(tx_hash) as "% Sales PAYING Royalties"
from ethereum.core.ez_nft_sales a
where currency_symbol in ('ETH','WETH')
--and platform_name in ('blur','opensea')
and nft_address = '0xdfde78d2baec499fe18f2be74b6c287eed9511d7'
--and block_timestamp > '2023-01-01'
group by 1
order by 3 desc
Run a query to Download Data