PREVIEW / futures_1hour / 2022-11-25
file: by_date/futures_1hour/2022/2022-11-25.parquet size: 47 KB rows: 1,333
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-11-25 00:00:00 | ES | Futures | 4558.78 | 4560.19 | 4556.81 | 4557.09 | 2616.0 |
| 2022-11-25 01:00:00 | ES | Futures | 4557.09 | 4559.91 | 4555.96 | 4559.91 | 2611.0 |
| 2022-11-25 02:00:00 | ES | Futures | 4559.63 | 4561.88 | 4556.81 | 4556.81 | 5263.0 |
| 2022-11-25 03:00:00 | ES | Futures | 4556.81 | 4561.6 | 4552.86 | 4555.68 | 12238.0 |
| 2022-11-25 04:00:00 | ES | Futures | 4555.68 | 4558.78 | 4547.23 | 4549.76 | 16057.0 |
| 2022-11-25 05:00:00 | ES | Futures | 4549.48 | 4556.53 | 4546.66 | 4554.27 | 10477.0 |
| 2022-11-25 06:00:00 | ES | Futures | 4554.55 | 4556.53 | 4550.89 | 4552.02 | 10022.0 |
| 2022-11-25 07:00:00 | ES | Futures | 4552.02 | 4557.09 | 4551.45 | 4553.71 | 10184.0 |
| 2022-11-25 08:00:00 | ES | Futures | 4553.43 | 4553.99 | 4544.12 | 4545.25 | 21085.0 |
| 2022-11-25 09:00:00 | ES | Futures | 4545.25 | 4550.61 | 4538.2 | 4549.48 | 102445.0 |
| 2022-11-25 10:00:00 | ES | Futures | 4549.48 | 4553.43 | 4547.51 | 4551.45 | 81641.0 |
| 2022-11-25 11:00:00 | ES | Futures | 4551.45 | 4554.55 | 4544.12 | 4550.04 | 69059.0 |
| 2022-11-25 12:00:00 | ES | Futures | 4550.04 | 4551.17 | 4542.43 | 4547.51 | 76568.0 |
| 2022-11-25 13:00:00 | ES | Futures | 4547.51 | 4549.2 | 4545.82 | 4548.92 | 16818.0 |
| 2022-11-25 00:00:00 | NQ | Futures | 13693.09 | 13697.69 | 13679.87 | 13683.03 | 2047.0 |
| 2022-11-25 01:00:00 | NQ | Futures | 13683.03 | 13686.19 | 13670.97 | 13686.19 | 1813.0 |
| 2022-11-25 02:00:00 | NQ | Futures | 13686.19 | 13697.4 | 13674.99 | 13674.99 | 2856.0 |
| 2022-11-25 03:00:00 | NQ | Futures | 13674.99 | 13684.76 | 13646.83 | 13656.89 | 5669.0 |
| 2022-11-25 04:00:00 | NQ | Futures | 13656.6 | 13667.81 | 13614.94 | 13627.29 | 6790.0 |
| 2022-11-25 05:00:00 | NQ | Futures | 13627.29 | 13647.69 | 13616.37 | 13633.33 | 4711.0 |
| 2022-11-25 06:00:00 | NQ | Futures | 13633.61 | 13640.22 | 13608.62 | 13611.2 | 4956.0 |
| 2022-11-25 07:00:00 | NQ | Futures | 13612.64 | 13625.28 | 13598.85 | 13602.87 | 5365.0 |
| 2022-11-25 08:00:00 | NQ | Futures | 13602.29 | 13617.81 | 13577.87 | 13583.33 | 10408.0 |
| 2022-11-25 09:00:00 | NQ | Futures | 13583.62 | 13587.35 | 13522.99 | 13565.52 | 44037.0 |
| 2022-11-25 10:00:00 | NQ | Futures | 13565.52 | 13593.39 | 13554.02 | 13570.11 | 32590.0 |
| 2022-11-25 11:00:00 | NQ | Futures | 13569.83 | 13590.23 | 13526.44 | 13561.49 | 31182.0 |
| 2022-11-25 12:00:00 | NQ | Futures | 13561.78 | 13566.09 | 13536.21 | 13544.54 | 23261.0 |
| 2022-11-25 13:00:00 | NQ | Futures | 13544.83 | 13549.14 | 13531.33 | 13546.55 | 6075.0 |
| 2022-11-25 00:00:00 | YM | Futures | 38432.0 | 38443.2 | 38424.2 | 38427.5 | 592.0 |
| 2022-11-25 01:00:00 | YM | Futures | 38428.6 | 38443.2 | 38423.0 | 38443.2 | 618.0 |
| 2022-11-25 02:00:00 | YM | Futures | 38444.4 | 38460.1 | 38424.2 | 38425.3 | 1209.0 |
| 2022-11-25 03:00:00 | YM | Futures | 38425.3 | 38471.3 | 38419.7 | 38438.7 | 2598.0 |
| 2022-11-25 04:00:00 | YM | Futures | 38438.7 | 38472.4 | 38401.7 | 38411.8 | 2765.0 |
| 2022-11-25 05:00:00 | YM | Futures | 38412.9 | 38478.0 | 38396.1 | 38463.4 | 2592.0 |
| 2022-11-25 06:00:00 | YM | Futures | 38464.6 | 38474.7 | 38447.7 | 38453.3 | 1760.0 |
| 2022-11-25 07:00:00 | YM | Futures | 38454.5 | 38490.4 | 38450.0 | 38479.1 | 2144.0 |
| 2022-11-25 08:00:00 | YM | Futures | 38478.0 | 38483.6 | 38411.8 | 38417.4 | 3435.0 |
| 2022-11-25 09:00:00 | YM | Futures | 38418.5 | 38545.4 | 38387.1 | 38529.6 | 19919.0 |
| 2022-11-25 10:00:00 | YM | Futures | 38529.6 | 38584.6 | 38517.3 | 38566.7 | 14146.0 |
| 2022-11-25 11:00:00 | YM | Futures | 38566.7 | 38597.0 | 38551.0 | 38580.1 | 8866.0 |
| 2022-11-25 12:00:00 | YM | Futures | 38579.0 | 38591.4 | 38522.9 | 38563.3 | 7550.0 |
| 2022-11-25 13:00:00 | YM | Futures | 38562.2 | 38589.1 | 38548.7 | 38580.1 | 1268.0 |
| 2022-11-25 00:00:00 | CL | Futures | 64.33 | 64.41 | 64.24 | 64.3 | 1365.0 |
| 2022-11-25 01:00:00 | CL | Futures | 64.3 | 64.35 | 64.07 | 64.12 | 1759.0 |
| 2022-11-25 02:00:00 | CL | Futures | 64.12 | 64.34 | 64.09 | 64.21 | 2070.0 |
| 2022-11-25 03:00:00 | CL | Futures | 64.21 | 64.78 | 64.16 | 64.54 | 8063.0 |
| 2022-11-25 04:00:00 | CL | Futures | 64.53 | 65.23 | 64.49 | 65.19 | 10563.0 |
| 2022-11-25 05:00:00 | CL | Futures | 65.19 | 65.33 | 65.04 | 65.24 | 5889.0 |
| 2022-11-25 06:00:00 | CL | Futures | 65.25 | 65.46 | 65.03 | 65.32 | 5747.0 |
| 2022-11-25 07:00:00 | CL | Futures | 65.32 | 65.39 | 65.1 | 65.14 | 4960.0 |
> showing 50 of 1,333 rows — these rows as CSV