PREVIEW / futures_30min / 2013-11-25
file: by_date/futures_30min/2013/2013-11-25.parquet size: 71 KB rows: 2,767
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-25 00:00:00 | ES | Futures | 1862.99 | 1863.51 | 1862.99 | 1863.51 | 1287.0 |
| 2013-11-25 00:30:00 | ES | Futures | 1863.25 | 1863.76 | 1863.25 | 1863.76 | 497.0 |
| 2013-11-25 01:00:00 | ES | Futures | 1863.76 | 1863.76 | 1862.99 | 1862.99 | 1000.0 |
| 2013-11-25 01:30:00 | ES | Futures | 1863.25 | 1864.28 | 1862.99 | 1863.51 | 1825.0 |
| 2013-11-25 02:00:00 | ES | Futures | 1863.51 | 1865.05 | 1863.51 | 1864.54 | 3417.0 |
| 2013-11-25 02:30:00 | ES | Futures | 1864.54 | 1864.8 | 1863.25 | 1863.51 | 2073.0 |
| 2013-11-25 03:00:00 | ES | Futures | 1863.51 | 1864.54 | 1862.73 | 1864.28 | 7624.0 |
| 2013-11-25 03:30:00 | ES | Futures | 1864.28 | 1865.57 | 1863.76 | 1864.28 | 22782.0 |
| 2013-11-25 04:00:00 | ES | Futures | 1864.28 | 1864.54 | 1863.25 | 1864.54 | 12666.0 |
| 2013-11-25 04:30:00 | ES | Futures | 1864.54 | 1865.05 | 1863.76 | 1864.28 | 9823.0 |
| 2013-11-25 05:00:00 | ES | Futures | 1864.02 | 1864.28 | 1863.25 | 1863.76 | 8171.0 |
| 2013-11-25 05:30:00 | ES | Futures | 1864.02 | 1865.05 | 1863.51 | 1864.8 | 7722.0 |
| 2013-11-25 06:00:00 | ES | Futures | 1864.8 | 1865.05 | 1864.02 | 1864.54 | 10937.0 |
| 2013-11-25 06:30:00 | ES | Futures | 1864.54 | 1865.57 | 1864.28 | 1865.31 | 9237.0 |
| 2013-11-25 07:00:00 | ES | Futures | 1865.31 | 1865.31 | 1864.28 | 1864.28 | 7377.0 |
| 2013-11-25 07:30:00 | ES | Futures | 1864.28 | 1865.05 | 1864.02 | 1864.8 | 8735.0 |
| 2013-11-25 08:00:00 | ES | Futures | 1864.54 | 1865.57 | 1864.54 | 1865.05 | 12144.0 |
| 2013-11-25 08:30:00 | ES | Futures | 1865.05 | 1865.31 | 1864.28 | 1864.54 | 15497.0 |
| 2013-11-25 09:00:00 | ES | Futures | 1864.28 | 1865.05 | 1863.51 | 1863.76 | 21490.0 |
| 2013-11-25 09:30:00 | ES | Futures | 1863.76 | 1864.28 | 1860.67 | 1860.93 | 121068.0 |
| 2013-11-25 10:00:00 | ES | Futures | 1861.18 | 1861.7 | 1859.64 | 1860.67 | 73057.0 |
| 2013-11-25 10:30:00 | ES | Futures | 1860.41 | 1862.73 | 1859.64 | 1861.18 | 58956.0 |
| 2013-11-25 11:00:00 | ES | Futures | 1861.18 | 1862.22 | 1860.67 | 1861.7 | 47757.0 |
| 2013-11-25 11:30:00 | ES | Futures | 1861.96 | 1862.73 | 1860.93 | 1861.7 | 53293.0 |
| 2013-11-25 12:00:00 | ES | Futures | 1861.44 | 1862.47 | 1860.93 | 1862.22 | 36494.0 |
| 2013-11-25 12:30:00 | ES | Futures | 1862.22 | 1862.22 | 1860.93 | 1861.18 | 39182.0 |
| 2013-11-25 13:00:00 | ES | Futures | 1861.18 | 1861.44 | 1860.41 | 1861.18 | 39779.0 |
| 2013-11-25 13:30:00 | ES | Futures | 1861.18 | 1862.73 | 1860.93 | 1862.47 | 21009.0 |
| 2013-11-25 14:00:00 | ES | Futures | 1862.47 | 1863.25 | 1862.22 | 1862.73 | 35118.0 |
| 2013-11-25 14:30:00 | ES | Futures | 1862.73 | 1862.99 | 1861.44 | 1861.44 | 26787.0 |
| 2013-11-25 15:00:00 | ES | Futures | 1861.44 | 1861.7 | 1857.06 | 1858.35 | 106806.0 |
| 2013-11-25 15:30:00 | ES | Futures | 1858.35 | 1859.12 | 1855.77 | 1858.86 | 149636.0 |
| 2013-11-25 16:00:00 | ES | Futures | 1859.12 | 1860.15 | 1858.86 | 1859.64 | 69206.0 |
| 2013-11-25 16:30:00 | ES | Futures | 1859.38 | 1859.64 | 1858.86 | 1859.38 | 6950.0 |
| 2013-11-25 17:00:00 | ES | Futures | 1859.64 | 1859.64 | 1858.6 | 1858.86 | 2174.0 |
| 2013-11-25 18:00:00 | ES | Futures | 1858.6 | 1859.38 | 1858.35 | 1859.38 | 2740.0 |
| 2013-11-25 18:30:00 | ES | Futures | 1859.38 | 1859.89 | 1859.12 | 1859.38 | 1195.0 |
| 2013-11-25 19:00:00 | ES | Futures | 1859.64 | 1859.89 | 1859.12 | 1859.38 | 1100.0 |
| 2013-11-25 19:30:00 | ES | Futures | 1859.38 | 1861.18 | 1859.38 | 1860.93 | 2315.0 |
| 2013-11-25 20:00:00 | ES | Futures | 1860.67 | 1861.96 | 1860.41 | 1861.7 | 3227.0 |
| 2013-11-25 20:30:00 | ES | Futures | 1861.7 | 1863.25 | 1861.7 | 1862.47 | 3651.0 |
| 2013-11-25 21:00:00 | ES | Futures | 1862.47 | 1862.73 | 1861.7 | 1862.22 | 883.0 |
| 2013-11-25 21:30:00 | ES | Futures | 1862.22 | 1862.22 | 1860.93 | 1861.18 | 1648.0 |
| 2013-11-25 22:00:00 | ES | Futures | 1861.18 | 1861.44 | 1860.93 | 1861.44 | 696.0 |
| 2013-11-25 22:30:00 | ES | Futures | 1861.44 | 1862.47 | 1860.93 | 1861.96 | 1460.0 |
| 2013-11-25 23:00:00 | ES | Futures | 1862.22 | 1862.22 | 1861.96 | 1862.22 | 398.0 |
| 2013-11-25 23:30:00 | ES | Futures | 1862.22 | 1862.47 | 1861.96 | 1862.22 | 330.0 |
| 2013-11-25 00:00:00 | NQ | Futures | 3984.44 | 3985.02 | 3983.86 | 3985.02 | 155.0 |
| 2013-11-25 00:30:00 | NQ | Futures | 3985.31 | 3985.31 | 3984.44 | 3985.31 | 43.0 |
| 2013-11-25 01:00:00 | NQ | Futures | 3985.31 | 3985.31 | 3984.15 | 3984.44 | 207.0 |
> showing 50 of 2,767 rows — these rows as CSV