PREVIEW / futures_30min / 2013-12-09
file: by_date/futures_30min/2013/2013-12-09.parquet size: 71 KB rows: 2,802
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-12-09 00:00:00 | ES | Futures | 1865.31 | 1865.83 | 1865.05 | 1865.31 | 3562.0 |
| 2013-12-09 00:30:00 | ES | Futures | 1865.57 | 1866.09 | 1865.05 | 1865.83 | 2010.0 |
| 2013-12-09 01:00:00 | ES | Futures | 1865.57 | 1866.09 | 1865.05 | 1865.57 | 1416.0 |
| 2013-12-09 01:30:00 | ES | Futures | 1865.31 | 1865.57 | 1865.31 | 1865.31 | 574.0 |
| 2013-12-09 02:00:00 | ES | Futures | 1865.31 | 1865.31 | 1864.02 | 1864.54 | 3206.0 |
| 2013-12-09 02:30:00 | ES | Futures | 1864.54 | 1866.09 | 1864.28 | 1865.83 | 4431.0 |
| 2013-12-09 03:00:00 | ES | Futures | 1865.57 | 1865.83 | 1862.99 | 1863.25 | 12086.0 |
| 2013-12-09 03:30:00 | ES | Futures | 1863.51 | 1864.8 | 1863.25 | 1864.54 | 9656.0 |
| 2013-12-09 04:00:00 | ES | Futures | 1864.54 | 1865.31 | 1863.51 | 1864.28 | 8175.0 |
| 2013-12-09 04:30:00 | ES | Futures | 1864.54 | 1865.05 | 1863.76 | 1864.02 | 10580.0 |
| 2013-12-09 05:00:00 | ES | Futures | 1864.02 | 1864.54 | 1862.99 | 1863.51 | 8822.0 |
| 2013-12-09 05:30:00 | ES | Futures | 1863.25 | 1863.76 | 1862.47 | 1863.51 | 6790.0 |
| 2013-12-09 06:00:00 | ES | Futures | 1863.51 | 1864.54 | 1862.22 | 1862.99 | 13362.0 |
| 2013-12-09 06:30:00 | ES | Futures | 1862.73 | 1863.51 | 1862.47 | 1862.99 | 9299.0 |
| 2013-12-09 07:00:00 | ES | Futures | 1862.99 | 1864.8 | 1862.47 | 1864.8 | 8419.0 |
| 2013-12-09 07:30:00 | ES | Futures | 1864.8 | 1864.8 | 1864.02 | 1864.54 | 5744.0 |
| 2013-12-09 08:00:00 | ES | Futures | 1864.54 | 1866.09 | 1863.76 | 1865.83 | 13814.0 |
| 2013-12-09 08:30:00 | ES | Futures | 1866.09 | 1866.34 | 1865.05 | 1865.31 | 10093.0 |
| 2013-12-09 09:00:00 | ES | Futures | 1865.31 | 1867.63 | 1864.8 | 1867.38 | 33476.0 |
| 2013-12-09 09:30:00 | ES | Futures | 1867.38 | 1869.18 | 1864.54 | 1868.67 | 159614.0 |
| 2013-12-09 10:00:00 | ES | Futures | 1868.92 | 1869.18 | 1864.8 | 1865.31 | 100424.0 |
| 2013-12-09 10:30:00 | ES | Futures | 1865.31 | 1867.38 | 1863.76 | 1866.34 | 72678.0 |
| 2013-12-09 11:00:00 | ES | Futures | 1866.34 | 1869.18 | 1866.09 | 1868.15 | 64597.0 |
| 2013-12-09 11:30:00 | ES | Futures | 1868.15 | 1868.67 | 1866.6 | 1867.12 | 46292.0 |
| 2013-12-09 12:00:00 | ES | Futures | 1867.12 | 1868.15 | 1865.83 | 1865.83 | 31269.0 |
| 2013-12-09 12:30:00 | ES | Futures | 1865.83 | 1867.63 | 1865.57 | 1866.86 | 24107.0 |
| 2013-12-09 13:00:00 | ES | Futures | 1866.86 | 1868.92 | 1866.09 | 1867.89 | 28654.0 |
| 2013-12-09 13:30:00 | ES | Futures | 1867.89 | 1868.67 | 1866.34 | 1866.6 | 30075.0 |
| 2013-12-09 14:00:00 | ES | Futures | 1866.34 | 1866.86 | 1864.8 | 1865.57 | 28509.0 |
| 2013-12-09 14:30:00 | ES | Futures | 1865.57 | 1867.38 | 1865.31 | 1865.83 | 31062.0 |
| 2013-12-09 15:00:00 | ES | Futures | 1865.83 | 1866.86 | 1864.02 | 1864.54 | 36732.0 |
| 2013-12-09 15:30:00 | ES | Futures | 1864.28 | 1866.34 | 1864.28 | 1866.09 | 92105.0 |
| 2013-12-09 16:00:00 | ES | Futures | 1866.09 | 1866.86 | 1865.31 | 1866.6 | 62307.0 |
| 2013-12-09 16:30:00 | ES | Futures | 1866.6 | 1866.86 | 1866.09 | 1866.34 | 4811.0 |
| 2013-12-09 17:00:00 | ES | Futures | 1866.34 | 1867.12 | 1865.57 | 1866.86 | 2669.0 |
| 2013-12-09 18:00:00 | ES | Futures | 1866.86 | 1868.15 | 1866.6 | 1867.63 | 2949.0 |
| 2013-12-09 18:30:00 | ES | Futures | 1867.63 | 1867.63 | 1866.86 | 1866.86 | 1121.0 |
| 2013-12-09 19:00:00 | ES | Futures | 1866.86 | 1867.63 | 1866.6 | 1867.63 | 1341.0 |
| 2013-12-09 19:30:00 | ES | Futures | 1867.63 | 1868.41 | 1867.38 | 1867.89 | 1554.0 |
| 2013-12-09 20:00:00 | ES | Futures | 1867.89 | 1868.15 | 1867.38 | 1868.15 | 1318.0 |
| 2013-12-09 20:30:00 | ES | Futures | 1868.15 | 1868.92 | 1867.63 | 1868.41 | 2078.0 |
| 2013-12-09 21:00:00 | ES | Futures | 1868.67 | 1868.67 | 1867.63 | 1867.89 | 1500.0 |
| 2013-12-09 21:30:00 | ES | Futures | 1867.89 | 1868.67 | 1867.89 | 1868.15 | 1119.0 |
| 2013-12-09 22:00:00 | ES | Futures | 1868.41 | 1868.67 | 1868.15 | 1868.15 | 1090.0 |
| 2013-12-09 22:30:00 | ES | Futures | 1868.15 | 1868.92 | 1867.89 | 1868.67 | 1047.0 |
| 2013-12-09 23:00:00 | ES | Futures | 1868.67 | 1868.92 | 1867.63 | 1868.15 | 1247.0 |
| 2013-12-09 23:30:00 | ES | Futures | 1867.89 | 1868.67 | 1867.89 | 1868.41 | 1177.0 |
| 2013-12-09 00:00:00 | NQ | Futures | 4079.42 | 4080.0 | 4078.83 | 4079.42 | 232.0 |
| 2013-12-09 00:30:00 | NQ | Futures | 4079.71 | 4080.29 | 4078.83 | 4080.0 | 166.0 |
| 2013-12-09 01:00:00 | NQ | Futures | 4079.71 | 4079.71 | 4078.83 | 4079.12 | 120.0 |
> showing 50 of 2,802 rows — these rows as CSV