PREVIEW / futures_1hour / 2014-05-04
file: by_date/futures_1hour/2014/2014-05-04.parquet size: 14 KB rows: 261
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-05-04 18:00:00 | ES | Futures | 1948.05 | 1948.05 | 1945.46 | 1948.05 | 6860.0 |
| 2014-05-04 19:00:00 | ES | Futures | 1947.79 | 1948.57 | 1947.01 | 1947.27 | 2997.0 |
| 2014-05-04 20:00:00 | ES | Futures | 1947.53 | 1949.87 | 1947.53 | 1947.53 | 4442.0 |
| 2014-05-04 21:00:00 | ES | Futures | 1947.53 | 1947.79 | 1944.94 | 1945.72 | 4661.0 |
| 2014-05-04 22:00:00 | ES | Futures | 1945.72 | 1945.72 | 1943.64 | 1944.68 | 4428.0 |
| 2014-05-04 23:00:00 | ES | Futures | 1944.68 | 1945.72 | 1944.42 | 1944.68 | 1857.0 |
| 2014-05-04 18:00:00 | NQ | Futures | 4174.09 | 4175.25 | 4165.64 | 4172.05 | 996.0 |
| 2014-05-04 19:00:00 | NQ | Futures | 4172.05 | 4173.8 | 4170.01 | 4170.59 | 348.0 |
| 2014-05-04 20:00:00 | NQ | Futures | 4170.89 | 4174.67 | 4170.3 | 4171.18 | 692.0 |
| 2014-05-04 21:00:00 | NQ | Futures | 4170.89 | 4170.89 | 4165.93 | 4166.81 | 1011.0 |
| 2014-05-04 22:00:00 | NQ | Futures | 4166.81 | 4167.1 | 4162.73 | 4163.31 | 1017.0 |
| 2014-05-04 23:00:00 | NQ | Futures | 4163.6 | 4166.81 | 4163.31 | 4164.77 | 226.0 |
| 2014-05-04 18:00:00 | YM | Futures | 16940.2 | 16944.3 | 16923.7 | 16941.2 | 519.0 |
| 2014-05-04 19:00:00 | YM | Futures | 16941.2 | 16947.4 | 16936.0 | 16936.0 | 488.0 |
| 2014-05-04 20:00:00 | YM | Futures | 16938.1 | 16954.6 | 16938.1 | 16940.2 | 596.0 |
| 2014-05-04 21:00:00 | YM | Futures | 16939.1 | 16939.1 | 16920.6 | 16923.7 | 1072.0 |
| 2014-05-04 22:00:00 | YM | Futures | 16924.7 | 16924.7 | 16909.3 | 16915.4 | 688.0 |
| 2014-05-04 23:00:00 | YM | Futures | 16915.4 | 16924.7 | 16915.4 | 16918.5 | 246.0 |
| 2014-05-04 18:00:00 | CL | Futures | 160.33 | 160.39 | 159.91 | 159.99 | 1416.0 |
| 2014-05-04 19:00:00 | CL | Futures | 159.99 | 160.11 | 159.96 | 160.03 | 527.0 |
| 2014-05-04 20:00:00 | CL | Futures | 160.04 | 160.17 | 160.01 | 160.09 | 620.0 |
| 2014-05-04 21:00:00 | CL | Futures | 160.07 | 160.25 | 160.07 | 160.09 | 724.0 |
| 2014-05-04 22:00:00 | CL | Futures | 160.09 | 160.12 | 160.06 | 160.07 | 185.0 |
| 2014-05-04 23:00:00 | CL | Futures | 160.07 | 160.12 | 160.06 | 160.07 | 181.0 |
| 2014-05-04 18:00:00 | GC | Futures | 1782.1 | 1784.7 | 1780.4 | 1783.2 | 1302.0 |
| 2014-05-04 19:00:00 | GC | Futures | 1782.4 | 1783.1 | 1781.0 | 1781.7 | 400.0 |
| 2014-05-04 20:00:00 | GC | Futures | 1781.8 | 1786.8 | 1781.3 | 1785.8 | 1718.0 |
| 2014-05-04 21:00:00 | GC | Futures | 1785.8 | 1794.3 | 1785.7 | 1788.9 | 5865.0 |
| 2014-05-04 22:00:00 | GC | Futures | 1788.9 | 1793.3 | 1788.8 | 1791.3 | 2477.0 |
| 2014-05-04 23:00:00 | GC | Futures | 1791.4 | 1792.0 | 1788.0 | 1788.1 | 1533.0 |
| 2014-05-04 18:00:00 | ZN | Futures | 116.747889 | 116.747889 | 116.616235 | 116.630864 | 7925.0 |
| 2014-05-04 19:00:00 | ZN | Futures | 116.630864 | 116.674748 | 116.630864 | 116.674748 | 2410.0 |
| 2014-05-04 20:00:00 | ZN | Futures | 116.674748 | 116.704005 | 116.645492 | 116.704005 | 4180.0 |
| 2014-05-04 21:00:00 | ZN | Futures | 116.704005 | 116.806402 | 116.689376 | 116.806402 | 8474.0 |
| 2014-05-04 22:00:00 | ZN | Futures | 116.806402 | 116.894172 | 116.777146 | 116.850287 | 13064.0 |
| 2014-05-04 23:00:00 | ZN | Futures | 116.850287 | 116.850287 | 116.821031 | 116.850287 | 2264.0 |
> showing 36 of 261 rows — these rows as CSV