PREVIEW / futures_30min / 2014-08-25
file: by_date/futures_30min/2014/2014-08-25.parquet size: 65 KB rows: 2,581
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-25 00:00:00 | ES | Futures | 2079.18 | 2079.7 | 2078.66 | 2079.44 | 2538.0 |
| 2014-08-25 00:30:00 | ES | Futures | 2079.18 | 2079.7 | 2079.18 | 2079.44 | 2294.0 |
| 2014-08-25 01:00:00 | ES | Futures | 2079.18 | 2079.18 | 2078.14 | 2078.4 | 1589.0 |
| 2014-08-25 01:30:00 | ES | Futures | 2078.66 | 2080.74 | 2078.4 | 2079.44 | 6219.0 |
| 2014-08-25 02:00:00 | ES | Futures | 2079.7 | 2082.31 | 2079.44 | 2082.05 | 12153.0 |
| 2014-08-25 02:30:00 | ES | Futures | 2082.31 | 2082.31 | 2080.48 | 2081.0 | 6339.0 |
| 2014-08-25 03:00:00 | ES | Futures | 2081.0 | 2082.05 | 2079.44 | 2079.96 | 10636.0 |
| 2014-08-25 03:30:00 | ES | Futures | 2079.96 | 2080.74 | 2079.18 | 2079.44 | 4137.0 |
| 2014-08-25 04:00:00 | ES | Futures | 2079.44 | 2079.96 | 2078.4 | 2079.7 | 6537.0 |
| 2014-08-25 04:30:00 | ES | Futures | 2079.96 | 2079.96 | 2078.14 | 2078.14 | 4745.0 |
| 2014-08-25 05:00:00 | ES | Futures | 2078.14 | 2078.92 | 2078.14 | 2078.4 | 1897.0 |
| 2014-08-25 05:30:00 | ES | Futures | 2078.4 | 2078.92 | 2077.35 | 2077.61 | 5695.0 |
| 2014-08-25 06:00:00 | ES | Futures | 2077.35 | 2078.92 | 2077.35 | 2078.4 | 4180.0 |
| 2014-08-25 06:30:00 | ES | Futures | 2078.66 | 2079.44 | 2077.61 | 2078.66 | 4856.0 |
| 2014-08-25 07:00:00 | ES | Futures | 2078.66 | 2079.7 | 2078.14 | 2079.44 | 5633.0 |
| 2014-08-25 07:30:00 | ES | Futures | 2079.44 | 2080.48 | 2079.18 | 2079.96 | 6393.0 |
| 2014-08-25 08:00:00 | ES | Futures | 2079.96 | 2080.22 | 2078.92 | 2079.96 | 4850.0 |
| 2014-08-25 08:30:00 | ES | Futures | 2079.96 | 2081.26 | 2079.44 | 2081.26 | 14363.0 |
| 2014-08-25 09:00:00 | ES | Futures | 2081.26 | 2081.52 | 2080.22 | 2080.22 | 12791.0 |
| 2014-08-25 09:30:00 | ES | Futures | 2080.48 | 2082.57 | 2077.88 | 2081.52 | 100145.0 |
| 2014-08-25 10:00:00 | ES | Futures | 2081.78 | 2082.83 | 2079.96 | 2081.26 | 76014.0 |
| 2014-08-25 10:30:00 | ES | Futures | 2081.26 | 2084.39 | 2081.0 | 2083.61 | 78589.0 |
| 2014-08-25 11:00:00 | ES | Futures | 2083.87 | 2084.65 | 2082.83 | 2084.39 | 57331.0 |
| 2014-08-25 11:30:00 | ES | Futures | 2084.39 | 2084.65 | 2083.35 | 2083.61 | 32837.0 |
| 2014-08-25 12:00:00 | ES | Futures | 2083.61 | 2083.87 | 2079.7 | 2080.48 | 45385.0 |
| 2014-08-25 12:30:00 | ES | Futures | 2080.22 | 2080.74 | 2078.4 | 2079.18 | 46204.0 |
| 2014-08-25 13:00:00 | ES | Futures | 2078.92 | 2080.22 | 2077.35 | 2079.96 | 46317.0 |
| 2014-08-25 13:30:00 | ES | Futures | 2079.96 | 2081.52 | 2079.44 | 2080.74 | 27889.0 |
| 2014-08-25 14:00:00 | ES | Futures | 2080.74 | 2081.0 | 2078.92 | 2079.44 | 25983.0 |
| 2014-08-25 14:30:00 | ES | Futures | 2079.44 | 2080.74 | 2078.66 | 2080.22 | 22447.0 |
| 2014-08-25 15:00:00 | ES | Futures | 2080.48 | 2081.0 | 2079.44 | 2079.96 | 25579.0 |
| 2014-08-25 15:30:00 | ES | Futures | 2079.96 | 2081.26 | 2079.44 | 2081.0 | 75614.0 |
| 2014-08-25 16:00:00 | ES | Futures | 2080.74 | 2081.26 | 2079.18 | 2079.7 | 44625.0 |
| 2014-08-25 16:30:00 | ES | Futures | 2079.7 | 2079.7 | 2079.18 | 2079.18 | 2920.0 |
| 2014-08-25 17:00:00 | ES | Futures | 2079.44 | 2079.7 | 2079.18 | 2079.7 | 1348.0 |
| 2014-08-25 18:00:00 | ES | Futures | 2079.18 | 2079.96 | 2078.66 | 2079.96 | 3322.0 |
| 2014-08-25 18:30:00 | ES | Futures | 2079.96 | 2079.96 | 2079.18 | 2079.44 | 910.0 |
| 2014-08-25 19:00:00 | ES | Futures | 2079.44 | 2079.96 | 2079.44 | 2079.96 | 439.0 |
| 2014-08-25 19:30:00 | ES | Futures | 2079.96 | 2080.22 | 2079.7 | 2079.96 | 742.0 |
| 2014-08-25 20:00:00 | ES | Futures | 2079.96 | 2080.22 | 2079.7 | 2079.96 | 1468.0 |
| 2014-08-25 20:30:00 | ES | Futures | 2079.7 | 2079.96 | 2078.14 | 2078.4 | 1950.0 |
| 2014-08-25 21:00:00 | ES | Futures | 2078.4 | 2078.92 | 2078.14 | 2078.4 | 1864.0 |
| 2014-08-25 21:30:00 | ES | Futures | 2078.66 | 2078.66 | 2078.14 | 2078.14 | 1478.0 |
| 2014-08-25 22:00:00 | ES | Futures | 2078.14 | 2078.4 | 2077.88 | 2078.14 | 1394.0 |
| 2014-08-25 22:30:00 | ES | Futures | 2078.14 | 2078.4 | 2077.88 | 2077.88 | 660.0 |
| 2014-08-25 23:00:00 | ES | Futures | 2078.14 | 2078.4 | 2077.09 | 2077.35 | 2152.0 |
| 2014-08-25 23:30:00 | ES | Futures | 2077.61 | 2077.88 | 2077.09 | 2077.35 | 1107.0 |
| 2014-08-25 00:00:00 | NQ | Futures | 4754.29 | 4756.04 | 4754.0 | 4755.75 | 710.0 |
| 2014-08-25 00:30:00 | NQ | Futures | 4755.17 | 4755.75 | 4754.88 | 4755.17 | 196.0 |
| 2014-08-25 01:00:00 | NQ | Futures | 4755.17 | 4755.17 | 4752.25 | 4752.83 | 550.0 |
> showing 50 of 2,581 rows — these rows as CSV