PREVIEW / futures_1hour / 2023-06-25
file: by_date/futures_1hour/2023/2023-06-25.parquet size: 19 KB rows: 409
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-06-25 18:00:00 | ES | Futures | 4820.42 | 4828.93 | 4817.68 | 4828.38 | 9397.0 |
| 2023-06-25 19:00:00 | ES | Futures | 4828.38 | 4830.3 | 4827.01 | 4828.93 | 5099.0 |
| 2023-06-25 20:00:00 | ES | Futures | 4829.2 | 4829.48 | 4823.99 | 4828.38 | 9554.0 |
| 2023-06-25 21:00:00 | ES | Futures | 4828.11 | 4832.22 | 4824.26 | 4828.93 | 10457.0 |
| 2023-06-25 22:00:00 | ES | Futures | 4828.93 | 4831.95 | 4828.66 | 4831.13 | 5057.0 |
| 2023-06-25 23:00:00 | ES | Futures | 4831.13 | 4833.87 | 4830.58 | 4831.68 | 6253.0 |
| 2023-06-25 18:00:00 | NQ | Futures | 16752.12 | 16798.84 | 16748.22 | 16797.17 | 5561.0 |
| 2023-06-25 19:00:00 | NQ | Futures | 16797.73 | 16803.85 | 16785.21 | 16799.4 | 3255.0 |
| 2023-06-25 20:00:00 | NQ | Futures | 16799.68 | 16801.07 | 16780.76 | 16791.06 | 4284.0 |
| 2023-06-25 21:00:00 | NQ | Futures | 16791.33 | 16811.64 | 16771.59 | 16798.29 | 5595.0 |
| 2023-06-25 22:00:00 | NQ | Futures | 16797.45 | 16808.58 | 16796.62 | 16804.96 | 2368.0 |
| 2023-06-25 23:00:00 | NQ | Futures | 16805.24 | 16814.7 | 16796.9 | 16801.07 | 2859.0 |
| 2023-06-25 18:00:00 | YM | Futures | 37223.3 | 37289.1 | 37199.2 | 37283.6 | 1422.0 |
| 2023-06-25 19:00:00 | YM | Futures | 37284.7 | 37301.1 | 37277.0 | 37288.0 | 825.0 |
| 2023-06-25 20:00:00 | YM | Futures | 37286.9 | 37292.4 | 37256.2 | 37283.6 | 1017.0 |
| 2023-06-25 21:00:00 | YM | Futures | 37284.7 | 37311.0 | 37265.0 | 37291.3 | 1045.0 |
| 2023-06-25 22:00:00 | YM | Futures | 37289.1 | 37301.1 | 37284.7 | 37295.6 | 384.0 |
| 2023-06-25 23:00:00 | YM | Futures | 37296.7 | 37316.5 | 37295.6 | 37302.2 | 640.0 |
| 2023-06-25 18:00:00 | CL | Futures | 56.67 | 56.89 | 56.32 | 56.83 | 4754.0 |
| 2023-06-25 19:00:00 | CL | Futures | 56.84 | 56.84 | 56.74 | 56.75 | 1136.0 |
| 2023-06-25 20:00:00 | CL | Futures | 56.77 | 56.8 | 56.55 | 56.69 | 1944.0 |
| 2023-06-25 21:00:00 | CL | Futures | 56.68 | 56.69 | 56.26 | 56.27 | 7561.0 |
| 2023-06-25 22:00:00 | CL | Futures | 56.27 | 56.45 | 56.24 | 56.26 | 3332.0 |
| 2023-06-25 23:00:00 | CL | Futures | 56.26 | 56.28 | 56.0 | 56.13 | 4023.0 |
| 2023-06-25 18:00:00 | GC | Futures | 2205.7 | 2205.8 | 2201.1 | 2203.6 | 3420.0 |
| 2023-06-25 19:00:00 | GC | Futures | 2203.5 | 2204.6 | 2202.6 | 2204.3 | 1478.0 |
| 2023-06-25 20:00:00 | GC | Futures | 2204.3 | 2206.4 | 2203.5 | 2205.6 | 2415.0 |
| 2023-06-25 21:00:00 | GC | Futures | 2205.6 | 2208.1 | 2204.2 | 2204.7 | 5379.0 |
| 2023-06-25 22:00:00 | GC | Futures | 2204.6 | 2206.1 | 2203.2 | 2203.4 | 3274.0 |
| 2023-06-25 23:00:00 | GC | Futures | 2203.4 | 2206.0 | 2203.2 | 2204.4 | 1605.0 |
| 2023-06-25 18:00:00 | ZN | Futures | 115.351331 | 115.446926 | 115.335398 | 115.399128 | 13127.0 |
| 2023-06-25 19:00:00 | ZN | Futures | 115.399128 | 115.446926 | 115.383196 | 115.399128 | 5057.0 |
| 2023-06-25 20:00:00 | ZN | Futures | 115.399128 | 115.478791 | 115.383196 | 115.415061 | 10203.0 |
| 2023-06-25 21:00:00 | ZN | Futures | 115.430993 | 115.446926 | 115.367263 | 115.383196 | 9995.0 |
| 2023-06-25 22:00:00 | ZN | Futures | 115.383196 | 115.399128 | 115.335398 | 115.367263 | 10581.0 |
| 2023-06-25 23:00:00 | ZN | Futures | 115.367263 | 115.399128 | 115.351331 | 115.399128 | 6792.0 |
> showing 36 of 409 rows — these rows as CSV