PREVIEW / futures_1hour / 2014-02-16
file: by_date/futures_1hour/2014/2014-02-16.parquet size: 13 KB rows: 227
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-02-16 18:00:00 | ES | Futures | 1896.96 | 1900.58 | 1896.96 | 1898.77 | 6848.0 |
| 2014-02-16 19:00:00 | ES | Futures | 1899.03 | 1899.55 | 1895.15 | 1895.67 | 7676.0 |
| 2014-02-16 20:00:00 | ES | Futures | 1895.93 | 1898.52 | 1895.67 | 1898.52 | 3826.0 |
| 2014-02-16 21:00:00 | ES | Futures | 1898.26 | 1898.52 | 1896.19 | 1897.22 | 2068.0 |
| 2014-02-16 22:00:00 | ES | Futures | 1897.22 | 1898.0 | 1896.45 | 1897.22 | 1726.0 |
| 2014-02-16 23:00:00 | ES | Futures | 1897.48 | 1898.0 | 1896.45 | 1897.22 | 1229.0 |
| 2014-02-16 18:00:00 | NQ | Futures | 4255.62 | 4260.86 | 4253.88 | 4258.82 | 485.0 |
| 2014-02-16 19:00:00 | NQ | Futures | 4258.53 | 4259.98 | 4251.55 | 4252.43 | 1143.0 |
| 2014-02-16 20:00:00 | NQ | Futures | 4252.72 | 4258.24 | 4252.72 | 4258.24 | 704.0 |
| 2014-02-16 21:00:00 | NQ | Futures | 4257.95 | 4258.53 | 4255.04 | 4256.5 | 430.0 |
| 2014-02-16 22:00:00 | NQ | Futures | 4256.5 | 4258.24 | 4255.04 | 4257.37 | 218.0 |
| 2014-02-16 23:00:00 | NQ | Futures | 4257.66 | 4258.24 | 4253.88 | 4255.33 | 272.0 |
| 2014-02-16 18:00:00 | YM | Futures | 16529.5 | 16555.1 | 16529.5 | 16535.6 | 672.0 |
| 2014-02-16 19:00:00 | YM | Futures | 16536.7 | 16541.8 | 16509.0 | 16512.1 | 1385.0 |
| 2014-02-16 20:00:00 | YM | Futures | 16514.1 | 16538.7 | 16514.1 | 16537.7 | 1102.0 |
| 2014-02-16 21:00:00 | YM | Futures | 16536.7 | 16537.7 | 16519.2 | 16527.4 | 566.0 |
| 2014-02-16 22:00:00 | YM | Futures | 16528.5 | 16533.6 | 16521.3 | 16527.4 | 560.0 |
| 2014-02-16 23:00:00 | YM | Futures | 16529.5 | 16533.6 | 16517.2 | 16522.3 | 362.0 |
| 2014-02-16 18:00:00 | CL | Futures | 158.26 | 159.45 | 158.15 | 158.98 | 823.0 |
| 2014-02-16 19:00:00 | CL | Futures | 159.01 | 159.01 | 158.56 | 158.6 | 232.0 |
| 2014-02-16 20:00:00 | CL | Futures | 158.58 | 158.75 | 158.56 | 158.61 | 300.0 |
| 2014-02-16 21:00:00 | CL | Futures | 158.6 | 158.71 | 158.44 | 158.53 | 167.0 |
| 2014-02-16 22:00:00 | CL | Futures | 158.55 | 158.69 | 158.44 | 158.61 | 283.0 |
| 2014-02-16 23:00:00 | CL | Futures | 158.6 | 158.61 | 158.5 | 158.61 | 98.0 |
| 2014-02-16 18:00:00 | GC | Futures | 1805.9 | 1813.5 | 1805.9 | 1812.6 | 3185.0 |
| 2014-02-16 19:00:00 | GC | Futures | 1812.8 | 1812.9 | 1809.4 | 1810.4 | 1996.0 |
| 2014-02-16 20:00:00 | GC | Futures | 1810.4 | 1821.4 | 1809.5 | 1817.7 | 10357.0 |
| 2014-02-16 21:00:00 | GC | Futures | 1817.7 | 1819.1 | 1816.2 | 1817.4 | 2148.0 |
| 2014-02-16 22:00:00 | GC | Futures | 1817.6 | 1818.1 | 1815.1 | 1815.5 | 1483.0 |
| 2014-02-16 23:00:00 | GC | Futures | 1815.5 | 1816.2 | 1813.5 | 1813.7 | 838.0 |
| 2014-02-16 18:00:00 | ZN | Futures | 116.186049 | 116.214944 | 116.099364 | 116.186049 | 9650.0 |
| 2014-02-16 19:00:00 | ZN | Futures | 116.200496 | 116.258286 | 116.171601 | 116.243839 | 7760.0 |
| 2014-02-16 20:00:00 | ZN | Futures | 116.243839 | 116.243839 | 116.186049 | 116.186049 | 3342.0 |
| 2014-02-16 21:00:00 | ZN | Futures | 116.200496 | 116.200496 | 116.157154 | 116.186049 | 3385.0 |
| 2014-02-16 22:00:00 | ZN | Futures | 116.186049 | 116.186049 | 116.171601 | 116.186049 | 973.0 |
| 2014-02-16 23:00:00 | ZN | Futures | 116.171601 | 116.200496 | 116.171601 | 116.186049 | 992.0 |
> showing 36 of 227 rows — these rows as CSV