PREVIEW / futures_daily / 2014-10-06
file: by_date/futures_daily/2014/2014-10-06.parquet size: 9 KB rows: 106
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-10-06 | ES | Futures | 2048.43 | 2058.88 | 2037.46 | 2043.21 | 1727529.0 |
| 2014-10-06 | NQ | Futures | 4656.48 | 4682.84 | 4631.56 | 4644.02 | 338251.0 |
| 2014-10-06 | YM | Futures | 17168.8 | 17267.2 | 17088.6 | 17148.5 | 165288.0 |
| 2014-10-06 | CL | Futures | 169.1 | 170.93 | 167.2 | 170.17 | 276614.0 |
| 2014-10-06 | GC | Futures | 1563.5 | 1587.0 | 1552.1 | 1583.6 | 147758.0 |
| 2014-10-06 | ZN | Futures | 117.323972 | 117.690061 | 117.250755 | 117.528982 | 1113674.0 |
| 2014-10-06 | A6 | Futures | 0.83876 | 0.84945 | 0.83672 | 0.84614 | 121056.0 |
| 2014-10-06 | AD | Futures | 0.90117 | 0.91265 | 0.90006 | 0.90971 | 68468.0 |
| 2014-10-06 | ALI | Futures | 2907.22 | 2916.69 | 2907.22 | 2916.69 | 10.0 |
| 2014-10-06 | B | Futures | 96.17 | 97.31 | 95.3 | 96.88 | 190251.0 |
| 2014-10-06 | B6 | Futures | 1.6771 | 1.6912 | 1.6759 | 1.6872 | 88783.0 |
| 2014-10-06 | BFX | Futures | 3825.2 | 3829.8 | 3825.2 | 3829.8 | 4.0 |
| 2014-10-06 | BR | Futures | 0.22246 | 0.223 | 0.21866 | 0.21885 | 1699.0 |
| 2014-10-06 | BZ | Futures | 97.01 | 98.01 | 96.0 | 97.59 | 15527.0 |
| 2014-10-06 | C | Futures | 2124.0 | 2148.0 | 2124.0 | 2137.0 | 7093.0 |
| 2014-10-06 | CB | Futures | 141.051 | 141.051 | 140.666 | 141.051 | 32.0 |
| 2014-10-06 | CC | Futures | 2263.0 | 2286.0 | 2262.0 | 2273.0 | 8555.0 |
| 2014-10-06 | CNH | Futures | 7.0846 | 7.0846 | 7.0822 | 7.0822 | 2.0 |
| 2014-10-06 | CSC | Futures | 5.232 | 5.232 | 5.135 | 5.135 | 17.0 |
| 2014-10-06 | CT | Futures | 79.45 | 82.35 | 78.97 | 81.58 | 20616.0 |
| 2014-10-06 | DC | Futures | 41.86 | 41.89 | 41.2 | 41.22 | 159.0 |
| 2014-10-06 | DX | Futures | 82.397 | 82.44 | 81.386 | 81.679 | 43434.0 |
| 2014-10-06 | E1 | Futures | 1.3229 | 1.33722 | 1.32149 | 1.33185 | 49660.0 |
| 2014-10-06 | E6 | Futures | 1.47374 | 1.49281 | 1.47303 | 1.48704 | 268954.0 |
| 2014-10-06 | E7 | Futures | 1.4644 | 1.4832 | 1.4639 | 1.4777 | 3105.0 |
| 2014-10-06 | ED | Futures | 95.4422 | 95.4422 | 95.4374 | 95.4374 | 60930.0 |
| 2014-10-06 | ER | Futures | 98.014 | 98.014 | 98.004 | 98.014 | 85484.0 |
| 2014-10-06 | EW | Futures | 1416.9 | 1424.1 | 1408.6 | 1412.0 | 22707.0 |
| 2014-10-06 | FBTP | Futures | 95.66 | 95.88 | 95.3 | 95.4 | 48646.0 |
| 2014-10-06 | FBTS | Futures | 98.659 | 98.748 | 98.659 | 98.686 | 4116.0 |
| 2014-10-06 | FCE | Futures | 3426.1 | 3450.8 | 3394.2 | 3412.9 | 97853.0 |
| 2014-10-06 | FDAX | Futures | 10228.2 | 10245.2 | 10019.5 | 10069.9 | 121086.0 |
| 2014-10-06 | FESX | Futures | 2281.8 | 2301.3 | 2250.6 | 2262.2 | 1064042.0 |
| 2014-10-06 | FEU3 | Futures | 98.626 | 98.631 | 98.626 | 98.631 | 25.0 |
| 2014-10-06 | FGBL | Futures | 132.09 | 132.35 | 132.08 | 132.25 | 569577.0 |
| 2014-10-06 | FGBM | Futures | 122.89 | 122.98 | 122.87 | 122.95 | 322001.0 |
| 2014-10-06 | FGBS | Futures | 110.938 | 110.953 | 110.933 | 110.948 | 143810.0 |
| 2014-10-06 | FGBX | Futures | 143.45 | 143.98 | 143.19 | 143.49 | 23431.0 |
| 2014-10-06 | FMWO | Futures | 5590.9 | 5604.7 | 5568.3 | 5580.9 | 840.0 |
| 2014-10-06 | FOAT | Futures | 121.81 | 122.02 | 121.8 | 121.9 | 45223.0 |
| 2014-10-06 | FTDX | Futures | 1175.2 | 1175.2 | 1153.5 | 1158.7 | 812.0 |
| 2014-10-06 | FTI | Futures | 356.38 | 358.06 | 354.74 | 356.16 | 33428.0 |
| 2014-10-06 | FTUK | Futures | 5035.4 | 5072.9 | 5028.9 | 5046.3 | 104922.0 |
| 2014-10-06 | FVSA | Futures | 1489.85 | 1514.21 | 1465.5 | 1510.15 | 12884.0 |
| 2014-10-06 | FXXP | Futures | 255.4 | 255.7 | 252.9 | 253.8 | 8022.0 |
| 2014-10-06 | G | Futures | 97.46 | 97.73 | 97.41 | 97.56 | 132602.0 |
| 2014-10-06 | GF | Futures | 373.769 | 375.247 | 371.63 | 373.38 | 1961.0 |
| 2014-10-06 | GSCI | Futures | 955.25 | 962.91 | 949.27 | 960.47 | 1082.0 |
| 2014-10-06 | HE | Futures | 126.111 | 129.24 | 125.842 | 129.038 | 16955.0 |
| 2014-10-06 | HG | Futures | 3.8071 | 3.8604 | 3.7938 | 3.8503 | 34108.0 |
> showing 50 of 106 rows — these rows as CSV