PREVIEW / futures_1min / 2018-07-31
file: by_date/futures_1min/2018/2018-07-31.parquet size: 685 KB rows: 61,651
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-31 00:00:00 | ES | Futures | 3057.34 | 3057.34 | 3057.07 | 3057.34 | 26.0 |
| 2018-07-31 00:01:00 | ES | Futures | 3057.34 | 3057.89 | 3057.34 | 3057.62 | 29.0 |
| 2018-07-31 00:02:00 | ES | Futures | 3057.62 | 3057.89 | 3057.62 | 3057.62 | 7.0 |
| 2018-07-31 00:03:00 | ES | Futures | 3057.34 | 3058.98 | 3057.07 | 3057.34 | 781.0 |
| 2018-07-31 00:04:00 | ES | Futures | 3057.34 | 3058.16 | 3057.34 | 3057.62 | 299.0 |
| 2018-07-31 00:05:00 | ES | Futures | 3057.62 | 3060.34 | 3057.62 | 3059.52 | 842.0 |
| 2018-07-31 00:06:00 | ES | Futures | 3059.52 | 3059.8 | 3058.71 | 3058.71 | 482.0 |
| 2018-07-31 00:07:00 | ES | Futures | 3058.98 | 3058.98 | 3058.16 | 3058.16 | 243.0 |
| 2018-07-31 00:08:00 | ES | Futures | 3058.43 | 3058.43 | 3057.89 | 3057.89 | 323.0 |
| 2018-07-31 00:09:00 | ES | Futures | 3057.89 | 3058.43 | 3057.89 | 3058.16 | 143.0 |
| 2018-07-31 00:10:00 | ES | Futures | 3058.16 | 3058.16 | 3057.62 | 3057.89 | 126.0 |
| 2018-07-31 00:11:00 | ES | Futures | 3058.16 | 3058.16 | 3057.34 | 3057.62 | 160.0 |
| 2018-07-31 00:12:00 | ES | Futures | 3057.34 | 3058.71 | 3057.34 | 3058.71 | 91.0 |
| 2018-07-31 00:13:00 | ES | Futures | 3058.71 | 3058.98 | 3058.43 | 3058.98 | 288.0 |
| 2018-07-31 00:14:00 | ES | Futures | 3058.98 | 3059.52 | 3058.71 | 3059.25 | 373.0 |
| 2018-07-31 00:15:00 | ES | Futures | 3058.98 | 3059.52 | 3058.98 | 3059.25 | 285.0 |
| 2018-07-31 00:16:00 | ES | Futures | 3059.25 | 3059.8 | 3058.98 | 3059.25 | 200.0 |
| 2018-07-31 00:17:00 | ES | Futures | 3059.25 | 3059.25 | 3058.71 | 3058.98 | 131.0 |
| 2018-07-31 00:18:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3058.98 | 177.0 |
| 2018-07-31 00:19:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3058.98 | 278.0 |
| 2018-07-31 00:20:00 | ES | Futures | 3058.71 | 3058.98 | 3058.71 | 3058.71 | 47.0 |
| 2018-07-31 00:21:00 | ES | Futures | 3058.71 | 3058.98 | 3058.71 | 3058.98 | 18.0 |
| 2018-07-31 00:22:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3058.98 | 66.0 |
| 2018-07-31 00:23:00 | ES | Futures | 3058.98 | 3058.98 | 3058.71 | 3058.71 | 61.0 |
| 2018-07-31 00:24:00 | ES | Futures | 3058.98 | 3058.98 | 3058.98 | 3058.98 | 26.0 |
| 2018-07-31 00:25:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3058.71 | 23.0 |
| 2018-07-31 00:26:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3059.25 | 71.0 |
| 2018-07-31 00:27:00 | ES | Futures | 3059.25 | 3059.52 | 3059.25 | 3059.52 | 36.0 |
| 2018-07-31 00:28:00 | ES | Futures | 3059.52 | 3060.07 | 3059.52 | 3059.52 | 150.0 |
| 2018-07-31 00:29:00 | ES | Futures | 3059.8 | 3059.8 | 3058.98 | 3059.25 | 177.0 |
| 2018-07-31 00:30:00 | ES | Futures | 3058.98 | 3059.25 | 3058.98 | 3058.98 | 14.0 |
| 2018-07-31 00:31:00 | ES | Futures | 3058.98 | 3059.25 | 3058.98 | 3059.25 | 12.0 |
| 2018-07-31 00:32:00 | ES | Futures | 3058.98 | 3059.25 | 3058.98 | 3058.98 | 16.0 |
| 2018-07-31 00:33:00 | ES | Futures | 3058.98 | 3058.98 | 3058.43 | 3058.98 | 109.0 |
| 2018-07-31 00:34:00 | ES | Futures | 3058.71 | 3058.71 | 3058.71 | 3058.71 | 69.0 |
| 2018-07-31 00:35:00 | ES | Futures | 3058.71 | 3058.98 | 3058.43 | 3058.71 | 87.0 |
| 2018-07-31 00:36:00 | ES | Futures | 3058.98 | 3059.25 | 3058.71 | 3059.25 | 38.0 |
| 2018-07-31 00:37:00 | ES | Futures | 3059.25 | 3059.25 | 3058.98 | 3058.98 | 72.0 |
| 2018-07-31 00:38:00 | ES | Futures | 3058.71 | 3058.98 | 3058.71 | 3058.71 | 30.0 |
| 2018-07-31 00:39:00 | ES | Futures | 3058.98 | 3059.25 | 3058.98 | 3058.98 | 84.0 |
| 2018-07-31 00:40:00 | ES | Futures | 3058.71 | 3059.52 | 3058.71 | 3059.25 | 114.0 |
| 2018-07-31 00:41:00 | ES | Futures | 3059.25 | 3059.25 | 3058.98 | 3059.25 | 130.0 |
| 2018-07-31 00:42:00 | ES | Futures | 3058.98 | 3059.52 | 3058.98 | 3058.98 | 114.0 |
| 2018-07-31 00:43:00 | ES | Futures | 3059.25 | 3059.52 | 3059.25 | 3059.52 | 105.0 |
| 2018-07-31 00:44:00 | ES | Futures | 3059.52 | 3059.8 | 3059.52 | 3059.8 | 152.0 |
| 2018-07-31 00:45:00 | ES | Futures | 3059.8 | 3060.07 | 3059.8 | 3059.8 | 92.0 |
| 2018-07-31 00:46:00 | ES | Futures | 3059.8 | 3059.8 | 3059.52 | 3059.52 | 62.0 |
| 2018-07-31 00:47:00 | ES | Futures | 3059.52 | 3059.8 | 3059.52 | 3059.8 | 102.0 |
| 2018-07-31 00:48:00 | ES | Futures | 3059.52 | 3060.07 | 3059.52 | 3059.8 | 72.0 |
| 2018-07-31 00:49:00 | ES | Futures | 3060.07 | 3060.07 | 3059.8 | 3059.8 | 36.0 |
> showing 50 of 61,651 rows — these rows as CSV