PREVIEW / futures_1hour / 2015-03-08
file: by_date/futures_1hour/2015/2015-03-08.parquet size: 14 KB rows: 272
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 |
|---|---|---|---|---|---|---|---|
| 2015-03-08 18:00:00 | ES | Futures | 2182.58 | 2183.37 | 2178.11 | 2179.42 | 8420.0 |
| 2015-03-08 19:00:00 | ES | Futures | 2179.42 | 2179.42 | 2177.32 | 2178.37 | 3917.0 |
| 2015-03-08 20:00:00 | ES | Futures | 2178.63 | 2178.63 | 2176.27 | 2176.79 | 6554.0 |
| 2015-03-08 21:00:00 | ES | Futures | 2176.79 | 2178.11 | 2175.74 | 2176.53 | 5555.0 |
| 2015-03-08 22:00:00 | ES | Futures | 2176.53 | 2177.06 | 2176.0 | 2176.53 | 2569.0 |
| 2015-03-08 23:00:00 | ES | Futures | 2176.53 | 2176.79 | 2176.0 | 2176.27 | 2227.0 |
| 2015-03-08 18:00:00 | NQ | Futures | 5182.72 | 5185.66 | 5173.03 | 5176.26 | 1137.0 |
| 2015-03-08 19:00:00 | NQ | Futures | 5176.55 | 5177.14 | 5171.85 | 5173.61 | 492.0 |
| 2015-03-08 20:00:00 | NQ | Futures | 5173.03 | 5174.2 | 5168.33 | 5169.8 | 574.0 |
| 2015-03-08 21:00:00 | NQ | Futures | 5169.8 | 5173.03 | 5166.86 | 5169.21 | 828.0 |
| 2015-03-08 22:00:00 | NQ | Futures | 5168.92 | 5170.09 | 5167.74 | 5169.8 | 488.0 |
| 2015-03-08 23:00:00 | NQ | Futures | 5169.8 | 5170.68 | 5168.33 | 5168.33 | 672.0 |
| 2015-03-08 18:00:00 | YM | Futures | 18659.3 | 18679.1 | 18632.2 | 18642.6 | 1256.0 |
| 2015-03-08 19:00:00 | YM | Futures | 18642.6 | 18642.6 | 18625.9 | 18635.3 | 567.0 |
| 2015-03-08 20:00:00 | YM | Futures | 18634.3 | 18635.3 | 18615.5 | 18621.7 | 785.0 |
| 2015-03-08 21:00:00 | YM | Futures | 18620.7 | 18631.1 | 18611.3 | 18618.6 | 570.0 |
| 2015-03-08 22:00:00 | YM | Futures | 18617.6 | 18619.6 | 18612.3 | 18616.5 | 330.0 |
| 2015-03-08 23:00:00 | YM | Futures | 18616.5 | 18618.6 | 18614.4 | 18616.5 | 325.0 |
| 2015-03-08 18:00:00 | CL | Futures | 81.93 | 82.2 | 81.8 | 81.92 | 970.0 |
| 2015-03-08 19:00:00 | CL | Futures | 81.9 | 81.93 | 81.47 | 81.59 | 1274.0 |
| 2015-03-08 20:00:00 | CL | Futures | 81.57 | 81.78 | 81.57 | 81.7 | 1223.0 |
| 2015-03-08 21:00:00 | CL | Futures | 81.7 | 81.78 | 81.54 | 81.55 | 1324.0 |
| 2015-03-08 22:00:00 | CL | Futures | 81.57 | 81.73 | 81.54 | 81.65 | 645.0 |
| 2015-03-08 23:00:00 | CL | Futures | 81.65 | 81.7 | 81.49 | 81.55 | 590.0 |
| 2015-03-08 18:00:00 | GC | Futures | 1598.4 | 1598.6 | 1593.9 | 1596.9 | 1890.0 |
| 2015-03-08 19:00:00 | GC | Futures | 1596.8 | 1598.9 | 1595.7 | 1597.4 | 1506.0 |
| 2015-03-08 20:00:00 | GC | Futures | 1597.4 | 1600.5 | 1596.8 | 1599.0 | 2306.0 |
| 2015-03-08 21:00:00 | GC | Futures | 1599.0 | 1600.0 | 1594.2 | 1598.2 | 4710.0 |
| 2015-03-08 22:00:00 | GC | Futures | 1598.0 | 1599.4 | 1597.1 | 1598.4 | 2758.0 |
| 2015-03-08 23:00:00 | GC | Futures | 1598.4 | 1598.9 | 1596.7 | 1597.6 | 1884.0 |
| 2015-03-08 18:00:00 | ZN | Futures | 120.498153 | 120.498153 | 120.423485 | 120.438419 | 4742.0 |
| 2015-03-08 19:00:00 | ZN | Futures | 120.453352 | 120.453352 | 120.378685 | 120.393618 | 5773.0 |
| 2015-03-08 20:00:00 | ZN | Futures | 120.393618 | 120.498153 | 120.393618 | 120.483219 | 11111.0 |
| 2015-03-08 21:00:00 | ZN | Futures | 120.483219 | 120.513086 | 120.453352 | 120.468286 | 6370.0 |
| 2015-03-08 22:00:00 | ZN | Futures | 120.483219 | 120.557887 | 120.483219 | 120.52802 | 6257.0 |
| 2015-03-08 23:00:00 | ZN | Futures | 120.52802 | 120.542953 | 120.483219 | 120.52802 | 2850.0 |
> showing 36 of 272 rows — these rows as CSV