sashimiboiCats Project NFT sales
Updated 2022-09-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) as DATE
,EVENT_TYPE
,AVG(PRICE) AS avg_price_eth
,AVG(PRICE_USD) AS avg_price_usd
,SUM(TOTAL_FEES_USD) AS TOTAL_FEES_USD
,SUM(PLATFORM_FEE_USD) AS TOTAL_PLATFORM_FEE_USD
,SUM(CREATOR_FEE_USD) AS TOTAL_CREATOR_FEE_USD
,SUM(TX_FEE_USD) AS TOTAL_TX_FEE_USD
FROM ethereum.core.ez_nft_sales
WHERE NFT_ADDRESS = '0x78d67f130e80aaa0aad5d786585d36b130fd45dc'
GROUP BY 1,2
Run a query to Download Data