PREVIEW / futures_30min / 2013-10-09
file: by_date/futures_30min/2013/2013-10-09.parquet size: 75 KB rows: 2,874
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-10-09 00:00:00 | ES | Futures | 1707.96 | 1708.73 | 1707.44 | 1708.47 | 1642.0 |
| 2013-10-09 00:30:00 | ES | Futures | 1708.21 | 1709.25 | 1708.21 | 1708.73 | 1315.0 |
| 2013-10-09 01:00:00 | ES | Futures | 1708.73 | 1709.25 | 1708.73 | 1708.73 | 1549.0 |
| 2013-10-09 01:30:00 | ES | Futures | 1708.73 | 1708.73 | 1707.96 | 1708.47 | 2461.0 |
| 2013-10-09 02:00:00 | ES | Futures | 1708.21 | 1709.76 | 1708.21 | 1708.99 | 5173.0 |
| 2013-10-09 02:30:00 | ES | Futures | 1709.25 | 1709.25 | 1707.96 | 1708.47 | 2086.0 |
| 2013-10-09 03:00:00 | ES | Futures | 1708.21 | 1708.73 | 1706.67 | 1708.21 | 12459.0 |
| 2013-10-09 03:30:00 | ES | Futures | 1707.96 | 1709.25 | 1707.18 | 1707.7 | 7567.0 |
| 2013-10-09 04:00:00 | ES | Futures | 1707.7 | 1709.25 | 1706.67 | 1706.92 | 8144.0 |
| 2013-10-09 04:30:00 | ES | Futures | 1706.92 | 1708.47 | 1706.41 | 1707.96 | 7231.0 |
| 2013-10-09 05:00:00 | ES | Futures | 1707.96 | 1711.05 | 1707.96 | 1710.28 | 12242.0 |
| 2013-10-09 05:30:00 | ES | Futures | 1710.28 | 1710.54 | 1707.96 | 1708.21 | 5977.0 |
| 2013-10-09 06:00:00 | ES | Futures | 1708.21 | 1709.5 | 1707.96 | 1708.21 | 10450.0 |
| 2013-10-09 06:30:00 | ES | Futures | 1708.21 | 1709.76 | 1708.21 | 1709.25 | 6975.0 |
| 2013-10-09 07:00:00 | ES | Futures | 1709.25 | 1710.54 | 1708.21 | 1708.73 | 12167.0 |
| 2013-10-09 07:30:00 | ES | Futures | 1708.73 | 1708.73 | 1706.67 | 1706.67 | 15808.0 |
| 2013-10-09 08:00:00 | ES | Futures | 1706.67 | 1708.21 | 1704.34 | 1707.7 | 39100.0 |
| 2013-10-09 08:30:00 | ES | Futures | 1707.44 | 1707.96 | 1705.12 | 1705.89 | 19021.0 |
| 2013-10-09 09:00:00 | ES | Futures | 1705.89 | 1707.7 | 1705.12 | 1705.38 | 32738.0 |
| 2013-10-09 09:30:00 | ES | Futures | 1705.38 | 1705.89 | 1699.19 | 1703.57 | 267026.0 |
| 2013-10-09 10:00:00 | ES | Futures | 1703.83 | 1705.12 | 1699.44 | 1703.83 | 217095.0 |
| 2013-10-09 10:30:00 | ES | Futures | 1704.09 | 1705.38 | 1696.61 | 1697.38 | 197517.0 |
| 2013-10-09 11:00:00 | ES | Futures | 1697.38 | 1699.96 | 1692.22 | 1695.06 | 209602.0 |
| 2013-10-09 11:30:00 | ES | Futures | 1694.8 | 1699.96 | 1694.54 | 1698.93 | 159437.0 |
| 2013-10-09 12:00:00 | ES | Futures | 1699.19 | 1700.99 | 1697.9 | 1698.41 | 91143.0 |
| 2013-10-09 12:30:00 | ES | Futures | 1698.67 | 1701.51 | 1697.12 | 1697.64 | 76744.0 |
| 2013-10-09 13:00:00 | ES | Futures | 1697.9 | 1707.44 | 1697.64 | 1706.15 | 187654.0 |
| 2013-10-09 13:30:00 | ES | Futures | 1706.15 | 1707.44 | 1704.09 | 1706.15 | 136856.0 |
| 2013-10-09 14:00:00 | ES | Futures | 1705.89 | 1708.47 | 1703.83 | 1707.18 | 168585.0 |
| 2013-10-09 14:30:00 | ES | Futures | 1707.18 | 1709.5 | 1705.89 | 1709.25 | 99064.0 |
| 2013-10-09 15:00:00 | ES | Futures | 1708.99 | 1709.5 | 1705.63 | 1706.92 | 78627.0 |
| 2013-10-09 15:30:00 | ES | Futures | 1706.92 | 1709.25 | 1700.73 | 1703.05 | 212791.0 |
| 2013-10-09 16:00:00 | ES | Futures | 1703.31 | 1703.31 | 1700.48 | 1701.25 | 100525.0 |
| 2013-10-09 16:30:00 | ES | Futures | 1700.73 | 1701.76 | 1700.22 | 1701.25 | 9233.0 |
| 2013-10-09 17:00:00 | ES | Futures | 1701.25 | 1701.51 | 1700.48 | 1700.48 | 1339.0 |
| 2013-10-09 18:00:00 | ES | Futures | 1700.99 | 1704.86 | 1700.48 | 1704.34 | 7130.0 |
| 2013-10-09 18:30:00 | ES | Futures | 1704.6 | 1706.15 | 1704.34 | 1705.89 | 3413.0 |
| 2013-10-09 19:00:00 | ES | Futures | 1705.89 | 1706.41 | 1705.12 | 1705.63 | 1833.0 |
| 2013-10-09 19:30:00 | ES | Futures | 1705.63 | 1705.63 | 1704.34 | 1704.6 | 1681.0 |
| 2013-10-09 20:00:00 | ES | Futures | 1704.34 | 1704.86 | 1704.09 | 1704.34 | 3096.0 |
| 2013-10-09 20:30:00 | ES | Futures | 1704.34 | 1705.63 | 1704.09 | 1705.38 | 3014.0 |
| 2013-10-09 21:00:00 | ES | Futures | 1705.63 | 1705.89 | 1704.86 | 1705.89 | 1882.0 |
| 2013-10-09 21:30:00 | ES | Futures | 1705.89 | 1707.18 | 1705.12 | 1706.67 | 4951.0 |
| 2013-10-09 22:00:00 | ES | Futures | 1706.67 | 1707.44 | 1706.41 | 1706.92 | 3100.0 |
| 2013-10-09 22:30:00 | ES | Futures | 1706.92 | 1707.18 | 1705.38 | 1705.63 | 5268.0 |
| 2013-10-09 23:00:00 | ES | Futures | 1705.63 | 1707.7 | 1705.63 | 1707.18 | 4179.0 |
| 2013-10-09 23:30:00 | ES | Futures | 1706.92 | 1708.47 | 1706.92 | 1707.96 | 2775.0 |
| 2013-10-09 00:00:00 | NQ | Futures | 3669.61 | 3670.2 | 3667.87 | 3669.03 | 584.0 |
| 2013-10-09 00:30:00 | NQ | Futures | 3669.03 | 3671.36 | 3668.45 | 3670.2 | 229.0 |
| 2013-10-09 01:00:00 | NQ | Futures | 3670.2 | 3670.78 | 3668.45 | 3668.45 | 385.0 |
> showing 50 of 2,874 rows — these rows as CSV