PREVIEW / futures_1hour / 2014-05-25
file: by_date/futures_1hour/2014/2014-05-25.parquet size: 11 KB rows: 202
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-25 18:00:00 | ES | Futures | 1971.42 | 1973.24 | 1970.64 | 1972.2 | 5286.0 |
| 2014-05-25 19:00:00 | ES | Futures | 1971.94 | 1972.2 | 1970.9 | 1971.16 | 1498.0 |
| 2014-05-25 20:00:00 | ES | Futures | 1971.16 | 1971.68 | 1970.64 | 1971.68 | 1576.0 |
| 2014-05-25 21:00:00 | ES | Futures | 1971.42 | 1971.94 | 1971.16 | 1971.68 | 1000.0 |
| 2014-05-25 22:00:00 | ES | Futures | 1971.68 | 1971.68 | 1970.9 | 1971.16 | 404.0 |
| 2014-05-25 23:00:00 | ES | Futures | 1971.42 | 1971.42 | 1970.38 | 1970.64 | 681.0 |
| 2014-05-25 18:00:00 | NQ | Futures | 4285.63 | 4294.65 | 4285.04 | 4290.58 | 1158.0 |
| 2014-05-25 19:00:00 | NQ | Futures | 4290.29 | 4290.29 | 4286.79 | 4287.67 | 257.0 |
| 2014-05-25 20:00:00 | NQ | Futures | 4287.67 | 4287.96 | 4285.63 | 4287.37 | 425.0 |
| 2014-05-25 21:00:00 | NQ | Futures | 4287.08 | 4287.96 | 4287.08 | 4287.37 | 175.0 |
| 2014-05-25 22:00:00 | NQ | Futures | 4287.37 | 4287.67 | 4285.92 | 4286.21 | 123.0 |
| 2014-05-25 23:00:00 | NQ | Futures | 4286.21 | 4286.21 | 4283.88 | 4285.63 | 212.0 |
| 2014-05-25 18:00:00 | YM | Futures | 17088.5 | 17110.1 | 17087.4 | 17101.8 | 1027.0 |
| 2014-05-25 19:00:00 | YM | Futures | 17101.8 | 17102.9 | 17091.5 | 17093.6 | 185.0 |
| 2014-05-25 20:00:00 | YM | Futures | 17095.7 | 17095.7 | 17090.5 | 17095.7 | 227.0 |
| 2014-05-25 21:00:00 | YM | Futures | 17095.7 | 17100.8 | 17094.6 | 17098.8 | 248.0 |
| 2014-05-25 22:00:00 | YM | Futures | 17096.7 | 17099.8 | 17092.6 | 17092.6 | 120.0 |
| 2014-05-25 23:00:00 | YM | Futures | 17093.6 | 17093.6 | 17085.4 | 17089.5 | 214.0 |
| 2014-05-25 18:00:00 | CL | Futures | 168.43 | 168.43 | 168.22 | 168.28 | 634.0 |
| 2014-05-25 19:00:00 | CL | Futures | 168.28 | 168.38 | 168.19 | 168.2 | 438.0 |
| 2014-05-25 20:00:00 | CL | Futures | 168.22 | 168.25 | 168.01 | 168.06 | 464.0 |
| 2014-05-25 21:00:00 | CL | Futures | 168.06 | 168.09 | 167.96 | 168.04 | 438.0 |
| 2014-05-25 22:00:00 | CL | Futures | 168.03 | 168.04 | 167.98 | 168.01 | 357.0 |
| 2014-05-25 23:00:00 | CL | Futures | 168.01 | 168.03 | 167.93 | 167.96 | 261.0 |
| 2014-05-25 18:00:00 | GC | Futures | 1772.1 | 1773.7 | 1768.4 | 1769.4 | 535.0 |
| 2014-05-25 19:00:00 | GC | Futures | 1769.2 | 1770.4 | 1768.8 | 1769.2 | 231.0 |
| 2014-05-25 20:00:00 | GC | Futures | 1769.5 | 1771.3 | 1768.8 | 1770.7 | 685.0 |
| 2014-05-25 21:00:00 | GC | Futures | 1770.6 | 1772.8 | 1769.8 | 1772.5 | 1723.0 |
| 2014-05-25 22:00:00 | GC | Futures | 1772.5 | 1773.1 | 1771.7 | 1772.1 | 1030.0 |
| 2014-05-25 23:00:00 | GC | Futures | 1772.0 | 1772.5 | 1771.1 | 1771.7 | 560.0 |
| 2014-05-25 18:00:00 | ZN | Futures | 117.727981 | 117.742609 | 117.698724 | 117.713352 | 1898.0 |
| 2014-05-25 19:00:00 | ZN | Futures | 117.713352 | 117.713352 | 117.684096 | 117.713352 | 1055.0 |
| 2014-05-25 20:00:00 | ZN | Futures | 117.713352 | 117.757237 | 117.698724 | 117.742609 | 1873.0 |
| 2014-05-25 21:00:00 | ZN | Futures | 117.727981 | 117.757237 | 117.727981 | 117.757237 | 1805.0 |
| 2014-05-25 22:00:00 | ZN | Futures | 117.757237 | 117.757237 | 117.742609 | 117.742609 | 276.0 |
| 2014-05-25 23:00:00 | ZN | Futures | 117.742609 | 117.757237 | 117.727981 | 117.757237 | 723.0 |
> showing 36 of 202 rows — these rows as CSV