DAY | AVG_PRICE | |
---|---|---|
1 | 2025-02-27 00:00:00.000 | 0 |
2 | 2025-02-26 00:00:00.000 | 0 |
3 | 2025-02-25 00:00:00.000 | 0 |
4 | 2025-02-24 00:00:00.000 | 0 |
5 | 2025-02-23 00:00:00.000 | 0.1323 |
monadmetrics-JFe1_RAverage Sale Price
Updated 2025-02-27
9
1
2
3
4
5
6
7
8
9
›
⌄
SELECT
DATE_TRUNC('day', block_timestamp) AS day,
ROUND(AVG(value), 4) AS avg_price
FROM MONAD.testnet.fact_transactions
WHERE to_address = '0x66e40f67afd710386379a6bb24d00308f81c183f'
AND block_timestamp >= '2025-02-19 15:00:00.000'
GROUP BY 1
ORDER BY 1 DESC;
Last run: about 1 month ago
5
156B
1s