PREVIEW / futures_1hour / 2014-03-02
file: by_date/futures_1hour/2014/2014-03-02.parquet size: 14 KB rows: 280
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-02 18:00:00 | ES | Futures | 1909.9 | 1910.93 | 1903.69 | 1906.02 | 57776.0 |
| 2014-03-02 19:00:00 | ES | Futures | 1906.02 | 1906.27 | 1900.07 | 1901.1 | 30637.0 |
| 2014-03-02 20:00:00 | ES | Futures | 1901.1 | 1906.02 | 1900.84 | 1904.98 | 16809.0 |
| 2014-03-02 21:00:00 | ES | Futures | 1904.98 | 1908.6 | 1904.21 | 1908.09 | 9760.0 |
| 2014-03-02 22:00:00 | ES | Futures | 1908.34 | 1908.34 | 1904.72 | 1906.02 | 8606.0 |
| 2014-03-02 23:00:00 | ES | Futures | 1906.27 | 1907.05 | 1903.17 | 1906.79 | 5389.0 |
| 2014-03-02 18:00:00 | NQ | Futures | 4276.55 | 4276.55 | 4258.24 | 4262.6 | 7130.0 |
| 2014-03-02 19:00:00 | NQ | Futures | 4262.6 | 4263.47 | 4246.61 | 4249.52 | 3602.0 |
| 2014-03-02 20:00:00 | NQ | Futures | 4250.39 | 4262.31 | 4250.1 | 4259.69 | 2180.0 |
| 2014-03-02 21:00:00 | NQ | Futures | 4259.98 | 4267.54 | 4258.24 | 4266.67 | 1047.0 |
| 2014-03-02 22:00:00 | NQ | Futures | 4266.67 | 4266.67 | 4258.53 | 4262.02 | 843.0 |
| 2014-03-02 23:00:00 | NQ | Futures | 4262.31 | 4265.22 | 4255.62 | 4263.47 | 890.0 |
| 2014-03-02 18:00:00 | YM | Futures | 16637.2 | 16640.2 | 16576.7 | 16598.2 | 3098.0 |
| 2014-03-02 19:00:00 | YM | Futures | 16599.2 | 16604.3 | 16556.2 | 16565.4 | 2112.0 |
| 2014-03-02 20:00:00 | YM | Futures | 16566.4 | 16607.4 | 16566.4 | 16597.2 | 1249.0 |
| 2014-03-02 21:00:00 | YM | Futures | 16598.2 | 16627.9 | 16591.0 | 16625.9 | 826.0 |
| 2014-03-02 22:00:00 | YM | Futures | 16625.9 | 16625.9 | 16594.1 | 16607.4 | 782.0 |
| 2014-03-02 23:00:00 | YM | Futures | 16607.4 | 16616.7 | 16582.8 | 16613.6 | 669.0 |
| 2014-03-02 18:00:00 | CL | Futures | 162.82 | 165.33 | 162.74 | 165.16 | 9146.0 |
| 2014-03-02 19:00:00 | CL | Futures | 165.17 | 165.42 | 164.67 | 164.68 | 4363.0 |
| 2014-03-02 20:00:00 | CL | Futures | 164.68 | 164.73 | 164.07 | 164.08 | 2463.0 |
| 2014-03-02 21:00:00 | CL | Futures | 164.07 | 164.13 | 163.92 | 164.0 | 1756.0 |
| 2014-03-02 22:00:00 | CL | Futures | 164.02 | 164.13 | 164.02 | 164.07 | 810.0 |
| 2014-03-02 23:00:00 | CL | Futures | 164.05 | 164.19 | 164.02 | 164.07 | 746.0 |
| 2014-03-02 18:00:00 | GC | Futures | 1824.8 | 1833.2 | 1822.5 | 1833.2 | 7298.0 |
| 2014-03-02 19:00:00 | GC | Futures | 1833.0 | 1840.4 | 1830.0 | 1835.6 | 5555.0 |
| 2014-03-02 20:00:00 | GC | Futures | 1835.8 | 1840.7 | 1833.7 | 1839.9 | 6409.0 |
| 2014-03-02 21:00:00 | GC | Futures | 1839.8 | 1842.1 | 1837.2 | 1839.1 | 3827.0 |
| 2014-03-02 22:00:00 | GC | Futures | 1839.2 | 1841.1 | 1837.7 | 1839.3 | 2079.0 |
| 2014-03-02 23:00:00 | GC | Futures | 1839.5 | 1839.8 | 1837.2 | 1838.0 | 1118.0 |
| 2014-03-02 18:00:00 | ZN | Futures | 117.18292 | 117.197367 | 116.980656 | 117.038446 | 4642.0 |
| 2014-03-02 19:00:00 | ZN | Futures | 117.038446 | 117.12513 | 117.009551 | 117.096236 | 1850.0 |
| 2014-03-02 20:00:00 | ZN | Futures | 117.081788 | 117.081788 | 117.009551 | 117.023999 | 936.0 |
| 2014-03-02 21:00:00 | ZN | Futures | 117.038446 | 117.067341 | 116.995104 | 116.995104 | 1235.0 |
| 2014-03-02 22:00:00 | ZN | Futures | 116.980656 | 117.023999 | 116.966209 | 116.980656 | 312.0 |
| 2014-03-02 23:00:00 | ZN | Futures | 116.966209 | 117.023999 | 116.951761 | 116.951761 | 142.0 |
> showing 36 of 280 rows — these rows as CSV