PREVIEW / futures_daily / 2011-12-01
file: by_date/futures_daily/2011/2011-12-01.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-01 | ES | Futures | 1241.57 | 1248.81 | 1233.58 | 1241.32 | 2110759.0 |
| 2011-12-01 | NQ | Futures | 2617.64 | 2643.04 | 2607.09 | 2635.91 | 226157.0 |
| 2011-12-01 | YM | Futures | 11544.2 | 11594.2 | 11490.4 | 11530.8 | 101458.0 |
| 2011-12-01 | CL | Futures | 188.43 | 189.66 | 185.35 | 187.84 | 275858.0 |
| 2011-12-01 | GC | Futures | 2366.1 | 2373.6 | 2345.5 | 2349.0 | 113555.0 |
| 2011-12-01 | ZN | Futures | 111.656865 | 111.857976 | 111.308272 | 111.536198 | 149141.0 |
| 2011-12-01 | A6 | Futures | 0.90154 | 0.90172 | 0.89108 | 0.89882 | 129811.0 |
| 2011-12-01 | AD | Futures | 0.98164 | 0.98665 | 0.97834 | 0.98575 | 93408.0 |
| 2011-12-01 | B | Futures | 97.95 | 98.59 | 96.15 | 96.88 | 100480.0 |
| 2011-12-01 | B6 | Futures | 1.6383 | 1.6441 | 1.6317 | 1.6368 | 106331.0 |
| 2011-12-01 | BFX | Futures | 2471.2 | 2472.0 | 2445.3 | 2445.9 | 33.0 |
| 2011-12-01 | BR | Futures | 0.25581 | 0.25581 | 0.25434 | 0.25434 | 90.0 |
| 2011-12-01 | BZ | Futures | 103.09 | 104.05 | 102.15 | 102.82 | 587.0 |
| 2011-12-01 | C | Futures | 1527.0 | 1535.0 | 1512.0 | 1513.0 | 5543.0 |
| 2011-12-01 | CB | Futures | 89.212 | 89.212 | 88.539 | 88.539 | 13.0 |
| 2011-12-01 | CC | Futures | 1787.0 | 1802.0 | 1764.0 | 1773.0 | 9874.0 |
| 2011-12-01 | CSC | Futures | 3.976 | 3.978 | 3.976 | 3.978 | 4.0 |
| 2011-12-01 | CT | Futures | 117.23 | 119.48 | 116.98 | 117.59 | 8679.0 |
| 2011-12-01 | DC | Futures | 28.49 | 28.65 | 28.41 | 28.58 | 151.0 |
| 2011-12-01 | DX | Futures | 77.05 | 77.202 | 76.716 | 76.999 | 21203.0 |
| 2011-12-01 | E1 | Futures | 1.4364 | 1.4469 | 1.42722 | 1.43181 | 27584.0 |
| 2011-12-01 | E6 | Futures | 1.60648 | 1.61617 | 1.60362 | 1.60828 | 280158.0 |
| 2011-12-01 | E7 | Futures | 1.5931 | 1.6022 | 1.5901 | 1.5945 | 4134.0 |
| 2011-12-01 | ED | Futures | 94.9602 | 94.9769 | 94.9555 | 94.9674 | 284789.0 |
| 2011-12-01 | ER | Futures | 97.366 | 97.376 | 97.322 | 97.366 | 187300.0 |
| 2011-12-01 | EW | Futures | 885.1 | 892.4 | 879.9 | 882.2 | 25309.0 |
| 2011-12-01 | FBTP | Futures | 56.3 | 58.03 | 56.3 | 57.83 | 14183.0 |
| 2011-12-01 | FBTS | Futures | 77.047 | 78.388 | 76.959 | 78.316 | 1564.0 |
| 2011-12-01 | FCE | Futures | 2264.6 | 2266.0 | 2227.1 | 2234.6 | 110270.0 |
| 2011-12-01 | FDAX | Futures | 6643.6 | 6652.3 | 6533.9 | 6558.3 | 165924.0 |
| 2011-12-01 | FESX | Futures | 1557.1 | 1559.1 | 1531.8 | 1539.1 | 1285188.0 |
| 2011-12-01 | FEU3 | Futures | 97.895 | 97.925 | 97.895 | 97.925 | 151.0 |
| 2011-12-01 | FGBL | Futures | 108.15 | 109.4 | 108.06 | 109.13 | 874828.0 |
| 2011-12-01 | FGBM | Futures | 111.04 | 111.78 | 111.0 | 111.58 | 501520.0 |
| 2011-12-01 | FGBS | Futures | 109.566 | 109.655 | 109.481 | 109.611 | 564227.0 |
| 2011-12-01 | FGBX | Futures | 107.36 | 110.09 | 107.12 | 109.71 | 6935.0 |
| 2011-12-01 | FTDX | Futures | 651.4 | 651.4 | 638.0 | 642.6 | 143.0 |
| 2011-12-01 | FTI | Futures | 253.04 | 253.96 | 249.38 | 249.72 | 37127.0 |
| 2011-12-01 | FTUK | Futures | 3967.4 | 3989.3 | 3935.1 | 3943.3 | 129856.0 |
| 2011-12-01 | FVSA | Futures | 15423.64 | 15530.75 | 15038.05 | 15080.89 | 3008.0 |
| 2011-12-01 | FXXP | Futures | 166.9 | 168.2 | 166.0 | 166.4 | 3290.0 |
| 2011-12-01 | G | Futures | 91.96 | 92.72 | 91.24 | 92.44 | 170986.0 |
| 2011-12-01 | GF | Futures | 315.464 | 315.949 | 312.987 | 314.71 | 2150.0 |
| 2011-12-01 | GSCI | Futures | 1018.51 | 1024.79 | 1007.97 | 1015.18 | 151.0 |
| 2011-12-01 | HE | Futures | 113.109 | 113.355 | 111.259 | 111.29 | 19457.0 |
| 2011-12-01 | HG | Futures | 4.7075 | 4.7477 | 4.6396 | 4.6613 | 40703.0 |
| 2011-12-01 | HO | Futures | 2.4528 | 2.4613 | 2.4037 | 2.4128 | 24652.0 |
| 2011-12-01 | HRC | Futures | 2867.9 | 2867.9 | 2867.9 | 2867.9 | 84.0 |
| 2011-12-01 | J1 | Futures | 0.0161979 | 0.0162205 | 0.0161476 | 0.0161514 | 75803.0 |
| 2011-12-01 | J7 | Futures | 0.0161 | 0.016116 | 0.016052 | 0.016053 | 198.0 |
> showing 50 of 98 rows — these rows as CSV