PREVIEW / futures_30min / 2013-09-04
file: by_date/futures_30min/2013/2013-09-04.parquet size: 75 KB rows: 2,797
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-09-04 00:00:00 | ES | Futures | 1695.47 | 1695.73 | 1695.21 | 1695.47 | 845.0 |
| 2013-09-04 00:30:00 | ES | Futures | 1695.21 | 1697.54 | 1695.21 | 1697.54 | 4272.0 |
| 2013-09-04 01:00:00 | ES | Futures | 1697.28 | 1698.05 | 1697.28 | 1697.79 | 2659.0 |
| 2013-09-04 01:30:00 | ES | Futures | 1697.79 | 1698.05 | 1697.28 | 1697.54 | 2169.0 |
| 2013-09-04 02:00:00 | ES | Futures | 1697.79 | 1697.79 | 1696.24 | 1696.5 | 3688.0 |
| 2013-09-04 02:30:00 | ES | Futures | 1696.5 | 1697.28 | 1696.24 | 1696.76 | 2262.0 |
| 2013-09-04 03:00:00 | ES | Futures | 1697.02 | 1697.54 | 1692.37 | 1693.66 | 17103.0 |
| 2013-09-04 03:30:00 | ES | Futures | 1693.92 | 1693.92 | 1692.11 | 1692.88 | 8652.0 |
| 2013-09-04 04:00:00 | ES | Futures | 1693.14 | 1694.95 | 1692.88 | 1693.92 | 9209.0 |
| 2013-09-04 04:30:00 | ES | Futures | 1693.92 | 1693.92 | 1691.59 | 1693.4 | 8459.0 |
| 2013-09-04 05:00:00 | ES | Futures | 1693.4 | 1694.17 | 1692.88 | 1693.4 | 5371.0 |
| 2013-09-04 05:30:00 | ES | Futures | 1693.14 | 1694.95 | 1691.85 | 1692.37 | 14246.0 |
| 2013-09-04 06:00:00 | ES | Futures | 1692.11 | 1693.66 | 1691.85 | 1693.66 | 4955.0 |
| 2013-09-04 06:30:00 | ES | Futures | 1693.66 | 1694.69 | 1693.4 | 1694.43 | 10072.0 |
| 2013-09-04 07:00:00 | ES | Futures | 1694.17 | 1695.73 | 1693.4 | 1694.43 | 8724.0 |
| 2013-09-04 07:30:00 | ES | Futures | 1694.69 | 1694.95 | 1693.14 | 1693.14 | 7814.0 |
| 2013-09-04 08:00:00 | ES | Futures | 1693.4 | 1693.66 | 1692.62 | 1693.4 | 8134.0 |
| 2013-09-04 08:30:00 | ES | Futures | 1693.4 | 1693.66 | 1690.56 | 1692.62 | 26265.0 |
| 2013-09-04 09:00:00 | ES | Futures | 1692.62 | 1694.17 | 1692.37 | 1694.17 | 22945.0 |
| 2013-09-04 09:30:00 | ES | Futures | 1693.92 | 1699.6 | 1690.81 | 1698.31 | 202456.0 |
| 2013-09-04 10:00:00 | ES | Futures | 1698.57 | 1703.22 | 1698.31 | 1702.96 | 142463.0 |
| 2013-09-04 10:30:00 | ES | Futures | 1702.96 | 1704.0 | 1701.67 | 1703.48 | 109082.0 |
| 2013-09-04 11:00:00 | ES | Futures | 1703.48 | 1705.81 | 1702.96 | 1705.03 | 111947.0 |
| 2013-09-04 11:30:00 | ES | Futures | 1705.03 | 1709.68 | 1704.77 | 1709.43 | 146701.0 |
| 2013-09-04 12:00:00 | ES | Futures | 1709.43 | 1709.94 | 1708.13 | 1708.39 | 76751.0 |
| 2013-09-04 12:30:00 | ES | Futures | 1708.39 | 1709.68 | 1708.13 | 1708.65 | 50682.0 |
| 2013-09-04 13:00:00 | ES | Futures | 1708.91 | 1710.98 | 1708.13 | 1710.46 | 65765.0 |
| 2013-09-04 13:30:00 | ES | Futures | 1710.46 | 1710.46 | 1707.36 | 1708.13 | 60571.0 |
| 2013-09-04 14:00:00 | ES | Futures | 1708.13 | 1709.43 | 1707.1 | 1707.88 | 58914.0 |
| 2013-09-04 14:30:00 | ES | Futures | 1707.62 | 1709.68 | 1706.84 | 1709.17 | 48474.0 |
| 2013-09-04 15:00:00 | ES | Futures | 1708.91 | 1710.46 | 1706.07 | 1707.88 | 94558.0 |
| 2013-09-04 15:30:00 | ES | Futures | 1707.62 | 1708.91 | 1705.55 | 1707.88 | 158431.0 |
| 2013-09-04 16:00:00 | ES | Futures | 1707.88 | 1710.2 | 1707.36 | 1709.94 | 76276.0 |
| 2013-09-04 16:30:00 | ES | Futures | 1709.68 | 1710.72 | 1709.68 | 1710.72 | 7261.0 |
| 2013-09-04 17:00:00 | ES | Futures | 1710.46 | 1711.49 | 1710.46 | 1711.24 | 4567.0 |
| 2013-09-04 18:00:00 | ES | Futures | 1710.98 | 1711.24 | 1710.2 | 1710.2 | 2092.0 |
| 2013-09-04 18:30:00 | ES | Futures | 1710.46 | 1710.98 | 1710.2 | 1710.46 | 697.0 |
| 2013-09-04 19:00:00 | ES | Futures | 1710.72 | 1710.98 | 1710.46 | 1710.46 | 622.0 |
| 2013-09-04 19:30:00 | ES | Futures | 1710.72 | 1711.24 | 1710.2 | 1710.98 | 1248.0 |
| 2013-09-04 20:00:00 | ES | Futures | 1710.98 | 1710.98 | 1709.68 | 1709.68 | 2358.0 |
| 2013-09-04 20:30:00 | ES | Futures | 1709.68 | 1710.2 | 1709.43 | 1709.94 | 2097.0 |
| 2013-09-04 21:00:00 | ES | Futures | 1709.68 | 1710.2 | 1709.43 | 1709.94 | 965.0 |
| 2013-09-04 21:30:00 | ES | Futures | 1709.94 | 1710.2 | 1709.17 | 1709.43 | 2390.0 |
| 2013-09-04 22:00:00 | ES | Futures | 1709.43 | 1710.2 | 1709.17 | 1709.94 | 769.0 |
| 2013-09-04 22:30:00 | ES | Futures | 1709.94 | 1710.2 | 1709.43 | 1709.94 | 1158.0 |
| 2013-09-04 23:00:00 | ES | Futures | 1709.94 | 1710.46 | 1709.68 | 1710.2 | 790.0 |
| 2013-09-04 23:30:00 | ES | Futures | 1710.46 | 1710.46 | 1709.94 | 1709.94 | 1062.0 |
| 2013-09-04 00:00:00 | NQ | Futures | 3613.79 | 3614.08 | 3612.62 | 3613.5 | 113.0 |
| 2013-09-04 00:30:00 | NQ | Futures | 3613.5 | 3617.88 | 3613.2 | 3617.59 | 572.0 |
| 2013-09-04 01:00:00 | NQ | Futures | 3617.3 | 3619.34 | 3617.0 | 3619.05 | 363.0 |
> showing 50 of 2,797 rows — these rows as CSV