PREVIEW / futures_1hour / 2011-08-07
file: by_date/futures_1hour/2011/2011-08-07.parquet size: 15 KB rows: 279
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-07 18:00:00 | ES | Futures | 1164.47 | 1170.46 | 1158.74 | 1166.47 | 141245.0 |
| 2011-08-07 19:00:00 | ES | Futures | 1166.47 | 1174.7 | 1165.47 | 1168.46 | 46998.0 |
| 2011-08-07 20:00:00 | ES | Futures | 1168.46 | 1176.2 | 1167.97 | 1173.95 | 39588.0 |
| 2011-08-07 21:00:00 | ES | Futures | 1173.95 | 1176.2 | 1169.96 | 1175.95 | 24234.0 |
| 2011-08-07 22:00:00 | ES | Futures | 1176.2 | 1176.2 | 1169.21 | 1169.46 | 15925.0 |
| 2011-08-07 23:00:00 | ES | Futures | 1169.71 | 1170.46 | 1164.72 | 1167.22 | 17934.0 |
| 2011-08-07 18:00:00 | NQ | Futures | 2469.03 | 2471.04 | 2446.87 | 2462.12 | 8045.0 |
| 2011-08-07 19:00:00 | NQ | Futures | 2461.54 | 2477.95 | 2460.39 | 2466.72 | 2945.0 |
| 2011-08-07 20:00:00 | NQ | Futures | 2466.72 | 2481.69 | 2465.57 | 2476.8 | 3391.0 |
| 2011-08-07 21:00:00 | NQ | Futures | 2476.8 | 2481.69 | 2467.01 | 2479.96 | 3456.0 |
| 2011-08-07 22:00:00 | NQ | Futures | 2479.96 | 2479.96 | 2463.85 | 2465.86 | 1233.0 |
| 2011-08-07 23:00:00 | NQ | Futures | 2466.15 | 2469.03 | 2455.79 | 2461.26 | 1527.0 |
| 2011-08-07 18:00:00 | YM | Futures | 10806.4 | 10834.5 | 10727.0 | 10780.2 | 14772.0 |
| 2011-08-07 19:00:00 | YM | Futures | 10777.3 | 10850.9 | 10776.3 | 10802.5 | 3816.0 |
| 2011-08-07 20:00:00 | YM | Futures | 10802.5 | 10870.3 | 10799.6 | 10853.8 | 3938.0 |
| 2011-08-07 21:00:00 | YM | Futures | 10851.9 | 10873.2 | 10817.0 | 10871.3 | 3678.0 |
| 2011-08-07 22:00:00 | YM | Futures | 10870.3 | 10872.2 | 10810.2 | 10810.2 | 2788.0 |
| 2011-08-07 23:00:00 | YM | Futures | 10812.2 | 10819.0 | 10771.5 | 10796.7 | 2664.0 |
| 2011-08-07 18:00:00 | CL | Futures | 146.24 | 146.27 | 142.77 | 143.29 | 12621.0 |
| 2011-08-07 19:00:00 | CL | Futures | 143.27 | 144.63 | 143.23 | 143.99 | 3078.0 |
| 2011-08-07 20:00:00 | CL | Futures | 144.0 | 144.7 | 143.7 | 143.85 | 2070.0 |
| 2011-08-07 21:00:00 | CL | Futures | 143.85 | 144.26 | 143.32 | 144.24 | 1987.0 |
| 2011-08-07 22:00:00 | CL | Futures | 144.22 | 144.68 | 143.59 | 143.59 | 1481.0 |
| 2011-08-07 23:00:00 | CL | Futures | 143.58 | 143.64 | 142.6 | 142.83 | 2136.0 |
| 2011-08-07 18:00:00 | GC | Futures | 2341.9 | 2364.2 | 2341.9 | 2352.5 | 17032.0 |
| 2011-08-07 19:00:00 | GC | Futures | 2352.5 | 2355.6 | 2347.8 | 2354.3 | 3766.0 |
| 2011-08-07 20:00:00 | GC | Futures | 2354.9 | 2355.2 | 2346.4 | 2352.5 | 4374.0 |
| 2011-08-07 21:00:00 | GC | Futures | 2352.8 | 2364.6 | 2352.2 | 2361.0 | 8335.0 |
| 2011-08-07 22:00:00 | GC | Futures | 2360.9 | 2365.9 | 2359.6 | 2362.8 | 3872.0 |
| 2011-08-07 23:00:00 | GC | Futures | 2362.8 | 2371.2 | 2362.5 | 2369.1 | 5220.0 |
| 2011-08-07 18:00:00 | ZN | Futures | 109.52218 | 109.697072 | 109.374196 | 109.602899 | 53978.0 |
| 2011-08-07 19:00:00 | ZN | Futures | 109.602899 | 109.602899 | 109.320383 | 109.441461 | 33794.0 |
| 2011-08-07 20:00:00 | ZN | Futures | 109.441461 | 109.52218 | 109.333836 | 109.401102 | 24180.0 |
| 2011-08-07 21:00:00 | ZN | Futures | 109.401102 | 109.495274 | 109.387649 | 109.428008 | 16424.0 |
| 2011-08-07 22:00:00 | ZN | Futures | 109.414555 | 109.56254 | 109.374196 | 109.481821 | 11656.0 |
| 2011-08-07 23:00:00 | ZN | Futures | 109.481821 | 109.750884 | 109.481821 | 109.710525 | 25212.0 |
> showing 36 of 279 rows — these rows as CSV