PREVIEW / futures_daily / 2018-11-13
file: by_date/futures_daily/2018/2018-11-13.parquet size: 10 KB rows: 116
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 |
|---|---|---|---|---|---|---|---|
| 2018-11-13 | ES | Futures | 2962.88 | 2988.64 | 2943.91 | 2958.0 | 2101869.0 |
| 2018-11-13 | NQ | Futures | 7952.97 | 8086.54 | 7899.83 | 7959.94 | 711516.0 |
| 2018-11-13 | YM | Futures | 26752.6 | 26922.1 | 26516.7 | 26673.6 | 276955.0 |
| 2018-11-13 | CL | Futures | 62.46 | 62.96 | 58.09 | 59.08 | 422819.0 |
| 2018-11-13 | GC | Futures | 1522.3 | 1527.9 | 1516.6 | 1522.7 | 248928.0 |
| 2018-11-13 | ZN | Futures | 117.954329 | 118.109962 | 117.767569 | 118.047709 | 1878432.0 |
| 2018-11-13 | A6 | Futures | 0.73837 | 0.74362 | 0.73745 | 0.74146 | 109130.0 |
| 2018-11-13 | AD | Futures | 0.76389 | 0.76561 | 0.76278 | 0.76339 | 70125.0 |
| 2018-11-13 | B | Futures | 51.1 | 51.5 | 47.75 | 48.39 | 445041.0 |
| 2018-11-13 | B6 | Futures | 1.3238 | 1.3439 | 1.3235 | 1.3342 | 210888.0 |
| 2018-11-13 | BR | Futures | 0.20281 | 0.20281 | 0.19862 | 0.1995 | 4085.0 |
| 2018-11-13 | BTC | Futures | 9141.3 | 9155.8 | 9011.0 | 9097.9 | 2534.0 |
| 2018-11-13 | BZ | Futures | 50.75 | 51.14 | 47.45 | 48.06 | 56981.0 |
| 2018-11-13 | C | Futures | 1498.0 | 1498.0 | 1470.0 | 1475.0 | 4535.0 |
| 2018-11-13 | CB | Futures | 266.16 | 266.16 | 265.319 | 265.739 | 17.0 |
| 2018-11-13 | CC | Futures | 1552.0 | 1561.0 | 1524.0 | 1554.0 | 29555.0 |
| 2018-11-13 | CNH | Futures | 7.0159 | 7.0184 | 6.9892 | 6.9899 | 1620.0 |
| 2018-11-13 | CSC | Futures | 2.972 | 2.982 | 2.922 | 2.97 | 103.0 |
| 2018-11-13 | CT | Futures | 85.73 | 86.23 | 84.88 | 85.15 | 21318.0 |
| 2018-11-13 | DC | Futures | 24.53 | 24.81 | 24.28 | 24.71 | 467.0 |
| 2018-11-13 | DX | Futures | 92.557 | 92.628 | 92.063 | 92.285 | 24029.0 |
| 2018-11-13 | E1 | Futures | 1.17612 | 1.18051 | 1.17363 | 1.17873 | 26339.0 |
| 2018-11-13 | E6 | Futures | 1.25082 | 1.25899 | 1.25082 | 1.25615 | 236407.0 |
| 2018-11-13 | E7 | Futures | 1.2447 | 1.2527 | 1.2447 | 1.25 | 4583.0 |
| 2018-11-13 | EBM | Futures | 209.76 | 210.27 | 208.98 | 209.76 | 19538.0 |
| 2018-11-13 | ED | Futures | 94.9792 | 94.989 | 94.9694 | 94.9841 | 285195.0 |
| 2018-11-13 | ER | Futures | 98.381 | 98.386 | 98.381 | 98.386 | 40119.0 |
| 2018-11-13 | EW | Futures | 1952.4 | 1973.9 | 1943.1 | 1948.7 | 15291.0 |
| 2018-11-13 | FBON | Futures | 127.29 | 127.39 | 127.2 | 127.32 | 247.0 |
| 2018-11-13 | FBTP | Futures | 104.77 | 104.87 | 104.16 | 104.79 | 70527.0 |
| 2018-11-13 | FBTS | Futures | 102.668 | 102.696 | 102.405 | 102.574 | 82245.0 |
| 2018-11-13 | FCE | Futures | 4520.1 | 4557.3 | 4509.0 | 4552.4 | 129743.0 |
| 2018-11-13 | FDAX | Futures | 11920.2 | 12084.2 | 11902.8 | 12076.3 | 114796.0 |
| 2018-11-13 | FDIV | Futures | 139.17 | 140.2 | 139.17 | 140.2 | 1.0 |
| 2018-11-13 | FDXM | Futures | 11710.6 | 11874.9 | 11696.2 | 11867.2 | 57089.0 |
| 2018-11-13 | FESX | Futures | 2682.3 | 2705.8 | 2676.4 | 2704.1 | 1126299.0 |
| 2018-11-13 | FGBL | Futures | 153.31 | 153.53 | 153.1 | 153.2 | 777657.0 |
| 2018-11-13 | FGBM | Futures | 131.18 | 131.25 | 131.08 | 131.13 | 386569.0 |
| 2018-11-13 | FGBS | Futures | 112.693 | 112.708 | 112.673 | 112.688 | 251819.0 |
| 2018-11-13 | FGBX | Futures | 177.53 | 178.08 | 177.13 | 177.35 | 57963.0 |
| 2018-11-13 | FMWO | Futures | 6775.9 | 6804.9 | 6730.7 | 6793.3 | 2803.0 |
| 2018-11-13 | FOAT | Futures | 140.34 | 140.47 | 140.19 | 140.3 | 110498.0 |
| 2018-11-13 | FTDX | Futures | 2534.2 | 2560.7 | 2517.0 | 2560.2 | 372.0 |
| 2018-11-13 | FTI | Futures | 487.01 | 490.68 | 485.9 | 490.17 | 37237.0 |
| 2018-11-13 | FTUK | Futures | 6272.8 | 6330.0 | 6251.4 | 6288.0 | 110589.0 |
| 2018-11-13 | FVSA | Futures | 340.7 | 346.75 | 332.64 | 335.66 | 17347.0 |
| 2018-11-13 | FXXP | Futures | 313.8 | 315.8 | 312.8 | 315.6 | 53602.0 |
| 2018-11-13 | G | Futures | 114.88 | 115.01 | 114.36 | 114.48 | 335353.0 |
| 2018-11-13 | GF | Futures | 309.167 | 316.755 | 307.122 | 316.379 | 9970.0 |
| 2018-11-13 | GSCI | Futures | 485.75 | 487.44 | 477.46 | 479.49 | 3026.0 |
> showing 50 of 116 rows — these rows as CSV