PREVIEW / futures_daily / 2011-09-16
file: by_date/futures_daily/2011/2011-09-16.parquet size: 9 KB rows: 98
schema
date DATE symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| date | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2011-09-16 | ES | Futures | 1200.89 | 1212.37 | 1192.66 | 1209.63 | 2661191.0 |
| 2011-09-16 | NQ | Futures | 2603.95 | 2634.77 | 2590.25 | 2633.63 | 313377.0 |
| 2011-09-16 | YM | Futures | 10916.0 | 11009.2 | 10854.5 | 10995.7 | 115896.0 |
| 2011-09-16 | CL | Futures | 168.55 | 169.57 | 164.46 | 166.27 | 181501.0 |
| 2011-09-16 | GC | Futures | 2417.5 | 2464.0 | 2383.6 | 2450.1 | 190164.0 |
| 2011-09-16 | ZN | Futures | 111.133976 | 111.375309 | 110.852421 | 111.174198 | 897502.0 |
| 2011-09-16 | A6 | Futures | 0.89882 | 0.90453 | 0.89539 | 0.90277 | 95925.0 |
| 2011-09-16 | AD | Futures | 1.01536 | 1.02096 | 1.01266 | 1.01936 | 78364.0 |
| 2011-09-16 | B | Futures | 96.5 | 98.03 | 95.68 | 96.29 | 212227.0 |
| 2011-09-16 | B6 | Futures | 1.6476 | 1.6518 | 1.6416 | 1.6463 | 87036.0 |
| 2011-09-16 | BFX | Futures | 2585.0 | 2614.4 | 2585.0 | 2592.1 | 30.0 |
| 2011-09-16 | BR | Futures | 0.26181 | 0.26194 | 0.25675 | 0.25882 | 143.0 |
| 2011-09-16 | BZ | Futures | 100.24 | 101.48 | 99.2 | 99.74 | 741.0 |
| 2011-09-16 | C | Futures | 1926.0 | 1932.0 | 1911.0 | 1913.0 | 5818.0 |
| 2011-09-16 | CB | Futures | 95.888 | 95.888 | 95.888 | 95.888 | 9.0 |
| 2011-09-16 | CC | Futures | 2192.0 | 2202.0 | 2180.0 | 2189.0 | 6394.0 |
| 2011-09-16 | CSC | Futures | 4.339 | 4.341 | 4.317 | 4.329 | 19.0 |
| 2011-09-16 | CT | Futures | 141.71 | 142.54 | 141.39 | 141.56 | 13.0 |
| 2011-09-16 | DC | Futures | 30.21 | 30.3 | 30.13 | 30.23 | 142.0 |
| 2011-09-16 | DX | Futures | 75.415 | 75.891 | 75.41 | 75.682 | 33026.0 |
| 2011-09-16 | E1 | Futures | 1.51356 | 1.51408 | 1.49873 | 1.50201 | 19307.0 |
| 2011-09-16 | E6 | Futures | 1.658 | 1.658 | 1.64222 | 1.64736 | 301357.0 |
| 2011-09-16 | E7 | Futures | 1.6426 | 1.6435 | 1.6283 | 1.6333 | 3913.0 |
| 2011-09-16 | ED | Futures | 95.0127 | 95.0223 | 94.9841 | 95.0032 | 285915.0 |
| 2011-09-16 | ER | Futures | 97.292 | 97.371 | 97.278 | 97.347 | 153434.0 |
| 2011-09-16 | EW | Futures | 866.5 | 873.3 | 858.7 | 867.1 | 24338.0 |
| 2011-09-16 | FBTP | Futures | 62.14 | 63.13 | 61.92 | 62.46 | 7422.0 |
| 2011-09-16 | FBTS | Futures | 81.414 | 82.104 | 81.414 | 81.791 | 1672.0 |
| 2011-09-16 | FCE | Futures | 2189.2 | 2199.2 | 2144.9 | 2158.1 | 138498.0 |
| 2011-09-16 | FDAX | Futures | 5954.3 | 6022.6 | 5907.8 | 5957.9 | 43245.0 |
| 2011-09-16 | FESX | Futures | 1436.1 | 1451.4 | 1413.5 | 1418.1 | 1774363.0 |
| 2011-09-16 | FEU3 | Futures | 97.846 | 97.905 | 97.846 | 97.905 | 241.0 |
| 2011-09-16 | FGBL | Futures | 110.14 | 110.71 | 109.78 | 110.56 | 876096.0 |
| 2011-09-16 | FGBM | Futures | 110.4 | 110.84 | 110.23 | 110.71 | 441293.0 |
| 2011-09-16 | FGBS | Futures | 108.91 | 109.133 | 108.88 | 109.049 | 541729.0 |
| 2011-09-16 | FGBX | Futures | 110.31 | 112.03 | 109.83 | 111.76 | 10120.0 |
| 2011-09-16 | FTDX | Futures | 654.1 | 654.1 | 644.9 | 649.5 | 646.0 |
| 2011-09-16 | FTI | Futures | 233.38 | 236.12 | 231.13 | 233.92 | 51938.0 |
| 2011-09-16 | FTUK | Futures | 3844.7 | 3864.4 | 3813.8 | 3826.4 | 133390.0 |
| 2011-09-16 | FVSA | Futures | 16905.66 | 17159.25 | 16673.21 | 16990.19 | 3955.0 |
| 2011-09-16 | FXXP | Futures | 160.1 | 161.5 | 158.8 | 159.5 | 2445.0 |
| 2011-09-16 | G | Futures | 91.58 | 91.86 | 91.35 | 91.71 | 96138.0 |
| 2011-09-16 | GF | Futures | 312.001 | 313.36 | 309.511 | 311.265 | 2423.0 |
| 2011-09-16 | GSCI | Futures | 1043.97 | 1047.85 | 1030.58 | 1034.78 | 173.0 |
| 2011-09-16 | HE | Futures | 108.947 | 109.435 | 106.687 | 106.687 | 14924.0 |
| 2011-09-16 | HG | Futures | 5.2429 | 5.2898 | 5.1939 | 5.2025 | 24998.0 |
| 2011-09-16 | HO | Futures | 2.4417 | 2.4606 | 2.4164 | 2.4278 | 15819.0 |
| 2011-09-16 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-16 | J1 | Futures | 0.0164027 | 0.0164077 | 0.0163423 | 0.0163662 | 79695.0 |
| 2011-09-16 | J7 | Futures | 0.016292 | 0.016308 | 0.016243 | 0.016267 | 287.0 |
> showing 50 of 98 rows — these rows as CSV