PREVIEW / futures_daily / 2015-06-29
file: by_date/futures_daily/2015/2015-06-29.parquet size: 9 KB rows: 107
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-06-29 | ES | Futures | 2187.46 | 2207.86 | 2169.71 | 2173.16 | 2292340.0 |
| 2015-06-29 | NQ | Futures | 5171.82 | 5197.21 | 5100.02 | 5111.4 | 334972.0 |
| 2015-06-29 | YM | Futures | 18167.0 | 18236.8 | 17964.7 | 17993.4 | 225524.0 |
| 2015-06-29 | CL | Futures | 98.28 | 98.99 | 96.94 | 97.42 | 286035.0 |
| 2015-06-29 | GC | Futures | 1544.3 | 1551.0 | 1532.2 | 1539.8 | 145708.0 |
| 2015-06-29 | ZN | Futures | 120.481627 | 121.047969 | 119.796057 | 120.377301 | 1693467.0 |
| 2015-06-29 | A6 | Futures | 0.75208 | 0.7608 | 0.74832 | 0.75991 | 86785.0 |
| 2015-06-29 | AD | Futures | 0.8269 | 0.83007 | 0.82281 | 0.82567 | 74763.0 |
| 2015-06-29 | ALI | Futures | 2330.01 | 2330.01 | 2330.01 | 2330.01 | 0.0 |
| 2015-06-29 | B | Futures | 58.84 | 59.17 | 57.69 | 58.25 | 154221.0 |
| 2015-06-29 | B6 | Futures | 1.6492 | 1.661 | 1.6472 | 1.6554 | 110186.0 |
| 2015-06-29 | BFX | Futures | 4386.4 | 4407.0 | 4384.0 | 4384.0 | 10.0 |
| 2015-06-29 | BR | Futures | 0.18662 | 0.18857 | 0.18611 | 0.18797 | 542.0 |
| 2015-06-29 | BZ | Futures | 58.78 | 59.11 | 57.7 | 58.22 | 23513.0 |
| 2015-06-29 | C | Futures | 2339.0 | 2353.0 | 2329.0 | 2344.0 | 3162.0 |
| 2015-06-29 | CC | Futures | 2427.0 | 2455.0 | 2424.0 | 2449.0 | 10512.0 |
| 2015-06-29 | CNH | Futures | 7.0203 | 7.0203 | 7.0108 | 7.0108 | 2.0 |
| 2015-06-29 | CSC | Futures | 4.434 | 4.442 | 4.407 | 4.409 | 104.0 |
| 2015-06-29 | CT | Futures | 83.64 | 84.6 | 83.51 | 83.69 | 49.0 |
| 2015-06-29 | DC | Futures | 35.58 | 35.86 | 35.21 | 35.36 | 394.0 |
| 2015-06-29 | DX | Futures | 90.248 | 90.515 | 88.788 | 88.882 | 72735.0 |
| 2015-06-29 | E1 | Futures | 1.35564 | 1.3776 | 1.35056 | 1.3757 | 26575.0 |
| 2015-06-29 | E6 | Futures | 1.29238 | 1.32657 | 1.2878 | 1.32339 | 372837.0 |
| 2015-06-29 | E7 | Futures | 1.2857 | 1.319 | 1.2806 | 1.3161 | 9269.0 |
| 2015-06-29 | EBM | Futures | 320.12 | 331.19 | 318.48 | 325.45 | 25710.0 |
| 2015-06-29 | ED | Futures | 95.6222 | 95.6558 | 95.6222 | 95.6318 | 331235.0 |
| 2015-06-29 | ER | Futures | 98.073 | 98.077 | 98.038 | 98.077 | 144602.0 |
| 2015-06-29 | EW | Futures | 1586.5 | 1598.1 | 1566.2 | 1568.5 | 21968.0 |
| 2015-06-29 | FBTP | Futures | 94.45 | 96.95 | 93.29 | 96.07 | 135752.0 |
| 2015-06-29 | FBTS | Futures | 98.789 | 99.367 | 98.424 | 99.198 | 21473.0 |
| 2015-06-29 | FCE | Futures | 4087.0 | 4122.4 | 3968.7 | 4057.8 | 188125.0 |
| 2015-06-29 | FDAX | Futures | 12110.9 | 12484.5 | 11984.8 | 12268.9 | 159022.0 |
| 2015-06-29 | FDIV | Futures | 150.66 | 150.71 | 150.66 | 150.71 | 2.0 |
| 2015-06-29 | FESX | Futures | 2516.2 | 2610.2 | 2494.0 | 2565.1 | 1806406.0 |
| 2015-06-29 | FEU3 | Futures | 98.705 | 98.715 | 98.705 | 98.715 | 30.0 |
| 2015-06-29 | FGBL | Futures | 136.09 | 136.42 | 134.84 | 135.41 | 857975.0 |
| 2015-06-29 | FGBM | Futures | 123.98 | 124.29 | 123.75 | 123.89 | 541768.0 |
| 2015-06-29 | FGBS | Futures | 111.188 | 111.228 | 111.168 | 111.193 | 386213.0 |
| 2015-06-29 | FGBX | Futures | 155.16 | 155.26 | 149.17 | 150.51 | 35266.0 |
| 2015-06-29 | FMWO | Futures | 5786.7 | 5808.9 | 5785.5 | 5791.7 | 177.0 |
| 2015-06-29 | FOAT | Futures | 122.17 | 123.54 | 122.17 | 123.1 | 80721.0 |
| 2015-06-29 | FTDX | Futures | 1521.8 | 1575.0 | 1521.3 | 1556.1 | 320.0 |
| 2015-06-29 | FTI | Futures | 412.32 | 422.1 | 406.03 | 416.38 | 55895.0 |
| 2015-06-29 | FTUK | Futures | 5203.8 | 5278.2 | 5133.1 | 5228.1 | 141782.0 |
| 2015-06-29 | FVSA | Futures | 1939.85 | 2129.01 | 1911.68 | 2068.64 | 18867.0 |
| 2015-06-29 | FXXP | Futures | 287.5 | 299.9 | 287.5 | 295.6 | 21942.0 |
| 2015-06-29 | G | Futures | 101.23 | 101.45 | 100.55 | 101.02 | 155207.0 |
| 2015-06-29 | GF | Futures | 367.922 | 375.062 | 366.604 | 372.47 | 5690.0 |
| 2015-06-29 | GSCI | Futures | 723.65 | 723.65 | 718.73 | 720.07 | 17.0 |
| 2015-06-29 | HE | Futures | 82.095 | 82.231 | 80.273 | 80.763 | 9026.0 |
> showing 50 of 107 rows — these rows as CSV