PREVIEW / futures_1hour / 2023-01-15
file: by_date/futures_1hour/2023/2023-01-15.parquet size: 18 KB rows: 394
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-01-15 18:00:00 | ES | Futures | 4496.07 | 4498.59 | 4486.57 | 4488.8 | 7841.0 |
| 2023-01-15 19:00:00 | ES | Futures | 4488.8 | 4496.91 | 4487.13 | 4496.07 | 7133.0 |
| 2023-01-15 20:00:00 | ES | Futures | 4495.79 | 4505.3 | 4494.4 | 4503.62 | 8192.0 |
| 2023-01-15 21:00:00 | ES | Futures | 4503.62 | 4504.18 | 4500.27 | 4501.95 | 4772.0 |
| 2023-01-15 22:00:00 | ES | Futures | 4502.22 | 4502.78 | 4499.15 | 4501.11 | 2736.0 |
| 2023-01-15 23:00:00 | ES | Futures | 4501.39 | 4501.67 | 4499.15 | 4499.43 | 2139.0 |
| 2023-01-15 18:00:00 | NQ | Futures | 13215.89 | 13223.0 | 13180.61 | 13185.45 | 4320.0 |
| 2023-01-15 19:00:00 | NQ | Futures | 13186.02 | 13210.48 | 13181.75 | 13207.07 | 3188.0 |
| 2023-01-15 20:00:00 | NQ | Futures | 13206.78 | 13244.62 | 13202.52 | 13237.51 | 4041.0 |
| 2023-01-15 21:00:00 | NQ | Futures | 13238.93 | 13241.78 | 13225.28 | 13231.82 | 2216.0 |
| 2023-01-15 22:00:00 | NQ | Futures | 13232.1 | 13233.53 | 13219.87 | 13230.68 | 1423.0 |
| 2023-01-15 23:00:00 | NQ | Futures | 13231.25 | 13232.67 | 13220.15 | 13220.72 | 1235.0 |
| 2023-01-15 18:00:00 | YM | Futures | 38368.0 | 38383.6 | 38315.6 | 38325.6 | 1409.0 |
| 2023-01-15 19:00:00 | YM | Futures | 38331.2 | 38386.9 | 38321.2 | 38375.8 | 1084.0 |
| 2023-01-15 20:00:00 | YM | Futures | 38375.8 | 38427.0 | 38361.3 | 38420.3 | 1147.0 |
| 2023-01-15 21:00:00 | YM | Futures | 38419.2 | 38424.8 | 38405.8 | 38415.9 | 544.0 |
| 2023-01-15 22:00:00 | YM | Futures | 38417.0 | 38421.4 | 38393.6 | 38402.5 | 417.0 |
| 2023-01-15 23:00:00 | YM | Futures | 38402.5 | 38408.1 | 38385.8 | 38385.8 | 326.0 |
| 2023-01-15 18:00:00 | CL | Futures | 65.53 | 65.66 | 65.28 | 65.28 | 661.0 |
| 2023-01-15 19:00:00 | CL | Futures | 65.3 | 65.41 | 65.25 | 65.39 | 574.0 |
| 2023-01-15 20:00:00 | CL | Futures | 65.37 | 65.39 | 65.01 | 65.21 | 1418.0 |
| 2023-01-15 21:00:00 | CL | Futures | 65.21 | 65.27 | 65.01 | 65.06 | 530.0 |
| 2023-01-15 22:00:00 | CL | Futures | 65.05 | 65.09 | 64.96 | 65.06 | 306.0 |
| 2023-01-15 23:00:00 | CL | Futures | 65.06 | 65.06 | 64.93 | 64.93 | 174.0 |
| 2023-01-15 18:00:00 | GC | Futures | 2253.3 | 2253.4 | 2248.6 | 2248.6 | 3327.0 |
| 2023-01-15 19:00:00 | GC | Futures | 2248.9 | 2252.1 | 2248.6 | 2251.2 | 1982.0 |
| 2023-01-15 20:00:00 | GC | Futures | 2251.0 | 2257.7 | 2250.2 | 2257.1 | 4268.0 |
| 2023-01-15 21:00:00 | GC | Futures | 2257.1 | 2262.5 | 2255.3 | 2261.9 | 3956.0 |
| 2023-01-15 22:00:00 | GC | Futures | 2261.8 | 2262.7 | 2257.7 | 2259.5 | 2209.0 |
| 2023-01-15 23:00:00 | GC | Futures | 2259.5 | 2260.5 | 2254.4 | 2255.0 | 1615.0 |
| 2023-01-15 18:00:00 | ZN | Futures | 118.256003 | 118.288195 | 118.159428 | 118.19162 | 9951.0 |
| 2023-01-15 19:00:00 | ZN | Futures | 118.207716 | 118.304291 | 118.19162 | 118.304291 | 8037.0 |
| 2023-01-15 20:00:00 | ZN | Futures | 118.320387 | 118.352578 | 118.256003 | 118.272099 | 9540.0 |
| 2023-01-15 21:00:00 | ZN | Futures | 118.288195 | 118.304291 | 118.239908 | 118.288195 | 6121.0 |
| 2023-01-15 22:00:00 | ZN | Futures | 118.288195 | 118.336483 | 118.288195 | 118.336483 | 3958.0 |
| 2023-01-15 23:00:00 | ZN | Futures | 118.320387 | 118.336483 | 118.288195 | 118.304291 | 2051.0 |
> showing 36 of 394 rows — these rows as CSV