PREVIEW / futures_1min / 2018-01-31
file: by_date/futures_1min/2018/2018-01-31.parquet size: 743 KB rows: 68,007
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-01-31 00:00:00 | ES | Futures | 3097.08 | 3097.35 | 3096.81 | 3097.08 | 81.0 |
| 2018-01-31 00:01:00 | ES | Futures | 3097.08 | 3097.35 | 3097.08 | 3097.35 | 33.0 |
| 2018-01-31 00:02:00 | ES | Futures | 3097.08 | 3097.35 | 3097.08 | 3097.08 | 13.0 |
| 2018-01-31 00:03:00 | ES | Futures | 3097.35 | 3097.63 | 3097.35 | 3097.63 | 37.0 |
| 2018-01-31 00:04:00 | ES | Futures | 3097.63 | 3097.63 | 3097.35 | 3097.63 | 35.0 |
| 2018-01-31 00:05:00 | ES | Futures | 3097.63 | 3097.9 | 3097.63 | 3097.9 | 35.0 |
| 2018-01-31 00:06:00 | ES | Futures | 3097.63 | 3097.63 | 3096.53 | 3096.53 | 144.0 |
| 2018-01-31 00:07:00 | ES | Futures | 3096.53 | 3096.53 | 3096.26 | 3096.53 | 129.0 |
| 2018-01-31 00:08:00 | ES | Futures | 3096.53 | 3096.53 | 3095.99 | 3096.26 | 95.0 |
| 2018-01-31 00:09:00 | ES | Futures | 3095.99 | 3096.26 | 3095.71 | 3095.71 | 107.0 |
| 2018-01-31 00:10:00 | ES | Futures | 3095.99 | 3096.53 | 3095.99 | 3095.99 | 146.0 |
| 2018-01-31 00:11:00 | ES | Futures | 3095.99 | 3096.53 | 3095.99 | 3096.26 | 113.0 |
| 2018-01-31 00:12:00 | ES | Futures | 3096.26 | 3096.26 | 3095.71 | 3095.71 | 101.0 |
| 2018-01-31 00:13:00 | ES | Futures | 3095.71 | 3095.99 | 3095.71 | 3095.99 | 89.0 |
| 2018-01-31 00:14:00 | ES | Futures | 3095.99 | 3095.99 | 3095.71 | 3095.99 | 65.0 |
| 2018-01-31 00:15:00 | ES | Futures | 3095.99 | 3096.26 | 3095.99 | 3096.26 | 98.0 |
| 2018-01-31 00:16:00 | ES | Futures | 3095.99 | 3095.99 | 3095.71 | 3095.71 | 183.0 |
| 2018-01-31 00:17:00 | ES | Futures | 3095.71 | 3096.26 | 3095.71 | 3095.99 | 43.0 |
| 2018-01-31 00:18:00 | ES | Futures | 3095.99 | 3095.99 | 3095.17 | 3095.17 | 139.0 |
| 2018-01-31 00:19:00 | ES | Futures | 3095.17 | 3095.17 | 3094.07 | 3094.62 | 861.0 |
| 2018-01-31 00:20:00 | ES | Futures | 3094.62 | 3094.89 | 3094.35 | 3094.89 | 82.0 |
| 2018-01-31 00:21:00 | ES | Futures | 3094.62 | 3094.89 | 3094.35 | 3094.89 | 73.0 |
| 2018-01-31 00:22:00 | ES | Futures | 3094.89 | 3095.17 | 3094.62 | 3094.62 | 89.0 |
| 2018-01-31 00:23:00 | ES | Futures | 3094.62 | 3094.89 | 3094.07 | 3094.07 | 588.0 |
| 2018-01-31 00:24:00 | ES | Futures | 3094.07 | 3094.07 | 3091.89 | 3092.16 | 890.0 |
| 2018-01-31 00:25:00 | ES | Futures | 3092.16 | 3092.71 | 3091.89 | 3092.43 | 582.0 |
| 2018-01-31 00:26:00 | ES | Futures | 3092.43 | 3092.98 | 3092.43 | 3092.98 | 140.0 |
| 2018-01-31 00:27:00 | ES | Futures | 3092.71 | 3093.53 | 3092.71 | 3093.53 | 149.0 |
| 2018-01-31 00:28:00 | ES | Futures | 3093.53 | 3093.53 | 3092.71 | 3092.98 | 115.0 |
| 2018-01-31 00:29:00 | ES | Futures | 3093.25 | 3093.25 | 3091.89 | 3091.89 | 127.0 |
| 2018-01-31 00:30:00 | ES | Futures | 3091.89 | 3092.16 | 3091.34 | 3091.61 | 227.0 |
| 2018-01-31 00:31:00 | ES | Futures | 3091.61 | 3091.89 | 3091.07 | 3091.34 | 290.0 |
| 2018-01-31 00:32:00 | ES | Futures | 3091.61 | 3091.89 | 3091.34 | 3091.61 | 355.0 |
| 2018-01-31 00:33:00 | ES | Futures | 3091.34 | 3091.61 | 3090.52 | 3091.07 | 293.0 |
| 2018-01-31 00:34:00 | ES | Futures | 3091.34 | 3091.89 | 3091.07 | 3091.61 | 201.0 |
| 2018-01-31 00:35:00 | ES | Futures | 3091.34 | 3091.61 | 3091.34 | 3091.34 | 194.0 |
| 2018-01-31 00:36:00 | ES | Futures | 3091.61 | 3091.61 | 3091.34 | 3091.34 | 41.0 |
| 2018-01-31 00:37:00 | ES | Futures | 3091.34 | 3091.61 | 3091.07 | 3091.61 | 151.0 |
| 2018-01-31 00:38:00 | ES | Futures | 3091.34 | 3091.61 | 3091.07 | 3091.07 | 210.0 |
| 2018-01-31 00:39:00 | ES | Futures | 3091.07 | 3091.34 | 3090.52 | 3090.79 | 208.0 |
| 2018-01-31 00:40:00 | ES | Futures | 3090.79 | 3092.16 | 3090.79 | 3092.16 | 218.0 |
| 2018-01-31 00:41:00 | ES | Futures | 3092.16 | 3092.16 | 3091.34 | 3091.34 | 107.0 |
| 2018-01-31 00:42:00 | ES | Futures | 3091.34 | 3091.61 | 3091.34 | 3091.61 | 36.0 |
| 2018-01-31 00:43:00 | ES | Futures | 3091.61 | 3091.61 | 3090.79 | 3090.79 | 227.0 |
| 2018-01-31 00:44:00 | ES | Futures | 3090.79 | 3090.79 | 3089.97 | 3090.25 | 264.0 |
| 2018-01-31 00:45:00 | ES | Futures | 3090.25 | 3090.52 | 3090.25 | 3090.52 | 100.0 |
| 2018-01-31 00:46:00 | ES | Futures | 3090.52 | 3090.79 | 3090.52 | 3090.79 | 56.0 |
| 2018-01-31 00:47:00 | ES | Futures | 3091.07 | 3091.61 | 3091.07 | 3091.34 | 147.0 |
| 2018-01-31 00:48:00 | ES | Futures | 3091.61 | 3091.61 | 3091.07 | 3091.34 | 101.0 |
| 2018-01-31 00:49:00 | ES | Futures | 3091.34 | 3091.89 | 3091.07 | 3091.61 | 156.0 |
> showing 50 of 68,007 rows — these rows as CSV