PREVIEW / futures_daily / 2011-12-09
file: by_date/futures_daily/2011/2011-12-09.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-12-09 | ES | Futures | 1233.33 | 1258.29 | 1226.35 | 1256.54 | 1143695.0 |
| 2011-12-09 | NQ | Futures | 2607.37 | 2656.17 | 2589.96 | 2650.46 | 124579.0 |
| 2011-12-09 | YM | Futures | 11535.6 | 11737.3 | 11486.6 | 11729.7 | 76114.0 |
| 2011-12-09 | CL | Futures | 183.87 | 187.3 | 182.52 | 186.36 | 318767.0 |
| 2011-12-09 | GC | Futures | 2307.3 | 2332.9 | 2301.9 | 2317.9 | 105584.0 |
| 2011-12-09 | ZN | Futures | 112.652154 | 112.760175 | 112.085045 | 112.206568 | 778149.0 |
| 2011-12-09 | A6 | Futures | 0.89328 | 0.89873 | 0.8829 | 0.89767 | 137529.0 |
| 2011-12-09 | AD | Futures | 0.97734 | 0.98374 | 0.97474 | 0.98234 | 78870.0 |
| 2011-12-09 | B | Futures | 95.8 | 97.03 | 95.34 | 96.67 | 94095.0 |
| 2011-12-09 | B6 | Futures | 1.6308 | 1.6421 | 1.6265 | 1.6345 | 91127.0 |
| 2011-12-09 | BFX | Futures | 2447.7 | 2480.0 | 2447.7 | 2480.0 | 37.0 |
| 2011-12-09 | BR | Futures | 0.25417 | 0.2542 | 0.25417 | 0.25417 | 40.0 |
| 2011-12-09 | BZ | Futures | 101.94 | 102.88 | 101.76 | 102.59 | 730.0 |
| 2011-12-09 | C | Futures | 1392.0 | 1406.0 | 1354.0 | 1356.0 | 8292.0 |
| 2011-12-09 | CB | Futures | 89.077 | 89.077 | 88.996 | 89.077 | 42.0 |
| 2011-12-09 | CC | Futures | 1650.0 | 1670.0 | 1592.0 | 1602.0 | 9983.0 |
| 2011-12-09 | CSC | Futures | 3.964 | 3.964 | 3.927 | 3.932 | 11.0 |
| 2011-12-09 | CT | Futures | 118.43 | 119.46 | 116.11 | 116.47 | 8265.0 |
| 2011-12-09 | DC | Futures | 28.51 | 28.53 | 28.14 | 28.24 | 125.0 |
| 2011-12-09 | DX | Futures | 77.433 | 77.737 | 77.05 | 77.242 | 14943.0 |
| 2011-12-09 | E1 | Futures | 1.41659 | 1.42932 | 1.41331 | 1.41961 | 23957.0 |
| 2011-12-09 | E6 | Futures | 1.59561 | 1.60565 | 1.58736 | 1.59812 | 295942.0 |
| 2011-12-09 | E7 | Futures | 1.5817 | 1.5918 | 1.5738 | 1.5845 | 3634.0 |
| 2011-12-09 | EBM | Futures | 229.31 | 230.3 | 225.38 | 229.97 | 10697.0 |
| 2011-12-09 | ED | Futures | 94.9316 | 94.9459 | 94.9316 | 94.9435 | 95283.0 |
| 2011-12-09 | ER | Futures | 97.204 | 97.209 | 97.164 | 97.174 | 159877.0 |
| 2011-12-09 | EW | Futures | 868.9 | 890.8 | 863.1 | 890.3 | 22622.0 |
| 2011-12-09 | FBTP | Futures | 58.57 | 59.21 | 57.46 | 58.91 | 16142.0 |
| 2011-12-09 | FBTS | Futures | 77.553 | 78.267 | 76.678 | 78.195 | 1314.0 |
| 2011-12-09 | FCE | Futures | 2188.5 | 2274.9 | 2178.9 | 2265.3 | 105592.0 |
| 2011-12-09 | FDAX | Futures | 6295.6 | 6546.4 | 6265.2 | 6504.0 | 191434.0 |
| 2011-12-09 | FESX | Futures | 1500.6 | 1565.0 | 1498.6 | 1557.7 | 1431442.0 |
| 2011-12-09 | FEU3 | Futures | 97.727 | 97.732 | 97.727 | 97.732 | 491.0 |
| 2011-12-09 | FGBL | Futures | 110.95 | 110.96 | 109.49 | 109.55 | 514028.0 |
| 2011-12-09 | FGBM | Futures | 112.29 | 112.3 | 111.66 | 111.68 | 279860.0 |
| 2011-12-09 | FGBS | Futures | 109.665 | 109.675 | 109.526 | 109.536 | 335930.0 |
| 2011-12-09 | FGBX | Futures | 114.29 | 114.42 | 112.27 | 112.36 | 5437.0 |
| 2011-12-09 | FTDX | Futures | 612.3 | 627.9 | 612.3 | 623.8 | 114.0 |
| 2011-12-09 | FTI | Futures | 249.67 | 257.15 | 249.13 | 255.93 | 43865.0 |
| 2011-12-09 | FTUK | Futures | 3928.6 | 3990.7 | 3887.0 | 3972.8 | 121604.0 |
| 2011-12-09 | FVSA | Futures | 15145.16 | 15252.26 | 14673.88 | 14673.88 | 3467.0 |
| 2011-12-09 | FXXP | Futures | 165.4 | 168.0 | 165.4 | 167.9 | 7475.0 |
| 2011-12-09 | G | Futures | 93.87 | 93.98 | 93.28 | 93.39 | 84486.0 |
| 2011-12-09 | GF | Futures | 307.01 | 307.333 | 304.855 | 306.094 | 2640.0 |
| 2011-12-09 | GSCI | Futures | 1004.25 | 1004.48 | 991.15 | 1001.61 | 2117.0 |
| 2011-12-09 | HE | Futures | 107.654 | 108.147 | 106.452 | 106.544 | 16395.0 |
| 2011-12-09 | HG | Futures | 4.6026 | 4.7418 | 4.5842 | 4.6923 | 38109.0 |
| 2011-12-09 | HO | Futures | 2.3769 | 2.4032 | 2.3619 | 2.3735 | 19177.0 |
| 2011-12-09 | HRC | Futures | 2745.9 | 2745.9 | 2745.9 | 2745.9 | 0.0 |
| 2011-12-09 | J1 | Futures | 0.016184 | 0.0162167 | 0.0161539 | 0.0162092 | 65954.0 |
> showing 50 of 98 rows — these rows as CSV