PREVIEW / futures_1hour / 2011-05-29
file: by_date/futures_1hour/2011/2011-05-29.parquet size: 11 KB rows: 195
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 |
|---|---|---|---|---|---|---|---|
| 2011-05-29 18:00:00 | ES | Futures | 1321.4 | 1322.15 | 1320.41 | 1320.91 | 1401.0 |
| 2011-05-29 19:00:00 | ES | Futures | 1320.91 | 1322.64 | 1320.66 | 1321.15 | 1477.0 |
| 2011-05-29 20:00:00 | ES | Futures | 1321.4 | 1321.9 | 1321.15 | 1321.4 | 2297.0 |
| 2011-05-29 21:00:00 | ES | Futures | 1321.4 | 1322.4 | 1321.15 | 1321.9 | 2329.0 |
| 2011-05-29 22:00:00 | ES | Futures | 1321.65 | 1322.89 | 1321.4 | 1322.64 | 1317.0 |
| 2011-05-29 23:00:00 | ES | Futures | 1322.64 | 1322.64 | 1321.65 | 1321.9 | 767.0 |
| 2011-05-29 18:00:00 | NQ | Futures | 2679.21 | 2681.22 | 2679.21 | 2679.21 | 177.0 |
| 2011-05-29 19:00:00 | NQ | Futures | 2679.5 | 2682.66 | 2679.5 | 2680.36 | 167.0 |
| 2011-05-29 20:00:00 | NQ | Futures | 2680.65 | 2681.8 | 2680.07 | 2680.93 | 195.0 |
| 2011-05-29 21:00:00 | NQ | Futures | 2681.51 | 2682.37 | 2680.65 | 2680.93 | 99.0 |
| 2011-05-29 22:00:00 | NQ | Futures | 2680.65 | 2683.23 | 2680.65 | 2682.66 | 159.0 |
| 2011-05-29 23:00:00 | NQ | Futures | 2682.66 | 2682.95 | 2681.8 | 2682.08 | 88.0 |
| 2011-05-29 18:00:00 | YM | Futures | 11964.7 | 11976.3 | 11962.8 | 11974.4 | 108.0 |
| 2011-05-29 19:00:00 | YM | Futures | 11973.4 | 11989.8 | 11972.4 | 11976.3 | 250.0 |
| 2011-05-29 20:00:00 | YM | Futures | 11979.2 | 11983.0 | 11972.4 | 11973.4 | 103.0 |
| 2011-05-29 21:00:00 | YM | Futures | 11975.3 | 11983.0 | 11973.4 | 11976.3 | 87.0 |
| 2011-05-29 22:00:00 | YM | Futures | 11975.3 | 11981.1 | 11974.4 | 11981.1 | 69.0 |
| 2011-05-29 23:00:00 | YM | Futures | 11981.1 | 11984.0 | 11978.2 | 11979.2 | 35.0 |
| 2011-05-29 18:00:00 | CL | Futures | 173.41 | 173.6 | 173.03 | 173.32 | 326.0 |
| 2011-05-29 19:00:00 | CL | Futures | 173.37 | 173.41 | 173.18 | 173.37 | 203.0 |
| 2011-05-29 20:00:00 | CL | Futures | 173.37 | 173.42 | 173.04 | 173.13 | 447.0 |
| 2011-05-29 21:00:00 | CL | Futures | 173.11 | 173.22 | 172.82 | 172.92 | 285.0 |
| 2011-05-29 22:00:00 | CL | Futures | 172.94 | 173.22 | 172.84 | 173.11 | 154.0 |
| 2011-05-29 23:00:00 | CL | Futures | 173.11 | 173.2 | 173.08 | 173.17 | 99.0 |
| 2011-05-29 18:00:00 | GC | Futures | 2145.3 | 2146.2 | 2143.7 | 2146.2 | 321.0 |
| 2011-05-29 19:00:00 | GC | Futures | 2146.4 | 2146.4 | 2143.9 | 2144.8 | 323.0 |
| 2011-05-29 20:00:00 | GC | Futures | 2144.6 | 2145.3 | 2142.6 | 2142.9 | 731.0 |
| 2011-05-29 21:00:00 | GC | Futures | 2142.8 | 2145.3 | 2142.6 | 2142.9 | 785.0 |
| 2011-05-29 22:00:00 | GC | Futures | 2142.9 | 2144.3 | 2142.2 | 2144.2 | 673.0 |
| 2011-05-29 23:00:00 | GC | Futures | 2144.0 | 2144.3 | 2143.3 | 2143.7 | 244.0 |
| 2011-05-29 18:00:00 | ZN | Futures | 105.481475 | 105.587901 | 105.481475 | 105.547991 | 2312.0 |
| 2011-05-29 19:00:00 | ZN | Futures | 105.547991 | 105.574597 | 105.534688 | 105.561294 | 890.0 |
| 2011-05-29 20:00:00 | ZN | Futures | 105.561294 | 105.561294 | 105.521384 | 105.561294 | 802.0 |
| 2011-05-29 21:00:00 | ZN | Futures | 105.561294 | 105.574597 | 105.547991 | 105.547991 | 837.0 |
| 2011-05-29 22:00:00 | ZN | Futures | 105.561294 | 105.561294 | 105.521384 | 105.547991 | 744.0 |
| 2011-05-29 23:00:00 | ZN | Futures | 105.534688 | 105.547991 | 105.534688 | 105.547991 | 650.0 |
> showing 36 of 195 rows — these rows as CSV