PREVIEW / futures_1min / 2014-11-02
file: by_date/futures_1min/2014/2014-11-02.parquet size: 102 KB rows: 8,423
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 |
|---|---|---|---|---|---|---|---|
| 2014-11-02 18:00:00 | ES | Futures | 2107.53 | 2108.05 | 2106.74 | 2107.27 | 1931.0 |
| 2014-11-02 18:01:00 | ES | Futures | 2107.53 | 2108.84 | 2107.27 | 2107.79 | 576.0 |
| 2014-11-02 18:02:00 | ES | Futures | 2108.05 | 2108.31 | 2107.79 | 2107.79 | 315.0 |
| 2014-11-02 18:03:00 | ES | Futures | 2107.79 | 2108.31 | 2107.79 | 2108.05 | 177.0 |
| 2014-11-02 18:04:00 | ES | Futures | 2108.31 | 2108.31 | 2107.27 | 2107.27 | 533.0 |
| 2014-11-02 18:05:00 | ES | Futures | 2107.27 | 2107.53 | 2107.0 | 2107.0 | 203.0 |
| 2014-11-02 18:06:00 | ES | Futures | 2107.53 | 2107.53 | 2106.48 | 2107.0 | 181.0 |
| 2014-11-02 18:07:00 | ES | Futures | 2107.0 | 2107.79 | 2107.0 | 2107.79 | 98.0 |
| 2014-11-02 18:08:00 | ES | Futures | 2107.79 | 2107.79 | 2107.27 | 2107.53 | 59.0 |
| 2014-11-02 18:09:00 | ES | Futures | 2107.27 | 2107.53 | 2107.27 | 2107.27 | 5.0 |
| 2014-11-02 18:10:00 | ES | Futures | 2107.27 | 2107.79 | 2107.27 | 2107.53 | 54.0 |
| 2014-11-02 18:11:00 | ES | Futures | 2107.79 | 2107.79 | 2107.0 | 2107.0 | 85.0 |
| 2014-11-02 18:12:00 | ES | Futures | 2107.0 | 2107.27 | 2107.0 | 2107.0 | 21.0 |
| 2014-11-02 18:13:00 | ES | Futures | 2107.0 | 2107.27 | 2107.0 | 2107.0 | 19.0 |
| 2014-11-02 18:14:00 | ES | Futures | 2107.27 | 2107.27 | 2107.0 | 2107.0 | 33.0 |
| 2014-11-02 18:15:00 | ES | Futures | 2107.27 | 2107.27 | 2107.0 | 2107.0 | 55.0 |
| 2014-11-02 18:16:00 | ES | Futures | 2107.0 | 2107.0 | 2106.74 | 2107.0 | 49.0 |
| 2014-11-02 18:17:00 | ES | Futures | 2106.74 | 2106.74 | 2106.22 | 2106.74 | 491.0 |
| 2014-11-02 18:18:00 | ES | Futures | 2106.74 | 2106.74 | 2106.48 | 2106.74 | 70.0 |
| 2014-11-02 18:19:00 | ES | Futures | 2106.74 | 2106.74 | 2106.22 | 2106.48 | 35.0 |
| 2014-11-02 18:20:00 | ES | Futures | 2106.48 | 2106.48 | 2105.96 | 2106.22 | 224.0 |
| 2014-11-02 18:21:00 | ES | Futures | 2106.22 | 2107.53 | 2106.22 | 2106.74 | 455.0 |
| 2014-11-02 18:22:00 | ES | Futures | 2106.74 | 2107.0 | 2106.48 | 2106.74 | 67.0 |
| 2014-11-02 18:23:00 | ES | Futures | 2107.0 | 2107.0 | 2106.74 | 2107.0 | 39.0 |
| 2014-11-02 18:24:00 | ES | Futures | 2107.0 | 2107.0 | 2106.48 | 2106.48 | 47.0 |
| 2014-11-02 18:25:00 | ES | Futures | 2106.48 | 2106.74 | 2106.48 | 2106.48 | 33.0 |
| 2014-11-02 18:26:00 | ES | Futures | 2106.48 | 2107.0 | 2106.48 | 2107.0 | 10.0 |
| 2014-11-02 18:27:00 | ES | Futures | 2107.0 | 2107.0 | 2106.48 | 2106.48 | 99.0 |
| 2014-11-02 18:28:00 | ES | Futures | 2106.48 | 2106.74 | 2106.22 | 2106.22 | 82.0 |
| 2014-11-02 18:29:00 | ES | Futures | 2106.22 | 2106.22 | 2105.96 | 2105.96 | 90.0 |
| 2014-11-02 18:30:00 | ES | Futures | 2106.22 | 2106.22 | 2105.96 | 2105.96 | 27.0 |
| 2014-11-02 18:31:00 | ES | Futures | 2105.96 | 2106.22 | 2105.96 | 2105.96 | 66.0 |
| 2014-11-02 18:32:00 | ES | Futures | 2105.96 | 2106.22 | 2105.96 | 2106.22 | 25.0 |
| 2014-11-02 18:33:00 | ES | Futures | 2106.22 | 2106.22 | 2105.69 | 2106.22 | 48.0 |
| 2014-11-02 18:34:00 | ES | Futures | 2105.96 | 2105.96 | 2105.69 | 2105.96 | 44.0 |
| 2014-11-02 18:35:00 | ES | Futures | 2105.69 | 2105.69 | 2105.17 | 2105.43 | 299.0 |
| 2014-11-02 18:36:00 | ES | Futures | 2105.43 | 2106.22 | 2105.43 | 2105.96 | 145.0 |
| 2014-11-02 18:37:00 | ES | Futures | 2105.96 | 2105.96 | 2105.96 | 2105.96 | 22.0 |
| 2014-11-02 18:38:00 | ES | Futures | 2106.22 | 2106.22 | 2105.96 | 2106.22 | 20.0 |
| 2014-11-02 18:39:00 | ES | Futures | 2106.22 | 2106.48 | 2105.96 | 2106.48 | 144.0 |
| 2014-11-02 18:40:00 | ES | Futures | 2106.22 | 2106.48 | 2106.22 | 2106.22 | 25.0 |
| 2014-11-02 18:41:00 | ES | Futures | 2106.48 | 2106.48 | 2106.22 | 2106.22 | 15.0 |
| 2014-11-02 18:42:00 | ES | Futures | 2106.22 | 2106.22 | 2106.22 | 2106.22 | 7.0 |
| 2014-11-02 18:43:00 | ES | Futures | 2106.22 | 2106.22 | 2106.22 | 2106.22 | 1.0 |
| 2014-11-02 18:44:00 | ES | Futures | 2106.48 | 2106.74 | 2106.48 | 2106.74 | 104.0 |
| 2014-11-02 18:45:00 | ES | Futures | 2106.48 | 2106.74 | 2106.48 | 2106.48 | 21.0 |
| 2014-11-02 18:46:00 | ES | Futures | 2106.48 | 2106.48 | 2106.48 | 2106.48 | 6.0 |
| 2014-11-02 18:47:00 | ES | Futures | 2106.48 | 2106.48 | 2106.22 | 2106.22 | 60.0 |
| 2014-11-02 18:48:00 | ES | Futures | 2106.22 | 2106.22 | 2106.22 | 2106.22 | 55.0 |
| 2014-11-02 18:49:00 | ES | Futures | 2106.22 | 2106.74 | 2106.22 | 2106.74 | 51.0 |
> showing 50 of 8,423 rows — these rows as CSV