PREVIEW / futures_30min / 2013-02-28
file: by_date/futures_30min/2013/2013-02-28.parquet size: 78 KB rows: 2,922
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-28 00:00:00 | ES | Futures | 1558.02 | 1558.28 | 1556.48 | 1557.51 | 4988.0 |
| 2013-02-28 00:30:00 | ES | Futures | 1557.51 | 1558.53 | 1557.51 | 1558.02 | 2224.0 |
| 2013-02-28 01:00:00 | ES | Futures | 1558.02 | 1558.53 | 1557.51 | 1557.51 | 2727.0 |
| 2013-02-28 01:30:00 | ES | Futures | 1557.51 | 1557.51 | 1556.99 | 1556.99 | 1333.0 |
| 2013-02-28 02:00:00 | ES | Futures | 1557.25 | 1557.51 | 1555.97 | 1556.48 | 4889.0 |
| 2013-02-28 02:30:00 | ES | Futures | 1556.48 | 1556.74 | 1555.71 | 1556.48 | 6317.0 |
| 2013-02-28 03:00:00 | ES | Futures | 1556.48 | 1558.02 | 1555.71 | 1557.51 | 16087.0 |
| 2013-02-28 03:30:00 | ES | Futures | 1557.51 | 1558.79 | 1556.74 | 1558.28 | 11550.0 |
| 2013-02-28 04:00:00 | ES | Futures | 1558.28 | 1558.28 | 1555.46 | 1555.71 | 16134.0 |
| 2013-02-28 04:30:00 | ES | Futures | 1555.71 | 1557.51 | 1555.46 | 1557.25 | 12196.0 |
| 2013-02-28 05:00:00 | ES | Futures | 1557.25 | 1558.02 | 1555.97 | 1557.25 | 10701.0 |
| 2013-02-28 05:30:00 | ES | Futures | 1557.25 | 1557.25 | 1555.97 | 1556.99 | 10225.0 |
| 2013-02-28 06:00:00 | ES | Futures | 1556.99 | 1558.28 | 1556.48 | 1558.28 | 11497.0 |
| 2013-02-28 06:30:00 | ES | Futures | 1558.28 | 1559.3 | 1558.02 | 1558.79 | 14916.0 |
| 2013-02-28 07:00:00 | ES | Futures | 1558.53 | 1559.3 | 1558.02 | 1558.28 | 14736.0 |
| 2013-02-28 07:30:00 | ES | Futures | 1558.28 | 1558.53 | 1556.74 | 1557.25 | 17356.0 |
| 2013-02-28 08:00:00 | ES | Futures | 1557.51 | 1557.51 | 1555.97 | 1556.99 | 19725.0 |
| 2013-02-28 08:30:00 | ES | Futures | 1557.25 | 1557.51 | 1554.94 | 1556.74 | 37006.0 |
| 2013-02-28 09:00:00 | ES | Futures | 1556.48 | 1556.74 | 1553.66 | 1554.69 | 46463.0 |
| 2013-02-28 09:30:00 | ES | Futures | 1554.94 | 1560.59 | 1553.15 | 1558.02 | 281319.0 |
| 2013-02-28 10:00:00 | ES | Futures | 1558.28 | 1559.05 | 1554.69 | 1557.25 | 189233.0 |
| 2013-02-28 10:30:00 | ES | Futures | 1557.25 | 1557.25 | 1553.4 | 1554.94 | 162626.0 |
| 2013-02-28 11:00:00 | ES | Futures | 1554.94 | 1558.79 | 1553.92 | 1558.79 | 117604.0 |
| 2013-02-28 11:30:00 | ES | Futures | 1558.53 | 1558.79 | 1555.97 | 1557.25 | 91298.0 |
| 2013-02-28 12:00:00 | ES | Futures | 1557.25 | 1558.53 | 1556.48 | 1557.51 | 47053.0 |
| 2013-02-28 12:30:00 | ES | Futures | 1557.76 | 1559.82 | 1557.25 | 1558.53 | 45256.0 |
| 2013-02-28 13:00:00 | ES | Futures | 1558.53 | 1563.15 | 1558.53 | 1562.64 | 118013.0 |
| 2013-02-28 13:30:00 | ES | Futures | 1562.64 | 1563.41 | 1561.36 | 1562.9 | 78885.0 |
| 2013-02-28 14:00:00 | ES | Futures | 1562.64 | 1564.18 | 1562.13 | 1563.92 | 69626.0 |
| 2013-02-28 14:30:00 | ES | Futures | 1563.67 | 1564.69 | 1560.33 | 1560.84 | 102054.0 |
| 2013-02-28 15:00:00 | ES | Futures | 1560.59 | 1561.1 | 1558.02 | 1559.82 | 120114.0 |
| 2013-02-28 15:30:00 | ES | Futures | 1559.56 | 1560.33 | 1551.35 | 1551.61 | 254912.0 |
| 2013-02-28 16:00:00 | ES | Futures | 1551.61 | 1552.89 | 1549.04 | 1552.38 | 180204.0 |
| 2013-02-28 16:30:00 | ES | Futures | 1552.63 | 1552.63 | 1548.53 | 1548.78 | 18848.0 |
| 2013-02-28 17:00:00 | ES | Futures | 1549.04 | 1552.63 | 1548.78 | 1552.12 | 8712.0 |
| 2013-02-28 18:00:00 | ES | Futures | 1552.38 | 1552.63 | 1549.04 | 1549.55 | 10059.0 |
| 2013-02-28 18:30:00 | ES | Futures | 1549.55 | 1550.32 | 1546.99 | 1548.53 | 8533.0 |
| 2013-02-28 19:00:00 | ES | Futures | 1548.53 | 1550.84 | 1548.53 | 1550.84 | 4354.0 |
| 2013-02-28 19:30:00 | ES | Futures | 1550.84 | 1551.09 | 1548.53 | 1548.78 | 3975.0 |
| 2013-02-28 20:00:00 | ES | Futures | 1549.04 | 1549.55 | 1548.27 | 1548.53 | 4185.0 |
| 2013-02-28 20:30:00 | ES | Futures | 1548.53 | 1549.55 | 1548.27 | 1549.55 | 1819.0 |
| 2013-02-28 21:00:00 | ES | Futures | 1549.55 | 1550.32 | 1549.3 | 1549.81 | 1399.0 |
| 2013-02-28 21:30:00 | ES | Futures | 1549.81 | 1550.58 | 1549.55 | 1550.07 | 1245.0 |
| 2013-02-28 22:00:00 | ES | Futures | 1549.81 | 1550.58 | 1549.55 | 1550.32 | 1048.0 |
| 2013-02-28 22:30:00 | ES | Futures | 1550.58 | 1551.09 | 1550.32 | 1550.84 | 2719.0 |
| 2013-02-28 23:00:00 | ES | Futures | 1551.09 | 1551.61 | 1550.84 | 1551.61 | 1067.0 |
| 2013-02-28 23:30:00 | ES | Futures | 1551.35 | 1551.86 | 1550.84 | 1551.09 | 1882.0 |
| 2013-02-28 00:00:00 | NQ | Futures | 3195.65 | 3195.65 | 3193.32 | 3195.07 | 218.0 |
| 2013-02-28 00:30:00 | NQ | Futures | 3194.77 | 3196.81 | 3194.77 | 3196.23 | 193.0 |
| 2013-02-28 01:00:00 | NQ | Futures | 3196.23 | 3196.81 | 3195.36 | 3195.65 | 185.0 |
> showing 50 of 2,922 rows — these rows as CSV