PREVIEW / futures_daily / 2012-10-12
file: by_date/futures_daily/2012/2012-10-12.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 |
|---|---|---|---|---|---|---|---|
| 2012-10-12 | ES | Futures | 1453.65 | 1460.01 | 1445.25 | 1446.78 | 1624836.0 |
| 2012-10-12 | NQ | Futures | 3122.47 | 3139.16 | 3114.99 | 3118.16 | 208152.0 |
| 2012-10-12 | YM | Futures | 12950.2 | 13020.5 | 12916.1 | 12933.6 | 104932.0 |
| 2012-10-12 | CL | Futures | 166.78 | 167.2 | 164.53 | 165.79 | 198462.0 |
| 2012-10-12 | GC | Futures | 2362.8 | 2369.9 | 2341.2 | 2349.4 | 130391.0 |
| 2012-10-12 | ZN | Futures | 117.150906 | 117.370649 | 116.986098 | 117.178374 | 722570.0 |
| 2012-10-12 | A6 | Futures | 0.92781 | 0.93017 | 0.92353 | 0.92472 | 102313.0 |
| 2012-10-12 | AD | Futures | 1.02406 | 1.02617 | 1.02175 | 1.02306 | 62645.0 |
| 2012-10-12 | B | Futures | 105.33 | 105.33 | 103.49 | 104.11 | 182317.0 |
| 2012-10-12 | B6 | Futures | 1.6754 | 1.6808 | 1.6725 | 1.6784 | 90136.0 |
| 2012-10-12 | BR | Futures | 0.23668 | 0.23668 | 0.23668 | 0.23668 | 2.0 |
| 2012-10-12 | BZ | Futures | 108.62 | 108.65 | 107.42 | 108.04 | 1853.0 |
| 2012-10-12 | C | Futures | 1538.0 | 1549.0 | 1532.0 | 1544.0 | 3816.0 |
| 2012-10-12 | CB | Futures | 95.271 | 95.499 | 94.736 | 95.137 | 20.0 |
| 2012-10-12 | CC | Futures | 1765.0 | 1794.0 | 1763.0 | 1784.0 | 9038.0 |
| 2012-10-12 | CSC | Futures | 4.246 | 4.25 | 4.246 | 4.25 | 16.0 |
| 2012-10-12 | CT | Futures | 91.72 | 92.16 | 91.25 | 92.08 | 11886.0 |
| 2012-10-12 | DC | Futures | 31.58 | 31.84 | 31.58 | 31.75 | 172.0 |
| 2012-10-12 | DX | Futures | 77.344 | 77.392 | 77.077 | 77.237 | 15016.0 |
| 2012-10-12 | E1 | Futures | 1.37827 | 1.38445 | 1.37698 | 1.38097 | 23298.0 |
| 2012-10-12 | E6 | Futures | 1.52367 | 1.53086 | 1.52261 | 1.52673 | 199900.0 |
| 2012-10-12 | E7 | Futures | 1.5146 | 1.5216 | 1.5135 | 1.5176 | 3108.0 |
| 2012-10-12 | ED | Futures | 95.2301 | 95.2444 | 95.2301 | 95.2396 | 113483.0 |
| 2012-10-12 | ER | Futures | 97.866 | 97.871 | 97.862 | 97.866 | 57399.0 |
| 2012-10-12 | EW | Futures | 999.1 | 1003.7 | 990.1 | 991.6 | 20193.0 |
| 2012-10-12 | FBTP | Futures | 71.86 | 72.21 | 71.8 | 72.06 | 18178.0 |
| 2012-10-12 | FBTS | Futures | 89.533 | 89.692 | 89.474 | 89.625 | 2582.0 |
| 2012-10-12 | FCE | Futures | 2553.5 | 2567.0 | 2542.6 | 2546.0 | 18729.0 |
| 2012-10-12 | FDAX | Futures | 7965.2 | 7991.5 | 7923.6 | 7937.8 | 115993.0 |
| 2012-10-12 | FESX | Futures | 1683.8 | 1694.0 | 1672.9 | 1679.0 | 1033857.0 |
| 2012-10-12 | FEU3 | Futures | 98.487 | 98.487 | 98.487 | 98.487 | 5.0 |
| 2012-10-12 | FGBL | Futures | 118.18 | 118.6 | 118.02 | 118.43 | 603933.0 |
| 2012-10-12 | FGBM | Futures | 116.26 | 116.4 | 116.16 | 116.35 | 349086.0 |
| 2012-10-12 | FGBS | Futures | 110.348 | 110.353 | 110.318 | 110.343 | 181139.0 |
| 2012-10-12 | FGBX | Futures | 125.07 | 126.17 | 124.85 | 125.74 | 5926.0 |
| 2012-10-12 | FOAT | Futures | 103.89 | 104.28 | 103.82 | 104.12 | 13105.0 |
| 2012-10-12 | FTDX | Futures | 762.2 | 768.8 | 758.5 | 767.4 | 148.0 |
| 2012-10-12 | FTI | Futures | 280.59 | 281.62 | 280.33 | 280.42 | 67.0 |
| 2012-10-12 | FTUK | Futures | 4238.4 | 4246.1 | 4209.8 | 4221.6 | 76683.0 |
| 2012-10-12 | FVSA | Futures | 5364.64 | 5409.82 | 5251.7 | 5387.23 | 4189.0 |
| 2012-10-12 | FXXP | Futures | 194.3 | 194.9 | 193.6 | 194.2 | 968.0 |
| 2012-10-12 | G | Futures | 99.1 | 99.52 | 98.98 | 99.41 | 126010.0 |
| 2012-10-12 | GF | Futures | 276.515 | 278.819 | 275.987 | 276.947 | 2971.0 |
| 2012-10-12 | GSCI | Futures | 1082.37 | 1083.25 | 1072.1 | 1075.33 | 557.0 |
| 2012-10-12 | HE | Futures | 96.58 | 97.543 | 96.207 | 97.419 | 14421.0 |
| 2012-10-12 | HG | Futures | 4.8127 | 4.8274 | 4.7458 | 4.7587 | 45025.0 |
| 2012-10-12 | HH | Futures | 46.045 | 46.045 | 46.045 | 46.045 | 1459.0 |
| 2012-10-12 | HO | Futures | 2.6243 | 2.6243 | 2.5824 | 2.596 | 42038.0 |
| 2012-10-12 | HRC | Futures | 2430.8 | 2430.8 | 2430.8 | 2430.8 | 0.0 |
| 2012-10-12 | J1 | Futures | 0.0159807 | 0.0160008 | 0.0159507 | 0.0159807 | 55196.0 |
> showing 50 of 98 rows — these rows as CSV