PREVIEW / futures_1hour / 2013-10-27
file: by_date/futures_1hour/2013/2013-10-27.parquet size: 14 KB rows: 260
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-10-27 18:00:00 | ES | Futures | 1809.59 | 1810.62 | 1808.56 | 1808.56 | 3856.0 |
| 2013-10-27 19:00:00 | ES | Futures | 1808.56 | 1815.27 | 1808.56 | 1814.24 | 10273.0 |
| 2013-10-27 20:00:00 | ES | Futures | 1814.24 | 1814.75 | 1812.95 | 1814.75 | 7161.0 |
| 2013-10-27 21:00:00 | ES | Futures | 1814.49 | 1818.36 | 1814.24 | 1816.3 | 15069.0 |
| 2013-10-27 22:00:00 | ES | Futures | 1816.04 | 1817.07 | 1815.78 | 1816.82 | 3818.0 |
| 2013-10-27 23:00:00 | ES | Futures | 1816.82 | 1817.07 | 1815.27 | 1815.53 | 2556.0 |
| 2013-10-27 18:00:00 | NQ | Futures | 3919.97 | 3922.58 | 3917.64 | 3918.22 | 592.0 |
| 2013-10-27 19:00:00 | NQ | Futures | 3918.22 | 3931.58 | 3918.22 | 3929.55 | 1099.0 |
| 2013-10-27 20:00:00 | NQ | Futures | 3929.84 | 3930.71 | 3926.65 | 3930.42 | 1072.0 |
| 2013-10-27 21:00:00 | NQ | Futures | 3930.71 | 3937.68 | 3929.26 | 3933.91 | 1823.0 |
| 2013-10-27 22:00:00 | NQ | Futures | 3933.62 | 3936.23 | 3933.33 | 3934.78 | 775.0 |
| 2013-10-27 23:00:00 | NQ | Futures | 3934.49 | 3935.65 | 3933.04 | 3933.33 | 473.0 |
| 2013-10-27 18:00:00 | YM | Futures | 15822.2 | 15837.5 | 15819.1 | 15828.3 | 451.0 |
| 2013-10-27 19:00:00 | YM | Futures | 15827.3 | 15884.5 | 15824.2 | 15879.4 | 1886.0 |
| 2013-10-27 20:00:00 | YM | Futures | 15878.3 | 15882.4 | 15863.0 | 15874.3 | 1457.0 |
| 2013-10-27 21:00:00 | YM | Futures | 15875.3 | 15904.9 | 15871.2 | 15888.6 | 2427.0 |
| 2013-10-27 22:00:00 | YM | Futures | 15888.6 | 15896.7 | 15883.5 | 15891.6 | 975.0 |
| 2013-10-27 23:00:00 | YM | Futures | 15893.7 | 15894.7 | 15883.5 | 15885.5 | 485.0 |
| 2013-10-27 18:00:00 | CL | Futures | 155.52 | 155.52 | 154.93 | 155.13 | 916.0 |
| 2013-10-27 19:00:00 | CL | Futures | 155.11 | 155.16 | 154.95 | 154.97 | 445.0 |
| 2013-10-27 20:00:00 | CL | Futures | 154.95 | 155.11 | 154.95 | 155.09 | 351.0 |
| 2013-10-27 21:00:00 | CL | Futures | 155.09 | 155.33 | 155.08 | 155.25 | 930.0 |
| 2013-10-27 22:00:00 | CL | Futures | 155.24 | 155.27 | 155.09 | 155.19 | 279.0 |
| 2013-10-27 23:00:00 | CL | Futures | 155.2 | 155.24 | 155.16 | 155.16 | 147.0 |
| 2013-10-27 18:00:00 | GC | Futures | 1854.2 | 1856.7 | 1851.4 | 1852.5 | 1306.0 |
| 2013-10-27 19:00:00 | GC | Futures | 1852.5 | 1854.2 | 1848.8 | 1849.2 | 1153.0 |
| 2013-10-27 20:00:00 | GC | Futures | 1849.2 | 1851.1 | 1847.4 | 1850.5 | 2057.0 |
| 2013-10-27 21:00:00 | GC | Futures | 1850.7 | 1855.1 | 1847.1 | 1854.1 | 4075.0 |
| 2013-10-27 22:00:00 | GC | Futures | 1854.0 | 1855.6 | 1850.4 | 1851.5 | 2814.0 |
| 2013-10-27 23:00:00 | GC | Futures | 1851.6 | 1852.0 | 1850.4 | 1851.2 | 923.0 |
| 2013-10-27 18:00:00 | ZN | Futures | 116.600149 | 116.642996 | 116.571585 | 116.614432 | 1927.0 |
| 2013-10-27 19:00:00 | ZN | Futures | 116.614432 | 116.642996 | 116.557303 | 116.571585 | 3838.0 |
| 2013-10-27 20:00:00 | ZN | Futures | 116.557303 | 116.585867 | 116.557303 | 116.557303 | 2786.0 |
| 2013-10-27 21:00:00 | ZN | Futures | 116.557303 | 116.571585 | 116.514456 | 116.528738 | 5066.0 |
| 2013-10-27 22:00:00 | ZN | Futures | 116.528738 | 116.543021 | 116.457327 | 116.457327 | 5312.0 |
| 2013-10-27 23:00:00 | ZN | Futures | 116.471609 | 116.500174 | 116.457327 | 116.500174 | 2490.0 |
> showing 36 of 260 rows — these rows as CSV