PREVIEW / futures_1hour / 2024-01-22
file: by_date/futures_1hour/2024/2024-01-22.parquet size: 65 KB rows: 2,079
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-22 00:00:00 | ES | Futures | 5245.31 | 5245.57 | 5241.55 | 5242.35 | 4912.0 |
| 2024-01-22 01:00:00 | ES | Futures | 5242.35 | 5245.04 | 5241.55 | 5243.43 | 7962.0 |
| 2024-01-22 02:00:00 | ES | Futures | 5243.16 | 5245.57 | 5240.2 | 5244.5 | 12463.0 |
| 2024-01-22 03:00:00 | ES | Futures | 5244.23 | 5247.72 | 5241.55 | 5245.04 | 23809.0 |
| 2024-01-22 04:00:00 | ES | Futures | 5245.31 | 5248.26 | 5243.43 | 5247.45 | 16905.0 |
| 2024-01-22 05:00:00 | ES | Futures | 5247.45 | 5249.87 | 5245.31 | 5246.65 | 13766.0 |
| 2024-01-22 06:00:00 | ES | Futures | 5246.92 | 5251.21 | 5246.11 | 5247.45 | 13994.0 |
| 2024-01-22 07:00:00 | ES | Futures | 5247.45 | 5254.17 | 5246.92 | 5253.36 | 22925.0 |
| 2024-01-22 08:00:00 | ES | Futures | 5253.36 | 5253.63 | 5246.65 | 5249.33 | 31682.0 |
| 2024-01-22 09:00:00 | ES | Futures | 5249.07 | 5262.23 | 5246.11 | 5260.35 | 193458.0 |
| 2024-01-22 10:00:00 | ES | Futures | 5260.35 | 5262.5 | 5242.08 | 5244.23 | 265313.0 |
| 2024-01-22 11:00:00 | ES | Futures | 5244.5 | 5251.48 | 5237.79 | 5249.6 | 127644.0 |
| 2024-01-22 12:00:00 | ES | Futures | 5249.87 | 5250.95 | 5241.01 | 5246.38 | 83334.0 |
| 2024-01-22 13:00:00 | ES | Futures | 5246.65 | 5249.07 | 5235.91 | 5247.45 | 96306.0 |
| 2024-01-22 14:00:00 | ES | Futures | 5247.45 | 5249.33 | 5238.59 | 5245.31 | 81749.0 |
| 2024-01-22 15:00:00 | ES | Futures | 5245.31 | 5251.48 | 5241.81 | 5244.77 | 162095.0 |
| 2024-01-22 16:00:00 | ES | Futures | 5244.5 | 5245.57 | 5242.08 | 5243.69 | 46520.0 |
| 2024-01-22 18:00:00 | ES | Futures | 5244.77 | 5245.84 | 5241.81 | 5244.23 | 5266.0 |
| 2024-01-22 19:00:00 | ES | Futures | 5244.23 | 5246.11 | 5243.16 | 5244.77 | 5203.0 |
| 2024-01-22 20:00:00 | ES | Futures | 5244.77 | 5247.99 | 5241.81 | 5246.38 | 11048.0 |
| 2024-01-22 21:00:00 | ES | Futures | 5246.11 | 5248.26 | 5243.96 | 5244.23 | 7631.0 |
| 2024-01-22 22:00:00 | ES | Futures | 5244.23 | 5246.65 | 5242.89 | 5242.89 | 6032.0 |
| 2024-01-22 23:00:00 | ES | Futures | 5243.16 | 5246.38 | 5243.16 | 5244.77 | 2914.0 |
| 2024-01-22 00:00:00 | NQ | Futures | 19041.08 | 19043.52 | 19016.94 | 19022.9 | 3526.0 |
| 2024-01-22 01:00:00 | NQ | Futures | 19022.9 | 19038.36 | 19021.01 | 19031.31 | 4638.0 |
| 2024-01-22 02:00:00 | NQ | Futures | 19031.04 | 19049.75 | 19019.92 | 19025.62 | 8598.0 |
| 2024-01-22 03:00:00 | NQ | Futures | 19024.53 | 19030.23 | 19004.46 | 19027.24 | 9546.0 |
| 2024-01-22 04:00:00 | NQ | Futures | 19027.51 | 19032.94 | 19009.34 | 19025.62 | 7475.0 |
| 2024-01-22 05:00:00 | NQ | Futures | 19025.07 | 19036.19 | 19013.95 | 19023.72 | 4568.0 |
| 2024-01-22 06:00:00 | NQ | Futures | 19023.18 | 19045.14 | 19020.73 | 19023.18 | 6678.0 |
| 2024-01-22 07:00:00 | NQ | Futures | 19022.9 | 19073.89 | 19021.28 | 19060.33 | 12966.0 |
| 2024-01-22 08:00:00 | NQ | Futures | 19060.6 | 19062.77 | 19003.38 | 19013.41 | 18866.0 |
| 2024-01-22 09:00:00 | NQ | Futures | 19013.68 | 19076.6 | 18975.71 | 19028.06 | 100816.0 |
| 2024-01-22 10:00:00 | NQ | Futures | 19028.33 | 19040.53 | 18917.95 | 18930.69 | 128302.0 |
| 2024-01-22 11:00:00 | NQ | Futures | 18931.24 | 18999.31 | 18919.57 | 18996.6 | 65711.0 |
| 2024-01-22 12:00:00 | NQ | Futures | 18996.6 | 18998.5 | 18942.63 | 18965.68 | 46527.0 |
| 2024-01-22 13:00:00 | NQ | Futures | 18966.22 | 18969.21 | 18912.79 | 18961.88 | 48950.0 |
| 2024-01-22 14:00:00 | NQ | Futures | 18962.15 | 18970.29 | 18921.47 | 18951.31 | 45320.0 |
| 2024-01-22 15:00:00 | NQ | Futures | 18951.58 | 18973.54 | 18934.22 | 18941.81 | 59493.0 |
| 2024-01-22 16:00:00 | NQ | Futures | 18941.81 | 18942.9 | 18923.37 | 18936.12 | 9889.0 |
| 2024-01-22 18:00:00 | NQ | Futures | 18942.08 | 18956.19 | 18930.15 | 18945.88 | 3375.0 |
| 2024-01-22 19:00:00 | NQ | Futures | 18945.61 | 18957.54 | 18942.08 | 18953.48 | 2929.0 |
| 2024-01-22 20:00:00 | NQ | Futures | 18953.48 | 18967.58 | 18934.76 | 18960.53 | 6020.0 |
| 2024-01-22 21:00:00 | NQ | Futures | 18959.98 | 18971.1 | 18950.49 | 18952.12 | 4938.0 |
| 2024-01-22 22:00:00 | NQ | Futures | 18952.12 | 18968.12 | 18946.7 | 18947.78 | 3874.0 |
| 2024-01-22 23:00:00 | NQ | Futures | 18947.51 | 18962.97 | 18946.97 | 18956.19 | 2117.0 |
| 2024-01-22 00:00:00 | YM | Futures | 40926.7 | 40931.0 | 40911.6 | 40918.1 | 797.0 |
| 2024-01-22 01:00:00 | YM | Futures | 40917.0 | 40933.1 | 40904.1 | 40911.6 | 1438.0 |
| 2024-01-22 02:00:00 | YM | Futures | 40910.5 | 40917.0 | 40880.5 | 40910.5 | 2445.0 |
| 2024-01-22 03:00:00 | YM | Futures | 40909.5 | 40949.2 | 40900.9 | 40925.6 | 2491.0 |
> showing 50 of 2,079 rows — these rows as CSV