PREVIEW / futures_1hour / 2009-08-23
file: by_date/futures_1hour/2009/2009-08-23.parquet size: 12 KB rows: 201
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 |
|---|---|---|---|---|---|---|---|
| 2009-08-23 18:00:00 | ES | Futures | 988.78 | 990.71 | 988.3 | 989.5 | 7660.0 |
| 2009-08-23 19:00:00 | ES | Futures | 989.5 | 990.23 | 988.3 | 989.02 | 4097.0 |
| 2009-08-23 20:00:00 | ES | Futures | 989.26 | 995.05 | 989.02 | 993.6 | 17387.0 |
| 2009-08-23 21:00:00 | ES | Futures | 993.84 | 996.01 | 992.88 | 993.36 | 10342.0 |
| 2009-08-23 22:00:00 | ES | Futures | 993.36 | 995.05 | 992.88 | 994.81 | 5150.0 |
| 2009-08-23 23:00:00 | ES | Futures | 994.81 | 995.29 | 993.12 | 994.81 | 3090.0 |
| 2009-08-23 18:00:00 | NQ | Futures | 1862.66 | 1865.51 | 1860.67 | 1863.51 | 468.0 |
| 2009-08-23 19:00:00 | NQ | Futures | 1863.23 | 1864.37 | 1861.24 | 1862.09 | 320.0 |
| 2009-08-23 20:00:00 | NQ | Futures | 1862.66 | 1874.05 | 1862.66 | 1871.77 | 1365.0 |
| 2009-08-23 21:00:00 | NQ | Futures | 1871.77 | 1877.76 | 1870.35 | 1870.92 | 1201.0 |
| 2009-08-23 22:00:00 | NQ | Futures | 1871.2 | 1874.62 | 1870.35 | 1874.34 | 445.0 |
| 2009-08-23 23:00:00 | NQ | Futures | 1874.34 | 1874.91 | 1871.49 | 1874.91 | 561.0 |
| 2009-08-23 18:00:00 | YM | Futures | 8772.0 | 8790.5 | 8765.6 | 8780.4 | 293.0 |
| 2009-08-23 19:00:00 | YM | Futures | 8778.5 | 8785.9 | 8773.9 | 8777.6 | 180.0 |
| 2009-08-23 20:00:00 | YM | Futures | 8777.6 | 8829.4 | 8776.7 | 8818.3 | 1118.0 |
| 2009-08-23 21:00:00 | YM | Futures | 8818.3 | 8847.9 | 8818.3 | 8819.2 | 2128.0 |
| 2009-08-23 22:00:00 | YM | Futures | 8820.1 | 8834.0 | 8813.7 | 8833.1 | 782.0 |
| 2009-08-23 23:00:00 | YM | Futures | 8831.2 | 8834.0 | 8817.4 | 8832.1 | 668.0 |
| 2009-08-23 18:00:00 | CL | Futures | 167.52 | 168.64 | 167.52 | 168.16 | 433.0 |
| 2009-08-23 19:00:00 | CL | Futures | 168.14 | 168.21 | 167.64 | 167.84 | 212.0 |
| 2009-08-23 20:00:00 | CL | Futures | 167.82 | 168.8 | 167.71 | 168.27 | 1244.0 |
| 2009-08-23 21:00:00 | CL | Futures | 168.27 | 168.89 | 168.18 | 168.46 | 1321.0 |
| 2009-08-23 22:00:00 | CL | Futures | 168.46 | 168.75 | 168.3 | 168.57 | 378.0 |
| 2009-08-23 23:00:00 | CL | Futures | 168.64 | 168.68 | 168.43 | 168.66 | 133.0 |
| 2009-08-23 18:00:00 | GC | Futures | 1347.8 | 1350.0 | 1347.6 | 1348.5 | 356.0 |
| 2009-08-23 19:00:00 | GC | Futures | 1348.5 | 1349.5 | 1345.4 | 1345.4 | 449.0 |
| 2009-08-23 20:00:00 | GC | Futures | 1345.4 | 1349.3 | 1344.1 | 1347.6 | 1164.0 |
| 2009-08-23 21:00:00 | GC | Futures | 1347.6 | 1349.0 | 1347.6 | 1348.7 | 340.0 |
| 2009-08-23 22:00:00 | GC | Futures | 1348.6 | 1348.7 | 1346.9 | 1347.3 | 506.0 |
| 2009-08-23 23:00:00 | GC | Futures | 1347.3 | 1348.7 | 1347.2 | 1348.0 | 341.0 |
| 2009-08-23 18:00:00 | ZN | Futures | 92.890778 | 92.989981 | 92.890778 | 92.95278 | 1592.0 |
| 2009-08-23 19:00:00 | ZN | Futures | 92.96518 | 93.039582 | 92.96518 | 92.97758 | 1490.0 |
| 2009-08-23 20:00:00 | ZN | Futures | 92.989981 | 92.989981 | 92.803976 | 92.841177 | 6205.0 |
| 2009-08-23 21:00:00 | ZN | Futures | 92.841177 | 92.96518 | 92.828776 | 92.95278 | 5251.0 |
| 2009-08-23 22:00:00 | ZN | Futures | 92.95278 | 92.96518 | 92.915579 | 92.927979 | 1499.0 |
| 2009-08-23 23:00:00 | ZN | Futures | 92.915579 | 92.927979 | 92.816376 | 92.841177 | 3416.0 |
> showing 36 of 201 rows — these rows as CSV