PREVIEW / futures_daily / 2015-02-12
file: by_date/futures_daily/2015/2015-02-12.parquet size: 9 KB rows: 105
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-12 | ES | Futures | 2171.2 | 2185.87 | 2157.57 | 2184.3 | 1433910.0 |
| 2015-02-12 | NQ | Futures | 4999.12 | 5043.21 | 4972.72 | 5041.18 | 219353.0 |
| 2015-02-12 | YM | Futures | 18220.5 | 18277.6 | 18106.5 | 18263.3 | 117444.0 |
| 2015-02-12 | CL | Futures | 93.11 | 97.18 | 92.65 | 96.51 | 270197.0 |
| 2015-02-12 | GC | Futures | 1592.9 | 1611.9 | 1592.5 | 1596.1 | 109412.0 |
| 2015-02-12 | ZN | Futures | 120.747486 | 121.159694 | 120.467773 | 120.997755 | 1486245.0 |
| 2015-02-12 | A6 | Futures | 0.75506 | 0.76094 | 0.74742 | 0.7582 | 124715.0 |
| 2015-02-12 | AD | Futures | 0.80689 | 0.8184 | 0.80506 | 0.81565 | 76163.0 |
| 2015-02-12 | ALI | Futures | 2827.5 | 2827.5 | 2827.5 | 2827.5 | 0.0 |
| 2015-02-12 | B | Futures | 55.77 | 59.31 | 55.51 | 58.69 | 371561.0 |
| 2015-02-12 | B6 | Futures | 1.6018 | 1.6205 | 1.5989 | 1.6198 | 130967.0 |
| 2015-02-12 | BR | Futures | 0.18957 | 0.195 | 0.18957 | 0.19451 | 7021.0 |
| 2015-02-12 | BZ | Futures | 55.67 | 59.18 | 55.38 | 58.54 | 45458.0 |
| 2015-02-12 | C | Futures | 2190.0 | 2201.0 | 2190.0 | 2201.0 | 8164.0 |
| 2015-02-12 | CB | Futures | 143.764 | 143.99 | 143.764 | 143.99 | 6.0 |
| 2015-02-12 | CC | Futures | 2128.0 | 2157.0 | 2126.0 | 2155.0 | 24700.0 |
| 2015-02-12 | CNH | Futures | 7.1285 | 7.1285 | 7.1128 | 7.1128 | 31.0 |
| 2015-02-12 | CSC | Futures | 4.347 | 4.472 | 4.339 | 4.472 | 91.0 |
| 2015-02-12 | CT | Futures | 79.44 | 79.9 | 78.59 | 79.8 | 16459.0 |
| 2015-02-12 | DC | Futures | 35.46 | 36.65 | 35.32 | 36.4 | 380.0 |
| 2015-02-12 | DX | Futures | 89.939 | 90.019 | 89.049 | 89.165 | 41115.0 |
| 2015-02-12 | E1 | Futures | 1.37652 | 1.38124 | 1.36911 | 1.37282 | 12055.0 |
| 2015-02-12 | E6 | Futures | 1.33328 | 1.3441 | 1.32999 | 1.34305 | 136911.0 |
| 2015-02-12 | E7 | Futures | 1.3256 | 1.3361 | 1.3221 | 1.335 | 4476.0 |
| 2015-02-12 | EBM | Futures | 300.49 | 302.11 | 299.27 | 299.27 | 16089.0 |
| 2015-02-12 | ED | Futures | 95.445 | 95.4498 | 95.445 | 95.445 | 106653.0 |
| 2015-02-12 | ER | Futures | 98.038 | 98.043 | 98.028 | 98.038 | 42983.0 |
| 2015-02-12 | EW | Futures | 1552.1 | 1562.1 | 1542.4 | 1559.1 | 17121.0 |
| 2015-02-12 | FBTP | Futures | 100.29 | 100.94 | 100.12 | 100.63 | 127261.0 |
| 2015-02-12 | FBTS | Futures | 99.129 | 99.227 | 99.094 | 99.191 | 21754.0 |
| 2015-02-12 | FCE | Futures | 3815.5 | 3863.4 | 3793.9 | 3843.1 | 5353.0 |
| 2015-02-12 | FDAX | Futures | 11976.2 | 12188.2 | 11914.6 | 12114.4 | 113560.0 |
| 2015-02-12 | FESX | Futures | 2441.8 | 2479.3 | 2423.8 | 2461.3 | 1078704.0 |
| 2015-02-12 | FGBL | Futures | 139.02 | 139.42 | 138.73 | 139.3 | 748388.0 |
| 2015-02-12 | FGBM | Futures | 124.53 | 124.65 | 124.45 | 124.6 | 412591.0 |
| 2015-02-12 | FGBS | Futures | 111.223 | 111.233 | 111.203 | 111.218 | 218083.0 |
| 2015-02-12 | FGBX | Futures | 168.66 | 170.09 | 168.1 | 169.73 | 26973.0 |
| 2015-02-12 | FMWO | Futures | 5689.2 | 5718.8 | 5689.2 | 5718.8 | 1287.0 |
| 2015-02-12 | FOAT | Futures | 127.18 | 127.61 | 127.15 | 127.56 | 62027.0 |
| 2015-02-12 | FTDX | Futures | 1416.7 | 1437.3 | 1416.7 | 1434.5 | 186.0 |
| 2015-02-12 | FTI | Futures | 395.95 | 400.05 | 395.95 | 397.59 | 964.0 |
| 2015-02-12 | FTUK | Futures | 5276.9 | 5311.2 | 5275.0 | 5284.7 | 93614.0 |
| 2015-02-12 | FVSA | Futures | 2130.64 | 2144.06 | 2072.45 | 2094.83 | 2768.0 |
| 2015-02-12 | FXXP | Futures | 280.1 | 283.9 | 279.9 | 282.5 | 9022.0 |
| 2015-02-12 | G | Futures | 104.1 | 104.16 | 103.24 | 103.99 | 246539.0 |
| 2015-02-12 | GF | Futures | 335.074 | 338.912 | 332.206 | 337.9 | 5543.0 |
| 2015-02-12 | GSCI | Futures | 704.46 | 720.01 | 701.02 | 717.0 | 1057.0 |
| 2015-02-12 | HE | Futures | 85.86 | 87.604 | 85.491 | 86.531 | 16847.0 |
| 2015-02-12 | HG | Futures | 3.2278 | 3.3307 | 3.2215 | 3.3053 | 67146.0 |
| 2015-02-12 | HH | Futures | 35.928 | 35.928 | 33.688 | 33.951 | 3840.0 |
> showing 50 of 105 rows — these rows as CSV