Eman-RazPrice Change: 24h
Updated 2024-11-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
with tab1 as (select price as current_price
from aptos.price.ez_prices_hourly
where token_address='0xd6a49762f6e4f7401ee79be6f5d4111e70db1408966ba1aa204e6e10c9d437ca::bubbles::BubblesCoin'
order by hour DESC
limit 1),
tab2 as (select avg(price) as yesterday_price
from aptos.price.ez_prices_hourly
where token_address='0xd6a49762f6e4f7401ee79be6f5d4111e70db1408966ba1aa204e6e10c9d437ca::bubbles::BubblesCoin'
and hour::date = current_date-1)
select ((current_price-yesterday_price)/yesterday_price)*100 as "24h Price Change"
from tab1 , tab2
Auto-refreshes every 24 hours
QueryRunArchived: QueryRun has been archived