PREVIEW / futures_1hour / 2023-11-29
file: by_date/futures_1hour/2023/2023-11-29.parquet size: 66 KB rows: 2,068
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 |
|---|---|---|---|---|---|---|---|
| 2023-11-29 00:00:00 | ES | Futures | 4963.82 | 4964.63 | 4961.64 | 4963.54 | 6348.0 |
| 2023-11-29 01:00:00 | ES | Futures | 4963.54 | 4965.72 | 4961.64 | 4965.17 | 7831.0 |
| 2023-11-29 02:00:00 | ES | Futures | 4965.17 | 4965.17 | 4961.64 | 4962.19 | 9641.0 |
| 2023-11-29 03:00:00 | ES | Futures | 4962.46 | 4969.79 | 4961.1 | 4967.35 | 21487.0 |
| 2023-11-29 04:00:00 | ES | Futures | 4967.62 | 4974.68 | 4966.26 | 4973.32 | 22376.0 |
| 2023-11-29 05:00:00 | ES | Futures | 4973.05 | 4974.13 | 4971.15 | 4972.78 | 14608.0 |
| 2023-11-29 06:00:00 | ES | Futures | 4972.78 | 4977.39 | 4971.42 | 4976.31 | 15254.0 |
| 2023-11-29 07:00:00 | ES | Futures | 4976.04 | 4980.11 | 4973.86 | 4979.84 | 26992.0 |
| 2023-11-29 08:00:00 | ES | Futures | 4980.11 | 4986.08 | 4978.75 | 4980.11 | 58130.0 |
| 2023-11-29 09:00:00 | ES | Futures | 4980.38 | 4993.42 | 4977.94 | 4991.51 | 189228.0 |
| 2023-11-29 10:00:00 | ES | Futures | 4991.51 | 4992.87 | 4968.97 | 4974.68 | 312245.0 |
| 2023-11-29 11:00:00 | ES | Futures | 4974.68 | 4976.31 | 4956.21 | 4965.17 | 195897.0 |
| 2023-11-29 12:00:00 | ES | Futures | 4965.44 | 4971.96 | 4963.0 | 4970.88 | 95911.0 |
| 2023-11-29 13:00:00 | ES | Futures | 4971.15 | 4972.78 | 4964.63 | 4969.25 | 96420.0 |
| 2023-11-29 14:00:00 | ES | Futures | 4969.25 | 4971.69 | 4957.84 | 4962.73 | 122827.0 |
| 2023-11-29 15:00:00 | ES | Futures | 4962.46 | 4963.27 | 4948.34 | 4953.22 | 239664.0 |
| 2023-11-29 16:00:00 | ES | Futures | 4953.22 | 4959.47 | 4952.41 | 4956.48 | 57430.0 |
| 2023-11-29 18:00:00 | ES | Futures | 4955.67 | 4957.57 | 4954.58 | 4955.94 | 5946.0 |
| 2023-11-29 19:00:00 | ES | Futures | 4956.21 | 4957.84 | 4954.31 | 4956.21 | 7401.0 |
| 2023-11-29 20:00:00 | ES | Futures | 4956.21 | 4957.03 | 4953.22 | 4954.58 | 9541.0 |
| 2023-11-29 21:00:00 | ES | Futures | 4954.85 | 4958.93 | 4954.31 | 4958.38 | 6924.0 |
| 2023-11-29 22:00:00 | ES | Futures | 4958.66 | 4958.66 | 4955.94 | 4957.84 | 4452.0 |
| 2023-11-29 23:00:00 | ES | Futures | 4957.84 | 4959.74 | 4957.57 | 4958.93 | 4818.0 |
| 2023-11-29 00:00:00 | NQ | Futures | 17661.18 | 17665.58 | 17649.65 | 17655.96 | 3234.0 |
| 2023-11-29 01:00:00 | NQ | Futures | 17655.69 | 17664.48 | 17647.72 | 17660.36 | 4013.0 |
| 2023-11-29 02:00:00 | NQ | Futures | 17660.08 | 17660.91 | 17640.31 | 17643.6 | 4303.0 |
| 2023-11-29 03:00:00 | NQ | Futures | 17643.6 | 17688.1 | 17639.76 | 17669.42 | 12868.0 |
| 2023-11-29 04:00:00 | NQ | Futures | 17669.42 | 17713.64 | 17664.75 | 17704.85 | 13563.0 |
| 2023-11-29 05:00:00 | NQ | Futures | 17705.4 | 17715.29 | 17702.38 | 17708.97 | 7261.0 |
| 2023-11-29 06:00:00 | NQ | Futures | 17708.97 | 17730.4 | 17701.83 | 17722.16 | 8560.0 |
| 2023-11-29 07:00:00 | NQ | Futures | 17721.88 | 17737.54 | 17713.92 | 17737.54 | 10823.0 |
| 2023-11-29 08:00:00 | NQ | Futures | 17737.54 | 17768.85 | 17729.85 | 17738.09 | 25094.0 |
| 2023-11-29 09:00:00 | NQ | Futures | 17738.36 | 17807.58 | 17729.85 | 17791.92 | 85866.0 |
| 2023-11-29 10:00:00 | NQ | Futures | 17792.47 | 17802.08 | 17671.89 | 17710.07 | 134570.0 |
| 2023-11-29 11:00:00 | NQ | Futures | 17709.8 | 17712.27 | 17613.39 | 17652.12 | 75897.0 |
| 2023-11-29 12:00:00 | NQ | Futures | 17652.39 | 17684.53 | 17637.56 | 17678.49 | 40530.0 |
| 2023-11-29 13:00:00 | NQ | Futures | 17678.76 | 17688.1 | 17641.41 | 17661.46 | 43745.0 |
| 2023-11-29 14:00:00 | NQ | Futures | 17662.28 | 17671.89 | 17617.51 | 17649.1 | 47914.0 |
| 2023-11-29 15:00:00 | NQ | Futures | 17649.37 | 17651.29 | 17593.34 | 17606.8 | 67016.0 |
| 2023-11-29 16:00:00 | NQ | Futures | 17606.8 | 17639.48 | 17606.8 | 17623.83 | 15940.0 |
| 2023-11-29 18:00:00 | NQ | Futures | 17622.73 | 17633.44 | 17619.16 | 17630.15 | 3595.0 |
| 2023-11-29 19:00:00 | NQ | Futures | 17630.42 | 17641.41 | 17623.28 | 17633.72 | 4505.0 |
| 2023-11-29 20:00:00 | NQ | Futures | 17633.99 | 17635.91 | 17616.96 | 17625.2 | 6984.0 |
| 2023-11-29 21:00:00 | NQ | Futures | 17625.48 | 17641.13 | 17621.91 | 17640.03 | 3245.0 |
| 2023-11-29 22:00:00 | NQ | Futures | 17640.03 | 17640.58 | 17629.6 | 17636.74 | 2323.0 |
| 2023-11-29 23:00:00 | NQ | Futures | 17636.19 | 17641.13 | 17632.34 | 17638.93 | 2222.0 |
| 2023-11-29 00:00:00 | YM | Futures | 38510.2 | 38513.4 | 38496.1 | 38509.1 | 757.0 |
| 2023-11-29 01:00:00 | YM | Futures | 38509.1 | 38523.2 | 38496.1 | 38522.1 | 1194.0 |
| 2023-11-29 02:00:00 | YM | Futures | 38522.1 | 38522.1 | 38502.6 | 38506.9 | 1610.0 |
| 2023-11-29 03:00:00 | YM | Futures | 38508.0 | 38557.9 | 38504.7 | 38547.1 | 2947.0 |
> showing 50 of 2,068 rows — these rows as CSV