PREVIEW / futures_1hour / 2015-04-19
file: by_date/futures_1hour/2015/2015-04-19.parquet size: 14 KB rows: 277
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 |
|---|---|---|---|---|---|---|---|
| 2015-04-19 18:00:00 | ES | Futures | 2198.52 | 2199.04 | 2195.88 | 2197.99 | 15145.0 |
| 2015-04-19 19:00:00 | ES | Futures | 2197.99 | 2199.31 | 2196.14 | 2199.04 | 4877.0 |
| 2015-04-19 20:00:00 | ES | Futures | 2199.04 | 2199.04 | 2196.67 | 2198.25 | 4688.0 |
| 2015-04-19 21:00:00 | ES | Futures | 2198.25 | 2199.84 | 2197.99 | 2199.04 | 8227.0 |
| 2015-04-19 22:00:00 | ES | Futures | 2199.31 | 2202.74 | 2199.04 | 2201.42 | 12168.0 |
| 2015-04-19 23:00:00 | ES | Futures | 2201.42 | 2201.95 | 2200.89 | 2201.69 | 2331.0 |
| 2015-04-19 18:00:00 | NQ | Futures | 5124.65 | 5127.29 | 5119.65 | 5124.06 | 2232.0 |
| 2015-04-19 19:00:00 | NQ | Futures | 5123.76 | 5124.94 | 5119.35 | 5124.65 | 670.0 |
| 2015-04-19 20:00:00 | NQ | Futures | 5124.06 | 5124.06 | 5119.35 | 5123.76 | 733.0 |
| 2015-04-19 21:00:00 | NQ | Futures | 5123.17 | 5125.82 | 5122.59 | 5123.17 | 1256.0 |
| 2015-04-19 22:00:00 | NQ | Futures | 5123.17 | 5130.82 | 5123.17 | 5127.59 | 1649.0 |
| 2015-04-19 23:00:00 | NQ | Futures | 5127.88 | 5129.35 | 5126.7 | 5127.59 | 379.0 |
| 2015-04-19 18:00:00 | YM | Futures | 18669.4 | 18693.5 | 18655.8 | 18674.7 | 1264.0 |
| 2015-04-19 19:00:00 | YM | Futures | 18673.6 | 18680.9 | 18662.1 | 18679.9 | 440.0 |
| 2015-04-19 20:00:00 | YM | Futures | 18678.8 | 18678.8 | 18661.0 | 18677.8 | 652.0 |
| 2015-04-19 21:00:00 | YM | Futures | 18678.8 | 18689.3 | 18675.7 | 18680.9 | 1002.0 |
| 2015-04-19 22:00:00 | YM | Futures | 18680.9 | 18711.4 | 18679.9 | 18704.0 | 1154.0 |
| 2015-04-19 23:00:00 | YM | Futures | 18704.0 | 18706.1 | 18697.7 | 18700.9 | 312.0 |
| 2015-04-19 18:00:00 | CL | Futures | 88.05 | 88.27 | 87.8 | 88.17 | 1819.0 |
| 2015-04-19 19:00:00 | CL | Futures | 88.17 | 88.34 | 88.14 | 88.34 | 724.0 |
| 2015-04-19 20:00:00 | CL | Futures | 88.34 | 88.47 | 88.26 | 88.37 | 1862.0 |
| 2015-04-19 21:00:00 | CL | Futures | 88.38 | 88.53 | 88.26 | 88.43 | 2313.0 |
| 2015-04-19 22:00:00 | CL | Futures | 88.44 | 88.84 | 88.35 | 88.76 | 2694.0 |
| 2015-04-19 23:00:00 | CL | Futures | 88.78 | 88.85 | 88.56 | 88.61 | 636.0 |
| 2015-04-19 18:00:00 | GC | Futures | 1644.9 | 1646.4 | 1643.5 | 1643.7 | 1142.0 |
| 2015-04-19 19:00:00 | GC | Futures | 1643.8 | 1647.5 | 1643.7 | 1647.2 | 1025.0 |
| 2015-04-19 20:00:00 | GC | Futures | 1647.2 | 1647.5 | 1643.7 | 1644.4 | 1952.0 |
| 2015-04-19 21:00:00 | GC | Futures | 1644.2 | 1646.3 | 1644.1 | 1644.5 | 2704.0 |
| 2015-04-19 22:00:00 | GC | Futures | 1644.6 | 1645.6 | 1643.8 | 1645.2 | 2042.0 |
| 2015-04-19 23:00:00 | GC | Futures | 1645.2 | 1645.5 | 1643.5 | 1643.7 | 2106.0 |
| 2015-04-19 18:00:00 | ZN | Futures | 123.858183 | 123.88805 | 123.84325 | 123.873116 | 3762.0 |
| 2015-04-19 19:00:00 | ZN | Futures | 123.858183 | 123.917917 | 123.858183 | 123.88805 | 2690.0 |
| 2015-04-19 20:00:00 | ZN | Futures | 123.902983 | 123.902983 | 123.84325 | 123.858183 | 2442.0 |
| 2015-04-19 21:00:00 | ZN | Futures | 123.858183 | 123.88805 | 123.84325 | 123.858183 | 4578.0 |
| 2015-04-19 22:00:00 | ZN | Futures | 123.858183 | 123.88805 | 123.84325 | 123.88805 | 3046.0 |
| 2015-04-19 23:00:00 | ZN | Futures | 123.88805 | 123.902983 | 123.873116 | 123.88805 | 1528.0 |
> showing 36 of 277 rows — these rows as CSV