PREVIEW / futures_daily / 2011-11-29
file: by_date/futures_daily/2011/2011-11-29.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-11-29 | ES | Futures | 1188.66 | 1203.89 | 1184.17 | 1194.4 | 2423915.0 |
| 2011-11-29 | NQ | Futures | 2535.17 | 2562.57 | 2517.2 | 2525.47 | 272608.0 |
| 2011-11-29 | YM | Futures | 11044.7 | 11158.1 | 11003.4 | 11110.0 | 125534.0 |
| 2011-11-29 | CL | Futures | 183.25 | 187.75 | 182.28 | 187.08 | 320858.0 |
| 2011-11-29 | GC | Futures | 2315.9 | 2327.8 | 2305.0 | 2320.8 | 158257.0 |
| 2011-11-29 | ZN | Futures | 112.059087 | 112.139531 | 111.589828 | 111.951828 | 1398799.0 |
| 2011-11-29 | A6 | Futures | 0.86856 | 0.8843 | 0.8654 | 0.87956 | 144209.0 |
| 2011-11-29 | AD | Futures | 0.96623 | 0.97474 | 0.96493 | 0.97074 | 77817.0 |
| 2011-11-29 | B | Futures | 95.82 | 98.03 | 95.72 | 97.91 | 121165.0 |
| 2011-11-29 | B6 | Futures | 1.618 | 1.634 | 1.6143 | 1.6284 | 90570.0 |
| 2011-11-29 | BFX | Futures | 2385.6 | 2398.9 | 2367.4 | 2388.1 | 69.0 |
| 2011-11-29 | BR | Futures | 0.24813 | 0.249 | 0.24813 | 0.249 | 392.0 |
| 2011-11-29 | BZ | Futures | 102.92 | 103.92 | 102.83 | 103.91 | 759.0 |
| 2011-11-29 | C | Futures | 1571.0 | 1577.0 | 1534.0 | 1545.0 | 3716.0 |
| 2011-11-29 | CB | Futures | 89.884 | 89.884 | 89.346 | 89.75 | 18.0 |
| 2011-11-29 | CC | Futures | 1827.0 | 1834.0 | 1773.0 | 1799.0 | 11171.0 |
| 2011-11-29 | CSC | Futures | 3.978 | 3.978 | 3.976 | 3.976 | 16.0 |
| 2011-11-29 | CT | Futures | 117.64 | 119.7 | 113.98 | 119.46 | 13385.0 |
| 2011-11-29 | DC | Futures | 28.28 | 28.44 | 28.26 | 28.31 | 43.0 |
| 2011-11-29 | DX | Futures | 78.007 | 78.076 | 77.256 | 77.704 | 20979.0 |
| 2011-11-29 | E1 | Futures | 1.42197 | 1.43627 | 1.41987 | 1.42643 | 19089.0 |
| 2011-11-29 | E6 | Futures | 1.59107 | 1.60684 | 1.58796 | 1.59322 | 306908.0 |
| 2011-11-29 | E7 | Futures | 1.5778 | 1.5929 | 1.5743 | 1.5796 | 6186.0 |
| 2011-11-29 | ED | Futures | 94.8839 | 94.9077 | 94.8791 | 94.8934 | 203125.0 |
| 2011-11-29 | ER | Futures | 97.223 | 97.287 | 97.213 | 97.258 | 149276.0 |
| 2011-11-29 | EW | Futures | 843.6 | 854.9 | 839.8 | 846.5 | 25812.0 |
| 2011-11-29 | FBTP | Futures | 55.51 | 55.61 | 54.91 | 55.51 | 18748.0 |
| 2011-11-29 | FBTS | Futures | 76.654 | 77.015 | 76.421 | 76.871 | 1680.0 |
| 2011-11-29 | FCE | Futures | 2150.6 | 2176.7 | 2121.7 | 2160.6 | 88976.0 |
| 2011-11-29 | FDAX | Futures | 6251.0 | 6329.2 | 6180.5 | 6293.4 | 179644.0 |
| 2011-11-29 | FESX | Futures | 1479.9 | 1494.6 | 1456.7 | 1484.6 | 1248282.0 |
| 2011-11-29 | FEU3 | Futures | 97.776 | 97.821 | 97.776 | 97.816 | 206.0 |
| 2011-11-29 | FGBL | Futures | 108.37 | 108.72 | 107.6 | 107.92 | 823334.0 |
| 2011-11-29 | FGBM | Futures | 110.57 | 110.73 | 110.2 | 110.42 | 481629.0 |
| 2011-11-29 | FGBS | Futures | 109.297 | 109.407 | 109.273 | 109.332 | 406784.0 |
| 2011-11-29 | FGBX | Futures | 108.04 | 108.92 | 106.76 | 107.34 | 6706.0 |
| 2011-11-29 | FTDX | Futures | 618.2 | 629.3 | 617.3 | 626.5 | 328.0 |
| 2011-11-29 | FTI | Futures | 240.05 | 241.86 | 237.07 | 241.65 | 37984.0 |
| 2011-11-29 | FTUK | Futures | 3798.0 | 3835.0 | 3781.5 | 3823.5 | 106176.0 |
| 2011-11-29 | FVSA | Futures | 16516.15 | 16601.83 | 16002.02 | 16194.82 | 1803.0 |
| 2011-11-29 | FXXP | Futures | 160.0 | 161.6 | 159.0 | 161.3 | 5722.0 |
| 2011-11-29 | G | Futures | 92.71 | 92.97 | 92.45 | 92.68 | 158019.0 |
| 2011-11-29 | GF | Futures | 312.395 | 313.149 | 311.372 | 311.964 | 2059.0 |
| 2011-11-29 | GSCI | Futures | 1002.93 | 1016.34 | 1002.7 | 1016.34 | 113.0 |
| 2011-11-29 | HE | Futures | 111.845 | 112.8 | 111.352 | 112.431 | 16013.0 |
| 2011-11-29 | HG | Futures | 4.4384 | 4.5037 | 4.4127 | 4.4721 | 37131.0 |
| 2011-11-29 | HO | Futures | 2.3998 | 2.4597 | 2.3994 | 2.4507 | 13014.0 |
| 2011-11-29 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-29 | J1 | Futures | 0.0161112 | 0.0161916 | 0.0160546 | 0.01613 | 81073.0 |
| 2011-11-29 | J7 | Futures | 0.015997 | 0.016091 | 0.01596 | 0.016032 | 299.0 |
> showing 50 of 98 rows — these rows as CSV