PREVIEW / futures_30min / 2011-10-26
file: by_date/futures_30min/2011/2011-10-26.parquet size: 81 KB rows: 2,793
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-26 00:00:00 | ES | Futures | 1234.23 | 1234.73 | 1233.48 | 1233.98 | 2458.0 |
| 2011-10-26 00:30:00 | ES | Futures | 1233.98 | 1234.98 | 1233.73 | 1234.23 | 2549.0 |
| 2011-10-26 01:00:00 | ES | Futures | 1234.23 | 1234.73 | 1232.98 | 1232.98 | 3527.0 |
| 2011-10-26 01:30:00 | ES | Futures | 1232.98 | 1234.73 | 1232.73 | 1234.48 | 3019.0 |
| 2011-10-26 02:00:00 | ES | Futures | 1234.48 | 1234.73 | 1231.47 | 1233.73 | 7049.0 |
| 2011-10-26 02:30:00 | ES | Futures | 1233.48 | 1236.49 | 1232.23 | 1236.24 | 6594.0 |
| 2011-10-26 03:00:00 | ES | Futures | 1235.99 | 1237.74 | 1233.98 | 1234.98 | 20226.0 |
| 2011-10-26 03:30:00 | ES | Futures | 1234.98 | 1238.49 | 1233.73 | 1237.49 | 16838.0 |
| 2011-10-26 04:00:00 | ES | Futures | 1237.24 | 1238.49 | 1234.23 | 1234.73 | 13898.0 |
| 2011-10-26 04:30:00 | ES | Futures | 1234.98 | 1236.49 | 1232.98 | 1232.98 | 14153.0 |
| 2011-10-26 05:00:00 | ES | Futures | 1232.73 | 1235.99 | 1232.48 | 1234.48 | 10164.0 |
| 2011-10-26 05:30:00 | ES | Futures | 1234.48 | 1236.49 | 1233.98 | 1235.48 | 7984.0 |
| 2011-10-26 06:00:00 | ES | Futures | 1235.23 | 1235.99 | 1232.73 | 1233.48 | 10531.0 |
| 2011-10-26 06:30:00 | ES | Futures | 1233.48 | 1237.24 | 1233.23 | 1234.48 | 13668.0 |
| 2011-10-26 07:00:00 | ES | Futures | 1234.48 | 1236.99 | 1232.98 | 1236.74 | 15855.0 |
| 2011-10-26 07:30:00 | ES | Futures | 1236.74 | 1237.74 | 1234.23 | 1234.48 | 19840.0 |
| 2011-10-26 08:00:00 | ES | Futures | 1234.48 | 1237.24 | 1234.23 | 1236.74 | 13466.0 |
| 2011-10-26 08:30:00 | ES | Futures | 1236.74 | 1240.5 | 1234.48 | 1239.0 | 59685.0 |
| 2011-10-26 09:00:00 | ES | Futures | 1239.25 | 1243.26 | 1238.74 | 1241.75 | 58951.0 |
| 2011-10-26 09:30:00 | ES | Futures | 1241.75 | 1243.51 | 1236.99 | 1238.49 | 245613.0 |
| 2011-10-26 10:00:00 | ES | Futures | 1238.49 | 1239.5 | 1229.47 | 1233.23 | 241900.0 |
| 2011-10-26 10:30:00 | ES | Futures | 1233.23 | 1233.23 | 1220.19 | 1222.95 | 289058.0 |
| 2011-10-26 11:00:00 | ES | Futures | 1222.95 | 1227.96 | 1222.45 | 1226.71 | 163972.0 |
| 2011-10-26 11:30:00 | ES | Futures | 1226.71 | 1231.72 | 1226.46 | 1229.47 | 116115.0 |
| 2011-10-26 12:00:00 | ES | Futures | 1229.72 | 1231.47 | 1227.46 | 1228.97 | 56339.0 |
| 2011-10-26 12:30:00 | ES | Futures | 1229.22 | 1230.72 | 1226.96 | 1227.71 | 51736.0 |
| 2011-10-26 13:00:00 | ES | Futures | 1227.46 | 1228.21 | 1224.2 | 1228.21 | 78380.0 |
| 2011-10-26 13:30:00 | ES | Futures | 1227.96 | 1238.49 | 1227.96 | 1236.24 | 275953.0 |
| 2011-10-26 14:00:00 | ES | Futures | 1236.24 | 1240.5 | 1235.23 | 1237.24 | 160801.0 |
| 2011-10-26 14:30:00 | ES | Futures | 1237.49 | 1243.01 | 1236.24 | 1238.24 | 167140.0 |
| 2011-10-26 15:00:00 | ES | Futures | 1238.24 | 1243.01 | 1236.99 | 1242.26 | 129717.0 |
| 2011-10-26 15:30:00 | ES | Futures | 1242.51 | 1246.27 | 1238.74 | 1241.75 | 273591.0 |
| 2011-10-26 16:00:00 | ES | Futures | 1241.75 | 1243.01 | 1240.25 | 1241.75 | 101407.0 |
| 2011-10-26 16:30:00 | ES | Futures | 1241.75 | 1247.27 | 1241.25 | 1246.02 | 11302.0 |
| 2011-10-26 17:00:00 | ES | Futures | 1246.02 | 1248.27 | 1245.52 | 1247.02 | 3921.0 |
| 2011-10-26 18:00:00 | ES | Futures | 1245.77 | 1246.02 | 1243.51 | 1243.76 | 4539.0 |
| 2011-10-26 18:30:00 | ES | Futures | 1243.76 | 1244.01 | 1242.26 | 1242.51 | 2402.0 |
| 2011-10-26 19:00:00 | ES | Futures | 1242.76 | 1244.51 | 1242.0 | 1244.01 | 2280.0 |
| 2011-10-26 19:30:00 | ES | Futures | 1244.01 | 1244.26 | 1242.76 | 1244.01 | 2274.0 |
| 2011-10-26 20:00:00 | ES | Futures | 1244.01 | 1247.02 | 1244.01 | 1244.76 | 7662.0 |
| 2011-10-26 20:30:00 | ES | Futures | 1244.76 | 1245.52 | 1242.76 | 1245.01 | 3643.0 |
| 2011-10-26 21:00:00 | ES | Futures | 1245.26 | 1246.77 | 1241.5 | 1244.01 | 8638.0 |
| 2011-10-26 21:30:00 | ES | Futures | 1244.01 | 1252.79 | 1243.76 | 1251.03 | 16381.0 |
| 2011-10-26 22:00:00 | ES | Futures | 1251.03 | 1255.8 | 1250.78 | 1254.29 | 17306.0 |
| 2011-10-26 22:30:00 | ES | Futures | 1254.29 | 1256.55 | 1253.04 | 1255.55 | 10539.0 |
| 2011-10-26 23:00:00 | ES | Futures | 1255.55 | 1256.8 | 1253.54 | 1256.3 | 9311.0 |
| 2011-10-26 23:30:00 | ES | Futures | 1256.3 | 1258.55 | 1255.04 | 1257.55 | 7749.0 |
| 2011-10-26 00:00:00 | NQ | Futures | 2690.63 | 2691.78 | 2689.47 | 2690.05 | 166.0 |
| 2011-10-26 00:30:00 | NQ | Futures | 2690.05 | 2691.78 | 2689.18 | 2690.63 | 194.0 |
| 2011-10-26 01:00:00 | NQ | Futures | 2690.63 | 2691.78 | 2688.32 | 2688.32 | 176.0 |
> showing 50 of 2,793 rows — these rows as CSV