PREVIEW / futures_30min / 2014-02-16
file: by_date/futures_30min/2014/2014-02-16.parquet size: 18 KB rows: 436
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 | 1899.81 | 1896.96 | 1899.29 | 4346.0 |
| 2014-02-16 18:30:00 | ES | Futures | 1899.55 | 1900.58 | 1898.77 | 1898.77 | 2502.0 |
| 2014-02-16 19:00:00 | ES | Futures | 1899.03 | 1899.55 | 1895.41 | 1895.93 | 5043.0 |
| 2014-02-16 19:30:00 | ES | Futures | 1895.93 | 1896.7 | 1895.15 | 1895.67 | 2633.0 |
| 2014-02-16 20:00:00 | ES | Futures | 1895.93 | 1898.26 | 1895.67 | 1897.74 | 2672.0 |
| 2014-02-16 20:30:00 | ES | Futures | 1897.74 | 1898.52 | 1896.96 | 1898.52 | 1154.0 |
| 2014-02-16 21:00:00 | ES | Futures | 1898.26 | 1898.52 | 1897.48 | 1898.0 | 1208.0 |
| 2014-02-16 21:30:00 | ES | Futures | 1898.0 | 1898.0 | 1896.19 | 1897.22 | 860.0 |
| 2014-02-16 22:00:00 | ES | Futures | 1897.22 | 1897.48 | 1896.45 | 1897.22 | 532.0 |
| 2014-02-16 22:30:00 | ES | Futures | 1896.96 | 1898.0 | 1896.96 | 1897.22 | 1194.0 |
| 2014-02-16 23:00:00 | ES | Futures | 1897.48 | 1898.0 | 1896.96 | 1897.22 | 612.0 |
| 2014-02-16 23:30:00 | ES | Futures | 1896.96 | 1897.22 | 1896.45 | 1897.22 | 617.0 |
| 2014-02-16 18:00:00 | NQ | Futures | 4255.62 | 4259.69 | 4253.88 | 4259.4 | 273.0 |
| 2014-02-16 18:30:00 | NQ | Futures | 4258.82 | 4260.86 | 4258.82 | 4258.82 | 212.0 |
| 2014-02-16 19:00:00 | NQ | Futures | 4258.53 | 4259.98 | 4251.85 | 4253.3 | 571.0 |
| 2014-02-16 19:30:00 | NQ | Futures | 4253.3 | 4254.46 | 4251.55 | 4252.43 | 572.0 |
| 2014-02-16 20:00:00 | NQ | Futures | 4252.72 | 4257.95 | 4252.72 | 4257.08 | 412.0 |
| 2014-02-16 20:30:00 | NQ | Futures | 4256.79 | 4258.24 | 4255.04 | 4258.24 | 292.0 |
| 2014-02-16 21:00:00 | NQ | Futures | 4257.95 | 4258.53 | 4256.5 | 4257.08 | 281.0 |
| 2014-02-16 21:30:00 | NQ | Futures | 4257.37 | 4257.66 | 4255.04 | 4256.5 | 149.0 |
| 2014-02-16 22:00:00 | NQ | Futures | 4256.5 | 4256.79 | 4255.04 | 4256.79 | 77.0 |
| 2014-02-16 22:30:00 | NQ | Futures | 4256.79 | 4258.24 | 4255.92 | 4257.37 | 141.0 |
| 2014-02-16 23:00:00 | NQ | Futures | 4257.66 | 4258.24 | 4255.92 | 4256.21 | 133.0 |
| 2014-02-16 23:30:00 | NQ | Futures | 4255.62 | 4255.62 | 4253.88 | 4255.33 | 139.0 |
| 2014-02-16 18:00:00 | YM | Futures | 16529.5 | 16545.9 | 16529.5 | 16543.9 | 262.0 |
| 2014-02-16 18:30:00 | YM | Futures | 16543.9 | 16555.1 | 16535.6 | 16535.6 | 410.0 |
| 2014-02-16 19:00:00 | YM | Futures | 16536.7 | 16541.8 | 16512.1 | 16516.2 | 776.0 |
| 2014-02-16 19:30:00 | YM | Futures | 16516.2 | 16520.3 | 16509.0 | 16512.1 | 609.0 |
| 2014-02-16 20:00:00 | YM | Futures | 16514.1 | 16536.7 | 16514.1 | 16530.5 | 761.0 |
| 2014-02-16 20:30:00 | YM | Futures | 16531.5 | 16538.7 | 16524.4 | 16537.7 | 341.0 |
| 2014-02-16 21:00:00 | YM | Futures | 16536.7 | 16537.7 | 16528.5 | 16531.5 | 257.0 |
| 2014-02-16 21:30:00 | YM | Futures | 16532.6 | 16532.6 | 16519.2 | 16527.4 | 309.0 |
| 2014-02-16 22:00:00 | YM | Futures | 16528.5 | 16529.5 | 16521.3 | 16525.4 | 241.0 |
| 2014-02-16 22:30:00 | YM | Futures | 16525.4 | 16533.6 | 16523.3 | 16527.4 | 319.0 |
| 2014-02-16 23:00:00 | YM | Futures | 16529.5 | 16533.6 | 16524.4 | 16524.4 | 137.0 |
| 2014-02-16 23:30:00 | YM | Futures | 16525.4 | 16525.4 | 16517.2 | 16522.3 | 225.0 |
| 2014-02-16 18:00:00 | CL | Futures | 158.26 | 159.45 | 158.15 | 158.99 | 660.0 |
| 2014-02-16 18:30:00 | CL | Futures | 158.94 | 159.07 | 158.77 | 158.98 | 163.0 |
| 2014-02-16 19:00:00 | CL | Futures | 159.01 | 159.01 | 158.75 | 158.85 | 95.0 |
| 2014-02-16 19:30:00 | CL | Futures | 158.85 | 158.85 | 158.56 | 158.6 | 137.0 |
| 2014-02-16 20:00:00 | CL | Futures | 158.58 | 158.75 | 158.56 | 158.56 | 194.0 |
| 2014-02-16 20:30:00 | CL | Futures | 158.58 | 158.67 | 158.56 | 158.61 | 106.0 |
| 2014-02-16 21:00:00 | CL | Futures | 158.6 | 158.71 | 158.6 | 158.64 | 64.0 |
| 2014-02-16 21:30:00 | CL | Futures | 158.63 | 158.63 | 158.44 | 158.53 | 103.0 |
| 2014-02-16 22:00:00 | CL | Futures | 158.55 | 158.67 | 158.44 | 158.66 | 148.0 |
| 2014-02-16 22:30:00 | CL | Futures | 158.63 | 158.69 | 158.55 | 158.61 | 135.0 |
| 2014-02-16 23:00:00 | CL | Futures | 158.6 | 158.61 | 158.55 | 158.55 | 54.0 |
| 2014-02-16 23:30:00 | CL | Futures | 158.58 | 158.61 | 158.5 | 158.61 | 44.0 |
| 2014-02-16 18:00:00 | GC | Futures | 1805.9 | 1811.1 | 1805.9 | 1810.9 | 1379.0 |
| 2014-02-16 18:30:00 | GC | Futures | 1811.0 | 1813.5 | 1810.7 | 1812.6 | 1806.0 |
> showing 50 of 436 rows — these rows as CSV