flipside
Products
For Protocols
For Analysts
For Explorers
About
Log in
Become a Partner
flipside
2024-01-15 02:52 PM
Keyrock
2024-01-15 02:52 PM
Updated 2024-01-15
Copy Reference
Fork
9
1
2
3
4
5
6
›
⌄
SELECT
symbol
,
hour
,
avg
(
price
)
as
price
FROM
crosschain
.
price
.
ez_hourly_token_prices
WHERE
symbol
IN
(
'WBTC'
,
'WETH'
,
'USDC'
,
'USDT'
,
'USDD'
)
AND
blockchain
=
'ethereum'
AND
hour
>
'2022-10-01'
group
by
1
,
2
Results
QueryRunArchived: QueryRun has been archived