PREVIEW / futures_30min / 2013-01-22
file: by_date/futures_30min/2013/2013-01-22.parquet size: 77 KB rows: 2,899
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-01-22 00:00:00 | ES | Futures | 1519.28 | 1521.33 | 1519.28 | 1520.82 | 2981.0 |
| 2013-01-22 00:30:00 | ES | Futures | 1520.82 | 1521.84 | 1520.56 | 1521.59 | 1760.0 |
| 2013-01-22 01:00:00 | ES | Futures | 1521.33 | 1521.33 | 1520.56 | 1520.56 | 2085.0 |
| 2013-01-22 01:30:00 | ES | Futures | 1520.82 | 1521.07 | 1519.79 | 1520.05 | 1607.0 |
| 2013-01-22 02:00:00 | ES | Futures | 1520.05 | 1521.07 | 1519.79 | 1520.82 | 1922.0 |
| 2013-01-22 02:30:00 | ES | Futures | 1520.82 | 1520.82 | 1519.53 | 1520.05 | 5702.0 |
| 2013-01-22 03:00:00 | ES | Futures | 1520.05 | 1521.33 | 1518.51 | 1519.02 | 10222.0 |
| 2013-01-22 03:30:00 | ES | Futures | 1519.02 | 1519.53 | 1515.43 | 1515.94 | 27710.0 |
| 2013-01-22 04:00:00 | ES | Futures | 1515.94 | 1516.45 | 1513.89 | 1515.94 | 38069.0 |
| 2013-01-22 04:30:00 | ES | Futures | 1515.94 | 1516.97 | 1515.17 | 1516.45 | 13545.0 |
| 2013-01-22 05:00:00 | ES | Futures | 1516.71 | 1519.79 | 1516.45 | 1519.28 | 21067.0 |
| 2013-01-22 05:30:00 | ES | Futures | 1519.53 | 1520.05 | 1518.51 | 1519.28 | 11908.0 |
| 2013-01-22 06:00:00 | ES | Futures | 1519.28 | 1520.05 | 1517.74 | 1517.74 | 14669.0 |
| 2013-01-22 06:30:00 | ES | Futures | 1517.99 | 1518.76 | 1516.45 | 1517.99 | 12938.0 |
| 2013-01-22 07:00:00 | ES | Futures | 1517.99 | 1519.28 | 1517.48 | 1519.02 | 9973.0 |
| 2013-01-22 07:30:00 | ES | Futures | 1518.76 | 1519.02 | 1516.45 | 1517.22 | 11783.0 |
| 2013-01-22 08:00:00 | ES | Futures | 1517.22 | 1517.22 | 1515.43 | 1516.45 | 22483.0 |
| 2013-01-22 08:30:00 | ES | Futures | 1516.71 | 1517.74 | 1515.94 | 1517.22 | 14396.0 |
| 2013-01-22 09:00:00 | ES | Futures | 1517.22 | 1518.76 | 1516.97 | 1518.25 | 22770.0 |
| 2013-01-22 09:30:00 | ES | Futures | 1518.51 | 1520.56 | 1517.48 | 1519.28 | 122021.0 |
| 2013-01-22 10:00:00 | ES | Futures | 1519.28 | 1519.53 | 1515.17 | 1515.17 | 131561.0 |
| 2013-01-22 10:30:00 | ES | Futures | 1515.43 | 1517.99 | 1514.66 | 1517.74 | 82229.0 |
| 2013-01-22 11:00:00 | ES | Futures | 1517.48 | 1519.02 | 1516.45 | 1518.76 | 69003.0 |
| 2013-01-22 11:30:00 | ES | Futures | 1518.51 | 1520.05 | 1517.48 | 1519.53 | 51318.0 |
| 2013-01-22 12:00:00 | ES | Futures | 1519.28 | 1521.84 | 1519.28 | 1521.59 | 67752.0 |
| 2013-01-22 12:30:00 | ES | Futures | 1521.59 | 1522.87 | 1521.07 | 1521.59 | 55606.0 |
| 2013-01-22 13:00:00 | ES | Futures | 1521.33 | 1523.64 | 1521.07 | 1522.61 | 42729.0 |
| 2013-01-22 13:30:00 | ES | Futures | 1522.87 | 1523.38 | 1522.1 | 1522.35 | 36333.0 |
| 2013-01-22 14:00:00 | ES | Futures | 1522.61 | 1524.15 | 1521.84 | 1523.89 | 46763.0 |
| 2013-01-22 14:30:00 | ES | Futures | 1524.15 | 1525.43 | 1523.64 | 1525.18 | 44237.0 |
| 2013-01-22 15:00:00 | ES | Futures | 1525.18 | 1525.43 | 1523.12 | 1524.66 | 44947.0 |
| 2013-01-22 15:30:00 | ES | Futures | 1524.66 | 1526.72 | 1523.64 | 1526.2 | 136609.0 |
| 2013-01-22 16:00:00 | ES | Futures | 1525.95 | 1529.28 | 1525.18 | 1528.77 | 114761.0 |
| 2013-01-22 16:30:00 | ES | Futures | 1528.77 | 1529.28 | 1528.0 | 1529.28 | 11822.0 |
| 2013-01-22 17:00:00 | ES | Futures | 1529.28 | 1530.82 | 1529.03 | 1530.31 | 6070.0 |
| 2013-01-22 18:00:00 | ES | Futures | 1529.8 | 1530.57 | 1529.03 | 1529.54 | 5577.0 |
| 2013-01-22 18:30:00 | ES | Futures | 1529.54 | 1529.8 | 1528.26 | 1528.77 | 3490.0 |
| 2013-01-22 19:00:00 | ES | Futures | 1528.77 | 1529.54 | 1528.51 | 1529.28 | 3164.0 |
| 2013-01-22 19:30:00 | ES | Futures | 1529.28 | 1529.28 | 1528.51 | 1529.03 | 2661.0 |
| 2013-01-22 20:00:00 | ES | Futures | 1529.03 | 1529.54 | 1528.77 | 1528.77 | 2281.0 |
| 2013-01-22 20:30:00 | ES | Futures | 1528.77 | 1529.28 | 1528.26 | 1528.77 | 2626.0 |
| 2013-01-22 21:00:00 | ES | Futures | 1528.51 | 1528.77 | 1528.0 | 1528.26 | 1721.0 |
| 2013-01-22 21:30:00 | ES | Futures | 1528.0 | 1528.26 | 1527.74 | 1527.74 | 1276.0 |
| 2013-01-22 22:00:00 | ES | Futures | 1528.0 | 1528.0 | 1527.49 | 1527.49 | 1301.0 |
| 2013-01-22 22:30:00 | ES | Futures | 1527.49 | 1527.74 | 1526.97 | 1526.97 | 2093.0 |
| 2013-01-22 23:00:00 | ES | Futures | 1527.23 | 1527.49 | 1526.72 | 1526.72 | 1496.0 |
| 2013-01-22 23:30:00 | ES | Futures | 1526.97 | 1526.97 | 1526.46 | 1526.72 | 1459.0 |
| 2013-01-22 00:00:00 | NQ | Futures | 3188.95 | 3192.45 | 3188.37 | 3191.86 | 514.0 |
| 2013-01-22 00:30:00 | NQ | Futures | 3191.57 | 3193.61 | 3191.28 | 3193.32 | 211.0 |
| 2013-01-22 01:00:00 | NQ | Futures | 3192.74 | 3193.32 | 3191.86 | 3192.15 | 178.0 |
> showing 50 of 2,899 rows — these rows as CSV