PREVIEW / futures_1hour / 2022-09-18
file: by_date/futures_1hour/2022/2022-09-18.parquet size: 19 KB rows: 411
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-09-18 18:00:00 | ES | Futures | 4385.7 | 4391.9 | 4379.5 | 4390.49 | 12264.0 |
| 2022-09-18 19:00:00 | ES | Futures | 4389.93 | 4395.0 | 4387.96 | 4390.21 | 6610.0 |
| 2022-09-18 20:00:00 | ES | Futures | 4390.49 | 4396.69 | 4389.37 | 4393.31 | 8208.0 |
| 2022-09-18 21:00:00 | ES | Futures | 4393.03 | 4396.13 | 4387.67 | 4393.59 | 7311.0 |
| 2022-09-18 22:00:00 | ES | Futures | 4393.59 | 4393.88 | 4367.94 | 4376.96 | 16419.0 |
| 2022-09-18 23:00:00 | ES | Futures | 4377.24 | 4379.78 | 4372.73 | 4377.24 | 5576.0 |
| 2022-09-18 18:00:00 | NQ | Futures | 13699.7 | 13709.18 | 13655.45 | 13701.13 | 7194.0 |
| 2022-09-18 19:00:00 | NQ | Futures | 13701.13 | 13727.28 | 13693.09 | 13711.48 | 4074.0 |
| 2022-09-18 20:00:00 | NQ | Futures | 13712.05 | 13734.46 | 13710.04 | 13721.82 | 4646.0 |
| 2022-09-18 21:00:00 | NQ | Futures | 13721.25 | 13729.87 | 13695.68 | 13712.05 | 4841.0 |
| 2022-09-18 22:00:00 | NQ | Futures | 13712.05 | 13715.5 | 13625.86 | 13654.59 | 8369.0 |
| 2022-09-18 23:00:00 | NQ | Futures | 13654.01 | 13662.63 | 13637.64 | 13658.04 | 3464.0 |
| 2022-09-18 18:00:00 | YM | Futures | 34730.9 | 34763.4 | 34684.9 | 34754.5 | 1635.0 |
| 2022-09-18 19:00:00 | YM | Futures | 34752.2 | 34778.0 | 34729.8 | 34743.2 | 814.0 |
| 2022-09-18 20:00:00 | YM | Futures | 34745.5 | 34779.1 | 34738.7 | 34756.7 | 919.0 |
| 2022-09-18 21:00:00 | YM | Futures | 34756.7 | 34776.9 | 34720.8 | 34761.2 | 891.0 |
| 2022-09-18 22:00:00 | YM | Futures | 34761.2 | 34762.3 | 34594.0 | 34655.7 | 1769.0 |
| 2022-09-18 23:00:00 | YM | Futures | 34655.7 | 34672.5 | 34626.5 | 34655.7 | 640.0 |
| 2022-09-18 18:00:00 | CL | Futures | 68.08 | 68.56 | 68.07 | 68.54 | 1742.0 |
| 2022-09-18 19:00:00 | CL | Futures | 68.52 | 68.55 | 68.4 | 68.46 | 660.0 |
| 2022-09-18 20:00:00 | CL | Futures | 68.48 | 68.91 | 68.48 | 68.83 | 2083.0 |
| 2022-09-18 21:00:00 | CL | Futures | 68.83 | 68.94 | 68.64 | 68.74 | 4304.0 |
| 2022-09-18 22:00:00 | CL | Futures | 68.74 | 68.76 | 68.38 | 68.48 | 4265.0 |
| 2022-09-18 23:00:00 | CL | Futures | 68.48 | 68.49 | 68.32 | 68.38 | 1744.0 |
| 2022-09-18 18:00:00 | GC | Futures | 1990.7 | 1993.3 | 1987.3 | 1992.7 | 2418.0 |
| 2022-09-18 19:00:00 | GC | Futures | 1992.8 | 1994.7 | 1991.4 | 1992.1 | 1686.0 |
| 2022-09-18 20:00:00 | GC | Futures | 1992.0 | 1993.1 | 1989.5 | 1989.8 | 2156.0 |
| 2022-09-18 21:00:00 | GC | Futures | 1989.8 | 1990.8 | 1984.0 | 1984.6 | 4195.0 |
| 2022-09-18 22:00:00 | GC | Futures | 1984.4 | 1984.8 | 1980.3 | 1984.2 | 3608.0 |
| 2022-09-18 23:00:00 | GC | Futures | 1984.2 | 1984.2 | 1980.4 | 1981.2 | 1490.0 |
| 2022-09-18 18:00:00 | ZN | Futures | 118.336704 | 118.352822 | 118.272233 | 118.320586 | 4106.0 |
| 2022-09-18 19:00:00 | ZN | Futures | 118.336704 | 118.417293 | 118.320586 | 118.401175 | 5226.0 |
| 2022-09-18 20:00:00 | ZN | Futures | 118.385057 | 118.417293 | 118.304468 | 118.320586 | 5608.0 |
| 2022-09-18 21:00:00 | ZN | Futures | 118.320586 | 118.320586 | 118.272233 | 118.288351 | 3406.0 |
| 2022-09-18 22:00:00 | ZN | Futures | 118.272233 | 118.272233 | 118.207762 | 118.239997 | 4701.0 |
| 2022-09-18 23:00:00 | ZN | Futures | 118.223879 | 118.272233 | 118.223879 | 118.272233 | 1821.0 |
> showing 36 of 411 rows — these rows as CSV