PREVIEW / futures_1hour / 2014-03-23
file: by_date/futures_1hour/2014/2014-03-23.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 |
|---|---|---|---|---|---|---|---|
| 2014-03-23 18:00:00 | ES | Futures | 1927.28 | 1930.66 | 1926.76 | 1929.88 | 5992.0 |
| 2014-03-23 19:00:00 | ES | Futures | 1929.88 | 1931.17 | 1929.36 | 1929.62 | 2808.0 |
| 2014-03-23 20:00:00 | ES | Futures | 1929.62 | 1930.66 | 1929.36 | 1929.88 | 4747.0 |
| 2014-03-23 21:00:00 | ES | Futures | 1929.88 | 1931.95 | 1927.02 | 1931.17 | 19181.0 |
| 2014-03-23 22:00:00 | ES | Futures | 1931.43 | 1933.51 | 1931.17 | 1931.17 | 7312.0 |
| 2014-03-23 23:00:00 | ES | Futures | 1931.17 | 1931.69 | 1929.62 | 1930.4 | 2240.0 |
| 2014-03-23 18:00:00 | NQ | Futures | 4240.49 | 4242.82 | 4234.08 | 4241.07 | 1255.0 |
| 2014-03-23 19:00:00 | NQ | Futures | 4241.07 | 4243.11 | 4240.49 | 4241.07 | 527.0 |
| 2014-03-23 20:00:00 | NQ | Futures | 4241.07 | 4241.36 | 4239.32 | 4241.07 | 782.0 |
| 2014-03-23 21:00:00 | NQ | Futures | 4241.07 | 4244.27 | 4234.08 | 4242.82 | 4246.0 |
| 2014-03-23 22:00:00 | NQ | Futures | 4242.82 | 4247.77 | 4242.53 | 4243.11 | 1293.0 |
| 2014-03-23 23:00:00 | NQ | Futures | 4243.4 | 4244.27 | 4239.61 | 4241.36 | 472.0 |
| 2014-03-23 18:00:00 | YM | Futures | 16698.1 | 16716.7 | 16689.9 | 16710.5 | 1112.0 |
| 2014-03-23 19:00:00 | YM | Futures | 16710.5 | 16723.9 | 16706.4 | 16706.4 | 442.0 |
| 2014-03-23 20:00:00 | YM | Futures | 16708.4 | 16717.7 | 16707.4 | 16711.5 | 614.0 |
| 2014-03-23 21:00:00 | YM | Futures | 16713.6 | 16730.1 | 16689.9 | 16722.9 | 2081.0 |
| 2014-03-23 22:00:00 | YM | Futures | 16723.9 | 16740.4 | 16719.8 | 16720.8 | 728.0 |
| 2014-03-23 23:00:00 | YM | Futures | 16721.8 | 16724.9 | 16708.4 | 16714.6 | 320.0 |
| 2014-03-23 18:00:00 | CL | Futures | 157.85 | 158.02 | 157.31 | 157.48 | 1193.0 |
| 2014-03-23 19:00:00 | CL | Futures | 157.48 | 157.53 | 157.35 | 157.4 | 207.0 |
| 2014-03-23 20:00:00 | CL | Futures | 157.42 | 157.64 | 157.4 | 157.5 | 670.0 |
| 2014-03-23 21:00:00 | CL | Futures | 157.5 | 157.56 | 157.42 | 157.43 | 437.0 |
| 2014-03-23 22:00:00 | CL | Futures | 157.47 | 157.58 | 157.43 | 157.51 | 266.0 |
| 2014-03-23 23:00:00 | CL | Futures | 157.5 | 157.53 | 157.39 | 157.39 | 258.0 |
| 2014-03-23 18:00:00 | GC | Futures | 1828.4 | 1829.3 | 1822.2 | 1823.7 | 1505.0 |
| 2014-03-23 19:00:00 | GC | Futures | 1823.5 | 1828.1 | 1821.7 | 1825.7 | 1715.0 |
| 2014-03-23 20:00:00 | GC | Futures | 1825.7 | 1828.1 | 1824.4 | 1827.0 | 2670.0 |
| 2014-03-23 21:00:00 | GC | Futures | 1826.7 | 1828.4 | 1817.8 | 1820.3 | 6628.0 |
| 2014-03-23 22:00:00 | GC | Futures | 1820.0 | 1820.7 | 1815.5 | 1817.8 | 3294.0 |
| 2014-03-23 23:00:00 | GC | Futures | 1817.8 | 1819.4 | 1817.0 | 1818.8 | 1560.0 |
| 2014-03-23 18:00:00 | ZN | Futures | 115.592259 | 115.592259 | 115.489862 | 115.50449 | 6175.0 |
| 2014-03-23 19:00:00 | ZN | Futures | 115.50449 | 115.533746 | 115.475234 | 115.50449 | 3400.0 |
| 2014-03-23 20:00:00 | ZN | Futures | 115.50449 | 115.519118 | 115.489862 | 115.489862 | 6809.0 |
| 2014-03-23 21:00:00 | ZN | Futures | 115.489862 | 115.592259 | 115.475234 | 115.533746 | 14513.0 |
| 2014-03-23 22:00:00 | ZN | Futures | 115.548375 | 115.563003 | 115.489862 | 115.50449 | 9005.0 |
| 2014-03-23 23:00:00 | ZN | Futures | 115.50449 | 115.548375 | 115.489862 | 115.533746 | 5175.0 |
> showing 36 of 268 rows — these rows as CSV