PREVIEW / futures_daily / 2018-08-08
file: by_date/futures_daily/2018/2018-08-08.parquet size: 10 KB rows: 113
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-08-08 | ES | Futures | 3106.78 | 3108.95 | 3098.09 | 3101.08 | 745412.0 |
| 2018-08-08 | NQ | Futures | 8718.91 | 8739.6 | 8677.23 | 8711.04 | 250480.0 |
| 2018-08-08 | YM | Futures | 26995.6 | 27008.2 | 26870.2 | 26907.1 | 97164.0 |
| 2018-08-08 | CL | Futures | 71.48 | 71.77 | 68.62 | 69.26 | 760313.0 |
| 2018-08-08 | GC | Futures | 1544.6 | 1551.1 | 1538.1 | 1547.5 | 263236.0 |
| 2018-08-08 | ZN | Futures | 118.810822 | 118.935134 | 118.733128 | 118.8419 | 987422.0 |
| 2018-08-08 | A6 | Futures | 0.76316 | 0.76532 | 0.75946 | 0.76511 | 91893.0 |
| 2018-08-08 | AD | Futures | 0.77604 | 0.77923 | 0.77244 | 0.77882 | 90565.0 |
| 2018-08-08 | B | Futures | 54.41 | 54.58 | 52.23 | 52.69 | 269509.0 |
| 2018-08-08 | B6 | Futures | 1.3368 | 1.3392 | 1.328 | 1.3323 | 107107.0 |
| 2018-08-08 | BR | Futures | 0.20292 | 0.20327 | 0.2014 | 0.20178 | 1993.0 |
| 2018-08-08 | BTC | Futures | 9637.4 | 9665.9 | 8697.2 | 9017.7 | 8099.0 |
| 2018-08-08 | BZ | Futures | 54.25 | 54.5 | 52.17 | 52.62 | 23735.0 |
| 2018-08-08 | C | Futures | 1474.0 | 1502.0 | 1463.0 | 1481.0 | 5429.0 |
| 2018-08-08 | CB | Futures | 279.359 | 279.359 | 278.819 | 279.149 | 9.0 |
| 2018-08-08 | CC | Futures | 1490.0 | 1527.0 | 1483.0 | 1502.0 | 30383.0 |
| 2018-08-08 | CNH | Futures | 6.8905 | 6.9217 | 6.8835 | 6.8963 | 403.0 |
| 2018-08-08 | CSC | Futures | 3.208 | 3.246 | 3.208 | 3.238 | 61.0 |
| 2018-08-08 | CT | Futures | 98.83 | 98.83 | 98.06 | 98.06 | 11.0 |
| 2018-08-08 | DC | Futures | 26.05 | 26.25 | 25.86 | 26.16 | 301.0 |
| 2018-08-08 | DX | Futures | 89.965 | 90.211 | 89.804 | 89.87 | 16853.0 |
| 2018-08-08 | E1 | Futures | 1.20373 | 1.20755 | 1.20241 | 1.20743 | 21476.0 |
| 2018-08-08 | E6 | Futures | 1.30066 | 1.30424 | 1.29798 | 1.30312 | 211417.0 |
| 2018-08-08 | E7 | Futures | 1.294 | 1.2975 | 1.2914 | 1.2965 | 2475.0 |
| 2018-08-08 | EBM | Futures | 227.8 | 228.59 | 223.88 | 224.4 | 14516.0 |
| 2018-08-08 | ED | Futures | 95.0302 | 95.0448 | 95.0253 | 95.0351 | 198910.0 |
| 2018-08-08 | ER | Futures | 98.362 | 98.362 | 98.357 | 98.362 | 23529.0 |
| 2018-08-08 | EW | Futures | 2136.7 | 2137.3 | 2121.1 | 2129.3 | 7576.0 |
| 2018-08-08 | FBON | Futures | 129.65 | 129.65 | 129.02 | 129.07 | 133.0 |
| 2018-08-08 | FBTP | Futures | 106.5 | 106.89 | 105.93 | 106.44 | 59569.0 |
| 2018-08-08 | FBTS | Futures | 102.346 | 102.522 | 102.151 | 102.336 | 39297.0 |
| 2018-08-08 | FCE | Futures | 4947.3 | 4960.3 | 4925.8 | 4934.3 | 46089.0 |
| 2018-08-08 | FDAX | Futures | 13222.4 | 13276.3 | 13148.2 | 13193.7 | 77703.0 |
| 2018-08-08 | FDXM | Futures | 13046.3 | 13106.1 | 12980.2 | 13025.1 | 32387.0 |
| 2018-08-08 | FESX | Futures | 2922.4 | 2929.9 | 2909.0 | 2914.9 | 660760.0 |
| 2018-08-08 | FEU3 | Futures | 99.011 | 99.011 | 99.011 | 99.011 | 15.0 |
| 2018-08-08 | FGBL | Futures | 152.69 | 152.9 | 152.61 | 152.75 | 347532.0 |
| 2018-08-08 | FGBM | Futures | 130.88 | 131.0 | 130.85 | 130.94 | 214876.0 |
| 2018-08-08 | FGBS | Futures | 112.608 | 112.643 | 112.603 | 112.623 | 180896.0 |
| 2018-08-08 | FGBX | Futures | 176.75 | 177.16 | 176.57 | 176.65 | 27975.0 |
| 2018-08-08 | FMWO | Futures | 7212.7 | 7217.3 | 7199.9 | 7215.0 | 339.0 |
| 2018-08-08 | FOAT | Futures | 140.45 | 140.53 | 140.36 | 140.42 | 53353.0 |
| 2018-08-08 | FTDX | Futures | 2880.4 | 2882.3 | 2857.8 | 2864.2 | 108.0 |
| 2018-08-08 | FTI | Futures | 528.87 | 530.31 | 527.49 | 529.01 | 19750.0 |
| 2018-08-08 | FTUK | Futures | 6815.2 | 6888.2 | 6813.4 | 6872.7 | 90031.0 |
| 2018-08-08 | FVSA | Futures | 256.05 | 257.0 | 249.36 | 256.05 | 21017.0 |
| 2018-08-08 | FXXP | Futures | 336.1 | 337.1 | 335.4 | 336.1 | 27433.0 |
| 2018-08-08 | G | Futures | 115.3 | 115.33 | 115.07 | 115.25 | 200159.0 |
| 2018-08-08 | GF | Futures | 310.062 | 312.807 | 308.457 | 312.082 | 2242.0 |
| 2018-08-08 | GSCI | Futures | 521.16 | 521.16 | 516.09 | 516.09 | 3001.0 |
> showing 50 of 113 rows — these rows as CSV