flipside

    Bridge Volume - The number of transactions based on direction
    saeedmznBridge Volume - The number of transactions based on direction
    Updated 2022-07-01
    select
    BLOCK_TIMESTAMP::date as date ,
    DIRECTION,
    count (DISTINCT tx_id) as num_bridges,
    sum (num_bridges) over (partition by DIRECTION order by date) as cum_bridges
    from flow.core.fact_bridge_transactions
    group by 1,2
    Run a query to Download Data