PREVIEW / futures_5min / 2011-10-09
file: by_date/futures_5min/2011/2011-10-09.parquet size: 51 KB rows: 2,234
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-10-09 18:00:00 | ES | Futures | 1161.26 | 1162.26 | 1160.01 | 1161.76 | 5363.0 |
| 2011-10-09 18:05:00 | ES | Futures | 1161.51 | 1161.76 | 1160.26 | 1160.76 | 881.0 |
| 2011-10-09 18:10:00 | ES | Futures | 1160.76 | 1161.51 | 1160.26 | 1161.26 | 859.0 |
| 2011-10-09 18:15:00 | ES | Futures | 1161.26 | 1162.77 | 1160.76 | 1162.77 | 2234.0 |
| 2011-10-09 18:20:00 | ES | Futures | 1162.51 | 1162.51 | 1161.01 | 1161.51 | 921.0 |
| 2011-10-09 18:25:00 | ES | Futures | 1161.51 | 1161.76 | 1160.76 | 1161.01 | 496.0 |
| 2011-10-09 18:30:00 | ES | Futures | 1161.01 | 1161.26 | 1160.76 | 1161.26 | 345.0 |
| 2011-10-09 18:35:00 | ES | Futures | 1161.26 | 1161.76 | 1161.26 | 1161.26 | 280.0 |
| 2011-10-09 18:40:00 | ES | Futures | 1161.26 | 1162.01 | 1161.26 | 1161.76 | 305.0 |
| 2011-10-09 18:45:00 | ES | Futures | 1161.76 | 1162.01 | 1161.26 | 1161.51 | 474.0 |
| 2011-10-09 18:50:00 | ES | Futures | 1161.51 | 1161.51 | 1161.01 | 1161.26 | 305.0 |
| 2011-10-09 18:55:00 | ES | Futures | 1161.01 | 1161.51 | 1161.01 | 1161.51 | 390.0 |
| 2011-10-09 19:00:00 | ES | Futures | 1161.51 | 1161.76 | 1161.26 | 1161.51 | 113.0 |
| 2011-10-09 19:05:00 | ES | Futures | 1161.51 | 1161.76 | 1161.01 | 1161.76 | 453.0 |
| 2011-10-09 19:10:00 | ES | Futures | 1161.76 | 1162.26 | 1161.76 | 1162.26 | 295.0 |
| 2011-10-09 19:15:00 | ES | Futures | 1162.26 | 1163.52 | 1162.01 | 1163.52 | 1406.0 |
| 2011-10-09 19:20:00 | ES | Futures | 1163.52 | 1163.52 | 1162.77 | 1163.27 | 246.0 |
| 2011-10-09 19:25:00 | ES | Futures | 1163.27 | 1164.27 | 1163.02 | 1163.52 | 1073.0 |
| 2011-10-09 19:30:00 | ES | Futures | 1163.52 | 1164.02 | 1162.77 | 1163.02 | 420.0 |
| 2011-10-09 19:35:00 | ES | Futures | 1163.27 | 1163.52 | 1162.77 | 1163.27 | 378.0 |
| 2011-10-09 19:40:00 | ES | Futures | 1163.27 | 1163.27 | 1162.51 | 1162.77 | 212.0 |
| 2011-10-09 19:45:00 | ES | Futures | 1162.77 | 1164.02 | 1162.77 | 1164.02 | 377.0 |
| 2011-10-09 19:50:00 | ES | Futures | 1164.02 | 1165.77 | 1164.02 | 1165.52 | 1313.0 |
| 2011-10-09 19:55:00 | ES | Futures | 1165.27 | 1167.28 | 1165.27 | 1166.53 | 2141.0 |
| 2011-10-09 20:00:00 | ES | Futures | 1166.53 | 1168.53 | 1166.53 | 1168.03 | 3458.0 |
| 2011-10-09 20:05:00 | ES | Futures | 1167.78 | 1168.28 | 1167.28 | 1168.03 | 1645.0 |
| 2011-10-09 20:10:00 | ES | Futures | 1168.28 | 1169.79 | 1167.78 | 1168.03 | 3583.0 |
| 2011-10-09 20:15:00 | ES | Futures | 1167.78 | 1168.03 | 1167.28 | 1167.78 | 897.0 |
| 2011-10-09 20:20:00 | ES | Futures | 1167.53 | 1168.03 | 1167.28 | 1167.53 | 524.0 |
| 2011-10-09 20:25:00 | ES | Futures | 1167.78 | 1167.78 | 1167.03 | 1167.03 | 340.0 |
| 2011-10-09 20:30:00 | ES | Futures | 1167.03 | 1167.78 | 1167.03 | 1167.28 | 489.0 |
| 2011-10-09 20:35:00 | ES | Futures | 1167.03 | 1167.53 | 1166.78 | 1167.28 | 297.0 |
| 2011-10-09 20:40:00 | ES | Futures | 1167.53 | 1169.28 | 1167.53 | 1169.03 | 1666.0 |
| 2011-10-09 20:45:00 | ES | Futures | 1168.78 | 1169.03 | 1168.53 | 1168.53 | 304.0 |
| 2011-10-09 20:50:00 | ES | Futures | 1168.53 | 1169.54 | 1168.28 | 1169.28 | 400.0 |
| 2011-10-09 20:55:00 | ES | Futures | 1169.28 | 1172.29 | 1169.28 | 1171.54 | 3006.0 |
| 2011-10-09 21:00:00 | ES | Futures | 1171.54 | 1173.3 | 1171.54 | 1172.54 | 2088.0 |
| 2011-10-09 21:05:00 | ES | Futures | 1172.54 | 1173.8 | 1172.04 | 1172.8 | 4851.0 |
| 2011-10-09 21:10:00 | ES | Futures | 1172.54 | 1172.8 | 1171.54 | 1172.04 | 988.0 |
| 2011-10-09 21:15:00 | ES | Futures | 1172.04 | 1172.8 | 1171.79 | 1172.04 | 607.0 |
| 2011-10-09 21:20:00 | ES | Futures | 1172.04 | 1172.29 | 1171.54 | 1172.04 | 591.0 |
| 2011-10-09 21:25:00 | ES | Futures | 1171.79 | 1172.8 | 1171.79 | 1172.54 | 437.0 |
| 2011-10-09 21:30:00 | ES | Futures | 1172.29 | 1172.8 | 1171.54 | 1171.79 | 707.0 |
| 2011-10-09 21:35:00 | ES | Futures | 1171.79 | 1172.54 | 1171.29 | 1171.29 | 743.0 |
| 2011-10-09 21:40:00 | ES | Futures | 1171.54 | 1171.54 | 1169.79 | 1170.04 | 1460.0 |
| 2011-10-09 21:45:00 | ES | Futures | 1170.04 | 1170.29 | 1169.28 | 1169.28 | 1112.0 |
| 2011-10-09 21:50:00 | ES | Futures | 1169.54 | 1170.04 | 1169.28 | 1169.79 | 584.0 |
| 2011-10-09 21:55:00 | ES | Futures | 1169.79 | 1170.54 | 1169.79 | 1170.54 | 406.0 |
| 2011-10-09 22:00:00 | ES | Futures | 1170.79 | 1170.79 | 1168.78 | 1169.54 | 1080.0 |
| 2011-10-09 22:05:00 | ES | Futures | 1169.54 | 1170.29 | 1168.78 | 1170.29 | 478.0 |
> showing 50 of 2,234 rows — these rows as CSV