PREVIEW / futures_daily / 2015-10-16
file: by_date/futures_daily/2015/2015-10-16.parquet size: 9 KB rows: 107
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-10-16 | ES | Futures | 2146.92 | 2155.69 | 2140.53 | 2154.63 | 1362298.0 |
| 2015-10-16 | NQ | Futures | 5155.92 | 5190.12 | 5139.84 | 5185.15 | 207248.0 |
| 2015-10-16 | YM | Futures | 17604.2 | 17670.2 | 17552.6 | 17658.9 | 108094.0 |
| 2015-10-16 | CL | Futures | 75.25 | 76.17 | 74.05 | 75.77 | 284312.0 |
| 2015-10-16 | GC | Futures | 1526.5 | 1529.4 | 1515.9 | 1527.2 | 108910.0 |
| 2015-10-16 | ZN | Futures | 123.69154 | 123.856183 | 123.51193 | 123.601735 | 776692.0 |
| 2015-10-16 | A6 | Futures | 0.73144 | 0.73174 | 0.72273 | 0.72583 | 66262.0 |
| 2015-10-16 | AD | Futures | 0.79627 | 0.79678 | 0.79125 | 0.79309 | 46122.0 |
| 2015-10-16 | ALI | Futures | 2148.07 | 2148.07 | 2148.07 | 2148.07 | 0.0 |
| 2015-10-16 | B | Futures | 44.95 | 45.38 | 44.14 | 45.17 | 225956.0 |
| 2015-10-16 | B6 | Futures | 1.6284 | 1.6305 | 1.6245 | 1.6274 | 53752.0 |
| 2015-10-16 | BFX | Futures | 4151.8 | 4172.5 | 4150.6 | 4157.9 | 12.0 |
| 2015-10-16 | BR | Futures | 0.15761 | 0.15894 | 0.15376 | 0.15829 | 442.0 |
| 2015-10-16 | BZ | Futures | 44.66 | 45.12 | 43.92 | 44.92 | 21575.0 |
| 2015-10-16 | C | Futures | 2233.0 | 2260.0 | 2230.0 | 2257.0 | 5723.0 |
| 2015-10-16 | CB | Futures | 186.982 | 186.982 | 186.982 | 186.982 | 1.0 |
| 2015-10-16 | CC | Futures | 2269.0 | 2293.0 | 2264.0 | 2287.0 | 11812.0 |
| 2015-10-16 | CNH | Futures | 7.094 | 7.0973 | 7.094 | 7.0948 | 12.0 |
| 2015-10-16 | CSC | Futures | 4.35 | 4.35 | 4.345 | 4.35 | 10.0 |
| 2015-10-16 | CT | Futures | 76.23 | 76.71 | 75.42 | 76.59 | 11029.0 |
| 2015-10-16 | DC | Futures | 34.79 | 34.86 | 34.66 | 34.81 | 106.0 |
| 2015-10-16 | DX | Futures | 88.466 | 88.667 | 88.303 | 88.464 | 20540.0 |
| 2015-10-16 | E1 | Futures | 1.33617 | 1.33808 | 1.33021 | 1.33605 | 13070.0 |
| 2015-10-16 | E6 | Futures | 1.33415 | 1.33602 | 1.32888 | 1.3338 | 145002.0 |
| 2015-10-16 | E7 | Futures | 1.3268 | 1.3286 | 1.3217 | 1.3264 | 3312.0 |
| 2015-10-16 | EBM | Futures | 260.15 | 260.51 | 256.86 | 257.59 | 15500.0 |
| 2015-10-16 | ED | Futures | 95.7592 | 95.7592 | 95.7496 | 95.7496 | 98681.0 |
| 2015-10-16 | ER | Futures | 98.156 | 98.166 | 98.151 | 98.161 | 46586.0 |
| 2015-10-16 | EW | Futures | 1509.7 | 1513.6 | 1499.6 | 1506.7 | 12677.0 |
| 2015-10-16 | FBTP | Futures | 103.25 | 103.66 | 103.19 | 103.58 | 74462.0 |
| 2015-10-16 | FBTS | Futures | 100.4 | 100.427 | 100.391 | 100.4 | 13238.0 |
| 2015-10-16 | FCE | Futures | 3924.5 | 3934.9 | 3900.3 | 3920.7 | 83378.0 |
| 2015-10-16 | FDAX | Futures | 11166.8 | 11196.5 | 11071.5 | 11122.2 | 92609.0 |
| 2015-10-16 | FESX | Futures | 2441.0 | 2450.0 | 2428.3 | 2441.0 | 923395.0 |
| 2015-10-16 | FEU3 | Futures | 98.808 | 98.808 | 98.803 | 98.808 | 27.0 |
| 2015-10-16 | FGBL | Futures | 139.44 | 139.8 | 139.43 | 139.62 | 403364.0 |
| 2015-10-16 | FGBM | Futures | 125.36 | 125.44 | 125.35 | 125.41 | 252613.0 |
| 2015-10-16 | FGBS | Futures | 111.303 | 111.333 | 111.303 | 111.328 | 115257.0 |
| 2015-10-16 | FGBX | Futures | 159.0 | 160.2 | 158.96 | 159.55 | 30201.0 |
| 2015-10-16 | FMWO | Futures | 5608.8 | 5613.8 | 5596.4 | 5608.8 | 226.0 |
| 2015-10-16 | FOAT | Futures | 127.68 | 128.05 | 127.67 | 127.89 | 58341.0 |
| 2015-10-16 | FTDX | Futures | 1654.7 | 1658.5 | 1648.1 | 1650.9 | 91.0 |
| 2015-10-16 | FTI | Futures | 387.86 | 390.12 | 386.72 | 388.82 | 31128.0 |
| 2015-10-16 | FTUK | Futures | 5121.7 | 5130.1 | 5087.1 | 5104.8 | 83197.0 |
| 2015-10-16 | FVSA | Futures | 2191.88 | 2214.85 | 2159.71 | 2182.69 | 8705.0 |
| 2015-10-16 | FXXP | Futures | 281.9 | 283.6 | 281.2 | 282.5 | 18978.0 |
| 2015-10-16 | G | Futures | 105.33 | 105.43 | 105.1 | 105.2 | 118286.0 |
| 2015-10-16 | GF | Futures | 334.991 | 343.935 | 333.275 | 343.574 | 5133.0 |
| 2015-10-16 | GSCI | Futures | 594.38 | 597.53 | 591.63 | 597.04 | 18.0 |
| 2015-10-16 | HE | Futures | 99.497 | 99.722 | 97.59 | 98.076 | 14344.0 |
> showing 50 of 107 rows — these rows as CSV