PREVIEW / futures_1hour / 2022-01-24
file: by_date/futures_1hour/2022/2022-01-24.parquet size: 70 KB rows: 2,092
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-24 00:00:00 | ES | Futures | 5001.64 | 5005.6 | 4999.94 | 5001.64 | 6594.0 |
| 2022-01-24 01:00:00 | ES | Futures | 5001.36 | 5005.03 | 4996.26 | 4997.4 | 5845.0 |
| 2022-01-24 02:00:00 | ES | Futures | 4997.68 | 4997.68 | 4984.1 | 4990.04 | 33058.0 |
| 2022-01-24 03:00:00 | ES | Futures | 4990.04 | 5005.6 | 4981.84 | 4982.97 | 31304.0 |
| 2022-01-24 04:00:00 | ES | Futures | 4983.26 | 4988.63 | 4972.79 | 4977.88 | 35020.0 |
| 2022-01-24 05:00:00 | ES | Futures | 4977.88 | 4978.45 | 4933.48 | 4948.47 | 52444.0 |
| 2022-01-24 06:00:00 | ES | Futures | 4948.47 | 4962.61 | 4945.64 | 4960.07 | 40507.0 |
| 2022-01-24 07:00:00 | ES | Futures | 4959.78 | 4962.33 | 4934.61 | 4937.16 | 39187.0 |
| 2022-01-24 08:00:00 | ES | Futures | 4937.44 | 4937.44 | 4893.04 | 4893.61 | 107295.0 |
| 2022-01-24 09:00:00 | ES | Futures | 4893.32 | 4910.01 | 4852.88 | 4860.52 | 438615.0 |
| 2022-01-24 10:00:00 | ES | Futures | 4860.52 | 4881.16 | 4822.34 | 4856.84 | 526412.0 |
| 2022-01-24 11:00:00 | ES | Futures | 4856.84 | 4857.13 | 4789.82 | 4822.91 | 363469.0 |
| 2022-01-24 12:00:00 | ES | Futures | 4822.91 | 4828.85 | 4765.5 | 4816.97 | 419471.0 |
| 2022-01-24 13:00:00 | ES | Futures | 4816.69 | 4885.41 | 4810.46 | 4884.56 | 371646.0 |
| 2022-01-24 14:00:00 | ES | Futures | 4884.56 | 4904.92 | 4825.17 | 4873.53 | 399299.0 |
| 2022-01-24 15:00:00 | ES | Futures | 4873.53 | 4988.63 | 4869.29 | 4982.69 | 602645.0 |
| 2022-01-24 16:00:00 | ES | Futures | 4982.41 | 4990.33 | 4967.7 | 4985.8 | 106454.0 |
| 2022-01-24 18:00:00 | ES | Futures | 4980.43 | 4984.95 | 4958.37 | 4979.3 | 23587.0 |
| 2022-01-24 19:00:00 | ES | Futures | 4979.58 | 4982.41 | 4938.29 | 4939.99 | 27635.0 |
| 2022-01-24 20:00:00 | ES | Futures | 4939.99 | 4947.91 | 4926.7 | 4941.97 | 31331.0 |
| 2022-01-24 21:00:00 | ES | Futures | 4941.97 | 4942.82 | 4926.41 | 4941.4 | 15951.0 |
| 2022-01-24 22:00:00 | ES | Futures | 4941.4 | 4941.4 | 4919.63 | 4921.6 | 19188.0 |
| 2022-01-24 23:00:00 | ES | Futures | 4921.89 | 4927.26 | 4908.03 | 4914.53 | 14940.0 |
| 2022-01-24 00:00:00 | NQ | Futures | 16852.0 | 16876.05 | 16847.36 | 16866.78 | 4779.0 |
| 2022-01-24 01:00:00 | NQ | Futures | 16865.33 | 16877.5 | 16845.33 | 16852.58 | 4768.0 |
| 2022-01-24 02:00:00 | NQ | Futures | 16852.87 | 16854.32 | 16775.78 | 16825.05 | 15403.0 |
| 2022-01-24 03:00:00 | NQ | Futures | 16824.76 | 16896.05 | 16787.95 | 16799.54 | 22702.0 |
| 2022-01-24 04:00:00 | NQ | Futures | 16799.83 | 16824.47 | 16723.9 | 16757.23 | 20461.0 |
| 2022-01-24 05:00:00 | NQ | Futures | 16754.91 | 16755.78 | 16568.27 | 16623.62 | 31738.0 |
| 2022-01-24 06:00:00 | NQ | Futures | 16624.49 | 16708.54 | 16618.41 | 16692.02 | 24738.0 |
| 2022-01-24 07:00:00 | NQ | Futures | 16692.02 | 16701.0 | 16556.67 | 16572.61 | 24352.0 |
| 2022-01-24 08:00:00 | NQ | Futures | 16573.19 | 16575.8 | 16420.17 | 16423.65 | 47801.0 |
| 2022-01-24 09:00:00 | NQ | Futures | 16423.65 | 16535.23 | 16289.17 | 16341.63 | 178942.0 |
| 2022-01-24 10:00:00 | NQ | Futures | 16341.34 | 16424.81 | 16203.1 | 16334.09 | 177574.0 |
| 2022-01-24 11:00:00 | NQ | Futures | 16332.94 | 16334.09 | 16017.03 | 16153.54 | 132359.0 |
| 2022-01-24 12:00:00 | NQ | Futures | 16152.09 | 16190.93 | 15888.94 | 16139.34 | 134594.0 |
| 2022-01-24 13:00:00 | NQ | Futures | 16138.47 | 16439.01 | 16112.96 | 16433.21 | 116056.0 |
| 2022-01-24 14:00:00 | NQ | Futures | 16432.63 | 16517.55 | 16199.91 | 16406.26 | 120137.0 |
| 2022-01-24 15:00:00 | NQ | Futures | 16408.87 | 16834.9 | 16368.0 | 16809.68 | 144400.0 |
| 2022-01-24 16:00:00 | NQ | Futures | 16809.68 | 16838.09 | 16764.18 | 16812.58 | 27866.0 |
| 2022-01-24 18:00:00 | NQ | Futures | 16803.6 | 16808.24 | 16696.66 | 16786.5 | 13406.0 |
| 2022-01-24 19:00:00 | NQ | Futures | 16788.82 | 16797.22 | 16613.48 | 16623.62 | 16243.0 |
| 2022-01-24 20:00:00 | NQ | Futures | 16622.75 | 16656.95 | 16570.59 | 16632.61 | 19026.0 |
| 2022-01-24 21:00:00 | NQ | Futures | 16631.45 | 16631.45 | 16556.67 | 16615.8 | 11442.0 |
| 2022-01-24 22:00:00 | NQ | Futures | 16614.93 | 16614.93 | 16500.74 | 16521.61 | 12526.0 |
| 2022-01-24 23:00:00 | NQ | Futures | 16522.77 | 16549.43 | 16472.63 | 16496.68 | 8904.0 |
| 2022-01-24 00:00:00 | YM | Futures | 38636.3 | 38667.7 | 38618.3 | 38631.8 | 1075.0 |
| 2022-01-24 01:00:00 | YM | Futures | 38629.5 | 38659.9 | 38592.4 | 38598.0 | 1155.0 |
| 2022-01-24 02:00:00 | YM | Futures | 38598.0 | 38599.2 | 38514.9 | 38540.7 | 4617.0 |
| 2022-01-24 03:00:00 | YM | Futures | 38541.9 | 38636.3 | 38469.9 | 38471.1 | 7076.0 |
> showing 50 of 2,092 rows — these rows as CSV