PREVIEW / futures_1hour / 2022-12-01
file: by_date/futures_1hour/2022/2022-12-01.parquet size: 68 KB rows: 2,063
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-12-01 00:00:00 | ES | Futures | 4610.09 | 4617.14 | 4608.68 | 4613.47 | 10372.0 |
| 2022-12-01 01:00:00 | ES | Futures | 4613.75 | 4615.16 | 4609.52 | 4610.65 | 7545.0 |
| 2022-12-01 02:00:00 | ES | Futures | 4610.37 | 4611.22 | 4603.32 | 4606.99 | 16288.0 |
| 2022-12-01 03:00:00 | ES | Futures | 4606.99 | 4609.24 | 4597.97 | 4601.63 | 32415.0 |
| 2022-12-01 04:00:00 | ES | Futures | 4601.63 | 4602.76 | 4591.48 | 4597.68 | 26910.0 |
| 2022-12-01 05:00:00 | ES | Futures | 4597.97 | 4601.91 | 4595.71 | 4596.28 | 15150.0 |
| 2022-12-01 06:00:00 | ES | Futures | 4596.28 | 4601.35 | 4594.58 | 4600.22 | 16051.0 |
| 2022-12-01 07:00:00 | ES | Futures | 4599.94 | 4608.11 | 4598.25 | 4608.11 | 25272.0 |
| 2022-12-01 08:00:00 | ES | Futures | 4607.83 | 4628.41 | 4601.35 | 4617.14 | 87537.0 |
| 2022-12-01 09:00:00 | ES | Futures | 4617.14 | 4628.41 | 4610.37 | 4621.93 | 205986.0 |
| 2022-12-01 10:00:00 | ES | Futures | 4621.93 | 4634.33 | 4571.75 | 4604.17 | 351898.0 |
| 2022-12-01 11:00:00 | ES | Futures | 4604.45 | 4605.01 | 4585.28 | 4595.43 | 185423.0 |
| 2022-12-01 12:00:00 | ES | Futures | 4595.71 | 4605.01 | 4580.49 | 4601.07 | 148857.0 |
| 2022-12-01 13:00:00 | ES | Futures | 4601.07 | 4609.52 | 4589.51 | 4598.53 | 130749.0 |
| 2022-12-01 14:00:00 | ES | Futures | 4598.81 | 4610.93 | 4590.36 | 4608.4 | 129117.0 |
| 2022-12-01 15:00:00 | ES | Futures | 4608.4 | 4614.6 | 4598.25 | 4601.63 | 237234.0 |
| 2022-12-01 16:00:00 | ES | Futures | 4601.35 | 4602.19 | 4595.43 | 4597.68 | 48060.0 |
| 2022-12-01 18:00:00 | ES | Futures | 4597.68 | 4600.5 | 4596.56 | 4598.25 | 4647.0 |
| 2022-12-01 19:00:00 | ES | Futures | 4597.97 | 4598.25 | 4586.97 | 4587.82 | 11543.0 |
| 2022-12-01 20:00:00 | ES | Futures | 4587.54 | 4590.36 | 4584.44 | 4585.84 | 8641.0 |
| 2022-12-01 21:00:00 | ES | Futures | 4585.84 | 4591.2 | 4585.28 | 4590.64 | 7352.0 |
| 2022-12-01 22:00:00 | ES | Futures | 4590.92 | 4593.17 | 4589.51 | 4592.61 | 5678.0 |
| 2022-12-01 23:00:00 | ES | Futures | 4592.61 | 4594.87 | 4588.95 | 4593.46 | 5702.0 |
| 2022-12-01 00:00:00 | NQ | Futures | 13859.16 | 13886.46 | 13854.28 | 13875.25 | 4707.0 |
| 2022-12-01 01:00:00 | NQ | Futures | 13875.25 | 13879.28 | 13855.43 | 13860.03 | 3125.0 |
| 2022-12-01 02:00:00 | NQ | Futures | 13859.45 | 13862.9 | 13835.89 | 13847.96 | 6656.0 |
| 2022-12-01 03:00:00 | NQ | Futures | 13847.38 | 13857.15 | 13812.62 | 13824.11 | 13081.0 |
| 2022-12-01 04:00:00 | NQ | Futures | 13824.4 | 13826.41 | 13783.02 | 13810.03 | 11152.0 |
| 2022-12-01 05:00:00 | NQ | Futures | 13809.46 | 13822.1 | 13796.53 | 13798.54 | 6381.0 |
| 2022-12-01 06:00:00 | NQ | Futures | 13798.54 | 13827.56 | 13791.07 | 13820.09 | 7159.0 |
| 2022-12-01 07:00:00 | NQ | Futures | 13820.95 | 13851.98 | 13815.49 | 13851.12 | 9009.0 |
| 2022-12-01 08:00:00 | NQ | Futures | 13850.83 | 13944.21 | 13827.56 | 13881.58 | 39596.0 |
| 2022-12-01 09:00:00 | NQ | Futures | 13881.0 | 13947.95 | 13827.85 | 13917.78 | 82400.0 |
| 2022-12-01 10:00:00 | NQ | Futures | 13921.8 | 13958.29 | 13726.42 | 13875.54 | 124991.0 |
| 2022-12-01 11:00:00 | NQ | Futures | 13875.83 | 13879.85 | 13797.68 | 13827.27 | 68535.0 |
| 2022-12-01 12:00:00 | NQ | Futures | 13827.85 | 13860.89 | 13773.83 | 13845.95 | 51178.0 |
| 2022-12-01 13:00:00 | NQ | Futures | 13845.95 | 13877.55 | 13811.47 | 13851.41 | 45327.0 |
| 2022-12-01 14:00:00 | NQ | Futures | 13851.69 | 13892.21 | 13825.26 | 13887.03 | 40574.0 |
| 2022-12-01 15:00:00 | NQ | Futures | 13887.03 | 13905.42 | 13850.83 | 13860.6 | 62288.0 |
| 2022-12-01 16:00:00 | NQ | Futures | 13860.03 | 13861.46 | 13832.73 | 13833.59 | 13646.0 |
| 2022-12-01 18:00:00 | NQ | Futures | 13837.33 | 13846.81 | 13828.13 | 13837.9 | 3106.0 |
| 2022-12-01 19:00:00 | NQ | Futures | 13836.75 | 13836.75 | 13799.98 | 13804.57 | 4531.0 |
| 2022-12-01 20:00:00 | NQ | Futures | 13804.28 | 13813.48 | 13789.34 | 13796.81 | 3887.0 |
| 2022-12-01 21:00:00 | NQ | Futures | 13797.1 | 13813.77 | 13794.52 | 13811.76 | 2847.0 |
| 2022-12-01 22:00:00 | NQ | Futures | 13812.9 | 13820.95 | 13806.58 | 13818.08 | 2185.0 |
| 2022-12-01 23:00:00 | NQ | Futures | 13817.79 | 13823.54 | 13803.42 | 13820.66 | 2125.0 |
| 2022-12-01 00:00:00 | YM | Futures | 38836.0 | 38871.9 | 38825.9 | 38850.6 | 1422.0 |
| 2022-12-01 01:00:00 | YM | Futures | 38850.6 | 38861.8 | 38831.5 | 38837.1 | 1336.0 |
| 2022-12-01 02:00:00 | YM | Futures | 38838.3 | 38845.0 | 38785.5 | 38815.8 | 2372.0 |
| 2022-12-01 03:00:00 | YM | Futures | 38815.8 | 38834.9 | 38757.5 | 38792.3 | 4302.0 |
> showing 50 of 2,063 rows — these rows as CSV