PREVIEW / futures_1hour / 2014-03-16
file: by_date/futures_1hour/2014/2014-03-16.parquet size: 13 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-03-16 18:00:00 | ES | Futures | 1903.13 | 1905.21 | 1894.04 | 1898.2 | 22479.0 |
| 2014-03-16 19:00:00 | ES | Futures | 1898.46 | 1901.57 | 1897.68 | 1901.05 | 6219.0 |
| 2014-03-16 20:00:00 | ES | Futures | 1901.31 | 1903.65 | 1900.27 | 1903.39 | 8963.0 |
| 2014-03-16 21:00:00 | ES | Futures | 1903.65 | 1904.95 | 1901.05 | 1902.35 | 11036.0 |
| 2014-03-16 22:00:00 | ES | Futures | 1902.35 | 1904.69 | 1901.83 | 1903.65 | 4901.0 |
| 2014-03-16 23:00:00 | ES | Futures | 1903.91 | 1904.95 | 1901.83 | 1904.69 | 4408.0 |
| 2014-03-16 18:00:00 | NQ | Futures | 4218.65 | 4221.27 | 4195.93 | 4203.79 | 3338.0 |
| 2014-03-16 19:00:00 | NQ | Futures | 4203.79 | 4211.37 | 4202.34 | 4210.78 | 1016.0 |
| 2014-03-16 20:00:00 | NQ | Futures | 4210.78 | 4217.48 | 4209.62 | 4217.19 | 1734.0 |
| 2014-03-16 21:00:00 | NQ | Futures | 4216.9 | 4220.39 | 4209.91 | 4211.95 | 2043.0 |
| 2014-03-16 22:00:00 | NQ | Futures | 4211.95 | 4218.65 | 4211.07 | 4216.9 | 811.0 |
| 2014-03-16 23:00:00 | NQ | Futures | 4217.19 | 4218.65 | 4212.82 | 4217.48 | 876.0 |
| 2014-03-16 18:00:00 | YM | Futures | 16468.5 | 16476.7 | 16386.1 | 16416.0 | 2529.0 |
| 2014-03-16 19:00:00 | YM | Futures | 16414.9 | 16441.7 | 16408.8 | 16440.7 | 904.0 |
| 2014-03-16 20:00:00 | YM | Futures | 16441.7 | 16461.3 | 16435.5 | 16460.2 | 1556.0 |
| 2014-03-16 21:00:00 | YM | Futures | 16458.2 | 16473.6 | 16443.8 | 16453.0 | 1588.0 |
| 2014-03-16 22:00:00 | YM | Futures | 16451.0 | 16473.6 | 16448.9 | 16466.4 | 648.0 |
| 2014-03-16 23:00:00 | YM | Futures | 16467.5 | 16474.7 | 16452.0 | 16471.6 | 498.0 |
| 2014-03-16 18:00:00 | CL | Futures | 156.77 | 157.09 | 156.5 | 156.59 | 520.0 |
| 2014-03-16 19:00:00 | CL | Futures | 156.59 | 156.59 | 156.51 | 156.56 | 80.0 |
| 2014-03-16 20:00:00 | CL | Futures | 156.55 | 156.59 | 156.5 | 156.55 | 178.0 |
| 2014-03-16 21:00:00 | CL | Futures | 156.55 | 156.59 | 156.47 | 156.48 | 132.0 |
| 2014-03-16 22:00:00 | CL | Futures | 156.51 | 156.58 | 156.4 | 156.55 | 260.0 |
| 2014-03-16 23:00:00 | CL | Futures | 156.53 | 156.58 | 156.53 | 156.58 | 37.0 |
| 2014-03-16 18:00:00 | GC | Futures | 1894.3 | 1907.3 | 1893.9 | 1904.0 | 4645.0 |
| 2014-03-16 19:00:00 | GC | Futures | 1903.7 | 1903.7 | 1898.5 | 1899.5 | 1789.0 |
| 2014-03-16 20:00:00 | GC | Futures | 1899.7 | 1902.2 | 1896.9 | 1897.1 | 2024.0 |
| 2014-03-16 21:00:00 | GC | Futures | 1897.0 | 1897.3 | 1889.6 | 1894.7 | 6594.0 |
| 2014-03-16 22:00:00 | GC | Futures | 1894.5 | 1895.1 | 1892.3 | 1892.9 | 1792.0 |
| 2014-03-16 23:00:00 | GC | Futures | 1892.9 | 1895.1 | 1892.1 | 1893.9 | 1261.0 |
| 2014-03-16 18:00:00 | ZN | Futures | 116.645492 | 116.747889 | 116.586979 | 116.689376 | 9271.0 |
| 2014-03-16 19:00:00 | ZN | Futures | 116.704005 | 116.762518 | 116.704005 | 116.747889 | 3416.0 |
| 2014-03-16 20:00:00 | ZN | Futures | 116.747889 | 116.747889 | 116.718633 | 116.733261 | 5745.0 |
| 2014-03-16 21:00:00 | ZN | Futures | 116.733261 | 116.762518 | 116.645492 | 116.689376 | 9595.0 |
| 2014-03-16 22:00:00 | ZN | Futures | 116.689376 | 116.704005 | 116.645492 | 116.674748 | 3599.0 |
| 2014-03-16 23:00:00 | ZN | Futures | 116.674748 | 116.704005 | 116.66012 | 116.674748 | 3251.0 |
> showing 36 of 261 rows — these rows as CSV