PREVIEW / futures_1hour / 2013-11-17
file: by_date/futures_1hour/2013/2013-11-17.parquet size: 13 KB rows: 254
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-17 18:00:00 | ES | Futures | 1850.61 | 1851.9 | 1850.09 | 1850.09 | 7066.0 |
| 2013-11-17 19:00:00 | ES | Futures | 1850.09 | 1850.61 | 1848.54 | 1849.06 | 6182.0 |
| 2013-11-17 20:00:00 | ES | Futures | 1849.06 | 1849.58 | 1848.54 | 1849.32 | 3567.0 |
| 2013-11-17 21:00:00 | ES | Futures | 1849.58 | 1849.58 | 1848.54 | 1849.06 | 2203.0 |
| 2013-11-17 22:00:00 | ES | Futures | 1849.06 | 1849.83 | 1848.29 | 1848.54 | 4842.0 |
| 2013-11-17 23:00:00 | ES | Futures | 1848.8 | 1849.32 | 1847.77 | 1849.32 | 4911.0 |
| 2013-11-17 18:00:00 | NQ | Futures | 3969.05 | 3973.7 | 3968.47 | 3970.21 | 806.0 |
| 2013-11-17 19:00:00 | NQ | Futures | 3970.21 | 3970.5 | 3966.73 | 3967.6 | 742.0 |
| 2013-11-17 20:00:00 | NQ | Futures | 3967.6 | 3969.05 | 3966.44 | 3968.47 | 368.0 |
| 2013-11-17 21:00:00 | NQ | Futures | 3968.18 | 3969.05 | 3967.02 | 3967.89 | 273.0 |
| 2013-11-17 22:00:00 | NQ | Futures | 3967.89 | 3970.21 | 3966.73 | 3967.31 | 686.0 |
| 2013-11-17 23:00:00 | NQ | Futures | 3967.31 | 3968.18 | 3965.28 | 3967.89 | 597.0 |
| 2013-11-17 18:00:00 | YM | Futures | 16251.1 | 16261.3 | 16250.1 | 16250.1 | 514.0 |
| 2013-11-17 19:00:00 | YM | Futures | 16251.1 | 16253.1 | 16240.9 | 16242.9 | 1102.0 |
| 2013-11-17 20:00:00 | YM | Futures | 16242.9 | 16249.1 | 16239.9 | 16248.0 | 770.0 |
| 2013-11-17 21:00:00 | YM | Futures | 16248.0 | 16249.1 | 16240.9 | 16244.0 | 569.0 |
| 2013-11-17 22:00:00 | YM | Futures | 16242.9 | 16250.1 | 16239.9 | 16240.9 | 715.0 |
| 2013-11-17 23:00:00 | YM | Futures | 16240.9 | 16245.0 | 16235.8 | 16245.0 | 947.0 |
| 2013-11-17 18:00:00 | CL | Futures | 149.22 | 149.33 | 149.07 | 149.18 | 411.0 |
| 2013-11-17 19:00:00 | CL | Futures | 149.16 | 149.18 | 148.78 | 148.89 | 521.0 |
| 2013-11-17 20:00:00 | CL | Futures | 148.91 | 149.03 | 148.86 | 148.99 | 287.0 |
| 2013-11-17 21:00:00 | CL | Futures | 148.97 | 149.03 | 148.88 | 148.89 | 195.0 |
| 2013-11-17 22:00:00 | CL | Futures | 148.95 | 149.05 | 148.91 | 149.02 | 145.0 |
| 2013-11-17 23:00:00 | CL | Futures | 149.02 | 149.03 | 148.67 | 148.8 | 313.0 |
| 2013-11-17 18:00:00 | GC | Futures | 1766.8 | 1767.2 | 1764.7 | 1764.7 | 774.0 |
| 2013-11-17 19:00:00 | GC | Futures | 1764.7 | 1765.3 | 1762.9 | 1763.9 | 875.0 |
| 2013-11-17 20:00:00 | GC | Futures | 1764.0 | 1764.5 | 1759.9 | 1762.7 | 3264.0 |
| 2013-11-17 21:00:00 | GC | Futures | 1762.7 | 1763.4 | 1761.3 | 1761.7 | 971.0 |
| 2013-11-17 22:00:00 | GC | Futures | 1761.6 | 1764.5 | 1761.6 | 1764.2 | 748.0 |
| 2013-11-17 23:00:00 | GC | Futures | 1764.2 | 1764.6 | 1762.8 | 1763.2 | 578.0 |
| 2013-11-17 18:00:00 | ZN | Futures | 115.814627 | 115.843191 | 115.786062 | 115.814627 | 7040.0 |
| 2013-11-17 19:00:00 | ZN | Futures | 115.814627 | 115.886038 | 115.814627 | 115.843191 | 3839.0 |
| 2013-11-17 20:00:00 | ZN | Futures | 115.843191 | 115.843191 | 115.800344 | 115.800344 | 2996.0 |
| 2013-11-17 21:00:00 | ZN | Futures | 115.814627 | 115.814627 | 115.77178 | 115.786062 | 5531.0 |
| 2013-11-17 22:00:00 | ZN | Futures | 115.786062 | 115.90032 | 115.77178 | 115.871756 | 9897.0 |
| 2013-11-17 23:00:00 | ZN | Futures | 115.886038 | 115.928885 | 115.871756 | 115.914602 | 4208.0 |
> showing 36 of 254 rows — these rows as CSV