PREVIEW / futures_1hour / 2009-10-25
file: by_date/futures_1hour/2009/2009-10-25.parquet size: 13 KB rows: 232
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-10-25 18:00:00 | ES | Futures | 1043.01 | 1045.91 | 1041.55 | 1044.46 | 5892.0 |
| 2009-10-25 19:00:00 | ES | Futures | 1044.22 | 1044.46 | 1042.28 | 1042.52 | 4287.0 |
| 2009-10-25 20:00:00 | ES | Futures | 1042.28 | 1045.67 | 1042.28 | 1044.7 | 6385.0 |
| 2009-10-25 21:00:00 | ES | Futures | 1044.46 | 1046.4 | 1044.22 | 1045.43 | 6216.0 |
| 2009-10-25 22:00:00 | ES | Futures | 1045.43 | 1046.16 | 1044.7 | 1045.43 | 4213.0 |
| 2009-10-25 23:00:00 | ES | Futures | 1045.19 | 1045.43 | 1044.22 | 1044.46 | 1142.0 |
| 2009-10-25 18:00:00 | NQ | Futures | 1997.5 | 2003.49 | 1994.08 | 2000.64 | 323.0 |
| 2009-10-25 19:00:00 | NQ | Futures | 1999.78 | 2000.07 | 1996.36 | 1996.36 | 426.0 |
| 2009-10-25 20:00:00 | NQ | Futures | 1996.36 | 2003.2 | 1996.07 | 2001.21 | 602.0 |
| 2009-10-25 21:00:00 | NQ | Futures | 2001.78 | 2005.77 | 2000.64 | 2003.49 | 905.0 |
| 2009-10-25 22:00:00 | NQ | Futures | 2003.77 | 2004.91 | 2002.06 | 2003.2 | 413.0 |
| 2009-10-25 23:00:00 | NQ | Futures | 2003.49 | 2003.49 | 2001.49 | 2001.78 | 150.0 |
| 2009-10-25 18:00:00 | YM | Futures | 9232.1 | 9255.3 | 9221.9 | 9243.2 | 193.0 |
| 2009-10-25 19:00:00 | YM | Futures | 9242.3 | 9243.2 | 9226.5 | 9227.4 | 353.0 |
| 2009-10-25 20:00:00 | YM | Futures | 9230.2 | 9253.5 | 9227.4 | 9244.2 | 334.0 |
| 2009-10-25 21:00:00 | YM | Futures | 9246.0 | 9261.8 | 9244.2 | 9255.3 | 788.0 |
| 2009-10-25 22:00:00 | YM | Futures | 9255.3 | 9262.8 | 9253.5 | 9256.3 | 287.0 |
| 2009-10-25 23:00:00 | YM | Futures | 9256.3 | 9257.2 | 9247.0 | 9249.8 | 147.0 |
| 2009-10-25 18:00:00 | CL | Futures | 177.98 | 178.49 | 177.86 | 178.18 | 671.0 |
| 2009-10-25 19:00:00 | CL | Futures | 178.18 | 178.69 | 178.09 | 178.09 | 501.0 |
| 2009-10-25 20:00:00 | CL | Futures | 178.09 | 178.24 | 177.8 | 178.2 | 835.0 |
| 2009-10-25 21:00:00 | CL | Futures | 178.2 | 178.71 | 178.13 | 178.71 | 848.0 |
| 2009-10-25 22:00:00 | CL | Futures | 178.71 | 178.8 | 178.33 | 178.56 | 916.0 |
| 2009-10-25 23:00:00 | CL | Futures | 178.53 | 178.6 | 177.86 | 178.18 | 632.0 |
| 2009-10-25 18:00:00 | ZN | Futures | 94.29466 | 94.357398 | 94.257017 | 94.357398 | 5316.0 |
| 2009-10-25 19:00:00 | ZN | Futures | 94.34485 | 94.357398 | 94.332303 | 94.34485 | 1311.0 |
| 2009-10-25 20:00:00 | ZN | Futures | 94.34485 | 94.34485 | 94.282113 | 94.29466 | 4478.0 |
| 2009-10-25 21:00:00 | ZN | Futures | 94.307208 | 94.319755 | 94.29466 | 94.307208 | 1345.0 |
| 2009-10-25 22:00:00 | ZN | Futures | 94.307208 | 94.307208 | 94.282113 | 94.29466 | 3778.0 |
| 2009-10-25 23:00:00 | ZN | Futures | 94.29466 | 94.307208 | 94.282113 | 94.29466 | 1291.0 |
> showing 30 of 232 rows — these rows as CSV