PREVIEW / futures_30min / 2012-08-15
file: by_date/futures_30min/2012/2012-08-15.parquet size: 72 KB rows: 2,703
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-08-15 00:00:00 | ES | Futures | 1421.95 | 1422.46 | 1421.7 | 1422.21 | 633.0 |
| 2012-08-15 00:30:00 | ES | Futures | 1422.21 | 1422.21 | 1421.7 | 1422.21 | 759.0 |
| 2012-08-15 01:00:00 | ES | Futures | 1421.95 | 1422.21 | 1421.44 | 1421.95 | 949.0 |
| 2012-08-15 01:30:00 | ES | Futures | 1422.21 | 1422.97 | 1421.44 | 1422.72 | 2052.0 |
| 2012-08-15 02:00:00 | ES | Futures | 1422.72 | 1424.24 | 1422.46 | 1423.99 | 3742.0 |
| 2012-08-15 02:30:00 | ES | Futures | 1423.99 | 1424.75 | 1423.48 | 1423.48 | 3768.0 |
| 2012-08-15 03:00:00 | ES | Futures | 1423.48 | 1423.99 | 1422.46 | 1422.97 | 10177.0 |
| 2012-08-15 03:30:00 | ES | Futures | 1422.97 | 1423.22 | 1421.19 | 1421.95 | 8771.0 |
| 2012-08-15 04:00:00 | ES | Futures | 1421.95 | 1423.73 | 1420.94 | 1423.22 | 15231.0 |
| 2012-08-15 04:30:00 | ES | Futures | 1423.48 | 1423.99 | 1422.72 | 1423.48 | 8790.0 |
| 2012-08-15 05:00:00 | ES | Futures | 1423.48 | 1424.5 | 1423.22 | 1423.73 | 5057.0 |
| 2012-08-15 05:30:00 | ES | Futures | 1423.48 | 1423.99 | 1422.21 | 1422.97 | 5066.0 |
| 2012-08-15 06:00:00 | ES | Futures | 1422.97 | 1423.48 | 1421.7 | 1423.22 | 8939.0 |
| 2012-08-15 06:30:00 | ES | Futures | 1422.97 | 1423.22 | 1422.46 | 1422.72 | 7004.0 |
| 2012-08-15 07:00:00 | ES | Futures | 1422.72 | 1423.73 | 1422.46 | 1422.46 | 11023.0 |
| 2012-08-15 07:30:00 | ES | Futures | 1422.21 | 1422.97 | 1421.95 | 1422.46 | 10304.0 |
| 2012-08-15 08:00:00 | ES | Futures | 1422.46 | 1423.73 | 1421.95 | 1422.46 | 13740.0 |
| 2012-08-15 08:30:00 | ES | Futures | 1422.46 | 1424.5 | 1421.44 | 1422.72 | 31092.0 |
| 2012-08-15 09:00:00 | ES | Futures | 1422.72 | 1424.24 | 1422.46 | 1424.24 | 20094.0 |
| 2012-08-15 09:30:00 | ES | Futures | 1424.24 | 1428.82 | 1423.22 | 1427.8 | 138744.0 |
| 2012-08-15 10:00:00 | ES | Futures | 1427.8 | 1428.82 | 1426.53 | 1427.29 | 85668.0 |
| 2012-08-15 10:30:00 | ES | Futures | 1427.29 | 1428.06 | 1424.75 | 1426.53 | 144279.0 |
| 2012-08-15 11:00:00 | ES | Futures | 1426.53 | 1428.06 | 1425.51 | 1426.02 | 84822.0 |
| 2012-08-15 11:30:00 | ES | Futures | 1426.02 | 1427.55 | 1425.77 | 1427.55 | 57848.0 |
| 2012-08-15 12:00:00 | ES | Futures | 1427.55 | 1428.31 | 1426.78 | 1428.06 | 25982.0 |
| 2012-08-15 12:30:00 | ES | Futures | 1427.8 | 1428.31 | 1427.04 | 1427.29 | 27375.0 |
| 2012-08-15 13:00:00 | ES | Futures | 1427.55 | 1427.55 | 1426.28 | 1426.53 | 17081.0 |
| 2012-08-15 13:30:00 | ES | Futures | 1426.28 | 1427.04 | 1425.77 | 1426.02 | 20620.0 |
| 2012-08-15 14:00:00 | ES | Futures | 1425.77 | 1427.29 | 1425.51 | 1427.04 | 30697.0 |
| 2012-08-15 14:30:00 | ES | Futures | 1427.29 | 1429.84 | 1426.28 | 1428.82 | 69020.0 |
| 2012-08-15 15:00:00 | ES | Futures | 1428.56 | 1429.07 | 1426.78 | 1427.55 | 45378.0 |
| 2012-08-15 15:30:00 | ES | Futures | 1427.29 | 1428.06 | 1426.28 | 1427.04 | 98247.0 |
| 2012-08-15 16:00:00 | ES | Futures | 1427.04 | 1428.56 | 1426.78 | 1427.29 | 63325.0 |
| 2012-08-15 16:30:00 | ES | Futures | 1427.55 | 1428.82 | 1427.29 | 1428.56 | 4470.0 |
| 2012-08-15 17:00:00 | ES | Futures | 1428.56 | 1428.56 | 1427.55 | 1428.06 | 2574.0 |
| 2012-08-15 18:00:00 | ES | Futures | 1427.8 | 1428.31 | 1427.29 | 1428.31 | 968.0 |
| 2012-08-15 18:30:00 | ES | Futures | 1428.31 | 1428.31 | 1427.8 | 1427.8 | 325.0 |
| 2012-08-15 19:00:00 | ES | Futures | 1428.06 | 1428.31 | 1427.8 | 1427.8 | 260.0 |
| 2012-08-15 19:30:00 | ES | Futures | 1427.8 | 1428.06 | 1427.55 | 1428.06 | 337.0 |
| 2012-08-15 20:00:00 | ES | Futures | 1427.8 | 1429.33 | 1427.55 | 1429.07 | 1906.0 |
| 2012-08-15 20:30:00 | ES | Futures | 1429.07 | 1429.58 | 1428.56 | 1429.07 | 1716.0 |
| 2012-08-15 21:00:00 | ES | Futures | 1428.82 | 1429.33 | 1427.8 | 1427.8 | 1665.0 |
| 2012-08-15 21:30:00 | ES | Futures | 1428.06 | 1429.58 | 1427.8 | 1429.07 | 3345.0 |
| 2012-08-15 22:00:00 | ES | Futures | 1429.07 | 1430.85 | 1428.82 | 1429.84 | 5275.0 |
| 2012-08-15 22:30:00 | ES | Futures | 1429.84 | 1430.85 | 1429.33 | 1429.33 | 2087.0 |
| 2012-08-15 23:00:00 | ES | Futures | 1429.58 | 1429.84 | 1429.33 | 1429.58 | 881.0 |
| 2012-08-15 23:30:00 | ES | Futures | 1429.58 | 1430.09 | 1428.82 | 1429.84 | 2594.0 |
| 2012-08-15 00:00:00 | NQ | Futures | 3154.82 | 3155.98 | 3154.82 | 3155.4 | 124.0 |
| 2012-08-15 00:30:00 | NQ | Futures | 3155.11 | 3156.27 | 3154.82 | 3156.27 | 73.0 |
| 2012-08-15 01:00:00 | NQ | Futures | 3155.98 | 3155.98 | 3154.82 | 3155.4 | 140.0 |
> showing 50 of 2,703 rows — these rows as CSV