PREVIEW / futures_30min / 2012-07-13
file: by_date/futures_30min/2012/2012-07-13.parquet size: 64 KB rows: 2,264
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-07-13 00:00:00 | ES | Futures | 1356.86 | 1357.62 | 1356.35 | 1356.35 | 1975.0 |
| 2012-07-13 00:30:00 | ES | Futures | 1356.6 | 1356.86 | 1355.59 | 1356.6 | 1204.0 |
| 2012-07-13 01:00:00 | ES | Futures | 1356.6 | 1357.62 | 1356.09 | 1357.62 | 1643.0 |
| 2012-07-13 01:30:00 | ES | Futures | 1357.11 | 1357.37 | 1356.09 | 1356.09 | 1624.0 |
| 2012-07-13 02:00:00 | ES | Futures | 1356.09 | 1356.6 | 1354.57 | 1356.09 | 3241.0 |
| 2012-07-13 02:30:00 | ES | Futures | 1356.09 | 1356.35 | 1354.82 | 1355.59 | 2129.0 |
| 2012-07-13 03:00:00 | ES | Futures | 1355.59 | 1356.09 | 1353.3 | 1354.57 | 13676.0 |
| 2012-07-13 03:30:00 | ES | Futures | 1354.82 | 1356.35 | 1354.57 | 1355.33 | 12086.0 |
| 2012-07-13 04:00:00 | ES | Futures | 1355.33 | 1355.59 | 1353.55 | 1354.06 | 9843.0 |
| 2012-07-13 04:30:00 | ES | Futures | 1354.06 | 1355.84 | 1353.81 | 1355.33 | 7818.0 |
| 2012-07-13 05:00:00 | ES | Futures | 1355.08 | 1357.87 | 1355.08 | 1356.35 | 11805.0 |
| 2012-07-13 05:30:00 | ES | Futures | 1356.35 | 1357.62 | 1355.84 | 1357.37 | 6138.0 |
| 2012-07-13 06:00:00 | ES | Futures | 1357.62 | 1357.87 | 1356.35 | 1357.62 | 6126.0 |
| 2012-07-13 06:30:00 | ES | Futures | 1357.62 | 1359.65 | 1357.62 | 1357.87 | 26178.0 |
| 2012-07-13 07:00:00 | ES | Futures | 1358.13 | 1358.38 | 1354.57 | 1355.84 | 24257.0 |
| 2012-07-13 07:30:00 | ES | Futures | 1355.59 | 1357.11 | 1355.08 | 1355.59 | 11128.0 |
| 2012-07-13 08:00:00 | ES | Futures | 1355.33 | 1355.84 | 1354.31 | 1355.59 | 13976.0 |
| 2012-07-13 08:30:00 | ES | Futures | 1355.59 | 1356.86 | 1354.31 | 1355.08 | 20388.0 |
| 2012-07-13 09:00:00 | ES | Futures | 1355.08 | 1355.33 | 1353.3 | 1355.33 | 28565.0 |
| 2012-07-13 09:30:00 | ES | Futures | 1355.08 | 1365.76 | 1354.82 | 1365.25 | 300083.0 |
| 2012-07-13 10:00:00 | ES | Futures | 1365.5 | 1370.84 | 1364.74 | 1367.28 | 230250.0 |
| 2012-07-13 10:30:00 | ES | Futures | 1367.54 | 1369.82 | 1367.28 | 1369.06 | 141397.0 |
| 2012-07-13 11:00:00 | ES | Futures | 1368.81 | 1369.57 | 1367.28 | 1368.81 | 121148.0 |
| 2012-07-13 11:30:00 | ES | Futures | 1368.81 | 1372.11 | 1368.55 | 1371.35 | 91492.0 |
| 2012-07-13 12:00:00 | ES | Futures | 1371.1 | 1372.88 | 1370.59 | 1371.1 | 68938.0 |
| 2012-07-13 12:30:00 | ES | Futures | 1371.1 | 1371.86 | 1370.84 | 1371.6 | 22559.0 |
| 2012-07-13 13:00:00 | ES | Futures | 1371.6 | 1372.37 | 1370.84 | 1371.35 | 34272.0 |
| 2012-07-13 13:30:00 | ES | Futures | 1371.35 | 1372.88 | 1370.59 | 1371.86 | 27810.0 |
| 2012-07-13 14:00:00 | ES | Futures | 1371.6 | 1372.37 | 1370.84 | 1371.6 | 28873.0 |
| 2012-07-13 14:30:00 | ES | Futures | 1371.6 | 1372.62 | 1371.35 | 1372.62 | 28886.0 |
| 2012-07-13 15:00:00 | ES | Futures | 1372.62 | 1376.44 | 1372.37 | 1374.4 | 103475.0 |
| 2012-07-13 15:30:00 | ES | Futures | 1374.15 | 1376.18 | 1372.88 | 1374.15 | 201859.0 |
| 2012-07-13 16:00:00 | ES | Futures | 1374.15 | 1376.18 | 1373.89 | 1375.16 | 100578.0 |
| 2012-07-13 00:00:00 | NQ | Futures | 2956.25 | 2957.41 | 2955.67 | 2955.67 | 107.0 |
| 2012-07-13 00:30:00 | NQ | Futures | 2955.38 | 2955.38 | 2953.93 | 2954.51 | 231.0 |
| 2012-07-13 01:00:00 | NQ | Futures | 2954.8 | 2955.96 | 2953.64 | 2955.67 | 278.0 |
| 2012-07-13 01:30:00 | NQ | Futures | 2955.67 | 2955.96 | 2953.06 | 2953.35 | 339.0 |
| 2012-07-13 02:00:00 | NQ | Futures | 2953.64 | 2953.93 | 2950.16 | 2953.64 | 372.0 |
| 2012-07-13 02:30:00 | NQ | Futures | 2953.64 | 2953.64 | 2949.87 | 2950.45 | 388.0 |
| 2012-07-13 03:00:00 | NQ | Futures | 2950.45 | 2952.48 | 2946.68 | 2949.58 | 1025.0 |
| 2012-07-13 03:30:00 | NQ | Futures | 2949.29 | 2953.93 | 2949.29 | 2951.61 | 1291.0 |
| 2012-07-13 04:00:00 | NQ | Futures | 2951.61 | 2951.61 | 2946.97 | 2948.13 | 863.0 |
| 2012-07-13 04:30:00 | NQ | Futures | 2947.55 | 2951.61 | 2946.39 | 2949.58 | 733.0 |
| 2012-07-13 05:00:00 | NQ | Futures | 2949.58 | 2955.38 | 2949.29 | 2952.19 | 791.0 |
| 2012-07-13 05:30:00 | NQ | Futures | 2952.48 | 2955.09 | 2951.03 | 2954.51 | 700.0 |
| 2012-07-13 06:00:00 | NQ | Futures | 2954.51 | 2955.67 | 2952.19 | 2955.38 | 520.0 |
| 2012-07-13 06:30:00 | NQ | Futures | 2955.09 | 2962.04 | 2955.09 | 2958.28 | 3012.0 |
| 2012-07-13 07:00:00 | NQ | Futures | 2958.86 | 2958.86 | 2952.19 | 2954.51 | 2819.0 |
| 2012-07-13 07:30:00 | NQ | Futures | 2954.8 | 2955.96 | 2949.58 | 2951.32 | 1787.0 |
| 2012-07-13 08:00:00 | NQ | Futures | 2951.32 | 2953.64 | 2949.29 | 2953.35 | 1319.0 |
> showing 50 of 2,264 rows — these rows as CSV