flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
PAXG 1
drone-mostafa
PAXG 1
Updated 2023-06-07
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
HOUR
as
date
,
PRICE
as
Last_PRICE
FROM
ethereum
.
core
.
fact_hourly_token_prices
WHERE
TOKEN_ADDRESS
=
'0x45804880de22913dafe09f4980848ece6ecbaf78'
--PAXG
AND
HOUR
>=
current_date
-
2
ORDER
BY
date
DESC
limit
1
Results
Run a query to Download Data