PREVIEW / futures_1min / 2018-12-27
file: by_date/futures_1min/2018/2018-12-27.parquet size: 833 KB rows: 66,995
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-12-27 00:00:00 | ES | Futures | 2679.45 | 2679.72 | 2678.91 | 2678.91 | 100.0 |
| 2018-12-27 00:01:00 | ES | Futures | 2678.91 | 2679.45 | 2678.64 | 2679.18 | 96.0 |
| 2018-12-27 00:02:00 | ES | Futures | 2679.18 | 2679.45 | 2679.18 | 2679.18 | 65.0 |
| 2018-12-27 00:03:00 | ES | Futures | 2679.18 | 2679.18 | 2678.91 | 2679.18 | 19.0 |
| 2018-12-27 00:04:00 | ES | Futures | 2679.18 | 2679.45 | 2678.91 | 2679.45 | 107.0 |
| 2018-12-27 00:05:00 | ES | Futures | 2679.18 | 2679.45 | 2679.18 | 2679.18 | 38.0 |
| 2018-12-27 00:06:00 | ES | Futures | 2679.18 | 2679.45 | 2678.91 | 2679.18 | 47.0 |
| 2018-12-27 00:07:00 | ES | Futures | 2679.18 | 2679.72 | 2679.18 | 2679.72 | 68.0 |
| 2018-12-27 00:08:00 | ES | Futures | 2679.45 | 2680.27 | 2679.45 | 2680.0 | 143.0 |
| 2018-12-27 00:09:00 | ES | Futures | 2680.0 | 2680.54 | 2679.72 | 2680.54 | 121.0 |
| 2018-12-27 00:10:00 | ES | Futures | 2680.27 | 2681.08 | 2680.27 | 2680.54 | 239.0 |
| 2018-12-27 00:11:00 | ES | Futures | 2680.54 | 2681.08 | 2680.27 | 2680.81 | 119.0 |
| 2018-12-27 00:12:00 | ES | Futures | 2680.81 | 2681.9 | 2680.81 | 2681.9 | 235.0 |
| 2018-12-27 00:13:00 | ES | Futures | 2681.63 | 2684.34 | 2681.63 | 2684.07 | 788.0 |
| 2018-12-27 00:14:00 | ES | Futures | 2684.07 | 2684.89 | 2683.26 | 2684.34 | 538.0 |
| 2018-12-27 00:15:00 | ES | Futures | 2684.61 | 2684.89 | 2684.34 | 2684.61 | 180.0 |
| 2018-12-27 00:16:00 | ES | Futures | 2684.89 | 2684.89 | 2684.34 | 2684.34 | 136.0 |
| 2018-12-27 00:17:00 | ES | Futures | 2684.34 | 2684.61 | 2683.53 | 2684.34 | 436.0 |
| 2018-12-27 00:18:00 | ES | Futures | 2684.34 | 2684.34 | 2683.53 | 2683.8 | 186.0 |
| 2018-12-27 00:19:00 | ES | Futures | 2683.8 | 2689.23 | 2683.8 | 2687.33 | 1497.0 |
| 2018-12-27 00:20:00 | ES | Futures | 2687.6 | 2688.14 | 2686.51 | 2686.79 | 324.0 |
| 2018-12-27 00:21:00 | ES | Futures | 2686.51 | 2691.67 | 2686.51 | 2690.05 | 1247.0 |
| 2018-12-27 00:22:00 | ES | Futures | 2689.77 | 2693.85 | 2689.77 | 2693.58 | 939.0 |
| 2018-12-27 00:23:00 | ES | Futures | 2693.58 | 2694.39 | 2691.67 | 2692.49 | 1099.0 |
| 2018-12-27 00:24:00 | ES | Futures | 2692.49 | 2692.49 | 2691.67 | 2691.67 | 289.0 |
| 2018-12-27 00:25:00 | ES | Futures | 2691.4 | 2693.58 | 2691.4 | 2693.03 | 436.0 |
| 2018-12-27 00:26:00 | ES | Futures | 2693.3 | 2695.75 | 2693.03 | 2694.12 | 701.0 |
| 2018-12-27 00:27:00 | ES | Futures | 2693.85 | 2693.85 | 2692.49 | 2692.49 | 170.0 |
| 2018-12-27 00:28:00 | ES | Futures | 2692.49 | 2692.76 | 2691.13 | 2691.4 | 204.0 |
| 2018-12-27 00:29:00 | ES | Futures | 2691.67 | 2693.3 | 2691.4 | 2692.22 | 348.0 |
| 2018-12-27 00:30:00 | ES | Futures | 2692.22 | 2692.76 | 2690.86 | 2691.13 | 429.0 |
| 2018-12-27 00:31:00 | ES | Futures | 2691.4 | 2691.4 | 2689.5 | 2689.77 | 419.0 |
| 2018-12-27 00:32:00 | ES | Futures | 2689.77 | 2690.59 | 2688.96 | 2689.23 | 225.0 |
| 2018-12-27 00:33:00 | ES | Futures | 2689.23 | 2689.23 | 2685.43 | 2685.43 | 1015.0 |
| 2018-12-27 00:34:00 | ES | Futures | 2685.7 | 2687.33 | 2685.43 | 2686.24 | 808.0 |
| 2018-12-27 00:35:00 | ES | Futures | 2686.24 | 2686.24 | 2685.16 | 2685.16 | 219.0 |
| 2018-12-27 00:36:00 | ES | Futures | 2685.16 | 2685.97 | 2684.61 | 2685.16 | 234.0 |
| 2018-12-27 00:37:00 | ES | Futures | 2685.16 | 2685.7 | 2684.89 | 2685.16 | 181.0 |
| 2018-12-27 00:38:00 | ES | Futures | 2685.43 | 2685.43 | 2683.53 | 2684.07 | 302.0 |
| 2018-12-27 00:39:00 | ES | Futures | 2683.8 | 2684.89 | 2683.53 | 2684.89 | 172.0 |
| 2018-12-27 00:40:00 | ES | Futures | 2684.61 | 2685.43 | 2684.34 | 2685.16 | 138.0 |
| 2018-12-27 00:41:00 | ES | Futures | 2685.16 | 2685.7 | 2684.89 | 2685.7 | 165.0 |
| 2018-12-27 00:42:00 | ES | Futures | 2685.43 | 2685.43 | 2684.89 | 2685.16 | 100.0 |
| 2018-12-27 00:43:00 | ES | Futures | 2684.89 | 2684.89 | 2684.34 | 2684.89 | 108.0 |
| 2018-12-27 00:44:00 | ES | Futures | 2684.61 | 2684.61 | 2681.63 | 2682.17 | 455.0 |
| 2018-12-27 00:45:00 | ES | Futures | 2682.17 | 2682.17 | 2677.82 | 2678.37 | 1155.0 |
| 2018-12-27 00:46:00 | ES | Futures | 2678.1 | 2678.64 | 2673.75 | 2678.37 | 856.0 |
| 2018-12-27 00:47:00 | ES | Futures | 2678.1 | 2678.91 | 2677.55 | 2678.1 | 256.0 |
| 2018-12-27 00:48:00 | ES | Futures | 2677.82 | 2678.37 | 2675.65 | 2676.47 | 481.0 |
| 2018-12-27 00:49:00 | ES | Futures | 2676.19 | 2676.47 | 2675.11 | 2675.38 | 300.0 |
> showing 50 of 66,995 rows — these rows as CSV