Eman-Raz% of price changes relative to ATH & ATL
    Updated 2024-05-19
    with tab1 as (select MAX(price) AS MAX, min(price) as min
    from blast.price.ez_hourly_token_prices
    where token_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'),

    tab2 as (select price
    from blast.price.ez_hourly_token_prices
    where token_address='0x5ffd9ebd27f2fcab044c0f0a26a45cb62fa29c06'
    order by hour desc
    limit 1)

    select ((price-min)/min)*100 as "rel to atl", ((price-max)/max)*100 as "rel to ath"
    from tab1 , tab2
    Auto-refreshes every 24 hours
    QueryRunArchived: QueryRun has been archived