PREVIEW / futures_1hour / 2014-07-13
file: by_date/futures_1hour/2014/2014-07-13.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-07-13 18:00:00 | ES | Futures | 2046.08 | 2048.69 | 2045.82 | 2047.38 | 5451.0 |
| 2014-07-13 19:00:00 | ES | Futures | 2047.38 | 2047.9 | 2046.6 | 2047.38 | 1927.0 |
| 2014-07-13 20:00:00 | ES | Futures | 2047.38 | 2048.95 | 2047.12 | 2048.69 | 3650.0 |
| 2014-07-13 21:00:00 | ES | Futures | 2048.69 | 2049.21 | 2047.9 | 2048.69 | 1951.0 |
| 2014-07-13 22:00:00 | ES | Futures | 2048.95 | 2048.95 | 2048.17 | 2048.17 | 1007.0 |
| 2014-07-13 23:00:00 | ES | Futures | 2048.43 | 2048.69 | 2047.64 | 2047.64 | 1866.0 |
| 2014-07-13 18:00:00 | NQ | Futures | 4553.09 | 4559.23 | 4552.8 | 4557.77 | 782.0 |
| 2014-07-13 19:00:00 | NQ | Futures | 4557.47 | 4558.64 | 4555.72 | 4557.77 | 240.0 |
| 2014-07-13 20:00:00 | NQ | Futures | 4557.77 | 4562.44 | 4557.47 | 4561.56 | 760.0 |
| 2014-07-13 21:00:00 | NQ | Futures | 4561.56 | 4562.44 | 4560.39 | 4561.85 | 584.0 |
| 2014-07-13 22:00:00 | NQ | Futures | 4561.85 | 4561.85 | 4558.64 | 4559.23 | 476.0 |
| 2014-07-13 23:00:00 | NQ | Futures | 4559.23 | 4560.1 | 4557.77 | 4558.06 | 281.0 |
| 2014-07-13 18:00:00 | YM | Futures | 17460.4 | 17486.3 | 17459.4 | 17473.8 | 594.0 |
| 2014-07-13 19:00:00 | YM | Futures | 17475.9 | 17482.1 | 17471.8 | 17474.9 | 211.0 |
| 2014-07-13 20:00:00 | YM | Futures | 17475.9 | 17489.4 | 17473.8 | 17486.3 | 491.0 |
| 2014-07-13 21:00:00 | YM | Futures | 17485.2 | 17491.4 | 17481.1 | 17489.4 | 446.0 |
| 2014-07-13 22:00:00 | YM | Futures | 17489.4 | 17490.4 | 17482.1 | 17483.2 | 133.0 |
| 2014-07-13 23:00:00 | YM | Futures | 17484.2 | 17488.3 | 17476.9 | 17478.0 | 419.0 |
| 2014-07-13 18:00:00 | CL | Futures | 163.4 | 164.2 | 163.37 | 164.02 | 2351.0 |
| 2014-07-13 19:00:00 | CL | Futures | 164.05 | 164.07 | 163.86 | 163.99 | 496.0 |
| 2014-07-13 20:00:00 | CL | Futures | 163.97 | 164.09 | 163.91 | 164.04 | 604.0 |
| 2014-07-13 21:00:00 | CL | Futures | 164.04 | 164.15 | 163.88 | 164.07 | 919.0 |
| 2014-07-13 22:00:00 | CL | Futures | 164.05 | 164.09 | 163.96 | 164.07 | 554.0 |
| 2014-07-13 23:00:00 | CL | Futures | 164.07 | 164.1 | 163.73 | 163.84 | 1231.0 |
| 2014-07-13 18:00:00 | GC | Futures | 1834.7 | 1836.6 | 1834.3 | 1835.4 | 1072.0 |
| 2014-07-13 19:00:00 | GC | Futures | 1835.4 | 1835.6 | 1834.1 | 1835.1 | 589.0 |
| 2014-07-13 20:00:00 | GC | Futures | 1835.0 | 1835.5 | 1833.2 | 1833.9 | 958.0 |
| 2014-07-13 21:00:00 | GC | Futures | 1834.0 | 1834.8 | 1831.4 | 1832.8 | 2995.0 |
| 2014-07-13 22:00:00 | GC | Futures | 1832.8 | 1833.2 | 1828.9 | 1829.8 | 3579.0 |
| 2014-07-13 23:00:00 | GC | Futures | 1830.0 | 1830.4 | 1824.6 | 1827.4 | 4441.0 |
| 2014-07-13 18:00:00 | ZN | Futures | 118.084918 | 118.099653 | 118.055448 | 118.099653 | 2252.0 |
| 2014-07-13 19:00:00 | ZN | Futures | 118.099653 | 118.114388 | 118.070183 | 118.070183 | 1214.0 |
| 2014-07-13 20:00:00 | ZN | Futures | 118.070183 | 118.070183 | 118.025979 | 118.040714 | 4355.0 |
| 2014-07-13 21:00:00 | ZN | Futures | 118.025979 | 118.040714 | 117.981774 | 117.996509 | 4998.0 |
| 2014-07-13 22:00:00 | ZN | Futures | 117.996509 | 118.040714 | 117.996509 | 118.025979 | 2353.0 |
| 2014-07-13 23:00:00 | ZN | Futures | 118.025979 | 118.025979 | 118.011244 | 118.011244 | 530.0 |
> showing 36 of 262 rows — these rows as CSV