PREVIEW / futures_1hour / 2024-09-19
file: by_date/futures_1hour/2024/2024-09-19.parquet size: 68 KB rows: 2,100
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-09-19 00:00:00 | ES | Futures | 5956.06 | 5956.84 | 5951.65 | 5954.5 | 5677.0 |
| 2024-09-19 01:00:00 | ES | Futures | 5954.5 | 5957.62 | 5949.83 | 5956.06 | 8076.0 |
| 2024-09-19 02:00:00 | ES | Futures | 5955.8 | 5963.85 | 5951.91 | 5962.03 | 12294.0 |
| 2024-09-19 03:00:00 | ES | Futures | 5962.03 | 5970.85 | 5954.25 | 5970.85 | 20719.0 |
| 2024-09-19 04:00:00 | ES | Futures | 5970.85 | 5977.34 | 5965.92 | 5975.53 | 21958.0 |
| 2024-09-19 05:00:00 | ES | Futures | 5975.79 | 5987.98 | 5974.23 | 5986.69 | 21041.0 |
| 2024-09-19 06:00:00 | ES | Futures | 5986.43 | 5994.73 | 5984.61 | 5993.17 | 20124.0 |
| 2024-09-19 07:00:00 | ES | Futures | 5992.91 | 5999.14 | 5990.06 | 5993.69 | 32400.0 |
| 2024-09-19 08:00:00 | ES | Futures | 5993.43 | 5994.99 | 5986.69 | 5988.24 | 42700.0 |
| 2024-09-19 09:00:00 | ES | Futures | 5987.98 | 5999.4 | 5967.22 | 5983.05 | 231113.0 |
| 2024-09-19 10:00:00 | ES | Futures | 5983.05 | 6007.97 | 5980.72 | 5986.69 | 242986.0 |
| 2024-09-19 11:00:00 | ES | Futures | 5986.69 | 5999.92 | 5981.5 | 5991.88 | 132751.0 |
| 2024-09-19 12:00:00 | ES | Futures | 5991.88 | 6009.26 | 5990.84 | 6003.55 | 89319.0 |
| 2024-09-19 13:00:00 | ES | Futures | 6003.81 | 6018.35 | 6001.48 | 6013.94 | 97645.0 |
| 2024-09-19 14:00:00 | ES | Futures | 6014.2 | 6016.53 | 5997.07 | 6007.71 | 119584.0 |
| 2024-09-19 15:00:00 | ES | Futures | 6007.97 | 6010.04 | 5991.36 | 5998.1 | 261374.0 |
| 2024-09-19 16:00:00 | ES | Futures | 5997.85 | 5998.62 | 5992.4 | 5994.47 | 62401.0 |
| 2024-09-19 18:00:00 | ES | Futures | 5996.03 | 5996.81 | 5988.5 | 5992.14 | 6459.0 |
| 2024-09-19 19:00:00 | ES | Futures | 5991.88 | 5994.47 | 5988.76 | 5990.06 | 3985.0 |
| 2024-09-19 20:00:00 | ES | Futures | 5989.8 | 5991.36 | 5983.83 | 5985.39 | 8578.0 |
| 2024-09-19 21:00:00 | ES | Futures | 5985.65 | 5991.36 | 5985.39 | 5990.32 | 5810.0 |
| 2024-09-19 22:00:00 | ES | Futures | 5990.06 | 5992.65 | 5984.61 | 5985.65 | 4877.0 |
| 2024-09-19 23:00:00 | ES | Futures | 5985.91 | 5991.36 | 5984.61 | 5990.84 | 4498.0 |
| 2024-09-19 00:00:00 | NQ | Futures | 20732.35 | 20739.92 | 20714.35 | 20729.48 | 4318.0 |
| 2024-09-19 01:00:00 | NQ | Futures | 20730.27 | 20759.75 | 20708.87 | 20748.79 | 6147.0 |
| 2024-09-19 02:00:00 | NQ | Futures | 20749.57 | 20790.28 | 20730.53 | 20780.1 | 7959.0 |
| 2024-09-19 03:00:00 | NQ | Futures | 20779.84 | 20813.24 | 20742.01 | 20812.98 | 10024.0 |
| 2024-09-19 04:00:00 | NQ | Futures | 20813.24 | 20815.06 | 20768.62 | 20806.19 | 9464.0 |
| 2024-09-19 05:00:00 | NQ | Futures | 20806.45 | 20855.77 | 20792.1 | 20852.11 | 10087.0 |
| 2024-09-19 06:00:00 | NQ | Futures | 20851.85 | 20876.64 | 20836.98 | 20869.07 | 8414.0 |
| 2024-09-19 07:00:00 | NQ | Futures | 20868.29 | 20892.29 | 20850.03 | 20883.16 | 10714.0 |
| 2024-09-19 08:00:00 | NQ | Futures | 20882.9 | 20892.81 | 20863.07 | 20874.55 | 14669.0 |
| 2024-09-19 09:00:00 | NQ | Futures | 20874.55 | 20949.17 | 20835.41 | 20882.9 | 80453.0 |
| 2024-09-19 10:00:00 | NQ | Futures | 20884.47 | 21038.4 | 20872.99 | 20939.0 | 85775.0 |
| 2024-09-19 11:00:00 | NQ | Futures | 20939.0 | 21034.75 | 20924.12 | 20975.26 | 58300.0 |
| 2024-09-19 12:00:00 | NQ | Futures | 20975.52 | 21054.06 | 20969.52 | 21036.84 | 38007.0 |
| 2024-09-19 13:00:00 | NQ | Futures | 21036.32 | 21084.85 | 21016.23 | 21074.41 | 34358.0 |
| 2024-09-19 14:00:00 | NQ | Futures | 21074.15 | 21083.54 | 20983.87 | 21027.45 | 45233.0 |
| 2024-09-19 15:00:00 | NQ | Futures | 21028.49 | 21032.14 | 20939.78 | 20959.35 | 75586.0 |
| 2024-09-19 16:00:00 | NQ | Futures | 20958.56 | 20969.78 | 20926.73 | 20938.47 | 16657.0 |
| 2024-09-19 18:00:00 | NQ | Futures | 20941.87 | 20950.48 | 20906.38 | 20924.39 | 3951.0 |
| 2024-09-19 19:00:00 | NQ | Futures | 20924.39 | 20942.91 | 20917.08 | 20923.86 | 2438.0 |
| 2024-09-19 20:00:00 | NQ | Futures | 20922.56 | 20932.21 | 20896.21 | 20910.56 | 3493.0 |
| 2024-09-19 21:00:00 | NQ | Futures | 20910.04 | 20936.91 | 20906.38 | 20931.17 | 3227.0 |
| 2024-09-19 22:00:00 | NQ | Futures | 20930.39 | 20946.56 | 20894.64 | 20901.69 | 3631.0 |
| 2024-09-19 23:00:00 | NQ | Futures | 20901.95 | 20930.39 | 20895.16 | 20926.47 | 2546.0 |
| 2024-09-19 00:00:00 | YM | Futures | 43905.2 | 43906.2 | 43874.0 | 43890.6 | 610.0 |
| 2024-09-19 01:00:00 | YM | Futures | 43890.6 | 43891.6 | 43855.2 | 43879.2 | 705.0 |
| 2024-09-19 02:00:00 | YM | Futures | 43880.2 | 43923.9 | 43857.3 | 43902.1 | 1821.0 |
| 2024-09-19 03:00:00 | YM | Futures | 43903.1 | 43980.1 | 43864.6 | 43980.1 | 2357.0 |
> showing 50 of 2,100 rows — these rows as CSV