PREVIEW / futures_1hour / 2014-02-23
file: by_date/futures_1hour/2014/2014-02-23.parquet size: 14 KB rows: 262
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-23 18:00:00 | ES | Futures | 1898.77 | 1899.55 | 1898.0 | 1898.52 | 6261.0 |
| 2014-02-23 19:00:00 | ES | Futures | 1898.26 | 1901.36 | 1897.48 | 1901.1 | 5710.0 |
| 2014-02-23 20:00:00 | ES | Futures | 1901.36 | 1902.39 | 1898.0 | 1898.0 | 8946.0 |
| 2014-02-23 21:00:00 | ES | Futures | 1898.0 | 1898.52 | 1894.89 | 1895.67 | 8749.0 |
| 2014-02-23 22:00:00 | ES | Futures | 1895.67 | 1896.96 | 1894.89 | 1895.15 | 5222.0 |
| 2014-02-23 23:00:00 | ES | Futures | 1895.41 | 1895.67 | 1892.57 | 1893.6 | 7838.0 |
| 2014-02-23 18:00:00 | NQ | Futures | 4262.31 | 4265.22 | 4259.98 | 4262.02 | 672.0 |
| 2014-02-23 19:00:00 | NQ | Futures | 4262.6 | 4269.87 | 4261.44 | 4269.29 | 718.0 |
| 2014-02-23 20:00:00 | NQ | Futures | 4269.29 | 4271.32 | 4261.73 | 4261.73 | 1125.0 |
| 2014-02-23 21:00:00 | NQ | Futures | 4261.73 | 4262.31 | 4254.17 | 4255.62 | 917.0 |
| 2014-02-23 22:00:00 | NQ | Futures | 4255.33 | 4258.82 | 4254.17 | 4255.92 | 387.0 |
| 2014-02-23 23:00:00 | NQ | Futures | 4255.92 | 4257.08 | 4249.81 | 4251.85 | 804.0 |
| 2014-02-23 18:00:00 | YM | Futures | 16508.0 | 16511.0 | 16498.7 | 16501.8 | 419.0 |
| 2014-02-23 19:00:00 | YM | Futures | 16499.8 | 16525.4 | 16495.7 | 16523.3 | 682.0 |
| 2014-02-23 20:00:00 | YM | Futures | 16523.3 | 16533.6 | 16498.7 | 16498.7 | 876.0 |
| 2014-02-23 21:00:00 | YM | Futures | 16498.7 | 16501.8 | 16468.0 | 16474.1 | 1312.0 |
| 2014-02-23 22:00:00 | YM | Futures | 16473.1 | 16486.4 | 16471.0 | 16475.1 | 469.0 |
| 2014-02-23 23:00:00 | YM | Futures | 16473.1 | 16478.2 | 16446.4 | 16456.7 | 1151.0 |
| 2014-02-23 18:00:00 | CL | Futures | 161.69 | 162.09 | 161.63 | 162.06 | 1205.0 |
| 2014-02-23 19:00:00 | CL | Futures | 162.06 | 162.34 | 162.04 | 162.23 | 1060.0 |
| 2014-02-23 20:00:00 | CL | Futures | 162.22 | 162.25 | 161.99 | 162.01 | 819.0 |
| 2014-02-23 21:00:00 | CL | Futures | 162.01 | 162.07 | 161.88 | 161.92 | 564.0 |
| 2014-02-23 22:00:00 | CL | Futures | 161.93 | 162.01 | 161.87 | 161.93 | 190.0 |
| 2014-02-23 23:00:00 | CL | Futures | 161.95 | 162.04 | 161.9 | 162.03 | 236.0 |
| 2014-02-23 18:00:00 | GC | Futures | 1815.4 | 1816.1 | 1812.1 | 1813.9 | 868.0 |
| 2014-02-23 19:00:00 | GC | Futures | 1813.7 | 1816.5 | 1813.5 | 1814.0 | 1360.0 |
| 2014-02-23 20:00:00 | GC | Futures | 1814.3 | 1815.0 | 1806.1 | 1810.4 | 6172.0 |
| 2014-02-23 21:00:00 | GC | Futures | 1810.4 | 1810.9 | 1808.3 | 1809.6 | 2143.0 |
| 2014-02-23 22:00:00 | GC | Futures | 1809.5 | 1810.4 | 1809.1 | 1810.2 | 1218.0 |
| 2014-02-23 23:00:00 | GC | Futures | 1810.2 | 1811.3 | 1807.8 | 1810.7 | 1071.0 |
| 2014-02-23 18:00:00 | ZN | Futures | 116.142707 | 116.157154 | 116.084917 | 116.128259 | 4461.0 |
| 2014-02-23 19:00:00 | ZN | Futures | 116.128259 | 116.157154 | 116.084917 | 116.099364 | 4942.0 |
| 2014-02-23 20:00:00 | ZN | Futures | 116.084917 | 116.200496 | 116.084917 | 116.200496 | 10385.0 |
| 2014-02-23 21:00:00 | ZN | Futures | 116.186049 | 116.272733 | 116.186049 | 116.258286 | 17930.0 |
| 2014-02-23 22:00:00 | ZN | Futures | 116.258286 | 116.272733 | 116.214944 | 116.243839 | 7256.0 |
| 2014-02-23 23:00:00 | ZN | Futures | 116.243839 | 116.272733 | 116.229391 | 116.243839 | 2693.0 |
> showing 36 of 262 rows — these rows as CSV