B09Time Series Analysis of Fees
Updated 2024-05-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
WITH FeesOverTime AS (
SELECT
DATE(BLOCK_TIMESTAMP) AS SaleDate,
SUM(PLATFORM_FEE_USD) AS TotalPlatformFees,
SUM(CREATOR_FEE_USD) AS TotalCreatorFees,
SUM(TX_FEE_USD) AS TotalTransactionFees
FROM ethereum.nft.ez_nft_sales
WHERE
nft_address = lower('0x4cd0ea8b1bdb5ab9249d96ccf3d8a0d3ada2bc76')
GROUP BY DATE(BLOCK_TIMESTAMP)
)
SELECT
SaleDate,
TotalPlatformFees,
TotalCreatorFees,
TotalTransactionFees
FROM FeesOverTime
ORDER BY SaleDate;
QueryRunArchived: QueryRun has been archived