Eman-RazMonthly Percentage Changes in the Prices of Native Coins of Different Blockchains
    Updated 2025-03-10
    with apt as (with tab1 as (select price
    from aptos.price.ez_prices_hourly
    where token_address='0x1::aptos_coin::AptosCoin'
    and name='Aptos Coin' and symbol='APT'
    order by hour desc
    limit 1),

    tab2 as (select avg(price) as avg_price
    from aptos.price.ez_prices_hourly
    where token_address='0x1::aptos_coin::AptosCoin'
    and name='Aptos Coin' and symbol='APT'
    and hour::date=current_date-30)

    select ((price-avg_price)/avg_price)*100 as "Price Change", 'APT' as symbol
    from tab1 , tab2),

    ------------------------------------------------------
    ------------------------------------------------------

    arb as (with tab1 as (select price
    from arbitrum.price.ez_prices_hourly
    where token_address='0x912ce59144191c1204e64559fe8253a0e49e6548'
    order by hour desc
    limit 1),

    tab2 as (select avg(price) as avg_price
    from arbitrum.price.ez_prices_hourly
    where token_address='0x912ce59144191c1204e64559fe8253a0e49e6548'
    and hour::date=current_date-30)

    select ((price-avg_price)/avg_price)*100 as "Price Change", 'ARB' as symbol
    from tab1 , tab2),

    -------------------------------------------------------
    -------------------------------------------------------

    Last run: 27 days agoAuto-refreshes every 24 hours
    Price Change
    SYMBOL
    1
    -1.050929669APT
    2
    -45.401302801ARB
    3
    -43.929821638AVAX
    4
    -24.095507181AURORA
    5
    -13.407484493BTC
    6
    -24.200675851NEAR
    7
    -14.346202305KLAY
    8
    -23.797946469GNO
    9
    -14.321372069FLOW
    10
    -18.914198641ETH
    11
    -4.052251869BNB
    12
    -9.224624948OP
    13
    -45.169664225MATIC
    14
    -6.450539361OSMO
    15
    -31.344315144SOL
    16
    7.239348805RUNE
    17
    -28.420494952GLMR
    18
    -1.27555553ADA
    19
    5.475251862TIA
    20
    -43.936610201DYM
    26
    573B
    27s