PREVIEW / futures_daily / 2014-02-10
file: by_date/futures_daily/2014/2014-02-10.parquet size: 9 KB rows: 102
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-10 | ES | Futures | 1848.32 | 1851.42 | 1841.37 | 1850.13 | 1148560.0 |
| 2014-02-10 | NQ | Futures | 4092.89 | 4117.61 | 4081.68 | 4112.72 | 205066.0 |
| 2014-02-10 | YM | Futures | 15723.2 | 15733.1 | 15650.3 | 15714.2 | 106803.0 |
| 2014-02-10 | CL | Futures | 176.68 | 177.57 | 175.02 | 176.7 | 251127.0 |
| 2014-02-10 | GC | Futures | 1668.0 | 1684.4 | 1667.1 | 1680.3 | 94770.0 |
| 2014-02-10 | ZN | Futures | 115.249695 | 115.47862 | 115.221079 | 115.321234 | 651835.0 |
| 2014-02-10 | A6 | Futures | 0.8512 | 0.85177 | 0.84691 | 0.85044 | 48526.0 |
| 2014-02-10 | AD | Futures | 0.91633 | 0.91825 | 0.91461 | 0.91592 | 35114.0 |
| 2014-02-10 | B | Futures | 111.92 | 111.93 | 110.62 | 110.85 | 168263.0 |
| 2014-02-10 | B6 | Futures | 1.7237 | 1.7253 | 1.7204 | 1.7228 | 57690.0 |
| 2014-02-10 | BR | Futures | 0.21546 | 0.21616 | 0.21383 | 0.21471 | 1022.0 |
| 2014-02-10 | BZ | Futures | 114.06 | 114.11 | 113.0 | 113.1 | 9643.0 |
| 2014-02-10 | C | Futures | 1962.0 | 1978.0 | 1960.0 | 1965.0 | 8246.0 |
| 2014-02-10 | CB | Futures | 85.083 | 85.488 | 84.396 | 84.396 | 31.0 |
| 2014-02-10 | CC | Futures | 2183.0 | 2186.0 | 2165.0 | 2175.0 | 19864.0 |
| 2014-02-10 | CSC | Futures | 4.168 | 4.168 | 4.128 | 4.151 | 89.0 |
| 2014-02-10 | CT | Futures | 99.81 | 101.3 | 99.24 | 99.62 | 22521.0 |
| 2014-02-10 | DC | Futures | 32.43 | 32.43 | 31.81 | 32.09 | 571.0 |
| 2014-02-10 | DX | Futures | 76.856 | 76.875 | 76.709 | 76.768 | 10587.0 |
| 2014-02-10 | E1 | Futures | 1.42929 | 1.43314 | 1.42774 | 1.4316 | 15078.0 |
| 2014-02-10 | E6 | Futures | 1.60825 | 1.61144 | 1.60755 | 1.61026 | 124011.0 |
| 2014-02-10 | E7 | Futures | 1.598 | 1.601 | 1.5969 | 1.5998 | 2635.0 |
| 2014-02-10 | EBM | Futures | 269.74 | 273.56 | 269.04 | 271.13 | 9811.0 |
| 2014-02-10 | ED | Futures | 95.3805 | 95.3805 | 95.3758 | 95.3758 | 50412.0 |
| 2014-02-10 | ER | Futures | 97.871 | 97.881 | 97.867 | 97.871 | 38490.0 |
| 2014-02-10 | EW | Futures | 1332.6 | 1337.8 | 1327.1 | 1336.2 | 10646.0 |
| 2014-02-10 | FBTP | Futures | 84.66 | 84.78 | 84.59 | 84.73 | 27183.0 |
| 2014-02-10 | FBTS | Futures | 96.476 | 96.503 | 96.459 | 96.468 | 6652.0 |
| 2014-02-10 | FCE | Futures | 3304.4 | 3307.5 | 3288.4 | 3295.0 | 82713.0 |
| 2014-02-10 | FDAX | Futures | 10368.1 | 10370.9 | 10294.4 | 10304.3 | 86622.0 |
| 2014-02-10 | FESX | Futures | 2151.3 | 2152.1 | 2128.8 | 2133.1 | 754391.0 |
| 2014-02-10 | FGBL | Futures | 122.46 | 122.49 | 122.16 | 122.24 | 392631.0 |
| 2014-02-10 | FGBM | Futures | 119.28 | 119.31 | 119.13 | 119.17 | 319762.0 |
| 2014-02-10 | FGBS | Futures | 110.638 | 110.643 | 110.593 | 110.608 | 208389.0 |
| 2014-02-10 | FGBX | Futures | 124.86 | 124.88 | 124.12 | 124.25 | 9287.0 |
| 2014-02-10 | FMWO | Futures | 5289.9 | 5297.5 | 5289.9 | 5297.5 | 36.0 |
| 2014-02-10 | FOAT | Futures | 110.81 | 110.84 | 110.52 | 110.57 | 33708.0 |
| 2014-02-10 | FTDX | Futures | 1155.9 | 1159.2 | 1153.5 | 1154.5 | 72.0 |
| 2014-02-10 | FTI | Futures | 333.18 | 333.44 | 331.86 | 332.33 | 50.0 |
| 2014-02-10 | FTUK | Futures | 4957.1 | 4958.3 | 4928.4 | 4947.3 | 77641.0 |
| 2014-02-10 | FVSA | Futures | 1979.15 | 2004.65 | 1948.54 | 1968.95 | 7833.0 |
| 2014-02-10 | FXXP | Futures | 239.0 | 239.0 | 237.9 | 238.4 | 4003.0 |
| 2014-02-10 | G | Futures | 93.38 | 93.44 | 93.14 | 93.25 | 91946.0 |
| 2014-02-10 | GF | Futures | 270.377 | 271.184 | 269.45 | 270.7 | 2983.0 |
| 2014-02-10 | GSCI | Futures | 1040.31 | 1041.54 | 1037.68 | 1040.06 | 1448.0 |
| 2014-02-10 | HE | Futures | 114.19 | 114.582 | 114.009 | 114.431 | 10456.0 |
| 2014-02-10 | HG | Futures | 4.0934 | 4.1086 | 4.06 | 4.0726 | 40454.0 |
| 2014-02-10 | HH | Futures | 49.638 | 50.69 | 48.491 | 48.65 | 824.0 |
| 2014-02-10 | HO | Futures | 2.4386 | 2.4396 | 2.3919 | 2.3969 | 74321.0 |
| 2014-02-10 | HRC | Futures | 2349.6 | 2349.6 | 2349.6 | 2349.6 | 0.0 |
> showing 50 of 102 rows — these rows as CSV