PREVIEW / futures_1min / 2017-01-31
file: by_date/futures_1min/2017/2017-01-31.parquet size: 714 KB rows: 63,357
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 |
|---|---|---|---|---|---|---|---|
| 2017-01-31 00:00:00 | ES | Futures | 2476.47 | 2476.47 | 2476.2 | 2476.47 | 67.0 |
| 2017-01-31 00:01:00 | ES | Futures | 2476.47 | 2476.47 | 2476.2 | 2476.47 | 27.0 |
| 2017-01-31 00:02:00 | ES | Futures | 2476.47 | 2476.74 | 2476.47 | 2476.47 | 74.0 |
| 2017-01-31 00:03:00 | ES | Futures | 2476.47 | 2476.47 | 2476.47 | 2476.47 | 82.0 |
| 2017-01-31 00:04:00 | ES | Futures | 2476.2 | 2476.47 | 2475.92 | 2476.2 | 173.0 |
| 2017-01-31 00:05:00 | ES | Futures | 2476.2 | 2476.2 | 2476.2 | 2476.2 | 18.0 |
| 2017-01-31 00:06:00 | ES | Futures | 2476.2 | 2476.2 | 2476.2 | 2476.2 | 1.0 |
| 2017-01-31 00:07:00 | ES | Futures | 2476.2 | 2476.47 | 2476.2 | 2476.47 | 11.0 |
| 2017-01-31 00:08:00 | ES | Futures | 2476.2 | 2476.47 | 2475.65 | 2475.92 | 233.0 |
| 2017-01-31 00:09:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2475.92 | 21.0 |
| 2017-01-31 00:10:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2475.92 | 47.0 |
| 2017-01-31 00:11:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2475.92 | 17.0 |
| 2017-01-31 00:12:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2476.2 | 18.0 |
| 2017-01-31 00:13:00 | ES | Futures | 2475.92 | 2476.2 | 2475.65 | 2475.92 | 62.0 |
| 2017-01-31 00:14:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2476.2 | 132.0 |
| 2017-01-31 00:15:00 | ES | Futures | 2475.92 | 2475.92 | 2475.65 | 2475.65 | 239.0 |
| 2017-01-31 00:16:00 | ES | Futures | 2475.65 | 2475.92 | 2475.38 | 2475.38 | 117.0 |
| 2017-01-31 00:17:00 | ES | Futures | 2475.38 | 2475.65 | 2475.11 | 2475.38 | 154.0 |
| 2017-01-31 00:18:00 | ES | Futures | 2475.65 | 2475.65 | 2475.38 | 2475.38 | 38.0 |
| 2017-01-31 00:19:00 | ES | Futures | 2475.65 | 2475.65 | 2475.38 | 2475.65 | 19.0 |
| 2017-01-31 00:20:00 | ES | Futures | 2475.38 | 2475.65 | 2475.38 | 2475.65 | 44.0 |
| 2017-01-31 00:21:00 | ES | Futures | 2475.65 | 2475.65 | 2475.11 | 2475.38 | 67.0 |
| 2017-01-31 00:22:00 | ES | Futures | 2475.11 | 2475.38 | 2475.11 | 2475.38 | 30.0 |
| 2017-01-31 00:23:00 | ES | Futures | 2475.38 | 2475.38 | 2475.11 | 2475.11 | 25.0 |
| 2017-01-31 00:24:00 | ES | Futures | 2475.11 | 2475.38 | 2474.83 | 2474.83 | 316.0 |
| 2017-01-31 00:25:00 | ES | Futures | 2474.83 | 2475.11 | 2474.56 | 2475.11 | 204.0 |
| 2017-01-31 00:26:00 | ES | Futures | 2475.11 | 2475.38 | 2474.83 | 2475.11 | 212.0 |
| 2017-01-31 00:27:00 | ES | Futures | 2475.11 | 2475.38 | 2475.11 | 2475.11 | 82.0 |
| 2017-01-31 00:28:00 | ES | Futures | 2475.11 | 2475.38 | 2475.11 | 2475.11 | 38.0 |
| 2017-01-31 00:29:00 | ES | Futures | 2475.11 | 2475.65 | 2475.11 | 2475.38 | 179.0 |
| 2017-01-31 00:30:00 | ES | Futures | 2475.38 | 2476.2 | 2475.38 | 2475.92 | 518.0 |
| 2017-01-31 00:31:00 | ES | Futures | 2475.92 | 2475.92 | 2475.65 | 2475.92 | 67.0 |
| 2017-01-31 00:32:00 | ES | Futures | 2475.65 | 2475.92 | 2475.65 | 2475.65 | 16.0 |
| 2017-01-31 00:33:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2476.2 | 44.0 |
| 2017-01-31 00:34:00 | ES | Futures | 2476.2 | 2476.47 | 2475.92 | 2476.47 | 209.0 |
| 2017-01-31 00:35:00 | ES | Futures | 2476.2 | 2476.47 | 2476.2 | 2476.2 | 18.0 |
| 2017-01-31 00:36:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2476.2 | 66.0 |
| 2017-01-31 00:37:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2475.92 | 123.0 |
| 2017-01-31 00:38:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2475.92 | 12.0 |
| 2017-01-31 00:39:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2475.92 | 7.0 |
| 2017-01-31 00:40:00 | ES | Futures | 2475.92 | 2475.92 | 2475.92 | 2475.92 | 5.0 |
| 2017-01-31 00:41:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2475.92 | 84.0 |
| 2017-01-31 00:42:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2476.2 | 9.0 |
| 2017-01-31 00:43:00 | ES | Futures | 2475.92 | 2476.2 | 2475.92 | 2476.2 | 6.0 |
| 2017-01-31 00:44:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2475.92 | 4.0 |
| 2017-01-31 00:45:00 | ES | Futures | 2476.2 | 2476.2 | 2475.92 | 2476.2 | 25.0 |
| 2017-01-31 00:46:00 | ES | Futures | 2476.2 | 2476.47 | 2475.92 | 2476.47 | 69.0 |
| 2017-01-31 00:47:00 | ES | Futures | 2476.47 | 2476.47 | 2476.2 | 2476.47 | 48.0 |
| 2017-01-31 00:48:00 | ES | Futures | 2476.47 | 2476.47 | 2476.2 | 2476.47 | 13.0 |
| 2017-01-31 00:49:00 | ES | Futures | 2476.2 | 2476.47 | 2476.2 | 2476.2 | 16.0 |
> showing 50 of 63,357 rows — these rows as CSV