PREVIEW / futures_5min / 2018-05-31
file: by_date/futures_5min/2018/2018-05-31.parquet size: 270 KB rows: 16,353
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-05-31 00:00:00 | ES | Futures | 2971.97 | 2972.24 | 2971.7 | 2971.97 | 151.0 |
| 2018-05-31 00:05:00 | ES | Futures | 2971.7 | 2972.79 | 2971.7 | 2972.24 | 364.0 |
| 2018-05-31 00:10:00 | ES | Futures | 2972.51 | 2973.06 | 2972.24 | 2972.51 | 301.0 |
| 2018-05-31 00:15:00 | ES | Futures | 2972.51 | 2972.51 | 2972.24 | 2972.51 | 71.0 |
| 2018-05-31 00:20:00 | ES | Futures | 2972.51 | 2972.51 | 2971.97 | 2972.24 | 96.0 |
| 2018-05-31 00:25:00 | ES | Futures | 2972.24 | 2972.24 | 2971.7 | 2972.24 | 235.0 |
| 2018-05-31 00:30:00 | ES | Futures | 2972.24 | 2972.24 | 2971.97 | 2971.97 | 110.0 |
| 2018-05-31 00:35:00 | ES | Futures | 2971.97 | 2972.24 | 2971.7 | 2972.24 | 134.0 |
| 2018-05-31 00:40:00 | ES | Futures | 2972.24 | 2972.24 | 2971.97 | 2972.24 | 48.0 |
| 2018-05-31 00:45:00 | ES | Futures | 2972.24 | 2972.24 | 2971.97 | 2972.24 | 78.0 |
| 2018-05-31 00:50:00 | ES | Futures | 2972.24 | 2972.51 | 2971.97 | 2972.24 | 114.0 |
| 2018-05-31 00:55:00 | ES | Futures | 2972.24 | 2972.79 | 2972.24 | 2972.79 | 184.0 |
| 2018-05-31 01:00:00 | ES | Futures | 2972.79 | 2972.79 | 2972.24 | 2972.51 | 191.0 |
| 2018-05-31 01:05:00 | ES | Futures | 2972.79 | 2972.79 | 2972.51 | 2972.51 | 33.0 |
| 2018-05-31 01:10:00 | ES | Futures | 2972.51 | 2972.51 | 2972.24 | 2972.24 | 93.0 |
| 2018-05-31 01:15:00 | ES | Futures | 2972.51 | 2973.06 | 2972.24 | 2972.79 | 190.0 |
| 2018-05-31 01:20:00 | ES | Futures | 2972.79 | 2973.06 | 2972.24 | 2972.51 | 216.0 |
| 2018-05-31 01:25:00 | ES | Futures | 2972.79 | 2973.06 | 2972.51 | 2972.79 | 358.0 |
| 2018-05-31 01:30:00 | ES | Futures | 2973.06 | 2973.61 | 2972.79 | 2973.06 | 503.0 |
| 2018-05-31 01:35:00 | ES | Futures | 2973.06 | 2974.15 | 2973.06 | 2973.61 | 983.0 |
| 2018-05-31 01:40:00 | ES | Futures | 2973.61 | 2973.88 | 2973.33 | 2973.61 | 604.0 |
| 2018-05-31 01:45:00 | ES | Futures | 2973.61 | 2973.88 | 2973.33 | 2973.88 | 454.0 |
| 2018-05-31 01:50:00 | ES | Futures | 2973.88 | 2974.15 | 2973.61 | 2973.88 | 349.0 |
| 2018-05-31 01:55:00 | ES | Futures | 2973.88 | 2973.88 | 2971.15 | 2971.7 | 1197.0 |
| 2018-05-31 02:00:00 | ES | Futures | 2971.42 | 2971.7 | 2969.51 | 2969.79 | 1506.0 |
| 2018-05-31 02:05:00 | ES | Futures | 2969.79 | 2970.6 | 2969.51 | 2970.6 | 443.0 |
| 2018-05-31 02:10:00 | ES | Futures | 2970.6 | 2971.15 | 2970.33 | 2970.6 | 419.0 |
| 2018-05-31 02:15:00 | ES | Futures | 2970.88 | 2971.15 | 2968.97 | 2970.33 | 1285.0 |
| 2018-05-31 02:20:00 | ES | Futures | 2970.06 | 2970.6 | 2969.24 | 2970.33 | 597.0 |
| 2018-05-31 02:25:00 | ES | Futures | 2970.33 | 2973.06 | 2970.33 | 2972.79 | 964.0 |
| 2018-05-31 02:30:00 | ES | Futures | 2972.79 | 2972.79 | 2971.7 | 2972.24 | 603.0 |
| 2018-05-31 02:35:00 | ES | Futures | 2972.24 | 2973.61 | 2971.97 | 2972.51 | 543.0 |
| 2018-05-31 02:40:00 | ES | Futures | 2972.51 | 2973.61 | 2972.51 | 2972.79 | 542.0 |
| 2018-05-31 02:45:00 | ES | Futures | 2972.51 | 2973.33 | 2972.24 | 2973.33 | 408.0 |
| 2018-05-31 02:50:00 | ES | Futures | 2973.61 | 2974.42 | 2973.06 | 2974.15 | 456.0 |
| 2018-05-31 02:55:00 | ES | Futures | 2974.15 | 2974.42 | 2973.61 | 2974.42 | 428.0 |
| 2018-05-31 03:00:00 | ES | Futures | 2974.15 | 2974.42 | 2971.97 | 2973.61 | 2456.0 |
| 2018-05-31 03:05:00 | ES | Futures | 2973.33 | 2973.33 | 2970.33 | 2970.88 | 1438.0 |
| 2018-05-31 03:10:00 | ES | Futures | 2970.88 | 2972.51 | 2970.6 | 2971.42 | 765.0 |
| 2018-05-31 03:15:00 | ES | Futures | 2971.42 | 2972.24 | 2970.33 | 2970.6 | 1023.0 |
| 2018-05-31 03:20:00 | ES | Futures | 2970.6 | 2972.24 | 2970.06 | 2971.97 | 1342.0 |
| 2018-05-31 03:25:00 | ES | Futures | 2971.97 | 2974.15 | 2971.97 | 2973.06 | 1119.0 |
| 2018-05-31 03:30:00 | ES | Futures | 2973.06 | 2973.61 | 2972.24 | 2973.33 | 959.0 |
| 2018-05-31 03:35:00 | ES | Futures | 2973.33 | 2975.52 | 2972.79 | 2974.7 | 1884.0 |
| 2018-05-31 03:40:00 | ES | Futures | 2974.97 | 2976.06 | 2973.88 | 2974.97 | 1730.0 |
| 2018-05-31 03:45:00 | ES | Futures | 2974.97 | 2976.88 | 2974.7 | 2976.88 | 1844.0 |
| 2018-05-31 03:50:00 | ES | Futures | 2976.88 | 2977.43 | 2976.61 | 2976.61 | 2149.0 |
| 2018-05-31 03:55:00 | ES | Futures | 2976.34 | 2976.88 | 2976.06 | 2976.06 | 934.0 |
| 2018-05-31 04:00:00 | ES | Futures | 2976.34 | 2976.34 | 2973.61 | 2973.88 | 1509.0 |
| 2018-05-31 04:05:00 | ES | Futures | 2973.88 | 2975.52 | 2973.88 | 2975.52 | 620.0 |
> showing 50 of 16,353 rows — these rows as CSV