PREVIEW / futures_daily / 2014-08-08
file: by_date/futures_daily/2014/2014-08-08.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2014-08-08 | ES | Futures | 1979.17 | 2003.06 | 1963.59 | 1998.38 | 1904778.0 |
| 2014-08-08 | NQ | Futures | 4448.39 | 4484.45 | 4414.93 | 4469.16 | 315422.0 |
| 2014-08-08 | YM | Futures | 16468.7 | 16650.3 | 16353.6 | 16627.1 | 190966.0 |
| 2014-08-08 | CL | Futures | 179.75 | 181.24 | 178.85 | 179.77 | 266006.0 |
| 2014-08-08 | GC | Futures | 1724.2 | 1737.0 | 1712.6 | 1719.6 | 147901.0 |
| 2014-08-08 | ZN | Futures | 117.600723 | 118.155099 | 117.51319 | 117.615312 | 1826402.0 |
| 2014-08-08 | A6 | Futures | 0.89344 | 0.89547 | 0.89074 | 0.89431 | 91776.0 |
| 2014-08-08 | AD | Futures | 0.9287 | 0.93012 | 0.92383 | 0.92484 | 63582.0 |
| 2014-08-08 | ALI | Futures | 2945.06 | 2945.06 | 2945.06 | 2945.06 | 0.0 |
| 2014-08-08 | B | Futures | 111.61 | 112.85 | 110.6 | 110.93 | 200917.0 |
| 2014-08-08 | B6 | Futures | 1.7689 | 1.7692 | 1.762 | 1.763 | 101279.0 |
| 2014-08-08 | BR | Futures | 0.22728 | 0.2296 | 0.22685 | 0.22946 | 442.0 |
| 2014-08-08 | BZ | Futures | 112.89 | 113.7 | 111.49 | 111.8 | 12162.0 |
| 2014-08-08 | C | Futures | 2133.0 | 2141.0 | 2123.0 | 2132.0 | 3931.0 |
| 2014-08-08 | CB | Futures | 133.03 | 133.03 | 131.354 | 131.368 | 3.0 |
| 2014-08-08 | CC | Futures | 2372.0 | 2386.0 | 2359.0 | 2373.0 | 18728.0 |
| 2014-08-08 | CNH | Futures | 7.0885 | 7.0889 | 7.072 | 7.072 | 69.0 |
| 2014-08-08 | CSC | Futures | 4.576 | 4.576 | 4.576 | 4.576 | 6.0 |
| 2014-08-08 | CT | Futures | 80.42 | 80.93 | 80.14 | 80.5 | 6.0 |
| 2014-08-08 | DC | Futures | 37.64 | 37.68 | 37.3 | 37.31 | 170.0 |
| 2014-08-08 | DX | Futures | 77.481 | 77.523 | 77.186 | 77.318 | 27747.0 |
| 2014-08-08 | E1 | Futures | 1.41045 | 1.41955 | 1.40917 | 1.41622 | 45206.0 |
| 2014-08-08 | E6 | Futures | 1.57674 | 1.58524 | 1.57462 | 1.58264 | 206708.0 |
| 2014-08-08 | E7 | Futures | 1.5663 | 1.5749 | 1.5645 | 1.5723 | 2228.0 |
| 2014-08-08 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4162 | 53134.0 |
| 2014-08-08 | ER | Futures | 97.901 | 97.901 | 97.891 | 97.891 | 29881.0 |
| 2014-08-08 | EW | Futures | 1414.0 | 1430.4 | 1401.4 | 1427.3 | 14679.0 |
| 2014-08-08 | FBTP | Futures | 91.57 | 91.88 | 90.95 | 91.71 | 98517.0 |
| 2014-08-08 | FBTS | Futures | 98.33 | 98.49 | 98.259 | 98.436 | 19409.0 |
| 2014-08-08 | FCE | Futures | 3275.7 | 3328.6 | 3261.0 | 3298.4 | 127601.0 |
| 2014-08-08 | FDAX | Futures | 9856.7 | 10023.6 | 9804.9 | 9927.7 | 155275.0 |
| 2014-08-08 | FESX | Futures | 2146.3 | 2184.4 | 2137.6 | 2161.4 | 1416601.0 |
| 2014-08-08 | FGBL | Futures | 130.16 | 130.29 | 129.7 | 129.98 | 813981.0 |
| 2014-08-08 | FGBM | Futures | 122.14 | 122.15 | 121.92 | 122.03 | 391417.0 |
| 2014-08-08 | FGBS | Futures | 110.823 | 110.828 | 110.783 | 110.803 | 218650.0 |
| 2014-08-08 | FGBX | Futures | 139.42 | 140.31 | 138.84 | 139.44 | 28779.0 |
| 2014-08-08 | FMWO | Futures | 5553.7 | 5597.7 | 5553.7 | 5596.5 | 146.0 |
| 2014-08-08 | FOAT | Futures | 119.8 | 119.95 | 119.7 | 119.82 | 66468.0 |
| 2014-08-08 | FTDX | Futures | 1067.7 | 1089.2 | 1063.9 | 1081.2 | 346.0 |
| 2014-08-08 | FTI | Futures | 338.65 | 339.78 | 335.44 | 337.39 | 42504.0 |
| 2014-08-08 | FTUK | Futures | 5035.4 | 5056.9 | 4993.5 | 5028.1 | 103799.0 |
| 2014-08-08 | FVSA | Futures | 1651.36 | 1706.54 | 1625.88 | 1698.05 | 34340.0 |
| 2014-08-08 | FXXP | Futures | 243.9 | 246.3 | 242.4 | 244.3 | 18928.0 |
| 2014-08-08 | G | Futures | 95.92 | 96.26 | 95.67 | 95.82 | 210016.0 |
| 2014-08-08 | GF | Futures | 332.956 | 334.795 | 330.006 | 330.006 | 1446.0 |
| 2014-08-08 | GSCI | Futures | 1037.72 | 1037.72 | 1030.44 | 1033.04 | 1507.0 |
| 2014-08-08 | HE | Futures | 120.744 | 122.497 | 117.873 | 120.079 | 21398.0 |
| 2014-08-08 | HG | Futures | 4.0551 | 4.0698 | 4.0397 | 4.0564 | 43007.0 |
| 2014-08-08 | HH | Futures | 49.636 | 50.308 | 49.636 | 50.296 | 908.0 |
| 2014-08-08 | HO | Futures | 2.3176 | 2.329 | 2.2905 | 2.2971 | 61580.0 |
> showing 50 of 103 rows — these rows as CSV