monadmetrics-JFe1_RAverage Sale Price
    Updated 2025-02-27
    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
    DAY
    AVG_PRICE
    1
    2025-02-27 00:00:00.0000
    2
    2025-02-26 00:00:00.0000
    3
    2025-02-25 00:00:00.0000
    4
    2025-02-24 00:00:00.0000
    5
    2025-02-23 00:00:00.0000.1323
    5
    156B
    1s