PREVIEW / futures_daily / 2015-02-18
file: by_date/futures_daily/2015/2015-02-18.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-02-18 | ES | Futures | 2197.4 | 2199.5 | 2189.02 | 2196.35 | 1088179.0 |
| 2015-02-18 | NQ | Futures | 5087.3 | 5097.74 | 5074.82 | 5089.04 | 146465.0 |
| 2015-02-18 | YM | Futures | 18341.7 | 18361.1 | 18284.7 | 18325.4 | 89556.0 |
| 2015-02-18 | CL | Futures | 100.01 | 100.32 | 94.37 | 97.73 | 280306.0 |
| 2015-02-18 | GC | Futures | 1581.2 | 1586.5 | 1565.3 | 1569.3 | 121125.0 |
| 2015-02-18 | ZN | Futures | 119.996679 | 120.835816 | 119.716966 | 120.61499 | 1627163.0 |
| 2015-02-18 | A6 | Futures | 0.76427 | 0.76682 | 0.76026 | 0.76457 | 85135.0 |
| 2015-02-18 | AD | Futures | 0.82166 | 0.82227 | 0.81667 | 0.81942 | 53540.0 |
| 2015-02-18 | ALI | Futures | 2671.01 | 2671.01 | 2671.01 | 2671.01 | 0.0 |
| 2015-02-18 | B | Futures | 61.68 | 61.84 | 58.66 | 59.92 | 224099.0 |
| 2015-02-18 | B6 | Futures | 1.6133 | 1.6276 | 1.6129 | 1.6227 | 98568.0 |
| 2015-02-18 | BFX | Futures | 4337.1 | 4340.2 | 4334.7 | 4340.2 | 140.0 |
| 2015-02-18 | BR | Futures | 0.19233 | 0.19456 | 0.19233 | 0.19357 | 1001.0 |
| 2015-02-18 | BZ | Futures | 61.42 | 61.65 | 58.52 | 59.77 | 24334.0 |
| 2015-02-18 | C | Futures | 2209.0 | 2216.0 | 2185.0 | 2215.0 | 4463.0 |
| 2015-02-18 | CB | Futures | 149.925 | 151.979 | 147.871 | 147.871 | 10.0 |
| 2015-02-18 | CC | Futures | 2175.0 | 2197.0 | 2155.0 | 2195.0 | 16682.0 |
| 2015-02-18 | CNH | Futures | 7.1515 | 7.1541 | 7.1474 | 7.148 | 36.0 |
| 2015-02-18 | CSC | Futures | 4.546 | 4.643 | 4.546 | 4.583 | 76.0 |
| 2015-02-18 | CT | Futures | 81.34 | 82.67 | 81.17 | 82.53 | 8891.0 |
| 2015-02-18 | DC | Futures | 37.52 | 38.05 | 37.17 | 37.63 | 392.0 |
| 2015-02-18 | DX | Futures | 89.162 | 89.569 | 89.02 | 89.221 | 24460.0 |
| 2015-02-18 | E1 | Futures | 1.36388 | 1.37218 | 1.35238 | 1.35468 | 11158.0 |
| 2015-02-18 | E6 | Futures | 1.34246 | 1.34316 | 1.33352 | 1.33905 | 225777.0 |
| 2015-02-18 | E7 | Futures | 1.3348 | 1.335 | 1.3256 | 1.3311 | 2794.0 |
| 2015-02-18 | EBM | Futures | 306.98 | 307.38 | 300.49 | 301.3 | 10599.0 |
| 2015-02-18 | ED | Futures | 95.4426 | 95.4522 | 95.4402 | 95.4474 | 191961.0 |
| 2015-02-18 | ER | Futures | 98.038 | 98.043 | 98.038 | 98.043 | 16956.0 |
| 2015-02-18 | EW | Futures | 1568.1 | 1575.2 | 1563.8 | 1574.1 | 15252.0 |
| 2015-02-18 | FBTP | Futures | 100.75 | 101.11 | 100.67 | 100.73 | 84345.0 |
| 2015-02-18 | FBTS | Futures | 99.262 | 99.297 | 99.227 | 99.244 | 21026.0 |
| 2015-02-18 | FCE | Futures | 3880.1 | 3911.8 | 3880.1 | 3902.9 | 159109.0 |
| 2015-02-18 | FDAX | Futures | 12107.2 | 12194.3 | 12098.9 | 12162.1 | 74091.0 |
| 2015-02-18 | FESX | Futures | 2489.4 | 2506.7 | 2488.7 | 2495.9 | 881340.0 |
| 2015-02-18 | FGBL | Futures | 138.82 | 138.97 | 138.54 | 138.8 | 712209.0 |
| 2015-02-18 | FGBM | Futures | 124.5 | 124.63 | 124.47 | 124.58 | 346598.0 |
| 2015-02-18 | FGBS | Futures | 111.183 | 111.218 | 111.178 | 111.208 | 169072.0 |
| 2015-02-18 | FGBX | Futures | 166.6 | 167.48 | 165.2 | 166.12 | 32483.0 |
| 2015-02-18 | FMWO | Futures | 5788.1 | 5802.9 | 5788.1 | 5793.0 | 270.0 |
| 2015-02-18 | FOAT | Futures | 127.24 | 127.44 | 127.09 | 127.27 | 57101.0 |
| 2015-02-18 | FTDX | Futures | 1433.1 | 1443.0 | 1433.1 | 1440.1 | 90.0 |
| 2015-02-18 | FTI | Futures | 401.52 | 404.49 | 401.52 | 403.5 | 28072.0 |
| 2015-02-18 | FTUK | Futures | 5354.1 | 5361.1 | 5326.0 | 5341.6 | 73862.0 |
| 2015-02-18 | FVSA | Futures | 2036.64 | 2081.4 | 2009.78 | 2063.49 | 10696.0 |
| 2015-02-18 | FXXP | Futures | 285.5 | 287.1 | 285.1 | 286.8 | 8177.0 |
| 2015-02-18 | G | Futures | 103.22 | 103.29 | 102.33 | 102.46 | 216856.0 |
| 2015-02-18 | GF | Futures | 339.587 | 343.34 | 339.207 | 342.623 | 3862.0 |
| 2015-02-18 | GSCI | Futures | 725.93 | 729.28 | 718.98 | 721.21 | 89.0 |
| 2015-02-18 | HE | Futures | 85.592 | 88.375 | 84.82 | 86.162 | 19955.0 |
| 2015-02-18 | HG | Futures | 3.2831 | 3.3459 | 3.2583 | 3.3161 | 22777.0 |
> showing 50 of 106 rows — these rows as CSV