flipside

    2024-02-18 07:22 PM
    SocioAnalytica2024-02-18 07:22 PM
    Updated 2024-02-18

    SELECT 'satellite' as platform,
    CASE when destination_chain in ('optimism','arbitrum','linea','ethereum','polygon','scroll','filecoin', 'avalanche',
    'fantom','binance','base') then 'evn'
    else 'else' end as chain_type,
    destination_chain,
    date_trunc('d',block_timestamp) as date,
    count (DISTINCT tx_hash) as n_bridge,
    sum(amount) as volume
    FROM axelar.defi.ez_bridge_satellite
    WHERE block_timestamp >= current_date - 90
    GROUP BY 1,2,3,4

    UNION

    SELECT 'squid' as platform,
    CASE when destination_chain in ('optimism','arbitrum','linea','ethereum','polygon','scroll','filecoin', 'avalanche',
    'fantom','binance','base') then 'evm'
    else 'else' end as chain_type,
    destination_chain,
    date_trunc('d',block_timestamp) as date,
    count (DISTINCT tx_hash) as n_bridge,
    sum(amount) as volume
    FROM axelar.defi.ez_bridge_squid
    WHERE block_timestamp >= current_date - 90
    GROUP BY 1,2,3,4


    SELECT *
    from axelar.defi.ez_bridge_satellite
    where destination_chain = 'osmosis'
    and block_timestamp::date = '2024-02-13'
    order by amount desc



    Last run: about 1 year ago
    PLATFORM
    CHAIN_TYPE
    DESTINATION_CHAIN
    WEEK
    N_BRIDGE
    VOLUME
    1
    		squidevnarbitrum2023-12-23 00:00:00.000252451081.765961732
    2
    		squidelsekujira2024-01-14 00:00:00.0004649566.209166
    3
    		squidelsecelo2023-12-13 00:00:00.0002482488.427776
    4
    		satelliteevnpolygon2024-01-16 00:00:00.0001930032.740416
    5
    		satelliteelsecosmoshub2024-02-06 00:00:00.000261.121729
    6
    		squidelseneutron2024-02-06 00:00:00.000415326.942074
    7
    		squidelsekava2024-02-12 00:00:00.0002048064.98196099
    8
    		squidelsekava2024-01-07 00:00:00.000113735.724979
    9
    		satelliteelseumee2024-01-15 00:00:00.0001045674.5704624
    10
    		squidelsecelo2024-02-08 00:00:00.00024323408.22963
    11
    		squidevnlinea2024-01-12 00:00:00.0001922247.462071
    12
    		satelliteevnpolygon2024-01-28 00:00:00.0003344341.889768395
    13
    		squidevnbinance2023-12-20 00:00:00.0003031073710.02889368
    14
    		satelliteevnavalanche2024-01-17 00:00:00.00076107.375936684
    15
    		satelliteelsejuno2023-11-27 00:00:00.00031201.747569
    16
    		satelliteevnoptimism2023-12-05 00:00:00.0003573.502767
    17
    		satelliteevnavalanche2024-02-02 00:00:00.000713939.79186291
    18
    		satelliteevnfantom2023-12-11 00:00:00.000314906.493419924
    19
    		satelliteevnoptimism2024-01-02 00:00:00.00025.1
    20
    		squidevnarbitrum2024-02-15 00:00:00.000202156668.204125162
    ...
    3973
    272KB
    678s