PREVIEW / futures_30min / 2011-06-14
file: by_date/futures_30min/2011/2011-06-14.parquet size: 74 KB rows: 2,688
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-06-14 00:00:00 | ES | Futures | 1270.97 | 1271.47 | 1270.47 | 1270.97 | 1297.0 |
| 2011-06-14 00:30:00 | ES | Futures | 1271.22 | 1271.97 | 1270.72 | 1271.72 | 1268.0 |
| 2011-06-14 01:00:00 | ES | Futures | 1271.47 | 1273.22 | 1271.22 | 1272.47 | 4714.0 |
| 2011-06-14 01:30:00 | ES | Futures | 1272.72 | 1272.72 | 1271.47 | 1271.47 | 2761.0 |
| 2011-06-14 02:00:00 | ES | Futures | 1271.47 | 1272.97 | 1271.47 | 1271.97 | 5485.0 |
| 2011-06-14 02:30:00 | ES | Futures | 1272.22 | 1273.22 | 1271.72 | 1272.47 | 5640.0 |
| 2011-06-14 03:00:00 | ES | Futures | 1272.22 | 1275.46 | 1272.22 | 1273.71 | 30540.0 |
| 2011-06-14 03:30:00 | ES | Futures | 1273.71 | 1273.96 | 1271.47 | 1272.47 | 11884.0 |
| 2011-06-14 04:00:00 | ES | Futures | 1272.47 | 1275.71 | 1272.47 | 1274.71 | 16459.0 |
| 2011-06-14 04:30:00 | ES | Futures | 1274.71 | 1275.21 | 1273.46 | 1274.46 | 12314.0 |
| 2011-06-14 05:00:00 | ES | Futures | 1274.46 | 1275.46 | 1273.22 | 1273.22 | 13621.0 |
| 2011-06-14 05:30:00 | ES | Futures | 1273.22 | 1273.96 | 1272.72 | 1273.71 | 6777.0 |
| 2011-06-14 06:00:00 | ES | Futures | 1273.96 | 1273.96 | 1272.22 | 1272.97 | 6874.0 |
| 2011-06-14 06:30:00 | ES | Futures | 1272.72 | 1273.22 | 1270.22 | 1270.97 | 17235.0 |
| 2011-06-14 07:00:00 | ES | Futures | 1270.97 | 1272.72 | 1270.47 | 1272.22 | 18804.0 |
| 2011-06-14 07:30:00 | ES | Futures | 1272.22 | 1272.72 | 1271.22 | 1272.22 | 15416.0 |
| 2011-06-14 08:00:00 | ES | Futures | 1272.47 | 1273.71 | 1271.97 | 1272.47 | 19794.0 |
| 2011-06-14 08:30:00 | ES | Futures | 1272.47 | 1277.46 | 1272.47 | 1276.71 | 70059.0 |
| 2011-06-14 09:00:00 | ES | Futures | 1276.96 | 1277.21 | 1274.71 | 1274.96 | 42338.0 |
| 2011-06-14 09:30:00 | ES | Futures | 1274.96 | 1278.7 | 1274.46 | 1277.7 | 246857.0 |
| 2011-06-14 10:00:00 | ES | Futures | 1277.46 | 1279.2 | 1276.46 | 1278.95 | 153237.0 |
| 2011-06-14 10:30:00 | ES | Futures | 1278.95 | 1280.7 | 1278.45 | 1279.45 | 182245.0 |
| 2011-06-14 11:00:00 | ES | Futures | 1279.45 | 1279.95 | 1277.95 | 1278.45 | 86667.0 |
| 2011-06-14 11:30:00 | ES | Futures | 1278.45 | 1280.2 | 1277.46 | 1280.2 | 83452.0 |
| 2011-06-14 12:00:00 | ES | Futures | 1280.2 | 1280.95 | 1278.45 | 1280.45 | 84098.0 |
| 2011-06-14 12:30:00 | ES | Futures | 1280.45 | 1281.94 | 1279.7 | 1281.2 | 74810.0 |
| 2011-06-14 13:00:00 | ES | Futures | 1280.95 | 1282.19 | 1279.95 | 1281.94 | 80624.0 |
| 2011-06-14 13:30:00 | ES | Futures | 1281.7 | 1283.44 | 1280.7 | 1281.2 | 94344.0 |
| 2011-06-14 14:00:00 | ES | Futures | 1280.95 | 1282.69 | 1280.2 | 1281.94 | 63857.0 |
| 2011-06-14 14:30:00 | ES | Futures | 1281.94 | 1283.19 | 1281.2 | 1282.69 | 73183.0 |
| 2011-06-14 15:00:00 | ES | Futures | 1282.69 | 1283.94 | 1280.45 | 1281.7 | 111733.0 |
| 2011-06-14 15:30:00 | ES | Futures | 1281.7 | 1281.7 | 1277.95 | 1279.45 | 240514.0 |
| 2011-06-14 16:00:00 | ES | Futures | 1279.45 | 1281.94 | 1279.2 | 1280.95 | 127301.0 |
| 2011-06-14 16:30:00 | ES | Futures | 1280.7 | 1280.7 | 1278.95 | 1279.95 | 8977.0 |
| 2011-06-14 17:00:00 | ES | Futures | 1279.95 | 1280.45 | 1279.7 | 1279.95 | 2565.0 |
| 2011-06-14 18:00:00 | ES | Futures | 1279.95 | 1280.7 | 1279.2 | 1280.2 | 2432.0 |
| 2011-06-14 18:30:00 | ES | Futures | 1280.2 | 1280.7 | 1279.7 | 1280.2 | 2040.0 |
| 2011-06-14 19:00:00 | ES | Futures | 1280.2 | 1280.2 | 1279.2 | 1279.95 | 1931.0 |
| 2011-06-14 19:30:00 | ES | Futures | 1279.95 | 1280.45 | 1278.95 | 1279.45 | 2063.0 |
| 2011-06-14 20:00:00 | ES | Futures | 1279.2 | 1279.45 | 1278.7 | 1278.95 | 3395.0 |
| 2011-06-14 20:30:00 | ES | Futures | 1278.95 | 1279.45 | 1278.45 | 1279.2 | 1676.0 |
| 2011-06-14 21:00:00 | ES | Futures | 1279.2 | 1279.7 | 1278.45 | 1278.7 | 2161.0 |
| 2011-06-14 21:30:00 | ES | Futures | 1278.7 | 1278.95 | 1277.7 | 1277.95 | 4282.0 |
| 2011-06-14 22:00:00 | ES | Futures | 1278.2 | 1278.45 | 1277.46 | 1277.95 | 2238.0 |
| 2011-06-14 22:30:00 | ES | Futures | 1277.95 | 1277.95 | 1276.21 | 1276.96 | 6641.0 |
| 2011-06-14 23:00:00 | ES | Futures | 1276.71 | 1277.7 | 1276.46 | 1276.96 | 2156.0 |
| 2011-06-14 23:30:00 | ES | Futures | 1276.71 | 1276.71 | 1275.96 | 1276.71 | 2915.0 |
| 2011-06-14 00:00:00 | NQ | Futures | 2569.46 | 2570.03 | 2568.59 | 2569.17 | 111.0 |
| 2011-06-14 00:30:00 | NQ | Futures | 2569.46 | 2570.61 | 2568.88 | 2570.32 | 81.0 |
| 2011-06-14 01:00:00 | NQ | Futures | 2570.03 | 2572.62 | 2569.74 | 2571.76 | 455.0 |
> showing 50 of 2,688 rows — these rows as CSV