PREVIEW / futures_1hour / 2009-01-25
file: by_date/futures_1hour/2009/2009-01-25.parquet size: 13 KB rows: 231
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-01-25 18:00:00 | ES | Futures | 781.29 | 781.53 | 776.07 | 777.26 | 7079.0 |
| 2009-01-25 19:00:00 | ES | Futures | 777.26 | 777.73 | 774.17 | 776.07 | 5717.0 |
| 2009-01-25 20:00:00 | ES | Futures | 776.07 | 777.26 | 775.6 | 776.54 | 2526.0 |
| 2009-01-25 21:00:00 | ES | Futures | 776.54 | 777.02 | 775.6 | 776.54 | 1521.0 |
| 2009-01-25 22:00:00 | ES | Futures | 776.54 | 777.02 | 776.07 | 777.02 | 550.0 |
| 2009-01-25 23:00:00 | ES | Futures | 776.78 | 778.68 | 776.54 | 778.68 | 2580.0 |
| 2009-01-25 18:00:00 | NQ | Futures | 1315.89 | 1315.89 | 1306.01 | 1308.83 | 370.0 |
| 2009-01-25 19:00:00 | NQ | Futures | 1308.55 | 1308.83 | 1303.75 | 1306.86 | 188.0 |
| 2009-01-25 20:00:00 | NQ | Futures | 1307.42 | 1307.99 | 1306.01 | 1307.7 | 78.0 |
| 2009-01-25 21:00:00 | NQ | Futures | 1308.27 | 1309.12 | 1306.86 | 1307.42 | 104.0 |
| 2009-01-25 22:00:00 | NQ | Futures | 1307.42 | 1308.55 | 1307.14 | 1307.99 | 23.0 |
| 2009-01-25 23:00:00 | NQ | Futures | 1307.99 | 1310.81 | 1307.99 | 1310.81 | 47.0 |
| 2009-01-25 18:00:00 | YM | Futures | 7272.9 | 7272.9 | 7225.5 | 7235.5 | 497.0 |
| 2009-01-25 19:00:00 | YM | Futures | 7232.8 | 7237.3 | 7213.6 | 7232.8 | 152.0 |
| 2009-01-25 20:00:00 | YM | Futures | 7231.9 | 7235.5 | 7225.5 | 7231.9 | 167.0 |
| 2009-01-25 21:00:00 | YM | Futures | 7230.0 | 7238.2 | 7228.2 | 7230.0 | 404.0 |
| 2009-01-25 22:00:00 | YM | Futures | 7233.7 | 7241.0 | 7231.0 | 7240.1 | 63.0 |
| 2009-01-25 23:00:00 | YM | Futures | 7240.1 | 7252.8 | 7238.2 | 7250.1 | 188.0 |
| 2009-01-25 18:00:00 | CL | Futures | 138.01 | 139.2 | 137.29 | 137.53 | 1277.0 |
| 2009-01-25 19:00:00 | CL | Futures | 137.41 | 137.41 | 136.66 | 137.11 | 641.0 |
| 2009-01-25 20:00:00 | CL | Futures | 136.96 | 137.47 | 136.72 | 136.96 | 232.0 |
| 2009-01-25 21:00:00 | CL | Futures | 137.02 | 137.83 | 136.84 | 137.44 | 211.0 |
| 2009-01-25 22:00:00 | CL | Futures | 137.35 | 137.41 | 136.69 | 137.41 | 156.0 |
| 2009-01-25 23:00:00 | CL | Futures | 137.26 | 137.29 | 136.72 | 136.96 | 223.0 |
| 2009-01-25 18:00:00 | GC | Futures | 1281.7 | 1284.5 | 1273.3 | 1279.0 | 3398.0 |
| 2009-01-25 19:00:00 | GC | Futures | 1279.0 | 1279.8 | 1267.6 | 1268.4 | 3241.0 |
| 2009-01-25 20:00:00 | GC | Futures | 1268.5 | 1271.8 | 1268.3 | 1270.4 | 989.0 |
| 2009-01-25 21:00:00 | GC | Futures | 1270.5 | 1274.3 | 1269.7 | 1272.8 | 559.0 |
| 2009-01-25 22:00:00 | GC | Futures | 1273.0 | 1273.7 | 1270.3 | 1270.7 | 409.0 |
| 2009-01-25 23:00:00 | GC | Futures | 1270.8 | 1272.3 | 1268.1 | 1271.3 | 561.0 |
| 2009-01-25 18:00:00 | ZN | Futures | 95.594622 | 95.679017 | 95.558453 | 95.679017 | 1299.0 |
| 2009-01-25 19:00:00 | ZN | Futures | 95.679017 | 95.691073 | 95.654904 | 95.66696 | 757.0 |
| 2009-01-25 20:00:00 | ZN | Futures | 95.654904 | 95.66696 | 95.630791 | 95.642848 | 866.0 |
| 2009-01-25 21:00:00 | ZN | Futures | 95.642848 | 95.654904 | 95.618735 | 95.630791 | 796.0 |
| 2009-01-25 22:00:00 | ZN | Futures | 95.642848 | 95.66696 | 95.642848 | 95.66696 | 1024.0 |
| 2009-01-25 23:00:00 | ZN | Futures | 95.654904 | 95.66696 | 95.630791 | 95.630791 | 940.0 |
> showing 36 of 231 rows — these rows as CSV