PREVIEW / futures_1hour / 2009-09-13
file: by_date/futures_1hour/2009/2009-09-13.parquet size: 13 KB rows: 230
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-09-13 18:00:00 | ES | Futures | 1003.73 | 1003.73 | 1001.56 | 1002.04 | 1399.0 |
| 2009-09-13 19:00:00 | ES | Futures | 1001.8 | 1002.53 | 1000.36 | 1001.32 | 1659.0 |
| 2009-09-13 20:00:00 | ES | Futures | 1001.32 | 1001.32 | 994.57 | 996.01 | 7231.0 |
| 2009-09-13 21:00:00 | ES | Futures | 995.77 | 996.5 | 993.6 | 995.05 | 3412.0 |
| 2009-09-13 22:00:00 | ES | Futures | 994.81 | 996.26 | 994.57 | 995.05 | 1998.0 |
| 2009-09-13 23:00:00 | ES | Futures | 995.05 | 996.74 | 994.57 | 995.77 | 1022.0 |
| 2009-09-13 18:00:00 | NQ | Futures | 1919.62 | 1919.91 | 1913.93 | 1914.78 | 221.0 |
| 2009-09-13 19:00:00 | NQ | Futures | 1914.78 | 1916.49 | 1913.93 | 1914.5 | 38.0 |
| 2009-09-13 20:00:00 | NQ | Futures | 1913.93 | 1913.93 | 1902.82 | 1905.95 | 335.0 |
| 2009-09-13 21:00:00 | NQ | Futures | 1905.1 | 1905.95 | 1901.39 | 1903.67 | 228.0 |
| 2009-09-13 22:00:00 | NQ | Futures | 1903.39 | 1905.95 | 1902.82 | 1903.67 | 71.0 |
| 2009-09-13 23:00:00 | NQ | Futures | 1903.39 | 1906.81 | 1902.82 | 1905.1 | 63.0 |
| 2009-09-13 18:00:00 | YM | Futures | 8858.1 | 8858.1 | 8830.2 | 8838.6 | 423.0 |
| 2009-09-13 19:00:00 | YM | Futures | 8838.6 | 8845.1 | 8827.5 | 8836.8 | 186.0 |
| 2009-09-13 20:00:00 | YM | Futures | 8834.9 | 8835.8 | 8774.4 | 8794.9 | 1548.0 |
| 2009-09-13 21:00:00 | YM | Futures | 8794.9 | 8796.8 | 8776.3 | 8787.5 | 426.0 |
| 2009-09-13 22:00:00 | YM | Futures | 8788.4 | 8796.8 | 8782.8 | 8787.5 | 341.0 |
| 2009-09-13 23:00:00 | YM | Futures | 8788.4 | 8800.5 | 8783.7 | 8794.9 | 253.0 |
| 2009-09-13 18:00:00 | CL | Futures | 157.01 | 157.01 | 156.36 | 156.51 | 76.0 |
| 2009-09-13 19:00:00 | CL | Futures | 156.47 | 156.58 | 155.19 | 155.41 | 208.0 |
| 2009-09-13 20:00:00 | CL | Futures | 155.34 | 155.41 | 154.22 | 154.69 | 523.0 |
| 2009-09-13 21:00:00 | CL | Futures | 154.69 | 154.89 | 154.17 | 154.71 | 353.0 |
| 2009-09-13 22:00:00 | CL | Futures | 154.74 | 155.14 | 154.74 | 154.87 | 186.0 |
| 2009-09-13 23:00:00 | CL | Futures | 155.07 | 155.37 | 154.92 | 155.25 | 107.0 |
| 2009-09-13 18:00:00 | GC | Futures | 1422.4 | 1424.3 | 1420.3 | 1424.1 | 745.0 |
| 2009-09-13 19:00:00 | GC | Futures | 1423.8 | 1426.7 | 1423.1 | 1426.1 | 1071.0 |
| 2009-09-13 20:00:00 | GC | Futures | 1426.0 | 1426.8 | 1417.9 | 1419.0 | 3060.0 |
| 2009-09-13 21:00:00 | GC | Futures | 1419.0 | 1419.3 | 1415.9 | 1417.1 | 2223.0 |
| 2009-09-13 22:00:00 | GC | Futures | 1417.2 | 1418.6 | 1416.6 | 1417.3 | 681.0 |
| 2009-09-13 23:00:00 | GC | Futures | 1417.6 | 1419.3 | 1417.5 | 1418.9 | 567.0 |
| 2009-09-13 18:00:00 | ZN | Futures | 94.683633 | 94.683633 | 94.595801 | 94.633443 | 4358.0 |
| 2009-09-13 19:00:00 | ZN | Futures | 94.633443 | 94.696181 | 94.633443 | 94.696181 | 1549.0 |
| 2009-09-13 20:00:00 | ZN | Futures | 94.696181 | 94.809109 | 94.645991 | 94.771466 | 9939.0 |
| 2009-09-13 21:00:00 | ZN | Futures | 94.771466 | 94.834204 | 94.771466 | 94.834204 | 3858.0 |
| 2009-09-13 22:00:00 | ZN | Futures | 94.834204 | 94.859299 | 94.821656 | 94.834204 | 1285.0 |
| 2009-09-13 23:00:00 | ZN | Futures | 94.846751 | 94.846751 | 94.771466 | 94.784014 | 1621.0 |
> showing 36 of 230 rows — these rows as CSV