PREVIEW / futures_1hour / 2011-08-28
file: by_date/futures_1hour/2011/2011-08-28.parquet size: 13 KB rows: 251
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-28 18:00:00 | ES | Futures | 1172.7 | 1176.94 | 1169.46 | 1173.2 | 11943.0 |
| 2011-08-28 19:00:00 | ES | Futures | 1173.2 | 1175.7 | 1172.21 | 1174.45 | 4568.0 |
| 2011-08-28 20:00:00 | ES | Futures | 1174.7 | 1176.7 | 1172.7 | 1174.45 | 7833.0 |
| 2011-08-28 21:00:00 | ES | Futures | 1174.7 | 1182.93 | 1174.2 | 1180.44 | 16852.0 |
| 2011-08-28 22:00:00 | ES | Futures | 1180.69 | 1181.93 | 1178.44 | 1181.43 | 7265.0 |
| 2011-08-28 23:00:00 | ES | Futures | 1181.43 | 1182.93 | 1180.19 | 1182.18 | 3212.0 |
| 2011-08-28 18:00:00 | NQ | Futures | 2490.9 | 2496.65 | 2483.99 | 2491.47 | 644.0 |
| 2011-08-28 19:00:00 | NQ | Futures | 2490.9 | 2496.65 | 2489.17 | 2493.77 | 279.0 |
| 2011-08-28 20:00:00 | NQ | Futures | 2495.21 | 2496.94 | 2488.59 | 2492.62 | 809.0 |
| 2011-08-28 21:00:00 | NQ | Futures | 2493.2 | 2506.15 | 2492.05 | 2501.83 | 1686.0 |
| 2011-08-28 22:00:00 | NQ | Futures | 2502.41 | 2505.86 | 2498.67 | 2503.85 | 398.0 |
| 2011-08-28 23:00:00 | NQ | Futures | 2503.85 | 2507.3 | 2502.41 | 2505.86 | 197.0 |
| 2011-08-28 18:00:00 | YM | Futures | 10910.0 | 10945.8 | 10890.6 | 10918.7 | 468.0 |
| 2011-08-28 19:00:00 | YM | Futures | 10919.7 | 10941.9 | 10913.9 | 10932.3 | 96.0 |
| 2011-08-28 20:00:00 | YM | Futures | 10933.2 | 10948.7 | 10916.8 | 10929.4 | 236.0 |
| 2011-08-28 21:00:00 | YM | Futures | 10933.2 | 11000.0 | 10933.2 | 10982.6 | 598.0 |
| 2011-08-28 22:00:00 | YM | Futures | 10983.6 | 10990.4 | 10962.3 | 10988.4 | 292.0 |
| 2011-08-28 23:00:00 | YM | Futures | 10988.4 | 10998.1 | 10979.7 | 10992.3 | 153.0 |
| 2011-08-28 18:00:00 | CL | Futures | 144.57 | 145.23 | 144.28 | 145.03 | 784.0 |
| 2011-08-28 19:00:00 | CL | Futures | 145.03 | 145.08 | 144.88 | 145.03 | 298.0 |
| 2011-08-28 20:00:00 | CL | Futures | 145.01 | 145.03 | 144.35 | 144.49 | 719.0 |
| 2011-08-28 21:00:00 | CL | Futures | 144.45 | 144.81 | 144.2 | 144.56 | 722.0 |
| 2011-08-28 22:00:00 | CL | Futures | 144.56 | 144.91 | 144.37 | 144.62 | 686.0 |
| 2011-08-28 23:00:00 | CL | Futures | 144.62 | 144.79 | 144.54 | 144.71 | 189.0 |
| 2011-08-28 18:00:00 | GC | Futures | 2562.4 | 2564.5 | 2543.0 | 2545.1 | 5614.0 |
| 2011-08-28 19:00:00 | GC | Futures | 2545.8 | 2552.5 | 2537.7 | 2543.4 | 1787.0 |
| 2011-08-28 20:00:00 | GC | Futures | 2543.7 | 2545.1 | 2523.4 | 2525.5 | 6604.0 |
| 2011-08-28 21:00:00 | GC | Futures | 2525.9 | 2532.2 | 2518.8 | 2529.5 | 5943.0 |
| 2011-08-28 22:00:00 | GC | Futures | 2529.5 | 2536.8 | 2526.3 | 2536.5 | 2458.0 |
| 2011-08-28 23:00:00 | GC | Futures | 2536.6 | 2543.3 | 2536.2 | 2538.3 | 2768.0 |
| 2011-08-28 18:00:00 | ZN | Futures | 112.11864 | 112.145547 | 112.051375 | 112.132094 | 3497.0 |
| 2011-08-28 19:00:00 | ZN | Futures | 112.11864 | 112.159 | 112.11864 | 112.145547 | 1185.0 |
| 2011-08-28 20:00:00 | ZN | Futures | 112.132094 | 112.145547 | 112.091734 | 112.105187 | 2919.0 |
| 2011-08-28 21:00:00 | ZN | Futures | 112.105187 | 112.105187 | 111.984109 | 112.011015 | 6263.0 |
| 2011-08-28 22:00:00 | ZN | Futures | 112.011015 | 112.051375 | 112.011015 | 112.011015 | 1976.0 |
| 2011-08-28 23:00:00 | ZN | Futures | 112.024468 | 112.024468 | 111.984109 | 112.024468 | 1189.0 |
> showing 36 of 251 rows — these rows as CSV