PREVIEW / futures_1hour / 2011-10-30
file: by_date/futures_1hour/2011/2011-10-30.parquet size: 15 KB rows: 278
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-30 18:00:00 | ES | Futures | 1283.88 | 1284.63 | 1279.12 | 1279.37 | 7579.0 |
| 2011-10-30 19:00:00 | ES | Futures | 1279.37 | 1280.37 | 1277.61 | 1277.86 | 5277.0 |
| 2011-10-30 20:00:00 | ES | Futures | 1277.86 | 1279.37 | 1277.11 | 1278.87 | 5023.0 |
| 2011-10-30 21:00:00 | ES | Futures | 1278.87 | 1282.13 | 1278.36 | 1280.37 | 11197.0 |
| 2011-10-30 22:00:00 | ES | Futures | 1280.37 | 1281.37 | 1276.86 | 1278.36 | 9257.0 |
| 2011-10-30 23:00:00 | ES | Futures | 1278.36 | 1279.37 | 1275.86 | 1275.86 | 6628.0 |
| 2011-10-30 18:00:00 | NQ | Futures | 2765.3 | 2765.59 | 2755.79 | 2755.79 | 764.0 |
| 2011-10-30 19:00:00 | NQ | Futures | 2756.07 | 2757.23 | 2751.17 | 2752.33 | 436.0 |
| 2011-10-30 20:00:00 | NQ | Futures | 2752.33 | 2755.21 | 2750.88 | 2754.63 | 364.0 |
| 2011-10-30 21:00:00 | NQ | Futures | 2754.06 | 2760.4 | 2753.19 | 2757.23 | 931.0 |
| 2011-10-30 22:00:00 | NQ | Futures | 2757.23 | 2758.67 | 2746.56 | 2750.02 | 1355.0 |
| 2011-10-30 23:00:00 | NQ | Futures | 2750.31 | 2751.17 | 2746.56 | 2746.56 | 815.0 |
| 2011-10-30 18:00:00 | YM | Futures | 11964.4 | 11972.3 | 11931.9 | 11931.9 | 242.0 |
| 2011-10-30 19:00:00 | YM | Futures | 11933.9 | 11939.8 | 11921.1 | 11925.0 | 278.0 |
| 2011-10-30 20:00:00 | YM | Futures | 11925.0 | 11936.8 | 11916.1 | 11933.9 | 334.0 |
| 2011-10-30 21:00:00 | YM | Futures | 11931.9 | 11957.5 | 11927.9 | 11941.7 | 738.0 |
| 2011-10-30 22:00:00 | YM | Futures | 11940.7 | 11950.6 | 11916.1 | 11928.9 | 1037.0 |
| 2011-10-30 23:00:00 | YM | Futures | 11927.0 | 11932.9 | 11906.3 | 11908.3 | 588.0 |
| 2011-10-30 18:00:00 | CL | Futures | 157.78 | 158.24 | 157.59 | 157.93 | 656.0 |
| 2011-10-30 19:00:00 | CL | Futures | 157.95 | 157.98 | 157.31 | 157.31 | 522.0 |
| 2011-10-30 20:00:00 | CL | Futures | 157.31 | 157.59 | 156.97 | 157.48 | 612.0 |
| 2011-10-30 21:00:00 | CL | Futures | 157.43 | 157.81 | 156.8 | 157.02 | 1165.0 |
| 2011-10-30 22:00:00 | CL | Futures | 157.0 | 157.17 | 156.3 | 156.51 | 1507.0 |
| 2011-10-30 23:00:00 | CL | Futures | 156.48 | 156.53 | 155.87 | 156.16 | 1008.0 |
| 2011-10-30 18:00:00 | GC | Futures | 2427.4 | 2431.5 | 2426.3 | 2428.8 | 542.0 |
| 2011-10-30 19:00:00 | GC | Futures | 2428.7 | 2432.2 | 2426.6 | 2428.5 | 930.0 |
| 2011-10-30 20:00:00 | GC | Futures | 2428.8 | 2430.8 | 2426.0 | 2428.5 | 794.0 |
| 2011-10-30 21:00:00 | GC | Futures | 2428.8 | 2431.9 | 2403.8 | 2406.7 | 9048.0 |
| 2011-10-30 22:00:00 | GC | Futures | 2407.2 | 2410.6 | 2378.1 | 2388.3 | 10938.0 |
| 2011-10-30 23:00:00 | GC | Futures | 2388.3 | 2392.9 | 2379.7 | 2385.9 | 4967.0 |
| 2011-10-30 18:00:00 | ZN | Futures | 111.028761 | 111.137187 | 111.001654 | 111.137187 | 4891.0 |
| 2011-10-30 19:00:00 | ZN | Futures | 111.123634 | 111.164294 | 111.096527 | 111.150741 | 2878.0 |
| 2011-10-30 20:00:00 | ZN | Futures | 111.150741 | 111.191401 | 111.137187 | 111.150741 | 5561.0 |
| 2011-10-30 21:00:00 | ZN | Futures | 111.150741 | 111.150741 | 111.069421 | 111.150741 | 10641.0 |
| 2011-10-30 22:00:00 | ZN | Futures | 111.150741 | 111.204954 | 111.137187 | 111.164294 | 9225.0 |
| 2011-10-30 23:00:00 | ZN | Futures | 111.164294 | 111.232061 | 111.164294 | 111.204954 | 3031.0 |
> showing 36 of 278 rows — these rows as CSV