PREVIEW / futures_1hour / 2015-12-20
file: by_date/futures_1hour/2015/2015-12-20.parquet size: 14 KB rows: 269
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-20 18:00:00 | ES | Futures | 2146.72 | 2150.75 | 2145.37 | 2147.79 | 12968.0 |
| 2015-12-20 19:00:00 | ES | Futures | 2147.79 | 2150.21 | 2144.84 | 2145.91 | 9538.0 |
| 2015-12-20 20:00:00 | ES | Futures | 2145.91 | 2147.79 | 2144.57 | 2147.52 | 6131.0 |
| 2015-12-20 21:00:00 | ES | Futures | 2147.25 | 2149.13 | 2146.72 | 2148.87 | 5412.0 |
| 2015-12-20 22:00:00 | ES | Futures | 2149.13 | 2149.94 | 2148.33 | 2149.13 | 3857.0 |
| 2015-12-20 23:00:00 | ES | Futures | 2149.13 | 2150.21 | 2148.33 | 2149.13 | 2693.0 |
| 2015-12-20 18:00:00 | NQ | Futures | 5361.1 | 5372.68 | 5359.02 | 5365.55 | 1374.0 |
| 2015-12-20 19:00:00 | NQ | Futures | 5366.14 | 5373.27 | 5360.8 | 5364.36 | 2453.0 |
| 2015-12-20 20:00:00 | NQ | Futures | 5363.77 | 5369.11 | 5360.2 | 5367.33 | 1399.0 |
| 2015-12-20 21:00:00 | NQ | Futures | 5367.63 | 5371.49 | 5364.96 | 5371.19 | 945.0 |
| 2015-12-20 22:00:00 | NQ | Futures | 5371.19 | 5375.35 | 5370.3 | 5373.27 | 727.0 |
| 2015-12-20 23:00:00 | NQ | Futures | 5372.97 | 5375.65 | 5371.19 | 5372.97 | 475.0 |
| 2015-12-20 18:00:00 | YM | Futures | 18141.9 | 18185.5 | 18140.8 | 18162.1 | 1718.0 |
| 2015-12-20 19:00:00 | YM | Futures | 18162.1 | 18180.2 | 18136.6 | 18146.2 | 2257.0 |
| 2015-12-20 20:00:00 | YM | Futures | 18144.0 | 18168.5 | 18133.4 | 18163.2 | 1437.0 |
| 2015-12-20 21:00:00 | YM | Futures | 18164.3 | 18172.8 | 18153.6 | 18171.7 | 961.0 |
| 2015-12-20 22:00:00 | YM | Futures | 18171.7 | 18184.5 | 18167.5 | 18181.3 | 1126.0 |
| 2015-12-20 23:00:00 | YM | Futures | 18180.2 | 18186.6 | 18171.7 | 18179.2 | 539.0 |
| 2015-12-20 18:00:00 | CL | Futures | 47.08 | 47.27 | 46.63 | 46.89 | 2594.0 |
| 2015-12-20 19:00:00 | CL | Futures | 46.89 | 47.1 | 46.88 | 46.92 | 1875.0 |
| 2015-12-20 20:00:00 | CL | Futures | 46.92 | 47.05 | 46.85 | 47.0 | 1804.0 |
| 2015-12-20 21:00:00 | CL | Futures | 46.99 | 47.0 | 46.83 | 46.91 | 1601.0 |
| 2015-12-20 22:00:00 | CL | Futures | 46.92 | 47.09 | 46.91 | 47.01 | 1771.0 |
| 2015-12-20 23:00:00 | CL | Futures | 47.01 | 47.01 | 46.79 | 46.84 | 1445.0 |
| 2015-12-20 18:00:00 | GC | Futures | 1454.8 | 1455.7 | 1452.6 | 1453.8 | 1229.0 |
| 2015-12-20 19:00:00 | GC | Futures | 1453.9 | 1454.8 | 1451.9 | 1452.8 | 935.0 |
| 2015-12-20 20:00:00 | GC | Futures | 1452.8 | 1459.9 | 1452.6 | 1458.9 | 3170.0 |
| 2015-12-20 21:00:00 | GC | Futures | 1458.7 | 1459.3 | 1456.8 | 1458.6 | 1664.0 |
| 2015-12-20 22:00:00 | GC | Futures | 1458.7 | 1460.4 | 1457.9 | 1459.0 | 1428.0 |
| 2015-12-20 23:00:00 | GC | Futures | 1458.9 | 1459.3 | 1458.0 | 1458.6 | 705.0 |
| 2015-12-20 18:00:00 | ZN | Futures | 122.661056 | 122.706536 | 122.661056 | 122.691376 | 1729.0 |
| 2015-12-20 19:00:00 | ZN | Futures | 122.706536 | 122.706536 | 122.661056 | 122.691376 | 3815.0 |
| 2015-12-20 20:00:00 | ZN | Futures | 122.706536 | 122.706536 | 122.661056 | 122.676216 | 4191.0 |
| 2015-12-20 21:00:00 | ZN | Futures | 122.676216 | 122.676216 | 122.645895 | 122.661056 | 1968.0 |
| 2015-12-20 22:00:00 | ZN | Futures | 122.661056 | 122.676216 | 122.645895 | 122.645895 | 2615.0 |
| 2015-12-20 23:00:00 | ZN | Futures | 122.645895 | 122.661056 | 122.645895 | 122.661056 | 1836.0 |
> showing 36 of 269 rows — these rows as CSV