PREVIEW / futures_1hour / 2011-10-09
file: by_date/futures_1hour/2011/2011-10-09.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-10-09 18:00:00 | ES | Futures | 1161.26 | 1162.77 | 1160.01 | 1161.51 | 12853.0 |
| 2011-10-09 19:00:00 | ES | Futures | 1161.51 | 1167.28 | 1161.01 | 1166.53 | 8427.0 |
| 2011-10-09 20:00:00 | ES | Futures | 1166.53 | 1172.29 | 1166.53 | 1171.54 | 16609.0 |
| 2011-10-09 21:00:00 | ES | Futures | 1171.54 | 1173.8 | 1169.28 | 1170.54 | 14574.0 |
| 2011-10-09 22:00:00 | ES | Futures | 1170.79 | 1171.04 | 1167.78 | 1168.03 | 6820.0 |
| 2011-10-09 23:00:00 | ES | Futures | 1168.03 | 1172.29 | 1168.03 | 1171.79 | 5445.0 |
| 2011-10-09 18:00:00 | NQ | Futures | 2544.16 | 2549.35 | 2540.7 | 2547.33 | 917.0 |
| 2011-10-09 19:00:00 | NQ | Futures | 2546.46 | 2558.0 | 2545.31 | 2556.84 | 778.0 |
| 2011-10-09 20:00:00 | NQ | Futures | 2557.42 | 2568.09 | 2557.42 | 2567.8 | 1074.0 |
| 2011-10-09 21:00:00 | NQ | Futures | 2567.8 | 2577.6 | 2566.36 | 2567.51 | 2285.0 |
| 2011-10-09 22:00:00 | NQ | Futures | 2568.38 | 2569.24 | 2563.19 | 2563.48 | 718.0 |
| 2011-10-09 23:00:00 | NQ | Futures | 2563.76 | 2570.97 | 2563.48 | 2570.97 | 520.0 |
| 2011-10-09 18:00:00 | YM | Futures | 10908.9 | 10937.5 | 10908.9 | 10923.7 | 175.0 |
| 2011-10-09 19:00:00 | YM | Futures | 10924.7 | 10971.9 | 10920.7 | 10967.0 | 427.0 |
| 2011-10-09 20:00:00 | YM | Futures | 10969.0 | 11036.9 | 10967.0 | 11016.2 | 841.0 |
| 2011-10-09 21:00:00 | YM | Futures | 11017.2 | 11035.0 | 10998.5 | 11006.4 | 757.0 |
| 2011-10-09 22:00:00 | YM | Futures | 11006.4 | 11006.4 | 10980.8 | 10981.8 | 559.0 |
| 2011-10-09 23:00:00 | YM | Futures | 10981.8 | 11012.3 | 10981.8 | 11010.3 | 431.0 |
| 2011-10-09 18:00:00 | CL | Futures | 140.08 | 140.74 | 140.08 | 140.67 | 781.0 |
| 2011-10-09 19:00:00 | CL | Futures | 140.67 | 141.24 | 140.6 | 141.19 | 602.0 |
| 2011-10-09 20:00:00 | CL | Futures | 141.14 | 141.82 | 141.06 | 141.77 | 912.0 |
| 2011-10-09 21:00:00 | CL | Futures | 141.77 | 142.14 | 141.62 | 141.75 | 1403.0 |
| 2011-10-09 22:00:00 | CL | Futures | 141.72 | 141.82 | 141.21 | 141.21 | 690.0 |
| 2011-10-09 23:00:00 | CL | Futures | 141.23 | 141.62 | 141.11 | 141.58 | 740.0 |
| 2011-10-09 18:00:00 | GC | Futures | 2284.6 | 2291.5 | 2283.7 | 2286.6 | 662.0 |
| 2011-10-09 19:00:00 | GC | Futures | 2286.6 | 2294.7 | 2285.7 | 2291.9 | 649.0 |
| 2011-10-09 20:00:00 | GC | Futures | 2292.9 | 2297.1 | 2292.2 | 2296.5 | 1020.0 |
| 2011-10-09 21:00:00 | GC | Futures | 2296.5 | 2304.6 | 2296.5 | 2304.0 | 2660.0 |
| 2011-10-09 22:00:00 | GC | Futures | 2304.2 | 2305.7 | 2296.5 | 2300.7 | 1927.0 |
| 2011-10-09 23:00:00 | GC | Futures | 2300.8 | 2304.7 | 2297.8 | 2301.7 | 1084.0 |
| 2011-10-09 18:00:00 | ZN | Futures | 111.76064 | 111.814853 | 111.733533 | 111.733533 | 1709.0 |
| 2011-10-09 19:00:00 | ZN | Futures | 111.733533 | 111.76064 | 111.692873 | 111.706427 | 1024.0 |
| 2011-10-09 20:00:00 | ZN | Futures | 111.692873 | 111.706427 | 111.611553 | 111.611553 | 3928.0 |
| 2011-10-09 21:00:00 | ZN | Futures | 111.611553 | 111.625107 | 111.55734 | 111.611553 | 3968.0 |
| 2011-10-09 22:00:00 | ZN | Futures | 111.611553 | 111.67932 | 111.598 | 111.67932 | 1660.0 |
| 2011-10-09 23:00:00 | ZN | Futures | 111.67932 | 111.692873 | 111.584447 | 111.598 | 1834.0 |
> showing 36 of 257 rows — these rows as CSV