flipside

    Bridge Analysis- num bridges over time
    saeedmznBridge Analysis- num bridges over time
    Updated 2022-07-01
    select
    BLOCK_TIMESTAMP::date as date ,
    -- BLOCKCHAIN,
    count (DISTINCT tx_id) as num_bridges,
    sum (num_bridges) over ( order by date) as cum_bridges
    from flow.core.fact_bridge_transactions
    group by 1
    Run a query to Download Data