flipside

    Qi Swap Pairs' Stats in Avalanche DEXs
    Ali3NQi Swap Pairs' Stats in Avalanche DEXs
    Updated 2025-03-26
    -- forked from CLY Swap Pairs' Stats in Avalanche DEXs @ https://flipsidecrypto.xyz/edit/queries/5c16fdc6-28c4-4691-9df7-039d8bdd72bc

    select symbol_in || ' => ' || symbol_out as Trading_Pair,
    count (distinct tx_hash) as TX_Count,
    count (distinct origin_from_address) as Traders_Count,
    sum (case when token_in = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_in
    when token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_out end) as Total_Trading_Volume,
    avg (case when token_in = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_in
    when token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5' then amount_out end) as Average_Trading_Volume
    from avalanche.defi.ez_dex_swaps
    where token_in in ('0x8729438eb15e2c8b576fcc6aecda6a148776c0f5')
    or token_out = '0x8729438eb15e2c8b576fcc6aecda6a148776c0f5'
    group by 1
    order by 2 desc



    Last run: about 1 month ago
    TRADING_PAIR
    TX_COUNT
    TRADERS_COUNT
    TOTAL_TRADING_VOLUME
    AVERAGE_TRADING_VOLUME
    1
    		QI => WAVAX6185444630522895559001.081833556.194079014
    2
    		WAVAX => QI5070844005122609837812.979239851.025211514
    3
    		QI => PNG13553392030552283.38722952254.115640197
    4
    		PNG => QI13195422431428672.48731372381.681758663
    5
    		sAVAX => QI349538224531932.92401627007.121657817
    6
    		QI => sAVAX310151525081941.24407378085.732187
    7
    		AVE => QI14092231167817.80036202828.827395573
    8
    		USDT.e => QI1376654491977.883605511357.542066574
    9
    		QI => AVE13322211058530.1481622794.692303425
    10
    		QI => USDT.e1292818477508.012354761369.588244857
    11
    		QI => KNC11662334163090.961372863567.344439908
    12
    		KNC => QI11361494680319.526711744119.999583373
    13
    		QI => xQI105825113431595.751943412695.270086903
    14
    		xQI => QI94619314418429.23945115241.468540646
    15
    		QI => JOE685326330533.816324643482.531118722
    16
    		QI => WETH.e6076549133.27358722521.353008947
    17
    		JOE => QI605303309767.700242096512.012727673
    18
    		WETH.e => QI5704848962.78142028721.626670239
    19
    		USDC => QI30414218440137.811070548654.717179605
    20
    		QI => RUGPULL2996271491.533927497239.102120159
    91
    4KB
    6s