flipside

    [1] Bridges by destination
    Keyrock[1] Bridges by destination
    Updated 2024-02-09
    -- Stablecoin inflow for each destination chain (USDT and USDC) -> Solana seems to be understated
    select
    destination_chain,
    token_symbol,
    SUM(amount) as tot_bridged,
    sum(amount_usd) as tot_usd
    from
    ethereum.defi.ez_bridge_activity
    WHERE
    TOKEN_SYMBOL != '' -- To avoid weird tokens
    AND len(TOKEN_SYMBOL) < 15 -- To avoid weird tokens
    AND amount_usd > 0
    AND block_timestamp > '{{starting_date}}'
    AND Destination_chain in (
    'near',
    'solana',
    'sui',
    'osmosis',
    'aptos',
    'fantom',
    'telos',
    'sei',
    'injective'
    )
    AND TOKEN_SYMBOL in ('USDC', 'USDT')
    GROUP BY
    destination_chain,
    token_symbol
    ORDER BY
    tot_usd DESC
    Last run: over 1 year ago
    DESTINATION_CHAIN
    TOKEN_SYMBOL
    TOT_BRIDGED
    TOT_USD
    1
    		suiUSDT201510287.641421201471489.26
    2
    		suiUSDC201309192.597309201309437.29
    3
    		solanaUSDC158580709.088506158595941.6
    4
    		osmosisUSDC82659611.28730182665226.9
    5
    		nearUSDC15199147.62842315196221.54
    6
    		aptosUSDC6954180.8172546952574.02
    7
    		solanaUSDT5958229.9057575956265.9
    8
    		fantomUSDC3956197.7505463956006.6
    9
    		aptosUSDT1454853.9418011454860.11
    10
    		osmosisUSDT1210409.7613591210770.32
    11
    		nearUSDT1005612.7701971005751.77
    12
    		injectiveUSDC154084.315032154051.33
    13
    		fantomUSDT55311.72365555307.24
    14
    		telosUSDC31529.80448131498.74
    15
    		injectiveUSDT10934.54156210930.63
    16
    		seiUSDC4886.7640654891.65
    16
    689B
    2s