mehrancrypto-dxoepqQ66-8
Updated 2022-10-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT BLOCK_TIMESTAMP::date as daily , A.PLATFORM_NAME , 100*sum(CREATOR_FEE_USD)/sum(PRICE_USD) as CREATOR_percent,
100*sum(PLATFORM_FEE_USD)/sum(PRICE_USD) as platform_percent , COUNT(DISTINCT BUYER_ADDRESS) as buyer , count(DISTINCT SELLER_ADDRESS) as seller
from ethereum.core.ez_nft_sales A
where BLOCK_TIMESTAMP >= CURRENT_DATE - 100
and CURRENCY_SYMBOL ilike '%ETH%'
and ( A.PLATFORM_NAME = 'x2y2' or A.PLATFORM_NAME = 'looksrare' or A.PLATFORM_NAME = 'opensea' )
GROUP by 1 , 2
Run a query to Download Data