PREVIEW / futures_1hour / 2009-08-30
file: by_date/futures_1hour/2009/2009-08-30.parquet size: 13 KB rows: 220
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-30 18:00:00 | ES | Futures | 990.23 | 990.47 | 988.3 | 988.54 | 4931.0 |
| 2009-08-30 19:00:00 | ES | Futures | 988.3 | 989.99 | 988.3 | 989.5 | 2015.0 |
| 2009-08-30 20:00:00 | ES | Futures | 989.74 | 994.57 | 989.26 | 991.19 | 10431.0 |
| 2009-08-30 21:00:00 | ES | Futures | 991.43 | 991.43 | 986.61 | 986.61 | 11511.0 |
| 2009-08-30 22:00:00 | ES | Futures | 986.85 | 988.3 | 985.89 | 986.13 | 6391.0 |
| 2009-08-30 23:00:00 | ES | Futures | 986.13 | 986.37 | 985.16 | 986.37 | 6750.0 |
| 2009-08-30 18:00:00 | NQ | Futures | 1869.78 | 1870.35 | 1866.08 | 1866.65 | 449.0 |
| 2009-08-30 19:00:00 | NQ | Futures | 1865.79 | 1868.93 | 1865.79 | 1867.79 | 201.0 |
| 2009-08-30 20:00:00 | NQ | Futures | 1868.07 | 1874.05 | 1868.07 | 1868.36 | 1250.0 |
| 2009-08-30 21:00:00 | NQ | Futures | 1869.21 | 1869.21 | 1860.38 | 1860.95 | 621.0 |
| 2009-08-30 22:00:00 | NQ | Futures | 1860.67 | 1863.51 | 1859.24 | 1859.81 | 295.0 |
| 2009-08-30 23:00:00 | NQ | Futures | 1859.53 | 1860.1 | 1857.82 | 1858.39 | 1052.0 |
| 2009-08-30 18:00:00 | YM | Futures | 8805.3 | 8812.7 | 8792.4 | 8792.4 | 423.0 |
| 2009-08-30 19:00:00 | YM | Futures | 8792.4 | 8806.3 | 8791.5 | 8801.6 | 178.0 |
| 2009-08-30 20:00:00 | YM | Futures | 8801.6 | 8837.7 | 8801.6 | 8815.5 | 689.0 |
| 2009-08-30 21:00:00 | YM | Futures | 8817.4 | 8817.4 | 8774.8 | 8778.5 | 666.0 |
| 2009-08-30 22:00:00 | YM | Futures | 8778.5 | 8788.7 | 8771.1 | 8772.0 | 282.0 |
| 2009-08-30 23:00:00 | YM | Futures | 8773.0 | 8774.8 | 8764.6 | 8770.2 | 645.0 |
| 2009-08-30 18:00:00 | CL | Futures | 165.25 | 166.64 | 165.25 | 166.03 | 866.0 |
| 2009-08-30 19:00:00 | CL | Futures | 165.96 | 166.16 | 165.87 | 165.96 | 176.0 |
| 2009-08-30 20:00:00 | CL | Futures | 166.0 | 166.25 | 165.82 | 166.09 | 453.0 |
| 2009-08-30 21:00:00 | CL | Futures | 166.03 | 166.07 | 164.87 | 164.96 | 1050.0 |
| 2009-08-30 22:00:00 | CL | Futures | 164.98 | 165.09 | 164.71 | 164.75 | 769.0 |
| 2009-08-30 23:00:00 | CL | Futures | 164.75 | 164.89 | 164.05 | 164.53 | 1024.0 |
| 2009-08-30 18:00:00 | GC | Futures | 1351.4 | 1353.3 | 1349.9 | 1351.7 | 491.0 |
| 2009-08-30 19:00:00 | GC | Futures | 1351.7 | 1357.1 | 1351.0 | 1356.2 | 1446.0 |
| 2009-08-30 20:00:00 | GC | Futures | 1356.1 | 1358.1 | 1355.5 | 1357.8 | 1531.0 |
| 2009-08-30 21:00:00 | GC | Futures | 1357.9 | 1357.9 | 1351.4 | 1353.4 | 1466.0 |
| 2009-08-30 22:00:00 | GC | Futures | 1353.4 | 1353.5 | 1351.9 | 1351.9 | 542.0 |
| 2009-08-30 23:00:00 | GC | Futures | 1352.1 | 1352.1 | 1348.7 | 1350.4 | 962.0 |
| 2009-08-30 18:00:00 | ZN | Futures | 93.796001 | 93.796001 | 93.7588 | 93.771201 | 166.0 |
| 2009-08-30 19:00:00 | ZN | Futures | 93.7588 | 93.771201 | 93.709199 | 93.721599 | 435.0 |
| 2009-08-30 20:00:00 | ZN | Futures | 93.709199 | 93.721599 | 93.634797 | 93.709199 | 702.0 |
| 2009-08-30 21:00:00 | ZN | Futures | 93.696799 | 93.882803 | 93.696799 | 93.820802 | 2326.0 |
| 2009-08-30 22:00:00 | ZN | Futures | 93.820802 | 93.882803 | 93.808402 | 93.858003 | 876.0 |
| 2009-08-30 23:00:00 | ZN | Futures | 93.858003 | 93.895204 | 93.845602 | 93.870403 | 726.0 |
> showing 36 of 220 rows — these rows as CSV