PREVIEW / futures_1hour / 2024-07-01
file: by_date/futures_1hour/2024/2024-07-01.parquet size: 67 KB rows: 2,084
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 |
|---|---|---|---|---|---|---|---|
| 2024-07-01 00:00:00 | ES | Futures | 5805.62 | 5805.88 | 5802.21 | 5803.26 | 3853.0 |
| 2024-07-01 01:00:00 | ES | Futures | 5803.26 | 5808.5 | 5802.47 | 5807.98 | 4759.0 |
| 2024-07-01 02:00:00 | ES | Futures | 5807.98 | 5810.6 | 5807.19 | 5808.24 | 9998.0 |
| 2024-07-01 03:00:00 | ES | Futures | 5808.5 | 5810.6 | 5794.35 | 5797.49 | 24445.0 |
| 2024-07-01 04:00:00 | ES | Futures | 5797.49 | 5805.1 | 5792.77 | 5794.35 | 20430.0 |
| 2024-07-01 05:00:00 | ES | Futures | 5794.35 | 5797.49 | 5789.63 | 5796.97 | 16634.0 |
| 2024-07-01 06:00:00 | ES | Futures | 5796.71 | 5801.43 | 5795.4 | 5800.64 | 10409.0 |
| 2024-07-01 07:00:00 | ES | Futures | 5800.38 | 5805.62 | 5799.59 | 5804.83 | 13111.0 |
| 2024-07-01 08:00:00 | ES | Futures | 5804.57 | 5807.19 | 5799.33 | 5803.52 | 25301.0 |
| 2024-07-01 09:00:00 | ES | Futures | 5803.52 | 5808.77 | 5789.63 | 5797.23 | 171848.0 |
| 2024-07-01 10:00:00 | ES | Futures | 5797.23 | 5804.05 | 5772.33 | 5781.24 | 301520.0 |
| 2024-07-01 11:00:00 | ES | Futures | 5781.5 | 5793.82 | 5776.0 | 5793.56 | 155145.0 |
| 2024-07-01 12:00:00 | ES | Futures | 5793.56 | 5803.52 | 5788.06 | 5800.12 | 126223.0 |
| 2024-07-01 13:00:00 | ES | Futures | 5800.12 | 5802.47 | 5795.66 | 5798.8 | 79069.0 |
| 2024-07-01 14:00:00 | ES | Futures | 5799.07 | 5806.93 | 5794.09 | 5796.97 | 94621.0 |
| 2024-07-01 15:00:00 | ES | Futures | 5796.97 | 5809.03 | 5787.01 | 5803.0 | 206165.0 |
| 2024-07-01 16:00:00 | ES | Futures | 5803.26 | 5804.31 | 5800.38 | 5801.16 | 43439.0 |
| 2024-07-01 18:00:00 | ES | Futures | 5802.74 | 5804.31 | 5799.07 | 5799.33 | 3990.0 |
| 2024-07-01 19:00:00 | ES | Futures | 5799.07 | 5799.59 | 5795.92 | 5797.76 | 3784.0 |
| 2024-07-01 20:00:00 | ES | Futures | 5798.02 | 5799.07 | 5789.63 | 5793.04 | 8066.0 |
| 2024-07-01 21:00:00 | ES | Futures | 5793.3 | 5795.4 | 5791.99 | 5793.56 | 5961.0 |
| 2024-07-01 22:00:00 | ES | Futures | 5793.56 | 5795.13 | 5787.79 | 5790.15 | 5191.0 |
| 2024-07-01 23:00:00 | ES | Futures | 5790.15 | 5790.94 | 5787.53 | 5790.15 | 3832.0 |
| 2024-07-01 00:00:00 | NQ | Futures | 21114.11 | 21115.96 | 21091.94 | 21098.01 | 2855.0 |
| 2024-07-01 01:00:00 | NQ | Futures | 21098.01 | 21127.58 | 21095.11 | 21126.26 | 3308.0 |
| 2024-07-01 02:00:00 | NQ | Futures | 21126.26 | 21140.51 | 21119.13 | 21125.73 | 6264.0 |
| 2024-07-01 03:00:00 | NQ | Futures | 21126.26 | 21135.5 | 21045.74 | 21061.05 | 14404.0 |
| 2024-07-01 04:00:00 | NQ | Futures | 21061.32 | 21107.78 | 21030.17 | 21040.73 | 14175.0 |
| 2024-07-01 05:00:00 | NQ | Futures | 21041.52 | 21057.36 | 21014.59 | 21051.02 | 11242.0 |
| 2024-07-01 06:00:00 | NQ | Futures | 21050.49 | 21074.52 | 21044.69 | 21068.97 | 5657.0 |
| 2024-07-01 07:00:00 | NQ | Futures | 21069.5 | 21100.91 | 21066.86 | 21092.73 | 7894.0 |
| 2024-07-01 08:00:00 | NQ | Futures | 21092.2 | 21108.83 | 21079.79 | 21096.43 | 11886.0 |
| 2024-07-01 09:00:00 | NQ | Futures | 21096.43 | 21110.68 | 20950.97 | 21000.07 | 96175.0 |
| 2024-07-01 10:00:00 | NQ | Futures | 21000.07 | 21066.33 | 20919.82 | 21021.19 | 135215.0 |
| 2024-07-01 11:00:00 | NQ | Futures | 21021.19 | 21093.52 | 20997.17 | 21092.73 | 69172.0 |
| 2024-07-01 12:00:00 | NQ | Futures | 21092.99 | 21146.58 | 21073.46 | 21132.86 | 55247.0 |
| 2024-07-01 13:00:00 | NQ | Futures | 21133.12 | 21139.98 | 21094.84 | 21117.81 | 36891.0 |
| 2024-07-01 14:00:00 | NQ | Futures | 21118.07 | 21172.19 | 21100.12 | 21133.12 | 48019.0 |
| 2024-07-01 15:00:00 | NQ | Futures | 21133.12 | 21196.74 | 21101.44 | 21170.08 | 75572.0 |
| 2024-07-01 16:00:00 | NQ | Futures | 21169.81 | 21181.69 | 21158.73 | 21163.48 | 12192.0 |
| 2024-07-01 18:00:00 | NQ | Futures | 21166.91 | 21176.15 | 21149.22 | 21151.07 | 2608.0 |
| 2024-07-01 19:00:00 | NQ | Futures | 21151.33 | 21152.39 | 21131.27 | 21139.19 | 2859.0 |
| 2024-07-01 20:00:00 | NQ | Futures | 21139.19 | 21146.32 | 21085.87 | 21103.82 | 6790.0 |
| 2024-07-01 21:00:00 | NQ | Futures | 21104.35 | 21118.07 | 21096.16 | 21105.67 | 3410.0 |
| 2024-07-01 22:00:00 | NQ | Futures | 21105.67 | 21110.42 | 21078.21 | 21090.88 | 3251.0 |
| 2024-07-01 23:00:00 | NQ | Futures | 21090.62 | 21100.12 | 21078.74 | 21098.8 | 2990.0 |
| 2024-07-01 00:00:00 | YM | Futures | 41523.7 | 41523.7 | 41510.1 | 41510.1 | 394.0 |
| 2024-07-01 01:00:00 | YM | Futures | 41511.1 | 41552.1 | 41511.1 | 41550.0 | 922.0 |
| 2024-07-01 02:00:00 | YM | Futures | 41548.9 | 41572.0 | 41547.9 | 41565.7 | 1749.0 |
| 2024-07-01 03:00:00 | YM | Futures | 41565.7 | 41593.1 | 41486.9 | 41498.5 | 3776.0 |
> showing 50 of 2,084 rows — these rows as CSV