PREVIEW / futures_1hour / 2012-06-10
file: by_date/futures_1hour/2012/2012-06-10.parquet size: 14 KB rows: 268
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-06-10 18:00:00 | ES | Futures | 1358.02 | 1365.1 | 1358.02 | 1360.55 | 19082.0 |
| 2012-06-10 19:00:00 | ES | Futures | 1360.55 | 1360.8 | 1357.77 | 1360.3 | 4969.0 |
| 2012-06-10 20:00:00 | ES | Futures | 1360.04 | 1360.3 | 1357.26 | 1360.04 | 4555.0 |
| 2012-06-10 21:00:00 | ES | Futures | 1360.04 | 1361.31 | 1360.04 | 1360.3 | 3140.0 |
| 2012-06-10 22:00:00 | ES | Futures | 1360.3 | 1360.55 | 1358.53 | 1358.78 | 2002.0 |
| 2012-06-10 23:00:00 | ES | Futures | 1358.78 | 1359.54 | 1358.27 | 1358.78 | 2451.0 |
| 2012-06-10 18:00:00 | NQ | Futures | 2992.65 | 3012.31 | 2989.76 | 3001.9 | 997.0 |
| 2012-06-10 19:00:00 | NQ | Futures | 3002.19 | 3003.06 | 2996.7 | 3000.74 | 261.0 |
| 2012-06-10 20:00:00 | NQ | Futures | 3001.61 | 3001.9 | 2996.12 | 3001.32 | 284.0 |
| 2012-06-10 21:00:00 | NQ | Futures | 3002.48 | 3003.35 | 3001.03 | 3001.03 | 162.0 |
| 2012-06-10 22:00:00 | NQ | Futures | 3001.03 | 3001.32 | 2996.41 | 2997.56 | 288.0 |
| 2012-06-10 23:00:00 | NQ | Futures | 2997.56 | 2998.43 | 2996.41 | 2996.41 | 64.0 |
| 2012-06-10 18:00:00 | YM | Futures | 12534.4 | 12643.8 | 12519.5 | 12580.2 | 2722.0 |
| 2012-06-10 19:00:00 | YM | Futures | 12580.2 | 12582.2 | 12556.3 | 12574.2 | 584.0 |
| 2012-06-10 20:00:00 | YM | Futures | 12576.2 | 12577.2 | 12554.3 | 12572.2 | 624.0 |
| 2012-06-10 21:00:00 | YM | Futures | 12573.2 | 12583.2 | 12573.2 | 12574.2 | 412.0 |
| 2012-06-10 22:00:00 | YM | Futures | 12573.2 | 12575.2 | 12563.3 | 12565.3 | 312.0 |
| 2012-06-10 23:00:00 | YM | Futures | 12564.3 | 12567.3 | 12559.3 | 12562.3 | 305.0 |
| 2012-06-10 18:00:00 | CL | Futures | 141.94 | 142.65 | 141.58 | 142.44 | 4533.0 |
| 2012-06-10 19:00:00 | CL | Futures | 142.47 | 143.46 | 142.4 | 143.15 | 3149.0 |
| 2012-06-10 20:00:00 | CL | Futures | 143.15 | 143.15 | 142.65 | 142.97 | 1520.0 |
| 2012-06-10 21:00:00 | CL | Futures | 143.0 | 143.23 | 142.52 | 142.59 | 1094.0 |
| 2012-06-10 22:00:00 | CL | Futures | 142.57 | 142.65 | 142.4 | 142.44 | 767.0 |
| 2012-06-10 23:00:00 | CL | Futures | 142.45 | 142.5 | 142.14 | 142.4 | 828.0 |
| 2012-06-10 18:00:00 | GC | Futures | 2217.9 | 2226.9 | 2216.8 | 2225.5 | 3005.0 |
| 2012-06-10 19:00:00 | GC | Futures | 2225.1 | 2226.0 | 2214.4 | 2218.2 | 1674.0 |
| 2012-06-10 20:00:00 | GC | Futures | 2218.2 | 2222.6 | 2216.2 | 2218.8 | 2339.0 |
| 2012-06-10 21:00:00 | GC | Futures | 2218.7 | 2221.3 | 2211.2 | 2213.0 | 3355.0 |
| 2012-06-10 22:00:00 | GC | Futures | 2213.2 | 2215.0 | 2209.6 | 2210.5 | 1522.0 |
| 2012-06-10 23:00:00 | GC | Futures | 2210.3 | 2211.5 | 2208.9 | 2211.1 | 967.0 |
| 2012-06-10 18:00:00 | ZN | Futures | 117.099362 | 117.113116 | 116.68675 | 116.920564 | 27468.0 |
| 2012-06-10 19:00:00 | ZN | Futures | 116.90681 | 116.975579 | 116.879303 | 116.948071 | 6840.0 |
| 2012-06-10 20:00:00 | ZN | Futures | 116.948071 | 117.058101 | 116.851795 | 116.920564 | 13485.0 |
| 2012-06-10 21:00:00 | ZN | Futures | 116.90681 | 116.934318 | 116.893056 | 116.934318 | 5092.0 |
| 2012-06-10 22:00:00 | ZN | Futures | 116.920564 | 117.003086 | 116.920564 | 116.975579 | 4486.0 |
| 2012-06-10 23:00:00 | ZN | Futures | 116.961825 | 116.975579 | 116.920564 | 116.934318 | 1899.0 |
> showing 36 of 268 rows — these rows as CSV