PREVIEW / futures_30min / 2012-02-22
file: by_date/futures_30min/2012/2012-02-22.parquet size: 73 KB rows: 2,716
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 |
|---|---|---|---|---|---|---|---|
| 2012-02-22 00:00:00 | ES | Futures | 1372.33 | 1372.58 | 1372.07 | 1372.33 | 813.0 |
| 2012-02-22 00:30:00 | ES | Futures | 1372.33 | 1373.59 | 1372.33 | 1373.59 | 1675.0 |
| 2012-02-22 01:00:00 | ES | Futures | 1373.33 | 1373.84 | 1372.83 | 1373.33 | 1756.0 |
| 2012-02-22 01:30:00 | ES | Futures | 1373.33 | 1373.59 | 1373.08 | 1373.59 | 1084.0 |
| 2012-02-22 02:00:00 | ES | Futures | 1373.84 | 1374.85 | 1373.33 | 1374.59 | 4165.0 |
| 2012-02-22 02:30:00 | ES | Futures | 1374.59 | 1374.85 | 1373.84 | 1374.09 | 3128.0 |
| 2012-02-22 03:00:00 | ES | Futures | 1374.09 | 1374.85 | 1372.83 | 1372.83 | 12348.0 |
| 2012-02-22 03:30:00 | ES | Futures | 1373.08 | 1373.33 | 1371.32 | 1371.57 | 18519.0 |
| 2012-02-22 04:00:00 | ES | Futures | 1371.57 | 1371.82 | 1369.55 | 1370.31 | 15808.0 |
| 2012-02-22 04:30:00 | ES | Futures | 1370.56 | 1371.32 | 1369.05 | 1370.31 | 16981.0 |
| 2012-02-22 05:00:00 | ES | Futures | 1370.06 | 1370.81 | 1369.3 | 1370.31 | 7951.0 |
| 2012-02-22 05:30:00 | ES | Futures | 1370.06 | 1370.81 | 1369.3 | 1369.81 | 7444.0 |
| 2012-02-22 06:00:00 | ES | Futures | 1370.06 | 1370.06 | 1367.79 | 1369.3 | 14290.0 |
| 2012-02-22 06:30:00 | ES | Futures | 1369.3 | 1369.3 | 1367.54 | 1367.54 | 13717.0 |
| 2012-02-22 07:00:00 | ES | Futures | 1367.54 | 1369.3 | 1367.29 | 1368.8 | 11929.0 |
| 2012-02-22 07:30:00 | ES | Futures | 1368.8 | 1370.81 | 1368.55 | 1369.3 | 15726.0 |
| 2012-02-22 08:00:00 | ES | Futures | 1369.3 | 1369.81 | 1367.29 | 1368.29 | 17188.0 |
| 2012-02-22 08:30:00 | ES | Futures | 1368.29 | 1369.81 | 1367.54 | 1369.81 | 17187.0 |
| 2012-02-22 09:00:00 | ES | Futures | 1369.81 | 1370.31 | 1368.29 | 1368.8 | 20348.0 |
| 2012-02-22 09:30:00 | ES | Futures | 1368.55 | 1370.56 | 1367.79 | 1369.55 | 137535.0 |
| 2012-02-22 10:00:00 | ES | Futures | 1369.55 | 1371.57 | 1366.53 | 1368.8 | 181769.0 |
| 2012-02-22 10:30:00 | ES | Futures | 1368.8 | 1370.06 | 1366.78 | 1369.05 | 117176.0 |
| 2012-02-22 11:00:00 | ES | Futures | 1369.05 | 1370.56 | 1367.29 | 1368.04 | 128077.0 |
| 2012-02-22 11:30:00 | ES | Futures | 1367.79 | 1368.55 | 1364.26 | 1365.52 | 126678.0 |
| 2012-02-22 12:00:00 | ES | Futures | 1365.52 | 1366.03 | 1363.76 | 1365.77 | 71754.0 |
| 2012-02-22 12:30:00 | ES | Futures | 1365.77 | 1366.28 | 1365.02 | 1366.03 | 28099.0 |
| 2012-02-22 13:00:00 | ES | Futures | 1366.03 | 1369.3 | 1365.52 | 1368.55 | 57957.0 |
| 2012-02-22 13:30:00 | ES | Futures | 1368.8 | 1369.55 | 1367.54 | 1368.8 | 36553.0 |
| 2012-02-22 14:00:00 | ES | Futures | 1369.05 | 1369.81 | 1368.29 | 1368.8 | 31210.0 |
| 2012-02-22 14:30:00 | ES | Futures | 1369.05 | 1369.05 | 1366.53 | 1366.53 | 37639.0 |
| 2012-02-22 15:00:00 | ES | Futures | 1366.53 | 1368.55 | 1366.03 | 1367.03 | 53451.0 |
| 2012-02-22 15:30:00 | ES | Futures | 1367.03 | 1368.8 | 1364.77 | 1366.28 | 130876.0 |
| 2012-02-22 16:00:00 | ES | Futures | 1366.03 | 1367.03 | 1365.52 | 1366.78 | 62041.0 |
| 2012-02-22 16:30:00 | ES | Futures | 1366.78 | 1367.54 | 1366.28 | 1367.54 | 3740.0 |
| 2012-02-22 17:00:00 | ES | Futures | 1367.54 | 1367.54 | 1365.52 | 1366.03 | 2319.0 |
| 2012-02-22 18:00:00 | ES | Futures | 1366.03 | 1366.28 | 1365.52 | 1365.52 | 1612.0 |
| 2012-02-22 18:30:00 | ES | Futures | 1365.77 | 1366.28 | 1365.27 | 1366.28 | 1206.0 |
| 2012-02-22 19:00:00 | ES | Futures | 1366.28 | 1366.53 | 1365.52 | 1365.77 | 2636.0 |
| 2012-02-22 19:30:00 | ES | Futures | 1365.77 | 1366.03 | 1364.01 | 1364.01 | 3711.0 |
| 2012-02-22 20:00:00 | ES | Futures | 1364.26 | 1365.52 | 1364.01 | 1365.02 | 2794.0 |
| 2012-02-22 20:30:00 | ES | Futures | 1365.02 | 1366.03 | 1364.77 | 1365.27 | 2121.0 |
| 2012-02-22 21:00:00 | ES | Futures | 1365.27 | 1365.77 | 1365.02 | 1365.27 | 1561.0 |
| 2012-02-22 21:30:00 | ES | Futures | 1365.27 | 1366.53 | 1365.02 | 1366.28 | 1386.0 |
| 2012-02-22 22:00:00 | ES | Futures | 1366.28 | 1367.03 | 1366.03 | 1366.03 | 2287.0 |
| 2012-02-22 22:30:00 | ES | Futures | 1366.03 | 1366.53 | 1365.52 | 1365.77 | 1268.0 |
| 2012-02-22 23:00:00 | ES | Futures | 1365.77 | 1366.28 | 1365.52 | 1366.03 | 1037.0 |
| 2012-02-22 23:30:00 | ES | Futures | 1366.28 | 1366.28 | 1365.52 | 1365.52 | 1220.0 |
| 2012-02-22 00:00:00 | NQ | Futures | 2998.3 | 2998.59 | 2997.44 | 2998.02 | 129.0 |
| 2012-02-22 00:30:00 | NQ | Futures | 2998.3 | 2999.75 | 2997.73 | 2999.46 | 99.0 |
| 2012-02-22 01:00:00 | NQ | Futures | 2999.46 | 2999.75 | 2998.59 | 2999.46 | 142.0 |
> showing 50 of 2,716 rows — these rows as CSV