PREVIEW / futures_daily / 2015-01-02
file: by_date/futures_daily/2015/2015-01-02.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 |
|---|---|---|---|---|---|---|---|
| 2015-01-02 | ES | Futures | 2153.9 | 2166.74 | 2136.87 | 2144.73 | 1358348.0 |
| 2015-01-02 | NQ | Futures | 4919.93 | 4957.64 | 4874.38 | 4889.76 | 229555.0 |
| 2015-01-02 | YM | Futures | 18109.5 | 18214.4 | 17981.2 | 18050.5 | 124972.0 |
| 2015-01-02 | CL | Futures | 105.29 | 107.94 | 101.9 | 103.2 | 268708.0 |
| 2015-01-02 | GC | Futures | 1549.8 | 1564.0 | 1527.9 | 1552.6 | 120678.0 |
| 2015-01-02 | ZN | Futures | 119.290036 | 119.967235 | 119.098654 | 119.805296 | 768078.0 |
| 2015-01-02 | A6 | Futures | 0.79611 | 0.79768 | 0.7871 | 0.79072 | 58931.0 |
| 2015-01-02 | AD | Futures | 0.87625 | 0.87625 | 0.86261 | 0.86546 | 49821.0 |
| 2015-01-02 | ALI | Futures | 2794.49 | 2794.49 | 2794.49 | 2794.49 | 0.0 |
| 2015-01-02 | B | Futures | 60.16 | 60.67 | 57.48 | 58.47 | 79883.0 |
| 2015-01-02 | B6 | Futures | 1.6372 | 1.6379 | 1.6103 | 1.6115 | 109677.0 |
| 2015-01-02 | BR | Futures | 0.20146 | 0.20207 | 0.20091 | 0.20193 | 55.0 |
| 2015-01-02 | BZ | Futures | 59.71 | 60.96 | 57.84 | 58.79 | 20110.0 |
| 2015-01-02 | C | Futures | 2137.0 | 2173.0 | 2132.0 | 2169.0 | 5411.0 |
| 2015-01-02 | CB | Futures | 133.084 | 133.084 | 132.365 | 132.879 | 5.0 |
| 2015-01-02 | CC | Futures | 2153.0 | 2173.0 | 2137.0 | 2160.0 | 10634.0 |
| 2015-01-02 | CSC | Futures | 4.56 | 4.563 | 4.546 | 4.546 | 30.0 |
| 2015-01-02 | CT | Futures | 76.98 | 77.1 | 75.95 | 76.1 | 14941.0 |
| 2015-01-02 | DC | Futures | 35.88 | 36.25 | 35.69 | 35.69 | 64.0 |
| 2015-01-02 | DX | Futures | 85.958 | 86.602 | 85.949 | 86.501 | 44832.0 |
| 2015-01-02 | E1 | Futures | 1.2865 | 1.28675 | 1.27309 | 1.27705 | 28789.0 |
| 2015-01-02 | E6 | Futures | 1.42444 | 1.4248 | 1.41233 | 1.41303 | 73033.0 |
| 2015-01-02 | E7 | Futures | 1.4163 | 1.4163 | 1.4039 | 1.4046 | 2904.0 |
| 2015-01-02 | EBM | Futures | 322.79 | 324.82 | 321.57 | 322.79 | 7402.0 |
| 2015-01-02 | ED | Futures | 95.4402 | 95.445 | 95.4306 | 95.4402 | 84357.0 |
| 2015-01-02 | ER | Futures | 98.014 | 98.033 | 98.014 | 98.028 | 34749.0 |
| 2015-01-02 | EW | Futures | 1517.5 | 1526.7 | 1502.4 | 1508.1 | 17998.0 |
| 2015-01-02 | FBTP | Futures | 99.09 | 100.1 | 99.02 | 99.92 | 45130.0 |
| 2015-01-02 | FBTS | Futures | 98.783 | 98.978 | 98.783 | 98.952 | 9935.0 |
| 2015-01-02 | FCE | Futures | 3477.4 | 3521.9 | 3446.0 | 3470.1 | 100251.0 |
| 2015-01-02 | FDAX | Futures | 10877.1 | 10980.9 | 10760.5 | 10844.9 | 78831.0 |
| 2015-01-02 | FDIV | Futures | 138.81 | 139.37 | 138.81 | 139.32 | 15.0 |
| 2015-01-02 | FESX | Futures | 2258.8 | 2288.3 | 2239.3 | 2260.2 | 646026.0 |
| 2015-01-02 | FEU3 | Futures | 98.645 | 98.645 | 98.645 | 98.645 | 2.0 |
| 2015-01-02 | FGBL | Futures | 136.45 | 137.09 | 136.36 | 137.01 | 337404.0 |
| 2015-01-02 | FGBM | Futures | 123.89 | 123.95 | 123.82 | 123.93 | 202907.0 |
| 2015-01-02 | FGBS | Futures | 111.008 | 111.018 | 110.983 | 111.008 | 172079.0 |
| 2015-01-02 | FGBX | Futures | 155.55 | 157.38 | 155.15 | 157.24 | 19030.0 |
| 2015-01-02 | FMWO | Futures | 5626.1 | 5626.1 | 5591.4 | 5593.9 | 104.0 |
| 2015-01-02 | FOAT | Futures | 125.81 | 126.3 | 125.71 | 126.25 | 34627.0 |
| 2015-01-02 | FTDX | Futures | 1290.5 | 1303.6 | 1290.5 | 1299.4 | 142.0 |
| 2015-01-02 | FTI | Futures | 366.19 | 370.95 | 363.68 | 365.5 | 25540.0 |
| 2015-01-02 | FTUK | Futures | 5112.8 | 5113.2 | 5030.6 | 5056.7 | 69087.0 |
| 2015-01-02 | FVSA | Futures | 1924.23 | 2102.69 | 1924.23 | 2071.65 | 12807.0 |
| 2015-01-02 | FXXP | Futures | 258.6 | 260.2 | 256.4 | 257.1 | 3736.0 |
| 2015-01-02 | G | Futures | 102.87 | 103.42 | 102.61 | 103.32 | 76623.0 |
| 2015-01-02 | GF | Futures | 353.83 | 359.325 | 353.148 | 359.325 | 1577.0 |
| 2015-01-02 | GSCI | Futures | 704.92 | 713.02 | 704.16 | 706.63 | 131.0 |
| 2015-01-02 | HE | Futures | 108.599 | 109.74 | 108.566 | 109.069 | 11628.0 |
| 2015-01-02 | HG | Futures | 3.5892 | 3.6089 | 3.5581 | 3.579 | 24535.0 |
> showing 50 of 106 rows — these rows as CSV