PREVIEW / futures_5min / 2011-09-28
file: by_date/futures_5min/2011/2011-09-28.parquet size: 272 KB rows: 13,894
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 |
|---|---|---|---|---|---|---|---|
| 2011-09-28 00:00:00 | ES | Futures | 1168.03 | 1168.03 | 1167.03 | 1167.03 | 325.0 |
| 2011-09-28 00:05:00 | ES | Futures | 1167.28 | 1167.78 | 1167.28 | 1167.28 | 132.0 |
| 2011-09-28 00:10:00 | ES | Futures | 1167.53 | 1168.78 | 1167.53 | 1168.53 | 527.0 |
| 2011-09-28 00:15:00 | ES | Futures | 1168.53 | 1168.78 | 1168.28 | 1168.53 | 100.0 |
| 2011-09-28 00:20:00 | ES | Futures | 1168.53 | 1169.03 | 1168.28 | 1168.53 | 238.0 |
| 2011-09-28 00:25:00 | ES | Futures | 1168.53 | 1168.78 | 1167.78 | 1168.03 | 244.0 |
| 2011-09-28 00:30:00 | ES | Futures | 1168.03 | 1168.28 | 1167.28 | 1167.53 | 195.0 |
| 2011-09-28 00:35:00 | ES | Futures | 1167.53 | 1168.28 | 1167.53 | 1167.78 | 324.0 |
| 2011-09-28 00:40:00 | ES | Futures | 1168.03 | 1168.53 | 1168.03 | 1168.28 | 98.0 |
| 2011-09-28 00:45:00 | ES | Futures | 1168.28 | 1169.28 | 1168.03 | 1169.03 | 578.0 |
| 2011-09-28 00:50:00 | ES | Futures | 1169.03 | 1170.29 | 1169.03 | 1169.54 | 616.0 |
| 2011-09-28 00:55:00 | ES | Futures | 1169.54 | 1170.04 | 1169.28 | 1169.28 | 141.0 |
| 2011-09-28 01:00:00 | ES | Futures | 1169.28 | 1169.28 | 1167.78 | 1168.28 | 326.0 |
| 2011-09-28 01:05:00 | ES | Futures | 1168.28 | 1169.28 | 1168.03 | 1168.78 | 263.0 |
| 2011-09-28 01:10:00 | ES | Futures | 1168.78 | 1170.04 | 1168.78 | 1169.54 | 389.0 |
| 2011-09-28 01:15:00 | ES | Futures | 1169.28 | 1170.29 | 1169.03 | 1169.28 | 445.0 |
| 2011-09-28 01:20:00 | ES | Futures | 1169.28 | 1170.04 | 1168.53 | 1169.54 | 435.0 |
| 2011-09-28 01:25:00 | ES | Futures | 1169.79 | 1169.79 | 1168.53 | 1168.53 | 283.0 |
| 2011-09-28 01:30:00 | ES | Futures | 1168.53 | 1168.53 | 1167.28 | 1167.78 | 605.0 |
| 2011-09-28 01:35:00 | ES | Futures | 1167.78 | 1168.53 | 1167.28 | 1167.53 | 956.0 |
| 2011-09-28 01:40:00 | ES | Futures | 1167.53 | 1168.53 | 1167.53 | 1168.03 | 629.0 |
| 2011-09-28 01:45:00 | ES | Futures | 1167.78 | 1168.03 | 1166.53 | 1166.53 | 783.0 |
| 2011-09-28 01:50:00 | ES | Futures | 1166.78 | 1166.78 | 1166.02 | 1166.02 | 1283.0 |
| 2011-09-28 01:55:00 | ES | Futures | 1166.02 | 1166.78 | 1165.77 | 1166.02 | 1697.0 |
| 2011-09-28 02:00:00 | ES | Futures | 1166.28 | 1169.03 | 1166.02 | 1169.03 | 1996.0 |
| 2011-09-28 02:05:00 | ES | Futures | 1169.03 | 1169.54 | 1168.28 | 1169.03 | 1251.0 |
| 2011-09-28 02:10:00 | ES | Futures | 1169.03 | 1172.04 | 1169.03 | 1172.04 | 3456.0 |
| 2011-09-28 02:15:00 | ES | Futures | 1171.79 | 1173.05 | 1171.79 | 1172.29 | 2379.0 |
| 2011-09-28 02:20:00 | ES | Futures | 1172.29 | 1173.3 | 1170.79 | 1171.04 | 2191.0 |
| 2011-09-28 02:25:00 | ES | Futures | 1171.29 | 1173.3 | 1171.04 | 1172.54 | 1363.0 |
| 2011-09-28 02:30:00 | ES | Futures | 1172.54 | 1173.05 | 1171.79 | 1171.79 | 1142.0 |
| 2011-09-28 02:35:00 | ES | Futures | 1171.79 | 1172.04 | 1170.54 | 1171.54 | 1297.0 |
| 2011-09-28 02:40:00 | ES | Futures | 1171.54 | 1171.79 | 1169.54 | 1169.54 | 1529.0 |
| 2011-09-28 02:45:00 | ES | Futures | 1169.54 | 1171.79 | 1169.54 | 1171.29 | 1577.0 |
| 2011-09-28 02:50:00 | ES | Futures | 1171.29 | 1172.04 | 1170.79 | 1172.04 | 909.0 |
| 2011-09-28 02:55:00 | ES | Futures | 1171.79 | 1172.54 | 1170.04 | 1171.04 | 1551.0 |
| 2011-09-28 03:00:00 | ES | Futures | 1170.79 | 1171.54 | 1168.03 | 1170.04 | 7055.0 |
| 2011-09-28 03:05:00 | ES | Futures | 1170.04 | 1174.05 | 1169.79 | 1174.05 | 6897.0 |
| 2011-09-28 03:10:00 | ES | Futures | 1174.05 | 1177.56 | 1173.8 | 1177.06 | 10890.0 |
| 2011-09-28 03:15:00 | ES | Futures | 1177.06 | 1180.32 | 1176.81 | 1178.06 | 10993.0 |
| 2011-09-28 03:20:00 | ES | Futures | 1178.31 | 1178.31 | 1175.05 | 1175.3 | 6252.0 |
| 2011-09-28 03:25:00 | ES | Futures | 1175.55 | 1176.81 | 1174.3 | 1174.55 | 3659.0 |
| 2011-09-28 03:30:00 | ES | Futures | 1174.55 | 1176.31 | 1174.3 | 1175.8 | 4368.0 |
| 2011-09-28 03:35:00 | ES | Futures | 1176.06 | 1176.56 | 1174.05 | 1174.8 | 4048.0 |
| 2011-09-28 03:40:00 | ES | Futures | 1174.8 | 1177.06 | 1174.3 | 1176.31 | 4388.0 |
| 2011-09-28 03:45:00 | ES | Futures | 1176.56 | 1177.31 | 1175.55 | 1176.56 | 3008.0 |
| 2011-09-28 03:50:00 | ES | Futures | 1176.31 | 1177.06 | 1175.55 | 1176.31 | 2079.0 |
| 2011-09-28 03:55:00 | ES | Futures | 1176.31 | 1179.06 | 1176.31 | 1177.31 | 4759.0 |
| 2011-09-28 04:00:00 | ES | Futures | 1177.56 | 1177.56 | 1174.05 | 1174.55 | 6064.0 |
| 2011-09-28 04:05:00 | ES | Futures | 1174.55 | 1174.8 | 1172.54 | 1172.54 | 4656.0 |
> showing 50 of 13,894 rows — these rows as CSV