PREVIEW / futures_1hour / 2015-12-13
file: by_date/futures_1hour/2015/2015-12-13.parquet size: 14 KB rows: 277
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-13 18:00:00 | ES | Futures | 2149.18 | 2155.86 | 2149.18 | 2153.72 | 8906.0 |
| 2015-12-13 19:00:00 | ES | Futures | 2153.99 | 2155.06 | 2152.65 | 2153.19 | 2487.0 |
| 2015-12-13 20:00:00 | ES | Futures | 2152.92 | 2157.47 | 2152.12 | 2156.94 | 5115.0 |
| 2015-12-13 21:00:00 | ES | Futures | 2157.2 | 2158.01 | 2155.33 | 2155.86 | 2933.0 |
| 2015-12-13 22:00:00 | ES | Futures | 2155.6 | 2159.61 | 2154.79 | 2159.08 | 2513.0 |
| 2015-12-13 23:00:00 | ES | Futures | 2159.34 | 2159.88 | 2158.27 | 2158.81 | 2069.0 |
| 2015-12-13 18:00:00 | NQ | Futures | 5377.75 | 5394.36 | 5368.56 | 5389.02 | 1046.0 |
| 2015-12-13 19:00:00 | NQ | Futures | 5389.61 | 5393.76 | 5386.65 | 5387.83 | 418.0 |
| 2015-12-13 20:00:00 | NQ | Futures | 5387.24 | 5393.76 | 5383.39 | 5393.17 | 478.0 |
| 2015-12-13 21:00:00 | NQ | Futures | 5393.47 | 5395.25 | 5390.21 | 5394.65 | 174.0 |
| 2015-12-13 22:00:00 | NQ | Futures | 5390.8 | 5400.88 | 5389.61 | 5399.1 | 340.0 |
| 2015-12-13 23:00:00 | NQ | Futures | 5399.69 | 5401.18 | 5397.62 | 5398.51 | 156.0 |
| 2015-12-13 18:00:00 | YM | Futures | 18275.0 | 18314.3 | 18268.6 | 18297.3 | 1056.0 |
| 2015-12-13 19:00:00 | YM | Futures | 18299.4 | 18302.6 | 18287.7 | 18290.9 | 938.0 |
| 2015-12-13 20:00:00 | YM | Futures | 18292.0 | 18327.1 | 18281.4 | 18323.9 | 1963.0 |
| 2015-12-13 21:00:00 | YM | Futures | 18323.9 | 18332.4 | 18310.1 | 18319.7 | 1106.0 |
| 2015-12-13 22:00:00 | YM | Futures | 18318.6 | 18348.4 | 18312.2 | 18344.2 | 732.0 |
| 2015-12-13 23:00:00 | YM | Futures | 18345.2 | 18345.2 | 18334.6 | 18335.6 | 384.0 |
| 2015-12-13 18:00:00 | CL | Futures | 48.54 | 48.94 | 48.49 | 48.72 | 2713.0 |
| 2015-12-13 19:00:00 | CL | Futures | 48.72 | 48.83 | 48.65 | 48.67 | 1332.0 |
| 2015-12-13 20:00:00 | CL | Futures | 48.67 | 48.67 | 48.49 | 48.53 | 2203.0 |
| 2015-12-13 21:00:00 | CL | Futures | 48.52 | 48.56 | 48.36 | 48.5 | 2228.0 |
| 2015-12-13 22:00:00 | CL | Futures | 48.5 | 48.67 | 48.47 | 48.63 | 1027.0 |
| 2015-12-13 23:00:00 | CL | Futures | 48.63 | 48.72 | 48.61 | 48.63 | 706.0 |
| 2015-12-13 18:00:00 | GC | Futures | 1465.4 | 1466.4 | 1463.6 | 1463.6 | 1577.0 |
| 2015-12-13 19:00:00 | GC | Futures | 1463.9 | 1467.2 | 1462.1 | 1466.9 | 3009.0 |
| 2015-12-13 20:00:00 | GC | Futures | 1466.9 | 1467.3 | 1464.0 | 1466.9 | 3783.0 |
| 2015-12-13 21:00:00 | GC | Futures | 1466.9 | 1469.9 | 1466.8 | 1469.1 | 2677.0 |
| 2015-12-13 22:00:00 | GC | Futures | 1469.0 | 1471.3 | 1468.0 | 1468.3 | 3266.0 |
| 2015-12-13 23:00:00 | GC | Futures | 1468.1 | 1469.5 | 1468.1 | 1469.2 | 471.0 |
| 2015-12-13 18:00:00 | ZN | Futures | 123.358424 | 123.373584 | 123.282623 | 123.297783 | 11367.0 |
| 2015-12-13 19:00:00 | ZN | Futures | 123.312944 | 123.312944 | 123.191662 | 123.221982 | 11609.0 |
| 2015-12-13 20:00:00 | ZN | Futures | 123.221982 | 123.267463 | 123.191662 | 123.206822 | 14150.0 |
| 2015-12-13 21:00:00 | ZN | Futures | 123.206822 | 123.221982 | 123.191662 | 123.206822 | 3982.0 |
| 2015-12-13 22:00:00 | ZN | Futures | 123.221982 | 123.221982 | 123.176502 | 123.206822 | 5996.0 |
| 2015-12-13 23:00:00 | ZN | Futures | 123.191662 | 123.206822 | 123.176502 | 123.191662 | 3558.0 |
> showing 36 of 277 rows — these rows as CSV