PREVIEW / futures_30min / 2013-02-12
file: by_date/futures_30min/2013/2013-02-12.parquet size: 77 KB rows: 2,919
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-12 00:00:00 | ES | Futures | 1551.35 | 1551.61 | 1548.27 | 1548.53 | 10359.0 |
| 2013-02-12 00:30:00 | ES | Futures | 1548.78 | 1549.81 | 1548.53 | 1549.55 | 3136.0 |
| 2013-02-12 01:00:00 | ES | Futures | 1549.3 | 1549.81 | 1549.04 | 1549.55 | 1416.0 |
| 2013-02-12 01:30:00 | ES | Futures | 1549.55 | 1550.32 | 1549.55 | 1549.81 | 1126.0 |
| 2013-02-12 02:00:00 | ES | Futures | 1550.07 | 1551.35 | 1549.81 | 1550.84 | 3993.0 |
| 2013-02-12 02:30:00 | ES | Futures | 1551.09 | 1551.86 | 1550.58 | 1550.84 | 4446.0 |
| 2013-02-12 03:00:00 | ES | Futures | 1550.84 | 1551.35 | 1549.04 | 1549.55 | 16795.0 |
| 2013-02-12 03:30:00 | ES | Futures | 1549.55 | 1549.81 | 1548.78 | 1549.55 | 9782.0 |
| 2013-02-12 04:00:00 | ES | Futures | 1549.81 | 1551.61 | 1549.55 | 1551.61 | 10934.0 |
| 2013-02-12 04:30:00 | ES | Futures | 1551.61 | 1551.86 | 1549.55 | 1550.07 | 10366.0 |
| 2013-02-12 05:00:00 | ES | Futures | 1549.81 | 1551.61 | 1549.81 | 1551.35 | 7401.0 |
| 2013-02-12 05:30:00 | ES | Futures | 1551.61 | 1553.15 | 1551.09 | 1552.12 | 16184.0 |
| 2013-02-12 06:00:00 | ES | Futures | 1552.12 | 1553.4 | 1552.12 | 1552.63 | 13029.0 |
| 2013-02-12 06:30:00 | ES | Futures | 1552.63 | 1553.4 | 1552.12 | 1552.38 | 9008.0 |
| 2013-02-12 07:00:00 | ES | Futures | 1552.63 | 1553.15 | 1551.35 | 1551.61 | 8741.0 |
| 2013-02-12 07:30:00 | ES | Futures | 1551.61 | 1552.63 | 1551.09 | 1552.12 | 14815.0 |
| 2013-02-12 08:00:00 | ES | Futures | 1552.38 | 1554.43 | 1551.35 | 1553.66 | 23641.0 |
| 2013-02-12 08:30:00 | ES | Futures | 1553.66 | 1555.71 | 1553.4 | 1553.92 | 32207.0 |
| 2013-02-12 09:00:00 | ES | Futures | 1553.92 | 1554.43 | 1553.15 | 1553.66 | 17986.0 |
| 2013-02-12 09:30:00 | ES | Futures | 1553.66 | 1554.94 | 1551.86 | 1553.15 | 151263.0 |
| 2013-02-12 10:00:00 | ES | Futures | 1553.4 | 1556.22 | 1553.4 | 1555.46 | 135480.0 |
| 2013-02-12 10:30:00 | ES | Futures | 1555.2 | 1555.46 | 1553.15 | 1554.94 | 87962.0 |
| 2013-02-12 11:00:00 | ES | Futures | 1554.94 | 1555.71 | 1553.66 | 1554.43 | 95754.0 |
| 2013-02-12 11:30:00 | ES | Futures | 1554.69 | 1555.97 | 1553.92 | 1554.94 | 64288.0 |
| 2013-02-12 12:00:00 | ES | Futures | 1554.94 | 1556.48 | 1554.69 | 1555.46 | 46438.0 |
| 2013-02-12 12:30:00 | ES | Futures | 1555.46 | 1557.76 | 1555.2 | 1557.25 | 56209.0 |
| 2013-02-12 13:00:00 | ES | Futures | 1557.51 | 1559.05 | 1557.25 | 1558.79 | 51864.0 |
| 2013-02-12 13:30:00 | ES | Futures | 1558.79 | 1558.79 | 1556.99 | 1557.51 | 32727.0 |
| 2013-02-12 14:00:00 | ES | Futures | 1557.51 | 1557.76 | 1556.22 | 1556.48 | 30005.0 |
| 2013-02-12 14:30:00 | ES | Futures | 1556.48 | 1557.25 | 1556.48 | 1556.74 | 24273.0 |
| 2013-02-12 15:00:00 | ES | Futures | 1556.74 | 1556.74 | 1555.71 | 1556.48 | 39507.0 |
| 2013-02-12 15:30:00 | ES | Futures | 1556.22 | 1556.74 | 1554.94 | 1555.97 | 134660.0 |
| 2013-02-12 16:00:00 | ES | Futures | 1555.97 | 1557.25 | 1555.71 | 1556.48 | 62332.0 |
| 2013-02-12 16:30:00 | ES | Futures | 1556.48 | 1557.25 | 1556.22 | 1556.74 | 5675.0 |
| 2013-02-12 17:00:00 | ES | Futures | 1556.99 | 1558.02 | 1556.74 | 1557.76 | 2634.0 |
| 2013-02-12 18:00:00 | ES | Futures | 1557.51 | 1558.02 | 1557.51 | 1557.76 | 2160.0 |
| 2013-02-12 18:30:00 | ES | Futures | 1557.76 | 1558.02 | 1557.51 | 1557.76 | 1267.0 |
| 2013-02-12 19:00:00 | ES | Futures | 1558.02 | 1558.02 | 1556.99 | 1556.99 | 1949.0 |
| 2013-02-12 19:30:00 | ES | Futures | 1556.99 | 1558.02 | 1556.99 | 1557.51 | 2506.0 |
| 2013-02-12 20:00:00 | ES | Futures | 1557.51 | 1557.76 | 1556.99 | 1557.25 | 1188.0 |
| 2013-02-12 20:30:00 | ES | Futures | 1557.25 | 1557.76 | 1556.99 | 1557.76 | 902.0 |
| 2013-02-12 21:00:00 | ES | Futures | 1557.51 | 1558.28 | 1557.51 | 1558.02 | 1909.0 |
| 2013-02-12 21:30:00 | ES | Futures | 1558.28 | 1558.28 | 1557.51 | 1557.51 | 1347.0 |
| 2013-02-12 22:00:00 | ES | Futures | 1557.51 | 1558.02 | 1557.51 | 1557.51 | 1190.0 |
| 2013-02-12 22:30:00 | ES | Futures | 1557.51 | 1558.02 | 1557.51 | 1557.51 | 906.0 |
| 2013-02-12 23:00:00 | ES | Futures | 1557.51 | 1557.76 | 1557.25 | 1557.76 | 3142.0 |
| 2013-02-12 23:30:00 | ES | Futures | 1557.76 | 1557.76 | 1557.25 | 1557.25 | 1637.0 |
| 2013-02-12 00:00:00 | NQ | Futures | 3223.59 | 3223.59 | 3217.77 | 3218.06 | 635.0 |
| 2013-02-12 00:30:00 | NQ | Futures | 3218.64 | 3220.97 | 3218.64 | 3220.39 | 198.0 |
| 2013-02-12 01:00:00 | NQ | Futures | 3220.1 | 3220.68 | 3219.81 | 3220.68 | 134.0 |
> showing 50 of 2,919 rows — these rows as CSV