PREVIEW / futures_30min / 2011-06-08
file: by_date/futures_30min/2011/2011-06-08.parquet size: 75 KB rows: 2,696
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-08 00:00:00 | ES | Futures | 1274.45 | 1274.95 | 1274.2 | 1274.7 | 1562.0 |
| 2011-06-08 00:30:00 | ES | Futures | 1274.7 | 1275.94 | 1274.7 | 1275.94 | 2538.0 |
| 2011-06-08 01:00:00 | ES | Futures | 1275.69 | 1276.68 | 1275.69 | 1275.69 | 2754.0 |
| 2011-06-08 01:30:00 | ES | Futures | 1275.69 | 1276.93 | 1275.19 | 1276.19 | 4521.0 |
| 2011-06-08 02:00:00 | ES | Futures | 1276.19 | 1277.68 | 1275.94 | 1276.44 | 6622.0 |
| 2011-06-08 02:30:00 | ES | Futures | 1276.68 | 1277.68 | 1275.94 | 1277.68 | 6039.0 |
| 2011-06-08 03:00:00 | ES | Futures | 1277.43 | 1278.18 | 1274.7 | 1275.44 | 18740.0 |
| 2011-06-08 03:30:00 | ES | Futures | 1275.44 | 1275.44 | 1273.21 | 1273.95 | 21271.0 |
| 2011-06-08 04:00:00 | ES | Futures | 1273.95 | 1274.7 | 1270.23 | 1271.96 | 34116.0 |
| 2011-06-08 04:30:00 | ES | Futures | 1271.96 | 1272.71 | 1270.97 | 1272.46 | 10533.0 |
| 2011-06-08 05:00:00 | ES | Futures | 1272.21 | 1272.96 | 1270.97 | 1271.47 | 9978.0 |
| 2011-06-08 05:30:00 | ES | Futures | 1271.72 | 1273.7 | 1271.47 | 1272.71 | 10093.0 |
| 2011-06-08 06:00:00 | ES | Futures | 1272.96 | 1272.96 | 1270.72 | 1270.97 | 14394.0 |
| 2011-06-08 06:30:00 | ES | Futures | 1270.97 | 1271.22 | 1268.24 | 1269.98 | 35255.0 |
| 2011-06-08 07:00:00 | ES | Futures | 1269.98 | 1271.47 | 1269.48 | 1270.47 | 17315.0 |
| 2011-06-08 07:30:00 | ES | Futures | 1270.72 | 1271.22 | 1269.48 | 1270.97 | 19220.0 |
| 2011-06-08 08:00:00 | ES | Futures | 1271.22 | 1272.21 | 1269.98 | 1271.22 | 24054.0 |
| 2011-06-08 08:30:00 | ES | Futures | 1270.97 | 1273.7 | 1270.47 | 1272.96 | 31425.0 |
| 2011-06-08 09:00:00 | ES | Futures | 1272.96 | 1274.7 | 1272.21 | 1274.45 | 51731.0 |
| 2011-06-08 09:30:00 | ES | Futures | 1274.2 | 1277.18 | 1270.97 | 1271.72 | 292930.0 |
| 2011-06-08 10:00:00 | ES | Futures | 1271.72 | 1275.94 | 1271.22 | 1274.7 | 183555.0 |
| 2011-06-08 10:30:00 | ES | Futures | 1274.7 | 1277.18 | 1272.46 | 1275.69 | 179625.0 |
| 2011-06-08 11:00:00 | ES | Futures | 1275.69 | 1278.42 | 1272.71 | 1273.21 | 209751.0 |
| 2011-06-08 11:30:00 | ES | Futures | 1273.21 | 1277.18 | 1272.96 | 1277.18 | 130051.0 |
| 2011-06-08 12:00:00 | ES | Futures | 1277.18 | 1277.93 | 1273.45 | 1274.45 | 109999.0 |
| 2011-06-08 12:30:00 | ES | Futures | 1274.45 | 1277.18 | 1273.45 | 1276.93 | 66408.0 |
| 2011-06-08 13:00:00 | ES | Futures | 1276.93 | 1277.93 | 1274.45 | 1275.44 | 73134.0 |
| 2011-06-08 13:30:00 | ES | Futures | 1275.19 | 1275.69 | 1268.98 | 1270.72 | 157772.0 |
| 2011-06-08 14:00:00 | ES | Futures | 1270.72 | 1273.45 | 1268.73 | 1269.73 | 144426.0 |
| 2011-06-08 14:30:00 | ES | Futures | 1269.73 | 1275.44 | 1269.73 | 1273.45 | 119511.0 |
| 2011-06-08 15:00:00 | ES | Futures | 1273.45 | 1273.7 | 1268.73 | 1269.73 | 104682.0 |
| 2011-06-08 15:30:00 | ES | Futures | 1269.48 | 1273.21 | 1268.24 | 1270.72 | 217083.0 |
| 2011-06-08 16:00:00 | ES | Futures | 1270.72 | 1270.97 | 1268.49 | 1269.23 | 103879.0 |
| 2011-06-08 16:30:00 | ES | Futures | 1269.73 | 1269.73 | 1267.24 | 1267.49 | 11025.0 |
| 2011-06-08 17:00:00 | ES | Futures | 1267.49 | 1269.23 | 1267.49 | 1268.98 | 4163.0 |
| 2011-06-08 18:00:00 | ES | Futures | 1269.98 | 1270.97 | 1269.73 | 1270.72 | 5723.0 |
| 2011-06-08 18:30:00 | ES | Futures | 1270.47 | 1271.22 | 1269.73 | 1270.97 | 1396.0 |
| 2011-06-08 19:00:00 | ES | Futures | 1270.97 | 1271.22 | 1270.47 | 1270.97 | 1202.0 |
| 2011-06-08 19:30:00 | ES | Futures | 1271.22 | 1271.96 | 1270.72 | 1271.72 | 2850.0 |
| 2011-06-08 20:00:00 | ES | Futures | 1271.96 | 1271.96 | 1270.72 | 1271.47 | 2435.0 |
| 2011-06-08 20:30:00 | ES | Futures | 1271.22 | 1271.96 | 1271.22 | 1271.72 | 1685.0 |
| 2011-06-08 21:00:00 | ES | Futures | 1271.96 | 1273.7 | 1271.72 | 1273.45 | 4681.0 |
| 2011-06-08 21:30:00 | ES | Futures | 1273.7 | 1273.7 | 1271.96 | 1272.96 | 3863.0 |
| 2011-06-08 22:00:00 | ES | Futures | 1273.21 | 1273.21 | 1271.96 | 1272.71 | 1370.0 |
| 2011-06-08 22:30:00 | ES | Futures | 1272.96 | 1273.45 | 1272.21 | 1272.96 | 2237.0 |
| 2011-06-08 23:00:00 | ES | Futures | 1273.21 | 1273.7 | 1272.71 | 1273.21 | 2566.0 |
| 2011-06-08 23:30:00 | ES | Futures | 1273.21 | 1273.7 | 1271.22 | 1271.47 | 3215.0 |
| 2011-06-08 00:00:00 | NQ | Futures | 2605.37 | 2605.66 | 2604.22 | 2604.8 | 212.0 |
| 2011-06-08 00:30:00 | NQ | Futures | 2604.8 | 2605.95 | 2603.93 | 2605.37 | 554.0 |
| 2011-06-08 01:00:00 | NQ | Futures | 2605.66 | 2607.67 | 2605.66 | 2606.23 | 180.0 |
> showing 50 of 2,696 rows — these rows as CSV