flipside

    90- Popular Token Pairs Swapped by Squid Users Post-Bridging
    Eman-Raz90- Popular Token Pairs Swapped by Squid Users Post-Bridging
    Updated 44 minutes ago
    with table1 as (select
    to_varchar(data:call:transaction:from) as squid_user,
    created_at as bridge_date,
    to_varchar(id) as transaction_hash,
    to_varchar(lower(data:call:chain)) as source_chain,
    to_varchar(lower(data:call:returnValues:destinationChain)) as destination_chain,
    data:approved:returnValues:symbol as symbol
    FROM
    axelar.axelscan.fact_gmp
    WHERE data:approved:returnValues:contractAddress in
    ('0xce16F69375520ab01377ce7B88f5BA8C48F8D666',
    '0x492751eC3c57141deb205eC2da8bFcb410738630',
    '0xDC3D8e1Abe590BCa428a8a2FC4CfDbD1AcF57Bd9') and
    status = 'executed'
    AND simplified_status = 'received'
    AND created_at :: date >= '{{Start_Date}}'
    AND created_at :: date <= '{{End_Date}}'),

    table2 as (
    select
    blockchain,
    block_timestamp as swap_date,
    tx_hash,
    trader,
    platform,
    coalesce(amount_in_usd,amount_out_usd) as volume_usd,
    symbol_in,
    symbol_out,
    symbol_in || '➡' || symbol_out as token_pair
    from
    crosschain.defi.ez_dex_swaps
    where
    block_timestamp :: date >= '{{Start_Date}}'
    and block_timestamp :: date <= '{{End_Date}}')

    select token_pair,
    Last run: 44 minutes agoAuto-refreshes every 24 hours
    TOKEN_PAIR
    Number of Users
    Swap Count
    Swap Volume
    1
    		WETH➡USDC23870125596252877852.42
    2
    		USDC➡WETH20959112625301800606.73
    3
    		USDC➡axlUSDC1684149886147268679.8
    4
    		USDT➡USDC106553260799215305.13
    5
    		USDC➡USDT1029335459105737976.41
    6
    		WETH➡USDbC79262824149395061.76
    7
    		USDT➡WETH70631989043992517.34
    8
    		WETH➡USDT65061850030105393.97
    9
    		WMATIC➡USDC6192124009073335.18
    10
    		USDbC➡WETH50712202242633769.02
    11
    		USDbC➡axlUSDC47771044939925303.97
    12
    		axlUSDC➡USDC451023775104679677.83
    13
    		USDbC➡USDC37811448142678994.25
    14
    		USDC➡USDbC35711412740059096.45
    15
    		WETH➡USDB34261446475895419.28
    16
    		USDC➡WMATIC335695079920774.04
    17
    		ARB➡WETH323563013372927.51
    18
    		USDC➡DAI2995872623903721
    19
    		DAI➡USDC2760779834807349.67
    20
    		WMATIC➡USDT266953061755128.25
    20
    797B
    128s