flipside

    fresh-yellow
    Sbhn_NPfresh-yellow
    Updated 2025-01-17
    with price as (
    SELECT hour::date as datee,
    symbol,
    token_address,
    decimals,
    avg(price) as usdprice
    from aptos.price.ez_prices_hourly
    group by 1,2,3,4
    UNION
    SELECT hour::date as datee,
    'USDt' as symbol,
    '0xccd1a84ccea93531d7f165b90134aa0415feb30e8757ab1632dac68c0055f5c2::coins::USDt' as token_address,
    6 as decimals,
    avg(price) as usdprice
    from aptos.price.ez_prices_hourly
    where symbol ='USDT'
    group by 1,2,3,4
    UNION
    SELECT hour::date as datee,
    'thAPT' as symbol,
    '0xfaf4e633ae9eb31366c9ca24214231760926576c7b625313b3688b5e900731f6::staking::ThalaAPT' as token_address,
    decimals,
    avg(price) as usdprice
    from aptos.price.ez_prices_hourly
    where symbol ='APT'
    group by 1,2,3,4
    UNION
    SELECT hour::date as datee,
    'TruAPT' as symbol,
    '0xccd1a84ccea93531d7f165b90134aa0415feb30e8757ab1632dac68c0055f5c2::coins::TruAPT' as token_address,
    decimals,
    avg(price) as usdprice
    from aptos.price.ez_prices_hourly
    where symbol ='APT'
    group by 1,2,3,4)

    Last run: 21 days ago
    TYPE
    DATE
    SYMBOL
    USERS
    USD
    1
    		Supply2024-12-01 00:00:00.000USDT1586298846.36431916
    2
    		Supply2024-10-01 00:00:00.000thAPT12998.154203086
    3
    		Borrow2024-12-01 00:00:00.000USDT725660088.75262655
    4
    		Borrow2024-10-01 00:00:00.000thAPT142246.887639228
    5
    		Repay2024-12-01 00:00:00.000USDT586491356.37231428
    6
    		Repay2024-10-01 00:00:00.000thAPT72558.500676391
    7
    		Withdraw2024-12-01 00:00:00.000USDT1637252599.83568761
    8
    		Withdraw2024-10-01 00:00:00.000thAPT86004.854772193
    9
    		Supply2024-10-01 00:00:00.000WETH853860370.52579254
    10
    		Supply2025-05-01 00:00:00.000stAPT23170053.034989535
    11
    		Supply2025-04-01 00:00:00.000amAPT8921.848409258
    12
    		Borrow2024-10-01 00:00:00.000WETH1182590077.49338746
    13
    		Borrow2025-05-01 00:00:00.000stAPT720068.338909866
    14
    		Borrow2025-04-01 00:00:00.000amAPT411754.416139167
    15
    		Borrow2025-05-01 00:00:00.000TruAPT276.890543239
    16
    		Repay2024-10-01 00:00:00.000WETH22621820.976538391
    17
    		Repay2025-05-01 00:00:00.000stAPT1115332.964741422
    18
    		Repay2025-05-01 00:00:00.000TruAPT71332.516407036
    19
    		Repay2025-04-01 00:00:00.000amAPT513534.539106365
    20
    		Withdraw2025-05-01 00:00:00.000stAPT1371457268.13518886
    ...
    507
    31KB
    63s