PREVIEW / futures_1hour / 2011-05-22
file: by_date/futures_1hour/2011/2011-05-22.parquet size: 14 KB rows: 257
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-22 18:00:00 | ES | Futures | 1317.68 | 1318.67 | 1312.96 | 1315.44 | 22727.0 |
| 2011-05-22 19:00:00 | ES | Futures | 1315.44 | 1317.92 | 1314.69 | 1317.68 | 5447.0 |
| 2011-05-22 20:00:00 | ES | Futures | 1317.92 | 1317.92 | 1314.94 | 1315.19 | 7471.0 |
| 2011-05-22 21:00:00 | ES | Futures | 1315.44 | 1315.69 | 1313.7 | 1314.45 | 7518.0 |
| 2011-05-22 22:00:00 | ES | Futures | 1314.2 | 1314.69 | 1312.21 | 1312.71 | 8863.0 |
| 2011-05-22 23:00:00 | ES | Futures | 1312.71 | 1312.96 | 1311.71 | 1312.71 | 8782.0 |
| 2011-05-22 18:00:00 | NQ | Futures | 2690.99 | 2692.43 | 2678.06 | 2684.67 | 1719.0 |
| 2011-05-22 19:00:00 | NQ | Futures | 2684.67 | 2688.69 | 2683.52 | 2688.69 | 363.0 |
| 2011-05-22 20:00:00 | NQ | Futures | 2688.98 | 2690.13 | 2682.66 | 2684.38 | 873.0 |
| 2011-05-22 21:00:00 | NQ | Futures | 2684.38 | 2684.38 | 2680.93 | 2682.37 | 443.0 |
| 2011-05-22 22:00:00 | NQ | Futures | 2682.37 | 2682.37 | 2678.35 | 2678.92 | 407.0 |
| 2011-05-22 23:00:00 | NQ | Futures | 2678.92 | 2678.92 | 2676.34 | 2678.92 | 478.0 |
| 2011-05-22 18:00:00 | YM | Futures | 11989.8 | 11996.5 | 11940.6 | 11971.5 | 767.0 |
| 2011-05-22 19:00:00 | YM | Futures | 11970.5 | 11992.7 | 11967.6 | 11991.7 | 222.0 |
| 2011-05-22 20:00:00 | YM | Futures | 11993.6 | 11994.6 | 11958.9 | 11968.6 | 541.0 |
| 2011-05-22 21:00:00 | YM | Futures | 11968.6 | 11971.5 | 11958.9 | 11959.9 | 257.0 |
| 2011-05-22 22:00:00 | YM | Futures | 11960.9 | 11964.7 | 11947.4 | 11950.3 | 197.0 |
| 2011-05-22 23:00:00 | YM | Futures | 11948.3 | 11953.2 | 11943.5 | 11951.2 | 294.0 |
| 2011-05-22 18:00:00 | CL | Futures | 171.67 | 171.86 | 171.17 | 171.27 | 1453.0 |
| 2011-05-22 19:00:00 | CL | Futures | 171.25 | 172.29 | 171.25 | 172.24 | 918.0 |
| 2011-05-22 20:00:00 | CL | Futures | 172.25 | 172.29 | 171.12 | 171.18 | 949.0 |
| 2011-05-22 21:00:00 | CL | Futures | 171.22 | 171.27 | 170.5 | 170.62 | 1680.0 |
| 2011-05-22 22:00:00 | CL | Futures | 170.58 | 170.74 | 170.32 | 170.65 | 936.0 |
| 2011-05-22 23:00:00 | CL | Futures | 170.63 | 170.89 | 170.53 | 170.65 | 515.0 |
| 2011-05-22 18:00:00 | GC | Futures | 2111.5 | 2120.2 | 2106.8 | 2113.6 | 2649.0 |
| 2011-05-22 19:00:00 | GC | Futures | 2113.6 | 2118.1 | 2113.3 | 2117.2 | 1083.0 |
| 2011-05-22 20:00:00 | GC | Futures | 2117.1 | 2117.1 | 2109.7 | 2110.9 | 2814.0 |
| 2011-05-22 21:00:00 | GC | Futures | 2110.7 | 2112.5 | 2107.5 | 2109.0 | 2255.0 |
| 2011-05-22 22:00:00 | GC | Futures | 2109.0 | 2109.8 | 2105.4 | 2106.5 | 1842.0 |
| 2011-05-22 23:00:00 | GC | Futures | 2106.6 | 2108.8 | 2105.2 | 2106.8 | 2848.0 |
| 2011-05-22 18:00:00 | ZN | Futures | 104.616763 | 104.68328 | 104.616763 | 104.656673 | 3749.0 |
| 2011-05-22 19:00:00 | ZN | Futures | 104.669976 | 104.709886 | 104.656673 | 104.669976 | 5962.0 |
| 2011-05-22 20:00:00 | ZN | Futures | 104.656673 | 104.763099 | 104.656673 | 104.736493 | 11117.0 |
| 2011-05-22 21:00:00 | ZN | Futures | 104.736493 | 104.763099 | 104.723189 | 104.763099 | 5007.0 |
| 2011-05-22 22:00:00 | ZN | Futures | 104.763099 | 104.816312 | 104.749796 | 104.816312 | 5431.0 |
| 2011-05-22 23:00:00 | ZN | Futures | 104.803009 | 104.816312 | 104.803009 | 104.816312 | 2362.0 |
> showing 36 of 257 rows — these rows as CSV