PREVIEW / futures_daily / 2011-12-29
file: by_date/futures_daily/2011/2011-12-29.parquet size: 9 KB rows: 95
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-29 | ES | Futures | 1248.44 | 1262.99 | 1248.19 | 1261.98 | 878740.0 |
| 2011-12-29 | NQ | Futures | 2587.1 | 2609.69 | 2582.53 | 2604.26 | 100733.0 |
| 2011-12-29 | YM | Futures | 11682.3 | 11826.4 | 11680.3 | 11814.8 | 60957.0 |
| 2011-12-29 | CL | Futures | 186.12 | 186.74 | 183.71 | 186.24 | 153915.0 |
| 2011-12-29 | GC | Futures | 2102.3 | 2110.0 | 2057.5 | 2080.5 | 132782.0 |
| 2011-12-29 | ZN | Futures | 112.84119 | 113.138248 | 112.706164 | 113.070735 | 276282.0 |
| 2011-12-29 | A6 | Futures | 0.89038 | 0.89545 | 0.8861 | 0.89358 | 55558.0 |
| 2011-12-29 | AD | Futures | 0.97783 | 0.98214 | 0.97572 | 0.98084 | 34608.0 |
| 2011-12-29 | B | Futures | 95.31 | 95.91 | 94.57 | 95.82 | 59297.0 |
| 2011-12-29 | B6 | Futures | 1.6151 | 1.6167 | 1.6046 | 1.608 | 56278.0 |
| 2011-12-29 | BFX | Futures | 2453.5 | 2478.4 | 2453.5 | 2473.3 | 37.0 |
| 2011-12-29 | BR | Futures | 0.24692 | 0.24762 | 0.24671 | 0.24762 | 329.0 |
| 2011-12-29 | BZ | Futures | 100.73 | 101.69 | 100.73 | 101.69 | 317.0 |
| 2011-12-29 | C | Futures | 1425.0 | 1425.0 | 1389.0 | 1391.0 | 5660.0 |
| 2011-12-29 | CC | Futures | 1646.0 | 1663.0 | 1609.0 | 1615.0 | 5223.0 |
| 2011-12-29 | CSC | Futures | 4.0 | 4.022 | 4.0 | 4.022 | 7.0 |
| 2011-12-29 | CT | Futures | 116.47 | 118.61 | 115.31 | 118.01 | 6424.0 |
| 2011-12-29 | DC | Futures | 29.03 | 29.43 | 28.95 | 29.43 | 197.0 |
| 2011-12-29 | DX | Futures | 78.921 | 79.14 | 78.615 | 78.752 | 15433.0 |
| 2011-12-29 | E1 | Futures | 1.39519 | 1.39979 | 1.38824 | 1.39598 | 11321.0 |
| 2011-12-29 | E6 | Futures | 1.54839 | 1.55138 | 1.53823 | 1.54756 | 141379.0 |
| 2011-12-29 | E7 | Futures | 1.5339 | 1.5368 | 1.5243 | 1.5334 | 3245.0 |
| 2011-12-29 | EBM | Futures | 253.23 | 256.18 | 251.59 | 254.54 | 5802.0 |
| 2011-12-29 | ED | Futures | 94.8814 | 94.9053 | 94.8766 | 94.8957 | 89690.0 |
| 2011-12-29 | ER | Futures | 97.253 | 97.272 | 97.233 | 97.267 | 64172.0 |
| 2011-12-29 | EW | Futures | 876.3 | 888.1 | 876.3 | 887.1 | 13426.0 |
| 2011-12-29 | FBTP | Futures | 57.83 | 57.92 | 57.29 | 57.77 | 9157.0 |
| 2011-12-29 | FBTS | Futures | 80.001 | 80.21 | 79.889 | 80.041 | 886.0 |
| 2011-12-29 | FCE | Futures | 2204.1 | 2255.3 | 2194.8 | 2241.3 | 37723.0 |
| 2011-12-29 | FDAX | Futures | 6399.5 | 6500.5 | 6383.5 | 6443.1 | 67159.0 |
| 2011-12-29 | FESX | Futures | 1508.3 | 1539.7 | 1498.9 | 1523.0 | 453947.0 |
| 2011-12-29 | FGBL | Futures | 112.04 | 112.45 | 111.78 | 112.42 | 164888.0 |
| 2011-12-29 | FGBM | Futures | 112.88 | 113.11 | 112.7 | 113.08 | 117330.0 |
| 2011-12-29 | FGBS | Futures | 109.899 | 109.914 | 109.84 | 109.894 | 89116.0 |
| 2011-12-29 | FGBX | Futures | 117.88 | 118.53 | 117.49 | 118.51 | 2430.0 |
| 2011-12-29 | FTDX | Futures | 627.0 | 627.9 | 623.3 | 627.0 | 48.0 |
| 2011-12-29 | FTI | Futures | 258.2 | 261.85 | 256.35 | 260.72 | 22382.0 |
| 2011-12-29 | FTUK | Futures | 3942.1 | 4008.5 | 3934.5 | 3973.5 | 39080.0 |
| 2011-12-29 | FVSA | Futures | 13019.08 | 13338.08 | 12979.2 | 13098.83 | 791.0 |
| 2011-12-29 | FXXP | Futures | 169.4 | 170.6 | 169.1 | 170.3 | 232.0 |
| 2011-12-29 | G | Futures | 94.34 | 95.12 | 94.31 | 95.0 | 33701.0 |
| 2011-12-29 | GF | Futures | 317.295 | 318.049 | 316.003 | 316.38 | 1303.0 |
| 2011-12-29 | GSCI | Futures | 1013.45 | 1015.57 | 1005.3 | 1013.3 | 128.0 |
| 2011-12-29 | HE | Futures | 105.219 | 105.373 | 103.37 | 103.524 | 15279.0 |
| 2011-12-29 | HG | Futures | 4.4252 | 4.4866 | 4.3857 | 4.445 | 23309.0 |
| 2011-12-29 | HO | Futures | 2.3527 | 2.3694 | 2.3404 | 2.3595 | 14562.0 |
| 2011-12-29 | HRC | Futures | 2845.4 | 2845.4 | 2845.4 | 2845.4 | 25.0 |
| 2011-12-29 | J1 | Futures | 0.0161363 | 0.0162054 | 0.0161301 | 0.0161954 | 47379.0 |
| 2011-12-29 | J7 | Futures | 0.016081 | 0.016137 | 0.016072 | 0.016128 | 232.0 |
| 2011-12-29 | JB | Futures | 124.36 | 124.64 | 124.36 | 124.46 | 1031.0 |
> showing 50 of 95 rows — these rows as CSV