PREVIEW / futures_daily / 2014-10-10
file: by_date/futures_daily/2014/2014-10-10.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-10-10 | ES | Futures | 2002.47 | 2017.36 | 1977.66 | 1978.71 | 3069299.0 |
| 2014-10-10 | NQ | Futures | 4575.64 | 4597.66 | 4463.22 | 4465.53 | 675542.0 |
| 2014-10-10 | YM | Futures | 16781.2 | 16924.3 | 16665.6 | 16675.7 | 309178.0 |
| 2014-10-10 | CL | Futures | 158.97 | 162.55 | 157.46 | 161.66 | 396528.0 |
| 2014-10-10 | GC | Futures | 1605.5 | 1607.7 | 1597.1 | 1602.4 | 121360.0 |
| 2014-10-10 | ZN | Futures | 118.568672 | 118.817612 | 118.290445 | 118.59796 | 1401431.0 |
| 2014-10-10 | A6 | Futures | 0.84867 | 0.84984 | 0.83973 | 0.84235 | 124108.0 |
| 2014-10-10 | AD | Futures | 0.90686 | 0.90889 | 0.90321 | 0.90453 | 85730.0 |
| 2014-10-10 | ALI | Futures | 2923.63 | 2923.63 | 2923.63 | 2923.63 | 5.0 |
| 2014-10-10 | B | Futures | 92.96 | 94.31 | 91.71 | 94.02 | 304318.0 |
| 2014-10-10 | B6 | Futures | 1.6935 | 1.6951 | 1.6818 | 1.6866 | 89808.0 |
| 2014-10-10 | BR | Futures | 0.22036 | 0.22222 | 0.22012 | 0.22219 | 1866.0 |
| 2014-10-10 | BZ | Futures | 93.37 | 95.0 | 92.46 | 94.71 | 27308.0 |
| 2014-10-10 | C | Futures | 2117.0 | 2195.0 | 2116.0 | 2186.0 | 9541.0 |
| 2014-10-10 | CB | Futures | 141.051 | 146.447 | 141.051 | 146.447 | 8.0 |
| 2014-10-10 | CC | Futures | 2259.0 | 2342.0 | 2257.0 | 2331.0 | 18708.0 |
| 2014-10-10 | CNH | Futures | 7.0584 | 7.071 | 7.0584 | 7.0688 | 1.0 |
| 2014-10-10 | CSC | Futures | 5.148 | 5.161 | 5.148 | 5.161 | 2.0 |
| 2014-10-10 | CT | Futures | 81.02 | 83.0 | 80.59 | 81.22 | 17630.0 |
| 2014-10-10 | DC | Futures | 41.84 | 42.05 | 41.53 | 41.82 | 149.0 |
| 2014-10-10 | DX | Futures | 81.31 | 81.737 | 81.177 | 81.667 | 28187.0 |
| 2014-10-10 | E1 | Futures | 1.34041 | 1.34272 | 1.33351 | 1.3353 | 33721.0 |
| 2014-10-10 | E6 | Futures | 1.49446 | 1.49752 | 1.48445 | 1.48539 | 221594.0 |
| 2014-10-10 | E7 | Futures | 1.4849 | 1.4881 | 1.4752 | 1.4761 | 2549.0 |
| 2014-10-10 | ED | Futures | 95.447 | 95.4517 | 95.4422 | 95.4422 | 81838.0 |
| 2014-10-10 | ER | Futures | 97.999 | 98.009 | 97.994 | 97.994 | 68941.0 |
| 2014-10-10 | EW | Futures | 1376.6 | 1383.8 | 1349.9 | 1351.6 | 39356.0 |
| 2014-10-10 | FBTP | Futures | 95.56 | 95.57 | 95.27 | 95.47 | 65686.0 |
| 2014-10-10 | FBTS | Futures | 98.588 | 98.623 | 98.472 | 98.597 | 12012.0 |
| 2014-10-10 | FCE | Futures | 3257.1 | 3285.0 | 3234.8 | 3243.2 | 184915.0 |
| 2014-10-10 | FDAX | Futures | 9773.6 | 9816.9 | 9602.2 | 9650.4 | 214116.0 |
| 2014-10-10 | FESX | Futures | 2169.5 | 2191.2 | 2151.4 | 2161.5 | 1861394.0 |
| 2014-10-10 | FEU3 | Futures | 98.621 | 98.621 | 98.621 | 98.621 | 40.0 |
| 2014-10-10 | FGBL | Futures | 132.41 | 132.66 | 132.16 | 132.5 | 711390.0 |
| 2014-10-10 | FGBM | Futures | 122.98 | 123.08 | 122.91 | 123.0 | 360107.0 |
| 2014-10-10 | FGBS | Futures | 110.928 | 110.933 | 110.913 | 110.918 | 226822.0 |
| 2014-10-10 | FGBX | Futures | 143.62 | 144.0 | 142.91 | 143.66 | 21892.0 |
| 2014-10-10 | FMWO | Futures | 5475.6 | 5475.6 | 5415.4 | 5421.6 | 632.0 |
| 2014-10-10 | FOAT | Futures | 122.09 | 122.21 | 121.79 | 122.0 | 57467.0 |
| 2014-10-10 | FTDX | Futures | 1103.4 | 1103.4 | 1075.0 | 1093.5 | 442.0 |
| 2014-10-10 | FTI | Futures | 347.78 | 348.83 | 344.37 | 345.11 | 258.0 |
| 2014-10-10 | FTUK | Futures | 4900.1 | 4935.3 | 4835.2 | 4888.1 | 167047.0 |
| 2014-10-10 | FVSA | Futures | 1615.7 | 1737.49 | 1591.34 | 1737.49 | 19112.0 |
| 2014-10-10 | FXXP | Futures | 244.3 | 245.7 | 242.2 | 243.5 | 18257.0 |
| 2014-10-10 | G | Futures | 98.35 | 98.94 | 98.26 | 98.75 | 200654.0 |
| 2014-10-10 | GF | Futures | 375.947 | 377.238 | 373.364 | 374.421 | 4948.0 |
| 2014-10-10 | GSCI | Futures | 931.68 | 944.17 | 931.68 | 942.21 | 1529.0 |
| 2014-10-10 | HE | Futures | 128.366 | 128.837 | 126.683 | 127.053 | 11517.0 |
| 2014-10-10 | HG | Futures | 3.8433 | 3.8598 | 3.7919 | 3.8496 | 65320.0 |
| 2014-10-10 | HH | Futures | 46.545 | 46.931 | 46.424 | 46.653 | 1564.0 |
> showing 50 of 104 rows — these rows as CSV