PREVIEW / futures_daily / 2011-05-05
file: by_date/futures_daily/2011/2011-05-05.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-05-05 | ES | Futures | 1329.83 | 1335.28 | 1312.01 | 1321.66 | 2915006.0 |
| 2011-05-05 | NQ | Futures | 2716.24 | 2733.04 | 2691.76 | 2709.41 | 393338.0 |
| 2011-05-05 | YM | Futures | 11913.9 | 11959.0 | 11721.2 | 11818.0 | 159663.0 |
| 2011-05-05 | CL | Futures | 209.63 | 210.78 | 189.34 | 192.32 | 670082.0 |
| 2011-05-05 | GC | Futures | 2053.3 | 2060.2 | 1979.5 | 2005.1 | 334047.0 |
| 2011-05-05 | ZN | Futures | 102.514596 | 103.00182 | 102.448754 | 102.870137 | 1288067.0 |
| 2011-05-05 | A6 | Futures | 0.91668 | 0.91951 | 0.89936 | 0.90313 | 164778.0 |
| 2011-05-05 | AD | Futures | 1.03725 | 1.03974 | 1.0241 | 1.0261 | 138987.0 |
| 2011-05-05 | B | Futures | 102.18 | 103.25 | 92.33 | 93.84 | 163501.0 |
| 2011-05-05 | B6 | Futures | 1.7127 | 1.7179 | 1.6985 | 1.7006 | 151468.0 |
| 2011-05-05 | BFX | Futures | 3184.4 | 3196.2 | 3171.0 | 3174.9 | 45.0 |
| 2011-05-05 | BR | Futures | 0.27102 | 0.27122 | 0.26957 | 0.26957 | 373.0 |
| 2011-05-05 | BZ | Futures | 105.03 | 105.03 | 98.88 | 98.88 | 1932.0 |
| 2011-05-05 | C | Futures | 2113.0 | 2116.0 | 2054.0 | 2065.0 | 3792.0 |
| 2011-05-05 | CC | Futures | 2528.0 | 2529.0 | 2428.0 | 2432.0 | 17453.0 |
| 2011-05-05 | CSC | Futures | 4.399 | 4.399 | 4.374 | 4.374 | 4.0 |
| 2011-05-05 | CT | Futures | 149.95 | 149.95 | 143.03 | 145.36 | 13276.0 |
| 2011-05-05 | DC | Futures | 29.78 | 29.78 | 29.34 | 29.52 | 288.0 |
| 2011-05-05 | DX | Futures | 72.914 | 74.049 | 72.621 | 74.004 | 60824.0 |
| 2011-05-05 | E1 | Futures | 1.52073 | 1.53068 | 1.50279 | 1.50476 | 58323.0 |
| 2011-05-05 | E6 | Futures | 1.75459 | 1.763 | 1.71704 | 1.71846 | 509966.0 |
| 2011-05-05 | E7 | Futures | 1.7414 | 1.75 | 1.7041 | 1.7057 | 10184.0 |
| 2011-05-05 | ED | Futures | 94.9549 | 94.9597 | 94.9454 | 94.9549 | 160918.0 |
| 2011-05-05 | ER | Futures | 97.198 | 97.301 | 97.163 | 97.291 | 529628.0 |
| 2011-05-05 | EW | Futures | 982.5 | 988.6 | 973.6 | 980.9 | 28874.0 |
| 2011-05-05 | FBTP | Futures | 64.63 | 64.88 | 64.48 | 64.86 | 6134.0 |
| 2011-05-05 | FCE | Futures | 2730.4 | 2733.8 | 2684.4 | 2701.8 | 155226.0 |
| 2011-05-05 | FDAX | Futures | 7932.4 | 7948.4 | 7804.8 | 7887.5 | 170820.0 |
| 2011-05-05 | FESX | Futures | 1863.8 | 1865.8 | 1831.8 | 1844.6 | 1520911.0 |
| 2011-05-05 | FEU3 | Futures | 97.746 | 97.84 | 97.736 | 97.835 | 1028.0 |
| 2011-05-05 | FGBL | Futures | 97.86 | 98.73 | 97.68 | 98.48 | 1304304.0 |
| 2011-05-05 | FGBM | Futures | 102.66 | 103.4 | 102.58 | 103.24 | 814418.0 |
| 2011-05-05 | FGBS | Futures | 106.067 | 106.444 | 106.038 | 106.38 | 1301020.0 |
| 2011-05-05 | FGBX | Futures | 93.96 | 95.07 | 93.33 | 94.47 | 4158.0 |
| 2011-05-05 | FTDX | Futures | 806.9 | 826.1 | 806.9 | 816.3 | 173.0 |
| 2011-05-05 | FTI | Futures | 292.26 | 293.91 | 289.22 | 291.15 | 38661.0 |
| 2011-05-05 | FTUK | Futures | 4184.7 | 4194.5 | 4091.7 | 4122.8 | 112568.0 |
| 2011-05-05 | FXXP | Futures | 185.0 | 185.0 | 183.8 | 184.3 | 1311.0 |
| 2011-05-05 | G | Futures | 83.3 | 83.53 | 83.14 | 83.37 | 130239.0 |
| 2011-05-05 | GF | Futures | 310.877 | 310.877 | 307.749 | 309.554 | 1182.0 |
| 2011-05-05 | GSCI | Futures | 1140.64 | 1140.64 | 1054.96 | 1064.57 | 663.0 |
| 2011-05-05 | HE | Futures | 98.032 | 98.773 | 96.734 | 97.873 | 25596.0 |
| 2011-05-05 | HG | Futures | 5.4816 | 5.5029 | 5.2671 | 5.3116 | 50795.0 |
| 2011-05-05 | HO | Futures | 2.6092 | 2.634 | 2.37 | 2.3988 | 97060.0 |
| 2011-05-05 | HRC | Futures | 3077.0 | 3077.0 | 3077.0 | 3077.0 | 0.0 |
| 2011-05-05 | J1 | Futures | 0.0155845 | 0.0157918 | 0.0155719 | 0.0156636 | 161688.0 |
| 2011-05-05 | J7 | Futures | 0.015482 | 0.015693 | 0.015482 | 0.015568 | 1222.0 |
| 2011-05-05 | JB | Futures | 122.41 | 122.54 | 122.33 | 122.35 | 11.0 |
| 2011-05-05 | KC | Futures | 706.21 | 707.88 | 681.27 | 691.22 | 17854.0 |
| 2011-05-05 | KE | Futures | 3464.85 | 3492.49 | 3376.97 | 3384.87 | 16286.0 |
> showing 50 of 95 rows — these rows as CSV