DAY | DAILY_PLATFORM_FEES | |
---|---|---|
1 | 2024-12-31 00:00:00.000 | 110.015388633 |
2 | 2025-01-01 00:00:00.000 | 53.9177535 |
3 | 2025-01-02 00:00:00.000 | 176.2108545 |
4 | 2025-01-03 00:00:00.000 | 46.684305 |
5 | 2025-01-04 00:00:00.000 | 40.97342025 |
6 | 2025-01-05 00:00:00.000 | 69.320424 |
7 | 2025-01-06 00:00:00.000 | 59.009367 |
8 | 2025-01-07 00:00:00.000 | 26.410241898 |
victor-sanzcapdetDaily platform fees (USD)
Updated 3 days ago
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
DATE_TRUNC('day', BLOCK_TIMESTAMP) AS DAY,
SUM(PLATFORM_FEE_USD) AS DAILY_PLATFORM_FEES
FROM
aptos.nft.ez_nft_sales
WHERE
PROJECT_NAME = 'The Loonies'
AND block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)
GROUP BY
DAY
ORDER BY
DAY;
Last run: 3 days ago
8
317B
3s