PREVIEW / futures_30min / 2013-11-26
file: by_date/futures_30min/2013/2013-11-26.parquet size: 71 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-11-26 00:00:00 | ES | Futures | 1862.22 | 1862.73 | 1861.7 | 1862.73 | 1318.0 |
| 2013-11-26 00:30:00 | ES | Futures | 1862.47 | 1862.99 | 1862.47 | 1862.73 | 1493.0 |
| 2013-11-26 01:00:00 | ES | Futures | 1862.47 | 1862.99 | 1862.47 | 1862.73 | 1197.0 |
| 2013-11-26 01:30:00 | ES | Futures | 1862.73 | 1862.99 | 1862.47 | 1862.47 | 1242.0 |
| 2013-11-26 02:00:00 | ES | Futures | 1862.47 | 1862.99 | 1861.96 | 1862.22 | 2074.0 |
| 2013-11-26 02:30:00 | ES | Futures | 1862.47 | 1862.47 | 1860.41 | 1861.44 | 5061.0 |
| 2013-11-26 03:00:00 | ES | Futures | 1861.44 | 1862.73 | 1860.93 | 1862.22 | 5918.0 |
| 2013-11-26 03:30:00 | ES | Futures | 1862.22 | 1862.22 | 1860.67 | 1860.93 | 8950.0 |
| 2013-11-26 04:00:00 | ES | Futures | 1861.18 | 1861.44 | 1859.89 | 1860.15 | 7919.0 |
| 2013-11-26 04:30:00 | ES | Futures | 1860.15 | 1860.15 | 1858.35 | 1858.6 | 11244.0 |
| 2013-11-26 05:00:00 | ES | Futures | 1858.6 | 1859.38 | 1858.35 | 1859.12 | 5399.0 |
| 2013-11-26 05:30:00 | ES | Futures | 1858.86 | 1859.38 | 1858.6 | 1859.12 | 3089.0 |
| 2013-11-26 06:00:00 | ES | Futures | 1858.86 | 1859.38 | 1858.6 | 1858.86 | 8302.0 |
| 2013-11-26 06:30:00 | ES | Futures | 1858.6 | 1859.38 | 1858.35 | 1859.38 | 8024.0 |
| 2013-11-26 07:00:00 | ES | Futures | 1859.38 | 1861.44 | 1859.12 | 1860.93 | 11025.0 |
| 2013-11-26 07:30:00 | ES | Futures | 1860.93 | 1861.7 | 1860.41 | 1860.93 | 9180.0 |
| 2013-11-26 08:00:00 | ES | Futures | 1860.93 | 1861.44 | 1859.89 | 1860.67 | 13224.0 |
| 2013-11-26 08:30:00 | ES | Futures | 1860.67 | 1861.18 | 1859.12 | 1859.64 | 15606.0 |
| 2013-11-26 09:00:00 | ES | Futures | 1859.38 | 1859.89 | 1858.6 | 1859.38 | 17334.0 |
| 2013-11-26 09:30:00 | ES | Futures | 1859.64 | 1861.96 | 1858.6 | 1859.64 | 101276.0 |
| 2013-11-26 10:00:00 | ES | Futures | 1859.64 | 1860.93 | 1856.03 | 1860.67 | 127228.0 |
| 2013-11-26 10:30:00 | ES | Futures | 1860.67 | 1860.93 | 1858.6 | 1859.89 | 48980.0 |
| 2013-11-26 11:00:00 | ES | Futures | 1859.64 | 1861.44 | 1859.38 | 1859.64 | 60406.0 |
| 2013-11-26 11:30:00 | ES | Futures | 1859.64 | 1860.15 | 1858.86 | 1858.86 | 63868.0 |
| 2013-11-26 12:00:00 | ES | Futures | 1858.86 | 1862.99 | 1858.86 | 1862.47 | 53502.0 |
| 2013-11-26 12:30:00 | ES | Futures | 1862.22 | 1862.99 | 1861.18 | 1861.96 | 44312.0 |
| 2013-11-26 13:00:00 | ES | Futures | 1861.96 | 1862.47 | 1861.18 | 1861.96 | 23203.0 |
| 2013-11-26 13:30:00 | ES | Futures | 1862.22 | 1864.02 | 1861.96 | 1863.51 | 47225.0 |
| 2013-11-26 14:00:00 | ES | Futures | 1863.76 | 1863.76 | 1861.7 | 1862.99 | 37125.0 |
| 2013-11-26 14:30:00 | ES | Futures | 1862.99 | 1864.28 | 1862.73 | 1863.25 | 32514.0 |
| 2013-11-26 15:00:00 | ES | Futures | 1863.25 | 1864.54 | 1862.73 | 1863.76 | 44303.0 |
| 2013-11-26 15:30:00 | ES | Futures | 1863.76 | 1864.28 | 1858.6 | 1859.38 | 146472.0 |
| 2013-11-26 16:00:00 | ES | Futures | 1859.38 | 1860.15 | 1858.6 | 1859.38 | 77703.0 |
| 2013-11-26 16:30:00 | ES | Futures | 1859.38 | 1860.15 | 1859.12 | 1860.15 | 7614.0 |
| 2013-11-26 17:00:00 | ES | Futures | 1860.15 | 1860.15 | 1859.38 | 1859.38 | 2015.0 |
| 2013-11-26 18:00:00 | ES | Futures | 1859.38 | 1859.38 | 1858.6 | 1858.86 | 2508.0 |
| 2013-11-26 18:30:00 | ES | Futures | 1858.86 | 1859.12 | 1858.6 | 1859.12 | 1124.0 |
| 2013-11-26 19:00:00 | ES | Futures | 1858.86 | 1859.38 | 1858.6 | 1859.12 | 1048.0 |
| 2013-11-26 19:30:00 | ES | Futures | 1859.12 | 1859.89 | 1858.86 | 1859.64 | 1345.0 |
| 2013-11-26 20:00:00 | ES | Futures | 1859.64 | 1860.67 | 1859.38 | 1859.89 | 2461.0 |
| 2013-11-26 20:30:00 | ES | Futures | 1859.89 | 1860.41 | 1859.38 | 1859.64 | 1441.0 |
| 2013-11-26 21:00:00 | ES | Futures | 1859.38 | 1859.64 | 1858.86 | 1858.86 | 1306.0 |
| 2013-11-26 21:30:00 | ES | Futures | 1858.86 | 1859.12 | 1858.86 | 1858.86 | 594.0 |
| 2013-11-26 22:00:00 | ES | Futures | 1858.86 | 1859.89 | 1858.6 | 1859.12 | 2007.0 |
| 2013-11-26 22:30:00 | ES | Futures | 1859.12 | 1860.41 | 1858.86 | 1859.12 | 1692.0 |
| 2013-11-26 23:00:00 | ES | Futures | 1859.38 | 1859.64 | 1859.38 | 1859.64 | 641.0 |
| 2013-11-26 23:30:00 | ES | Futures | 1859.38 | 1859.64 | 1859.38 | 1859.64 | 101.0 |
| 2013-11-26 00:00:00 | NQ | Futures | 3989.38 | 3989.96 | 3988.8 | 3989.67 | 248.0 |
| 2013-11-26 00:30:00 | NQ | Futures | 3989.67 | 3990.25 | 3989.67 | 3989.96 | 215.0 |
| 2013-11-26 01:00:00 | NQ | Futures | 3989.96 | 3989.96 | 3989.67 | 3989.67 | 56.0 |
> showing 50 of 2,797 rows — these rows as CSV