flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
USDT Deviation
glass_blossoms
USDT Deviation
Updated 2022-05-13
Copy Reference
Fork
9
1
2
3
4
5
6
7
›
⌄
select
hour
,
max
(
case
when
symbol
=
'USDT'
then
price
end
)
as
USDT
,
100
*
(
USDT
-
1
)
as
"USDT Deviation from USD"
from
ethereum
.
token_prices_hourly
where
(
symbol
=
'USDT'
)
and
date_trunc
(
'day'
,
hour
)
>=
date_trunc
(
'day'
,
CURRENT_DATE
)
-
6
group
by
1
Results
Run a query to Download Data