AzinDEXs
    Updated 2 days ago
    WITH LAST0 AS
    (SELECT
    DATE_TRUNC('WEEK' , BLOCK_TIMESTAMP) AS DATE
    FROM
    aptos.defi.ez_dex_swaps
    GROUP BY 1
    ORDER BY 1 DESC
    LIMIT 2
    ),

    LAST1 AS
    (SELECT
    DATE
    FROM
    LAST0
    GROUP BY 1
    ORDER BY 1
    LIMIT 1),


    T1 AS
    (
    SELECT
    HOUR::dATE AS Date
    , AVG(PRICE) AS Price
    FROM
    aptos.price.ez_prices_hourly
    WHERE
    TOKEN_ADDRESS = '0x1::aptos_coin::AptosCoin'
    GROUP BY 1
    ),

    Manual_Price0 AS
    (SELECT
    BLOCK_TIMESTAMP::DATE AS Date
    , AVG((AMOUNT_IN * Price) / AMOUNT_OUT) AS Price
    Last run: 1 day ago
    PLATFORM
    TRADING_VOLUME
    1
    pancake7274028.19453208
    2
    liquidswap7184297.53396594
    3
    sushi5492475.41904858
    4
    animeswap5269.087096406
    5
    auxexchange6720.051047888
    6
    cellana78323803.3345473
    7
    thala231707521.115674
    8
    hyperfluid505856709.92062
    9
    cetus13184.121981912
    10
    hippo17983.668772648
    11
    batswap1919.064064302
    11
    315B
    12s