PREVIEW / futures_30min / 2011-09-13
file: by_date/futures_30min/2011/2011-09-13.parquet size: 76 KB rows: 2,655
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-13 00:00:00 | ES | Futures | 1163.98 | 1163.98 | 1162.73 | 1162.73 | 1087.0 |
| 2011-09-13 00:30:00 | ES | Futures | 1162.73 | 1164.23 | 1161.73 | 1162.98 | 522.0 |
| 2011-09-13 01:00:00 | ES | Futures | 1162.98 | 1163.23 | 1160.73 | 1161.48 | 1159.0 |
| 2011-09-13 01:30:00 | ES | Futures | 1161.73 | 1162.98 | 1159.74 | 1160.23 | 2345.0 |
| 2011-09-13 02:00:00 | ES | Futures | 1160.48 | 1163.98 | 1159.74 | 1162.48 | 3316.0 |
| 2011-09-13 02:30:00 | ES | Futures | 1162.23 | 1164.72 | 1161.23 | 1163.48 | 2271.0 |
| 2011-09-13 03:00:00 | ES | Futures | 1163.48 | 1163.48 | 1155.75 | 1158.49 | 11011.0 |
| 2011-09-13 03:30:00 | ES | Futures | 1158.24 | 1158.99 | 1147.02 | 1147.76 | 9552.0 |
| 2011-09-13 04:00:00 | ES | Futures | 1148.01 | 1151.26 | 1142.28 | 1147.02 | 16124.0 |
| 2011-09-13 04:30:00 | ES | Futures | 1147.27 | 1149.01 | 1142.78 | 1148.76 | 7418.0 |
| 2011-09-13 05:00:00 | ES | Futures | 1149.01 | 1151.26 | 1146.52 | 1148.76 | 7475.0 |
| 2011-09-13 05:30:00 | ES | Futures | 1149.01 | 1151.75 | 1144.52 | 1145.77 | 5045.0 |
| 2011-09-13 06:00:00 | ES | Futures | 1145.52 | 1146.77 | 1143.52 | 1146.77 | 5926.0 |
| 2011-09-13 06:30:00 | ES | Futures | 1146.77 | 1151.51 | 1145.52 | 1149.01 | 5549.0 |
| 2011-09-13 07:00:00 | ES | Futures | 1149.26 | 1157.49 | 1149.01 | 1156.99 | 10081.0 |
| 2011-09-13 07:30:00 | ES | Futures | 1156.99 | 1162.73 | 1149.51 | 1154.25 | 20114.0 |
| 2011-09-13 08:00:00 | ES | Futures | 1154.75 | 1155.99 | 1151.01 | 1154.5 | 9024.0 |
| 2011-09-13 08:30:00 | ES | Futures | 1154.25 | 1162.23 | 1154.25 | 1158.49 | 10407.0 |
| 2011-09-13 09:00:00 | ES | Futures | 1158.49 | 1162.98 | 1155.99 | 1161.98 | 8746.0 |
| 2011-09-13 09:30:00 | ES | Futures | 1161.98 | 1167.22 | 1153.75 | 1166.47 | 33490.0 |
| 2011-09-13 10:00:00 | ES | Futures | 1166.47 | 1171.46 | 1165.22 | 1166.72 | 31741.0 |
| 2011-09-13 10:30:00 | ES | Futures | 1166.97 | 1168.71 | 1160.73 | 1162.73 | 16323.0 |
| 2011-09-13 11:00:00 | ES | Futures | 1162.48 | 1164.47 | 1157.24 | 1159.99 | 14713.0 |
| 2011-09-13 11:30:00 | ES | Futures | 1160.23 | 1165.22 | 1158.99 | 1161.48 | 11756.0 |
| 2011-09-13 12:00:00 | ES | Futures | 1161.23 | 1164.72 | 1157.74 | 1163.23 | 10929.0 |
| 2011-09-13 12:30:00 | ES | Futures | 1163.23 | 1166.22 | 1161.23 | 1164.97 | 7022.0 |
| 2011-09-13 13:00:00 | ES | Futures | 1165.22 | 1168.71 | 1165.22 | 1166.97 | 7731.0 |
| 2011-09-13 13:30:00 | ES | Futures | 1166.97 | 1171.21 | 1164.97 | 1169.21 | 10282.0 |
| 2011-09-13 14:00:00 | ES | Futures | 1169.21 | 1173.45 | 1166.97 | 1173.45 | 13027.0 |
| 2011-09-13 14:30:00 | ES | Futures | 1173.2 | 1173.95 | 1166.47 | 1168.22 | 14471.0 |
| 2011-09-13 15:00:00 | ES | Futures | 1168.22 | 1169.96 | 1161.98 | 1167.97 | 19447.0 |
| 2011-09-13 15:30:00 | ES | Futures | 1167.97 | 1172.46 | 1167.22 | 1169.21 | 25935.0 |
| 2011-09-13 16:00:00 | ES | Futures | 1169.21 | 1169.96 | 1167.97 | 1168.46 | 10256.0 |
| 2011-09-13 16:30:00 | ES | Futures | 1168.46 | 1168.96 | 1164.97 | 1166.72 | 1413.0 |
| 2011-09-13 17:00:00 | ES | Futures | 1166.47 | 1167.97 | 1165.97 | 1167.97 | 174.0 |
| 2011-09-13 18:00:00 | ES | Futures | 1167.72 | 1167.72 | 1164.72 | 1164.72 | 535.0 |
| 2011-09-13 18:30:00 | ES | Futures | 1164.97 | 1167.72 | 1164.97 | 1167.22 | 201.0 |
| 2011-09-13 19:00:00 | ES | Futures | 1167.22 | 1167.47 | 1166.97 | 1167.22 | 220.0 |
| 2011-09-13 19:30:00 | ES | Futures | 1167.22 | 1167.22 | 1163.73 | 1164.23 | 948.0 |
| 2011-09-13 20:00:00 | ES | Futures | 1164.47 | 1168.46 | 1164.47 | 1167.72 | 962.0 |
| 2011-09-13 20:30:00 | ES | Futures | 1167.47 | 1169.21 | 1166.97 | 1168.22 | 586.0 |
| 2011-09-13 21:00:00 | ES | Futures | 1168.46 | 1168.96 | 1166.72 | 1168.46 | 895.0 |
| 2011-09-13 21:30:00 | ES | Futures | 1168.22 | 1168.71 | 1165.22 | 1165.22 | 926.0 |
| 2011-09-13 22:00:00 | ES | Futures | 1165.22 | 1166.47 | 1162.73 | 1162.73 | 649.0 |
| 2011-09-13 22:30:00 | ES | Futures | 1162.73 | 1164.23 | 1162.48 | 1162.73 | 428.0 |
| 2011-09-13 23:00:00 | ES | Futures | 1162.73 | 1162.98 | 1157.49 | 1157.99 | 1694.0 |
| 2011-09-13 23:30:00 | ES | Futures | 1157.99 | 1159.24 | 1155.0 | 1155.99 | 823.0 |
| 2011-09-13 00:00:00 | NQ | Futures | 2535.79 | 2535.79 | 2533.2 | 2533.2 | 23.0 |
| 2011-09-13 00:30:00 | NQ | Futures | 2534.64 | 2535.79 | 2531.18 | 2532.62 | 35.0 |
| 2011-09-13 01:00:00 | NQ | Futures | 2532.05 | 2532.33 | 2530.03 | 2531.47 | 66.0 |
> showing 50 of 2,655 rows — these rows as CSV