flipside

    Dately avUSD Swaps Stats on Avalanche Over Time
    Ali3NDately avUSD Swaps Stats on Avalanche Over Time
    Updated 4 days ago
    select date_trunc (day,block_timestamp) as date,
    case when token_in = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346' then 'Swap From avUSD (SELL)'
    when token_out = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346' then 'Swap To avUSD (BUY)' end as Trading_Type,
    count (distinct tx_hash) as TX_Count,
    count (distinct origin_from_address) as Traders_Count,
    sum (case when token_in = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346' then amount_in
    when token_out = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346' then amount_out end) as Trading_Volume,
    sum(coalesce(amount_in_usd,amount_out_usd)) as USD_Trading_Volume,
    avg (case when token_in = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346' then amount_in
    when token_out = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346' then amount_out end) as Average_Trading_Volume,
    sum (tx_count) over (partition by Trading_Type order by date) as Cumulative_TX_Count,
    sum (Trading_Volume) over (partition by Trading_Type order by date) as Cumulative_Trading_Volume,
    sum (USD_Trading_Volume) over (partition by Trading_Type order by date) as Cumulative_USD_Trading_Volume,
    from avalanche.defi.ez_dex_swaps
    where token_in in ('0x24de8771bc5ddb3362db529fc3358f2df3a0e346')
    or token_out = '0x24de8771bc5ddb3362db529fc3358f2df3a0e346'
    group by 1,2
    order by 1 desc









    Last run: 4 days agoAuto-refreshes every 24 hours
    DATE
    TRADING_TYPE
    TX_COUNT
    TRADERS_COUNT
    TRADING_VOLUME
    USD_TRADING_VOLUME
    AVERAGE_TRADING_VOLUME
    CUMULATIVE_TX_COUNT
    CUMULATIVE_TRADING_VOLUME
    CUMULATIVE_USD_TRADING_VOLUME
    1
    		2025-04-20 00:00:00.000Swap To avUSD (BUY)22756146742.516823115147025.39481.1230059775532712830386.792847912837389.71
    2
    		2025-04-20 00:00:00.000Swap From avUSD (SELL)22657143748.017834279143749.92524.6278023155492413504945.837102213482476.01
    3
    		2025-04-19 00:00:00.000Swap From avUSD (SELL)34761132847.220023887132887.32326.4059460055469813361197.81926813338726.09
    4
    		2025-04-19 00:00:00.000Swap To avUSD (BUY)34762102943.57138103103042.8278.2258685975510012683644.276024812690364.32
    5
    		2025-04-18 00:00:00.000Swap From avUSD (SELL)24662199431.876684992199583.56651.7381591015435113228350.599244113205838.77
    6
    		2025-04-18 00:00:00.000Swap To avUSD (BUY)2415897526.64110571297636.66327.2706077375475312580700.704643812587321.52
    7
    		2025-04-17 00:00:00.000Swap From avUSD (SELL)5765565801.35208087465858.71104.6126424185410513028918.722559113006255.21
    8
    		2025-04-17 00:00:00.000Swap To avUSD (BUY)5755670815.60655279670910.67114.4032416045451212483174.063538112489684.86
    9
    		2025-04-16 00:00:00.000Swap From avUSD (SELL)7496097775.39159591797854.17121.4601137845352912963117.370478212940396.5
    10
    		2025-04-16 00:00:00.000Swap To avUSD (BUY)74756169882.896174553170300.47205.1725799215393712412358.456985312418774.19
    11
    		2025-04-15 00:00:00.000Swap To avUSD (BUY)55977180411.883514845180655.02264.1462423355319012242475.560810712248473.72
    12
    		2025-04-15 00:00:00.000Swap From avUSD (SELL)5577789612.14044294589619.62141.5673624695278012865341.978882312842542.33
    13
    		2025-04-14 00:00:00.000Swap To avUSD (BUY)82383495651.509416563496109.88547.076721215263112062063.677295912067818.7
    14
    		2025-04-14 00:00:00.000Swap From avUSD (SELL)83284833447.329630535834402.49849.5895307145222312775729.838439312752922.71
    15
    		2025-04-13 00:00:00.000Swap To avUSD (BUY)72670148905.48894584149215.68180.2729890395180811566412.167879311571708.82
    16
    		2025-04-13 00:00:00.000Swap From avUSD (SELL)73176152272.73554112152393.7191.2974064595139111942282.508808811918520.22
    17
    		2025-04-12 00:00:00.000Swap From avUSD (SELL)6387849971.90648781549978.4967.0763845475066011790009.773267711766126.52
    18
    		2025-04-12 00:00:00.000Swap To avUSD (BUY)6357522225.64074440722134.8332.3047103845108211417506.678933511422493.14
    19
    		2025-04-11 00:00:00.000Swap From avUSD (SELL)8911211098211.435883491089630.621053.9457158195002211740037.866779911716148.03
    20
    		2025-04-11 00:00:00.000Swap To avUSD (BUY)8721041132424.053992471133366.621098.3744461615044711395281.038189111400358.31
    ...
    196
    25KB
    6s