PREVIEW / futures_30min / 2013-01-23
file: by_date/futures_30min/2013/2013-01-23.parquet size: 76 KB rows: 2,960
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-23 00:00:00 | ES | Futures | 1526.72 | 1526.97 | 1526.2 | 1526.46 | 3322.0 |
| 2013-01-23 00:30:00 | ES | Futures | 1526.46 | 1526.46 | 1525.43 | 1525.69 | 5212.0 |
| 2013-01-23 01:00:00 | ES | Futures | 1525.69 | 1526.2 | 1525.18 | 1526.2 | 3579.0 |
| 2013-01-23 01:30:00 | ES | Futures | 1525.95 | 1526.72 | 1525.95 | 1526.2 | 2412.0 |
| 2013-01-23 02:00:00 | ES | Futures | 1526.2 | 1526.46 | 1525.43 | 1526.2 | 4522.0 |
| 2013-01-23 02:30:00 | ES | Futures | 1526.2 | 1526.46 | 1525.43 | 1525.69 | 4403.0 |
| 2013-01-23 03:00:00 | ES | Futures | 1525.69 | 1526.97 | 1524.92 | 1524.92 | 17530.0 |
| 2013-01-23 03:30:00 | ES | Futures | 1525.18 | 1525.69 | 1524.41 | 1524.66 | 10715.0 |
| 2013-01-23 04:00:00 | ES | Futures | 1524.66 | 1526.72 | 1524.15 | 1526.2 | 11297.0 |
| 2013-01-23 04:30:00 | ES | Futures | 1526.2 | 1527.49 | 1525.95 | 1526.97 | 13064.0 |
| 2013-01-23 05:00:00 | ES | Futures | 1526.72 | 1527.49 | 1526.72 | 1527.23 | 6790.0 |
| 2013-01-23 05:30:00 | ES | Futures | 1527.23 | 1527.49 | 1526.46 | 1527.23 | 5866.0 |
| 2013-01-23 06:00:00 | ES | Futures | 1527.23 | 1527.49 | 1526.2 | 1526.72 | 6972.0 |
| 2013-01-23 06:30:00 | ES | Futures | 1526.72 | 1527.23 | 1526.72 | 1526.72 | 3897.0 |
| 2013-01-23 07:00:00 | ES | Futures | 1526.97 | 1528.26 | 1526.72 | 1527.74 | 16792.0 |
| 2013-01-23 07:30:00 | ES | Futures | 1527.74 | 1528.0 | 1526.72 | 1526.72 | 10086.0 |
| 2013-01-23 08:00:00 | ES | Futures | 1526.72 | 1527.23 | 1525.43 | 1526.2 | 18737.0 |
| 2013-01-23 08:30:00 | ES | Futures | 1525.95 | 1526.97 | 1525.95 | 1525.95 | 13835.0 |
| 2013-01-23 09:00:00 | ES | Futures | 1526.2 | 1526.97 | 1525.18 | 1526.46 | 25993.0 |
| 2013-01-23 09:30:00 | ES | Futures | 1526.72 | 1527.74 | 1525.69 | 1526.46 | 119902.0 |
| 2013-01-23 10:00:00 | ES | Futures | 1526.46 | 1528.77 | 1525.18 | 1525.69 | 108577.0 |
| 2013-01-23 10:30:00 | ES | Futures | 1525.43 | 1525.69 | 1523.64 | 1525.18 | 111873.0 |
| 2013-01-23 11:00:00 | ES | Futures | 1525.18 | 1526.72 | 1524.66 | 1524.66 | 71629.0 |
| 2013-01-23 11:30:00 | ES | Futures | 1524.66 | 1526.97 | 1524.41 | 1526.2 | 79882.0 |
| 2013-01-23 12:00:00 | ES | Futures | 1525.95 | 1527.23 | 1525.69 | 1525.95 | 50398.0 |
| 2013-01-23 12:30:00 | ES | Futures | 1525.95 | 1527.49 | 1525.43 | 1527.23 | 31915.0 |
| 2013-01-23 13:00:00 | ES | Futures | 1527.49 | 1528.51 | 1527.23 | 1527.74 | 39934.0 |
| 2013-01-23 13:30:00 | ES | Futures | 1527.49 | 1528.51 | 1527.23 | 1528.26 | 25289.0 |
| 2013-01-23 14:00:00 | ES | Futures | 1528.51 | 1529.03 | 1527.49 | 1528.51 | 32365.0 |
| 2013-01-23 14:30:00 | ES | Futures | 1528.51 | 1530.31 | 1528.26 | 1529.8 | 41826.0 |
| 2013-01-23 15:00:00 | ES | Futures | 1530.05 | 1530.31 | 1528.77 | 1529.28 | 52976.0 |
| 2013-01-23 15:30:00 | ES | Futures | 1529.28 | 1529.28 | 1527.49 | 1529.03 | 110345.0 |
| 2013-01-23 16:00:00 | ES | Futures | 1529.03 | 1530.31 | 1528.26 | 1530.05 | 56609.0 |
| 2013-01-23 16:30:00 | ES | Futures | 1529.8 | 1530.31 | 1524.15 | 1524.66 | 37138.0 |
| 2013-01-23 17:00:00 | ES | Futures | 1524.66 | 1524.92 | 1523.64 | 1524.41 | 3889.0 |
| 2013-01-23 18:00:00 | ES | Futures | 1522.35 | 1523.64 | 1521.84 | 1522.87 | 13367.0 |
| 2013-01-23 18:30:00 | ES | Futures | 1522.87 | 1524.15 | 1522.35 | 1523.64 | 3247.0 |
| 2013-01-23 19:00:00 | ES | Futures | 1523.89 | 1523.89 | 1522.87 | 1523.38 | 3788.0 |
| 2013-01-23 19:30:00 | ES | Futures | 1523.38 | 1524.15 | 1522.61 | 1523.12 | 4999.0 |
| 2013-01-23 20:00:00 | ES | Futures | 1523.12 | 1523.64 | 1522.87 | 1523.12 | 2822.0 |
| 2013-01-23 20:30:00 | ES | Futures | 1523.38 | 1524.15 | 1522.61 | 1522.61 | 3080.0 |
| 2013-01-23 21:00:00 | ES | Futures | 1522.61 | 1525.18 | 1522.61 | 1524.92 | 5526.0 |
| 2013-01-23 21:30:00 | ES | Futures | 1524.92 | 1526.2 | 1524.66 | 1524.92 | 6842.0 |
| 2013-01-23 22:00:00 | ES | Futures | 1524.92 | 1525.69 | 1523.64 | 1523.64 | 3644.0 |
| 2013-01-23 22:30:00 | ES | Futures | 1523.64 | 1525.18 | 1523.64 | 1524.66 | 2212.0 |
| 2013-01-23 23:00:00 | ES | Futures | 1524.41 | 1524.92 | 1523.38 | 1523.64 | 2115.0 |
| 2013-01-23 23:30:00 | ES | Futures | 1523.64 | 1524.15 | 1523.12 | 1523.38 | 1844.0 |
| 2013-01-23 00:00:00 | NQ | Futures | 3205.25 | 3205.83 | 3204.67 | 3204.96 | 121.0 |
| 2013-01-23 00:30:00 | NQ | Futures | 3205.25 | 3205.54 | 3204.09 | 3204.09 | 341.0 |
| 2013-01-23 01:00:00 | NQ | Futures | 3204.38 | 3204.96 | 3203.51 | 3204.38 | 247.0 |
> showing 50 of 2,960 rows — these rows as CSV