PREVIEW / futures_1hour / 2016-05-08
file: by_date/futures_1hour/2016/2016-05-08.parquet size: 15 KB rows: 293
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 |
|---|---|---|---|---|---|---|---|
| 2016-05-08 18:00:00 | ES | Futures | 2217.08 | 2221.67 | 2216.27 | 2221.13 | 10760.0 |
| 2016-05-08 19:00:00 | ES | Futures | 2221.13 | 2221.94 | 2219.78 | 2221.94 | 4457.0 |
| 2016-05-08 20:00:00 | ES | Futures | 2221.94 | 2222.21 | 2220.05 | 2220.05 | 8170.0 |
| 2016-05-08 21:00:00 | ES | Futures | 2220.32 | 2221.13 | 2217.62 | 2219.24 | 8246.0 |
| 2016-05-08 22:00:00 | ES | Futures | 2219.24 | 2220.32 | 2217.89 | 2219.51 | 5306.0 |
| 2016-05-08 23:00:00 | ES | Futures | 2219.51 | 2219.51 | 2217.62 | 2218.7 | 4164.0 |
| 2016-05-08 18:00:00 | NQ | Futures | 5152.92 | 5161.84 | 5149.64 | 5159.17 | 1420.0 |
| 2016-05-08 19:00:00 | NQ | Futures | 5159.46 | 5161.25 | 5155.3 | 5160.36 | 548.0 |
| 2016-05-08 20:00:00 | NQ | Futures | 5160.36 | 5161.25 | 5156.78 | 5157.08 | 988.0 |
| 2016-05-08 21:00:00 | NQ | Futures | 5157.38 | 5159.76 | 5148.45 | 5152.62 | 1179.0 |
| 2016-05-08 22:00:00 | NQ | Futures | 5152.32 | 5155.59 | 5149.35 | 5153.51 | 612.0 |
| 2016-05-08 23:00:00 | NQ | Futures | 5154.11 | 5154.11 | 5147.56 | 5150.24 | 679.0 |
| 2016-05-08 18:00:00 | YM | Futures | 18917.0 | 18955.5 | 18912.7 | 18947.0 | 1612.0 |
| 2016-05-08 19:00:00 | YM | Futures | 18948.0 | 18953.4 | 18936.3 | 18953.4 | 645.0 |
| 2016-05-08 20:00:00 | YM | Futures | 18952.3 | 18955.5 | 18942.7 | 18944.8 | 1203.0 |
| 2016-05-08 21:00:00 | YM | Futures | 18944.8 | 18950.2 | 18918.1 | 18928.8 | 1943.0 |
| 2016-05-08 22:00:00 | YM | Futures | 18926.6 | 18939.5 | 18919.1 | 18933.1 | 1108.0 |
| 2016-05-08 23:00:00 | YM | Futures | 18933.1 | 18934.1 | 18918.1 | 18927.7 | 803.0 |
| 2016-05-08 18:00:00 | CL | Futures | 48.35 | 49.36 | 48.35 | 49.2 | 15568.0 |
| 2016-05-08 19:00:00 | CL | Futures | 49.2 | 49.23 | 48.99 | 49.0 | 5810.0 |
| 2016-05-08 20:00:00 | CL | Futures | 49.01 | 49.03 | 48.86 | 48.91 | 3657.0 |
| 2016-05-08 21:00:00 | CL | Futures | 48.92 | 49.16 | 48.83 | 48.92 | 6387.0 |
| 2016-05-08 22:00:00 | CL | Futures | 48.93 | 49.02 | 48.86 | 48.95 | 3024.0 |
| 2016-05-08 23:00:00 | CL | Futures | 48.95 | 48.99 | 48.63 | 48.81 | 7474.0 |
| 2016-05-08 18:00:00 | GC | Futures | 1754.9 | 1757.9 | 1753.9 | 1757.7 | 2341.0 |
| 2016-05-08 19:00:00 | GC | Futures | 1757.7 | 1758.6 | 1754.9 | 1756.2 | 1389.0 |
| 2016-05-08 20:00:00 | GC | Futures | 1756.1 | 1757.6 | 1753.4 | 1756.1 | 4883.0 |
| 2016-05-08 21:00:00 | GC | Futures | 1756.1 | 1758.7 | 1754.1 | 1757.7 | 6093.0 |
| 2016-05-08 22:00:00 | GC | Futures | 1757.6 | 1758.4 | 1756.1 | 1756.5 | 2634.0 |
| 2016-05-08 23:00:00 | GC | Futures | 1756.4 | 1757.6 | 1753.5 | 1754.2 | 4063.0 |
| 2016-05-08 18:00:00 | ZN | Futures | 127.108048 | 127.123264 | 127.047188 | 127.077618 | 4867.0 |
| 2016-05-08 19:00:00 | ZN | Futures | 127.062403 | 127.108048 | 127.016757 | 127.031972 | 7049.0 |
| 2016-05-08 20:00:00 | ZN | Futures | 127.031972 | 127.062403 | 127.016757 | 127.062403 | 6797.0 |
| 2016-05-08 21:00:00 | ZN | Futures | 127.047188 | 127.092833 | 127.047188 | 127.092833 | 6667.0 |
| 2016-05-08 22:00:00 | ZN | Futures | 127.077618 | 127.092833 | 127.062403 | 127.077618 | 4591.0 |
| 2016-05-08 23:00:00 | ZN | Futures | 127.077618 | 127.123264 | 127.077618 | 127.108048 | 5528.0 |
> showing 36 of 293 rows — these rows as CSV