flipside

    Arbitrum open Analyzing - borrow repay 2
    MoeArbitrum open Analyzing - borrow repay 2
    Updated 2022-09-06
    select

    count (distinct tx_hash) as num_txs,
    count(ORIGIN_FROM_ADDRESS) as num_wallets,
    'Borrow' as type
    from optimism.core.fact_event_logs
    where EVENT_NAME ilike 'borrow'
    union all
    select

    count (distinct tx_hash) as num_txs,
    count(ORIGIN_FROM_ADDRESS) as num_wallets,
    'Repay' as type
    from optimism.core.fact_event_logs
    where EVENT_NAME ilike '%Repay%'
    Run a query to Download Data