PREVIEW / futures_daily / 2012-06-05
file: by_date/futures_daily/2012/2012-06-05.parquet size: 9 KB rows: 95
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-06-05 | ES | Futures | 1283.07 | 1296.68 | 1277.28 | 1294.92 | 2035780.0 |
| 2012-06-05 | NQ | Futures | 2831.93 | 2855.13 | 2817.9 | 2851.41 | 209961.0 |
| 2012-06-05 | YM | Futures | 11732.1 | 11800.2 | 11702.9 | 11792.4 | 135764.0 |
| 2012-06-05 | CL | Futures | 154.2 | 155.63 | 152.68 | 154.48 | 246358.0 |
| 2012-06-05 | GC | Futures | 2165.5 | 2172.0 | 2155.6 | 2161.5 | 96218.0 |
| 2012-06-05 | ZN | Futures | 117.062917 | 117.117069 | 116.64324 | 116.792158 | 41120.0 |
| 2012-06-05 | A6 | Futures | 0.87346 | 0.88093 | 0.87256 | 0.87544 | 139987.0 |
| 2012-06-05 | AD | Futures | 0.96758 | 0.9707 | 0.96416 | 0.96838 | 108702.0 |
| 2012-06-05 | B | Futures | 89.57 | 90.01 | 88.29 | 89.31 | 64862.0 |
| 2012-06-05 | B6 | Futures | 1.6144 | 1.6171 | 1.608 | 1.613 | 73361.0 |
| 2012-06-05 | BFX | Futures | 2504.8 | 2507.3 | 2504.8 | 2507.3 | 2.0 |
| 2012-06-05 | BR | Futures | 0.22937 | 0.23281 | 0.22937 | 0.23281 | 657.0 |
| 2012-06-05 | BZ | Futures | 95.57 | 95.57 | 94.25 | 94.95 | 1875.0 |
| 2012-06-05 | CB | Futures | 80.734 | 81.542 | 80.734 | 81.407 | 33.0 |
| 2012-06-05 | CC | Futures | 1579.0 | 1635.0 | 1565.0 | 1632.0 | 16469.0 |
| 2012-06-05 | CSC | Futures | 3.628 | 3.647 | 3.615 | 3.636 | 13.0 |
| 2012-06-05 | CT | Futures | 83.75 | 85.45 | 81.71 | 81.83 | 14440.0 |
| 2012-06-05 | DC | Futures | 25.42 | 26.02 | 25.42 | 25.82 | 108.0 |
| 2012-06-05 | DX | Futures | 79.928 | 80.452 | 79.836 | 80.333 | 28854.0 |
| 2012-06-05 | E1 | Futures | 1.36215 | 1.36726 | 1.35325 | 1.35691 | 39352.0 |
| 2012-06-05 | E6 | Futures | 1.49159 | 1.49732 | 1.48145 | 1.48574 | 259090.0 |
| 2012-06-05 | E7 | Futures | 1.4774 | 1.4828 | 1.4674 | 1.4715 | 2964.0 |
| 2012-06-05 | ED | Futures | 95.0645 | 95.0693 | 95.0645 | 95.0669 | 54201.0 |
| 2012-06-05 | ER | Futures | 97.562 | 97.567 | 97.553 | 97.562 | 61286.0 |
| 2012-06-05 | EW | Futures | 897.2 | 913.8 | 892.7 | 913.5 | 25591.0 |
| 2012-06-05 | FBTP | Futures | 66.9 | 66.9 | 66.06 | 66.46 | 10052.0 |
| 2012-06-05 | FBTS | Futures | 84.013 | 84.137 | 83.963 | 84.087 | 1443.0 |
| 2012-06-05 | FCE | Futures | 2182.4 | 2203.7 | 2170.6 | 2190.5 | 114016.0 |
| 2012-06-05 | FDAX | Futures | 6645.4 | 6662.5 | 6536.5 | 6595.6 | 163663.0 |
| 2012-06-05 | FESX | Futures | 1441.8 | 1446.0 | 1425.3 | 1437.0 | 870210.0 |
| 2012-06-05 | FEU3 | Futures | 98.137 | 98.137 | 98.127 | 98.137 | 544.0 |
| 2012-06-05 | FGBL | Futures | 119.53 | 120.12 | 119.49 | 119.65 | 611860.0 |
| 2012-06-05 | FGBM | Futures | 116.31 | 116.53 | 116.19 | 116.25 | 411528.0 |
| 2012-06-05 | FGBS | Futures | 110.387 | 110.442 | 110.358 | 110.407 | 420406.0 |
| 2012-06-05 | FGBX | Futures | 134.32 | 135.77 | 134.32 | 134.7 | 19643.0 |
| 2012-06-05 | FOAT | Futures | 100.61 | 100.86 | 100.49 | 100.57 | 12005.0 |
| 2012-06-05 | FTDX | Futures | 669.4 | 672.2 | 661.9 | 668.5 | 314.0 |
| 2012-06-05 | FTI | Futures | 246.64 | 248.2 | 245.65 | 247.03 | 20891.0 |
| 2012-06-05 | FVSA | Futures | 11383.83 | 11446.38 | 10883.44 | 11008.54 | 1034.0 |
| 2012-06-05 | FXXP | Futures | 170.5 | 170.8 | 169.4 | 169.9 | 1388.0 |
| 2012-06-05 | GF | Futures | 313.752 | 314.492 | 312.519 | 314.147 | 3195.0 |
| 2012-06-05 | GSCI | Futures | 929.34 | 931.01 | 925.13 | 926.24 | 534.0 |
| 2012-06-05 | HE | Futures | 95.688 | 96.767 | 95.267 | 96.398 | 17586.0 |
| 2012-06-05 | HG | Futures | 4.359 | 4.3891 | 4.2929 | 4.3073 | 47289.0 |
| 2012-06-05 | HO | Futures | 2.1644 | 2.178 | 2.153 | 2.167 | 11320.0 |
| 2012-06-05 | HRC | Futures | 2510.2 | 2510.2 | 2510.2 | 2510.2 | 0.0 |
| 2012-06-05 | J1 | Futures | 0.0160071 | 0.016056 | 0.015878 | 0.0159294 | 85971.0 |
| 2012-06-05 | J7 | Futures | 0.015927 | 0.015979 | 0.015803 | 0.015854 | 395.0 |
| 2012-06-05 | JB | Futures | 126.09 | 126.1 | 125.79 | 125.89 | 10676.0 |
| 2012-06-05 | KC | Futures | 356.18 | 359.22 | 351.45 | 352.12 | 11780.0 |
> showing 50 of 95 rows — these rows as CSV