PREVIEW / futures_1hour / 2023-03-26
file: by_date/futures_1hour/2023/2023-03-26.parquet size: 19 KB rows: 419
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-03-26 18:00:00 | ES | Futures | 4446.53 | 4460.67 | 4444.87 | 4459.01 | 15038.0 |
| 2023-03-26 19:00:00 | ES | Futures | 4459.01 | 4467.89 | 4457.07 | 4464.28 | 13306.0 |
| 2023-03-26 20:00:00 | ES | Futures | 4464.56 | 4464.83 | 4450.97 | 4455.68 | 14625.0 |
| 2023-03-26 21:00:00 | ES | Futures | 4455.68 | 4457.07 | 4450.41 | 4453.74 | 8656.0 |
| 2023-03-26 22:00:00 | ES | Futures | 4453.74 | 4457.35 | 4453.19 | 4454.85 | 6221.0 |
| 2023-03-26 23:00:00 | ES | Futures | 4454.85 | 4464.56 | 4454.3 | 4462.62 | 8568.0 |
| 2023-03-26 18:00:00 | NQ | Futures | 14546.16 | 14576.0 | 14530.95 | 14566.15 | 6045.0 |
| 2023-03-26 19:00:00 | NQ | Futures | 14566.15 | 14595.99 | 14561.92 | 14581.91 | 4511.0 |
| 2023-03-26 20:00:00 | NQ | Futures | 14582.48 | 14583.6 | 14541.65 | 14552.35 | 5304.0 |
| 2023-03-26 21:00:00 | NQ | Futures | 14552.35 | 14560.23 | 14536.02 | 14541.93 | 4084.0 |
| 2023-03-26 22:00:00 | NQ | Futures | 14541.93 | 14556.29 | 14539.4 | 14552.91 | 2257.0 |
| 2023-03-26 23:00:00 | NQ | Futures | 14553.19 | 14597.12 | 14550.38 | 14585.57 | 4232.0 |
| 2023-03-26 18:00:00 | YM | Futures | 35907.0 | 35999.9 | 35882.7 | 35992.2 | 1964.0 |
| 2023-03-26 19:00:00 | YM | Futures | 35993.3 | 36072.8 | 35977.8 | 36038.6 | 2294.0 |
| 2023-03-26 20:00:00 | YM | Futures | 36039.7 | 36041.9 | 35942.4 | 35983.3 | 1726.0 |
| 2023-03-26 21:00:00 | YM | Futures | 35981.1 | 35994.4 | 35942.4 | 35966.7 | 1103.0 |
| 2023-03-26 22:00:00 | YM | Futures | 35968.9 | 35989.9 | 35965.6 | 35976.7 | 767.0 |
| 2023-03-26 23:00:00 | YM | Futures | 35976.7 | 36033.1 | 35972.3 | 36014.3 | 1084.0 |
| 2023-03-26 18:00:00 | CL | Futures | 56.3 | 56.71 | 56.25 | 56.52 | 3154.0 |
| 2023-03-26 19:00:00 | CL | Futures | 56.51 | 56.7 | 56.41 | 56.51 | 1802.0 |
| 2023-03-26 20:00:00 | CL | Futures | 56.51 | 56.63 | 56.37 | 56.39 | 2158.0 |
| 2023-03-26 21:00:00 | CL | Futures | 56.4 | 56.44 | 56.12 | 56.12 | 3310.0 |
| 2023-03-26 22:00:00 | CL | Futures | 56.12 | 56.26 | 56.07 | 56.18 | 1677.0 |
| 2023-03-26 23:00:00 | CL | Futures | 56.18 | 56.24 | 56.07 | 56.21 | 1373.0 |
| 2023-03-26 18:00:00 | GC | Futures | 2300.3 | 2301.7 | 2289.0 | 2293.9 | 1034.0 |
| 2023-03-26 19:00:00 | GC | Futures | 2294.0 | 2297.1 | 2293.1 | 2295.9 | 568.0 |
| 2023-03-26 20:00:00 | GC | Futures | 2295.7 | 2296.1 | 2292.1 | 2293.1 | 680.0 |
| 2023-03-26 21:00:00 | GC | Futures | 2292.9 | 2298.6 | 2290.7 | 2293.1 | 1437.0 |
| 2023-03-26 22:00:00 | GC | Futures | 2293.1 | 2296.1 | 2292.2 | 2296.0 | 1247.0 |
| 2023-03-26 23:00:00 | GC | Futures | 2295.6 | 2296.0 | 2293.1 | 2293.3 | 638.0 |
| 2023-03-26 18:00:00 | ZN | Futures | 119.165921 | 119.181949 | 118.877422 | 118.973589 | 16901.0 |
| 2023-03-26 19:00:00 | ZN | Futures | 118.957561 | 119.037699 | 118.89345 | 118.925506 | 5250.0 |
| 2023-03-26 20:00:00 | ZN | Futures | 118.941533 | 119.133866 | 118.925506 | 119.005644 | 12319.0 |
| 2023-03-26 21:00:00 | ZN | Futures | 119.005644 | 119.197976 | 118.989616 | 119.069755 | 9568.0 |
| 2023-03-26 22:00:00 | ZN | Futures | 119.085783 | 119.133866 | 119.037699 | 119.053727 | 7028.0 |
| 2023-03-26 23:00:00 | ZN | Futures | 119.069755 | 119.133866 | 119.053727 | 119.10181 | 4429.0 |
> showing 36 of 419 rows — these rows as CSV