PREVIEW / futures_1hour / 2022-08-30
file: by_date/futures_1hour/2022/2022-08-30.parquet size: 68 KB rows: 2,026
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-30 00:00:00 | ES | Futures | 4579.37 | 4587.58 | 4577.67 | 4583.9 | 7246.0 |
| 2022-08-30 01:00:00 | ES | Futures | 4583.9 | 4585.32 | 4578.52 | 4583.05 | 6328.0 |
| 2022-08-30 02:00:00 | ES | Futures | 4583.05 | 4585.03 | 4576.53 | 4582.77 | 11520.0 |
| 2022-08-30 03:00:00 | ES | Futures | 4582.77 | 4604.29 | 4579.93 | 4597.78 | 30577.0 |
| 2022-08-30 04:00:00 | ES | Futures | 4597.78 | 4614.78 | 4597.78 | 4605.99 | 26122.0 |
| 2022-08-30 05:00:00 | ES | Futures | 4606.28 | 4610.81 | 4599.76 | 4607.98 | 16580.0 |
| 2022-08-30 06:00:00 | ES | Futures | 4607.98 | 4614.78 | 4603.16 | 4603.73 | 16940.0 |
| 2022-08-30 07:00:00 | ES | Futures | 4603.73 | 4607.69 | 4595.23 | 4597.78 | 19824.0 |
| 2022-08-30 08:00:00 | ES | Futures | 4598.06 | 4602.88 | 4583.62 | 4584.18 | 44766.0 |
| 2022-08-30 09:00:00 | ES | Futures | 4584.47 | 4587.58 | 4555.29 | 4559.25 | 249332.0 |
| 2022-08-30 10:00:00 | ES | Futures | 4558.97 | 4565.2 | 4496.65 | 4519.31 | 492406.0 |
| 2022-08-30 11:00:00 | ES | Futures | 4519.31 | 4533.48 | 4512.23 | 4523.28 | 399932.0 |
| 2022-08-30 12:00:00 | ES | Futures | 4523.28 | 4537.44 | 4508.27 | 4514.78 | 210460.0 |
| 2022-08-30 13:00:00 | ES | Futures | 4515.06 | 4519.6 | 4492.12 | 4507.98 | 210152.0 |
| 2022-08-30 14:00:00 | ES | Futures | 4508.27 | 4515.63 | 4501.47 | 4507.42 | 211468.0 |
| 2022-08-30 15:00:00 | ES | Futures | 4507.42 | 4530.64 | 4504.3 | 4516.76 | 426389.0 |
| 2022-08-30 16:00:00 | ES | Futures | 4517.05 | 4523.85 | 4514.21 | 4517.05 | 56580.0 |
| 2022-08-30 18:00:00 | ES | Futures | 4517.9 | 4521.01 | 4513.65 | 4519.6 | 7574.0 |
| 2022-08-30 19:00:00 | ES | Futures | 4519.88 | 4520.73 | 4512.23 | 4518.46 | 6487.0 |
| 2022-08-30 20:00:00 | ES | Futures | 4518.18 | 4532.06 | 4516.48 | 4530.08 | 11985.0 |
| 2022-08-30 21:00:00 | ES | Futures | 4530.36 | 4535.74 | 4526.96 | 4531.49 | 11160.0 |
| 2022-08-30 22:00:00 | ES | Futures | 4531.49 | 4538.86 | 4531.49 | 4535.18 | 7782.0 |
| 2022-08-30 23:00:00 | ES | Futures | 4534.89 | 4548.21 | 4533.76 | 4543.96 | 12082.0 |
| 2022-08-30 00:00:00 | NQ | Futures | 14495.79 | 14537.44 | 14490.01 | 14519.51 | 4953.0 |
| 2022-08-30 01:00:00 | NQ | Futures | 14519.22 | 14526.74 | 14496.66 | 14515.75 | 4089.0 |
| 2022-08-30 02:00:00 | NQ | Futures | 14516.62 | 14531.66 | 14494.93 | 14518.93 | 6092.0 |
| 2022-08-30 03:00:00 | NQ | Futures | 14517.78 | 14599.05 | 14505.63 | 14573.6 | 15405.0 |
| 2022-08-30 04:00:00 | NQ | Futures | 14573.6 | 14645.04 | 14573.6 | 14614.67 | 13585.0 |
| 2022-08-30 05:00:00 | NQ | Futures | 14615.54 | 14634.34 | 14592.69 | 14619.3 | 7900.0 |
| 2022-08-30 06:00:00 | NQ | Futures | 14618.72 | 14637.81 | 14608.6 | 14612.07 | 7052.0 |
| 2022-08-30 07:00:00 | NQ | Futures | 14611.49 | 14621.32 | 14577.65 | 14586.04 | 9542.0 |
| 2022-08-30 08:00:00 | NQ | Futures | 14586.61 | 14608.31 | 14530.21 | 14533.97 | 19263.0 |
| 2022-08-30 09:00:00 | NQ | Futures | 14533.39 | 14562.9 | 14416.54 | 14438.52 | 90969.0 |
| 2022-08-30 10:00:00 | NQ | Futures | 14439.97 | 14458.19 | 14194.98 | 14282.91 | 155149.0 |
| 2022-08-30 11:00:00 | NQ | Futures | 14283.49 | 14324.56 | 14236.92 | 14281.76 | 103975.0 |
| 2022-08-30 12:00:00 | NQ | Futures | 14282.33 | 14341.34 | 14218.99 | 14247.92 | 69545.0 |
| 2022-08-30 13:00:00 | NQ | Futures | 14248.2 | 14265.56 | 14169.82 | 14229.69 | 75392.0 |
| 2022-08-30 14:00:00 | NQ | Futures | 14229.98 | 14258.91 | 14208.29 | 14237.21 | 60550.0 |
| 2022-08-30 15:00:00 | NQ | Futures | 14237.5 | 14329.48 | 14232.01 | 14292.46 | 107934.0 |
| 2022-08-30 16:00:00 | NQ | Futures | 14292.17 | 14323.7 | 14290.14 | 14300.56 | 15591.0 |
| 2022-08-30 18:00:00 | NQ | Futures | 14306.92 | 14314.73 | 14284.94 | 14310.39 | 2683.0 |
| 2022-08-30 19:00:00 | NQ | Futures | 14309.23 | 14315.31 | 14285.23 | 14306.92 | 2590.0 |
| 2022-08-30 20:00:00 | NQ | Futures | 14306.63 | 14361.88 | 14301.42 | 14351.75 | 5625.0 |
| 2022-08-30 21:00:00 | NQ | Futures | 14352.04 | 14378.65 | 14342.21 | 14355.22 | 4940.0 |
| 2022-08-30 22:00:00 | NQ | Futures | 14358.12 | 14382.12 | 14353.78 | 14367.37 | 3147.0 |
| 2022-08-30 23:00:00 | NQ | Futures | 14365.64 | 14407.0 | 14359.27 | 14391.96 | 4775.0 |
| 2022-08-30 00:00:00 | YM | Futures | 36272.9 | 36323.6 | 36265.0 | 36299.9 | 1191.0 |
| 2022-08-30 01:00:00 | YM | Futures | 36299.9 | 36307.8 | 36265.0 | 36289.8 | 1150.0 |
| 2022-08-30 02:00:00 | YM | Futures | 36290.9 | 36303.3 | 36246.9 | 36284.1 | 1577.0 |
| 2022-08-30 03:00:00 | YM | Futures | 36284.1 | 36439.9 | 36269.5 | 36391.3 | 4466.0 |
> showing 50 of 2,026 rows — these rows as CSV