PREVIEW / futures_daily / 2014-02-06
file: by_date/futures_daily/2014/2014-02-06.parquet size: 9 KB rows: 104
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-02-06 | ES | Futures | 1798.59 | 1824.36 | 1797.81 | 1821.01 | 1739245.0 |
| 2014-02-06 | NQ | Futures | 3966.43 | 4022.76 | 3963.56 | 4008.97 | 267809.0 |
| 2014-02-06 | YM | Futures | 15358.7 | 15552.4 | 15352.7 | 15524.5 | 179057.0 |
| 2014-02-06 | CL | Futures | 171.74 | 174.53 | 171.74 | 172.78 | 234281.0 |
| 2014-02-06 | GC | Futures | 1657.9 | 1670.8 | 1651.0 | 1657.2 | 87894.0 |
| 2014-02-06 | ZN | Futures | 115.235387 | 115.335542 | 114.94923 | 115.020769 | 1093130.0 |
| 2014-02-06 | A6 | Futures | 0.84806 | 0.85377 | 0.84777 | 0.85206 | 72705.0 |
| 2014-02-06 | AD | Futures | 0.91288 | 0.91562 | 0.90954 | 0.9142 | 52633.0 |
| 2014-02-06 | B | Futures | 108.54 | 109.75 | 108.38 | 109.46 | 143447.0 |
| 2014-02-06 | B6 | Futures | 1.7132 | 1.7169 | 1.7089 | 1.7141 | 81785.0 |
| 2014-02-06 | BFX | Futures | 3459.4 | 3499.4 | 3459.4 | 3499.4 | 7.0 |
| 2014-02-06 | BR | Futures | 0.215 | 0.21679 | 0.215 | 0.2158 | 2906.0 |
| 2014-02-06 | BZ | Futures | 110.73 | 111.92 | 110.7 | 111.67 | 7959.0 |
| 2014-02-06 | C | Futures | 1944.0 | 1957.0 | 1942.0 | 1949.0 | 5206.0 |
| 2014-02-06 | CB | Futures | 86.359 | 86.359 | 85.868 | 85.868 | 28.0 |
| 2014-02-06 | CC | Futures | 2149.0 | 2163.0 | 2145.0 | 2156.0 | 18912.0 |
| 2014-02-06 | CSC | Futures | 4.267 | 4.29 | 4.23 | 4.267 | 26.0 |
| 2014-02-06 | CT | Futures | 98.21 | 98.85 | 97.81 | 98.41 | 12740.0 |
| 2014-02-06 | DC | Futures | 32.61 | 33.03 | 32.56 | 32.95 | 454.0 |
| 2014-02-06 | DX | Futures | 77.18 | 77.36 | 76.842 | 77.029 | 28096.0 |
| 2014-02-06 | E1 | Futures | 1.42107 | 1.43198 | 1.41658 | 1.42556 | 35071.0 |
| 2014-02-06 | E6 | Futures | 1.59787 | 1.60778 | 1.59137 | 1.60389 | 309945.0 |
| 2014-02-06 | E7 | Futures | 1.5878 | 1.5973 | 1.581 | 1.5934 | 6505.0 |
| 2014-02-06 | EBM | Futures | 270.08 | 270.78 | 268.69 | 270.08 | 14413.0 |
| 2014-02-06 | ED | Futures | 95.3805 | 95.3805 | 95.3758 | 95.3758 | 74496.0 |
| 2014-02-06 | ER | Futures | 97.896 | 97.901 | 97.852 | 97.867 | 184179.0 |
| 2014-02-06 | EW | Futures | 1302.2 | 1320.6 | 1300.9 | 1317.0 | 17255.0 |
| 2014-02-06 | FBTP | Futures | 84.28 | 84.45 | 84.08 | 84.3 | 59934.0 |
| 2014-02-06 | FBTS | Futures | 96.433 | 96.468 | 96.336 | 96.415 | 14796.0 |
| 2014-02-06 | FCE | Futures | 3208.7 | 3268.2 | 3206.0 | 3258.1 | 168713.0 |
| 2014-02-06 | FDAX | Futures | 10121.4 | 10289.4 | 9992.2 | 10259.4 | 145356.0 |
| 2014-02-06 | FESX | Futures | 2085.2 | 2124.6 | 2085.2 | 2116.9 | 1323270.0 |
| 2014-02-06 | FEU3 | Futures | 98.507 | 98.507 | 98.483 | 98.483 | 13.0 |
| 2014-02-06 | FGBL | Futures | 122.56 | 122.59 | 121.92 | 121.97 | 964304.0 |
| 2014-02-06 | FGBM | Futures | 119.34 | 119.35 | 118.88 | 118.97 | 781102.0 |
| 2014-02-06 | FGBS | Futures | 110.658 | 110.678 | 110.538 | 110.573 | 595991.0 |
| 2014-02-06 | FGBX | Futures | 125.25 | 125.25 | 124.08 | 124.16 | 32178.0 |
| 2014-02-06 | FMWO | Futures | 5237.1 | 5237.1 | 5229.6 | 5229.6 | 36.0 |
| 2014-02-06 | FOAT | Futures | 110.91 | 110.94 | 110.38 | 110.47 | 105967.0 |
| 2014-02-06 | FTDX | Futures | 1136.2 | 1146.9 | 1129.6 | 1145.5 | 224.0 |
| 2014-02-06 | FTI | Futures | 328.0 | 333.35 | 327.74 | 332.24 | 39091.0 |
| 2014-02-06 | FTUK | Futures | 4870.8 | 4938.6 | 4849.3 | 4921.6 | 126988.0 |
| 2014-02-06 | FVSA | Futures | 2208.69 | 2254.6 | 2096.47 | 2116.87 | 12472.0 |
| 2014-02-06 | FXXP | Futures | 234.0 | 236.8 | 233.4 | 236.3 | 7011.0 |
| 2014-02-06 | G | Futures | 93.46 | 93.54 | 92.98 | 93.04 | 181214.0 |
| 2014-02-06 | GF | Futures | 269.491 | 270.257 | 268.322 | 269.249 | 3128.0 |
| 2014-02-06 | GSCI | Futures | 1032.11 | 1033.1 | 1026.21 | 1026.21 | 87.0 |
| 2014-02-06 | HE | Futures | 114.733 | 115.005 | 113.556 | 113.767 | 17713.0 |
| 2014-02-06 | HG | Futures | 4.0315 | 4.0985 | 4.0303 | 4.0783 | 43181.0 |
| 2014-02-06 | HH | Futures | 55.833 | 55.896 | 52.04 | 52.39 | 9983.0 |
> showing 50 of 104 rows — these rows as CSV