PREVIEW / futures_1hour / 2017-04-09
file: by_date/futures_1hour/2017/2017-04-09.parquet size: 15 KB rows: 296
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-09 18:00:00 | ES | Futures | 2569.46 | 2571.64 | 2568.36 | 2571.37 | 7925.0 |
| 2017-04-09 19:00:00 | ES | Futures | 2571.09 | 2571.64 | 2570.28 | 2570.82 | 2580.0 |
| 2017-04-09 20:00:00 | ES | Futures | 2570.82 | 2575.19 | 2570.55 | 2574.65 | 11049.0 |
| 2017-04-09 21:00:00 | ES | Futures | 2574.37 | 2577.38 | 2573.55 | 2574.37 | 13322.0 |
| 2017-04-09 22:00:00 | ES | Futures | 2574.37 | 2574.92 | 2573.28 | 2573.83 | 3594.0 |
| 2017-04-09 23:00:00 | ES | Futures | 2573.83 | 2575.19 | 2573.83 | 2574.92 | 2524.0 |
| 2017-04-09 18:00:00 | NQ | Futures | 6464.57 | 6470.24 | 6460.1 | 6469.64 | 1090.0 |
| 2017-04-09 19:00:00 | NQ | Futures | 6469.94 | 6470.54 | 6465.47 | 6465.47 | 755.0 |
| 2017-04-09 20:00:00 | NQ | Futures | 6465.47 | 6475.01 | 6465.17 | 6473.52 | 2011.0 |
| 2017-04-09 21:00:00 | NQ | Futures | 6473.52 | 6480.08 | 6471.13 | 6472.92 | 2026.0 |
| 2017-04-09 22:00:00 | NQ | Futures | 6472.92 | 6474.11 | 6469.94 | 6471.13 | 662.0 |
| 2017-04-09 23:00:00 | NQ | Futures | 6471.43 | 6473.82 | 6471.13 | 6473.52 | 360.0 |
| 2017-04-09 18:00:00 | YM | Futures | 22397.7 | 22406.4 | 22381.4 | 22404.2 | 1041.0 |
| 2017-04-09 19:00:00 | YM | Futures | 22404.2 | 22408.5 | 22397.7 | 22397.7 | 543.0 |
| 2017-04-09 20:00:00 | YM | Futures | 22396.6 | 22433.5 | 22396.6 | 22428.1 | 1949.0 |
| 2017-04-09 21:00:00 | YM | Futures | 22427.0 | 22452.0 | 22418.3 | 22427.0 | 2075.0 |
| 2017-04-09 22:00:00 | YM | Futures | 22427.0 | 22431.4 | 22417.2 | 22421.6 | 668.0 |
| 2017-04-09 23:00:00 | YM | Futures | 22421.6 | 22430.3 | 22420.5 | 22428.1 | 440.0 |
| 2017-04-09 18:00:00 | CL | Futures | 48.59 | 48.88 | 48.57 | 48.77 | 4058.0 |
| 2017-04-09 19:00:00 | CL | Futures | 48.77 | 48.78 | 48.67 | 48.74 | 2256.0 |
| 2017-04-09 20:00:00 | CL | Futures | 48.74 | 48.8 | 48.71 | 48.76 | 2476.0 |
| 2017-04-09 21:00:00 | CL | Futures | 48.77 | 48.77 | 48.59 | 48.64 | 4963.0 |
| 2017-04-09 22:00:00 | CL | Futures | 48.64 | 48.68 | 48.6 | 48.64 | 2308.0 |
| 2017-04-09 23:00:00 | CL | Futures | 48.64 | 48.7 | 48.6 | 48.68 | 1987.0 |
| 2017-04-09 18:00:00 | GC | Futures | 1685.6 | 1687.5 | 1685.0 | 1686.3 | 2640.0 |
| 2017-04-09 19:00:00 | GC | Futures | 1686.2 | 1688.2 | 1685.5 | 1687.1 | 3758.0 |
| 2017-04-09 20:00:00 | GC | Futures | 1687.3 | 1687.4 | 1684.4 | 1684.8 | 4959.0 |
| 2017-04-09 21:00:00 | GC | Futures | 1684.7 | 1684.8 | 1682.6 | 1683.9 | 7997.0 |
| 2017-04-09 22:00:00 | GC | Futures | 1683.9 | 1684.7 | 1682.8 | 1684.6 | 3767.0 |
| 2017-04-09 23:00:00 | GC | Futures | 1684.6 | 1684.8 | 1683.8 | 1684.7 | 1759.0 |
| 2017-04-09 18:00:00 | ZN | Futures | 123.764347 | 123.779846 | 123.671349 | 123.702348 | 13560.0 |
| 2017-04-09 19:00:00 | ZN | Futures | 123.702348 | 123.764347 | 123.686849 | 123.748847 | 9522.0 |
| 2017-04-09 20:00:00 | ZN | Futures | 123.748847 | 123.748847 | 123.65585 | 123.686849 | 20342.0 |
| 2017-04-09 21:00:00 | ZN | Futures | 123.686849 | 123.702348 | 123.64035 | 123.65585 | 16966.0 |
| 2017-04-09 22:00:00 | ZN | Futures | 123.65585 | 123.686849 | 123.62485 | 123.686849 | 13369.0 |
| 2017-04-09 23:00:00 | ZN | Futures | 123.686849 | 123.702348 | 123.671349 | 123.702348 | 5583.0 |
> showing 36 of 296 rows — these rows as CSV