PREVIEW / futures_daily / 2016-02-16
file: by_date/futures_daily/2016/2016-02-16.parquet size: 9 KB rows: 109
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-02-16 | ES | Futures | 1992.34 | 2021.72 | 1992.07 | 2017.44 | 2034059.0 |
| 2016-02-16 | NQ | Futures | 4714.44 | 4812.03 | 4714.44 | 4797.96 | 320588.0 |
| 2016-02-16 | YM | Futures | 16509.2 | 16766.9 | 16509.2 | 16692.4 | 221658.0 |
| 2016-02-16 | CL | Futures | 39.33 | 42.44 | 38.52 | 38.91 | 481273.0 |
| 2016-02-16 | GC | Futures | 1588.5 | 1588.5 | 1531.0 | 1552.4 | 340804.0 |
| 2016-02-16 | ZN | Futures | 126.093519 | 126.258977 | 125.747563 | 126.018311 | 1581160.0 |
| 2016-02-16 | A6 | Futures | 0.71131 | 0.71873 | 0.70861 | 0.71051 | 131936.0 |
| 2016-02-16 | AD | Futures | 0.73771 | 0.74609 | 0.73494 | 0.73679 | 84487.0 |
| 2016-02-16 | ALI | Futures | 2084.44 | 2084.44 | 2084.44 | 2084.44 | 0.0 |
| 2016-02-16 | B | Futures | 29.0 | 29.87 | 26.82 | 27.04 | 398492.0 |
| 2016-02-16 | B6 | Futures | 1.5258 | 1.5293 | 1.502 | 1.503 | 131677.0 |
| 2016-02-16 | BFX | Futures | 3869.2 | 3869.2 | 3848.1 | 3859.8 | 34.0 |
| 2016-02-16 | BR | Futures | 0.15718 | 0.15718 | 0.15359 | 0.15438 | 3689.0 |
| 2016-02-16 | BZ | Futures | 27.3 | 29.63 | 26.64 | 26.84 | 48407.0 |
| 2016-02-16 | C | Futures | 2150.0 | 2167.0 | 2128.0 | 2160.0 | 2322.0 |
| 2016-02-16 | CB | Futures | 264.091 | 264.462 | 258.524 | 258.834 | 22.0 |
| 2016-02-16 | CC | Futures | 2090.0 | 2102.0 | 2063.0 | 2075.0 | 14141.0 |
| 2016-02-16 | CNH | Futures | 7.195 | 7.195 | 7.1441 | 7.1801 | 59.0 |
| 2016-02-16 | CSC | Futures | 3.77 | 3.77 | 3.738 | 3.75 | 30.0 |
| 2016-02-16 | CT | Futures | 69.11 | 70.8 | 69.06 | 70.11 | 25510.0 |
| 2016-02-16 | DC | Futures | 30.26 | 30.26 | 29.74 | 29.78 | 339.0 |
| 2016-02-16 | DX | Futures | 90.271 | 90.612 | 90.052 | 90.496 | 17320.0 |
| 2016-02-16 | E1 | Futures | 1.29291 | 1.29329 | 1.27713 | 1.27864 | 29181.0 |
| 2016-02-16 | E6 | Futures | 1.31571 | 1.31589 | 1.30162 | 1.30396 | 252501.0 |
| 2016-02-16 | E7 | Futures | 1.3079 | 1.3081 | 1.2943 | 1.2966 | 4892.0 |
| 2016-02-16 | EBM | Futures | 220.35 | 222.12 | 216.11 | 216.47 | 27321.0 |
| 2016-02-16 | ED | Futures | 95.6434 | 95.6482 | 95.6385 | 95.6434 | 167306.0 |
| 2016-02-16 | ER | Futures | 98.283 | 98.293 | 98.274 | 98.288 | 41826.0 |
| 2016-02-16 | EW | Futures | 1331.5 | 1359.7 | 1331.5 | 1356.5 | 18952.0 |
| 2016-02-16 | FBON | Futures | 116.11 | 116.32 | 115.51 | 115.58 | 1027.0 |
| 2016-02-16 | FBTP | Futures | 104.98 | 105.11 | 104.46 | 104.59 | 85003.0 |
| 2016-02-16 | FBTS | Futures | 100.766 | 100.802 | 100.704 | 100.73 | 22580.0 |
| 2016-02-16 | FCE | Futures | 3442.3 | 3462.3 | 3402.0 | 3421.5 | 103496.0 |
| 2016-02-16 | FDAX | Futures | 10043.4 | 10049.9 | 9837.4 | 9873.7 | 102618.0 |
| 2016-02-16 | FDXM | Futures | 9595.7 | 9610.3 | 9408.1 | 9442.3 | 26260.0 |
| 2016-02-16 | FESX | Futures | 2167.8 | 2175.4 | 2130.5 | 2139.6 | 1674870.0 |
| 2016-02-16 | FGBL | Futures | 144.98 | 145.15 | 144.6 | 144.86 | 694807.0 |
| 2016-02-16 | FGBM | Futures | 127.43 | 127.52 | 127.35 | 127.39 | 420302.0 |
| 2016-02-16 | FGBS | Futures | 111.778 | 111.783 | 111.748 | 111.763 | 203853.0 |
| 2016-02-16 | FGBX | Futures | 170.79 | 171.2 | 169.19 | 169.95 | 37813.0 |
| 2016-02-16 | FMWO | Futures | 5112.3 | 5119.8 | 5081.2 | 5096.1 | 198.0 |
| 2016-02-16 | FOAT | Futures | 131.51 | 131.6 | 131.13 | 131.26 | 107338.0 |
| 2016-02-16 | FTDX | Futures | 1511.2 | 1511.2 | 1474.2 | 1478.1 | 945.0 |
| 2016-02-16 | FTI | Futures | 358.76 | 360.4 | 354.02 | 355.84 | 23329.0 |
| 2016-02-16 | FTUK | Futures | 4719.8 | 4774.1 | 4699.8 | 4732.9 | 133659.0 |
| 2016-02-16 | FVSA | Futures | 3513.15 | 3542.37 | 3448.85 | 3495.61 | 16065.0 |
| 2016-02-16 | FXXP | Futures | 253.3 | 254.6 | 249.9 | 251.2 | 37818.0 |
| 2016-02-16 | G | Futures | 108.2 | 108.42 | 107.91 | 108.38 | 164916.0 |
| 2016-02-16 | GF | Futures | 294.627 | 303.414 | 292.909 | 303.365 | 3919.0 |
| 2016-02-16 | GSCI | Futures | 450.21 | 450.59 | 442.43 | 443.5 | 515.0 |
> showing 50 of 109 rows — these rows as CSV