PREVIEW / futures_1hour / 2012-12-30
file: by_date/futures_1hour/2012/2012-12-30.parquet size: 13 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 |
|---|---|---|---|---|---|---|---|
| 2012-12-30 18:00:00 | ES | Futures | 1424.85 | 1428.96 | 1419.98 | 1426.39 | 32652.0 |
| 2012-12-30 19:00:00 | ES | Futures | 1426.39 | 1426.39 | 1424.34 | 1424.85 | 6491.0 |
| 2012-12-30 20:00:00 | ES | Futures | 1424.59 | 1426.39 | 1424.34 | 1426.13 | 5860.0 |
| 2012-12-30 21:00:00 | ES | Futures | 1425.88 | 1425.88 | 1423.05 | 1425.62 | 4093.0 |
| 2012-12-30 22:00:00 | ES | Futures | 1425.62 | 1427.16 | 1425.11 | 1425.88 | 4359.0 |
| 2012-12-30 23:00:00 | ES | Futures | 1425.62 | 1426.9 | 1423.82 | 1424.08 | 2851.0 |
| 2012-12-30 18:00:00 | NQ | Futures | 3015.77 | 3020.13 | 3003.83 | 3016.06 | 2228.0 |
| 2012-12-30 19:00:00 | NQ | Futures | 3016.06 | 3016.64 | 3011.69 | 3012.27 | 596.0 |
| 2012-12-30 20:00:00 | NQ | Futures | 3011.98 | 3014.02 | 3010.53 | 3013.44 | 477.0 |
| 2012-12-30 21:00:00 | NQ | Futures | 3012.86 | 3014.31 | 3009.36 | 3013.73 | 257.0 |
| 2012-12-30 22:00:00 | NQ | Futures | 3013.73 | 3016.35 | 3013.44 | 3013.44 | 279.0 |
| 2012-12-30 23:00:00 | NQ | Futures | 3013.44 | 3016.35 | 3010.53 | 3011.11 | 302.0 |
| 2012-12-30 18:00:00 | YM | Futures | 12878.1 | 12900.3 | 12818.8 | 12881.1 | 2068.0 |
| 2012-12-30 19:00:00 | YM | Futures | 12885.2 | 12885.2 | 12871.1 | 12871.1 | 519.0 |
| 2012-12-30 20:00:00 | YM | Futures | 12874.1 | 12885.2 | 12872.1 | 12884.2 | 955.0 |
| 2012-12-30 21:00:00 | YM | Futures | 12882.1 | 12890.2 | 12877.1 | 12890.2 | 594.0 |
| 2012-12-30 22:00:00 | YM | Futures | 12889.2 | 12903.3 | 12888.2 | 12890.2 | 426.0 |
| 2012-12-30 23:00:00 | YM | Futures | 12891.2 | 12898.2 | 12871.1 | 12877.1 | 489.0 |
| 2012-12-30 18:00:00 | CL | Futures | 145.15 | 145.63 | 145.08 | 145.5 | 971.0 |
| 2012-12-30 19:00:00 | CL | Futures | 145.48 | 145.58 | 145.34 | 145.5 | 582.0 |
| 2012-12-30 20:00:00 | CL | Futures | 145.52 | 145.61 | 145.4 | 145.45 | 519.0 |
| 2012-12-30 21:00:00 | CL | Futures | 145.44 | 145.66 | 145.36 | 145.58 | 519.0 |
| 2012-12-30 22:00:00 | CL | Futures | 145.58 | 145.69 | 145.52 | 145.63 | 290.0 |
| 2012-12-30 23:00:00 | CL | Futures | 145.63 | 145.89 | 145.58 | 145.81 | 636.0 |
| 2012-12-30 18:00:00 | GC | Futures | 2280.6 | 2283.8 | 2280.6 | 2282.9 | 713.0 |
| 2012-12-30 19:00:00 | GC | Futures | 2282.9 | 2285.4 | 2282.8 | 2285.1 | 488.0 |
| 2012-12-30 20:00:00 | GC | Futures | 2285.1 | 2287.6 | 2283.9 | 2286.7 | 1656.0 |
| 2012-12-30 21:00:00 | GC | Futures | 2286.9 | 2289.3 | 2286.7 | 2287.6 | 1119.0 |
| 2012-12-30 22:00:00 | GC | Futures | 2287.3 | 2288.9 | 2286.7 | 2286.7 | 556.0 |
| 2012-12-30 23:00:00 | GC | Futures | 2286.8 | 2288.7 | 2286.7 | 2288.7 | 688.0 |
| 2012-12-30 18:00:00 | ZN | Futures | 118.351842 | 118.407478 | 118.310115 | 118.324024 | 3312.0 |
| 2012-12-30 19:00:00 | ZN | Futures | 118.337933 | 118.37966 | 118.337933 | 118.365751 | 1531.0 |
| 2012-12-30 20:00:00 | ZN | Futures | 118.351842 | 118.393569 | 118.351842 | 118.37966 | 786.0 |
| 2012-12-30 21:00:00 | ZN | Futures | 118.37966 | 118.407478 | 118.37966 | 118.407478 | 512.0 |
| 2012-12-30 22:00:00 | ZN | Futures | 118.407478 | 118.435296 | 118.393569 | 118.421387 | 1145.0 |
| 2012-12-30 23:00:00 | ZN | Futures | 118.421387 | 118.449205 | 118.407478 | 118.449205 | 302.0 |
> showing 36 of 260 rows — these rows as CSV