PREVIEW / futures_1hour / 2014-12-07
file: by_date/futures_1hour/2014/2014-12-07.parquet size: 13 KB rows: 255
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-07 18:00:00 | ES | Futures | 2175.12 | 2176.95 | 2174.33 | 2175.38 | 5619.0 |
| 2014-12-07 19:00:00 | ES | Futures | 2175.38 | 2176.95 | 2174.33 | 2174.33 | 5191.0 |
| 2014-12-07 20:00:00 | ES | Futures | 2174.33 | 2175.38 | 2173.54 | 2174.85 | 3717.0 |
| 2014-12-07 21:00:00 | ES | Futures | 2174.85 | 2175.64 | 2174.33 | 2175.38 | 2405.0 |
| 2014-12-07 22:00:00 | ES | Futures | 2175.38 | 2175.38 | 2174.07 | 2174.07 | 1445.0 |
| 2014-12-07 23:00:00 | ES | Futures | 2174.33 | 2174.59 | 2174.07 | 2174.59 | 1027.0 |
| 2014-12-07 18:00:00 | NQ | Futures | 5056.4 | 5059.33 | 5053.47 | 5056.11 | 1164.0 |
| 2014-12-07 19:00:00 | NQ | Futures | 5056.4 | 5059.62 | 5053.18 | 5053.47 | 742.0 |
| 2014-12-07 20:00:00 | NQ | Futures | 5053.47 | 5056.69 | 5052.3 | 5055.52 | 769.0 |
| 2014-12-07 21:00:00 | NQ | Futures | 5055.81 | 5057.57 | 5054.64 | 5056.11 | 337.0 |
| 2014-12-07 22:00:00 | NQ | Futures | 5055.81 | 5056.11 | 5053.76 | 5054.06 | 306.0 |
| 2014-12-07 23:00:00 | NQ | Futures | 5054.35 | 5056.11 | 5054.06 | 5055.52 | 217.0 |
| 2014-12-07 18:00:00 | YM | Futures | 18666.9 | 18676.2 | 18659.6 | 18666.9 | 552.0 |
| 2014-12-07 19:00:00 | YM | Futures | 18665.8 | 18677.3 | 18657.5 | 18659.6 | 637.0 |
| 2014-12-07 20:00:00 | YM | Futures | 18660.6 | 18666.9 | 18654.4 | 18664.8 | 827.0 |
| 2014-12-07 21:00:00 | YM | Futures | 18663.7 | 18668.9 | 18659.6 | 18666.9 | 333.0 |
| 2014-12-07 22:00:00 | YM | Futures | 18666.9 | 18666.9 | 18656.5 | 18658.6 | 265.0 |
| 2014-12-07 23:00:00 | YM | Futures | 18658.6 | 18661.7 | 18658.6 | 18660.6 | 145.0 |
| 2014-12-07 18:00:00 | CL | Futures | 110.26 | 110.42 | 108.87 | 109.17 | 4359.0 |
| 2014-12-07 19:00:00 | CL | Futures | 109.19 | 109.46 | 109.1 | 109.27 | 1577.0 |
| 2014-12-07 20:00:00 | CL | Futures | 109.25 | 109.81 | 109.24 | 109.74 | 2239.0 |
| 2014-12-07 21:00:00 | CL | Futures | 109.73 | 109.78 | 109.51 | 109.64 | 1388.0 |
| 2014-12-07 22:00:00 | CL | Futures | 109.66 | 109.73 | 109.57 | 109.61 | 551.0 |
| 2014-12-07 23:00:00 | CL | Futures | 109.62 | 109.73 | 109.39 | 109.64 | 1384.0 |
| 2014-12-07 18:00:00 | GC | Futures | 1629.6 | 1629.6 | 1624.3 | 1627.3 | 2661.0 |
| 2014-12-07 19:00:00 | GC | Futures | 1627.1 | 1630.8 | 1626.3 | 1630.3 | 1623.0 |
| 2014-12-07 20:00:00 | GC | Futures | 1630.3 | 1634.5 | 1630.1 | 1633.4 | 3177.0 |
| 2014-12-07 21:00:00 | GC | Futures | 1633.6 | 1634.1 | 1631.5 | 1632.1 | 1695.0 |
| 2014-12-07 22:00:00 | GC | Futures | 1631.9 | 1632.7 | 1630.6 | 1631.4 | 1408.0 |
| 2014-12-07 23:00:00 | GC | Futures | 1631.4 | 1632.9 | 1630.6 | 1632.2 | 883.0 |
| 2014-12-07 18:00:00 | ZN | Futures | 119.665669 | 119.665669 | 119.606524 | 119.62131 | 3.0 |
| 2014-12-07 19:00:00 | ZN | Futures | 119.591738 | 119.591738 | 119.591738 | 119.591738 | 5.0 |
| 2014-12-07 20:00:00 | ZN | Futures | 119.650883 | 119.650883 | 119.606524 | 119.606524 | 110.0 |
| 2014-12-07 21:00:00 | ZN | Futures | 119.62131 | 119.62131 | 119.62131 | 119.62131 | 12.0 |
| 2014-12-07 22:00:00 | ZN | Futures | 119.606524 | 119.62131 | 119.562165 | 119.576951 | 69.0 |
| 2014-12-07 23:00:00 | ZN | Futures | 119.591738 | 119.591738 | 119.576951 | 119.576951 | 9.0 |
> showing 36 of 255 rows — these rows as CSV