flipside

    Copy of Copy of Copy of Copy of Copy of gnosis - daily swapping activity
    LittlerDataCopy of Copy of Copy of Copy of Copy of gnosis - daily swapping activity
    Updated 2022-07-31
    with tx_per_second as (
    select
    date_trunc('day',block_timestamp) as day,
    sum(tx_count)/86400 as tx_per_second
    from gnosis.core.fact_blocks
    group by 1)

    select
    avg(tx_per_second)
    from tx_per_second


    Run a query to Download Data