PREVIEW / futures_30min / 2008-01-22
file: by_date/futures_30min/2008/2008-01-22.parquet size: 50 KB rows: 1,496
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-22 00:00:00 | ES | Futures | 1177.91 | 1178.84 | 1172.78 | 1177.67 | 6091.0 |
| 2008-01-22 00:30:00 | ES | Futures | 1177.44 | 1179.54 | 1172.54 | 1174.64 | 4266.0 |
| 2008-01-22 01:00:00 | ES | Futures | 1174.64 | 1175.11 | 1171.14 | 1173.71 | 9222.0 |
| 2008-01-22 01:30:00 | ES | Futures | 1172.78 | 1176.04 | 1171.14 | 1172.78 | 6308.0 |
| 2008-01-22 02:00:00 | ES | Futures | 1173.01 | 1174.64 | 1170.91 | 1170.91 | 12091.0 |
| 2008-01-22 02:30:00 | ES | Futures | 1170.91 | 1170.91 | 1170.91 | 1170.91 | 396.0 |
| 2008-01-22 03:00:00 | ES | Futures | 1170.91 | 1170.91 | 1170.91 | 1170.91 | 1650.0 |
| 2008-01-22 03:30:00 | ES | Futures | 1170.91 | 1175.11 | 1170.91 | 1174.17 | 16883.0 |
| 2008-01-22 04:00:00 | ES | Futures | 1173.94 | 1179.54 | 1170.91 | 1174.87 | 39669.0 |
| 2008-01-22 04:30:00 | ES | Futures | 1174.87 | 1179.3 | 1170.91 | 1178.84 | 20469.0 |
| 2008-01-22 05:00:00 | ES | Futures | 1178.6 | 1180.24 | 1170.91 | 1171.14 | 26812.0 |
| 2008-01-22 05:30:00 | ES | Futures | 1171.14 | 1177.44 | 1170.91 | 1176.51 | 17654.0 |
| 2008-01-22 06:00:00 | ES | Futures | 1176.74 | 1183.97 | 1176.51 | 1180.24 | 35384.0 |
| 2008-01-22 06:30:00 | ES | Futures | 1180.24 | 1187.23 | 1179.07 | 1182.8 | 29525.0 |
| 2008-01-22 07:00:00 | ES | Futures | 1182.8 | 1183.5 | 1170.91 | 1173.94 | 40469.0 |
| 2008-01-22 07:30:00 | ES | Futures | 1173.94 | 1179.54 | 1172.08 | 1174.64 | 46004.0 |
| 2008-01-22 08:00:00 | ES | Futures | 1174.41 | 1217.08 | 1171.14 | 1193.76 | 184491.0 |
| 2008-01-22 08:30:00 | ES | Futures | 1193.76 | 1201.22 | 1172.08 | 1182.57 | 164307.0 |
| 2008-01-22 09:00:00 | ES | Futures | 1182.33 | 1189.8 | 1178.84 | 1180.94 | 86899.0 |
| 2008-01-22 09:30:00 | ES | Futures | 1181.17 | 1213.11 | 1176.97 | 1200.99 | 555563.0 |
| 2008-01-22 10:00:00 | ES | Futures | 1201.22 | 1222.44 | 1199.36 | 1219.41 | 424084.0 |
| 2008-01-22 10:30:00 | ES | Futures | 1219.17 | 1225.94 | 1213.81 | 1218.94 | 330785.0 |
| 2008-01-22 11:00:00 | ES | Futures | 1218.71 | 1234.8 | 1218.47 | 1222.2 | 352726.0 |
| 2008-01-22 11:30:00 | ES | Futures | 1221.97 | 1223.6 | 1213.81 | 1216.14 | 220305.0 |
| 2008-01-22 12:00:00 | ES | Futures | 1216.14 | 1227.1 | 1214.74 | 1221.04 | 153620.0 |
| 2008-01-22 12:30:00 | ES | Futures | 1220.81 | 1226.17 | 1217.08 | 1225.7 | 93300.0 |
| 2008-01-22 13:00:00 | ES | Futures | 1225.7 | 1232.93 | 1221.74 | 1224.54 | 165426.0 |
| 2008-01-22 13:30:00 | ES | Futures | 1224.54 | 1228.03 | 1217.77 | 1222.44 | 162953.0 |
| 2008-01-22 14:00:00 | ES | Futures | 1222.44 | 1226.63 | 1215.91 | 1221.97 | 147386.0 |
| 2008-01-22 14:30:00 | ES | Futures | 1222.2 | 1226.17 | 1216.14 | 1222.9 | 141203.0 |
| 2008-01-22 15:00:00 | ES | Futures | 1223.14 | 1230.83 | 1220.81 | 1225.7 | 169960.0 |
| 2008-01-22 15:30:00 | ES | Futures | 1225.7 | 1235.73 | 1221.74 | 1224.54 | 290992.0 |
| 2008-01-22 16:00:00 | ES | Futures | 1224.54 | 1225.0 | 1219.17 | 1221.27 | 105179.0 |
| 2008-01-22 16:30:00 | ES | Futures | 1223.37 | 1223.37 | 1209.15 | 1213.81 | 28152.0 |
| 2008-01-22 17:00:00 | ES | Futures | 1213.81 | 1214.74 | 1212.65 | 1213.34 | 4607.0 |
| 2008-01-22 18:00:00 | ES | Futures | 1214.51 | 1216.14 | 1212.65 | 1216.14 | 3165.0 |
| 2008-01-22 18:30:00 | ES | Futures | 1216.14 | 1218.94 | 1216.14 | 1218.71 | 3381.0 |
| 2008-01-22 19:00:00 | ES | Futures | 1218.71 | 1220.57 | 1217.31 | 1219.41 | 2509.0 |
| 2008-01-22 19:30:00 | ES | Futures | 1219.41 | 1220.11 | 1217.31 | 1218.94 | 2047.0 |
| 2008-01-22 20:00:00 | ES | Futures | 1219.17 | 1219.64 | 1216.84 | 1217.77 | 1949.0 |
| 2008-01-22 20:30:00 | ES | Futures | 1217.54 | 1218.24 | 1214.98 | 1218.01 | 1829.0 |
| 2008-01-22 21:00:00 | ES | Futures | 1217.77 | 1217.77 | 1214.74 | 1214.74 | 1317.0 |
| 2008-01-22 21:30:00 | ES | Futures | 1214.98 | 1214.98 | 1207.75 | 1208.45 | 4261.0 |
| 2008-01-22 22:00:00 | ES | Futures | 1208.45 | 1210.55 | 1207.05 | 1208.45 | 3709.0 |
| 2008-01-22 22:30:00 | ES | Futures | 1208.22 | 1211.48 | 1205.88 | 1206.58 | 3460.0 |
| 2008-01-22 23:00:00 | ES | Futures | 1206.58 | 1207.75 | 1205.42 | 1205.88 | 1756.0 |
| 2008-01-22 23:30:00 | ES | Futures | 1205.88 | 1207.28 | 1205.65 | 1205.88 | 1316.0 |
| 2008-01-22 00:00:00 | NQ | Futures | 2011.32 | 2011.32 | 2003.94 | 2009.05 | 442.0 |
| 2008-01-22 00:30:00 | NQ | Futures | 2009.05 | 2011.03 | 2005.07 | 2005.07 | 170.0 |
| 2008-01-22 01:00:00 | NQ | Futures | 2007.06 | 2007.91 | 1998.26 | 1998.26 | 590.0 |
> showing 50 of 1,496 rows — these rows as CSV