PREVIEW / futures_30min / 2013-12-02
file: by_date/futures_30min/2013/2013-12-02.parquet size: 74 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-12-02 00:00:00 | ES | Futures | 1862.22 | 1862.99 | 1861.96 | 1862.47 | 1138.0 |
| 2013-12-02 00:30:00 | ES | Futures | 1862.47 | 1862.47 | 1861.96 | 1861.96 | 1188.0 |
| 2013-12-02 01:00:00 | ES | Futures | 1861.96 | 1862.22 | 1861.44 | 1861.96 | 1299.0 |
| 2013-12-02 01:30:00 | ES | Futures | 1861.96 | 1862.47 | 1861.96 | 1862.22 | 570.0 |
| 2013-12-02 02:00:00 | ES | Futures | 1862.22 | 1863.51 | 1862.22 | 1862.99 | 1985.0 |
| 2013-12-02 02:30:00 | ES | Futures | 1862.99 | 1864.02 | 1862.99 | 1863.51 | 1950.0 |
| 2013-12-02 03:00:00 | ES | Futures | 1863.76 | 1865.31 | 1861.18 | 1861.96 | 14168.0 |
| 2013-12-02 03:30:00 | ES | Futures | 1861.7 | 1862.22 | 1860.67 | 1860.93 | 6486.0 |
| 2013-12-02 04:00:00 | ES | Futures | 1861.18 | 1862.47 | 1860.93 | 1861.96 | 12548.0 |
| 2013-12-02 04:30:00 | ES | Futures | 1861.7 | 1862.22 | 1861.44 | 1861.7 | 6747.0 |
| 2013-12-02 05:00:00 | ES | Futures | 1861.44 | 1861.7 | 1859.12 | 1859.64 | 13529.0 |
| 2013-12-02 05:30:00 | ES | Futures | 1859.64 | 1860.67 | 1859.12 | 1860.67 | 7931.0 |
| 2013-12-02 06:00:00 | ES | Futures | 1860.41 | 1860.93 | 1860.15 | 1860.41 | 6755.0 |
| 2013-12-02 06:30:00 | ES | Futures | 1860.41 | 1861.7 | 1860.41 | 1860.67 | 6777.0 |
| 2013-12-02 07:00:00 | ES | Futures | 1860.67 | 1860.93 | 1859.38 | 1860.41 | 9662.0 |
| 2013-12-02 07:30:00 | ES | Futures | 1860.41 | 1862.73 | 1859.89 | 1862.73 | 11142.0 |
| 2013-12-02 08:00:00 | ES | Futures | 1862.47 | 1862.73 | 1861.96 | 1862.22 | 9301.0 |
| 2013-12-02 08:30:00 | ES | Futures | 1862.22 | 1862.47 | 1861.44 | 1861.96 | 9282.0 |
| 2013-12-02 09:00:00 | ES | Futures | 1861.96 | 1863.25 | 1861.44 | 1862.99 | 14917.0 |
| 2013-12-02 09:30:00 | ES | Futures | 1862.99 | 1864.54 | 1858.6 | 1859.89 | 147925.0 |
| 2013-12-02 10:00:00 | ES | Futures | 1859.89 | 1862.73 | 1858.35 | 1861.96 | 164581.0 |
| 2013-12-02 10:30:00 | ES | Futures | 1862.22 | 1862.73 | 1860.67 | 1862.47 | 86724.0 |
| 2013-12-02 11:00:00 | ES | Futures | 1862.47 | 1863.76 | 1861.96 | 1862.22 | 67411.0 |
| 2013-12-02 11:30:00 | ES | Futures | 1862.22 | 1865.05 | 1861.44 | 1864.54 | 66693.0 |
| 2013-12-02 12:00:00 | ES | Futures | 1864.28 | 1866.34 | 1864.02 | 1866.34 | 43096.0 |
| 2013-12-02 12:30:00 | ES | Futures | 1866.34 | 1866.6 | 1865.57 | 1865.83 | 32865.0 |
| 2013-12-02 13:00:00 | ES | Futures | 1865.83 | 1866.09 | 1864.02 | 1864.28 | 39683.0 |
| 2013-12-02 13:30:00 | ES | Futures | 1864.28 | 1864.54 | 1862.73 | 1863.76 | 44404.0 |
| 2013-12-02 14:00:00 | ES | Futures | 1863.51 | 1864.02 | 1860.15 | 1861.44 | 60166.0 |
| 2013-12-02 14:30:00 | ES | Futures | 1861.7 | 1862.22 | 1859.64 | 1861.7 | 54283.0 |
| 2013-12-02 15:00:00 | ES | Futures | 1861.7 | 1862.22 | 1858.35 | 1858.6 | 46894.0 |
| 2013-12-02 15:30:00 | ES | Futures | 1858.6 | 1858.86 | 1854.22 | 1857.06 | 213909.0 |
| 2013-12-02 16:00:00 | ES | Futures | 1857.06 | 1857.57 | 1856.28 | 1857.57 | 73148.0 |
| 2013-12-02 16:30:00 | ES | Futures | 1857.06 | 1857.57 | 1857.06 | 1857.32 | 4013.0 |
| 2013-12-02 17:00:00 | ES | Futures | 1857.06 | 1857.57 | 1857.06 | 1857.06 | 2884.0 |
| 2013-12-02 18:00:00 | ES | Futures | 1857.57 | 1858.86 | 1856.54 | 1858.35 | 6370.0 |
| 2013-12-02 18:30:00 | ES | Futures | 1858.6 | 1858.86 | 1857.57 | 1858.09 | 1529.0 |
| 2013-12-02 19:00:00 | ES | Futures | 1858.09 | 1858.35 | 1857.06 | 1857.83 | 3011.0 |
| 2013-12-02 19:30:00 | ES | Futures | 1857.83 | 1858.86 | 1857.32 | 1858.6 | 1793.0 |
| 2013-12-02 20:00:00 | ES | Futures | 1858.6 | 1859.12 | 1858.09 | 1858.6 | 2942.0 |
| 2013-12-02 20:30:00 | ES | Futures | 1858.86 | 1858.86 | 1857.83 | 1858.35 | 1710.0 |
| 2013-12-02 21:00:00 | ES | Futures | 1858.35 | 1858.35 | 1857.83 | 1858.09 | 1252.0 |
| 2013-12-02 21:30:00 | ES | Futures | 1858.09 | 1858.35 | 1857.32 | 1857.83 | 984.0 |
| 2013-12-02 22:00:00 | ES | Futures | 1857.83 | 1857.83 | 1857.32 | 1857.57 | 688.0 |
| 2013-12-02 22:30:00 | ES | Futures | 1857.32 | 1858.35 | 1857.32 | 1858.09 | 1440.0 |
| 2013-12-02 23:00:00 | ES | Futures | 1858.09 | 1858.09 | 1857.06 | 1857.32 | 1773.0 |
| 2013-12-02 23:30:00 | ES | Futures | 1857.32 | 1857.83 | 1857.06 | 1857.32 | 1397.0 |
| 2013-12-02 00:00:00 | NQ | Futures | 4057.34 | 4058.79 | 4057.05 | 4057.63 | 156.0 |
| 2013-12-02 00:30:00 | NQ | Futures | 4057.63 | 4058.5 | 4057.34 | 4057.34 | 173.0 |
| 2013-12-02 01:00:00 | NQ | Futures | 4057.34 | 4057.92 | 4056.76 | 4057.63 | 153.0 |
> showing 50 of 2,797 rows — these rows as CSV