flipside

    Untitled Query
    superflyUntitled Query
    select date_trunc('day', block_time),
    count(*) as Transactions,
    AVG(count(*))
    OVER(ORDER BY date_trunc('day', block_time) ROWS BETWEEN 7 PRECEDING AND CURRENT ROW)
    AS avg_transactions

    from optimism.core.fact_transactions
    where success=true
    group by date_trunc('day', block_time)
    Run a query to Download Data