PREVIEW / futures_30min / 2013-02-27
file: by_date/futures_30min/2013/2013-02-27.parquet size: 80 KB rows: 2,936
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-27 00:00:00 | ES | Futures | 1531.08 | 1531.34 | 1530.31 | 1530.82 | 2411.0 |
| 2013-02-27 00:30:00 | ES | Futures | 1530.82 | 1531.08 | 1530.31 | 1530.31 | 2050.0 |
| 2013-02-27 01:00:00 | ES | Futures | 1530.57 | 1531.34 | 1530.31 | 1530.57 | 3735.0 |
| 2013-02-27 01:30:00 | ES | Futures | 1530.57 | 1530.82 | 1530.31 | 1530.31 | 748.0 |
| 2013-02-27 02:00:00 | ES | Futures | 1530.31 | 1533.13 | 1530.31 | 1532.88 | 7726.0 |
| 2013-02-27 02:30:00 | ES | Futures | 1532.88 | 1533.13 | 1531.59 | 1532.36 | 4277.0 |
| 2013-02-27 03:00:00 | ES | Futures | 1532.36 | 1533.39 | 1530.82 | 1533.13 | 22030.0 |
| 2013-02-27 03:30:00 | ES | Futures | 1533.13 | 1533.13 | 1531.34 | 1531.85 | 13085.0 |
| 2013-02-27 04:00:00 | ES | Futures | 1531.85 | 1532.11 | 1530.31 | 1530.82 | 11899.0 |
| 2013-02-27 04:30:00 | ES | Futures | 1531.08 | 1531.85 | 1529.28 | 1531.59 | 21140.0 |
| 2013-02-27 05:00:00 | ES | Futures | 1531.85 | 1533.9 | 1530.82 | 1531.59 | 30210.0 |
| 2013-02-27 05:30:00 | ES | Futures | 1531.59 | 1532.88 | 1531.34 | 1531.85 | 10978.0 |
| 2013-02-27 06:00:00 | ES | Futures | 1531.85 | 1533.13 | 1531.34 | 1532.62 | 7499.0 |
| 2013-02-27 06:30:00 | ES | Futures | 1532.62 | 1533.64 | 1532.36 | 1533.64 | 9226.0 |
| 2013-02-27 07:00:00 | ES | Futures | 1533.39 | 1534.67 | 1532.88 | 1533.64 | 15251.0 |
| 2013-02-27 07:30:00 | ES | Futures | 1533.39 | 1536.47 | 1532.88 | 1535.95 | 22440.0 |
| 2013-02-27 08:00:00 | ES | Futures | 1535.7 | 1535.95 | 1531.34 | 1531.59 | 32344.0 |
| 2013-02-27 08:30:00 | ES | Futures | 1531.85 | 1534.67 | 1531.59 | 1532.62 | 45418.0 |
| 2013-02-27 09:00:00 | ES | Futures | 1532.36 | 1534.16 | 1531.85 | 1534.16 | 31094.0 |
| 2013-02-27 09:30:00 | ES | Futures | 1533.9 | 1540.06 | 1532.62 | 1538.78 | 292586.0 |
| 2013-02-27 10:00:00 | ES | Futures | 1538.78 | 1544.42 | 1538.26 | 1543.14 | 250730.0 |
| 2013-02-27 10:30:00 | ES | Futures | 1543.14 | 1546.22 | 1542.37 | 1543.65 | 186250.0 |
| 2013-02-27 11:00:00 | ES | Futures | 1543.65 | 1548.27 | 1543.65 | 1547.24 | 204083.0 |
| 2013-02-27 11:30:00 | ES | Futures | 1547.24 | 1549.04 | 1546.22 | 1547.76 | 98399.0 |
| 2013-02-27 12:00:00 | ES | Futures | 1548.01 | 1551.86 | 1547.5 | 1551.09 | 128389.0 |
| 2013-02-27 12:30:00 | ES | Futures | 1551.09 | 1553.4 | 1549.81 | 1551.35 | 149548.0 |
| 2013-02-27 13:00:00 | ES | Futures | 1551.61 | 1551.86 | 1549.81 | 1551.09 | 71764.0 |
| 2013-02-27 13:30:00 | ES | Futures | 1551.09 | 1552.89 | 1550.84 | 1551.61 | 61387.0 |
| 2013-02-27 14:00:00 | ES | Futures | 1551.86 | 1556.22 | 1551.35 | 1554.94 | 119738.0 |
| 2013-02-27 14:30:00 | ES | Futures | 1554.69 | 1556.99 | 1554.17 | 1556.74 | 102004.0 |
| 2013-02-27 15:00:00 | ES | Futures | 1556.74 | 1559.3 | 1555.2 | 1556.99 | 126652.0 |
| 2013-02-27 15:30:00 | ES | Futures | 1557.25 | 1559.05 | 1554.43 | 1554.94 | 209125.0 |
| 2013-02-27 16:00:00 | ES | Futures | 1554.69 | 1556.74 | 1554.43 | 1555.97 | 95582.0 |
| 2013-02-27 16:30:00 | ES | Futures | 1555.97 | 1556.99 | 1555.71 | 1556.22 | 6925.0 |
| 2013-02-27 17:00:00 | ES | Futures | 1556.22 | 1556.48 | 1555.2 | 1556.48 | 4307.0 |
| 2013-02-27 18:00:00 | ES | Futures | 1556.22 | 1556.74 | 1554.94 | 1555.46 | 4854.0 |
| 2013-02-27 18:30:00 | ES | Futures | 1555.46 | 1556.48 | 1555.2 | 1556.22 | 4147.0 |
| 2013-02-27 19:00:00 | ES | Futures | 1556.22 | 1556.22 | 1554.94 | 1555.46 | 3749.0 |
| 2013-02-27 19:30:00 | ES | Futures | 1555.2 | 1556.74 | 1554.94 | 1556.22 | 4543.0 |
| 2013-02-27 20:00:00 | ES | Futures | 1556.22 | 1556.48 | 1555.46 | 1555.97 | 2091.0 |
| 2013-02-27 20:30:00 | ES | Futures | 1555.97 | 1556.22 | 1555.71 | 1555.71 | 1793.0 |
| 2013-02-27 21:00:00 | ES | Futures | 1555.71 | 1556.22 | 1555.71 | 1556.22 | 1613.0 |
| 2013-02-27 21:30:00 | ES | Futures | 1556.22 | 1556.74 | 1555.71 | 1556.48 | 2045.0 |
| 2013-02-27 22:00:00 | ES | Futures | 1556.48 | 1557.51 | 1555.97 | 1557.51 | 3096.0 |
| 2013-02-27 22:30:00 | ES | Futures | 1557.25 | 1557.51 | 1556.22 | 1557.51 | 3406.0 |
| 2013-02-27 23:00:00 | ES | Futures | 1557.25 | 1557.76 | 1556.99 | 1557.51 | 1816.0 |
| 2013-02-27 23:30:00 | ES | Futures | 1557.76 | 1558.28 | 1557.25 | 1558.02 | 3196.0 |
| 2013-02-27 00:00:00 | NQ | Futures | 3153.73 | 3153.73 | 3151.4 | 3151.99 | 121.0 |
| 2013-02-27 00:30:00 | NQ | Futures | 3152.28 | 3152.57 | 3151.11 | 3151.4 | 100.0 |
| 2013-02-27 01:00:00 | NQ | Futures | 3151.4 | 3153.73 | 3151.11 | 3151.99 | 169.0 |
> showing 50 of 2,936 rows — these rows as CSV