PREVIEW / futures_1hour / 2023-11-26
file: by_date/futures_1hour/2023/2023-11-26.parquet size: 19 KB rows: 433
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-11-26 18:00:00 | ES | Futures | 4962.46 | 4962.73 | 4954.31 | 4955.4 | 10350.0 |
| 2023-11-26 19:00:00 | ES | Futures | 4955.4 | 4955.4 | 4950.78 | 4951.05 | 10151.0 |
| 2023-11-26 20:00:00 | ES | Futures | 4951.05 | 4956.21 | 4950.24 | 4952.41 | 12349.0 |
| 2023-11-26 21:00:00 | ES | Futures | 4952.41 | 4952.68 | 4947.79 | 4948.34 | 7914.0 |
| 2023-11-26 22:00:00 | ES | Futures | 4948.61 | 4948.88 | 4945.62 | 4948.06 | 6653.0 |
| 2023-11-26 23:00:00 | ES | Futures | 4948.34 | 4948.88 | 4947.52 | 4948.06 | 2370.0 |
| 2023-11-26 18:00:00 | NQ | Futures | 17587.3 | 17588.4 | 17559.56 | 17563.68 | 5877.0 |
| 2023-11-26 19:00:00 | NQ | Futures | 17563.95 | 17564.23 | 17541.15 | 17544.72 | 5300.0 |
| 2023-11-26 20:00:00 | NQ | Futures | 17544.72 | 17563.13 | 17541.98 | 17545.55 | 5921.0 |
| 2023-11-26 21:00:00 | NQ | Futures | 17546.37 | 17547.47 | 17518.08 | 17521.38 | 5598.0 |
| 2023-11-26 22:00:00 | NQ | Futures | 17521.38 | 17522.2 | 17511.22 | 17518.08 | 3677.0 |
| 2023-11-26 23:00:00 | NQ | Futures | 17518.91 | 17525.22 | 17516.98 | 17520.55 | 1937.0 |
| 2023-11-26 18:00:00 | YM | Futures | 38432.1 | 38433.1 | 38388.7 | 38393.0 | 1346.0 |
| 2023-11-26 19:00:00 | YM | Futures | 38393.0 | 38394.1 | 38363.7 | 38369.1 | 987.0 |
| 2023-11-26 20:00:00 | YM | Futures | 38370.2 | 38396.3 | 38368.1 | 38372.4 | 1310.0 |
| 2023-11-26 21:00:00 | YM | Futures | 38373.5 | 38374.6 | 38348.5 | 38352.9 | 860.0 |
| 2023-11-26 22:00:00 | YM | Futures | 38354.0 | 38356.1 | 38336.6 | 38349.6 | 606.0 |
| 2023-11-26 23:00:00 | YM | Futures | 38349.6 | 38349.6 | 38340.9 | 38345.3 | 330.0 |
| 2023-11-26 18:00:00 | CL | Futures | 63.23 | 63.57 | 63.14 | 63.55 | 2934.0 |
| 2023-11-26 19:00:00 | CL | Futures | 63.55 | 63.55 | 63.45 | 63.46 | 1059.0 |
| 2023-11-26 20:00:00 | CL | Futures | 63.45 | 63.55 | 63.11 | 63.15 | 5096.0 |
| 2023-11-26 21:00:00 | CL | Futures | 63.15 | 63.19 | 62.94 | 62.97 | 3570.0 |
| 2023-11-26 22:00:00 | CL | Futures | 62.96 | 62.98 | 62.76 | 62.87 | 3176.0 |
| 2023-11-26 23:00:00 | CL | Futures | 62.87 | 62.88 | 62.71 | 62.77 | 2340.0 |
| 2023-11-26 18:00:00 | GC | Futures | 2238.1 | 2239.4 | 2237.0 | 2238.7 | 1036.0 |
| 2023-11-26 19:00:00 | GC | Futures | 2238.6 | 2240.6 | 2238.1 | 2238.3 | 606.0 |
| 2023-11-26 20:00:00 | GC | Futures | 2238.4 | 2256.2 | 2238.4 | 2249.6 | 4943.0 |
| 2023-11-26 21:00:00 | GC | Futures | 2249.5 | 2249.6 | 2244.4 | 2248.5 | 1709.0 |
| 2023-11-26 22:00:00 | GC | Futures | 2248.5 | 2249.2 | 2244.0 | 2246.7 | 1271.0 |
| 2023-11-26 23:00:00 | GC | Futures | 2246.6 | 2251.1 | 2245.2 | 2250.6 | 1210.0 |
| 2023-11-26 18:00:00 | ZN | Futures | 110.116809 | 110.116809 | 110.005725 | 110.021594 | 18287.0 |
| 2023-11-26 19:00:00 | ZN | Futures | 110.037463 | 110.069202 | 109.910509 | 109.942247 | 23580.0 |
| 2023-11-26 20:00:00 | ZN | Futures | 109.926378 | 110.005725 | 109.87877 | 109.989855 | 15513.0 |
| 2023-11-26 21:00:00 | ZN | Futures | 110.005725 | 110.005725 | 109.958117 | 109.989855 | 4537.0 |
| 2023-11-26 22:00:00 | ZN | Futures | 109.973986 | 110.005725 | 109.942247 | 109.989855 | 6957.0 |
| 2023-11-26 23:00:00 | ZN | Futures | 109.989855 | 110.037463 | 109.942247 | 110.021594 | 6869.0 |
> showing 36 of 433 rows — these rows as CSV