PREVIEW / futures_1hour / 2024-02-04
file: by_date/futures_1hour/2024/2024-02-04.parquet size: 20 KB rows: 442
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-02-04 18:00:00 | ES | Futures | 5346.03 | 5351.13 | 5342.8 | 5346.83 | 10888.0 |
| 2024-02-04 19:00:00 | ES | Futures | 5346.56 | 5350.32 | 5334.21 | 5337.7 | 20328.0 |
| 2024-02-04 20:00:00 | ES | Futures | 5337.97 | 5339.85 | 5333.4 | 5339.58 | 9556.0 |
| 2024-02-04 21:00:00 | ES | Futures | 5339.31 | 5339.85 | 5334.75 | 5336.63 | 6283.0 |
| 2024-02-04 22:00:00 | ES | Futures | 5336.9 | 5338.51 | 5333.67 | 5335.55 | 6153.0 |
| 2024-02-04 23:00:00 | ES | Futures | 5335.55 | 5337.16 | 5335.02 | 5337.16 | 3535.0 |
| 2024-02-04 18:00:00 | NQ | Futures | 19197.02 | 19226.31 | 19191.32 | 19209.49 | 6004.0 |
| 2024-02-04 19:00:00 | NQ | Futures | 19208.68 | 19232.0 | 19168.0 | 19184.81 | 12699.0 |
| 2024-02-04 20:00:00 | NQ | Futures | 19184.81 | 19188.88 | 19162.3 | 19185.09 | 5661.0 |
| 2024-02-04 21:00:00 | NQ | Futures | 19183.73 | 19185.9 | 19167.46 | 19176.95 | 3524.0 |
| 2024-02-04 22:00:00 | NQ | Futures | 19177.49 | 19185.09 | 19172.07 | 19182.1 | 2842.0 |
| 2024-02-04 23:00:00 | NQ | Futures | 19182.37 | 19185.09 | 19177.49 | 19184.27 | 1595.0 |
| 2024-02-04 18:00:00 | YM | Futures | 41623.7 | 41645.2 | 41578.6 | 41634.5 | 1946.0 |
| 2024-02-04 19:00:00 | YM | Futures | 41632.3 | 41656.0 | 41548.5 | 41569.0 | 2440.0 |
| 2024-02-04 20:00:00 | YM | Futures | 41570.0 | 41581.8 | 41533.5 | 41576.5 | 1043.0 |
| 2024-02-04 21:00:00 | YM | Futures | 41576.5 | 41581.8 | 41545.3 | 41558.2 | 663.0 |
| 2024-02-04 22:00:00 | YM | Futures | 41557.1 | 41562.5 | 41526.0 | 41536.7 | 700.0 |
| 2024-02-04 23:00:00 | YM | Futures | 41538.9 | 41547.5 | 41530.3 | 41545.3 | 459.0 |
| 2024-02-04 18:00:00 | CL | Futures | 60.85 | 61.04 | 60.78 | 60.87 | 4641.0 |
| 2024-02-04 19:00:00 | CL | Futures | 60.87 | 60.88 | 60.53 | 60.58 | 3145.0 |
| 2024-02-04 20:00:00 | CL | Futures | 60.58 | 60.6 | 60.44 | 60.55 | 4144.0 |
| 2024-02-04 21:00:00 | CL | Futures | 60.54 | 60.64 | 60.36 | 60.42 | 2773.0 |
| 2024-02-04 22:00:00 | CL | Futures | 60.42 | 60.61 | 60.41 | 60.58 | 2677.0 |
| 2024-02-04 23:00:00 | CL | Futures | 60.58 | 60.67 | 60.52 | 60.67 | 1164.0 |
| 2024-02-04 18:00:00 | GC | Futures | 2255.6 | 2256.9 | 2253.3 | 2253.6 | 3535.0 |
| 2024-02-04 19:00:00 | GC | Futures | 2253.6 | 2254.1 | 2247.0 | 2249.2 | 4974.0 |
| 2024-02-04 20:00:00 | GC | Futures | 2249.1 | 2252.0 | 2247.8 | 2251.6 | 3718.0 |
| 2024-02-04 21:00:00 | GC | Futures | 2251.6 | 2252.4 | 2246.0 | 2246.7 | 3119.0 |
| 2024-02-04 22:00:00 | GC | Futures | 2246.6 | 2247.8 | 2241.8 | 2245.4 | 4185.0 |
| 2024-02-04 23:00:00 | GC | Futures | 2245.3 | 2246.7 | 2244.6 | 2244.9 | 1621.0 |
| 2024-02-04 18:00:00 | ZN | Futures | 113.194081 | 113.209921 | 112.988158 | 113.051519 | 38289.0 |
| 2024-02-04 19:00:00 | ZN | Futures | 113.067359 | 113.067359 | 112.734715 | 112.829756 | 113514.0 |
| 2024-02-04 20:00:00 | ZN | Futures | 112.813916 | 112.924797 | 112.798076 | 112.924797 | 51325.0 |
| 2024-02-04 21:00:00 | ZN | Futures | 112.924797 | 112.940638 | 112.877277 | 112.877277 | 20888.0 |
| 2024-02-04 22:00:00 | ZN | Futures | 112.893117 | 112.956478 | 112.877277 | 112.940638 | 17875.0 |
| 2024-02-04 23:00:00 | ZN | Futures | 112.940638 | 112.940638 | 112.908957 | 112.924797 | 5409.0 |
> showing 36 of 442 rows — these rows as CSV