PREVIEW / futures_daily / 2014-03-10
file: by_date/futures_daily/2014/2014-03-10.parquet size: 9 KB rows: 100
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-03-10 | ES | Futures | 1933.37 | 1936.72 | 1923.32 | 1935.17 | 1167755.0 |
| 2014-03-10 | NQ | Futures | 4255.27 | 4267.34 | 4235.15 | 4262.17 | 192161.0 |
| 2014-03-10 | YM | Futures | 16422.0 | 16451.2 | 16321.6 | 16409.0 | 2368.0 |
| 2014-03-10 | CL | Futures | 182.84 | 182.97 | 179.46 | 179.94 | 225290.0 |
| 2014-03-10 | GC | Futures | 1767.4 | 1772.8 | 1749.9 | 1768.4 | 126040.0 |
| 2014-03-10 | ZN | Futures | 114.591534 | 114.736403 | 114.432178 | 114.649481 | 888360.0 |
| 2014-03-10 | A6 | Futures | 0.86359 | 0.86493 | 0.86013 | 0.86042 | 17737.0 |
| 2014-03-10 | AD | Futures | 0.91218 | 0.91238 | 0.90883 | 0.91086 | 8919.0 |
| 2014-03-10 | B | Futures | 111.42 | 111.44 | 110.3 | 110.6 | 144896.0 |
| 2014-03-10 | B6 | Futures | 1.757 | 1.7582 | 1.7457 | 1.7476 | 24441.0 |
| 2014-03-10 | BR | Futures | 0.22072 | 0.22085 | 0.21893 | 0.21893 | 9.0 |
| 2014-03-10 | BZ | Futures | 113.15 | 113.59 | 112.53 | 112.82 | 9073.0 |
| 2014-03-10 | C | Futures | 1944.0 | 1956.0 | 1942.0 | 1950.0 | 8413.0 |
| 2014-03-10 | CB | Futures | 93.669 | 93.669 | 93.669 | 93.669 | 8.0 |
| 2014-03-10 | CC | Futures | 2213.0 | 2223.0 | 2205.0 | 2215.0 | 7459.0 |
| 2014-03-10 | CNH | Futures | 7.0363 | 7.056 | 7.0363 | 7.056 | 3.0 |
| 2014-03-10 | CSC | Futures | 4.375 | 4.375 | 4.375 | 4.375 | 5.0 |
| 2014-03-10 | CT | Futures | 102.39 | 104.08 | 101.92 | 102.91 | 10704.0 |
| 2014-03-10 | DC | Futures | 34.68 | 34.99 | 34.68 | 34.82 | 67.0 |
| 2014-03-10 | DX | Futures | 75.812 | 75.974 | 75.793 | 75.901 | 9394.0 |
| 2014-03-10 | E1 | Futures | 1.4633 | 1.466 | 1.46074 | 1.46241 | 7299.0 |
| 2014-03-10 | E6 | Futures | 1.63753 | 1.6406 | 1.63623 | 1.63717 | 34743.0 |
| 2014-03-10 | E7 | Futures | 1.6268 | 1.6294 | 1.6256 | 1.6263 | 465.0 |
| 2014-03-10 | EBM | Futures | 294.87 | 294.87 | 291.0 | 291.7 | 14217.0 |
| 2014-03-10 | ED | Futures | 95.3851 | 95.3899 | 95.3851 | 95.3899 | 61452.0 |
| 2014-03-10 | ER | Futures | 97.822 | 97.837 | 97.803 | 97.832 | 109676.0 |
| 2014-03-10 | EW | Futures | 1419.6 | 1423.9 | 1419.2 | 1423.9 | 120.0 |
| 2014-03-10 | FBTP | Futures | 86.3 | 86.69 | 86.24 | 86.62 | 37509.0 |
| 2014-03-10 | FBTS | Futures | 97.003 | 97.091 | 96.976 | 97.073 | 8318.0 |
| 2014-03-10 | FCE | Futures | 3384.7 | 3423.8 | 3366.9 | 3387.0 | 127623.0 |
| 2014-03-10 | FDAX | Futures | 10372.6 | 10407.5 | 10219.5 | 10273.9 | 115088.0 |
| 2014-03-10 | FESX | Futures | 2178.8 | 2198.2 | 2160.1 | 2172.3 | 29700.0 |
| 2014-03-10 | FEU3 | Futures | 98.438 | 98.453 | 98.438 | 98.453 | 200.0 |
| 2014-03-10 | FGBL | Futures | 122.83 | 123.06 | 122.64 | 122.95 | 559944.0 |
| 2014-03-10 | FGBM | Futures | 119.35 | 119.45 | 119.22 | 119.42 | 408749.0 |
| 2014-03-10 | FGBS | Futures | 110.478 | 110.508 | 110.453 | 110.503 | 223573.0 |
| 2014-03-10 | FGBX | Futures | 125.5 | 125.73 | 125.0 | 125.44 | 14611.0 |
| 2014-03-10 | FMWO | Futures | 5510.1 | 5510.1 | 5498.8 | 5508.8 | 17.0 |
| 2014-03-10 | FOAT | Futures | 111.41 | 111.59 | 111.3 | 111.49 | 48224.0 |
| 2014-03-10 | FTDX | Futures | 1197.2 | 1197.2 | 1190.2 | 1190.2 | 14.0 |
| 2014-03-10 | FTI | Futures | 338.44 | 340.27 | 334.55 | 335.7 | 108.0 |
| 2014-03-10 | FTUK | Futures | 5068.8 | 5096.2 | 5029.1 | 5036.0 | 20615.0 |
| 2014-03-10 | FVSA | Futures | 1961.0 | 2020.72 | 1896.3 | 1965.98 | 8259.0 |
| 2014-03-10 | FXXP | Futures | 244.6 | 244.6 | 244.3 | 244.3 | 1.0 |
| 2014-03-10 | G | Futures | 92.8 | 92.86 | 92.46 | 92.67 | 137221.0 |
| 2014-03-10 | GF | Futures | 277.915 | 281.437 | 277.555 | 281.317 | 3048.0 |
| 2014-03-10 | GSCI | Futures | 1072.24 | 1072.24 | 1066.95 | 1068.6 | 1687.0 |
| 2014-03-10 | HE | Futures | 137.499 | 140.095 | 137.408 | 140.095 | 25096.0 |
| 2014-03-10 | HG | Futures | 3.9001 | 3.9001 | 3.7962 | 3.8418 | 79358.0 |
| 2014-03-10 | HH | Futures | 61.271 | 61.532 | 59.42 | 60.633 | 342.0 |
> showing 50 of 100 rows — these rows as CSV