PREVIEW / futures_1hour / 2024-06-26
file: by_date/futures_1hour/2024/2024-06-26.parquet size: 67 KB rows: 2,069
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-06-26 00:00:00 | ES | Futures | 5809.29 | 5811.39 | 5807.72 | 5810.08 | 3166.0 |
| 2024-06-26 01:00:00 | ES | Futures | 5810.34 | 5813.49 | 5810.08 | 5812.7 | 5162.0 |
| 2024-06-26 02:00:00 | ES | Futures | 5812.7 | 5815.58 | 5811.91 | 5812.17 | 7468.0 |
| 2024-06-26 03:00:00 | ES | Futures | 5812.17 | 5821.35 | 5809.82 | 5821.09 | 19361.0 |
| 2024-06-26 04:00:00 | ES | Futures | 5821.09 | 5821.87 | 5817.68 | 5818.73 | 11192.0 |
| 2024-06-26 05:00:00 | ES | Futures | 5818.47 | 5819.25 | 5812.17 | 5812.17 | 11417.0 |
| 2024-06-26 06:00:00 | ES | Futures | 5812.17 | 5813.22 | 5806.41 | 5806.93 | 14010.0 |
| 2024-06-26 07:00:00 | ES | Futures | 5806.93 | 5807.72 | 5801.43 | 5806.14 | 21071.0 |
| 2024-06-26 08:00:00 | ES | Futures | 5806.14 | 5806.14 | 5792.25 | 5793.3 | 36950.0 |
| 2024-06-26 09:00:00 | ES | Futures | 5793.3 | 5799.33 | 5786.48 | 5796.18 | 145412.0 |
| 2024-06-26 10:00:00 | ES | Futures | 5796.18 | 5803.79 | 5790.94 | 5797.49 | 144257.0 |
| 2024-06-26 11:00:00 | ES | Futures | 5797.23 | 5811.13 | 5784.65 | 5809.29 | 157254.0 |
| 2024-06-26 12:00:00 | ES | Futures | 5809.29 | 5810.6 | 5798.02 | 5803.26 | 101359.0 |
| 2024-06-26 13:00:00 | ES | Futures | 5803.26 | 5805.88 | 5795.13 | 5804.05 | 79540.0 |
| 2024-06-26 14:00:00 | ES | Futures | 5804.05 | 5806.93 | 5798.28 | 5801.16 | 76564.0 |
| 2024-06-26 15:00:00 | ES | Futures | 5801.16 | 5818.99 | 5796.44 | 5811.13 | 184880.0 |
| 2024-06-26 16:00:00 | ES | Futures | 5811.39 | 5811.65 | 5797.76 | 5802.74 | 81958.0 |
| 2024-06-26 18:00:00 | ES | Futures | 5802.21 | 5805.36 | 5796.97 | 5798.54 | 6176.0 |
| 2024-06-26 19:00:00 | ES | Futures | 5798.28 | 5798.54 | 5791.73 | 5794.09 | 5266.0 |
| 2024-06-26 20:00:00 | ES | Futures | 5794.09 | 5794.09 | 5784.12 | 5788.58 | 8740.0 |
| 2024-06-26 21:00:00 | ES | Futures | 5788.58 | 5793.82 | 5788.06 | 5793.3 | 6603.0 |
| 2024-06-26 22:00:00 | ES | Futures | 5793.56 | 5796.44 | 5793.04 | 5793.82 | 3713.0 |
| 2024-06-26 23:00:00 | ES | Futures | 5793.82 | 5794.61 | 5790.42 | 5790.94 | 2635.0 |
| 2024-06-26 00:00:00 | NQ | Futures | 21108.57 | 21117.54 | 21099.33 | 21109.89 | 2154.0 |
| 2024-06-26 01:00:00 | NQ | Futures | 21110.15 | 21136.29 | 21109.89 | 21133.65 | 3518.0 |
| 2024-06-26 02:00:00 | NQ | Futures | 21134.18 | 21143.15 | 21124.14 | 21129.69 | 4277.0 |
| 2024-06-26 03:00:00 | NQ | Futures | 21129.42 | 21191.72 | 21108.83 | 21190.14 | 12201.0 |
| 2024-06-26 04:00:00 | NQ | Futures | 21190.14 | 21193.04 | 21164.8 | 21168.23 | 7111.0 |
| 2024-06-26 05:00:00 | NQ | Futures | 21167.96 | 21170.6 | 21141.83 | 21142.62 | 7280.0 |
| 2024-06-26 06:00:00 | NQ | Futures | 21141.83 | 21146.32 | 21110.15 | 21115.96 | 9570.0 |
| 2024-06-26 07:00:00 | NQ | Futures | 21115.96 | 21128.63 | 21098.27 | 21118.07 | 9855.0 |
| 2024-06-26 08:00:00 | NQ | Futures | 21117.54 | 21117.54 | 21044.95 | 21049.96 | 18857.0 |
| 2024-06-26 09:00:00 | NQ | Futures | 21048.91 | 21118.34 | 21014.06 | 21089.03 | 83821.0 |
| 2024-06-26 10:00:00 | NQ | Futures | 21087.45 | 21143.94 | 21060.0 | 21091.67 | 87222.0 |
| 2024-06-26 11:00:00 | NQ | Futures | 21091.94 | 21148.17 | 21025.68 | 21138.66 | 84744.0 |
| 2024-06-26 12:00:00 | NQ | Futures | 21138.66 | 21140.51 | 21059.73 | 21091.15 | 49419.0 |
| 2024-06-26 13:00:00 | NQ | Futures | 21091.15 | 21108.83 | 21050.23 | 21102.23 | 41106.0 |
| 2024-06-26 14:00:00 | NQ | Futures | 21102.5 | 21104.35 | 21063.96 | 21066.86 | 39395.0 |
| 2024-06-26 15:00:00 | NQ | Futures | 21067.65 | 21147.64 | 21041.78 | 21123.62 | 71684.0 |
| 2024-06-26 16:00:00 | NQ | Futures | 21123.62 | 21125.46 | 21034.39 | 21069.76 | 31251.0 |
| 2024-06-26 18:00:00 | NQ | Futures | 21061.58 | 21079.53 | 21039.93 | 21045.48 | 4322.0 |
| 2024-06-26 19:00:00 | NQ | Futures | 21045.74 | 21046.27 | 21019.87 | 21032.81 | 3816.0 |
| 2024-06-26 20:00:00 | NQ | Futures | 21032.81 | 21033.33 | 20985.82 | 21006.41 | 5662.0 |
| 2024-06-26 21:00:00 | NQ | Futures | 21006.41 | 21036.77 | 21006.14 | 21033.6 | 4003.0 |
| 2024-06-26 22:00:00 | NQ | Futures | 21033.86 | 21051.02 | 21032.28 | 21038.09 | 3411.0 |
| 2024-06-26 23:00:00 | NQ | Futures | 21038.61 | 21043.63 | 21023.3 | 21025.15 | 1818.0 |
| 2024-06-26 00:00:00 | YM | Futures | 41515.3 | 41529.0 | 41509.0 | 41522.7 | 618.0 |
| 2024-06-26 01:00:00 | YM | Futures | 41523.7 | 41538.4 | 41522.7 | 41535.3 | 911.0 |
| 2024-06-26 02:00:00 | YM | Futures | 41535.3 | 41545.8 | 41514.3 | 41515.3 | 2063.0 |
| 2024-06-26 03:00:00 | YM | Futures | 41514.3 | 41561.5 | 41510.1 | 41561.5 | 2834.0 |
> showing 50 of 2,069 rows — these rows as CSV