PREVIEW / futures_1hour / 2014-06-22
file: by_date/futures_1hour/2014/2014-06-22.parquet size: 14 KB rows: 273
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-06-22 18:00:00 | ES | Futures | 2035.66 | 2036.7 | 2035.4 | 2036.18 | 2163.0 |
| 2014-06-22 19:00:00 | ES | Futures | 2036.18 | 2037.22 | 2035.92 | 2036.96 | 922.0 |
| 2014-06-22 20:00:00 | ES | Futures | 2036.96 | 2038.52 | 2036.96 | 2038.52 | 4874.0 |
| 2014-06-22 21:00:00 | ES | Futures | 2038.52 | 2042.95 | 2038.0 | 2041.13 | 16237.0 |
| 2014-06-22 22:00:00 | ES | Futures | 2040.87 | 2041.39 | 2040.35 | 2040.61 | 3376.0 |
| 2014-06-22 23:00:00 | ES | Futures | 2040.87 | 2040.87 | 2040.09 | 2040.35 | 2296.0 |
| 2014-06-22 18:00:00 | NQ | Futures | 4429.57 | 4429.86 | 4428.11 | 4428.69 | 357.0 |
| 2014-06-22 19:00:00 | NQ | Futures | 4428.69 | 4430.74 | 4428.11 | 4430.45 | 151.0 |
| 2014-06-22 20:00:00 | NQ | Futures | 4430.74 | 4434.83 | 4430.45 | 4434.54 | 433.0 |
| 2014-06-22 21:00:00 | NQ | Futures | 4434.54 | 4447.09 | 4433.37 | 4442.71 | 2449.0 |
| 2014-06-22 22:00:00 | NQ | Futures | 4442.42 | 4443.0 | 4440.96 | 4441.84 | 557.0 |
| 2014-06-22 23:00:00 | NQ | Futures | 4442.13 | 4442.42 | 4440.38 | 4440.67 | 399.0 |
| 2014-06-22 18:00:00 | YM | Futures | 17436.6 | 17441.8 | 17427.3 | 17435.6 | 214.0 |
| 2014-06-22 19:00:00 | YM | Futures | 17436.6 | 17445.9 | 17436.6 | 17441.8 | 139.0 |
| 2014-06-22 20:00:00 | YM | Futures | 17442.8 | 17454.2 | 17442.8 | 17453.2 | 563.0 |
| 2014-06-22 21:00:00 | YM | Futures | 17452.1 | 17494.5 | 17450.0 | 17484.2 | 3151.0 |
| 2014-06-22 22:00:00 | YM | Futures | 17483.2 | 17484.2 | 17475.9 | 17476.9 | 841.0 |
| 2014-06-22 23:00:00 | YM | Futures | 17478.0 | 17478.0 | 17472.8 | 17474.9 | 416.0 |
| 2014-06-22 18:00:00 | CL | Futures | 174.73 | 174.77 | 174.01 | 174.37 | 2930.0 |
| 2014-06-22 19:00:00 | CL | Futures | 174.33 | 174.4 | 174.17 | 174.22 | 353.0 |
| 2014-06-22 20:00:00 | CL | Futures | 174.22 | 174.48 | 174.22 | 174.4 | 421.0 |
| 2014-06-22 21:00:00 | CL | Futures | 174.4 | 174.42 | 174.12 | 174.24 | 854.0 |
| 2014-06-22 22:00:00 | CL | Futures | 174.22 | 174.43 | 174.19 | 174.33 | 584.0 |
| 2014-06-22 23:00:00 | CL | Futures | 174.33 | 174.4 | 174.17 | 174.3 | 486.0 |
| 2014-06-22 18:00:00 | GC | Futures | 1801.0 | 1802.4 | 1799.8 | 1800.0 | 847.0 |
| 2014-06-22 19:00:00 | GC | Futures | 1800.0 | 1801.0 | 1799.1 | 1800.3 | 870.0 |
| 2014-06-22 20:00:00 | GC | Futures | 1800.4 | 1800.7 | 1798.8 | 1799.2 | 1989.0 |
| 2014-06-22 21:00:00 | GC | Futures | 1798.9 | 1799.2 | 1795.0 | 1797.6 | 3821.0 |
| 2014-06-22 22:00:00 | GC | Futures | 1797.4 | 1799.5 | 1797.2 | 1798.7 | 2480.0 |
| 2014-06-22 23:00:00 | GC | Futures | 1798.8 | 1798.8 | 1797.6 | 1798.7 | 1056.0 |
| 2014-06-22 18:00:00 | ZN | Futures | 117.289237 | 117.303972 | 117.259768 | 117.259768 | 2294.0 |
| 2014-06-22 19:00:00 | ZN | Futures | 117.259768 | 117.303972 | 117.245033 | 117.274502 | 2624.0 |
| 2014-06-22 20:00:00 | ZN | Futures | 117.274502 | 117.274502 | 117.200828 | 117.245033 | 5211.0 |
| 2014-06-22 21:00:00 | ZN | Futures | 117.245033 | 117.245033 | 117.156624 | 117.186094 | 14626.0 |
| 2014-06-22 22:00:00 | ZN | Futures | 117.171359 | 117.186094 | 117.156624 | 117.171359 | 2348.0 |
| 2014-06-22 23:00:00 | ZN | Futures | 117.171359 | 117.215563 | 117.171359 | 117.200828 | 1867.0 |
> showing 36 of 273 rows — these rows as CSV