PREVIEW / futures_daily / 2014-10-13
file: by_date/futures_daily/2014/2014-10-13.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2014-10-13 | ES | Futures | 1976.36 | 1990.98 | 1946.85 | 1948.67 | 2948075.0 |
| 2014-10-13 | NQ | Futures | 4460.32 | 4503.49 | 4395.42 | 4402.37 | 636045.0 |
| 2014-10-13 | YM | Futures | 16658.5 | 16766.0 | 16451.5 | 16467.8 | 306767.0 |
| 2014-10-13 | CL | Futures | 160.49 | 161.75 | 158.36 | 161.51 | 292345.0 |
| 2014-10-13 | GC | Futures | 1606.5 | 1623.8 | 1604.9 | 1613.3 | 119916.0 |
| 2014-10-13 | ZN | Futures | 118.802969 | 119.38871 | 118.744395 | 119.169057 | 516671.0 |
| 2014-10-13 | A6 | Futures | 0.83992 | 0.85013 | 0.83701 | 0.84711 | 98725.0 |
| 2014-10-13 | AD | Futures | 0.90514 | 0.90696 | 0.90382 | 0.90503 | 37459.0 |
| 2014-10-13 | ALI | Futures | 2938.77 | 2938.77 | 2938.77 | 2938.77 | 5.0 |
| 2014-10-13 | B | Futures | 93.83 | 94.01 | 90.41 | 92.81 | 279798.0 |
| 2014-10-13 | B6 | Futures | 1.6882 | 1.6942 | 1.6861 | 1.6871 | 69972.0 |
| 2014-10-13 | BFX | Futures | 3674.7 | 3674.7 | 3658.3 | 3658.3 | 187.0 |
| 2014-10-13 | BR | Futures | 0.22273 | 0.22354 | 0.22214 | 0.22352 | 2188.0 |
| 2014-10-13 | BZ | Futures | 94.13 | 94.13 | 92.47 | 93.49 | 16443.0 |
| 2014-10-13 | C | Futures | 2183.0 | 2222.0 | 2122.0 | 2128.0 | 7596.0 |
| 2014-10-13 | CB | Futures | 148.374 | 149.53 | 142.593 | 142.593 | 22.0 |
| 2014-10-13 | CC | Futures | 2355.0 | 2368.0 | 2255.0 | 2258.0 | 15760.0 |
| 2014-10-13 | CSC | Futures | 5.161 | 5.161 | 5.093 | 5.093 | 17.0 |
| 2014-10-13 | CT | Futures | 81.41 | 82.88 | 81.27 | 82.39 | 7896.0 |
| 2014-10-13 | DC | Futures | 41.68 | 41.68 | 41.09 | 41.09 | 119.0 |
| 2014-10-13 | DX | Futures | 81.542 | 81.576 | 80.883 | 81.378 | 21542.0 |
| 2014-10-13 | E1 | Futures | 1.33722 | 1.35077 | 1.33671 | 1.34144 | 26800.0 |
| 2014-10-13 | E6 | Futures | 1.48716 | 1.50281 | 1.48692 | 1.49151 | 169902.0 |
| 2014-10-13 | E7 | Futures | 1.4779 | 1.4934 | 1.4776 | 1.4821 | 2977.0 |
| 2014-10-13 | ED | Futures | 95.447 | 95.4517 | 95.4422 | 95.4422 | 52104.0 |
| 2014-10-13 | ER | Futures | 97.994 | 97.999 | 97.974 | 97.989 | 86571.0 |
| 2014-10-13 | EW | Futures | 1349.7 | 1361.4 | 1334.0 | 1335.8 | 35075.0 |
| 2014-10-13 | FBTP | Futures | 95.34 | 95.53 | 95.24 | 95.42 | 47990.0 |
| 2014-10-13 | FBTS | Futures | 98.597 | 98.597 | 98.544 | 98.579 | 12783.0 |
| 2014-10-13 | FCE | Futures | 3243.2 | 3308.5 | 3239.2 | 3289.6 | 82153.0 |
| 2014-10-13 | FDAX | Futures | 9530.4 | 9721.6 | 9510.7 | 9649.3 | 151356.0 |
| 2014-10-13 | FESX | Futures | 2136.9 | 2178.9 | 2124.6 | 2163.7 | 1458004.0 |
| 2014-10-13 | FEU3 | Futures | 98.606 | 98.616 | 98.606 | 98.616 | 15.0 |
| 2014-10-13 | FGBL | Futures | 132.81 | 132.81 | 132.34 | 132.47 | 474934.0 |
| 2014-10-13 | FGBM | Futures | 123.08 | 123.1 | 122.89 | 122.94 | 268123.0 |
| 2014-10-13 | FGBS | Futures | 110.923 | 110.928 | 110.883 | 110.898 | 278409.0 |
| 2014-10-13 | FGBX | Futures | 144.12 | 144.36 | 143.09 | 143.37 | 12150.0 |
| 2014-10-13 | FMWO | Futures | 5371.5 | 5411.6 | 5371.5 | 5384.0 | 1148.0 |
| 2014-10-13 | FOAT | Futures | 122.16 | 122.26 | 121.8 | 121.88 | 49313.0 |
| 2014-10-13 | FTDX | Futures | 1076.4 | 1094.9 | 1072.7 | 1080.7 | 307.0 |
| 2014-10-13 | FTI | Futures | 341.79 | 345.51 | 340.82 | 343.97 | 4714.0 |
| 2014-10-13 | FTUK | Futures | 4836.7 | 4918.7 | 4824.7 | 4899.7 | 133250.0 |
| 2014-10-13 | FVSA | Futures | 1737.49 | 1791.65 | 1724.99 | 1774.99 | 18523.0 |
| 2014-10-13 | FXXP | Futures | 240.5 | 244.7 | 240.3 | 243.1 | 8178.0 |
| 2014-10-13 | G | Futures | 98.86 | 99.34 | 98.85 | 99.28 | 137464.0 |
| 2014-10-13 | GF | Futures | 374.89 | 377.043 | 374.108 | 375.908 | 3420.0 |
| 2014-10-13 | GSCI | Futures | 932.36 | 942.64 | 931.85 | 940.43 | 1319.0 |
| 2014-10-13 | HE | Futures | 127.053 | 128.366 | 126.851 | 127.356 | 8242.0 |
| 2014-10-13 | HG | Futures | 3.8458 | 3.8744 | 3.8319 | 3.8566 | 46789.0 |
| 2014-10-13 | HH | Futures | 46.508 | 47.403 | 46.508 | 47.342 | 1785.0 |
> showing 50 of 103 rows — these rows as CSV