PREVIEW / futures_1hour / 2015-12-06
file: by_date/futures_1hour/2015/2015-12-06.parquet size: 14 KB rows: 267
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 |
|---|---|---|---|---|---|---|---|
| 2015-12-06 18:00:00 | ES | Futures | 2239.35 | 2239.88 | 2233.19 | 2235.6 | 7983.0 |
| 2015-12-06 19:00:00 | ES | Futures | 2235.34 | 2235.87 | 2232.93 | 2233.19 | 5022.0 |
| 2015-12-06 20:00:00 | ES | Futures | 2233.19 | 2234.26 | 2231.59 | 2232.93 | 4894.0 |
| 2015-12-06 21:00:00 | ES | Futures | 2232.93 | 2233.73 | 2231.59 | 2232.93 | 3261.0 |
| 2015-12-06 22:00:00 | ES | Futures | 2232.93 | 2234.8 | 2232.93 | 2234.0 | 2142.0 |
| 2015-12-06 23:00:00 | ES | Futures | 2234.0 | 2234.26 | 2232.66 | 2234.0 | 1603.0 |
| 2015-12-06 18:00:00 | NQ | Futures | 5599.23 | 5602.49 | 5585.89 | 5591.82 | 1183.0 |
| 2015-12-06 19:00:00 | NQ | Futures | 5592.12 | 5592.12 | 5585.0 | 5585.0 | 890.0 |
| 2015-12-06 20:00:00 | NQ | Futures | 5585.3 | 5588.26 | 5580.55 | 5583.52 | 959.0 |
| 2015-12-06 21:00:00 | NQ | Futures | 5583.22 | 5585.3 | 5581.74 | 5584.41 | 489.0 |
| 2015-12-06 22:00:00 | NQ | Futures | 5584.41 | 5588.26 | 5584.41 | 5586.19 | 253.0 |
| 2015-12-06 23:00:00 | NQ | Futures | 5587.08 | 5588.56 | 5583.82 | 5588.26 | 337.0 |
| 2015-12-06 18:00:00 | YM | Futures | 18906.6 | 18914.0 | 18854.7 | 18875.9 | 1399.0 |
| 2015-12-06 19:00:00 | YM | Futures | 18874.8 | 18879.1 | 18860.0 | 18862.1 | 796.0 |
| 2015-12-06 20:00:00 | YM | Futures | 18863.2 | 18871.7 | 18849.4 | 18856.8 | 651.0 |
| 2015-12-06 21:00:00 | YM | Futures | 18856.8 | 18864.2 | 18850.5 | 18857.9 | 377.0 |
| 2015-12-06 22:00:00 | YM | Futures | 18857.9 | 18871.7 | 18857.9 | 18866.4 | 363.0 |
| 2015-12-06 23:00:00 | YM | Futures | 18867.4 | 18867.4 | 18854.7 | 18865.3 | 218.0 |
| 2015-12-06 18:00:00 | CL | Futures | 54.99 | 55.06 | 53.75 | 54.27 | 6165.0 |
| 2015-12-06 19:00:00 | CL | Futures | 54.26 | 54.27 | 54.04 | 54.18 | 2461.0 |
| 2015-12-06 20:00:00 | CL | Futures | 54.18 | 54.4 | 54.14 | 54.34 | 2785.0 |
| 2015-12-06 21:00:00 | CL | Futures | 54.33 | 54.37 | 54.21 | 54.26 | 1016.0 |
| 2015-12-06 22:00:00 | CL | Futures | 54.26 | 54.29 | 54.19 | 54.21 | 741.0 |
| 2015-12-06 23:00:00 | CL | Futures | 54.19 | 54.3 | 54.15 | 54.27 | 762.0 |
| 2015-12-06 18:00:00 | GC | Futures | 1482.5 | 1482.8 | 1477.8 | 1478.7 | 2403.0 |
| 2015-12-06 19:00:00 | GC | Futures | 1478.5 | 1483.0 | 1478.5 | 1479.5 | 3087.0 |
| 2015-12-06 20:00:00 | GC | Futures | 1479.2 | 1483.3 | 1478.2 | 1482.6 | 4746.0 |
| 2015-12-06 21:00:00 | GC | Futures | 1482.8 | 1483.2 | 1480.4 | 1480.8 | 2560.0 |
| 2015-12-06 22:00:00 | GC | Futures | 1480.7 | 1482.2 | 1480.3 | 1480.8 | 1599.0 |
| 2015-12-06 23:00:00 | GC | Futures | 1481.0 | 1482.2 | 1480.3 | 1482.2 | 743.0 |
| 2015-12-06 18:00:00 | ZN | Futures | 122.148223 | 122.178398 | 122.118048 | 122.178398 | 51.0 |
| 2015-12-06 19:00:00 | ZN | Futures | 122.148223 | 122.16331 | 122.148223 | 122.148223 | 10.0 |
| 2015-12-06 20:00:00 | ZN | Futures | 122.133135 | 122.133135 | 122.087873 | 122.10296 | 21.0 |
| 2015-12-06 21:00:00 | ZN | Futures | 122.10296 | 122.10296 | 122.087873 | 122.087873 | 152.0 |
| 2015-12-06 22:00:00 | ZN | Futures | 122.10296 | 122.10296 | 122.087873 | 122.087873 | 9.0 |
| 2015-12-06 23:00:00 | ZN | Futures | 122.10296 | 122.10296 | 122.10296 | 122.10296 | 11.0 |
> showing 36 of 267 rows — these rows as CSV