flipside

    Bridge Analysis 11
    SajjadiiiBridge Analysis 11
    Updated 2022-07-04
    select SPLIT_PART(SWAP_CONTRACT, '.', 3) as SWAP_name , SPLIT_PART(TOKEN_OUT_CONTRACT, '.', 3) as token_out ,SPLIT_PART(TOKEN_IN_CONTRACT, '.', 3) as token_in , count(distinct tx_id)as n_tx
    from flow.core.fact_swaps
    where TX_ID in (select TX_ID
    from flow.core.fact_transactions
    where PROPOSER in (select distinct FLOW_WALLET_ADDRESS
    from flow.core.fact_bridge_transactions
    where DIRECTION = 'inbound'))
    group by 1,2,3
    order by 4 desc
    limit 50
    Run a query to Download Data