PREVIEW / futures_1hour / 2024-06-17
file: by_date/futures_1hour/2024/2024-06-17.parquet size: 65 KB rows: 2,023
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 |
|---|---|---|---|---|---|---|---|
| 2024-06-17 00:00:00 | ES | Futures | 5768.13 | 5769.44 | 5765.77 | 5766.3 | 1131.0 |
| 2024-06-17 01:00:00 | ES | Futures | 5766.56 | 5771.02 | 5765.25 | 5769.97 | 2955.0 |
| 2024-06-17 02:00:00 | ES | Futures | 5769.97 | 5772.85 | 5763.94 | 5771.28 | 8298.0 |
| 2024-06-17 03:00:00 | ES | Futures | 5771.54 | 5777.57 | 5769.97 | 5772.33 | 13690.0 |
| 2024-06-17 04:00:00 | ES | Futures | 5772.33 | 5777.04 | 5763.67 | 5766.3 | 16287.0 |
| 2024-06-17 05:00:00 | ES | Futures | 5766.03 | 5768.66 | 5764.72 | 5767.08 | 7187.0 |
| 2024-06-17 06:00:00 | ES | Futures | 5767.34 | 5768.13 | 5760.27 | 5764.99 | 9306.0 |
| 2024-06-17 07:00:00 | ES | Futures | 5765.25 | 5770.23 | 5764.99 | 5768.92 | 10537.0 |
| 2024-06-17 08:00:00 | ES | Futures | 5768.92 | 5771.02 | 5761.58 | 5764.72 | 19507.0 |
| 2024-06-17 09:00:00 | ES | Futures | 5764.46 | 5766.3 | 5756.86 | 5762.36 | 103637.0 |
| 2024-06-17 10:00:00 | ES | Futures | 5762.36 | 5772.33 | 5760.0 | 5771.54 | 136315.0 |
| 2024-06-17 11:00:00 | ES | Futures | 5771.54 | 5783.6 | 5771.54 | 5779.67 | 90766.0 |
| 2024-06-17 12:00:00 | ES | Futures | 5779.93 | 5804.05 | 5779.67 | 5798.54 | 106438.0 |
| 2024-06-17 13:00:00 | ES | Futures | 5798.54 | 5822.14 | 5798.54 | 5820.56 | 108802.0 |
| 2024-06-17 14:00:00 | ES | Futures | 5820.56 | 5831.57 | 5819.52 | 5824.5 | 131903.0 |
| 2024-06-17 15:00:00 | ES | Futures | 5824.5 | 5831.05 | 5814.01 | 5817.42 | 194655.0 |
| 2024-06-17 16:00:00 | ES | Futures | 5817.42 | 5817.94 | 5812.44 | 5817.16 | 50650.0 |
| 2024-06-17 18:00:00 | ES | Futures | 5817.94 | 5824.5 | 5816.63 | 5821.61 | 6013.0 |
| 2024-06-17 19:00:00 | ES | Futures | 5821.61 | 5823.71 | 5819.25 | 5822.4 | 3585.0 |
| 2024-06-17 20:00:00 | ES | Futures | 5822.4 | 5822.66 | 5816.63 | 5817.68 | 6821.0 |
| 2024-06-17 21:00:00 | ES | Futures | 5817.68 | 5817.68 | 5811.65 | 5812.96 | 5777.0 |
| 2024-06-17 22:00:00 | ES | Futures | 5812.96 | 5816.37 | 5812.96 | 5816.11 | 2575.0 |
| 2024-06-17 23:00:00 | ES | Futures | 5815.85 | 5818.47 | 5815.32 | 5816.11 | 3409.0 |
| 2024-06-17 00:00:00 | NQ | Futures | 21077.42 | 21082.17 | 21067.65 | 21069.24 | 795.0 |
| 2024-06-17 01:00:00 | NQ | Futures | 21070.03 | 21084.81 | 21063.16 | 21076.63 | 1738.0 |
| 2024-06-17 02:00:00 | NQ | Futures | 21077.42 | 21089.03 | 21049.44 | 21083.75 | 4928.0 |
| 2024-06-17 03:00:00 | NQ | Futures | 21083.49 | 21114.11 | 21078.21 | 21099.33 | 7420.0 |
| 2024-06-17 04:00:00 | NQ | Futures | 21099.59 | 21132.06 | 21075.04 | 21087.98 | 8531.0 |
| 2024-06-17 05:00:00 | NQ | Futures | 21086.39 | 21104.61 | 21080.06 | 21098.54 | 4343.0 |
| 2024-06-17 06:00:00 | NQ | Futures | 21098.8 | 21102.23 | 21072.14 | 21086.13 | 4530.0 |
| 2024-06-17 07:00:00 | NQ | Futures | 21086.13 | 21105.93 | 21084.55 | 21098.27 | 4995.0 |
| 2024-06-17 08:00:00 | NQ | Futures | 21098.27 | 21103.03 | 21060.26 | 21073.72 | 9976.0 |
| 2024-06-17 09:00:00 | NQ | Futures | 21072.93 | 21091.15 | 21017.23 | 21070.56 | 56803.0 |
| 2024-06-17 10:00:00 | NQ | Futures | 21070.82 | 21101.71 | 21043.89 | 21094.58 | 71862.0 |
| 2024-06-17 11:00:00 | NQ | Futures | 21094.58 | 21143.68 | 21094.31 | 21134.18 | 45388.0 |
| 2024-06-17 12:00:00 | NQ | Futures | 21134.18 | 21242.14 | 21126.26 | 21219.44 | 52883.0 |
| 2024-06-17 13:00:00 | NQ | Futures | 21219.18 | 21369.91 | 21218.91 | 21365.16 | 62264.0 |
| 2024-06-17 14:00:00 | NQ | Futures | 21365.42 | 21405.02 | 21348.26 | 21368.59 | 60827.0 |
| 2024-06-17 15:00:00 | NQ | Futures | 21368.33 | 21395.52 | 21317.11 | 21326.09 | 75824.0 |
| 2024-06-17 16:00:00 | NQ | Futures | 21326.09 | 21328.47 | 21290.98 | 21316.06 | 18845.0 |
| 2024-06-17 18:00:00 | NQ | Futures | 21322.39 | 21349.32 | 21315.0 | 21337.18 | 3583.0 |
| 2024-06-17 19:00:00 | NQ | Futures | 21336.91 | 21341.67 | 21324.77 | 21334.54 | 2428.0 |
| 2024-06-17 20:00:00 | NQ | Futures | 21334.54 | 21335.33 | 21298.37 | 21315.0 | 4702.0 |
| 2024-06-17 21:00:00 | NQ | Futures | 21314.74 | 21315.53 | 21285.44 | 21292.83 | 3294.0 |
| 2024-06-17 22:00:00 | NQ | Futures | 21292.56 | 21309.99 | 21291.24 | 21309.2 | 1929.0 |
| 2024-06-17 23:00:00 | NQ | Futures | 21308.67 | 21324.51 | 21306.03 | 21312.89 | 2365.0 |
| 2024-06-17 00:00:00 | YM | Futures | 40964.7 | 40972.1 | 40951.1 | 40954.2 | 332.0 |
| 2024-06-17 01:00:00 | YM | Futures | 40955.3 | 40988.9 | 40952.1 | 40986.8 | 532.0 |
| 2024-06-17 02:00:00 | YM | Futures | 40987.8 | 41013.1 | 40952.1 | 40985.7 | 1412.0 |
| 2024-06-17 03:00:00 | YM | Futures | 40986.8 | 41025.7 | 40981.5 | 40988.9 | 2038.0 |
> showing 50 of 2,023 rows — these rows as CSV