PREVIEW / futures_30min / 2008-03-12
file: by_date/futures_30min/2008/2008-03-12.parquet size: 66 KB rows: 2,169
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-03-12 00:00:00 | ES | Futures | 1233.16 | 1233.86 | 1232.7 | 1232.93 | 1804.0 |
| 2008-03-12 00:30:00 | ES | Futures | 1233.16 | 1233.4 | 1232.23 | 1232.23 | 1164.0 |
| 2008-03-12 01:00:00 | ES | Futures | 1232.23 | 1232.7 | 1232.0 | 1232.46 | 1305.0 |
| 2008-03-12 01:30:00 | ES | Futures | 1232.23 | 1233.16 | 1232.0 | 1232.93 | 1891.0 |
| 2008-03-12 02:00:00 | ES | Futures | 1232.93 | 1233.4 | 1232.23 | 1233.4 | 782.0 |
| 2008-03-12 02:30:00 | ES | Futures | 1233.4 | 1233.63 | 1232.0 | 1232.0 | 2185.0 |
| 2008-03-12 03:00:00 | ES | Futures | 1232.0 | 1232.46 | 1230.6 | 1232.46 | 9421.0 |
| 2008-03-12 03:30:00 | ES | Futures | 1232.46 | 1234.8 | 1232.0 | 1234.8 | 4420.0 |
| 2008-03-12 04:00:00 | ES | Futures | 1234.56 | 1235.26 | 1231.06 | 1232.0 | 15787.0 |
| 2008-03-12 04:30:00 | ES | Futures | 1232.0 | 1233.4 | 1230.83 | 1232.7 | 9865.0 |
| 2008-03-12 05:00:00 | ES | Futures | 1232.7 | 1235.73 | 1232.7 | 1234.56 | 8851.0 |
| 2008-03-12 05:30:00 | ES | Futures | 1234.56 | 1238.99 | 1234.33 | 1238.76 | 14489.0 |
| 2008-03-12 06:00:00 | ES | Futures | 1238.53 | 1240.86 | 1238.06 | 1238.29 | 17484.0 |
| 2008-03-12 06:30:00 | ES | Futures | 1238.06 | 1238.29 | 1235.26 | 1235.26 | 10769.0 |
| 2008-03-12 07:00:00 | ES | Futures | 1235.26 | 1237.36 | 1234.56 | 1236.89 | 8325.0 |
| 2008-03-12 07:30:00 | ES | Futures | 1236.89 | 1237.13 | 1232.7 | 1234.56 | 16901.0 |
| 2008-03-12 08:00:00 | ES | Futures | 1234.56 | 1235.03 | 1231.06 | 1232.23 | 19427.0 |
| 2008-03-12 08:30:00 | ES | Futures | 1232.46 | 1234.33 | 1230.83 | 1232.23 | 24576.0 |
| 2008-03-12 09:00:00 | ES | Futures | 1232.46 | 1235.26 | 1231.76 | 1234.8 | 33055.0 |
| 2008-03-12 09:30:00 | ES | Futures | 1234.8 | 1237.13 | 1229.2 | 1231.3 | 212094.0 |
| 2008-03-12 10:00:00 | ES | Futures | 1231.53 | 1232.7 | 1227.1 | 1230.6 | 178375.0 |
| 2008-03-12 10:30:00 | ES | Futures | 1230.6 | 1236.89 | 1229.67 | 1235.96 | 169545.0 |
| 2008-03-12 11:00:00 | ES | Futures | 1235.96 | 1244.35 | 1235.96 | 1240.86 | 238152.0 |
| 2008-03-12 11:30:00 | ES | Futures | 1241.09 | 1241.79 | 1235.96 | 1236.89 | 143996.0 |
| 2008-03-12 12:00:00 | ES | Futures | 1236.89 | 1237.36 | 1234.1 | 1235.03 | 127974.0 |
| 2008-03-12 12:30:00 | ES | Futures | 1234.8 | 1237.13 | 1231.3 | 1233.63 | 114346.0 |
| 2008-03-12 13:00:00 | ES | Futures | 1233.63 | 1236.66 | 1233.16 | 1234.8 | 78072.0 |
| 2008-03-12 13:30:00 | ES | Futures | 1234.8 | 1235.03 | 1228.73 | 1230.37 | 102510.0 |
| 2008-03-12 14:00:00 | ES | Futures | 1230.13 | 1232.46 | 1227.57 | 1229.67 | 104344.0 |
| 2008-03-12 14:30:00 | ES | Futures | 1229.67 | 1234.56 | 1228.73 | 1230.6 | 104168.0 |
| 2008-03-12 15:00:00 | ES | Futures | 1230.37 | 1230.6 | 1225.94 | 1226.4 | 144033.0 |
| 2008-03-12 15:30:00 | ES | Futures | 1226.17 | 1227.33 | 1219.87 | 1221.04 | 276002.0 |
| 2008-03-12 16:00:00 | ES | Futures | 1221.27 | 1223.37 | 1220.57 | 1221.27 | 94385.0 |
| 2008-03-12 16:30:00 | ES | Futures | 1221.74 | 1222.67 | 1221.27 | 1221.74 | 7948.0 |
| 2008-03-12 17:00:00 | ES | Futures | 1221.74 | 1222.2 | 1220.57 | 1221.04 | 3108.0 |
| 2008-03-12 18:00:00 | ES | Futures | 1220.34 | 1220.34 | 1217.31 | 1218.01 | 4637.0 |
| 2008-03-12 18:30:00 | ES | Futures | 1218.01 | 1218.71 | 1216.61 | 1216.84 | 3115.0 |
| 2008-03-12 19:00:00 | ES | Futures | 1216.84 | 1217.77 | 1216.61 | 1217.54 | 1264.0 |
| 2008-03-12 19:30:00 | ES | Futures | 1217.54 | 1217.54 | 1217.08 | 1217.54 | 757.0 |
| 2008-03-12 20:00:00 | ES | Futures | 1217.54 | 1218.01 | 1214.74 | 1215.91 | 2423.0 |
| 2008-03-12 20:30:00 | ES | Futures | 1215.68 | 1217.08 | 1215.21 | 1216.38 | 1206.0 |
| 2008-03-12 21:00:00 | ES | Futures | 1216.38 | 1216.61 | 1214.28 | 1214.74 | 1180.0 |
| 2008-03-12 21:30:00 | ES | Futures | 1214.74 | 1214.98 | 1213.81 | 1214.51 | 1753.0 |
| 2008-03-12 22:00:00 | ES | Futures | 1214.51 | 1215.21 | 1214.04 | 1214.98 | 659.0 |
| 2008-03-12 22:30:00 | ES | Futures | 1215.21 | 1215.68 | 1214.04 | 1214.98 | 785.0 |
| 2008-03-12 23:00:00 | ES | Futures | 1214.98 | 1215.21 | 1212.65 | 1212.88 | 3271.0 |
| 2008-03-12 23:30:00 | ES | Futures | 1212.65 | 1213.11 | 1207.75 | 1208.22 | 9105.0 |
| 2008-03-12 00:00:00 | NQ | Futures | 1986.05 | 1986.91 | 1985.2 | 1986.05 | 120.0 |
| 2008-03-12 00:30:00 | NQ | Futures | 1985.77 | 1987.19 | 1984.35 | 1985.2 | 163.0 |
| 2008-03-12 01:00:00 | NQ | Futures | 1984.92 | 1985.77 | 1984.35 | 1985.77 | 24.0 |
> showing 50 of 2,169 rows — these rows as CSV