PREVIEW / futures_1hour / 2012-12-23
file: by_date/futures_1hour/2012/2012-12-23.parquet size: 13 KB rows: 257
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-23 18:00:00 | ES | Futures | 1461.8 | 1462.06 | 1458.98 | 1459.23 | 7932.0 |
| 2012-12-23 19:00:00 | ES | Futures | 1459.23 | 1459.49 | 1454.87 | 1455.9 | 10984.0 |
| 2012-12-23 20:00:00 | ES | Futures | 1455.64 | 1458.46 | 1455.64 | 1456.92 | 3519.0 |
| 2012-12-23 21:00:00 | ES | Futures | 1457.18 | 1458.46 | 1456.67 | 1457.69 | 4444.0 |
| 2012-12-23 22:00:00 | ES | Futures | 1457.69 | 1458.46 | 1455.9 | 1455.9 | 3042.0 |
| 2012-12-23 23:00:00 | ES | Futures | 1455.9 | 1456.41 | 1455.38 | 1456.15 | 2040.0 |
| 2012-12-23 18:00:00 | NQ | Futures | 3096.98 | 3100.18 | 3093.48 | 3096.98 | 908.0 |
| 2012-12-23 19:00:00 | NQ | Futures | 3096.98 | 3097.27 | 3088.24 | 3088.53 | 1277.0 |
| 2012-12-23 20:00:00 | NQ | Futures | 3088.53 | 3091.74 | 3086.5 | 3089.99 | 503.0 |
| 2012-12-23 21:00:00 | NQ | Futures | 3089.7 | 3090.57 | 3087.66 | 3089.41 | 358.0 |
| 2012-12-23 22:00:00 | NQ | Futures | 3089.12 | 3089.99 | 3082.71 | 3083.88 | 486.0 |
| 2012-12-23 23:00:00 | NQ | Futures | 3084.17 | 3085.04 | 3083.59 | 3084.75 | 165.0 |
| 2012-12-23 18:00:00 | YM | Futures | 13212.1 | 13215.1 | 13183.0 | 13187.0 | 402.0 |
| 2012-12-23 19:00:00 | YM | Futures | 13187.0 | 13188.0 | 13154.8 | 13160.8 | 735.0 |
| 2012-12-23 20:00:00 | YM | Futures | 13160.8 | 13178.9 | 13160.8 | 13172.9 | 412.0 |
| 2012-12-23 21:00:00 | YM | Futures | 13172.9 | 13178.9 | 13167.9 | 13176.9 | 235.0 |
| 2012-12-23 22:00:00 | YM | Futures | 13175.9 | 13177.9 | 13160.8 | 13161.8 | 199.0 |
| 2012-12-23 23:00:00 | YM | Futures | 13161.8 | 13162.8 | 13157.8 | 13159.8 | 248.0 |
| 2012-12-23 18:00:00 | CL | Futures | 142.24 | 142.66 | 142.24 | 142.27 | 421.0 |
| 2012-12-23 19:00:00 | CL | Futures | 142.27 | 142.34 | 141.98 | 142.03 | 800.0 |
| 2012-12-23 20:00:00 | CL | Futures | 142.03 | 142.21 | 142.0 | 142.19 | 564.0 |
| 2012-12-23 21:00:00 | CL | Futures | 142.19 | 142.24 | 142.02 | 142.13 | 411.0 |
| 2012-12-23 22:00:00 | CL | Futures | 142.13 | 142.16 | 142.08 | 142.11 | 307.0 |
| 2012-12-23 23:00:00 | CL | Futures | 142.1 | 142.21 | 142.07 | 142.11 | 376.0 |
| 2012-12-23 18:00:00 | GC | Futures | 2283.5 | 2285.8 | 2281.6 | 2284.6 | 670.0 |
| 2012-12-23 19:00:00 | GC | Futures | 2284.7 | 2285.3 | 2277.3 | 2277.6 | 1291.0 |
| 2012-12-23 20:00:00 | GC | Futures | 2277.3 | 2284.2 | 2276.2 | 2282.7 | 2488.0 |
| 2012-12-23 21:00:00 | GC | Futures | 2282.8 | 2284.2 | 2280.6 | 2282.2 | 878.0 |
| 2012-12-23 22:00:00 | GC | Futures | 2282.2 | 2282.8 | 2281.7 | 2282.5 | 588.0 |
| 2012-12-23 23:00:00 | GC | Futures | 2282.4 | 2283.8 | 2281.8 | 2283.2 | 749.0 |
| 2012-12-23 18:00:00 | ZN | Futures | 117.851117 | 117.878935 | 117.823299 | 117.865026 | 2413.0 |
| 2012-12-23 19:00:00 | ZN | Futures | 117.865026 | 117.920662 | 117.865026 | 117.878935 | 1151.0 |
| 2012-12-23 20:00:00 | ZN | Futures | 117.865026 | 117.878935 | 117.837208 | 117.837208 | 1216.0 |
| 2012-12-23 21:00:00 | ZN | Futures | 117.823299 | 117.865026 | 117.823299 | 117.851117 | 1015.0 |
| 2012-12-23 22:00:00 | ZN | Futures | 117.851117 | 117.878935 | 117.837208 | 117.865026 | 453.0 |
| 2012-12-23 23:00:00 | ZN | Futures | 117.851117 | 117.865026 | 117.851117 | 117.865026 | 181.0 |
> showing 36 of 257 rows — these rows as CSV