flipside

    Liquidswap-stats-swaptype
    pouya_22Liquidswap-stats-swaptype
    Updated 8 hours ago
    with stables as (
    select distinct symbol
    from external.defillama.dim_stablecoins
    )

    select
    'Swap From Stablecoins' as swap_type,
    date_trunc(week, block_timestamp) as date,
    count(distinct tx_hash) as swaps,
    sum(amount_in_usd) as swap_volume,
    sum(swaps) over(order by date) as total_swaps,
    sum(swap_volume) over(order by date) as total_swap_volume
    from aptos.defi.ez_dex_swaps
    where platform = 'liquidswap'
    and block_timestamp >= dateadd(month, -{{month}}, current_date)
    and symbol_in in (select symbol from stables)
    group by date

    union all

    select
    'Swap To Stablecoins' as swap_type,
    date_trunc(week, block_timestamp) as date,
    count(distinct tx_hash) as swaps,
    sum(amount_in_usd) as swap_volume,
    sum(swaps) over(order by date) as total_swaps,
    sum(swap_volume) over(order by date) as total_swap_volume
    from aptos.defi.ez_dex_swaps
    where platform = 'liquidswap'
    and block_timestamp >= dateadd(month, -{{month}}, current_date)
    and symbol_out in (select symbol from stables)
    group by date

    union all

    select
    Last run: about 8 hours agoAuto-refreshes every 24 hours
    SWAP_TYPE
    DATE
    SWAPS
    SWAP_VOLUME
    TOTAL_SWAPS
    TOTAL_SWAP_VOLUME
    1
    		Swap From Stablecoins2023-10-09 00:00:00.00065278267349.774235542217659329322995.0890677
    2
    		Swap From Stablecoins2024-08-05 00:00:00.000353587946040.702637985165420516730987.338571
    3
    		Swap From Stablecoins2025-02-17 00:00:00.000292997212291.855365357081658907446862.463739
    4
    		Swap From Stablecoins2024-03-25 00:00:00.00010672534049129.55486273916401217067961.265764
    5
    		Swap From Stablecoins2023-07-24 00:00:00.00061372678477.46003485889204622837946.6502635
    6
    		Swap To Stablecoins2025-02-17 00:00:00.000319917017450.4381999381141831001317683.96988
    7
    		Swap To Stablecoins2023-10-09 00:00:00.000111829819428.450135203229748291131419.9885049
    8
    		Swap To Stablecoins2024-08-05 00:00:00.000362567791644.978544176123875612136907.513033
    9
    		Swap To Stablecoins2024-03-25 00:00:00.00015386533541166.40321954818375309434360.510037
    10
    		Swap To Stablecoins2023-07-24 00:00:00.000658761290236.111102194671576853393.3901053
    11
    		Altcoin Swaps2023-10-09 00:00:00.00038260531390.073050937126868733772151.7121796
    12
    		Altcoin Swaps2024-03-25 00:00:00.0009965216627040.03542432541430132365518.479637
    13
    		Altcoin Swaps2024-08-05 00:00:00.0009237715994595.66596354603274477161295.635876
    14
    		Altcoin Swaps2025-02-17 00:00:00.0001850036993249.144048199497892955493118.307245
    15
    		Altcoin Swaps2023-07-24 00:00:00.00030721202092.16504081158689830535163.9242016
    16
    		Swap From Stablecoins2024-06-03 00:00:00.0008029819093067.64444754758270440146850.656277
    17
    		Swap From Stablecoins2023-12-25 00:00:00.0001073992141593.92964751281937138860183.6583329
    18
    		Swap From Stablecoins2024-01-15 00:00:00.000527542904337.08612834301367945415551.4017948
    19
    		Swap From Stablecoins2024-10-21 00:00:00.0009948611138606.45454355819653615371440.34488
    20
    		Swap From Stablecoins2023-07-17 00:00:00.00047098665398.80800431683067422159469.1902286
    ...
    378
    36KB
    119s