PREVIEW / futures_1hour / 2022-08-18
file: by_date/futures_1hour/2022/2022-08-18.parquet size: 67 KB rows: 2,032
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-08-18 00:00:00 | ES | Futures | 4841.11 | 4843.66 | 4837.43 | 4837.71 | 2751.0 |
| 2022-08-18 01:00:00 | ES | Futures | 4837.71 | 4842.81 | 4833.74 | 4834.03 | 4831.0 |
| 2022-08-18 02:00:00 | ES | Futures | 4833.74 | 4838.28 | 4825.25 | 4826.66 | 10256.0 |
| 2022-08-18 03:00:00 | ES | Futures | 4826.66 | 4835.73 | 4824.68 | 4832.89 | 11432.0 |
| 2022-08-18 04:00:00 | ES | Futures | 4833.18 | 4842.53 | 4830.35 | 4842.24 | 10381.0 |
| 2022-08-18 05:00:00 | ES | Futures | 4842.53 | 4853.01 | 4841.11 | 4851.87 | 11674.0 |
| 2022-08-18 06:00:00 | ES | Futures | 4851.87 | 4858.67 | 4848.76 | 4849.89 | 13126.0 |
| 2022-08-18 07:00:00 | ES | Futures | 4850.17 | 4856.97 | 4847.63 | 4856.69 | 12055.0 |
| 2022-08-18 08:00:00 | ES | Futures | 4856.69 | 4864.05 | 4847.63 | 4854.14 | 35569.0 |
| 2022-08-18 09:00:00 | ES | Futures | 4854.14 | 4855.27 | 4835.16 | 4837.71 | 169534.0 |
| 2022-08-18 10:00:00 | ES | Futures | 4837.43 | 4852.72 | 4831.48 | 4845.64 | 202878.0 |
| 2022-08-18 11:00:00 | ES | Futures | 4845.64 | 4861.79 | 4838.84 | 4855.84 | 159428.0 |
| 2022-08-18 12:00:00 | ES | Futures | 4855.84 | 4858.96 | 4835.44 | 4841.39 | 134508.0 |
| 2022-08-18 13:00:00 | ES | Futures | 4841.39 | 4853.01 | 4839.13 | 4848.19 | 133092.0 |
| 2022-08-18 14:00:00 | ES | Futures | 4848.19 | 4858.39 | 4845.64 | 4855.84 | 109886.0 |
| 2022-08-18 15:00:00 | ES | Futures | 4856.12 | 4867.17 | 4852.16 | 4859.24 | 214268.0 |
| 2022-08-18 16:00:00 | ES | Futures | 4858.96 | 4860.94 | 4854.71 | 4858.96 | 46543.0 |
| 2022-08-18 18:00:00 | ES | Futures | 4857.54 | 4858.67 | 4853.86 | 4855.56 | 3364.0 |
| 2022-08-18 19:00:00 | ES | Futures | 4855.56 | 4856.97 | 4853.86 | 4856.69 | 2751.0 |
| 2022-08-18 20:00:00 | ES | Futures | 4856.69 | 4858.67 | 4848.47 | 4850.46 | 9402.0 |
| 2022-08-18 21:00:00 | ES | Futures | 4850.46 | 4852.72 | 4846.21 | 4851.02 | 6950.0 |
| 2022-08-18 22:00:00 | ES | Futures | 4851.02 | 4855.27 | 4849.04 | 4854.99 | 4885.0 |
| 2022-08-18 23:00:00 | ES | Futures | 4855.27 | 4855.56 | 4848.19 | 4848.47 | 4535.0 |
| 2022-08-18 00:00:00 | NQ | Futures | 15587.09 | 15594.32 | 15575.52 | 15576.97 | 1123.0 |
| 2022-08-18 01:00:00 | NQ | Futures | 15577.26 | 15596.06 | 15561.64 | 15562.8 | 2789.0 |
| 2022-08-18 02:00:00 | NQ | Futures | 15562.51 | 15576.97 | 15520.57 | 15525.2 | 5673.0 |
| 2022-08-18 03:00:00 | NQ | Futures | 15523.75 | 15567.42 | 15515.65 | 15560.19 | 7913.0 |
| 2022-08-18 04:00:00 | NQ | Futures | 15560.77 | 15594.32 | 15549.78 | 15592.88 | 6317.0 |
| 2022-08-18 05:00:00 | NQ | Futures | 15593.46 | 15639.44 | 15588.54 | 15635.68 | 6335.0 |
| 2022-08-18 06:00:00 | NQ | Futures | 15634.53 | 15655.93 | 15612.83 | 15616.59 | 7722.0 |
| 2022-08-18 07:00:00 | NQ | Futures | 15617.46 | 15655.06 | 15609.07 | 15654.48 | 6569.0 |
| 2022-08-18 08:00:00 | NQ | Futures | 15654.77 | 15687.17 | 15616.59 | 15640.6 | 17052.0 |
| 2022-08-18 09:00:00 | NQ | Futures | 15640.31 | 15643.78 | 15543.71 | 15563.66 | 67665.0 |
| 2022-08-18 10:00:00 | NQ | Futures | 15564.53 | 15657.96 | 15529.24 | 15629.9 | 81809.0 |
| 2022-08-18 11:00:00 | NQ | Futures | 15630.19 | 15706.26 | 15603.58 | 15683.12 | 62419.0 |
| 2022-08-18 12:00:00 | NQ | Futures | 15683.41 | 15698.45 | 15600.11 | 15632.21 | 50615.0 |
| 2022-08-18 13:00:00 | NQ | Futures | 15632.5 | 15688.9 | 15620.35 | 15665.77 | 47138.0 |
| 2022-08-18 14:00:00 | NQ | Futures | 15666.05 | 15681.96 | 15635.4 | 15666.92 | 47058.0 |
| 2022-08-18 15:00:00 | NQ | Futures | 15667.21 | 15703.08 | 15632.5 | 15652.17 | 71672.0 |
| 2022-08-18 16:00:00 | NQ | Futures | 15652.17 | 15668.66 | 15646.39 | 15665.19 | 12148.0 |
| 2022-08-18 18:00:00 | NQ | Futures | 15658.53 | 15658.82 | 15644.94 | 15646.96 | 1558.0 |
| 2022-08-18 19:00:00 | NQ | Futures | 15647.54 | 15651.01 | 15639.16 | 15650.44 | 1247.0 |
| 2022-08-18 20:00:00 | NQ | Futures | 15651.01 | 15656.51 | 15613.12 | 15620.64 | 3732.0 |
| 2022-08-18 21:00:00 | NQ | Futures | 15620.64 | 15632.79 | 15606.18 | 15628.45 | 2614.0 |
| 2022-08-18 22:00:00 | NQ | Futures | 15628.45 | 15640.31 | 15623.83 | 15640.02 | 1924.0 |
| 2022-08-18 23:00:00 | NQ | Futures | 15640.31 | 15642.34 | 15616.88 | 15618.91 | 2031.0 |
| 2022-08-18 00:00:00 | YM | Futures | 38300.5 | 38316.3 | 38274.5 | 38275.7 | 395.0 |
| 2022-08-18 01:00:00 | YM | Futures | 38275.7 | 38314.0 | 38255.4 | 38255.4 | 944.0 |
| 2022-08-18 02:00:00 | YM | Futures | 38256.5 | 38287.0 | 38200.1 | 38209.1 | 2393.0 |
| 2022-08-18 03:00:00 | YM | Futures | 38208.0 | 38263.3 | 38202.3 | 38239.6 | 3044.0 |
> showing 50 of 2,032 rows — these rows as CSV