PREVIEW / futures_5min / 2014-01-01
file: by_date/futures_5min/2014/2014-01-01.parquet size: 18 KB rows: 694
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 |
|---|---|---|---|---|---|---|---|
| 2014-01-01 18:00:00 | CL | Futures | 155.11 | 155.55 | 155.11 | 155.47 | 213.0 |
| 2014-01-01 18:05:00 | CL | Futures | 155.47 | 155.47 | 155.27 | 155.34 | 68.0 |
| 2014-01-01 18:10:00 | CL | Futures | 155.33 | 155.34 | 155.3 | 155.31 | 21.0 |
| 2014-01-01 18:15:00 | CL | Futures | 155.31 | 155.38 | 155.31 | 155.38 | 14.0 |
| 2014-01-01 18:20:00 | CL | Futures | 155.38 | 155.39 | 155.36 | 155.36 | 4.0 |
| 2014-01-01 18:25:00 | CL | Futures | 155.38 | 155.39 | 155.38 | 155.38 | 12.0 |
| 2014-01-01 18:30:00 | CL | Futures | 155.38 | 155.39 | 155.36 | 155.39 | 6.0 |
| 2014-01-01 18:35:00 | CL | Futures | 155.39 | 155.42 | 155.36 | 155.42 | 26.0 |
| 2014-01-01 18:40:00 | CL | Futures | 155.42 | 155.42 | 155.39 | 155.42 | 8.0 |
| 2014-01-01 18:45:00 | CL | Futures | 155.41 | 155.42 | 155.38 | 155.42 | 15.0 |
| 2014-01-01 18:50:00 | CL | Futures | 155.44 | 155.46 | 155.41 | 155.44 | 11.0 |
| 2014-01-01 18:55:00 | CL | Futures | 155.42 | 155.46 | 155.42 | 155.44 | 11.0 |
| 2014-01-01 19:00:00 | CL | Futures | 155.44 | 155.49 | 155.44 | 155.49 | 14.0 |
| 2014-01-01 19:05:00 | CL | Futures | 155.49 | 155.5 | 155.46 | 155.46 | 13.0 |
| 2014-01-01 19:10:00 | CL | Futures | 155.44 | 155.46 | 155.44 | 155.46 | 5.0 |
| 2014-01-01 19:15:00 | CL | Futures | 155.46 | 155.46 | 155.44 | 155.46 | 15.0 |
| 2014-01-01 19:20:00 | CL | Futures | 155.44 | 155.47 | 155.44 | 155.46 | 28.0 |
| 2014-01-01 19:25:00 | CL | Futures | 155.46 | 155.47 | 155.46 | 155.47 | 31.0 |
| 2014-01-01 19:30:00 | CL | Futures | 155.46 | 155.47 | 155.46 | 155.46 | 5.0 |
| 2014-01-01 19:35:00 | CL | Futures | 155.47 | 155.47 | 155.44 | 155.44 | 4.0 |
| 2014-01-01 19:40:00 | CL | Futures | 155.44 | 155.46 | 155.44 | 155.44 | 8.0 |
| 2014-01-01 19:45:00 | CL | Futures | 155.44 | 155.44 | 155.39 | 155.41 | 33.0 |
| 2014-01-01 19:50:00 | CL | Futures | 155.41 | 155.46 | 155.36 | 155.42 | 50.0 |
| 2014-01-01 19:55:00 | CL | Futures | 155.42 | 155.44 | 155.42 | 155.44 | 7.0 |
| 2014-01-01 20:00:00 | CL | Futures | 155.42 | 155.46 | 155.41 | 155.42 | 30.0 |
| 2014-01-01 20:05:00 | CL | Futures | 155.42 | 155.42 | 155.42 | 155.42 | 1.0 |
| 2014-01-01 20:10:00 | CL | Futures | 155.44 | 155.47 | 155.44 | 155.44 | 37.0 |
| 2014-01-01 20:15:00 | CL | Futures | 155.44 | 155.44 | 155.41 | 155.41 | 22.0 |
| 2014-01-01 20:20:00 | CL | Futures | 155.41 | 155.41 | 155.33 | 155.38 | 73.0 |
| 2014-01-01 20:25:00 | CL | Futures | 155.33 | 155.33 | 155.23 | 155.27 | 35.0 |
| 2014-01-01 20:30:00 | CL | Futures | 155.27 | 155.28 | 155.2 | 155.2 | 47.0 |
| 2014-01-01 20:35:00 | CL | Futures | 155.22 | 155.22 | 155.19 | 155.2 | 39.0 |
| 2014-01-01 20:40:00 | CL | Futures | 155.22 | 155.27 | 155.22 | 155.25 | 65.0 |
| 2014-01-01 20:45:00 | CL | Futures | 155.28 | 155.28 | 155.22 | 155.22 | 16.0 |
| 2014-01-01 20:50:00 | CL | Futures | 155.2 | 155.28 | 155.2 | 155.28 | 50.0 |
| 2014-01-01 20:55:00 | CL | Futures | 155.27 | 155.27 | 155.19 | 155.2 | 37.0 |
| 2014-01-01 21:00:00 | CL | Futures | 155.2 | 155.28 | 155.19 | 155.27 | 57.0 |
| 2014-01-01 21:05:00 | CL | Futures | 155.25 | 155.27 | 155.23 | 155.25 | 13.0 |
| 2014-01-01 21:10:00 | CL | Futures | 155.23 | 155.27 | 155.23 | 155.27 | 21.0 |
| 2014-01-01 21:15:00 | CL | Futures | 155.28 | 155.31 | 155.28 | 155.31 | 12.0 |
| 2014-01-01 21:20:00 | CL | Futures | 155.3 | 155.3 | 155.28 | 155.3 | 8.0 |
| 2014-01-01 21:25:00 | CL | Futures | 155.3 | 155.3 | 155.25 | 155.25 | 13.0 |
| 2014-01-01 21:30:00 | CL | Futures | 155.23 | 155.27 | 155.23 | 155.25 | 19.0 |
| 2014-01-01 21:35:00 | CL | Futures | 155.25 | 155.25 | 155.22 | 155.22 | 10.0 |
| 2014-01-01 21:40:00 | CL | Futures | 155.2 | 155.27 | 155.2 | 155.22 | 14.0 |
| 2014-01-01 21:45:00 | CL | Futures | 155.22 | 155.25 | 155.22 | 155.23 | 12.0 |
| 2014-01-01 21:50:00 | CL | Futures | 155.23 | 155.31 | 155.23 | 155.3 | 21.0 |
| 2014-01-01 21:55:00 | CL | Futures | 155.3 | 155.3 | 155.25 | 155.28 | 12.0 |
| 2014-01-01 22:00:00 | CL | Futures | 155.27 | 155.27 | 155.27 | 155.27 | 6.0 |
| 2014-01-01 22:05:00 | CL | Futures | 155.28 | 155.28 | 155.28 | 155.28 | 4.0 |
> showing 50 of 694 rows — these rows as CSV