PREVIEW / futures_1hour / 2022-11-28
file: by_date/futures_1hour/2022/2022-11-28.parquet size: 68 KB rows: 2,059
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-28 00:00:00 | ES | Futures | 4517.91 | 4517.91 | 4507.48 | 4513.12 | 10035.0 |
| 2022-11-28 01:00:00 | ES | Futures | 4513.4 | 4519.88 | 4512.55 | 4519.6 | 8616.0 |
| 2022-11-28 02:00:00 | ES | Futures | 4519.88 | 4524.39 | 4517.06 | 4519.32 | 15974.0 |
| 2022-11-28 03:00:00 | ES | Futures | 4519.32 | 4531.16 | 4518.47 | 4521.86 | 26663.0 |
| 2022-11-28 04:00:00 | ES | Futures | 4521.86 | 4524.11 | 4502.4 | 4504.38 | 25966.0 |
| 2022-11-28 05:00:00 | ES | Futures | 4504.1 | 4512.83 | 4501.56 | 4510.3 | 16687.0 |
| 2022-11-28 06:00:00 | ES | Futures | 4510.3 | 4515.65 | 4506.35 | 4513.4 | 20404.0 |
| 2022-11-28 07:00:00 | ES | Futures | 4513.12 | 4517.06 | 4511.43 | 4514.24 | 16691.0 |
| 2022-11-28 08:00:00 | ES | Futures | 4514.24 | 4516.22 | 4508.04 | 4513.12 | 25902.0 |
| 2022-11-28 09:00:00 | ES | Futures | 4512.83 | 4530.31 | 4505.51 | 4519.32 | 157018.0 |
| 2022-11-28 10:00:00 | ES | Futures | 4519.32 | 4523.83 | 4502.69 | 4504.1 | 189638.0 |
| 2022-11-28 11:00:00 | ES | Futures | 4504.1 | 4510.58 | 4500.43 | 4508.32 | 119582.0 |
| 2022-11-28 12:00:00 | ES | Futures | 4508.32 | 4514.81 | 4493.38 | 4493.95 | 186485.0 |
| 2022-11-28 13:00:00 | ES | Futures | 4494.23 | 4498.46 | 4480.42 | 4481.83 | 108552.0 |
| 2022-11-28 14:00:00 | ES | Futures | 4481.83 | 4484.08 | 4473.37 | 4475.34 | 128966.0 |
| 2022-11-28 15:00:00 | ES | Futures | 4475.62 | 4478.73 | 4465.48 | 4474.78 | 245998.0 |
| 2022-11-28 16:00:00 | ES | Futures | 4474.78 | 4480.13 | 4474.5 | 4478.16 | 49101.0 |
| 2022-11-28 18:00:00 | ES | Futures | 4478.73 | 4479.85 | 4476.19 | 4478.16 | 5446.0 |
| 2022-11-28 19:00:00 | ES | Futures | 4477.88 | 4482.11 | 4475.62 | 4480.42 | 7761.0 |
| 2022-11-28 20:00:00 | ES | Futures | 4480.7 | 4483.52 | 4477.6 | 4482.95 | 9236.0 |
| 2022-11-28 21:00:00 | ES | Futures | 4482.95 | 4484.36 | 4481.54 | 4481.83 | 6658.0 |
| 2022-11-28 22:00:00 | ES | Futures | 4481.83 | 4489.72 | 4480.98 | 4489.16 | 10827.0 |
| 2022-11-28 23:00:00 | ES | Futures | 4489.16 | 4491.97 | 4488.59 | 4490.56 | 5719.0 |
| 2022-11-28 00:00:00 | NQ | Futures | 13430.76 | 13430.76 | 13397.43 | 13412.66 | 4119.0 |
| 2022-11-28 01:00:00 | NQ | Futures | 13412.66 | 13435.07 | 13408.06 | 13434.78 | 3081.0 |
| 2022-11-28 02:00:00 | NQ | Futures | 13435.36 | 13454.03 | 13427.31 | 13430.19 | 6322.0 |
| 2022-11-28 03:00:00 | NQ | Futures | 13429.9 | 13480.47 | 13427.6 | 13450.3 | 11883.0 |
| 2022-11-28 04:00:00 | NQ | Futures | 13449.72 | 13458.92 | 13384.5 | 13391.4 | 11013.0 |
| 2022-11-28 05:00:00 | NQ | Futures | 13391.11 | 13426.16 | 13380.48 | 13419.27 | 7443.0 |
| 2022-11-28 06:00:00 | NQ | Futures | 13419.84 | 13442.83 | 13407.2 | 13442.83 | 6892.0 |
| 2022-11-28 07:00:00 | NQ | Futures | 13442.25 | 13458.34 | 13436.51 | 13449.15 | 6861.0 |
| 2022-11-28 08:00:00 | NQ | Futures | 13448.86 | 13464.09 | 13424.44 | 13463.23 | 11190.0 |
| 2022-11-28 09:00:00 | NQ | Futures | 13463.52 | 13548.56 | 13435.65 | 13512.94 | 66066.0 |
| 2022-11-28 10:00:00 | NQ | Futures | 13513.22 | 13526.15 | 13422.14 | 13429.04 | 75977.0 |
| 2022-11-28 11:00:00 | NQ | Futures | 13429.61 | 13465.82 | 13412.66 | 13458.92 | 42068.0 |
| 2022-11-28 12:00:00 | NQ | Futures | 13459.78 | 13485.64 | 13403.47 | 13409.21 | 56702.0 |
| 2022-11-28 13:00:00 | NQ | Futures | 13409.5 | 13431.62 | 13362.67 | 13365.83 | 40568.0 |
| 2022-11-28 14:00:00 | NQ | Futures | 13366.11 | 13373.01 | 13325.89 | 13347.72 | 45928.0 |
| 2022-11-28 15:00:00 | NQ | Futures | 13348.01 | 13357.21 | 13303.48 | 13344.85 | 65851.0 |
| 2022-11-28 16:00:00 | NQ | Futures | 13344.56 | 13365.54 | 13343.7 | 13358.64 | 10911.0 |
| 2022-11-28 18:00:00 | NQ | Futures | 13360.65 | 13361.23 | 13349.45 | 13352.9 | 2276.0 |
| 2022-11-28 19:00:00 | NQ | Futures | 13353.47 | 13369.56 | 13344.85 | 13364.1 | 3229.0 |
| 2022-11-28 20:00:00 | NQ | Futures | 13363.81 | 13375.02 | 13353.47 | 13373.3 | 3344.0 |
| 2022-11-28 21:00:00 | NQ | Futures | 13372.72 | 13381.92 | 13370.42 | 13372.72 | 3102.0 |
| 2022-11-28 22:00:00 | NQ | Futures | 13372.15 | 13408.35 | 13368.12 | 13405.76 | 4544.0 |
| 2022-11-28 23:00:00 | NQ | Futures | 13406.34 | 13412.95 | 13399.44 | 13409.79 | 2438.0 |
| 2022-11-28 00:00:00 | YM | Futures | 38379.3 | 38379.3 | 38316.4 | 38356.8 | 2023.0 |
| 2022-11-28 01:00:00 | YM | Futures | 38357.9 | 38412.9 | 38355.7 | 38408.4 | 1690.0 |
| 2022-11-28 02:00:00 | YM | Futures | 38409.6 | 38443.2 | 38389.4 | 38411.8 | 2675.0 |
| 2022-11-28 03:00:00 | YM | Futures | 38410.7 | 38479.1 | 38402.8 | 38420.8 | 4925.0 |
> showing 50 of 2,059 rows — these rows as CSV