flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Copy of Asset Prices on THORChain Post-November Halt
binhachon
Copy of Asset Prices on THORChain Post-November Halt
Updated 2022-06-04
Copy Reference
Fork
9
1
2
3
4
5
6
7
8
›
⌄
SELECT
SPLIT
(
pool_name
,
'-'
)
[
0
]
::
string
AS
clean_pool_name
,
*
FROM
thorchain
.
prices
WHERE
1
=
1
AND
block_timestamp
>=
'2021-11-18 18:00:00'
AND
block_timestamp
<=
'2021-11-18 20:00:00'
ORDER
BY
block_timestamp
,
pool_name
-- LIMIT 50000
Results
Run a query to Download Data