PREVIEW / futures_1hour / 2022-07-12
file: by_date/futures_1hour/2022/2022-07-12.parquet size: 69 KB rows: 2,055
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-07-12 00:00:00 | ES | Futures | 4348.22 | 4348.22 | 4342.55 | 4345.67 | 3349.0 |
| 2022-07-12 01:00:00 | ES | Futures | 4345.67 | 4348.5 | 4343.12 | 4343.97 | 4584.0 |
| 2022-07-12 02:00:00 | ES | Futures | 4343.97 | 4349.07 | 4336.89 | 4345.1 | 12962.0 |
| 2022-07-12 03:00:00 | ES | Futures | 4344.82 | 4348.5 | 4329.24 | 4341.99 | 22260.0 |
| 2022-07-12 04:00:00 | ES | Futures | 4341.99 | 4348.22 | 4337.74 | 4344.82 | 12406.0 |
| 2022-07-12 05:00:00 | ES | Futures | 4344.82 | 4348.22 | 4334.34 | 4337.74 | 14541.0 |
| 2022-07-12 06:00:00 | ES | Futures | 4337.74 | 4350.2 | 4335.19 | 4335.75 | 15884.0 |
| 2022-07-12 07:00:00 | ES | Futures | 4335.47 | 4356.43 | 4334.62 | 4348.78 | 24958.0 |
| 2022-07-12 08:00:00 | ES | Futures | 4348.78 | 4359.55 | 4344.25 | 4355.3 | 30541.0 |
| 2022-07-12 09:00:00 | ES | Futures | 4355.58 | 4392.41 | 4353.03 | 4364.93 | 225361.0 |
| 2022-07-12 10:00:00 | ES | Futures | 4364.65 | 4370.88 | 4351.05 | 4368.61 | 252833.0 |
| 2022-07-12 11:00:00 | ES | Futures | 4368.61 | 4383.34 | 4362.1 | 4371.73 | 166576.0 |
| 2022-07-12 12:00:00 | ES | Futures | 4371.45 | 4382.21 | 4367.2 | 4377.39 | 126338.0 |
| 2022-07-12 13:00:00 | ES | Futures | 4377.68 | 4383.91 | 4364.36 | 4372.86 | 132852.0 |
| 2022-07-12 14:00:00 | ES | Futures | 4372.86 | 4374.0 | 4351.05 | 4351.05 | 116760.0 |
| 2022-07-12 15:00:00 | ES | Futures | 4351.33 | 4351.33 | 4311.11 | 4332.92 | 345437.0 |
| 2022-07-12 16:00:00 | ES | Futures | 4333.2 | 4333.77 | 4326.41 | 4332.35 | 46590.0 |
| 2022-07-12 18:00:00 | ES | Futures | 4334.05 | 4335.75 | 4329.52 | 4331.5 | 7127.0 |
| 2022-07-12 19:00:00 | ES | Futures | 4331.5 | 4337.45 | 4326.97 | 4330.65 | 7732.0 |
| 2022-07-12 20:00:00 | ES | Futures | 4330.94 | 4339.72 | 4329.24 | 4337.45 | 11325.0 |
| 2022-07-12 21:00:00 | ES | Futures | 4337.74 | 4343.69 | 4328.95 | 4332.07 | 11609.0 |
| 2022-07-12 22:00:00 | ES | Futures | 4332.07 | 4340.29 | 4330.09 | 4338.87 | 8103.0 |
| 2022-07-12 23:00:00 | ES | Futures | 4339.44 | 4342.84 | 4337.17 | 4339.72 | 5302.0 |
| 2022-07-12 00:00:00 | NQ | Futures | 13669.73 | 13671.46 | 13648.9 | 13660.76 | 2452.0 |
| 2022-07-12 01:00:00 | NQ | Futures | 13660.76 | 13674.35 | 13650.64 | 13659.02 | 3275.0 |
| 2022-07-12 02:00:00 | NQ | Futures | 13659.02 | 13676.38 | 13624.89 | 13665.39 | 7951.0 |
| 2022-07-12 03:00:00 | NQ | Futures | 13664.52 | 13679.27 | 13603.78 | 13657.29 | 12983.0 |
| 2022-07-12 04:00:00 | NQ | Futures | 13657.58 | 13681.59 | 13636.17 | 13672.91 | 7253.0 |
| 2022-07-12 05:00:00 | NQ | Futures | 13672.62 | 13689.39 | 13647.46 | 13660.18 | 9173.0 |
| 2022-07-12 06:00:00 | NQ | Futures | 13660.47 | 13712.53 | 13659.6 | 13675.51 | 10827.0 |
| 2022-07-12 07:00:00 | NQ | Futures | 13674.93 | 13775.01 | 13670.31 | 13746.37 | 16471.0 |
| 2022-07-12 08:00:00 | NQ | Futures | 13745.8 | 13797.28 | 13728.15 | 13777.03 | 16646.0 |
| 2022-07-12 09:00:00 | NQ | Futures | 13777.03 | 13912.98 | 13716.87 | 13717.16 | 103815.0 |
| 2022-07-12 10:00:00 | NQ | Futures | 13718.03 | 13775.01 | 13657.87 | 13735.67 | 100599.0 |
| 2022-07-12 11:00:00 | NQ | Futures | 13735.96 | 13804.51 | 13713.4 | 13762.86 | 61126.0 |
| 2022-07-12 12:00:00 | NQ | Futures | 13762.57 | 13806.54 | 13739.14 | 13785.42 | 40187.0 |
| 2022-07-12 13:00:00 | NQ | Futures | 13784.55 | 13816.37 | 13728.15 | 13770.96 | 39770.0 |
| 2022-07-12 14:00:00 | NQ | Futures | 13771.54 | 13775.01 | 13684.19 | 13685.63 | 31170.0 |
| 2022-07-12 15:00:00 | NQ | Futures | 13686.21 | 13686.21 | 13550.27 | 13626.92 | 96375.0 |
| 2022-07-12 16:00:00 | NQ | Futures | 13627.21 | 13631.84 | 13609.56 | 13629.81 | 12073.0 |
| 2022-07-12 18:00:00 | NQ | Futures | 13628.94 | 13639.94 | 13615.93 | 13620.85 | 3349.0 |
| 2022-07-12 19:00:00 | NQ | Futures | 13621.42 | 13641.67 | 13606.96 | 13620.56 | 3947.0 |
| 2022-07-12 20:00:00 | NQ | Futures | 13621.71 | 13655.84 | 13616.51 | 13648.32 | 5847.0 |
| 2022-07-12 21:00:00 | NQ | Futures | 13648.9 | 13671.46 | 13619.69 | 13636.46 | 6268.0 |
| 2022-07-12 22:00:00 | NQ | Futures | 13635.89 | 13662.5 | 13626.34 | 13658.45 | 4592.0 |
| 2022-07-12 23:00:00 | NQ | Futures | 13658.16 | 13674.07 | 13651.79 | 13660.18 | 2921.0 |
| 2022-07-12 00:00:00 | YM | Futures | 34977.5 | 34977.5 | 34939.2 | 34962.9 | 633.0 |
| 2022-07-12 01:00:00 | YM | Futures | 34965.1 | 34976.4 | 34942.5 | 34943.7 | 870.0 |
| 2022-07-12 02:00:00 | YM | Futures | 34943.7 | 34984.3 | 34897.4 | 34951.6 | 2366.0 |
| 2022-07-12 03:00:00 | YM | Futures | 34951.6 | 34977.5 | 34841.0 | 34923.4 | 3955.0 |
> showing 50 of 2,055 rows — these rows as CSV