PREVIEW / futures_1hour / 2009-05-17
file: by_date/futures_1hour/2009/2009-05-17.parquet size: 13 KB rows: 222
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-05-17 18:00:00 | ES | Futures | 845.67 | 846.39 | 843.51 | 846.15 | 5933.0 |
| 2009-05-17 19:00:00 | ES | Futures | 845.91 | 846.15 | 843.51 | 843.51 | 1852.0 |
| 2009-05-17 20:00:00 | ES | Futures | 843.51 | 844.71 | 839.92 | 842.07 | 6960.0 |
| 2009-05-17 21:00:00 | ES | Futures | 842.07 | 843.03 | 838.96 | 839.92 | 7267.0 |
| 2009-05-17 22:00:00 | ES | Futures | 840.16 | 841.11 | 839.2 | 840.64 | 3863.0 |
| 2009-05-17 23:00:00 | ES | Futures | 840.88 | 840.88 | 839.2 | 839.92 | 3093.0 |
| 2009-05-17 18:00:00 | NQ | Futures | 1536.91 | 1539.47 | 1533.79 | 1539.47 | 404.0 |
| 2009-05-17 19:00:00 | NQ | Futures | 1538.33 | 1539.19 | 1534.36 | 1534.36 | 100.0 |
| 2009-05-17 20:00:00 | NQ | Futures | 1534.36 | 1535.49 | 1528.1 | 1530.66 | 375.0 |
| 2009-05-17 21:00:00 | NQ | Futures | 1531.23 | 1532.65 | 1525.83 | 1527.25 | 549.0 |
| 2009-05-17 22:00:00 | NQ | Futures | 1528.1 | 1529.52 | 1526.12 | 1528.67 | 206.0 |
| 2009-05-17 23:00:00 | NQ | Futures | 1527.54 | 1528.1 | 1526.12 | 1527.54 | 125.0 |
| 2009-05-17 18:00:00 | YM | Futures | 7595.1 | 7596.0 | 7574.0 | 7595.1 | 292.0 |
| 2009-05-17 19:00:00 | YM | Futures | 7593.3 | 7594.2 | 7574.9 | 7574.9 | 137.0 |
| 2009-05-17 20:00:00 | YM | Futures | 7574.0 | 7575.8 | 7540.9 | 7559.3 | 512.0 |
| 2009-05-17 21:00:00 | YM | Futures | 7559.3 | 7563.9 | 7533.5 | 7541.8 | 525.0 |
| 2009-05-17 22:00:00 | YM | Futures | 7543.7 | 7551.9 | 7529.0 | 7534.5 | 765.0 |
| 2009-05-17 23:00:00 | YM | Futures | 7534.5 | 7535.4 | 7513.3 | 7521.6 | 1925.0 |
| 2009-05-17 18:00:00 | CL | Futures | 136.698 | 137.414 | 136.1 | 137.271 | 794.0 |
| 2009-05-17 19:00:00 | CL | Futures | 137.295 | 137.295 | 136.889 | 136.937 | 182.0 |
| 2009-05-17 20:00:00 | CL | Futures | 137.008 | 137.128 | 136.029 | 136.554 | 375.0 |
| 2009-05-17 21:00:00 | CL | Futures | 136.578 | 136.65 | 135.862 | 135.862 | 306.0 |
| 2009-05-17 22:00:00 | CL | Futures | 135.933 | 136.22 | 135.599 | 136.148 | 358.0 |
| 2009-05-17 23:00:00 | CL | Futures | 136.172 | 136.316 | 136.029 | 136.244 | 157.0 |
| 2009-05-17 18:00:00 | GC | Futures | 1320.5 | 1322.5 | 1319.8 | 1322.2 | 385.0 |
| 2009-05-17 19:00:00 | GC | Futures | 1322.2 | 1323.6 | 1321.8 | 1322.6 | 209.0 |
| 2009-05-17 20:00:00 | GC | Futures | 1322.6 | 1323.2 | 1318.5 | 1320.2 | 1329.0 |
| 2009-05-17 21:00:00 | GC | Futures | 1319.9 | 1321.2 | 1319.6 | 1320.4 | 374.0 |
| 2009-05-17 22:00:00 | GC | Futures | 1320.5 | 1321.2 | 1320.1 | 1320.1 | 404.0 |
| 2009-05-17 23:00:00 | GC | Futures | 1320.1 | 1321.9 | 1320.1 | 1321.2 | 394.0 |
| 2009-05-17 18:00:00 | ZN | Futures | 94.906189 | 94.991657 | 94.906189 | 94.967238 | 334.0 |
| 2009-05-17 19:00:00 | ZN | Futures | 94.979447 | 95.040496 | 94.967238 | 94.979447 | 1890.0 |
| 2009-05-17 20:00:00 | ZN | Futures | 94.991657 | 95.089335 | 94.991657 | 95.016077 | 4044.0 |
| 2009-05-17 21:00:00 | ZN | Futures | 95.016077 | 95.101545 | 95.016077 | 95.101545 | 1794.0 |
| 2009-05-17 22:00:00 | ZN | Futures | 95.089335 | 95.113754 | 95.077125 | 95.077125 | 1571.0 |
| 2009-05-17 23:00:00 | ZN | Futures | 95.077125 | 95.089335 | 95.064916 | 95.077125 | 1185.0 |
> showing 36 of 222 rows — these rows as CSV