PREVIEW / futures_daily / 2011-12-08
file: by_date/futures_daily/2011/2011-12-08.parquet size: 9 KB rows: 97
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-12-08 | ES | Futures | 1261.53 | 1269.77 | 1228.59 | 1233.83 | 2442801.0 |
| 2011-12-08 | NQ | Futures | 2651.32 | 2672.15 | 2599.95 | 2608.51 | 215994.0 |
| 2011-12-08 | YM | Futures | 11730.6 | 11809.4 | 11486.6 | 11539.4 | 135583.0 |
| 2011-12-08 | CL | Futures | 189.04 | 190.71 | 183.18 | 184.36 | 340677.0 |
| 2011-12-08 | GC | Futures | 2358.5 | 2376.9 | 2305.8 | 2313.4 | 173374.0 |
| 2011-12-08 | ZN | Futures | 112.206568 | 112.706164 | 111.814993 | 112.665657 | 1025848.0 |
| 2011-12-08 | A6 | Futures | 0.90392 | 0.91201 | 0.89125 | 0.89363 | 171573.0 |
| 2011-12-08 | AD | Futures | 0.99115 | 0.99505 | 0.97734 | 0.98024 | 96012.0 |
| 2011-12-08 | B | Futures | 97.51 | 98.48 | 95.46 | 96.2 | 114203.0 |
| 2011-12-08 | B6 | Futures | 1.6392 | 1.6458 | 1.629 | 1.6324 | 103543.0 |
| 2011-12-08 | BFX | Futures | 2484.5 | 2484.5 | 2434.7 | 2434.7 | 24.0 |
| 2011-12-08 | BR | Futures | 0.2549 | 0.2549 | 0.25352 | 0.25352 | 59.0 |
| 2011-12-08 | BZ | Futures | 103.28 | 103.28 | 102.09 | 102.09 | 1078.0 |
| 2011-12-08 | C | Futures | 1408.0 | 1415.0 | 1370.0 | 1394.0 | 26236.0 |
| 2011-12-08 | CC | Futures | 1659.0 | 1670.0 | 1611.0 | 1652.0 | 12153.0 |
| 2011-12-08 | CSC | Futures | 3.976 | 3.978 | 3.964 | 3.978 | 12.0 |
| 2011-12-08 | CT | Futures | 119.25 | 119.77 | 118.05 | 118.56 | 4252.0 |
| 2011-12-08 | DC | Futures | 28.54 | 28.7 | 28.49 | 28.65 | 170.0 |
| 2011-12-08 | DX | Futures | 77.055 | 77.644 | 76.721 | 77.469 | 22537.0 |
| 2011-12-08 | E1 | Futures | 1.42053 | 1.42997 | 1.41239 | 1.41554 | 37584.0 |
| 2011-12-08 | E6 | Futures | 1.60338 | 1.60887 | 1.5882 | 1.59393 | 366724.0 |
| 2011-12-08 | E7 | Futures | 1.5896 | 1.5951 | 1.5747 | 1.5803 | 5015.0 |
| 2011-12-08 | EBM | Futures | 230.3 | 230.62 | 228.0 | 229.64 | 8983.0 |
| 2011-12-08 | ED | Futures | 94.9387 | 94.9602 | 94.9316 | 94.9435 | 161691.0 |
| 2011-12-08 | ER | Futures | 97.307 | 97.327 | 97.194 | 97.204 | 383285.0 |
| 2011-12-08 | EW | Futures | 893.2 | 900.2 | 865.4 | 869.2 | 48915.0 |
| 2011-12-08 | FBTP | Futures | 60.54 | 60.86 | 58.27 | 58.49 | 15374.0 |
| 2011-12-08 | FBTS | Futures | 78.99 | 79.311 | 77.465 | 77.553 | 1017.0 |
| 2011-12-08 | FCE | Futures | 2296.4 | 2301.4 | 2189.9 | 2208.1 | 128213.0 |
| 2011-12-08 | FDAX | Futures | 6590.9 | 6602.3 | 6314.6 | 6383.5 | 209350.0 |
| 2011-12-08 | FESX | Futures | 1575.0 | 1579.0 | 1507.9 | 1521.8 | 1568687.0 |
| 2011-12-08 | FEU3 | Futures | 97.866 | 97.88 | 97.762 | 97.762 | 108.0 |
| 2011-12-08 | FGBL | Futures | 109.85 | 110.87 | 109.39 | 110.72 | 673339.0 |
| 2011-12-08 | FGBM | Futures | 111.77 | 112.27 | 111.62 | 112.25 | 476183.0 |
| 2011-12-08 | FGBS | Futures | 109.606 | 109.67 | 109.521 | 109.66 | 525851.0 |
| 2011-12-08 | FGBX | Futures | 113.4 | 114.12 | 111.38 | 113.84 | 6662.0 |
| 2011-12-08 | FTDX | Futures | 632.0 | 635.3 | 614.6 | 618.2 | 377.0 |
| 2011-12-08 | FTI | Futures | 257.74 | 258.66 | 250.05 | 251.82 | 47906.0 |
| 2011-12-08 | FTUK | Futures | 4010.4 | 4024.4 | 3905.3 | 3942.3 | 131308.0 |
| 2011-12-08 | FVSA | Futures | 15102.31 | 15852.07 | 15016.63 | 15702.12 | 1931.0 |
| 2011-12-08 | FXXP | Futures | 169.6 | 170.1 | 165.8 | 166.0 | 1971.0 |
| 2011-12-08 | G | Futures | 92.91 | 93.84 | 92.7 | 93.66 | 131426.0 |
| 2011-12-08 | GF | Futures | 308.033 | 309.594 | 306.633 | 306.902 | 2188.0 |
| 2011-12-08 | GSCI | Futures | 1017.12 | 1017.12 | 998.9 | 1000.06 | 1424.0 |
| 2011-12-08 | HE | Futures | 109.287 | 109.626 | 107.53 | 107.561 | 16864.0 |
| 2011-12-08 | HG | Futures | 4.6936 | 4.7543 | 4.5888 | 4.6165 | 47224.0 |
| 2011-12-08 | HO | Futures | 2.4414 | 2.4554 | 2.3708 | 2.3833 | 20137.0 |
| 2011-12-08 | HRC | Futures | 2745.9 | 2745.9 | 2745.9 | 2745.9 | 0.0 |
| 2011-12-08 | J1 | Futures | 0.0161803 | 0.0162946 | 0.0161489 | 0.0161778 | 106935.0 |
| 2011-12-08 | J7 | Futures | 0.016083 | 0.016193 | 0.016053 | 0.01608 | 434.0 |
> showing 50 of 97 rows — these rows as CSV