PREVIEW / futures_30min / 2024-01-26
file: by_date/futures_30min/2024/2024-01-26.parquet size: 93 KB rows: 3,158
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-01-26 00:00:00 | ES | Futures | 5267.33 | 5271.63 | 5267.06 | 5270.55 | 3285.0 |
| 2024-01-26 00:30:00 | ES | Futures | 5270.82 | 5273.51 | 5270.55 | 5270.82 | 2875.0 |
| 2024-01-26 01:00:00 | ES | Futures | 5270.82 | 5271.09 | 5264.38 | 5265.18 | 4871.0 |
| 2024-01-26 01:30:00 | ES | Futures | 5265.18 | 5269.21 | 5263.57 | 5267.6 | 3947.0 |
| 2024-01-26 02:00:00 | ES | Futures | 5267.6 | 5270.02 | 5265.45 | 5268.4 | 5384.0 |
| 2024-01-26 02:30:00 | ES | Futures | 5268.4 | 5269.21 | 5262.76 | 5263.84 | 6075.0 |
| 2024-01-26 03:00:00 | ES | Futures | 5263.84 | 5268.94 | 5263.3 | 5266.26 | 9570.0 |
| 2024-01-26 03:30:00 | ES | Futures | 5266.52 | 5270.55 | 5266.52 | 5268.67 | 6010.0 |
| 2024-01-26 04:00:00 | ES | Futures | 5268.94 | 5273.24 | 5265.45 | 5272.97 | 7545.0 |
| 2024-01-26 04:30:00 | ES | Futures | 5272.97 | 5278.34 | 5271.9 | 5278.07 | 6769.0 |
| 2024-01-26 05:00:00 | ES | Futures | 5278.34 | 5281.57 | 5276.46 | 5280.76 | 7853.0 |
| 2024-01-26 05:30:00 | ES | Futures | 5281.03 | 5281.83 | 5278.88 | 5279.69 | 5051.0 |
| 2024-01-26 06:00:00 | ES | Futures | 5279.69 | 5282.37 | 5277.54 | 5282.37 | 5661.0 |
| 2024-01-26 06:30:00 | ES | Futures | 5282.37 | 5283.71 | 5279.69 | 5282.1 | 6776.0 |
| 2024-01-26 07:00:00 | ES | Futures | 5282.1 | 5286.94 | 5281.83 | 5285.86 | 9122.0 |
| 2024-01-26 07:30:00 | ES | Futures | 5285.59 | 5288.55 | 5283.45 | 5283.71 | 9091.0 |
| 2024-01-26 08:00:00 | ES | Futures | 5283.71 | 5288.01 | 5282.37 | 5283.71 | 14877.0 |
| 2024-01-26 08:30:00 | ES | Futures | 5283.71 | 5295.26 | 5277.0 | 5293.11 | 53776.0 |
| 2024-01-26 09:00:00 | ES | Futures | 5292.85 | 5293.11 | 5278.88 | 5284.25 | 39528.0 |
| 2024-01-26 09:30:00 | ES | Futures | 5283.98 | 5291.5 | 5280.22 | 5285.59 | 126528.0 |
| 2024-01-26 10:00:00 | ES | Futures | 5285.06 | 5290.97 | 5278.07 | 5290.16 | 100960.0 |
| 2024-01-26 10:30:00 | ES | Futures | 5290.16 | 5300.1 | 5289.09 | 5300.1 | 86219.0 |
| 2024-01-26 11:00:00 | ES | Futures | 5300.1 | 5301.17 | 5292.58 | 5296.07 | 71368.0 |
| 2024-01-26 11:30:00 | ES | Futures | 5296.07 | 5297.95 | 5289.89 | 5296.88 | 60632.0 |
| 2024-01-26 12:00:00 | ES | Futures | 5296.61 | 5298.22 | 5291.23 | 5292.04 | 50418.0 |
| 2024-01-26 12:30:00 | ES | Futures | 5292.04 | 5292.31 | 5274.31 | 5277.54 | 102777.0 |
| 2024-01-26 13:00:00 | ES | Futures | 5277.54 | 5283.18 | 5274.85 | 5282.1 | 56551.0 |
| 2024-01-26 13:30:00 | ES | Futures | 5281.83 | 5283.18 | 5272.43 | 5277.27 | 56631.0 |
| 2024-01-26 14:00:00 | ES | Futures | 5277.27 | 5282.91 | 5277.0 | 5279.69 | 40370.0 |
| 2024-01-26 14:30:00 | ES | Futures | 5279.95 | 5289.89 | 5276.73 | 5288.28 | 52400.0 |
| 2024-01-26 15:00:00 | ES | Futures | 5288.28 | 5289.09 | 5281.3 | 5282.91 | 44155.0 |
| 2024-01-26 15:30:00 | ES | Futures | 5282.64 | 5285.06 | 5278.07 | 5282.64 | 116101.0 |
| 2024-01-26 16:00:00 | ES | Futures | 5282.64 | 5282.91 | 5279.42 | 5280.22 | 40027.0 |
| 2024-01-26 16:30:00 | ES | Futures | 5280.22 | 5280.49 | 5278.07 | 5278.07 | 14280.0 |
| 2024-01-26 00:00:00 | NQ | Futures | 18974.63 | 19000.12 | 18973.0 | 18997.14 | 2217.0 |
| 2024-01-26 00:30:00 | NQ | Futures | 18997.14 | 19009.07 | 18990.09 | 18990.63 | 2618.0 |
| 2024-01-26 01:00:00 | NQ | Futures | 18990.9 | 18993.34 | 18962.15 | 18972.19 | 3894.0 |
| 2024-01-26 01:30:00 | NQ | Futures | 18972.46 | 18990.36 | 18963.24 | 18983.31 | 3495.0 |
| 2024-01-26 02:00:00 | NQ | Futures | 18983.85 | 18996.6 | 18968.12 | 18980.32 | 3614.0 |
| 2024-01-26 02:30:00 | NQ | Futures | 18980.05 | 18985.48 | 18949.14 | 18953.48 | 4420.0 |
| 2024-01-26 03:00:00 | NQ | Futures | 18952.39 | 18975.44 | 18947.51 | 18965.14 | 5369.0 |
| 2024-01-26 03:30:00 | NQ | Futures | 18966.22 | 18980.87 | 18963.51 | 18965.95 | 3929.0 |
| 2024-01-26 04:00:00 | NQ | Futures | 18966.49 | 18991.72 | 18949.95 | 18990.36 | 5121.0 |
| 2024-01-26 04:30:00 | NQ | Futures | 18990.9 | 19020.19 | 18980.87 | 19019.11 | 4786.0 |
| 2024-01-26 05:00:00 | NQ | Futures | 19019.11 | 19035.11 | 19002.84 | 19031.31 | 6109.0 |
| 2024-01-26 05:30:00 | NQ | Futures | 19032.4 | 19034.57 | 19011.78 | 19021.82 | 3994.0 |
| 2024-01-26 06:00:00 | NQ | Futures | 19021.28 | 19029.68 | 19005.28 | 19029.41 | 3680.0 |
| 2024-01-26 06:30:00 | NQ | Futures | 19029.41 | 19044.06 | 19021.28 | 19041.35 | 4161.0 |
| 2024-01-26 07:00:00 | NQ | Futures | 19041.35 | 19073.62 | 19036.19 | 19068.47 | 5951.0 |
| 2024-01-26 07:30:00 | NQ | Futures | 19068.47 | 19082.3 | 19052.74 | 19055.18 | 5168.0 |
> showing 50 of 3,158 rows — these rows as CSV