PREVIEW / futures_30min / 2011-08-14
file: by_date/futures_30min/2011/2011-08-14.parquet size: 19 KB rows: 475
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-08-14 18:00:00 | ES | Futures | 1176.94 | 1178.19 | 1173.45 | 1175.7 | 6708.0 |
| 2011-08-14 18:30:00 | ES | Futures | 1175.95 | 1177.19 | 1174.95 | 1175.7 | 2794.0 |
| 2011-08-14 19:00:00 | ES | Futures | 1175.45 | 1177.44 | 1175.2 | 1175.95 | 1542.0 |
| 2011-08-14 19:30:00 | ES | Futures | 1175.95 | 1182.18 | 1175.95 | 1180.94 | 6317.0 |
| 2011-08-14 20:00:00 | ES | Futures | 1180.94 | 1183.68 | 1180.19 | 1180.69 | 4796.0 |
| 2011-08-14 20:30:00 | ES | Futures | 1180.44 | 1183.43 | 1180.44 | 1182.43 | 2297.0 |
| 2011-08-14 21:00:00 | ES | Futures | 1182.18 | 1183.43 | 1181.93 | 1181.93 | 1992.0 |
| 2011-08-14 21:30:00 | ES | Futures | 1181.93 | 1182.43 | 1180.44 | 1180.69 | 2758.0 |
| 2011-08-14 22:00:00 | ES | Futures | 1180.69 | 1181.43 | 1179.44 | 1180.19 | 2266.0 |
| 2011-08-14 22:30:00 | ES | Futures | 1180.19 | 1180.69 | 1179.69 | 1180.19 | 1521.0 |
| 2011-08-14 23:00:00 | ES | Futures | 1179.94 | 1180.44 | 1178.44 | 1180.44 | 2044.0 |
| 2011-08-14 23:30:00 | ES | Futures | 1180.44 | 1181.43 | 1179.44 | 1180.19 | 1441.0 |
| 2011-08-14 18:00:00 | NQ | Futures | 2513.63 | 2514.78 | 2505.86 | 2508.16 | 1489.0 |
| 2011-08-14 18:30:00 | NQ | Futures | 2508.74 | 2512.19 | 2506.44 | 2508.16 | 173.0 |
| 2011-08-14 19:00:00 | NQ | Futures | 2507.87 | 2511.33 | 2507.87 | 2509.89 | 58.0 |
| 2011-08-14 19:30:00 | NQ | Futures | 2508.74 | 2522.84 | 2508.74 | 2519.96 | 547.0 |
| 2011-08-14 20:00:00 | NQ | Futures | 2520.54 | 2526.0 | 2517.66 | 2518.52 | 515.0 |
| 2011-08-14 20:30:00 | NQ | Futures | 2519.1 | 2525.43 | 2519.1 | 2522.55 | 293.0 |
| 2011-08-14 21:00:00 | NQ | Futures | 2522.55 | 2524.56 | 2521.4 | 2521.4 | 124.0 |
| 2011-08-14 21:30:00 | NQ | Futures | 2521.69 | 2521.97 | 2517.95 | 2519.1 | 134.0 |
| 2011-08-14 22:00:00 | NQ | Futures | 2519.1 | 2521.69 | 2517.37 | 2518.52 | 220.0 |
| 2011-08-14 22:30:00 | NQ | Futures | 2518.52 | 2519.67 | 2518.23 | 2519.1 | 231.0 |
| 2011-08-14 23:00:00 | NQ | Futures | 2519.1 | 2519.39 | 2515.36 | 2518.81 | 328.0 |
| 2011-08-14 23:30:00 | NQ | Futures | 2519.39 | 2521.97 | 2517.95 | 2519.67 | 214.0 |
| 2011-08-14 18:00:00 | YM | Futures | 10911.9 | 10924.5 | 10887.7 | 10900.3 | 435.0 |
| 2011-08-14 18:30:00 | YM | Futures | 10903.2 | 10911.9 | 10893.5 | 10894.5 | 308.0 |
| 2011-08-14 19:00:00 | YM | Futures | 10894.5 | 10911.0 | 10894.5 | 10899.3 | 333.0 |
| 2011-08-14 19:30:00 | YM | Futures | 10902.2 | 10949.7 | 10902.2 | 10938.1 | 301.0 |
| 2011-08-14 20:00:00 | YM | Futures | 10941.9 | 10969.1 | 10941.9 | 10942.9 | 328.0 |
| 2011-08-14 20:30:00 | YM | Futures | 10943.9 | 10965.2 | 10941.9 | 10959.4 | 225.0 |
| 2011-08-14 21:00:00 | YM | Futures | 10958.4 | 10963.2 | 10954.5 | 10954.5 | 110.0 |
| 2011-08-14 21:30:00 | YM | Futures | 10954.5 | 10955.5 | 10939.0 | 10944.8 | 113.0 |
| 2011-08-14 22:00:00 | YM | Futures | 10942.9 | 10946.8 | 10933.2 | 10939.0 | 119.0 |
| 2011-08-14 22:30:00 | YM | Futures | 10935.2 | 10940.0 | 10932.3 | 10935.2 | 124.0 |
| 2011-08-14 23:00:00 | YM | Futures | 10934.2 | 10937.1 | 10922.6 | 10933.2 | 193.0 |
| 2011-08-14 23:30:00 | YM | Futures | 10937.1 | 10946.8 | 10932.3 | 10939.0 | 181.0 |
| 2011-08-14 18:00:00 | CL | Futures | 145.54 | 145.54 | 144.42 | 145.17 | 65.0 |
| 2011-08-14 18:30:00 | CL | Futures | 145.03 | 145.22 | 144.98 | 145.22 | 15.0 |
| 2011-08-14 19:00:00 | CL | Futures | 145.37 | 145.39 | 145.37 | 145.37 | 11.0 |
| 2011-08-14 19:30:00 | CL | Futures | 145.37 | 145.39 | 145.25 | 145.32 | 26.0 |
| 2011-08-14 20:00:00 | CL | Futures | 145.28 | 145.59 | 145.22 | 145.47 | 301.0 |
| 2011-08-14 20:30:00 | CL | Futures | 145.49 | 145.49 | 145.3 | 145.3 | 17.0 |
| 2011-08-14 21:00:00 | CL | Futures | 145.59 | 145.62 | 145.45 | 145.45 | 31.0 |
| 2011-08-14 21:30:00 | CL | Futures | 145.47 | 145.47 | 145.1 | 145.22 | 151.0 |
| 2011-08-14 22:00:00 | CL | Futures | 145.15 | 145.22 | 145.11 | 145.22 | 27.0 |
| 2011-08-14 22:30:00 | CL | Futures | 145.22 | 145.25 | 145.17 | 145.17 | 8.0 |
| 2011-08-14 23:00:00 | CL | Futures | 145.3 | 145.37 | 145.28 | 145.32 | 90.0 |
| 2011-08-14 23:30:00 | CL | Futures | 145.32 | 145.37 | 145.32 | 145.32 | 34.0 |
| 2011-08-14 18:00:00 | GC | Futures | 2433.0 | 2437.7 | 2427.9 | 2430.8 | 1421.0 |
| 2011-08-14 18:30:00 | GC | Futures | 2429.9 | 2431.2 | 2426.7 | 2427.4 | 302.0 |
> showing 50 of 475 rows — these rows as CSV