PREVIEW / futures_30min / 2011-05-22
file: by_date/futures_30min/2011/2011-05-22.parquet size: 20 KB rows: 480
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 | 1316.18 | 18920.0 |
| 2011-05-22 18:30:00 | ES | Futures | 1316.18 | 1316.93 | 1315.19 | 1315.44 | 3807.0 |
| 2011-05-22 19:00:00 | ES | Futures | 1315.44 | 1315.94 | 1314.69 | 1314.94 | 2082.0 |
| 2011-05-22 19:30:00 | ES | Futures | 1315.19 | 1317.92 | 1314.94 | 1317.68 | 3365.0 |
| 2011-05-22 20:00:00 | ES | Futures | 1317.92 | 1317.92 | 1316.43 | 1316.68 | 3125.0 |
| 2011-05-22 20:30:00 | ES | Futures | 1316.68 | 1316.68 | 1314.94 | 1315.19 | 4346.0 |
| 2011-05-22 21:00:00 | ES | Futures | 1315.44 | 1315.69 | 1314.2 | 1314.69 | 3666.0 |
| 2011-05-22 21:30:00 | ES | Futures | 1314.69 | 1315.44 | 1313.7 | 1314.45 | 3852.0 |
| 2011-05-22 22:00:00 | ES | Futures | 1314.2 | 1314.69 | 1313.2 | 1313.45 | 4048.0 |
| 2011-05-22 22:30:00 | ES | Futures | 1313.2 | 1313.45 | 1312.21 | 1312.71 | 4815.0 |
| 2011-05-22 23:00:00 | ES | Futures | 1312.71 | 1312.96 | 1311.71 | 1312.46 | 3671.0 |
| 2011-05-22 23:30:00 | ES | Futures | 1312.21 | 1312.96 | 1311.96 | 1312.71 | 5111.0 |
| 2011-05-22 18:00:00 | NQ | Futures | 2690.99 | 2692.43 | 2678.06 | 2686.39 | 1406.0 |
| 2011-05-22 18:30:00 | NQ | Futures | 2686.39 | 2687.83 | 2684.67 | 2684.67 | 313.0 |
| 2011-05-22 19:00:00 | NQ | Futures | 2684.67 | 2685.24 | 2683.52 | 2684.09 | 158.0 |
| 2011-05-22 19:30:00 | NQ | Futures | 2684.09 | 2688.69 | 2684.09 | 2688.69 | 205.0 |
| 2011-05-22 20:00:00 | NQ | Futures | 2688.98 | 2690.13 | 2687.26 | 2687.26 | 216.0 |
| 2011-05-22 20:30:00 | NQ | Futures | 2686.97 | 2687.26 | 2682.66 | 2684.38 | 657.0 |
| 2011-05-22 21:00:00 | NQ | Futures | 2684.38 | 2684.38 | 2681.8 | 2682.08 | 247.0 |
| 2011-05-22 21:30:00 | NQ | Futures | 2682.08 | 2684.38 | 2680.93 | 2682.37 | 196.0 |
| 2011-05-22 22:00:00 | NQ | Futures | 2682.37 | 2682.37 | 2679.5 | 2679.79 | 219.0 |
| 2011-05-22 22:30:00 | NQ | Futures | 2679.79 | 2680.36 | 2678.35 | 2678.92 | 188.0 |
| 2011-05-22 23:00:00 | NQ | Futures | 2678.92 | 2678.92 | 2676.34 | 2677.77 | 303.0 |
| 2011-05-22 23:30:00 | NQ | Futures | 2677.77 | 2678.92 | 2677.49 | 2678.92 | 175.0 |
| 2011-05-22 18:00:00 | YM | Futures | 11989.8 | 11996.5 | 11940.6 | 11977.2 | 657.0 |
| 2011-05-22 18:30:00 | YM | Futures | 11981.1 | 11985.9 | 11968.6 | 11971.5 | 110.0 |
| 2011-05-22 19:00:00 | YM | Futures | 11970.5 | 11974.4 | 11967.6 | 11968.6 | 82.0 |
| 2011-05-22 19:30:00 | YM | Futures | 11969.5 | 11992.7 | 11969.5 | 11991.7 | 140.0 |
| 2011-05-22 20:00:00 | YM | Futures | 11993.6 | 11994.6 | 11981.1 | 11981.1 | 141.0 |
| 2011-05-22 20:30:00 | YM | Futures | 11980.1 | 11980.1 | 11958.9 | 11968.6 | 400.0 |
| 2011-05-22 21:00:00 | YM | Futures | 11968.6 | 11970.5 | 11961.8 | 11962.8 | 192.0 |
| 2011-05-22 21:30:00 | YM | Futures | 11962.8 | 11971.5 | 11958.9 | 11959.9 | 65.0 |
| 2011-05-22 22:00:00 | YM | Futures | 11960.9 | 11964.7 | 11953.2 | 11953.2 | 96.0 |
| 2011-05-22 22:30:00 | YM | Futures | 11953.2 | 11955.1 | 11947.4 | 11950.3 | 101.0 |
| 2011-05-22 23:00:00 | YM | Futures | 11948.3 | 11952.2 | 11943.5 | 11947.4 | 145.0 |
| 2011-05-22 23:30:00 | YM | Futures | 11946.4 | 11953.2 | 11944.5 | 11951.2 | 149.0 |
| 2011-05-22 18:00:00 | CL | Futures | 171.67 | 171.86 | 171.17 | 171.6 | 1130.0 |
| 2011-05-22 18:30:00 | CL | Futures | 171.6 | 171.67 | 171.24 | 171.27 | 323.0 |
| 2011-05-22 19:00:00 | CL | Futures | 171.25 | 171.58 | 171.25 | 171.48 | 381.0 |
| 2011-05-22 19:30:00 | CL | Futures | 171.48 | 172.29 | 171.39 | 172.24 | 537.0 |
| 2011-05-22 20:00:00 | CL | Futures | 172.25 | 172.29 | 171.58 | 171.67 | 379.0 |
| 2011-05-22 20:30:00 | CL | Futures | 171.6 | 171.6 | 171.12 | 171.18 | 570.0 |
| 2011-05-22 21:00:00 | CL | Futures | 171.22 | 171.27 | 170.67 | 170.74 | 989.0 |
| 2011-05-22 21:30:00 | CL | Futures | 170.74 | 170.84 | 170.5 | 170.62 | 691.0 |
| 2011-05-22 22:00:00 | CL | Futures | 170.58 | 170.69 | 170.32 | 170.62 | 569.0 |
| 2011-05-22 22:30:00 | CL | Futures | 170.6 | 170.74 | 170.36 | 170.65 | 367.0 |
| 2011-05-22 23:00:00 | CL | Futures | 170.63 | 170.89 | 170.6 | 170.81 | 285.0 |
| 2011-05-22 23:30:00 | CL | Futures | 170.79 | 170.84 | 170.53 | 170.65 | 230.0 |
| 2011-05-22 18:00:00 | GC | Futures | 2111.5 | 2120.2 | 2106.8 | 2116.0 | 2185.0 |
| 2011-05-22 18:30:00 | GC | Futures | 2116.4 | 2117.1 | 2113.3 | 2113.6 | 464.0 |
> showing 50 of 480 rows — these rows as CSV