Updated 2024-10-01
    SELECT
    block_timestamp,
    tx_id,
    fee/POW(10, 9) AS tx_fee
    FROM
    eclipse.core.fact_transactions
    WHERE
    block_timestamp > CURRENT_TIMESTAMP - INTERVAL '1 day'
    LIMIT
    30

    SELECT
    DISTINCT
    --tx_id,
    block_id,
    --block_hash,
    block_timestamp
    FROM
    eclipse.core.fact_transactions
    WHERE
    block_timestamp > CURRENT_TIMESTAMP - INTERVAL '1 day'
    ORDER
    BY
    block_timestamp
    DESC
    QueryRunArchived: QueryRun has been archived