PREVIEW / futures_daily / 2013-12-20
file: by_date/futures_daily/2013/2013-12-20.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-20 | ES | Futures | 1858.12 | 1874.1 | 1858.12 | 1870.49 | 1356110.0 |
| 2013-12-20 | NQ | Futures | 4016.15 | 4066.45 | 4015.87 | 4060.7 | 173625.0 |
| 2013-12-20 | YM | Futures | 16090.6 | 16199.4 | 16086.6 | 16155.5 | 87204.0 |
| 2013-12-20 | CL | Futures | 174.24 | 175.48 | 173.96 | 175.34 | 151281.0 |
| 2013-12-20 | GC | Futures | 1574.0 | 1598.0 | 1573.0 | 1593.7 | 138710.0 |
| 2013-12-20 | ZN | Futures | 113.260904 | 113.432598 | 112.874592 | 113.303828 | 872224.0 |
| 2013-12-20 | A6 | Futures | 0.83929 | 0.84653 | 0.83872 | 0.84501 | 70603.0 |
| 2013-12-20 | AD | Futures | 0.94731 | 0.95076 | 0.94104 | 0.94782 | 61563.0 |
| 2013-12-20 | B | Futures | 111.86 | 113.69 | 111.64 | 113.57 | 169479.0 |
| 2013-12-20 | B6 | Futures | 1.7184 | 1.7214 | 1.7129 | 1.7149 | 75912.0 |
| 2013-12-20 | BFX | Futures | 3442.1 | 3471.5 | 3442.1 | 3467.0 | 6.0 |
| 2013-12-20 | BR | Futures | 0.21445 | 0.21448 | 0.21365 | 0.21438 | 56.0 |
| 2013-12-20 | BZ | Futures | 113.67 | 115.66 | 113.59 | 115.54 | 6214.0 |
| 2013-12-20 | C | Futures | 1885.0 | 1900.0 | 1880.0 | 1898.0 | 6348.0 |
| 2013-12-20 | CB | Futures | 80.839 | 81.697 | 80.471 | 81.084 | 54.0 |
| 2013-12-20 | CC | Futures | 2067.0 | 2095.0 | 2066.0 | 2092.0 | 7857.0 |
| 2013-12-20 | CNH | Futures | 7.0071 | 7.0071 | 6.9972 | 6.9972 | 150.0 |
| 2013-12-20 | CSC | Futures | 3.789 | 3.822 | 3.768 | 3.822 | 13.0 |
| 2013-12-20 | CT | Futures | 94.9 | 95.61 | 94.67 | 94.81 | 8059.0 |
| 2013-12-20 | DC | Futures | 29.02 | 29.57 | 29.02 | 29.57 | 305.0 |
| 2013-12-20 | DX | Futures | 76.923 | 77.032 | 76.609 | 76.79 | 23820.0 |
| 2013-12-20 | E1 | Futures | 1.43057 | 1.43827 | 1.42723 | 1.43403 | 24009.0 |
| 2013-12-20 | E6 | Futures | 1.61203 | 1.61829 | 1.60837 | 1.61392 | 180641.0 |
| 2013-12-20 | E7 | Futures | 1.6014 | 1.6076 | 1.5979 | 1.6034 | 5014.0 |
| 2013-12-20 | EBM | Futures | 282.96 | 286.79 | 281.92 | 286.09 | 20636.0 |
| 2013-12-20 | ED | Futures | 95.3423 | 95.3471 | 95.3327 | 95.3423 | 141251.0 |
| 2013-12-20 | ER | Futures | 97.862 | 97.867 | 97.842 | 97.852 | 76003.0 |
| 2013-12-20 | EW | Futures | 1330.3 | 1345.6 | 1328.3 | 1344.3 | 16561.0 |
| 2013-12-20 | FBTP | Futures | 82.04 | 82.06 | 81.77 | 81.85 | 26284.0 |
| 2013-12-20 | FBTS | Futures | 95.6 | 95.635 | 95.53 | 95.591 | 6277.0 |
| 2013-12-20 | FCE | Futures | 3270.5 | 3276.3 | 3249.0 | 3270.5 | 86410.0 |
| 2013-12-20 | FDAX | Futures | 10402.5 | 10457.4 | 10385.9 | 10440.2 | 78780.0 |
| 2013-12-20 | FESX | Futures | 2135.9 | 2146.4 | 2128.8 | 2143.6 | 838691.0 |
| 2013-12-20 | FEU3 | Futures | 98.478 | 98.478 | 98.468 | 98.468 | 2.0 |
| 2013-12-20 | FGBL | Futures | 118.97 | 119.1 | 118.65 | 119.07 | 409496.0 |
| 2013-12-20 | FGBM | Futures | 117.43 | 117.44 | 117.21 | 117.39 | 280018.0 |
| 2013-12-20 | FGBS | Futures | 110.318 | 110.338 | 110.278 | 110.318 | 234794.0 |
| 2013-12-20 | FGBX | Futures | 119.63 | 120.12 | 119.34 | 120.02 | 8905.0 |
| 2013-12-20 | FMWO | Futures | 5323.9 | 5341.5 | 5320.1 | 5341.5 | 159.0 |
| 2013-12-20 | FOAT | Futures | 108.11 | 108.24 | 107.91 | 108.23 | 20218.0 |
| 2013-12-20 | FTDX | Futures | 1088.3 | 1089.2 | 1079.8 | 1086.4 | 189.0 |
| 2013-12-20 | FTI | Futures | 333.5 | 337.06 | 333.5 | 336.46 | 28849.0 |
| 2013-12-20 | FTUK | Futures | 4949.6 | 5026.0 | 4938.2 | 4948.8 | 106693.0 |
| 2013-12-20 | FVSA | Futures | 1864.55 | 1864.55 | 1800.07 | 1848.43 | 5954.0 |
| 2013-12-20 | FXXP | Futures | 234.8 | 235.7 | 234.1 | 235.2 | 7190.0 |
| 2013-12-20 | G | Futures | 90.48 | 90.79 | 90.29 | 90.77 | 85515.0 |
| 2013-12-20 | GF | Futures | 268.77 | 269.374 | 267.845 | 268.811 | 2358.0 |
| 2013-12-20 | GSCI | Futures | 1047.48 | 1055.08 | 1047.48 | 1055.08 | 46.0 |
| 2013-12-20 | HE | Futures | 104.075 | 104.437 | 103.683 | 104.166 | 14177.0 |
| 2013-12-20 | HG | Futures | 4.1673 | 4.19 | 4.1566 | 4.1781 | 34898.0 |
> showing 50 of 105 rows — these rows as CSV