PREVIEW / futures_1hour / 2014-10-26
file: by_date/futures_1hour/2014/2014-10-26.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-10-26 18:00:00 | ES | Futures | 2054.09 | 2055.4 | 2053.56 | 2053.82 | 5865.0 |
| 2014-10-26 19:00:00 | ES | Futures | 2053.82 | 2056.97 | 2053.82 | 2056.18 | 5916.0 |
| 2014-10-26 20:00:00 | ES | Futures | 2056.44 | 2056.71 | 2054.35 | 2054.61 | 3346.0 |
| 2014-10-26 21:00:00 | ES | Futures | 2054.61 | 2055.13 | 2052.25 | 2052.51 | 6420.0 |
| 2014-10-26 22:00:00 | ES | Futures | 2052.78 | 2053.56 | 2051.2 | 2051.99 | 4850.0 |
| 2014-10-26 23:00:00 | ES | Futures | 2051.73 | 2053.56 | 2051.47 | 2053.3 | 1603.0 |
| 2014-10-26 18:00:00 | NQ | Futures | 4729.99 | 4733.51 | 4729.11 | 4730.58 | 604.0 |
| 2014-10-26 19:00:00 | NQ | Futures | 4730.28 | 4739.37 | 4730.28 | 4737.9 | 946.0 |
| 2014-10-26 20:00:00 | NQ | Futures | 4737.9 | 4738.49 | 4734.09 | 4735.27 | 874.0 |
| 2014-10-26 21:00:00 | NQ | Futures | 4735.27 | 4735.85 | 4729.41 | 4729.99 | 1008.0 |
| 2014-10-26 22:00:00 | NQ | Futures | 4729.7 | 4732.04 | 4727.65 | 4731.16 | 1302.0 |
| 2014-10-26 23:00:00 | NQ | Futures | 4730.58 | 4733.51 | 4730.28 | 4733.21 | 514.0 |
| 2014-10-26 18:00:00 | YM | Futures | 17411.9 | 17418.1 | 17400.4 | 17408.8 | 532.0 |
| 2014-10-26 19:00:00 | YM | Futures | 17408.8 | 17438.9 | 17405.6 | 17431.6 | 1265.0 |
| 2014-10-26 20:00:00 | YM | Futures | 17430.6 | 17433.7 | 17417.1 | 17419.2 | 585.0 |
| 2014-10-26 21:00:00 | YM | Futures | 17420.2 | 17422.3 | 17400.4 | 17403.6 | 785.0 |
| 2014-10-26 22:00:00 | YM | Futures | 17402.5 | 17407.7 | 17395.2 | 17397.3 | 525.0 |
| 2014-10-26 23:00:00 | YM | Futures | 17399.4 | 17411.9 | 17397.3 | 17411.9 | 441.0 |
| 2014-10-26 18:00:00 | CL | Futures | 136.72 | 136.77 | 136.33 | 136.38 | 871.0 |
| 2014-10-26 19:00:00 | CL | Futures | 136.4 | 136.53 | 136.3 | 136.35 | 450.0 |
| 2014-10-26 20:00:00 | CL | Futures | 136.35 | 136.43 | 136.06 | 136.38 | 1186.0 |
| 2014-10-26 21:00:00 | CL | Futures | 136.38 | 136.4 | 136.01 | 136.2 | 893.0 |
| 2014-10-26 22:00:00 | CL | Futures | 136.2 | 136.48 | 136.1 | 136.43 | 725.0 |
| 2014-10-26 23:00:00 | CL | Futures | 136.43 | 136.48 | 136.2 | 136.2 | 505.0 |
| 2014-10-26 18:00:00 | GC | Futures | 1684.5 | 1685.0 | 1680.2 | 1681.3 | 1235.0 |
| 2014-10-26 19:00:00 | GC | Futures | 1681.3 | 1681.8 | 1680.2 | 1681.1 | 555.0 |
| 2014-10-26 20:00:00 | GC | Futures | 1681.3 | 1684.8 | 1681.1 | 1684.5 | 1557.0 |
| 2014-10-26 21:00:00 | GC | Futures | 1684.5 | 1686.5 | 1684.5 | 1685.9 | 1915.0 |
| 2014-10-26 22:00:00 | GC | Futures | 1685.9 | 1686.1 | 1684.5 | 1685.7 | 1406.0 |
| 2014-10-26 23:00:00 | GC | Futures | 1685.7 | 1685.9 | 1684.5 | 1684.8 | 434.0 |
| 2014-10-26 18:00:00 | ZN | Futures | 120.153618 | 120.168404 | 120.0649 | 120.094473 | 5605.0 |
| 2014-10-26 19:00:00 | ZN | Futures | 120.079686 | 120.124045 | 120.050114 | 120.0649 | 4176.0 |
| 2014-10-26 20:00:00 | ZN | Futures | 120.079686 | 120.138832 | 120.079686 | 120.124045 | 6446.0 |
| 2014-10-26 21:00:00 | ZN | Futures | 120.124045 | 120.138832 | 120.094473 | 120.109259 | 3819.0 |
| 2014-10-26 22:00:00 | ZN | Futures | 120.109259 | 120.124045 | 120.094473 | 120.124045 | 2567.0 |
| 2014-10-26 23:00:00 | ZN | Futures | 120.124045 | 120.124045 | 120.050114 | 120.0649 | 2751.0 |
> showing 36 of 273 rows — these rows as CSV