PREVIEW / futures_30min / 2013-11-27
file: by_date/futures_30min/2013/2013-11-27.parquet size: 70 KB rows: 2,677
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-27 00:00:00 | ES | Futures | 1859.38 | 1860.15 | 1859.38 | 1859.64 | 2000.0 |
| 2013-11-27 00:30:00 | ES | Futures | 1859.89 | 1860.15 | 1858.86 | 1859.38 | 1777.0 |
| 2013-11-27 01:00:00 | ES | Futures | 1859.38 | 1859.89 | 1858.86 | 1858.86 | 1682.0 |
| 2013-11-27 01:30:00 | ES | Futures | 1858.86 | 1859.89 | 1858.86 | 1859.38 | 793.0 |
| 2013-11-27 02:00:00 | ES | Futures | 1859.64 | 1860.67 | 1859.64 | 1860.15 | 2759.0 |
| 2013-11-27 02:30:00 | ES | Futures | 1860.15 | 1860.67 | 1859.89 | 1859.89 | 1804.0 |
| 2013-11-27 03:00:00 | ES | Futures | 1859.89 | 1860.67 | 1859.38 | 1860.41 | 5380.0 |
| 2013-11-27 03:30:00 | ES | Futures | 1860.15 | 1860.41 | 1858.86 | 1859.64 | 5188.0 |
| 2013-11-27 04:00:00 | ES | Futures | 1859.89 | 1862.22 | 1859.64 | 1861.18 | 9381.0 |
| 2013-11-27 04:30:00 | ES | Futures | 1861.18 | 1861.96 | 1860.93 | 1861.96 | 3046.0 |
| 2013-11-27 05:00:00 | ES | Futures | 1861.7 | 1861.96 | 1860.67 | 1861.44 | 3940.0 |
| 2013-11-27 05:30:00 | ES | Futures | 1861.44 | 1861.7 | 1860.67 | 1860.93 | 8963.0 |
| 2013-11-27 06:00:00 | ES | Futures | 1861.18 | 1861.44 | 1860.15 | 1860.67 | 10566.0 |
| 2013-11-27 06:30:00 | ES | Futures | 1860.67 | 1861.96 | 1860.67 | 1861.7 | 10096.0 |
| 2013-11-27 07:00:00 | ES | Futures | 1861.7 | 1861.96 | 1861.18 | 1861.18 | 7832.0 |
| 2013-11-27 07:30:00 | ES | Futures | 1861.18 | 1861.44 | 1860.15 | 1860.67 | 12058.0 |
| 2013-11-27 08:00:00 | ES | Futures | 1860.93 | 1861.44 | 1860.41 | 1860.67 | 8233.0 |
| 2013-11-27 08:30:00 | ES | Futures | 1860.93 | 1861.96 | 1859.64 | 1861.7 | 19038.0 |
| 2013-11-27 09:00:00 | ES | Futures | 1861.7 | 1861.96 | 1860.93 | 1860.93 | 20340.0 |
| 2013-11-27 09:30:00 | ES | Futures | 1861.18 | 1865.05 | 1859.89 | 1863.76 | 112704.0 |
| 2013-11-27 10:00:00 | ES | Futures | 1863.76 | 1864.28 | 1862.47 | 1862.73 | 51726.0 |
| 2013-11-27 10:30:00 | ES | Futures | 1862.99 | 1864.8 | 1862.73 | 1863.25 | 58683.0 |
| 2013-11-27 11:00:00 | ES | Futures | 1862.99 | 1864.8 | 1862.99 | 1864.28 | 38578.0 |
| 2013-11-27 11:30:00 | ES | Futures | 1864.28 | 1864.8 | 1862.73 | 1863.25 | 36943.0 |
| 2013-11-27 12:00:00 | ES | Futures | 1863.25 | 1863.25 | 1861.7 | 1862.47 | 36415.0 |
| 2013-11-27 12:30:00 | ES | Futures | 1862.47 | 1862.47 | 1858.86 | 1859.12 | 42178.0 |
| 2013-11-27 13:00:00 | ES | Futures | 1859.12 | 1860.15 | 1858.6 | 1860.15 | 31923.0 |
| 2013-11-27 13:30:00 | ES | Futures | 1860.15 | 1861.7 | 1859.89 | 1860.93 | 29891.0 |
| 2013-11-27 14:00:00 | ES | Futures | 1860.93 | 1861.7 | 1860.67 | 1861.44 | 17155.0 |
| 2013-11-27 14:30:00 | ES | Futures | 1861.44 | 1864.02 | 1861.44 | 1863.51 | 31252.0 |
| 2013-11-27 15:00:00 | ES | Futures | 1863.51 | 1864.28 | 1862.73 | 1864.02 | 33367.0 |
| 2013-11-27 15:30:00 | ES | Futures | 1863.76 | 1864.54 | 1862.73 | 1863.51 | 92161.0 |
| 2013-11-27 16:00:00 | ES | Futures | 1863.51 | 1863.76 | 1861.44 | 1861.7 | 57225.0 |
| 2013-11-27 16:30:00 | ES | Futures | 1861.7 | 1862.22 | 1861.44 | 1861.96 | 3375.0 |
| 2013-11-27 17:00:00 | ES | Futures | 1861.96 | 1862.22 | 1861.44 | 1861.7 | 1185.0 |
| 2013-11-27 18:00:00 | ES | Futures | 1861.96 | 1865.05 | 1861.7 | 1864.28 | 3659.0 |
| 2013-11-27 18:30:00 | ES | Futures | 1864.28 | 1864.8 | 1863.51 | 1863.76 | 843.0 |
| 2013-11-27 19:00:00 | ES | Futures | 1863.51 | 1863.76 | 1863.25 | 1863.25 | 1392.0 |
| 2013-11-27 19:30:00 | ES | Futures | 1863.51 | 1863.76 | 1862.99 | 1863.25 | 959.0 |
| 2013-11-27 20:00:00 | ES | Futures | 1863.25 | 1863.51 | 1862.99 | 1863.25 | 782.0 |
| 2013-11-27 20:30:00 | ES | Futures | 1862.99 | 1864.02 | 1862.99 | 1863.76 | 1424.0 |
| 2013-11-27 21:00:00 | ES | Futures | 1863.51 | 1864.28 | 1863.51 | 1863.51 | 1126.0 |
| 2013-11-27 21:30:00 | ES | Futures | 1863.51 | 1863.76 | 1863.51 | 1863.76 | 506.0 |
| 2013-11-27 22:00:00 | ES | Futures | 1863.51 | 1863.76 | 1863.25 | 1863.25 | 489.0 |
| 2013-11-27 22:30:00 | ES | Futures | 1863.25 | 1863.76 | 1862.99 | 1862.99 | 627.0 |
| 2013-11-27 23:00:00 | ES | Futures | 1863.25 | 1863.76 | 1862.99 | 1863.25 | 955.0 |
| 2013-11-27 23:30:00 | ES | Futures | 1863.51 | 1863.76 | 1863.51 | 1863.51 | 444.0 |
| 2013-11-27 00:00:00 | NQ | Futures | 4006.23 | 4007.39 | 4005.94 | 4006.52 | 319.0 |
| 2013-11-27 00:30:00 | NQ | Futures | 4006.52 | 4007.39 | 4005.35 | 4006.23 | 236.0 |
| 2013-11-27 01:00:00 | NQ | Futures | 4006.23 | 4006.81 | 4005.65 | 4005.94 | 91.0 |
> showing 50 of 2,677 rows — these rows as CSV