PREVIEW / futures_1hour / 2014-12-21
file: by_date/futures_1hour/2014/2014-12-21.parquet size: 14 KB rows: 271
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-21 18:00:00 | ES | Futures | 2173.63 | 2177.32 | 2172.58 | 2176.27 | 4461.0 |
| 2014-12-21 19:00:00 | ES | Futures | 2176.0 | 2176.27 | 2173.63 | 2175.48 | 4433.0 |
| 2014-12-21 20:00:00 | ES | Futures | 2175.21 | 2175.48 | 2173.9 | 2174.42 | 2877.0 |
| 2014-12-21 21:00:00 | ES | Futures | 2174.42 | 2176.0 | 2174.42 | 2174.69 | 1790.0 |
| 2014-12-21 22:00:00 | ES | Futures | 2174.69 | 2175.74 | 2174.42 | 2175.74 | 1721.0 |
| 2014-12-21 23:00:00 | ES | Futures | 2175.74 | 2177.06 | 2174.95 | 2176.79 | 1706.0 |
| 2014-12-21 18:00:00 | NQ | Futures | 5030.29 | 5038.22 | 5029.12 | 5036.17 | 650.0 |
| 2014-12-21 19:00:00 | NQ | Futures | 5035.58 | 5035.58 | 5029.12 | 5033.82 | 866.0 |
| 2014-12-21 20:00:00 | NQ | Futures | 5034.11 | 5034.7 | 5029.71 | 5031.18 | 606.0 |
| 2014-12-21 21:00:00 | NQ | Futures | 5031.47 | 5033.82 | 5030.29 | 5030.88 | 365.0 |
| 2014-12-21 22:00:00 | NQ | Futures | 5030.88 | 5033.53 | 5030.88 | 5033.23 | 225.0 |
| 2014-12-21 23:00:00 | NQ | Futures | 5033.23 | 5035.87 | 5032.35 | 5035.58 | 479.0 |
| 2014-12-21 18:00:00 | YM | Futures | 18519.4 | 18558.1 | 18519.4 | 18548.7 | 715.0 |
| 2014-12-21 19:00:00 | YM | Futures | 18546.6 | 18546.6 | 18526.7 | 18540.3 | 595.0 |
| 2014-12-21 20:00:00 | YM | Futures | 18542.4 | 18543.4 | 18528.8 | 18534.0 | 323.0 |
| 2014-12-21 21:00:00 | YM | Futures | 18534.0 | 18544.5 | 18532.0 | 18534.0 | 273.0 |
| 2014-12-21 22:00:00 | YM | Futures | 18535.1 | 18541.3 | 18534.0 | 18541.3 | 127.0 |
| 2014-12-21 23:00:00 | YM | Futures | 18538.2 | 18552.8 | 18538.2 | 18550.7 | 157.0 |
| 2014-12-21 18:00:00 | CL | Futures | 98.29 | 98.49 | 96.53 | 97.57 | 5115.0 |
| 2014-12-21 19:00:00 | CL | Futures | 97.57 | 97.88 | 97.4 | 97.67 | 1568.0 |
| 2014-12-21 20:00:00 | CL | Futures | 97.67 | 98.3 | 97.55 | 98.29 | 2268.0 |
| 2014-12-21 21:00:00 | CL | Futures | 98.29 | 98.75 | 98.1 | 98.25 | 3556.0 |
| 2014-12-21 22:00:00 | CL | Futures | 98.24 | 98.97 | 98.24 | 98.81 | 3024.0 |
| 2014-12-21 23:00:00 | CL | Futures | 98.85 | 98.95 | 98.24 | 98.69 | 3120.0 |
| 2014-12-21 18:00:00 | GC | Futures | 1636.2 | 1636.3 | 1633.2 | 1635.8 | 919.0 |
| 2014-12-21 19:00:00 | GC | Futures | 1635.8 | 1636.2 | 1634.5 | 1636.2 | 1297.0 |
| 2014-12-21 20:00:00 | GC | Futures | 1636.2 | 1638.8 | 1635.9 | 1638.1 | 2504.0 |
| 2014-12-21 21:00:00 | GC | Futures | 1637.8 | 1639.9 | 1637.0 | 1639.0 | 1684.0 |
| 2014-12-21 22:00:00 | GC | Futures | 1639.0 | 1640.7 | 1638.6 | 1639.5 | 1436.0 |
| 2014-12-21 23:00:00 | GC | Futures | 1639.0 | 1639.3 | 1637.4 | 1638.9 | 650.0 |
| 2014-12-21 18:00:00 | ZN | Futures | 120.468435 | 120.483293 | 120.423861 | 120.468435 | 1329.0 |
| 2014-12-21 19:00:00 | ZN | Futures | 120.468435 | 120.557583 | 120.468435 | 120.542725 | 3935.0 |
| 2014-12-21 20:00:00 | ZN | Futures | 120.527867 | 120.587299 | 120.527867 | 120.572441 | 2017.0 |
| 2014-12-21 21:00:00 | ZN | Futures | 120.587299 | 120.602157 | 120.557583 | 120.572441 | 847.0 |
| 2014-12-21 22:00:00 | ZN | Futures | 120.572441 | 120.572441 | 120.513009 | 120.542725 | 2246.0 |
| 2014-12-21 23:00:00 | ZN | Futures | 120.542725 | 120.602157 | 120.542725 | 120.587299 | 1471.0 |
> showing 36 of 271 rows — these rows as CSV