namanasync2024-07-08 01:21 PM
    Updated 2024-07-08


    select count(*) FROM (
    select
    from_address,
    TIMESTAMPDIFF(
    SECONDS,
    LAG(block_timestamp, 1) OVER (
    PARTITION BY from_address
    ORDER BY
    block_timestamp
    ),
    block_timestamp
    ) time_between_txs
    from
    arbitrum.core.fact_transactions
    where
    (
    block_number >= 193371117
    and block_number <= 193375117
    )

    )
    QueryRunArchived: QueryRun has been archived