PREVIEW / futures_1min / 2017-01-29
file: by_date/futures_1min/2017/2017-01-29.parquet size: 104 KB rows: 9,103
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-29 18:00:00 | ES | Futures | 2489.83 | 2492.56 | 2489.83 | 2491.47 | 4752.0 |
| 2017-01-29 18:01:00 | ES | Futures | 2491.47 | 2492.56 | 2491.2 | 2491.47 | 747.0 |
| 2017-01-29 18:02:00 | ES | Futures | 2491.74 | 2491.74 | 2490.93 | 2491.2 | 425.0 |
| 2017-01-29 18:03:00 | ES | Futures | 2490.93 | 2492.56 | 2490.93 | 2492.56 | 841.0 |
| 2017-01-29 18:04:00 | ES | Futures | 2492.29 | 2492.56 | 2491.74 | 2492.02 | 547.0 |
| 2017-01-29 18:05:00 | ES | Futures | 2492.29 | 2492.29 | 2491.74 | 2492.02 | 722.0 |
| 2017-01-29 18:06:00 | ES | Futures | 2491.74 | 2492.56 | 2491.74 | 2492.29 | 383.0 |
| 2017-01-29 18:07:00 | ES | Futures | 2492.02 | 2492.29 | 2491.47 | 2491.74 | 230.0 |
| 2017-01-29 18:08:00 | ES | Futures | 2491.74 | 2491.74 | 2491.47 | 2491.47 | 99.0 |
| 2017-01-29 18:09:00 | ES | Futures | 2491.74 | 2491.74 | 2490.93 | 2491.2 | 262.0 |
| 2017-01-29 18:10:00 | ES | Futures | 2491.2 | 2491.2 | 2490.38 | 2490.65 | 762.0 |
| 2017-01-29 18:11:00 | ES | Futures | 2490.65 | 2491.47 | 2490.65 | 2491.2 | 250.0 |
| 2017-01-29 18:12:00 | ES | Futures | 2491.47 | 2491.47 | 2490.93 | 2490.93 | 190.0 |
| 2017-01-29 18:13:00 | ES | Futures | 2490.93 | 2491.47 | 2490.65 | 2491.2 | 183.0 |
| 2017-01-29 18:14:00 | ES | Futures | 2491.2 | 2491.47 | 2491.2 | 2491.47 | 161.0 |
| 2017-01-29 18:15:00 | ES | Futures | 2491.47 | 2491.47 | 2491.2 | 2491.2 | 103.0 |
| 2017-01-29 18:16:00 | ES | Futures | 2491.47 | 2491.47 | 2491.2 | 2491.47 | 49.0 |
| 2017-01-29 18:17:00 | ES | Futures | 2491.47 | 2491.74 | 2491.2 | 2491.2 | 116.0 |
| 2017-01-29 18:18:00 | ES | Futures | 2491.47 | 2491.74 | 2491.2 | 2491.47 | 83.0 |
| 2017-01-29 18:19:00 | ES | Futures | 2491.47 | 2491.74 | 2491.2 | 2491.74 | 51.0 |
| 2017-01-29 18:20:00 | ES | Futures | 2491.74 | 2492.02 | 2491.74 | 2491.74 | 208.0 |
| 2017-01-29 18:21:00 | ES | Futures | 2491.74 | 2491.74 | 2491.47 | 2491.74 | 53.0 |
| 2017-01-29 18:22:00 | ES | Futures | 2491.47 | 2491.74 | 2491.47 | 2491.47 | 40.0 |
| 2017-01-29 18:23:00 | ES | Futures | 2491.74 | 2491.74 | 2490.93 | 2490.93 | 165.0 |
| 2017-01-29 18:24:00 | ES | Futures | 2490.93 | 2490.93 | 2490.65 | 2490.65 | 393.0 |
| 2017-01-29 18:25:00 | ES | Futures | 2490.93 | 2490.93 | 2490.38 | 2490.65 | 139.0 |
| 2017-01-29 18:26:00 | ES | Futures | 2490.38 | 2490.65 | 2489.83 | 2490.11 | 774.0 |
| 2017-01-29 18:27:00 | ES | Futures | 2490.11 | 2490.11 | 2489.83 | 2489.83 | 63.0 |
| 2017-01-29 18:28:00 | ES | Futures | 2489.83 | 2490.11 | 2489.83 | 2490.11 | 168.0 |
| 2017-01-29 18:29:00 | ES | Futures | 2490.11 | 2490.38 | 2489.83 | 2490.11 | 543.0 |
| 2017-01-29 18:30:00 | ES | Futures | 2489.83 | 2490.38 | 2489.29 | 2489.56 | 1077.0 |
| 2017-01-29 18:31:00 | ES | Futures | 2489.83 | 2490.38 | 2489.56 | 2490.11 | 216.0 |
| 2017-01-29 18:32:00 | ES | Futures | 2490.38 | 2490.65 | 2489.83 | 2490.38 | 591.0 |
| 2017-01-29 18:33:00 | ES | Futures | 2490.65 | 2490.65 | 2490.11 | 2490.38 | 267.0 |
| 2017-01-29 18:34:00 | ES | Futures | 2490.38 | 2490.38 | 2490.11 | 2490.11 | 104.0 |
| 2017-01-29 18:35:00 | ES | Futures | 2490.11 | 2490.38 | 2489.83 | 2490.11 | 183.0 |
| 2017-01-29 18:36:00 | ES | Futures | 2490.38 | 2490.65 | 2490.11 | 2490.11 | 64.0 |
| 2017-01-29 18:37:00 | ES | Futures | 2490.38 | 2490.38 | 2490.11 | 2490.11 | 48.0 |
| 2017-01-29 18:38:00 | ES | Futures | 2490.38 | 2490.38 | 2490.11 | 2490.11 | 87.0 |
| 2017-01-29 18:39:00 | ES | Futures | 2490.38 | 2490.65 | 2490.38 | 2490.65 | 101.0 |
| 2017-01-29 18:40:00 | ES | Futures | 2490.65 | 2490.65 | 2490.38 | 2490.65 | 58.0 |
| 2017-01-29 18:41:00 | ES | Futures | 2490.65 | 2490.65 | 2490.38 | 2490.65 | 179.0 |
| 2017-01-29 18:42:00 | ES | Futures | 2490.38 | 2490.65 | 2490.38 | 2490.38 | 121.0 |
| 2017-01-29 18:43:00 | ES | Futures | 2490.65 | 2490.65 | 2490.38 | 2490.38 | 26.0 |
| 2017-01-29 18:44:00 | ES | Futures | 2490.65 | 2490.65 | 2490.38 | 2490.38 | 32.0 |
| 2017-01-29 18:45:00 | ES | Futures | 2490.65 | 2490.93 | 2490.11 | 2490.11 | 296.0 |
| 2017-01-29 18:46:00 | ES | Futures | 2490.38 | 2490.38 | 2490.11 | 2490.38 | 132.0 |
| 2017-01-29 18:47:00 | ES | Futures | 2490.38 | 2490.38 | 2490.11 | 2490.11 | 37.0 |
| 2017-01-29 18:48:00 | ES | Futures | 2490.38 | 2490.38 | 2490.11 | 2490.38 | 32.0 |
| 2017-01-29 18:49:00 | ES | Futures | 2490.11 | 2490.65 | 2490.11 | 2490.38 | 202.0 |
> showing 50 of 9,103 rows — these rows as CSV