PREVIEW / futures_1hour / 2023-04-25
file: by_date/futures_1hour/2023/2023-04-25.parquet size: 69 KB rows: 2,061
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-04-25 00:00:00 | ES | Futures | 4602.12 | 4602.96 | 4598.52 | 4599.91 | 8425.0 |
| 2023-04-25 01:00:00 | ES | Futures | 4599.91 | 4602.4 | 4597.41 | 4601.29 | 8342.0 |
| 2023-04-25 02:00:00 | ES | Futures | 4601.29 | 4604.07 | 4598.24 | 4602.4 | 9261.0 |
| 2023-04-25 03:00:00 | ES | Futures | 4602.4 | 4603.51 | 4588.26 | 4591.86 | 32552.0 |
| 2023-04-25 04:00:00 | ES | Futures | 4591.86 | 4594.64 | 4581.88 | 4590.48 | 28694.0 |
| 2023-04-25 05:00:00 | ES | Futures | 4590.48 | 4592.42 | 4587.7 | 4592.14 | 11050.0 |
| 2023-04-25 06:00:00 | ES | Futures | 4592.14 | 4594.36 | 4588.26 | 4593.53 | 14269.0 |
| 2023-04-25 07:00:00 | ES | Futures | 4593.53 | 4596.86 | 4589.92 | 4593.8 | 16319.0 |
| 2023-04-25 08:00:00 | ES | Futures | 4593.53 | 4597.96 | 4591.86 | 4593.25 | 20411.0 |
| 2023-04-25 09:00:00 | ES | Futures | 4593.25 | 4597.69 | 4584.93 | 4587.7 | 174238.0 |
| 2023-04-25 10:00:00 | ES | Futures | 4587.7 | 4593.53 | 4574.67 | 4582.43 | 252264.0 |
| 2023-04-25 11:00:00 | ES | Futures | 4582.71 | 4589.09 | 4572.73 | 4573.56 | 192575.0 |
| 2023-04-25 12:00:00 | ES | Futures | 4573.56 | 4576.61 | 4566.9 | 4569.4 | 121989.0 |
| 2023-04-25 13:00:00 | ES | Futures | 4569.4 | 4572.17 | 4548.6 | 4550.26 | 210041.0 |
| 2023-04-25 14:00:00 | ES | Futures | 4550.26 | 4555.25 | 4545.82 | 4546.65 | 170439.0 |
| 2023-04-25 15:00:00 | ES | Futures | 4546.65 | 4555.81 | 4540.0 | 4541.38 | 276232.0 |
| 2023-04-25 16:00:00 | ES | Futures | 4541.38 | 4559.14 | 4539.17 | 4558.86 | 114125.0 |
| 2023-04-25 18:00:00 | ES | Futures | 4559.97 | 4566.62 | 4557.75 | 4561.08 | 20491.0 |
| 2023-04-25 19:00:00 | ES | Futures | 4561.08 | 4562.19 | 4558.03 | 4561.08 | 6814.0 |
| 2023-04-25 20:00:00 | ES | Futures | 4561.08 | 4564.4 | 4557.47 | 4563.02 | 10765.0 |
| 2023-04-25 21:00:00 | ES | Futures | 4563.02 | 4565.24 | 4561.91 | 4563.57 | 9633.0 |
| 2023-04-25 22:00:00 | ES | Futures | 4563.57 | 4565.24 | 4561.63 | 4565.24 | 6051.0 |
| 2023-04-25 23:00:00 | ES | Futures | 4565.24 | 4565.24 | 4558.58 | 4559.14 | 6149.0 |
| 2023-04-25 00:00:00 | NQ | Futures | 14654.27 | 14659.34 | 14645.82 | 14651.74 | 3670.0 |
| 2023-04-25 01:00:00 | NQ | Futures | 14651.46 | 14663.28 | 14640.48 | 14659.06 | 4607.0 |
| 2023-04-25 02:00:00 | NQ | Futures | 14658.78 | 14671.45 | 14643.85 | 14659.9 | 5048.0 |
| 2023-04-25 03:00:00 | NQ | Futures | 14659.62 | 14665.82 | 14620.49 | 14627.81 | 12585.0 |
| 2023-04-25 04:00:00 | NQ | Futures | 14628.37 | 14647.51 | 14603.31 | 14632.87 | 12369.0 |
| 2023-04-25 05:00:00 | NQ | Futures | 14633.15 | 14644.98 | 14622.74 | 14644.14 | 5233.0 |
| 2023-04-25 06:00:00 | NQ | Futures | 14643.85 | 14655.4 | 14630.34 | 14646.67 | 6576.0 |
| 2023-04-25 07:00:00 | NQ | Futures | 14646.67 | 14661.31 | 14635.69 | 14643.85 | 6830.0 |
| 2023-04-25 08:00:00 | NQ | Futures | 14643.57 | 14657.09 | 14631.75 | 14639.63 | 9352.0 |
| 2023-04-25 09:00:00 | NQ | Futures | 14639.07 | 14658.21 | 14602.47 | 14617.39 | 78572.0 |
| 2023-04-25 10:00:00 | NQ | Futures | 14617.11 | 14642.73 | 14561.92 | 14585.57 | 104210.0 |
| 2023-04-25 11:00:00 | NQ | Futures | 14585.57 | 14612.6 | 14546.16 | 14550.94 | 82750.0 |
| 2023-04-25 12:00:00 | NQ | Futures | 14551.22 | 14554.88 | 14513.78 | 14535.17 | 57744.0 |
| 2023-04-25 13:00:00 | NQ | Futures | 14535.46 | 14556.01 | 14476.61 | 14483.93 | 77709.0 |
| 2023-04-25 14:00:00 | NQ | Futures | 14484.21 | 14496.6 | 14450.43 | 14463.1 | 65900.0 |
| 2023-04-25 15:00:00 | NQ | Futures | 14463.66 | 14487.87 | 14422.27 | 14425.09 | 75518.0 |
| 2023-04-25 16:00:00 | NQ | Futures | 14425.37 | 14576.0 | 14415.51 | 14549.25 | 58147.0 |
| 2023-04-25 18:00:00 | NQ | Futures | 14573.18 | 14632.59 | 14554.04 | 14602.47 | 18837.0 |
| 2023-04-25 19:00:00 | NQ | Futures | 14603.03 | 14605.0 | 14588.11 | 14595.99 | 5645.0 |
| 2023-04-25 20:00:00 | NQ | Futures | 14595.71 | 14628.09 | 14585.01 | 14619.92 | 7489.0 |
| 2023-04-25 21:00:00 | NQ | Futures | 14619.92 | 14636.82 | 14617.67 | 14623.58 | 6355.0 |
| 2023-04-25 22:00:00 | NQ | Futures | 14623.3 | 14632.87 | 14614.29 | 14632.31 | 4037.0 |
| 2023-04-25 23:00:00 | NQ | Futures | 14632.31 | 14633.44 | 14606.97 | 14607.25 | 3241.0 |
| 2023-04-25 00:00:00 | YM | Futures | 37523.0 | 37526.3 | 37499.8 | 37507.5 | 1351.0 |
| 2023-04-25 01:00:00 | YM | Futures | 37506.4 | 37523.0 | 37488.7 | 37513.1 | 1742.0 |
| 2023-04-25 02:00:00 | YM | Futures | 37512.0 | 37530.7 | 37496.5 | 37523.0 | 2198.0 |
| 2023-04-25 03:00:00 | YM | Futures | 37523.0 | 37528.5 | 37403.6 | 37432.4 | 6853.0 |
> showing 50 of 2,061 rows — these rows as CSV