PREVIEW / futures_1hour / 2025-01-09
file: by_date/futures_1hour/2025/2025-01-09.parquet size: 61 KB rows: 1,946
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2025-01-09 00:00:00 | ES | Futures | 6096.15 | 6101.53 | 6094.1 | 6100.76 | 3367.0 |
| 2025-01-09 01:00:00 | ES | Futures | 6100.76 | 6101.79 | 6098.2 | 6100.25 | 2345.0 |
| 2025-01-09 02:00:00 | ES | Futures | 6099.99 | 6100.25 | 6085.12 | 6086.4 | 7500.0 |
| 2025-01-09 03:00:00 | ES | Futures | 6086.4 | 6103.84 | 6080.51 | 6101.53 | 12645.0 |
| 2025-01-09 04:00:00 | ES | Futures | 6101.79 | 6106.15 | 6098.45 | 6104.35 | 7081.0 |
| 2025-01-09 05:00:00 | ES | Futures | 6104.35 | 6108.97 | 6103.07 | 6105.63 | 6186.0 |
| 2025-01-09 06:00:00 | ES | Futures | 6105.63 | 6105.63 | 6094.86 | 6099.22 | 8198.0 |
| 2025-01-09 07:00:00 | ES | Futures | 6099.74 | 6103.33 | 6094.86 | 6102.56 | 7728.0 |
| 2025-01-09 08:00:00 | ES | Futures | 6102.3 | 6106.66 | 6095.63 | 6097.94 | 15200.0 |
| 2025-01-09 09:00:00 | ES | Futures | 6097.94 | 6097.94 | 6087.43 | 6096.4 | 14918.0 |
| 2025-01-09 18:00:00 | ES | Futures | 6095.38 | 6096.92 | 6077.43 | 6081.79 | 13757.0 |
| 2025-01-09 19:00:00 | ES | Futures | 6082.05 | 6084.1 | 6071.53 | 6073.84 | 14818.0 |
| 2025-01-09 20:00:00 | ES | Futures | 6074.1 | 6087.43 | 6073.84 | 6085.64 | 8372.0 |
| 2025-01-09 21:00:00 | ES | Futures | 6085.64 | 6091.53 | 6083.58 | 6090.25 | 6094.0 |
| 2025-01-09 22:00:00 | ES | Futures | 6090.25 | 6097.17 | 6089.99 | 6094.61 | 6427.0 |
| 2025-01-09 23:00:00 | ES | Futures | 6094.35 | 6096.4 | 6091.53 | 6095.63 | 3832.0 |
| 2025-01-09 00:00:00 | NQ | Futures | 21936.49 | 21956.05 | 21928.25 | 21949.61 | 2490.0 |
| 2025-01-09 01:00:00 | NQ | Futures | 21950.64 | 21955.53 | 21933.14 | 21940.61 | 2152.0 |
| 2025-01-09 02:00:00 | NQ | Futures | 21941.89 | 21942.92 | 21865.2 | 21873.44 | 6416.0 |
| 2025-01-09 03:00:00 | NQ | Futures | 21873.44 | 21932.89 | 21841.53 | 21919.25 | 8825.0 |
| 2025-01-09 04:00:00 | NQ | Futures | 21920.53 | 21940.09 | 21903.55 | 21937.52 | 5674.0 |
| 2025-01-09 05:00:00 | NQ | Futures | 21937.78 | 21961.45 | 21936.23 | 21954.25 | 4003.0 |
| 2025-01-09 06:00:00 | NQ | Futures | 21954.5 | 21955.53 | 21901.75 | 21927.74 | 6816.0 |
| 2025-01-09 07:00:00 | NQ | Futures | 21928.77 | 21944.21 | 21911.27 | 21938.03 | 4520.0 |
| 2025-01-09 08:00:00 | NQ | Futures | 21937.78 | 21960.94 | 21918.73 | 21931.08 | 7619.0 |
| 2025-01-09 09:00:00 | NQ | Futures | 21930.05 | 21936.49 | 21889.91 | 21927.48 | 6494.0 |
| 2025-01-09 18:00:00 | NQ | Futures | 21928.77 | 21935.2 | 21834.58 | 21861.6 | 7534.0 |
| 2025-01-09 19:00:00 | NQ | Futures | 21861.09 | 21869.58 | 21801.9 | 21818.88 | 7326.0 |
| 2025-01-09 20:00:00 | NQ | Futures | 21820.17 | 21882.45 | 21816.56 | 21871.89 | 4915.0 |
| 2025-01-09 21:00:00 | NQ | Futures | 21871.64 | 21904.06 | 21861.6 | 21898.4 | 3522.0 |
| 2025-01-09 22:00:00 | NQ | Futures | 21899.43 | 21940.35 | 21896.86 | 21926.71 | 4463.0 |
| 2025-01-09 23:00:00 | NQ | Futures | 21926.45 | 21934.69 | 21906.64 | 21928.0 | 2928.0 |
| 2025-01-09 00:00:00 | YM | Futures | 44051.6 | 44087.6 | 44038.2 | 44085.5 | 368.0 |
| 2025-01-09 01:00:00 | YM | Futures | 44085.5 | 44090.7 | 44072.1 | 44085.5 | 385.0 |
| 2025-01-09 02:00:00 | YM | Futures | 44083.5 | 44083.5 | 43995.0 | 44004.2 | 1251.0 |
| 2025-01-09 03:00:00 | YM | Futures | 44004.2 | 44126.7 | 43975.4 | 44113.3 | 2069.0 |
| 2025-01-09 04:00:00 | YM | Futures | 44115.4 | 44158.6 | 44104.1 | 44127.7 | 1109.0 |
| 2025-01-09 05:00:00 | YM | Futures | 44128.8 | 44161.7 | 44121.6 | 44129.8 | 793.0 |
| 2025-01-09 06:00:00 | YM | Futures | 44128.8 | 44129.8 | 44070.1 | 44095.8 | 1417.0 |
| 2025-01-09 07:00:00 | YM | Futures | 44096.8 | 44126.7 | 44062.9 | 44123.6 | 1476.0 |
| 2025-01-09 08:00:00 | YM | Futures | 44121.6 | 44140.1 | 44076.3 | 44085.5 | 1597.0 |
| 2025-01-09 09:00:00 | YM | Futures | 44084.5 | 44084.5 | 44017.6 | 44075.2 | 1976.0 |
| 2025-01-09 18:00:00 | YM | Futures | 44074.2 | 44080.4 | 43952.8 | 43988.8 | 1765.0 |
| 2025-01-09 19:00:00 | YM | Futures | 43986.7 | 43995.0 | 43933.2 | 43941.4 | 1638.0 |
| 2025-01-09 20:00:00 | YM | Futures | 43943.5 | 44009.4 | 43941.4 | 44002.2 | 1148.0 |
| 2025-01-09 21:00:00 | YM | Futures | 44001.1 | 44031.0 | 43989.8 | 44022.7 | 697.0 |
| 2025-01-09 22:00:00 | YM | Futures | 44022.7 | 44053.6 | 44021.7 | 44040.2 | 622.0 |
| 2025-01-09 23:00:00 | YM | Futures | 44041.3 | 44063.9 | 44027.9 | 44059.8 | 521.0 |
| 2025-01-09 00:00:00 | CL | Futures | 66.5 | 66.64 | 66.42 | 66.63 | 1092.0 |
| 2025-01-09 01:00:00 | CL | Futures | 66.63 | 66.73 | 66.58 | 66.69 | 1703.0 |
> showing 50 of 1,946 rows — these rows as CSV