PREVIEW / futures_1hour / 2011-10-02
file: by_date/futures_1hour/2011/2011-10-02.parquet size: 14 KB rows: 277
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-02 18:00:00 | ES | Futures | 1126.41 | 1126.66 | 1122.89 | 1126.15 | 21118.0 |
| 2011-10-02 19:00:00 | ES | Futures | 1126.15 | 1130.42 | 1126.15 | 1129.41 | 10008.0 |
| 2011-10-02 20:00:00 | ES | Futures | 1129.16 | 1129.41 | 1125.15 | 1126.15 | 8100.0 |
| 2011-10-02 21:00:00 | ES | Futures | 1126.66 | 1131.92 | 1125.65 | 1125.9 | 16883.0 |
| 2011-10-02 22:00:00 | ES | Futures | 1126.15 | 1127.91 | 1121.89 | 1122.89 | 13448.0 |
| 2011-10-02 23:00:00 | ES | Futures | 1123.15 | 1124.15 | 1119.89 | 1120.64 | 10026.0 |
| 2011-10-02 18:00:00 | NQ | Futures | 2452.47 | 2452.47 | 2442.67 | 2450.16 | 1701.0 |
| 2011-10-02 19:00:00 | NQ | Futures | 2450.16 | 2458.81 | 2450.16 | 2457.37 | 997.0 |
| 2011-10-02 20:00:00 | NQ | Futures | 2455.93 | 2457.08 | 2450.45 | 2452.18 | 1421.0 |
| 2011-10-02 21:00:00 | NQ | Futures | 2452.18 | 2461.99 | 2449.59 | 2450.16 | 1559.0 |
| 2011-10-02 22:00:00 | NQ | Futures | 2450.45 | 2454.78 | 2444.11 | 2444.97 | 1283.0 |
| 2011-10-02 23:00:00 | NQ | Futures | 2444.97 | 2446.42 | 2438.05 | 2438.92 | 1236.0 |
| 2011-10-02 18:00:00 | YM | Futures | 10656.9 | 10664.8 | 10618.5 | 10646.1 | 734.0 |
| 2011-10-02 19:00:00 | YM | Futures | 10647.0 | 10679.5 | 10647.0 | 10671.6 | 636.0 |
| 2011-10-02 20:00:00 | YM | Futures | 10669.7 | 10672.6 | 10638.2 | 10648.0 | 543.0 |
| 2011-10-02 21:00:00 | YM | Futures | 10647.0 | 10693.3 | 10642.1 | 10646.1 | 1167.0 |
| 2011-10-02 22:00:00 | YM | Futures | 10644.1 | 10663.8 | 10610.6 | 10614.5 | 802.0 |
| 2011-10-02 23:00:00 | YM | Futures | 10614.5 | 10630.3 | 10595.8 | 10598.8 | 1059.0 |
| 2011-10-02 18:00:00 | CL | Futures | 133.59 | 133.61 | 131.87 | 132.15 | 2584.0 |
| 2011-10-02 19:00:00 | CL | Futures | 132.15 | 132.95 | 132.15 | 132.83 | 1102.0 |
| 2011-10-02 20:00:00 | CL | Futures | 132.83 | 132.97 | 132.54 | 132.73 | 850.0 |
| 2011-10-02 21:00:00 | CL | Futures | 132.73 | 133.35 | 132.56 | 132.86 | 1564.0 |
| 2011-10-02 22:00:00 | CL | Futures | 132.86 | 133.0 | 132.29 | 132.46 | 1238.0 |
| 2011-10-02 23:00:00 | CL | Futures | 132.44 | 132.46 | 131.95 | 132.02 | 991.0 |
| 2011-10-02 18:00:00 | GC | Futures | 2263.1 | 2270.5 | 2256.0 | 2268.5 | 1574.0 |
| 2011-10-02 19:00:00 | GC | Futures | 2268.3 | 2275.9 | 2266.0 | 2271.3 | 1151.0 |
| 2011-10-02 20:00:00 | GC | Futures | 2271.3 | 2274.1 | 2264.9 | 2270.5 | 1496.0 |
| 2011-10-02 21:00:00 | GC | Futures | 2269.8 | 2281.8 | 2268.5 | 2274.7 | 2584.0 |
| 2011-10-02 22:00:00 | GC | Futures | 2274.8 | 2280.0 | 2274.2 | 2276.9 | 799.0 |
| 2011-10-02 23:00:00 | GC | Futures | 2277.5 | 2279.0 | 2269.5 | 2271.0 | 2251.0 |
| 2011-10-02 18:00:00 | ZN | Futures | 112.899118 | 113.075312 | 112.899118 | 112.980438 | 2801.0 |
| 2011-10-02 19:00:00 | ZN | Futures | 112.993992 | 112.993992 | 112.912672 | 112.912672 | 2180.0 |
| 2011-10-02 20:00:00 | ZN | Futures | 112.912672 | 112.939778 | 112.899118 | 112.939778 | 5018.0 |
| 2011-10-02 21:00:00 | ZN | Futures | 112.939778 | 112.980438 | 112.926225 | 112.966885 | 3910.0 |
| 2011-10-02 22:00:00 | ZN | Futures | 112.966885 | 112.993992 | 112.939778 | 112.966885 | 2262.0 |
| 2011-10-02 23:00:00 | ZN | Futures | 112.966885 | 113.061758 | 112.966885 | 113.061758 | 4108.0 |
> showing 36 of 277 rows — these rows as CSV