flipside

    [3] Bridge comparison
    Keyrock[3] Bridge comparison
    Updated 2024-02-09
    select
    date_trunc('day', block_timestamp) as day,
    destination_chain,
    sum(amount_usd) as tot_usd
    from
    ethereum.defi.ez_bridge_activity
    WHERE
    TOKEN_SYMBOL != ''
    AND amount_usd > 0
    AND block_timestamp > '{{starting_date}}'
    AND Destination_chain in (
    'near',
    'solana',
    'sui',
    'osmosis',
    'aptos',
    'manta',
    'telos',
    'sei',
    'injective'
    )
    GROUP BY
    destination_chain,
    day
    ORDER BY
    tot_usd DESC
    Last run: over 1 year ago
    DAY
    DESTINATION_CHAIN
    TOT_USD
    1
    		2024-01-31 00:00:00.000solana14412775.62
    2
    		2024-01-11 00:00:00.000sui12481263.82
    3
    		2024-02-01 00:00:00.000sui9646189.08
    4
    		2024-02-07 00:00:00.000sui9039883.8
    5
    		2023-11-08 00:00:00.000sui8783730.91
    6
    		2023-11-06 00:00:00.000sui8678332.67
    7
    		2024-02-02 00:00:00.000sui8308532.83
    8
    		2023-11-25 00:00:00.000sui7998905.89
    9
    		2024-01-29 00:00:00.000sui7899063.61
    10
    		2023-11-13 00:00:00.000sui7772583.35
    11
    		2024-01-25 00:00:00.000osmosis7360723.98
    12
    		2023-12-15 00:00:00.000solana7133825.61
    13
    		2024-01-26 00:00:00.000sui7053717.7
    14
    		2023-12-05 00:00:00.000sui6906252.9
    15
    		2024-01-12 00:00:00.000sui6500493.95
    16
    		2023-11-05 00:00:00.000sui6499914.6
    17
    		2023-12-23 00:00:00.000solana6475362.5
    18
    		2023-10-29 00:00:00.000sui6408497.58
    19
    		2023-12-17 00:00:00.000sui6251138.85
    20
    		2023-12-18 00:00:00.000sui6074767.24
    ...
    777
    34KB
    2s