flipside

    Daily NFT Transactions
    monadmetrics-JFe1_RDaily NFT Transactions
    Updated 2025-02-27
    SELECT
    DATE_TRUNC('day', block_timestamp) AS day,
    COUNT(tx_hash) AS daily_sales
    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 2 months ago
    DAY
    DAILY_SALES
    1
    		2025-02-27 00:00:00.000264
    2
    		2025-02-26 00:00:00.000154
    3
    		2025-02-25 00:00:00.000207
    4
    		2025-02-24 00:00:00.000762
    5
    		2025-02-23 00:00:00.0003847
    5
    162B
    3s