Squid📥Tracking of Destination Chains (Sorted By Swaps Count)
    Updated 4 days ago
    with final_table as (WITH token_transfer AS (
    WITH filtered_transfers AS (
    SELECT
    data:link:height::string AS block_number,
    data:link:txhash AS tx_hash,
    data:send:original_source_chain AS original_source_chain,
    data:send:original_destination_chain AS original_destination_chain,
    data:time_spent:destination_chain_type AS destination_chain_type,
    data:time_spent:source_chain_type AS source_chain_type,
    sender_address,
    -- data:link:recipient_address AS recipient_address,
    created_at::date AS date,
    CAST((data:send:amount) * (data:link:price) AS VARCHAR) AS usd_amount_sent,
    CAST(data:send:fee_value AS VARCHAR) AS fee_usd,
    id
    FROM axelar.axelscan.fact_transfers
    WHERE sender_address = '0xce16F69375520ab01377ce7B88f5BA8C48F8D666'
    AND simplified_status = 'received'
    AND created_at::date between '{{Start_Date}}' and '{{End_Date}}'
    )
    SELECT
    CAST(date AS VARCHAR) AS date,
    CASE
    WHEN ft.original_source_chain = 'base' THEN base_tx.from_address
    WHEN ft.original_source_chain = 'arbitrum' THEN arbitrum_tx.from_address
    WHEN ft.original_source_chain = 'ethereum' THEN ethereum_tx.from_address
    WHEN ft.original_source_chain = 'avalanche' THEN avalanche_tx.from_address
    WHEN ft.original_source_chain = 'optimism' THEN optimism_tx.from_address
    WHEN ft.original_source_chain = 'binance' THEN binance_tx.from_address
    WHEN ft.original_source_chain = 'polygon' THEN polygon_tx.from_address
    END AS sender,
    -- CAST(ft.recipient_address AS VARCHAR) AS recipient,
    CAST(ft.original_source_chain AS VARCHAR) AS source_chain,
    CAST(ft.source_chain_type AS VARCHAR) AS source_chain_type,
    CAST(ft.original_destination_chain AS VARCHAR) AS destination_chain,
    CAST(ft.destination_chain_type AS VARCHAR) AS destination_chain_type,
    Last run: 4 days ago
    📥Destination Chain
    🚀Swaps Count
    💰Swaps Volume ($USD)
    👥Swappers Count
    Gas Fee ($USD)
    1
    arbitrum309905380519620.660675146679394122.795876597
    2
    polygon291300189769582.28774915915584452.229272038
    3
    binance218734523170149.52898597301220863.984568133
    4
    base210588258520361.47884481724231234.034635476
    5
    celo135869161020650.3042269094728996.323056162
    6
    fantom128555191062873.5582245609033720.989704888
    7
    optimism116664117050396.41139453946171318.868204801
    8
    ethereum83378696063608.630036464361901340.05441355
    9
    avalanche5878474873256.67582553442182810.134975958
    10
    linea5633240352412.539729533707101097.80041029
    11
    moonbeam4182044623402.37861412477010379.758895784
    12
    mantle4010721733680.53282352656814847.917381881
    13
    scroll3621320625010.03295562332965155.79118183
    14
    immutable282916652931.96374188152114531.26831271
    15
    kava2510256990626.8266344115354858.509189697
    16
    filecoin285320853354.4812706745722.838113356
    17
    osmosis19287040089.4532455989111374.93696291
    18
    kujira8991516577.9050262143612146.278076259
    19
    axelarnet5948357223.327741821241371.169305898
    20
    neutron180785751.2244371831481175.91103914
    40
    2KB
    534s