PREVIEW / futures_1hour / 2024-10-23
file: by_date/futures_1hour/2024/2024-10-23.parquet size: 67 KB rows: 2,108
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-10-23 00:00:00 | ES | Futures | 6110.74 | 6113.07 | 6110.22 | 6112.55 | 1726.0 |
| 2024-10-23 01:00:00 | ES | Futures | 6112.55 | 6113.59 | 6110.48 | 6111.0 | 2713.0 |
| 2024-10-23 02:00:00 | ES | Futures | 6111.0 | 6111.26 | 6108.14 | 6109.7 | 6415.0 |
| 2024-10-23 03:00:00 | ES | Futures | 6109.96 | 6118.26 | 6108.92 | 6112.55 | 11680.0 |
| 2024-10-23 04:00:00 | ES | Futures | 6112.3 | 6114.89 | 6106.59 | 6107.1 | 10911.0 |
| 2024-10-23 05:00:00 | ES | Futures | 6106.85 | 6110.22 | 6104.77 | 6105.81 | 8526.0 |
| 2024-10-23 06:00:00 | ES | Futures | 6105.81 | 6106.33 | 6099.32 | 6101.91 | 14215.0 |
| 2024-10-23 07:00:00 | ES | Futures | 6101.65 | 6105.29 | 6100.1 | 6102.95 | 11786.0 |
| 2024-10-23 08:00:00 | ES | Futures | 6102.95 | 6105.55 | 6094.39 | 6095.69 | 23414.0 |
| 2024-10-23 09:00:00 | ES | Futures | 6095.95 | 6098.54 | 6090.75 | 6093.87 | 110903.0 |
| 2024-10-23 10:00:00 | ES | Futures | 6093.61 | 6098.02 | 6081.15 | 6085.56 | 187347.0 |
| 2024-10-23 11:00:00 | ES | Futures | 6085.82 | 6088.42 | 6067.66 | 6079.08 | 190635.0 |
| 2024-10-23 12:00:00 | ES | Futures | 6079.08 | 6079.08 | 6055.72 | 6060.91 | 151298.0 |
| 2024-10-23 13:00:00 | ES | Futures | 6061.17 | 6061.17 | 6037.03 | 6038.07 | 155901.0 |
| 2024-10-23 14:00:00 | ES | Futures | 6038.33 | 6051.83 | 6021.98 | 6051.05 | 191079.0 |
| 2024-10-23 15:00:00 | ES | Futures | 6051.05 | 6061.69 | 6046.12 | 6059.61 | 219787.0 |
| 2024-10-23 16:00:00 | ES | Futures | 6059.61 | 6069.73 | 6056.76 | 6064.54 | 82614.0 |
| 2024-10-23 18:00:00 | ES | Futures | 6066.62 | 6068.18 | 6062.99 | 6065.06 | 5326.0 |
| 2024-10-23 19:00:00 | ES | Futures | 6064.8 | 6066.36 | 6060.91 | 6065.32 | 2718.0 |
| 2024-10-23 20:00:00 | ES | Futures | 6065.32 | 6075.44 | 6061.95 | 6075.18 | 8360.0 |
| 2024-10-23 21:00:00 | ES | Futures | 6074.92 | 6074.92 | 6071.55 | 6072.85 | 6171.0 |
| 2024-10-23 22:00:00 | ES | Futures | 6072.59 | 6076.22 | 6068.95 | 6074.92 | 5626.0 |
| 2024-10-23 23:00:00 | ES | Futures | 6074.92 | 6077.52 | 6072.33 | 6072.59 | 4329.0 |
| 2024-10-23 00:00:00 | NQ | Futures | 21407.07 | 21417.25 | 21403.68 | 21414.64 | 1404.0 |
| 2024-10-23 01:00:00 | NQ | Futures | 21413.86 | 21424.03 | 21401.59 | 21402.38 | 1916.0 |
| 2024-10-23 02:00:00 | NQ | Futures | 21403.16 | 21407.59 | 21389.07 | 21396.11 | 2577.0 |
| 2024-10-23 03:00:00 | NQ | Futures | 21396.38 | 21439.17 | 21390.11 | 21401.59 | 6723.0 |
| 2024-10-23 04:00:00 | NQ | Futures | 21400.29 | 21415.94 | 21377.85 | 21383.07 | 4828.0 |
| 2024-10-23 05:00:00 | NQ | Futures | 21383.07 | 21400.81 | 21367.15 | 21378.63 | 5970.0 |
| 2024-10-23 06:00:00 | NQ | Futures | 21378.37 | 21379.94 | 21341.06 | 21350.72 | 6803.0 |
| 2024-10-23 07:00:00 | NQ | Futures | 21349.93 | 21378.89 | 21346.54 | 21364.81 | 6977.0 |
| 2024-10-23 08:00:00 | NQ | Futures | 21364.81 | 21389.07 | 21335.84 | 21347.59 | 13029.0 |
| 2024-10-23 09:00:00 | NQ | Futures | 21347.59 | 21355.93 | 21298.53 | 21324.89 | 68771.0 |
| 2024-10-23 10:00:00 | NQ | Futures | 21324.89 | 21350.72 | 21234.09 | 21282.1 | 100573.0 |
| 2024-10-23 11:00:00 | NQ | Futures | 21282.62 | 21309.49 | 21189.21 | 21247.13 | 78555.0 |
| 2024-10-23 12:00:00 | NQ | Futures | 21246.61 | 21246.61 | 21115.63 | 21132.33 | 64200.0 |
| 2024-10-23 13:00:00 | NQ | Futures | 21132.59 | 21132.59 | 20999.53 | 21004.75 | 67561.0 |
| 2024-10-23 14:00:00 | NQ | Futures | 21003.96 | 21070.5 | 20955.43 | 21058.23 | 64944.0 |
| 2024-10-23 15:00:00 | NQ | Futures | 21057.97 | 21114.33 | 21022.23 | 21100.76 | 70838.0 |
| 2024-10-23 16:00:00 | NQ | Futures | 21100.5 | 21185.56 | 21087.98 | 21159.47 | 25459.0 |
| 2024-10-23 18:00:00 | NQ | Futures | 21180.08 | 21184.51 | 21160.77 | 21171.99 | 3052.0 |
| 2024-10-23 19:00:00 | NQ | Futures | 21173.03 | 21180.86 | 21152.68 | 21175.64 | 2297.0 |
| 2024-10-23 20:00:00 | NQ | Futures | 21175.9 | 21226.0 | 21161.03 | 21225.22 | 5496.0 |
| 2024-10-23 21:00:00 | NQ | Futures | 21223.65 | 21225.22 | 21208.78 | 21212.95 | 3905.0 |
| 2024-10-23 22:00:00 | NQ | Futures | 21212.17 | 21225.74 | 21196.78 | 21217.91 | 3229.0 |
| 2024-10-23 23:00:00 | NQ | Futures | 21219.22 | 21231.48 | 21206.17 | 21207.21 | 3698.0 |
| 2024-10-23 00:00:00 | YM | Futures | 44784.6 | 44811.7 | 44782.5 | 44808.5 | 299.0 |
| 2024-10-23 01:00:00 | YM | Futures | 44808.5 | 44811.7 | 44792.9 | 44796.1 | 350.0 |
| 2024-10-23 02:00:00 | YM | Futures | 44799.2 | 44803.3 | 44768.0 | 44771.1 | 1089.0 |
| 2024-10-23 03:00:00 | YM | Futures | 44772.1 | 44820.0 | 44770.0 | 44780.4 | 1733.0 |
> showing 50 of 2,108 rows — these rows as CSV