flipside

    flow average speed
    arctic-night-foxflow average speed
    Updated 2022-07-21
    with flow as (
    select
    date_trunc('day', block_timestamp) as daily,
    COUNT(tx_id) as flow_count
    from flow.core.fact_transactions
    WHERE daily::DATE >= CURRENT_DATE - 90
    group by 1)

    select
    (SUM(flow_count) / COUNT(daily)) / (24*60)
    from flow
    Run a query to Download Data