PREVIEW / futures_daily / 2014-07-16
file: by_date/futures_daily/2014/2014-07-16.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-16 | ES | Futures | 2044.35 | 2054.74 | 2043.31 | 2051.36 | 1320381.0 |
| 2014-07-16 | NQ | Futures | 4518.77 | 4547.04 | 4514.74 | 4525.7 | 215286.0 |
| 2014-07-16 | YM | Futures | 17155.8 | 17222.4 | 17143.7 | 17210.3 | 112017.0 |
| 2014-07-16 | CL | Futures | 183.59 | 185.79 | 183.36 | 185.2 | 161599.0 |
| 2014-07-16 | GC | Futures | 1706.5 | 1718.4 | 1704.3 | 1712.6 | 119719.0 |
| 2014-07-16 | ZN | Futures | 116.637859 | 116.75457 | 116.477382 | 116.608681 | 722272.0 |
| 2014-07-16 | A6 | Futures | 0.90166 | 0.90214 | 0.89779 | 0.90108 | 60129.0 |
| 2014-07-16 | AD | Futures | 0.94272 | 0.94577 | 0.93947 | 0.94384 | 69383.0 |
| 2014-07-16 | ALI | Futures | 2862.48 | 2862.48 | 2862.48 | 2862.48 | 0.0 |
| 2014-07-16 | B | Futures | 112.34 | 113.55 | 112.28 | 112.72 | 304944.0 |
| 2014-07-16 | B6 | Futures | 1.8012 | 1.8022 | 1.7981 | 1.8004 | 78405.0 |
| 2014-07-16 | BFX | Futures | 3795.2 | 3829.6 | 3794.2 | 3825.0 | 635.0 |
| 2014-07-16 | BR | Futures | 0.23445 | 0.23508 | 0.23371 | 0.234 | 124.0 |
| 2014-07-16 | BZ | Futures | 113.17 | 114.27 | 113.15 | 113.44 | 12655.0 |
| 2014-07-16 | C | Futures | 2028.0 | 2037.0 | 2000.0 | 2011.0 | 11925.0 |
| 2014-07-16 | CB | Futures | 126.323 | 126.938 | 126.323 | 126.938 | 11.0 |
| 2014-07-16 | CC | Futures | 2278.0 | 2285.0 | 2242.0 | 2250.0 | 18460.0 |
| 2014-07-16 | CNH | Futures | 7.1482 | 7.1482 | 7.1442 | 7.1442 | 2.0 |
| 2014-07-16 | CSC | Futures | 4.332 | 4.37 | 4.328 | 4.343 | 4.0 |
| 2014-07-16 | CT | Futures | 86.1 | 87.17 | 86.1 | 86.27 | 17.0 |
| 2014-07-16 | DC | Futures | 34.91 | 35.6 | 34.85 | 35.25 | 350.0 |
| 2014-07-16 | DX | Futures | 76.337 | 76.56 | 76.337 | 76.531 | 16338.0 |
| 2014-07-16 | E1 | Futures | 1.43147 | 1.43199 | 1.4266 | 1.42712 | 31626.0 |
| 2014-07-16 | E6 | Futures | 1.60129 | 1.60164 | 1.59562 | 1.59598 | 132949.0 |
| 2014-07-16 | E7 | Futures | 1.5906 | 1.5911 | 1.5853 | 1.5856 | 1690.0 |
| 2014-07-16 | ED | Futures | 95.4115 | 95.4162 | 95.4115 | 95.4162 | 48390.0 |
| 2014-07-16 | ER | Futures | 97.901 | 97.906 | 97.896 | 97.901 | 23755.0 |
| 2014-07-16 | EW | Futures | 1465.6 | 1473.3 | 1455.9 | 1463.3 | 22321.0 |
| 2014-07-16 | FBTP | Futures | 91.62 | 91.86 | 91.57 | 91.77 | 41224.0 |
| 2014-07-16 | FBTS | Futures | 98.276 | 98.312 | 98.25 | 98.268 | 8710.0 |
| 2014-07-16 | FCE | Futures | 3435.2 | 3480.1 | 3432.8 | 3475.3 | 112674.0 |
| 2014-07-16 | FDAX | Futures | 10723.4 | 10877.6 | 10721.2 | 10857.8 | 88409.0 |
| 2014-07-16 | FESX | Futures | 2273.5 | 2305.9 | 2272.8 | 2301.6 | 901880.0 |
| 2014-07-16 | FGBL | Futures | 128.37 | 128.57 | 128.35 | 128.49 | 497251.0 |
| 2014-07-16 | FGBM | Futures | 121.68 | 121.72 | 121.64 | 121.7 | 273009.0 |
| 2014-07-16 | FGBS | Futures | 110.783 | 110.788 | 110.773 | 110.778 | 90634.0 |
| 2014-07-16 | FGBX | Futures | 134.57 | 135.04 | 134.45 | 134.85 | 17657.0 |
| 2014-07-16 | FMWO | Futures | 5812.9 | 5812.9 | 5812.9 | 5812.9 | 0.0 |
| 2014-07-16 | FOAT | Futures | 118.14 | 118.38 | 118.14 | 118.33 | 45712.0 |
| 2014-07-16 | FTDX | Futures | 1177.2 | 1188.4 | 1176.7 | 1186.5 | 365.0 |
| 2014-07-16 | FTI | Futures | 349.39 | 353.03 | 349.05 | 352.86 | 39560.0 |
| 2014-07-16 | FTUK | Futures | 5133.1 | 5188.1 | 5132.3 | 5182.3 | 75157.0 |
| 2014-07-16 | FVSA | Futures | 1362.69 | 1366.93 | 1324.48 | 1341.46 | 11081.0 |
| 2014-07-16 | FXXP | Futures | 255.0 | 258.3 | 254.9 | 257.8 | 5853.0 |
| 2014-07-16 | G | Futures | 94.23 | 94.28 | 94.02 | 94.06 | 121938.0 |
| 2014-07-16 | GF | Futures | 324.144 | 324.144 | 319.968 | 321.577 | 3637.0 |
| 2014-07-16 | GSCI | Futures | 1055.79 | 1057.54 | 1053.61 | 1054.03 | 160.0 |
| 2014-07-16 | HE | Futures | 137.499 | 137.683 | 136.529 | 136.975 | 17899.0 |
| 2014-07-16 | HG | Futures | 4.1503 | 4.1618 | 4.1024 | 4.1088 | 41023.0 |
| 2014-07-16 | HH | Futures | 52.072 | 52.325 | 52.034 | 52.085 | 2029.0 |
> showing 50 of 103 rows — these rows as CSV