PREVIEW / futures_daily / 2016-10-03
file: by_date/futures_daily/2016/2016-10-03.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2016-10-03 | ES | Futures | 2334.9 | 2340.57 | 2321.92 | 2328.95 | 1406125.0 |
| 2016-10-03 | NQ | Futures | 5736.29 | 5750.73 | 5707.42 | 5734.52 | 177125.0 |
| 2016-10-03 | YM | Futures | 19114.0 | 19166.5 | 19014.3 | 19064.7 | 121065.0 |
| 2016-10-03 | CL | Futures | 52.97 | 54.05 | 52.69 | 53.82 | 458021.0 |
| 2016-10-03 | GC | Futures | 1694.9 | 1696.9 | 1683.1 | 1684.2 | 130138.0 |
| 2016-10-03 | ZN | Futures | 127.651694 | 127.666895 | 127.347689 | 127.39329 | 775029.0 |
| 2016-10-03 | A6 | Futures | 0.78061 | 0.78254 | 0.77836 | 0.78163 | 62595.0 |
| 2016-10-03 | AD | Futures | 0.78114 | 0.78426 | 0.77965 | 0.78154 | 54065.0 |
| 2016-10-03 | ALI | Futures | 2207.42 | 2207.42 | 2207.42 | 2207.42 | 0.0 |
| 2016-10-03 | B | Futures | 38.71 | 39.58 | 38.49 | 39.38 | 284259.0 |
| 2016-10-03 | B6 | Futures | 1.3648 | 1.3651 | 1.3513 | 1.3555 | 124686.0 |
| 2016-10-03 | BFX | Futures | 4222.9 | 4222.9 | 4202.7 | 4202.7 | 3.0 |
| 2016-10-03 | BR | Futures | 0.2076 | 0.21082 | 0.2076 | 0.20989 | 9.0 |
| 2016-10-03 | BZ | Futures | 38.63 | 39.34 | 38.31 | 39.16 | 27245.0 |
| 2016-10-03 | C | Futures | 2388.0 | 2421.0 | 2371.0 | 2418.0 | 11330.0 |
| 2016-10-03 | CB | Futures | 241.788 | 242.408 | 241.385 | 242.408 | 25.0 |
| 2016-10-03 | CC | Futures | 2041.0 | 2070.0 | 2025.0 | 2066.0 | 22081.0 |
| 2016-10-03 | CNH | Futures | 7.1954 | 7.2058 | 7.1954 | 7.1997 | 6.0 |
| 2016-10-03 | CSC | Futures | 3.764 | 3.764 | 3.73 | 3.741 | 31.0 |
| 2016-10-03 | CT | Futures | 76.29 | 76.92 | 75.28 | 76.76 | 13360.0 |
| 2016-10-03 | DC | Futures | 29.65 | 29.65 | 29.28 | 29.4 | 161.0 |
| 2016-10-03 | DX | Futures | 88.823 | 89.103 | 88.781 | 88.965 | 15625.0 |
| 2016-10-03 | E1 | Futures | 1.28755 | 1.28954 | 1.28418 | 1.2863 | 20343.0 |
| 2016-10-03 | E6 | Futures | 1.30721 | 1.30819 | 1.30332 | 1.30472 | 106821.0 |
| 2016-10-03 | E7 | Futures | 1.3003 | 1.3009 | 1.2962 | 1.2976 | 1308.0 |
| 2016-10-03 | EBM | Futures | 188.88 | 190.35 | 188.0 | 188.29 | 16081.0 |
| 2016-10-03 | ED | Futures | 95.6538 | 95.6538 | 95.6345 | 95.6393 | 175230.0 |
| 2016-10-03 | ER | Futures | 98.269 | 98.274 | 98.264 | 98.264 | 33105.0 |
| 2016-10-03 | EW | Futures | 1646.5 | 1649.7 | 1633.8 | 1636.8 | 22195.0 |
| 2016-10-03 | FBON | Futures | 125.56 | 125.81 | 125.15 | 125.41 | 856.0 |
| 2016-10-03 | FBTP | Futures | 109.98 | 110.09 | 109.24 | 109.69 | 63500.0 |
| 2016-10-03 | FBTS | Futures | 101.32 | 101.329 | 101.266 | 101.32 | 17087.0 |
| 2016-10-03 | FCE | Futures | 3951.6 | 3967.6 | 3936.9 | 3956.0 | 55509.0 |
| 2016-10-03 | FESX | Futures | 2394.1 | 2402.1 | 2376.5 | 2388.5 | 389587.0 |
| 2016-10-03 | FGBL | Futures | 151.28 | 151.43 | 150.93 | 151.02 | 352828.0 |
| 2016-10-03 | FGBM | Futures | 129.28 | 129.34 | 129.22 | 129.23 | 209660.0 |
| 2016-10-03 | FGBS | Futures | 111.987 | 112.002 | 111.977 | 111.987 | 180155.0 |
| 2016-10-03 | FGBX | Futures | 188.62 | 189.28 | 186.85 | 187.54 | 27713.0 |
| 2016-10-03 | FMWO | Futures | 5767.9 | 5767.9 | 5743.7 | 5746.1 | 92.0 |
| 2016-10-03 | FOAT | Futures | 138.79 | 138.92 | 138.33 | 138.45 | 80128.0 |
| 2016-10-03 | FTI | Futures | 414.4 | 416.87 | 413.75 | 415.27 | 18541.0 |
| 2016-10-03 | FTUK | Futures | 5799.7 | 5874.0 | 5789.6 | 5863.4 | 103873.0 |
| 2016-10-03 | FVSA | Futures | 1551.52 | 1562.25 | 1501.47 | 1522.92 | 16282.0 |
| 2016-10-03 | FXXP | Futures | 281.5 | 282.6 | 280.8 | 281.9 | 20977.0 |
| 2016-10-03 | G | Futures | 116.17 | 116.49 | 116.14 | 116.32 | 154866.0 |
| 2016-10-03 | GF | Futures | 253.022 | 260.191 | 251.991 | 255.755 | 3182.0 |
| 2016-10-03 | GSCI | Futures | 519.12 | 522.32 | 514.5 | 521.4 | 349.0 |
| 2016-10-03 | HE | Futures | 68.003 | 69.078 | 66.545 | 67.811 | 31366.0 |
| 2016-10-03 | HG | Futures | 2.7585 | 2.7604 | 2.6994 | 2.7305 | 70438.0 |
| 2016-10-03 | HH | Futures | 25.424 | 25.785 | 25.371 | 25.75 | 1066.0 |
> showing 50 of 106 rows — these rows as CSV