PREVIEW / futures_30min / 2013-12-19
file: by_date/futures_30min/2013/2013-12-19.parquet size: 76 KB rows: 2,916
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-19 00:00:00 | ES | Futures | 1863.08 | 1864.63 | 1863.08 | 1864.11 | 6298.0 |
| 2013-12-19 00:30:00 | ES | Futures | 1864.37 | 1864.37 | 1863.08 | 1863.08 | 1426.0 |
| 2013-12-19 01:00:00 | ES | Futures | 1863.08 | 1864.11 | 1861.53 | 1861.79 | 3926.0 |
| 2013-12-19 01:30:00 | ES | Futures | 1861.79 | 1862.56 | 1861.53 | 1862.56 | 1756.0 |
| 2013-12-19 02:00:00 | ES | Futures | 1862.56 | 1862.82 | 1861.53 | 1861.53 | 2965.0 |
| 2013-12-19 02:30:00 | ES | Futures | 1861.79 | 1862.04 | 1861.27 | 1861.53 | 3852.0 |
| 2013-12-19 03:00:00 | ES | Futures | 1861.53 | 1864.89 | 1861.27 | 1864.63 | 18707.0 |
| 2013-12-19 03:30:00 | ES | Futures | 1864.63 | 1866.44 | 1864.63 | 1865.92 | 14397.0 |
| 2013-12-19 04:00:00 | ES | Futures | 1865.92 | 1866.18 | 1864.37 | 1865.15 | 7332.0 |
| 2013-12-19 04:30:00 | ES | Futures | 1865.15 | 1865.67 | 1864.89 | 1865.15 | 5212.0 |
| 2013-12-19 05:00:00 | ES | Futures | 1865.15 | 1865.15 | 1863.86 | 1864.11 | 5675.0 |
| 2013-12-19 05:30:00 | ES | Futures | 1863.86 | 1865.41 | 1863.6 | 1865.15 | 5662.0 |
| 2013-12-19 06:00:00 | ES | Futures | 1865.15 | 1865.67 | 1864.37 | 1865.67 | 4685.0 |
| 2013-12-19 06:30:00 | ES | Futures | 1865.67 | 1866.96 | 1865.15 | 1865.67 | 7924.0 |
| 2013-12-19 07:00:00 | ES | Futures | 1865.67 | 1866.7 | 1865.15 | 1866.7 | 7389.0 |
| 2013-12-19 07:30:00 | ES | Futures | 1866.7 | 1867.48 | 1864.37 | 1864.89 | 11868.0 |
| 2013-12-19 08:00:00 | ES | Futures | 1864.89 | 1865.92 | 1864.37 | 1864.63 | 9251.0 |
| 2013-12-19 08:30:00 | ES | Futures | 1864.63 | 1865.67 | 1857.65 | 1857.91 | 56075.0 |
| 2013-12-19 09:00:00 | ES | Futures | 1857.91 | 1862.56 | 1857.13 | 1862.3 | 43091.0 |
| 2013-12-19 09:30:00 | ES | Futures | 1862.04 | 1864.63 | 1860.23 | 1862.04 | 164371.0 |
| 2013-12-19 10:00:00 | ES | Futures | 1861.79 | 1863.34 | 1857.13 | 1861.01 | 134362.0 |
| 2013-12-19 10:30:00 | ES | Futures | 1861.01 | 1863.86 | 1860.23 | 1862.3 | 87360.0 |
| 2013-12-19 11:00:00 | ES | Futures | 1862.56 | 1862.82 | 1860.75 | 1862.82 | 57062.0 |
| 2013-12-19 11:30:00 | ES | Futures | 1862.56 | 1864.89 | 1862.3 | 1864.11 | 60571.0 |
| 2013-12-19 12:00:00 | ES | Futures | 1864.11 | 1865.67 | 1862.56 | 1864.89 | 58429.0 |
| 2013-12-19 12:30:00 | ES | Futures | 1864.89 | 1865.15 | 1863.86 | 1864.63 | 28612.0 |
| 2013-12-19 13:00:00 | ES | Futures | 1864.63 | 1866.44 | 1863.34 | 1865.92 | 49672.0 |
| 2013-12-19 13:30:00 | ES | Futures | 1865.92 | 1866.7 | 1864.63 | 1865.92 | 36102.0 |
| 2013-12-19 14:00:00 | ES | Futures | 1865.67 | 1866.44 | 1863.6 | 1863.6 | 36413.0 |
| 2013-12-19 14:30:00 | ES | Futures | 1863.6 | 1865.92 | 1863.34 | 1865.41 | 37395.0 |
| 2013-12-19 15:00:00 | ES | Futures | 1865.15 | 1866.96 | 1864.89 | 1865.15 | 49633.0 |
| 2013-12-19 15:30:00 | ES | Futures | 1864.89 | 1867.48 | 1863.86 | 1865.41 | 154356.0 |
| 2013-12-19 16:00:00 | ES | Futures | 1865.67 | 1865.92 | 1863.86 | 1864.37 | 66351.0 |
| 2013-12-19 16:30:00 | ES | Futures | 1864.37 | 1864.63 | 1863.6 | 1864.11 | 8196.0 |
| 2013-12-19 17:00:00 | ES | Futures | 1863.86 | 1864.89 | 1863.86 | 1864.89 | 1465.0 |
| 2013-12-19 18:00:00 | ES | Futures | 1864.89 | 1866.44 | 1864.89 | 1865.15 | 4053.0 |
| 2013-12-19 18:30:00 | ES | Futures | 1865.15 | 1865.67 | 1864.89 | 1864.89 | 1566.0 |
| 2013-12-19 19:00:00 | ES | Futures | 1865.15 | 1865.92 | 1864.89 | 1865.92 | 1612.0 |
| 2013-12-19 19:30:00 | ES | Futures | 1865.67 | 1866.7 | 1865.67 | 1866.18 | 1230.0 |
| 2013-12-19 20:00:00 | ES | Futures | 1865.92 | 1866.96 | 1865.67 | 1866.44 | 4156.0 |
| 2013-12-19 20:30:00 | ES | Futures | 1866.44 | 1867.22 | 1866.44 | 1867.22 | 1228.0 |
| 2013-12-19 21:00:00 | ES | Futures | 1866.96 | 1868.77 | 1866.96 | 1867.74 | 3117.0 |
| 2013-12-19 21:30:00 | ES | Futures | 1867.74 | 1868.51 | 1867.22 | 1867.22 | 959.0 |
| 2013-12-19 22:00:00 | ES | Futures | 1867.22 | 1868.51 | 1867.22 | 1867.48 | 1967.0 |
| 2013-12-19 22:30:00 | ES | Futures | 1867.74 | 1867.74 | 1866.96 | 1866.96 | 911.0 |
| 2013-12-19 23:00:00 | ES | Futures | 1866.96 | 1867.48 | 1866.96 | 1867.22 | 833.0 |
| 2013-12-19 23:30:00 | ES | Futures | 1867.22 | 1867.74 | 1866.96 | 1867.74 | 1256.0 |
| 2013-12-19 00:00:00 | NQ | Futures | 4072.49 | 4075.11 | 4072.2 | 4073.95 | 384.0 |
| 2013-12-19 00:30:00 | NQ | Futures | 4073.66 | 4073.66 | 4071.33 | 4072.2 | 152.0 |
| 2013-12-19 01:00:00 | NQ | Futures | 4072.49 | 4073.07 | 4069.3 | 4069.59 | 253.0 |
> showing 50 of 2,916 rows — these rows as CSV