PREVIEW / futures_1hour / 2013-06-16
file: by_date/futures_1hour/2013/2013-06-16.parquet size: 13 KB rows: 256
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-16 18:00:00 | ES | Futures | 1673.75 | 1676.6 | 1672.98 | 1675.3 | 6833.0 |
| 2013-06-16 19:00:00 | ES | Futures | 1675.3 | 1677.63 | 1675.3 | 1677.11 | 3010.0 |
| 2013-06-16 20:00:00 | ES | Futures | 1677.11 | 1679.44 | 1676.34 | 1677.89 | 9690.0 |
| 2013-06-16 21:00:00 | ES | Futures | 1678.15 | 1680.47 | 1677.89 | 1679.96 | 6788.0 |
| 2013-06-16 22:00:00 | ES | Futures | 1679.96 | 1680.73 | 1678.92 | 1679.96 | 2833.0 |
| 2013-06-16 23:00:00 | ES | Futures | 1679.96 | 1680.73 | 1678.41 | 1680.47 | 3505.0 |
| 2013-06-16 18:00:00 | NQ | Futures | 3432.6 | 3439.03 | 3432.31 | 3437.28 | 301.0 |
| 2013-06-16 19:00:00 | NQ | Futures | 3437.86 | 3441.95 | 3437.86 | 3441.37 | 693.0 |
| 2013-06-16 20:00:00 | NQ | Futures | 3441.37 | 3446.34 | 3440.2 | 3444.0 | 783.0 |
| 2013-06-16 21:00:00 | NQ | Futures | 3444.0 | 3448.38 | 3443.71 | 3447.51 | 456.0 |
| 2013-06-16 22:00:00 | NQ | Futures | 3447.8 | 3448.09 | 3445.75 | 3447.21 | 175.0 |
| 2013-06-16 23:00:00 | NQ | Futures | 3447.21 | 3448.97 | 3444.88 | 3448.09 | 334.0 |
| 2013-06-16 18:00:00 | YM | Futures | 15227.1 | 15245.4 | 15221.0 | 15238.3 | 386.0 |
| 2013-06-16 19:00:00 | YM | Futures | 15239.3 | 15255.5 | 15238.3 | 15254.5 | 234.0 |
| 2013-06-16 20:00:00 | YM | Futures | 15253.5 | 15270.8 | 15245.4 | 15261.6 | 752.0 |
| 2013-06-16 21:00:00 | YM | Futures | 15262.6 | 15284.0 | 15261.6 | 15281.9 | 867.0 |
| 2013-06-16 22:00:00 | YM | Futures | 15281.9 | 15283.0 | 15272.8 | 15277.9 | 407.0 |
| 2013-06-16 23:00:00 | YM | Futures | 15279.9 | 15286.0 | 15266.7 | 15281.9 | 501.0 |
| 2013-06-16 18:00:00 | CL | Futures | 153.47 | 153.47 | 153.11 | 153.17 | 298.0 |
| 2013-06-16 19:00:00 | CL | Futures | 153.14 | 153.25 | 152.99 | 153.06 | 256.0 |
| 2013-06-16 20:00:00 | CL | Futures | 153.1 | 153.11 | 152.88 | 152.99 | 280.0 |
| 2013-06-16 21:00:00 | CL | Futures | 153.0 | 153.17 | 152.91 | 153.1 | 357.0 |
| 2013-06-16 22:00:00 | CL | Futures | 153.08 | 153.08 | 152.77 | 152.86 | 198.0 |
| 2013-06-16 23:00:00 | CL | Futures | 152.86 | 153.02 | 152.8 | 153.0 | 91.0 |
| 2013-06-16 18:00:00 | GC | Futures | 1906.5 | 1907.7 | 1904.3 | 1905.1 | 599.0 |
| 2013-06-16 19:00:00 | GC | Futures | 1905.4 | 1906.2 | 1904.6 | 1905.8 | 244.0 |
| 2013-06-16 20:00:00 | GC | Futures | 1905.8 | 1906.1 | 1901.3 | 1903.8 | 2756.0 |
| 2013-06-16 21:00:00 | GC | Futures | 1903.6 | 1906.9 | 1903.1 | 1905.5 | 2128.0 |
| 2013-06-16 22:00:00 | GC | Futures | 1905.5 | 1907.5 | 1905.1 | 1907.3 | 1531.0 |
| 2013-06-16 23:00:00 | GC | Futures | 1907.3 | 1908.3 | 1906.0 | 1907.0 | 993.0 |
| 2013-06-16 18:00:00 | ZN | Futures | 117.340002 | 117.340002 | 117.269247 | 117.3117 | 3731.0 |
| 2013-06-16 19:00:00 | ZN | Futures | 117.297549 | 117.3117 | 117.240945 | 117.255096 | 3553.0 |
| 2013-06-16 20:00:00 | ZN | Futures | 117.269247 | 117.297549 | 117.226794 | 117.255096 | 7442.0 |
| 2013-06-16 21:00:00 | ZN | Futures | 117.269247 | 117.283398 | 117.240945 | 117.283398 | 3785.0 |
| 2013-06-16 22:00:00 | ZN | Futures | 117.269247 | 117.297549 | 117.269247 | 117.269247 | 2271.0 |
| 2013-06-16 23:00:00 | ZN | Futures | 117.269247 | 117.283398 | 117.240945 | 117.255096 | 2723.0 |
> showing 36 of 256 rows — these rows as CSV