PREVIEW / futures_1hour / 2023-11-22
file: by_date/futures_1hour/2023/2023-11-22.parquet size: 65 KB rows: 1,994
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-11-22 00:00:00 | ES | Futures | 4943.18 | 4945.08 | 4940.19 | 4940.73 | 4614.0 |
| 2023-11-22 01:00:00 | ES | Futures | 4940.73 | 4941.28 | 4937.75 | 4939.92 | 5349.0 |
| 2023-11-22 02:00:00 | ES | Futures | 4939.92 | 4942.91 | 4938.02 | 4941.82 | 7018.0 |
| 2023-11-22 03:00:00 | ES | Futures | 4941.82 | 4945.89 | 4939.65 | 4942.63 | 12756.0 |
| 2023-11-22 04:00:00 | ES | Futures | 4942.36 | 4946.98 | 4941.82 | 4944.26 | 12397.0 |
| 2023-11-22 05:00:00 | ES | Futures | 4944.26 | 4952.41 | 4943.72 | 4952.41 | 14552.0 |
| 2023-11-22 06:00:00 | ES | Futures | 4952.41 | 4954.04 | 4949.15 | 4950.24 | 16960.0 |
| 2023-11-22 07:00:00 | ES | Futures | 4950.51 | 4957.03 | 4949.97 | 4954.85 | 22151.0 |
| 2023-11-22 08:00:00 | ES | Futures | 4954.85 | 4960.56 | 4952.95 | 4958.93 | 47869.0 |
| 2023-11-22 09:00:00 | ES | Futures | 4959.2 | 4975.49 | 4952.68 | 4959.2 | 259969.0 |
| 2023-11-22 10:00:00 | ES | Futures | 4959.2 | 4965.72 | 4947.79 | 4954.85 | 247398.0 |
| 2023-11-22 11:00:00 | ES | Futures | 4954.58 | 4966.26 | 4954.04 | 4965.44 | 125087.0 |
| 2023-11-22 12:00:00 | ES | Futures | 4965.72 | 4970.06 | 4955.67 | 4961.1 | 119269.0 |
| 2023-11-22 13:00:00 | ES | Futures | 4961.1 | 4966.8 | 4960.01 | 4963.27 | 79118.0 |
| 2023-11-22 14:00:00 | ES | Futures | 4963.54 | 4966.8 | 4948.06 | 4958.38 | 141217.0 |
| 2023-11-22 15:00:00 | ES | Futures | 4958.11 | 4964.09 | 4955.94 | 4960.56 | 167852.0 |
| 2023-11-22 16:00:00 | ES | Futures | 4960.29 | 4961.64 | 4958.66 | 4959.47 | 34565.0 |
| 2023-11-22 18:00:00 | ES | Futures | 4957.57 | 4959.2 | 4956.21 | 4957.03 | 3476.0 |
| 2023-11-22 19:00:00 | ES | Futures | 4956.75 | 4958.66 | 4955.4 | 4958.38 | 3064.0 |
| 2023-11-22 20:00:00 | ES | Futures | 4958.11 | 4962.46 | 4957.03 | 4961.91 | 5535.0 |
| 2023-11-22 21:00:00 | ES | Futures | 4962.19 | 4962.19 | 4959.74 | 4960.29 | 3238.0 |
| 2023-11-22 22:00:00 | ES | Futures | 4960.01 | 4960.56 | 4958.38 | 4959.2 | 1905.0 |
| 2023-11-22 23:00:00 | ES | Futures | 4959.2 | 4960.56 | 4958.66 | 4959.47 | 1022.0 |
| 2023-11-22 00:00:00 | NQ | Futures | 17547.2 | 17554.06 | 17534.84 | 17535.94 | 3075.0 |
| 2023-11-22 01:00:00 | NQ | Futures | 17536.21 | 17538.13 | 17519.46 | 17531.82 | 4789.0 |
| 2023-11-22 02:00:00 | NQ | Futures | 17531.82 | 17535.39 | 17515.61 | 17531.82 | 4529.0 |
| 2023-11-22 03:00:00 | NQ | Futures | 17532.09 | 17558.46 | 17525.22 | 17534.84 | 8875.0 |
| 2023-11-22 04:00:00 | NQ | Futures | 17534.29 | 17565.87 | 17528.52 | 17561.75 | 9078.0 |
| 2023-11-22 05:00:00 | NQ | Futures | 17562.03 | 17609.55 | 17559.83 | 17608.45 | 12748.0 |
| 2023-11-22 06:00:00 | NQ | Futures | 17608.17 | 17624.38 | 17599.66 | 17611.74 | 10710.0 |
| 2023-11-22 07:00:00 | NQ | Futures | 17612.02 | 17645.53 | 17607.07 | 17630.15 | 14779.0 |
| 2023-11-22 08:00:00 | NQ | Futures | 17629.87 | 17655.41 | 17626.03 | 17649.65 | 25008.0 |
| 2023-11-22 09:00:00 | NQ | Futures | 17650.2 | 17769.13 | 17616.96 | 17651.57 | 135935.0 |
| 2023-11-22 10:00:00 | NQ | Futures | 17652.12 | 17687.82 | 17584.55 | 17621.63 | 121415.0 |
| 2023-11-22 11:00:00 | NQ | Futures | 17622.18 | 17672.44 | 17616.96 | 17670.52 | 54584.0 |
| 2023-11-22 12:00:00 | NQ | Futures | 17670.52 | 17690.57 | 17642.23 | 17657.34 | 45321.0 |
| 2023-11-22 13:00:00 | NQ | Futures | 17657.61 | 17693.32 | 17652.39 | 17677.39 | 35185.0 |
| 2023-11-22 14:00:00 | NQ | Futures | 17677.66 | 17688.37 | 17591.97 | 17639.48 | 52980.0 |
| 2023-11-22 15:00:00 | NQ | Futures | 17639.48 | 17648.27 | 17626.3 | 17631.24 | 47732.0 |
| 2023-11-22 16:00:00 | NQ | Futures | 17631.24 | 17635.64 | 17620.26 | 17628.5 | 9589.0 |
| 2023-11-22 18:00:00 | NQ | Futures | 17618.88 | 17629.05 | 17616.41 | 17628.5 | 2310.0 |
| 2023-11-22 19:00:00 | NQ | Futures | 17628.77 | 17630.97 | 17620.81 | 17630.42 | 2334.0 |
| 2023-11-22 20:00:00 | NQ | Futures | 17630.42 | 17645.53 | 17628.5 | 17644.15 | 2865.0 |
| 2023-11-22 21:00:00 | NQ | Futures | 17644.7 | 17646.9 | 17635.64 | 17636.74 | 2193.0 |
| 2023-11-22 22:00:00 | NQ | Futures | 17637.01 | 17637.84 | 17629.05 | 17633.17 | 1515.0 |
| 2023-11-22 23:00:00 | NQ | Futures | 17632.89 | 17638.11 | 17630.15 | 17632.62 | 909.0 |
| 2023-11-22 00:00:00 | YM | Futures | 38157.6 | 38167.4 | 38140.3 | 38143.5 | 438.0 |
| 2023-11-22 01:00:00 | YM | Futures | 38142.4 | 38144.6 | 38126.2 | 38140.3 | 1072.0 |
| 2023-11-22 02:00:00 | YM | Futures | 38140.3 | 38166.3 | 38133.7 | 38153.3 | 1430.0 |
| 2023-11-22 03:00:00 | YM | Futures | 38154.4 | 38175.0 | 38141.3 | 38167.4 | 2359.0 |
> showing 50 of 1,994 rows — these rows as CSV