PREVIEW / futures_30min / 2013-02-19
file: by_date/futures_30min/2013/2013-02-19.parquet size: 74 KB rows: 2,825
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-19 00:00:00 | ES | Futures | 1557.76 | 1558.02 | 1557.51 | 1558.02 | 1729.0 |
| 2013-02-19 00:30:00 | ES | Futures | 1557.76 | 1558.28 | 1557.76 | 1558.28 | 1305.0 |
| 2013-02-19 01:00:00 | ES | Futures | 1558.02 | 1558.28 | 1557.76 | 1558.02 | 1480.0 |
| 2013-02-19 01:30:00 | ES | Futures | 1558.02 | 1558.28 | 1556.99 | 1557.51 | 1477.0 |
| 2013-02-19 02:00:00 | ES | Futures | 1557.25 | 1557.76 | 1556.74 | 1557.51 | 4490.0 |
| 2013-02-19 02:30:00 | ES | Futures | 1557.25 | 1557.51 | 1555.2 | 1555.46 | 7061.0 |
| 2013-02-19 03:00:00 | ES | Futures | 1555.46 | 1558.02 | 1555.46 | 1557.76 | 18725.0 |
| 2013-02-19 03:30:00 | ES | Futures | 1558.02 | 1558.53 | 1557.25 | 1557.76 | 14536.0 |
| 2013-02-19 04:00:00 | ES | Futures | 1557.76 | 1558.28 | 1556.99 | 1558.02 | 9252.0 |
| 2013-02-19 04:30:00 | ES | Futures | 1558.02 | 1559.82 | 1557.76 | 1559.05 | 12436.0 |
| 2013-02-19 05:00:00 | ES | Futures | 1559.05 | 1559.82 | 1558.53 | 1559.3 | 12641.0 |
| 2013-02-19 05:30:00 | ES | Futures | 1559.3 | 1559.82 | 1559.05 | 1559.56 | 7714.0 |
| 2013-02-19 06:00:00 | ES | Futures | 1559.3 | 1559.56 | 1558.79 | 1559.05 | 6464.0 |
| 2013-02-19 06:30:00 | ES | Futures | 1559.05 | 1559.05 | 1558.02 | 1558.28 | 7471.0 |
| 2013-02-19 07:00:00 | ES | Futures | 1558.53 | 1560.84 | 1558.28 | 1560.59 | 24393.0 |
| 2013-02-19 07:30:00 | ES | Futures | 1560.59 | 1560.59 | 1559.3 | 1559.3 | 16275.0 |
| 2013-02-19 08:00:00 | ES | Futures | 1559.05 | 1560.84 | 1559.05 | 1560.33 | 10200.0 |
| 2013-02-19 08:30:00 | ES | Futures | 1560.07 | 1560.59 | 1559.56 | 1559.82 | 10585.0 |
| 2013-02-19 09:00:00 | ES | Futures | 1560.07 | 1560.33 | 1559.05 | 1559.56 | 24183.0 |
| 2013-02-19 09:30:00 | ES | Futures | 1559.56 | 1564.95 | 1559.56 | 1564.44 | 223598.0 |
| 2013-02-19 10:00:00 | ES | Futures | 1564.44 | 1564.95 | 1562.64 | 1564.69 | 114000.0 |
| 2013-02-19 10:30:00 | ES | Futures | 1564.95 | 1565.21 | 1562.64 | 1563.15 | 106272.0 |
| 2013-02-19 11:00:00 | ES | Futures | 1563.41 | 1565.98 | 1562.64 | 1565.72 | 77035.0 |
| 2013-02-19 11:30:00 | ES | Futures | 1565.72 | 1566.23 | 1564.18 | 1565.98 | 82568.0 |
| 2013-02-19 12:00:00 | ES | Futures | 1565.98 | 1565.98 | 1564.44 | 1565.21 | 58906.0 |
| 2013-02-19 12:30:00 | ES | Futures | 1565.21 | 1565.72 | 1564.18 | 1565.72 | 37315.0 |
| 2013-02-19 13:00:00 | ES | Futures | 1565.72 | 1565.98 | 1565.21 | 1565.72 | 25835.0 |
| 2013-02-19 13:30:00 | ES | Futures | 1565.46 | 1566.23 | 1565.21 | 1565.72 | 30699.0 |
| 2013-02-19 14:00:00 | ES | Futures | 1565.72 | 1568.03 | 1565.72 | 1567.51 | 79768.0 |
| 2013-02-19 14:30:00 | ES | Futures | 1567.51 | 1568.54 | 1566.75 | 1567.26 | 55439.0 |
| 2013-02-19 15:00:00 | ES | Futures | 1567.26 | 1568.28 | 1566.75 | 1567.26 | 38130.0 |
| 2013-02-19 15:30:00 | ES | Futures | 1567.0 | 1569.05 | 1566.23 | 1568.54 | 141344.0 |
| 2013-02-19 16:00:00 | ES | Futures | 1568.28 | 1568.8 | 1567.26 | 1568.28 | 92934.0 |
| 2013-02-19 16:30:00 | ES | Futures | 1568.54 | 1569.31 | 1568.28 | 1568.54 | 8450.0 |
| 2013-02-19 17:00:00 | ES | Futures | 1568.54 | 1569.31 | 1568.54 | 1569.31 | 1226.0 |
| 2013-02-19 18:00:00 | ES | Futures | 1569.05 | 1569.05 | 1568.28 | 1568.54 | 2657.0 |
| 2013-02-19 18:30:00 | ES | Futures | 1568.54 | 1569.05 | 1568.54 | 1569.05 | 1884.0 |
| 2013-02-19 19:00:00 | ES | Futures | 1569.05 | 1569.31 | 1568.54 | 1568.8 | 3466.0 |
| 2013-02-19 19:30:00 | ES | Futures | 1568.8 | 1569.05 | 1568.54 | 1568.8 | 1376.0 |
| 2013-02-19 20:00:00 | ES | Futures | 1568.8 | 1569.57 | 1568.54 | 1569.31 | 3004.0 |
| 2013-02-19 20:30:00 | ES | Futures | 1569.05 | 1569.57 | 1568.8 | 1569.05 | 1895.0 |
| 2013-02-19 21:00:00 | ES | Futures | 1569.05 | 1569.05 | 1568.54 | 1568.54 | 1816.0 |
| 2013-02-19 21:30:00 | ES | Futures | 1568.8 | 1569.05 | 1568.28 | 1569.05 | 2025.0 |
| 2013-02-19 22:00:00 | ES | Futures | 1568.8 | 1569.05 | 1568.8 | 1568.8 | 339.0 |
| 2013-02-19 22:30:00 | ES | Futures | 1568.8 | 1569.31 | 1568.8 | 1569.31 | 1311.0 |
| 2013-02-19 23:00:00 | ES | Futures | 1569.31 | 1569.82 | 1569.05 | 1569.57 | 1432.0 |
| 2013-02-19 23:30:00 | ES | Futures | 1569.57 | 1569.82 | 1569.31 | 1569.57 | 976.0 |
| 2013-02-19 00:00:00 | NQ | Futures | 3217.19 | 3217.77 | 3216.6 | 3216.9 | 88.0 |
| 2013-02-19 00:30:00 | NQ | Futures | 3217.48 | 3217.77 | 3217.19 | 3217.77 | 46.0 |
| 2013-02-19 01:00:00 | NQ | Futures | 3217.48 | 3217.77 | 3217.19 | 3217.48 | 46.0 |
> showing 50 of 2,825 rows — these rows as CSV