PREVIEW / futures_1hour / 2013-12-02
file: by_date/futures_1hour/2013/2013-12-02.parquet size: 48 KB rows: 1,506
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 | 1861.96 | 2326.0 |
| 2013-12-02 01:00:00 | ES | Futures | 1861.96 | 1862.47 | 1861.44 | 1862.22 | 1869.0 |
| 2013-12-02 02:00:00 | ES | Futures | 1862.22 | 1864.02 | 1862.22 | 1863.51 | 3935.0 |
| 2013-12-02 03:00:00 | ES | Futures | 1863.76 | 1865.31 | 1860.67 | 1860.93 | 20654.0 |
| 2013-12-02 04:00:00 | ES | Futures | 1861.18 | 1862.47 | 1860.93 | 1861.7 | 19295.0 |
| 2013-12-02 05:00:00 | ES | Futures | 1861.44 | 1861.7 | 1859.12 | 1860.67 | 21460.0 |
| 2013-12-02 06:00:00 | ES | Futures | 1860.41 | 1861.7 | 1860.15 | 1860.67 | 13532.0 |
| 2013-12-02 07:00:00 | ES | Futures | 1860.67 | 1862.73 | 1859.38 | 1862.73 | 20804.0 |
| 2013-12-02 08:00:00 | ES | Futures | 1862.47 | 1862.73 | 1861.44 | 1861.96 | 18583.0 |
| 2013-12-02 09:00:00 | ES | Futures | 1861.96 | 1864.54 | 1858.6 | 1859.89 | 162842.0 |
| 2013-12-02 10:00:00 | ES | Futures | 1859.89 | 1862.73 | 1858.35 | 1862.47 | 251305.0 |
| 2013-12-02 11:00:00 | ES | Futures | 1862.47 | 1865.05 | 1861.44 | 1864.54 | 134104.0 |
| 2013-12-02 12:00:00 | ES | Futures | 1864.28 | 1866.6 | 1864.02 | 1865.83 | 75961.0 |
| 2013-12-02 13:00:00 | ES | Futures | 1865.83 | 1866.09 | 1862.73 | 1863.76 | 84087.0 |
| 2013-12-02 14:00:00 | ES | Futures | 1863.51 | 1864.02 | 1859.64 | 1861.7 | 114449.0 |
| 2013-12-02 15:00:00 | ES | Futures | 1861.7 | 1862.22 | 1854.22 | 1857.06 | 260803.0 |
| 2013-12-02 16:00:00 | ES | Futures | 1857.06 | 1857.57 | 1856.28 | 1857.32 | 77161.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.09 | 7899.0 |
| 2013-12-02 19:00:00 | ES | Futures | 1858.09 | 1858.86 | 1857.06 | 1858.6 | 4804.0 |
| 2013-12-02 20:00:00 | ES | Futures | 1858.6 | 1859.12 | 1857.83 | 1858.35 | 4652.0 |
| 2013-12-02 21:00:00 | ES | Futures | 1858.35 | 1858.35 | 1857.32 | 1857.83 | 2236.0 |
| 2013-12-02 22:00:00 | ES | Futures | 1857.83 | 1858.35 | 1857.32 | 1858.09 | 2128.0 |
| 2013-12-02 23:00:00 | ES | Futures | 1858.09 | 1858.09 | 1857.06 | 1857.32 | 3170.0 |
| 2013-12-02 00:00:00 | NQ | Futures | 4057.34 | 4058.79 | 4057.05 | 4057.34 | 329.0 |
| 2013-12-02 01:00:00 | NQ | Futures | 4057.34 | 4058.5 | 4056.76 | 4058.5 | 246.0 |
| 2013-12-02 02:00:00 | NQ | Futures | 4058.79 | 4061.12 | 4058.21 | 4060.54 | 676.0 |
| 2013-12-02 03:00:00 | NQ | Futures | 4060.83 | 4063.15 | 4053.57 | 4055.31 | 4694.0 |
| 2013-12-02 04:00:00 | NQ | Futures | 4055.31 | 4057.05 | 4054.44 | 4056.47 | 4686.0 |
| 2013-12-02 05:00:00 | NQ | Futures | 4056.76 | 4056.76 | 4051.24 | 4054.73 | 3469.0 |
| 2013-12-02 06:00:00 | NQ | Futures | 4054.73 | 4059.38 | 4052.7 | 4056.76 | 2326.0 |
| 2013-12-02 07:00:00 | NQ | Futures | 4056.76 | 4060.25 | 4054.44 | 4059.96 | 2347.0 |
| 2013-12-02 08:00:00 | NQ | Futures | 4059.67 | 4060.25 | 4058.21 | 4059.08 | 4842.0 |
| 2013-12-02 09:00:00 | NQ | Futures | 4059.08 | 4067.51 | 4049.79 | 4050.95 | 35511.0 |
| 2013-12-02 10:00:00 | NQ | Futures | 4050.37 | 4057.92 | 4046.02 | 4054.44 | 48766.0 |
| 2013-12-02 11:00:00 | NQ | Futures | 4054.73 | 4056.76 | 4046.6 | 4051.82 | 27594.0 |
| 2013-12-02 12:00:00 | NQ | Futures | 4052.11 | 4059.08 | 4050.95 | 4057.05 | 13062.0 |
| 2013-12-02 13:00:00 | NQ | Futures | 4056.76 | 4057.92 | 4050.37 | 4052.99 | 14466.0 |
| 2013-12-02 14:00:00 | NQ | Futures | 4052.99 | 4054.44 | 4045.14 | 4053.86 | 18698.0 |
| 2013-12-02 15:00:00 | NQ | Futures | 4053.57 | 4054.73 | 4039.04 | 4044.56 | 38669.0 |
| 2013-12-02 16:00:00 | NQ | Futures | 4044.85 | 4048.05 | 4044.56 | 4047.18 | 4846.0 |
| 2013-12-02 17:00:00 | NQ | Futures | 4047.18 | 4048.34 | 4047.18 | 4047.76 | 146.0 |
| 2013-12-02 18:00:00 | NQ | Futures | 4047.18 | 4050.66 | 4046.6 | 4048.92 | 569.0 |
| 2013-12-02 19:00:00 | NQ | Futures | 4049.21 | 4050.95 | 4048.05 | 4050.66 | 788.0 |
| 2013-12-02 20:00:00 | NQ | Futures | 4050.66 | 4051.24 | 4049.21 | 4049.5 | 512.0 |
| 2013-12-02 21:00:00 | NQ | Futures | 4049.79 | 4050.08 | 4048.92 | 4048.92 | 227.0 |
| 2013-12-02 22:00:00 | NQ | Futures | 4049.21 | 4050.66 | 4048.63 | 4049.79 | 311.0 |
| 2013-12-02 23:00:00 | NQ | Futures | 4049.79 | 4049.79 | 4048.05 | 4048.05 | 550.0 |
| 2013-12-02 00:00:00 | YM | Futures | 16427.8 | 16433.9 | 16426.8 | 16427.8 | 410.0 |
| 2013-12-02 01:00:00 | YM | Futures | 16427.8 | 16429.8 | 16424.7 | 16428.8 | 278.0 |
> showing 50 of 1,506 rows — these rows as CSV