PREVIEW / futures_1hour / 2023-10-10
file: by_date/futures_1hour/2023/2023-10-10.parquet size: 67 KB rows: 2,076
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-10-10 00:00:00 | ES | Futures | 4750.1 | 4750.64 | 4747.93 | 4748.47 | 4046.0 |
| 2023-10-10 01:00:00 | ES | Futures | 4748.47 | 4750.64 | 4747.38 | 4749.28 | 7434.0 |
| 2023-10-10 02:00:00 | ES | Futures | 4749.28 | 4749.56 | 4742.77 | 4746.84 | 13739.0 |
| 2023-10-10 03:00:00 | ES | Futures | 4746.57 | 4754.99 | 4745.75 | 4749.83 | 30140.0 |
| 2023-10-10 04:00:00 | ES | Futures | 4749.83 | 4758.79 | 4745.48 | 4756.89 | 29957.0 |
| 2023-10-10 05:00:00 | ES | Futures | 4757.16 | 4757.43 | 4751.73 | 4754.17 | 14388.0 |
| 2023-10-10 06:00:00 | ES | Futures | 4754.44 | 4758.52 | 4752.81 | 4753.36 | 15321.0 |
| 2023-10-10 07:00:00 | ES | Futures | 4753.63 | 4754.44 | 4743.04 | 4744.12 | 30841.0 |
| 2023-10-10 08:00:00 | ES | Futures | 4744.12 | 4752.54 | 4742.77 | 4751.73 | 44563.0 |
| 2023-10-10 09:00:00 | ES | Futures | 4751.46 | 4760.42 | 4747.93 | 4760.42 | 177610.0 |
| 2023-10-10 10:00:00 | ES | Futures | 4760.42 | 4783.23 | 4760.15 | 4778.88 | 234073.0 |
| 2023-10-10 11:00:00 | ES | Futures | 4779.16 | 4798.98 | 4777.25 | 4797.35 | 188629.0 |
| 2023-10-10 12:00:00 | ES | Futures | 4797.62 | 4800.07 | 4793.01 | 4795.72 | 114135.0 |
| 2023-10-10 13:00:00 | ES | Futures | 4795.99 | 4795.99 | 4771.82 | 4780.24 | 213407.0 |
| 2023-10-10 14:00:00 | ES | Futures | 4780.51 | 4783.77 | 4767.75 | 4771.28 | 151976.0 |
| 2023-10-10 15:00:00 | ES | Futures | 4771.28 | 4777.53 | 4768.02 | 4770.19 | 203037.0 |
| 2023-10-10 16:00:00 | ES | Futures | 4769.92 | 4772.64 | 4768.56 | 4770.19 | 47064.0 |
| 2023-10-10 18:00:00 | ES | Futures | 4770.74 | 4771.28 | 4768.02 | 4770.19 | 3772.0 |
| 2023-10-10 19:00:00 | ES | Futures | 4770.47 | 4772.64 | 4770.19 | 4771.82 | 2833.0 |
| 2023-10-10 20:00:00 | ES | Futures | 4771.55 | 4774.81 | 4770.19 | 4770.19 | 7345.0 |
| 2023-10-10 21:00:00 | ES | Futures | 4770.19 | 4772.37 | 4768.56 | 4770.47 | 7421.0 |
| 2023-10-10 22:00:00 | ES | Futures | 4770.47 | 4773.72 | 4769.11 | 4772.37 | 4614.0 |
| 2023-10-10 23:00:00 | ES | Futures | 4772.64 | 4773.72 | 4771.28 | 4772.37 | 4440.0 |
| 2023-10-10 00:00:00 | NQ | Futures | 16716.61 | 16722.65 | 16706.45 | 16712.49 | 2707.0 |
| 2023-10-10 01:00:00 | NQ | Futures | 16712.22 | 16724.3 | 16707.82 | 16715.24 | 3723.0 |
| 2023-10-10 02:00:00 | NQ | Futures | 16715.24 | 16718.53 | 16685.3 | 16700.68 | 8409.0 |
| 2023-10-10 03:00:00 | NQ | Futures | 16700.13 | 16736.94 | 16696.29 | 16713.87 | 13890.0 |
| 2023-10-10 04:00:00 | NQ | Futures | 16714.14 | 16742.71 | 16692.72 | 16731.99 | 15232.0 |
| 2023-10-10 05:00:00 | NQ | Futures | 16731.99 | 16732.54 | 16711.12 | 16723.75 | 7367.0 |
| 2023-10-10 06:00:00 | NQ | Futures | 16723.48 | 16741.06 | 16716.06 | 16720.18 | 7521.0 |
| 2023-10-10 07:00:00 | NQ | Futures | 16720.73 | 16724.58 | 16668.55 | 16675.69 | 16866.0 |
| 2023-10-10 08:00:00 | NQ | Futures | 16675.41 | 16705.35 | 16670.47 | 16695.46 | 18220.0 |
| 2023-10-10 09:00:00 | NQ | Futures | 16694.91 | 16744.9 | 16677.61 | 16744.08 | 72975.0 |
| 2023-10-10 10:00:00 | NQ | Futures | 16744.08 | 16838.84 | 16741.06 | 16827.85 | 102469.0 |
| 2023-10-10 11:00:00 | NQ | Futures | 16828.13 | 16901.19 | 16819.61 | 16888.83 | 75046.0 |
| 2023-10-10 12:00:00 | NQ | Futures | 16889.1 | 16893.22 | 16865.75 | 16876.19 | 47707.0 |
| 2023-10-10 13:00:00 | NQ | Futures | 16876.47 | 16877.29 | 16760.28 | 16799.84 | 89207.0 |
| 2023-10-10 14:00:00 | NQ | Futures | 16799.84 | 16823.46 | 16767.42 | 16784.18 | 59962.0 |
| 2023-10-10 15:00:00 | NQ | Futures | 16784.45 | 16810.27 | 16768.8 | 16776.76 | 62173.0 |
| 2023-10-10 16:00:00 | NQ | Futures | 16777.04 | 16796.26 | 16775.66 | 16789.67 | 13452.0 |
| 2023-10-10 18:00:00 | NQ | Futures | 16789.95 | 16794.34 | 16781.98 | 16792.97 | 2213.0 |
| 2023-10-10 19:00:00 | NQ | Futures | 16792.69 | 16800.11 | 16792.42 | 16795.72 | 2079.0 |
| 2023-10-10 20:00:00 | NQ | Futures | 16795.99 | 16811.65 | 16789.95 | 16793.24 | 5230.0 |
| 2023-10-10 21:00:00 | NQ | Futures | 16793.52 | 16807.25 | 16789.67 | 16797.09 | 3406.0 |
| 2023-10-10 22:00:00 | NQ | Futures | 16797.09 | 16809.45 | 16790.5 | 16805.05 | 2964.0 |
| 2023-10-10 23:00:00 | NQ | Futures | 16805.05 | 16813.57 | 16800.66 | 16805.88 | 2625.0 |
| 2023-10-10 00:00:00 | YM | Futures | 36692.1 | 36694.2 | 36676.9 | 36679.0 | 602.0 |
| 2023-10-10 01:00:00 | YM | Futures | 36678.0 | 36688.8 | 36668.2 | 36679.0 | 1019.0 |
| 2023-10-10 02:00:00 | YM | Futures | 36678.0 | 36682.3 | 36640.0 | 36678.0 | 3055.0 |
| 2023-10-10 03:00:00 | YM | Futures | 36676.9 | 36740.9 | 36670.4 | 36700.7 | 6383.0 |
> showing 50 of 2,076 rows — these rows as CSV