PREVIEW / futures_daily / 2014-07-08
file: by_date/futures_daily/2014/2014-07-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-07-08 | ES | Futures | 2046.95 | 2047.21 | 2028.51 | 2036.56 | 1776514.0 |
| 2014-07-08 | NQ | Futures | 4505.51 | 4507.53 | 4431.95 | 4457.34 | 331375.0 |
| 2014-07-08 | YM | Futures | 17096.2 | 17104.3 | 16946.9 | 17011.5 | 148160.0 |
| 2014-07-08 | CL | Futures | 188.86 | 190.34 | 188.17 | 188.88 | 249378.0 |
| 2014-07-08 | GC | Futures | 1740.3 | 1746.7 | 1731.7 | 1734.6 | 130081.0 |
| 2014-07-08 | ZN | Futures | 116.156427 | 116.594092 | 116.083483 | 116.477382 | 1023765.0 |
| 2014-07-08 | A6 | Futures | 0.90127 | 0.90562 | 0.90079 | 0.90398 | 59961.0 |
| 2014-07-08 | AD | Futures | 0.94932 | 0.95105 | 0.9481 | 0.94983 | 40225.0 |
| 2014-07-08 | ALI | Futures | 2846.23 | 2846.23 | 2846.23 | 2846.23 | 18.0 |
| 2014-07-08 | B | Futures | 115.79 | 115.83 | 114.48 | 114.71 | 262380.0 |
| 2014-07-08 | B6 | Futures | 1.7999 | 1.8018 | 1.7951 | 1.7997 | 68032.0 |
| 2014-07-08 | BFX | Futures | 3804.4 | 3804.4 | 3786.8 | 3786.8 | 13.0 |
| 2014-07-08 | BR | Futures | 0.23363 | 0.23568 | 0.2335 | 0.23542 | 143.0 |
| 2014-07-08 | BZ | Futures | 116.36 | 116.55 | 115.23 | 115.44 | 17001.0 |
| 2014-07-08 | C | Futures | 2020.0 | 2030.0 | 2004.0 | 2025.0 | 4839.0 |
| 2014-07-08 | CC | Futures | 2271.0 | 2298.0 | 2269.0 | 2289.0 | 11746.0 |
| 2014-07-08 | CNH | Futures | 7.1433 | 7.1433 | 7.14 | 7.14 | 1.0 |
| 2014-07-08 | CSC | Futures | 4.392 | 4.392 | 4.392 | 4.392 | 2.0 |
| 2014-07-08 | CT | Futures | 88.6 | 89.38 | 88.2 | 88.42 | 47.0 |
| 2014-07-08 | DC | Futures | 35.34 | 35.51 | 34.84 | 34.98 | 282.0 |
| 2014-07-08 | DX | Futures | 76.19 | 76.266 | 76.119 | 76.148 | 7886.0 |
| 2014-07-08 | E1 | Futures | 1.4357 | 1.43763 | 1.43378 | 1.43635 | 24609.0 |
| 2014-07-08 | E6 | Futures | 1.60577 | 1.60719 | 1.60377 | 1.60636 | 100355.0 |
| 2014-07-08 | E7 | Futures | 1.5954 | 1.5966 | 1.5933 | 1.5959 | 1122.0 |
| 2014-07-08 | ED | Futures | 95.4115 | 95.4162 | 95.4067 | 95.4115 | 55781.0 |
| 2014-07-08 | ER | Futures | 97.916 | 97.92 | 97.911 | 97.92 | 25563.0 |
| 2014-07-08 | EW | Futures | 1484.2 | 1484.5 | 1464.8 | 1472.8 | 19245.0 |
| 2014-07-08 | FBTP | Futures | 91.82 | 91.82 | 91.53 | 91.65 | 51310.0 |
| 2014-07-08 | FBTS | Futures | 98.356 | 98.365 | 98.276 | 98.312 | 12359.0 |
| 2014-07-08 | FCE | Futures | 3527.7 | 3531.3 | 3464.3 | 3467.1 | 119854.0 |
| 2014-07-08 | FDAX | Futures | 10934.9 | 10940.4 | 10738.9 | 10774.1 | 112635.0 |
| 2014-07-08 | FESX | Futures | 2326.0 | 2328.9 | 2285.0 | 2290.1 | 1079064.0 |
| 2014-07-08 | FGBL | Futures | 127.72 | 128.23 | 127.66 | 128.16 | 535163.0 |
| 2014-07-08 | FGBM | Futures | 121.48 | 121.68 | 121.44 | 121.65 | 340476.0 |
| 2014-07-08 | FGBS | Futures | 110.783 | 110.798 | 110.773 | 110.783 | 162664.0 |
| 2014-07-08 | FGBX | Futures | 132.38 | 133.4 | 132.28 | 133.23 | 15536.0 |
| 2014-07-08 | FMWO | Futures | 5784.0 | 5784.0 | 5771.4 | 5771.4 | 140.0 |
| 2014-07-08 | FOAT | Futures | 117.6 | 118.1 | 117.56 | 118.05 | 54522.0 |
| 2014-07-08 | FTDX | Futures | 1236.1 | 1236.1 | 1220.2 | 1220.7 | 160.0 |
| 2014-07-08 | FTI | Futures | 358.4 | 358.57 | 353.64 | 354.21 | 32730.0 |
| 2014-07-08 | FTUK | Futures | 5215.0 | 5220.8 | 5127.3 | 5147.3 | 104747.0 |
| 2014-07-08 | FVSA | Futures | 1237.79 | 1315.15 | 1237.79 | 1302.25 | 11653.0 |
| 2014-07-08 | FXXP | Futures | 259.5 | 259.6 | 255.2 | 255.8 | 9937.0 |
| 2014-07-08 | G | Futures | 93.32 | 94.08 | 93.28 | 93.95 | 179270.0 |
| 2014-07-08 | GF | Futures | 334.642 | 334.642 | 330.887 | 330.887 | 4952.0 |
| 2014-07-08 | GSCI | Futures | 1078.74 | 1081.49 | 1072.15 | 1072.82 | 1688.0 |
| 2014-07-08 | HE | Futures | 138.628 | 138.811 | 136.004 | 136.266 | 26847.0 |
| 2014-07-08 | HG | Futures | 4.165 | 4.2104 | 4.1522 | 4.1631 | 46417.0 |
| 2014-07-08 | HH | Futures | 52.249 | 53.425 | 52.249 | 53.16 | 613.0 |
| 2014-07-08 | HO | Futures | 2.3316 | 2.3345 | 2.3037 | 2.3063 | 25222.0 |
> showing 50 of 103 rows — these rows as CSV