PREVIEW / futures_5min / 2018-04-26
file: by_date/futures_5min/2018/2018-04-26.parquet size: 255 KB rows: 15,907
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-04-26 00:00:00 | ES | Futures | 2890.91 | 2890.91 | 2890.1 | 2890.64 | 402.0 |
| 2018-04-26 00:05:00 | ES | Futures | 2890.64 | 2891.46 | 2890.64 | 2891.46 | 149.0 |
| 2018-04-26 00:10:00 | ES | Futures | 2891.19 | 2891.73 | 2891.19 | 2891.46 | 83.0 |
| 2018-04-26 00:15:00 | ES | Futures | 2891.73 | 2892.01 | 2891.46 | 2891.73 | 100.0 |
| 2018-04-26 00:20:00 | ES | Futures | 2891.73 | 2892.01 | 2891.46 | 2891.73 | 83.0 |
| 2018-04-26 00:25:00 | ES | Futures | 2891.73 | 2892.55 | 2891.73 | 2892.28 | 114.0 |
| 2018-04-26 00:30:00 | ES | Futures | 2892.28 | 2892.28 | 2891.73 | 2891.73 | 123.0 |
| 2018-04-26 00:35:00 | ES | Futures | 2891.46 | 2891.73 | 2891.46 | 2891.73 | 110.0 |
| 2018-04-26 00:40:00 | ES | Futures | 2891.46 | 2891.46 | 2890.37 | 2890.64 | 176.0 |
| 2018-04-26 00:45:00 | ES | Futures | 2890.37 | 2891.19 | 2890.37 | 2890.64 | 225.0 |
| 2018-04-26 00:50:00 | ES | Futures | 2890.37 | 2890.91 | 2889.82 | 2890.91 | 282.0 |
| 2018-04-26 00:55:00 | ES | Futures | 2890.64 | 2891.19 | 2890.64 | 2890.91 | 100.0 |
| 2018-04-26 01:00:00 | ES | Futures | 2890.91 | 2891.19 | 2890.91 | 2891.19 | 168.0 |
| 2018-04-26 01:05:00 | ES | Futures | 2890.91 | 2891.19 | 2890.64 | 2891.19 | 109.0 |
| 2018-04-26 01:10:00 | ES | Futures | 2890.91 | 2890.91 | 2885.46 | 2885.46 | 2861.0 |
| 2018-04-26 01:15:00 | ES | Futures | 2885.46 | 2887.37 | 2885.18 | 2886.82 | 787.0 |
| 2018-04-26 01:20:00 | ES | Futures | 2886.82 | 2887.64 | 2885.73 | 2886.0 | 584.0 |
| 2018-04-26 01:25:00 | ES | Futures | 2886.0 | 2889.55 | 2886.0 | 2889.28 | 1147.0 |
| 2018-04-26 01:30:00 | ES | Futures | 2889.28 | 2889.55 | 2888.46 | 2888.46 | 384.0 |
| 2018-04-26 01:35:00 | ES | Futures | 2888.73 | 2889.0 | 2888.19 | 2888.73 | 202.0 |
| 2018-04-26 01:40:00 | ES | Futures | 2888.46 | 2890.1 | 2888.46 | 2889.82 | 1363.0 |
| 2018-04-26 01:45:00 | ES | Futures | 2889.82 | 2889.82 | 2888.73 | 2888.73 | 1176.0 |
| 2018-04-26 01:50:00 | ES | Futures | 2888.46 | 2889.0 | 2887.37 | 2887.91 | 511.0 |
| 2018-04-26 01:55:00 | ES | Futures | 2888.19 | 2888.19 | 2886.0 | 2886.0 | 1014.0 |
| 2018-04-26 02:00:00 | ES | Futures | 2886.0 | 2887.37 | 2885.46 | 2886.0 | 1203.0 |
| 2018-04-26 02:05:00 | ES | Futures | 2886.0 | 2886.28 | 2884.09 | 2885.18 | 1124.0 |
| 2018-04-26 02:10:00 | ES | Futures | 2885.18 | 2885.18 | 2884.09 | 2884.37 | 877.0 |
| 2018-04-26 02:15:00 | ES | Futures | 2884.64 | 2885.46 | 2883.55 | 2885.18 | 1294.0 |
| 2018-04-26 02:20:00 | ES | Futures | 2885.18 | 2885.18 | 2883.27 | 2884.09 | 871.0 |
| 2018-04-26 02:25:00 | ES | Futures | 2884.09 | 2885.73 | 2883.82 | 2885.18 | 709.0 |
| 2018-04-26 02:30:00 | ES | Futures | 2885.18 | 2885.46 | 2884.37 | 2884.91 | 1017.0 |
| 2018-04-26 02:35:00 | ES | Futures | 2884.64 | 2884.91 | 2883.82 | 2883.82 | 1184.0 |
| 2018-04-26 02:40:00 | ES | Futures | 2884.09 | 2884.37 | 2883.27 | 2884.09 | 1666.0 |
| 2018-04-26 02:45:00 | ES | Futures | 2883.82 | 2884.91 | 2883.0 | 2884.37 | 1506.0 |
| 2018-04-26 02:50:00 | ES | Futures | 2884.37 | 2884.64 | 2883.55 | 2883.82 | 566.0 |
| 2018-04-26 02:55:00 | ES | Futures | 2884.09 | 2885.18 | 2883.55 | 2883.82 | 614.0 |
| 2018-04-26 03:00:00 | ES | Futures | 2883.82 | 2884.91 | 2882.18 | 2882.73 | 2579.0 |
| 2018-04-26 03:05:00 | ES | Futures | 2882.73 | 2883.82 | 2881.36 | 2881.64 | 2020.0 |
| 2018-04-26 03:10:00 | ES | Futures | 2881.91 | 2884.91 | 2881.64 | 2884.64 | 2413.0 |
| 2018-04-26 03:15:00 | ES | Futures | 2884.64 | 2887.09 | 2884.64 | 2886.82 | 1743.0 |
| 2018-04-26 03:20:00 | ES | Futures | 2886.82 | 2888.19 | 2886.82 | 2887.64 | 1826.0 |
| 2018-04-26 03:25:00 | ES | Futures | 2887.64 | 2888.46 | 2887.09 | 2887.91 | 1200.0 |
| 2018-04-26 03:30:00 | ES | Futures | 2887.91 | 2888.46 | 2887.37 | 2887.64 | 1343.0 |
| 2018-04-26 03:35:00 | ES | Futures | 2887.91 | 2888.46 | 2886.28 | 2886.82 | 1075.0 |
| 2018-04-26 03:40:00 | ES | Futures | 2886.82 | 2886.82 | 2884.37 | 2884.64 | 973.0 |
| 2018-04-26 03:45:00 | ES | Futures | 2884.37 | 2885.18 | 2883.0 | 2883.0 | 1071.0 |
| 2018-04-26 03:50:00 | ES | Futures | 2883.0 | 2884.64 | 2883.0 | 2883.27 | 1061.0 |
| 2018-04-26 03:55:00 | ES | Futures | 2883.55 | 2884.64 | 2883.0 | 2884.09 | 1048.0 |
| 2018-04-26 04:00:00 | ES | Futures | 2884.09 | 2886.0 | 2883.82 | 2885.73 | 1089.0 |
| 2018-04-26 04:05:00 | ES | Futures | 2885.46 | 2886.82 | 2884.91 | 2886.0 | 1083.0 |
> showing 50 of 15,907 rows — these rows as CSV