PREVIEW / futures_1hour / 2022-12-04
file: by_date/futures_1hour/2022/2022-12-04.parquet size: 19 KB rows: 418
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 |
|---|---|---|---|---|---|---|---|
| 2022-12-04 18:00:00 | ES | Futures | 4593.74 | 4595.71 | 4584.15 | 4590.36 | 11360.0 |
| 2022-12-04 19:00:00 | ES | Futures | 4590.36 | 4593.17 | 4586.69 | 4587.54 | 6575.0 |
| 2022-12-04 20:00:00 | ES | Futures | 4587.54 | 4590.92 | 4585.84 | 4586.97 | 10058.0 |
| 2022-12-04 21:00:00 | ES | Futures | 4586.97 | 4590.64 | 4586.41 | 4589.51 | 4671.0 |
| 2022-12-04 22:00:00 | ES | Futures | 4589.79 | 4592.05 | 4588.66 | 4591.48 | 3404.0 |
| 2022-12-04 23:00:00 | ES | Futures | 4591.76 | 4592.05 | 4587.54 | 4589.79 | 3128.0 |
| 2022-12-04 18:00:00 | NQ | Futures | 13792.22 | 13809.74 | 13770.09 | 13793.37 | 5069.0 |
| 2022-12-04 19:00:00 | NQ | Futures | 13793.65 | 13802.56 | 13779.57 | 13781.59 | 3630.0 |
| 2022-12-04 20:00:00 | NQ | Futures | 13781.87 | 13790.49 | 13770.09 | 13773.25 | 3751.0 |
| 2022-12-04 21:00:00 | NQ | Futures | 13772.97 | 13787.62 | 13772.39 | 13781.01 | 1549.0 |
| 2022-12-04 22:00:00 | NQ | Futures | 13782.16 | 13789.92 | 13776.13 | 13788.19 | 1273.0 |
| 2022-12-04 23:00:00 | NQ | Futures | 13788.77 | 13789.34 | 13774.69 | 13783.6 | 1267.0 |
| 2022-12-04 18:00:00 | YM | Futures | 38649.7 | 38675.5 | 38590.2 | 38641.9 | 1895.0 |
| 2022-12-04 19:00:00 | YM | Futures | 38641.9 | 38660.9 | 38617.2 | 38623.9 | 1250.0 |
| 2022-12-04 20:00:00 | YM | Futures | 38626.2 | 38660.9 | 38622.8 | 38638.5 | 1622.0 |
| 2022-12-04 21:00:00 | YM | Futures | 38636.3 | 38656.5 | 38635.1 | 38647.5 | 631.0 |
| 2022-12-04 22:00:00 | YM | Futures | 38646.4 | 38657.6 | 38638.5 | 38655.3 | 536.0 |
| 2022-12-04 23:00:00 | YM | Futures | 38654.2 | 38656.5 | 38623.9 | 38644.1 | 585.0 |
| 2022-12-04 18:00:00 | CL | Futures | 65.53 | 66.6 | 65.43 | 66.47 | 6206.0 |
| 2022-12-04 19:00:00 | CL | Futures | 66.48 | 67.05 | 66.48 | 66.79 | 3864.0 |
| 2022-12-04 20:00:00 | CL | Futures | 66.79 | 67.02 | 66.46 | 66.7 | 6521.0 |
| 2022-12-04 21:00:00 | CL | Futures | 66.7 | 66.79 | 66.41 | 66.47 | 3560.0 |
| 2022-12-04 22:00:00 | CL | Futures | 66.46 | 66.5 | 66.17 | 66.26 | 2671.0 |
| 2022-12-04 23:00:00 | CL | Futures | 66.25 | 66.29 | 65.98 | 66.1 | 1814.0 |
| 2022-12-04 18:00:00 | GC | Futures | 2120.6 | 2123.2 | 2117.7 | 2123.0 | 2686.0 |
| 2022-12-04 19:00:00 | GC | Futures | 2123.1 | 2125.4 | 2122.1 | 2123.7 | 2539.0 |
| 2022-12-04 20:00:00 | GC | Futures | 2123.8 | 2133.5 | 2123.5 | 2131.4 | 7589.0 |
| 2022-12-04 21:00:00 | GC | Futures | 2131.5 | 2133.4 | 2130.5 | 2131.9 | 3478.0 |
| 2022-12-04 22:00:00 | GC | Futures | 2131.9 | 2134.1 | 2130.7 | 2133.6 | 2761.0 |
| 2022-12-04 23:00:00 | GC | Futures | 2133.6 | 2135.1 | 2132.7 | 2133.5 | 2369.0 |
| 2022-12-04 18:00:00 | ZN | Futures | 117.93376 | 117.93376 | 117.820935 | 117.820935 | 5.0 |
| 2022-12-04 19:00:00 | ZN | Futures | 117.820935 | 117.820935 | 117.724228 | 117.756464 | 263.0 |
| 2022-12-04 20:00:00 | ZN | Futures | 117.772582 | 117.7887 | 117.772582 | 117.7887 | 150.0 |
| 2022-12-04 22:00:00 | ZN | Futures | 117.804817 | 117.820935 | 117.804817 | 117.820935 | 5.0 |
| 2022-12-04 23:00:00 | ZN | Futures | 117.708111 | 117.708111 | 117.708111 | 117.708111 | 40.0 |
> showing 35 of 418 rows — these rows as CSV