DAY | DAILY_PLATFORM_FEES | |
|---|---|---|
1 | 2025-01-30 00:00:00.000 | 35.799901125 |
2 | 2025-01-31 00:00:00.000 | 14.85 |
3 | 2025-02-01 00:00:00.000 | 8.611904928 |
4 | 2025-02-02 00:00:00.000 | 12.2358 |
5 | 2025-02-03 00:00:00.000 | 52.12073253 |
6 | 2025-02-04 00:00:00.000 | 7.629885 |
7 | 2025-02-05 00:00:00.000 | 31.4938125 |
victor-sanzcapdetDaily platform fees (USD)
Updated 2025-02-06
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 months ago
7
268B
2s