PREVIEW / futures_30min / 2012-10-02
file: by_date/futures_30min/2012/2012-10-02.parquet size: 74 KB rows: 2,806
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-10-02 00:00:00 | ES | Futures | 1469.43 | 1469.68 | 1468.92 | 1469.17 | 1170.0 |
| 2012-10-02 00:30:00 | ES | Futures | 1468.92 | 1469.94 | 1468.15 | 1469.17 | 3630.0 |
| 2012-10-02 01:00:00 | ES | Futures | 1469.17 | 1469.94 | 1468.41 | 1469.17 | 1339.0 |
| 2012-10-02 01:30:00 | ES | Futures | 1468.92 | 1469.94 | 1468.92 | 1469.68 | 1445.0 |
| 2012-10-02 02:00:00 | ES | Futures | 1469.68 | 1470.45 | 1468.92 | 1470.19 | 2519.0 |
| 2012-10-02 02:30:00 | ES | Futures | 1470.19 | 1471.47 | 1469.94 | 1469.94 | 5408.0 |
| 2012-10-02 03:00:00 | ES | Futures | 1470.19 | 1471.98 | 1468.15 | 1471.73 | 18262.0 |
| 2012-10-02 03:30:00 | ES | Futures | 1471.73 | 1472.49 | 1470.96 | 1471.73 | 12315.0 |
| 2012-10-02 04:00:00 | ES | Futures | 1471.73 | 1473.77 | 1471.47 | 1473.26 | 9902.0 |
| 2012-10-02 04:30:00 | ES | Futures | 1473.26 | 1475.3 | 1472.75 | 1475.05 | 14782.0 |
| 2012-10-02 05:00:00 | ES | Futures | 1475.05 | 1476.32 | 1474.03 | 1475.56 | 16117.0 |
| 2012-10-02 05:30:00 | ES | Futures | 1475.3 | 1476.07 | 1474.54 | 1475.05 | 9943.0 |
| 2012-10-02 06:00:00 | ES | Futures | 1475.05 | 1477.35 | 1475.05 | 1476.84 | 17956.0 |
| 2012-10-02 06:30:00 | ES | Futures | 1476.58 | 1477.6 | 1476.32 | 1476.58 | 11184.0 |
| 2012-10-02 07:00:00 | ES | Futures | 1476.58 | 1476.58 | 1474.79 | 1475.3 | 11006.0 |
| 2012-10-02 07:30:00 | ES | Futures | 1475.3 | 1476.32 | 1475.3 | 1476.07 | 8971.0 |
| 2012-10-02 08:00:00 | ES | Futures | 1476.07 | 1477.09 | 1475.56 | 1475.81 | 17179.0 |
| 2012-10-02 08:30:00 | ES | Futures | 1475.56 | 1475.81 | 1474.03 | 1475.05 | 16033.0 |
| 2012-10-02 09:00:00 | ES | Futures | 1474.79 | 1475.3 | 1473.77 | 1475.05 | 21553.0 |
| 2012-10-02 09:30:00 | ES | Futures | 1474.79 | 1477.35 | 1472.75 | 1473.0 | 153552.0 |
| 2012-10-02 10:00:00 | ES | Futures | 1473.0 | 1473.26 | 1469.17 | 1473.0 | 143224.0 |
| 2012-10-02 10:30:00 | ES | Futures | 1473.26 | 1475.3 | 1468.66 | 1469.43 | 135233.0 |
| 2012-10-02 11:00:00 | ES | Futures | 1469.68 | 1471.22 | 1468.41 | 1469.43 | 145547.0 |
| 2012-10-02 11:30:00 | ES | Futures | 1469.68 | 1471.47 | 1464.32 | 1466.11 | 193705.0 |
| 2012-10-02 12:00:00 | ES | Futures | 1466.36 | 1469.43 | 1465.08 | 1468.15 | 82965.0 |
| 2012-10-02 12:30:00 | ES | Futures | 1468.41 | 1468.92 | 1466.36 | 1467.38 | 37740.0 |
| 2012-10-02 13:00:00 | ES | Futures | 1467.38 | 1468.41 | 1466.62 | 1467.13 | 22628.0 |
| 2012-10-02 13:30:00 | ES | Futures | 1467.13 | 1470.19 | 1465.08 | 1466.62 | 67240.0 |
| 2012-10-02 14:00:00 | ES | Futures | 1466.62 | 1467.89 | 1463.81 | 1465.6 | 47887.0 |
| 2012-10-02 14:30:00 | ES | Futures | 1465.34 | 1465.85 | 1463.55 | 1464.32 | 53326.0 |
| 2012-10-02 15:00:00 | ES | Futures | 1464.32 | 1467.89 | 1463.81 | 1467.64 | 56973.0 |
| 2012-10-02 15:30:00 | ES | Futures | 1467.64 | 1471.22 | 1467.38 | 1470.45 | 154451.0 |
| 2012-10-02 16:00:00 | ES | Futures | 1470.45 | 1473.26 | 1470.19 | 1471.98 | 78763.0 |
| 2012-10-02 16:30:00 | ES | Futures | 1471.73 | 1471.73 | 1470.7 | 1471.47 | 5922.0 |
| 2012-10-02 17:00:00 | ES | Futures | 1471.47 | 1472.49 | 1471.47 | 1471.98 | 1952.0 |
| 2012-10-02 18:00:00 | ES | Futures | 1471.98 | 1472.24 | 1471.22 | 1471.98 | 1291.0 |
| 2012-10-02 18:30:00 | ES | Futures | 1471.98 | 1471.98 | 1470.96 | 1471.47 | 844.0 |
| 2012-10-02 19:00:00 | ES | Futures | 1471.22 | 1471.47 | 1470.7 | 1471.22 | 902.0 |
| 2012-10-02 19:30:00 | ES | Futures | 1471.47 | 1471.47 | 1470.45 | 1471.22 | 1809.0 |
| 2012-10-02 20:00:00 | ES | Futures | 1470.96 | 1472.24 | 1470.96 | 1472.24 | 1659.0 |
| 2012-10-02 20:30:00 | ES | Futures | 1472.24 | 1472.24 | 1471.47 | 1471.98 | 736.0 |
| 2012-10-02 21:00:00 | ES | Futures | 1471.98 | 1472.24 | 1470.19 | 1470.45 | 3308.0 |
| 2012-10-02 21:30:00 | ES | Futures | 1470.7 | 1470.7 | 1469.94 | 1470.45 | 2575.0 |
| 2012-10-02 22:00:00 | ES | Futures | 1470.19 | 1471.22 | 1469.43 | 1469.94 | 3096.0 |
| 2012-10-02 22:30:00 | ES | Futures | 1469.68 | 1469.94 | 1469.17 | 1469.68 | 1863.0 |
| 2012-10-02 23:00:00 | ES | Futures | 1469.68 | 1469.94 | 1468.92 | 1469.43 | 1316.0 |
| 2012-10-02 23:30:00 | ES | Futures | 1469.43 | 1469.43 | 1468.66 | 1469.17 | 1108.0 |
| 2012-10-02 00:00:00 | NQ | Futures | 3241.67 | 3241.96 | 3240.22 | 3240.8 | 239.0 |
| 2012-10-02 00:30:00 | NQ | Futures | 3240.22 | 3242.25 | 3238.76 | 3240.51 | 429.0 |
| 2012-10-02 01:00:00 | NQ | Futures | 3240.22 | 3241.96 | 3239.05 | 3240.51 | 133.0 |
> showing 50 of 2,806 rows — these rows as CSV