PREVIEW / futures_daily / 2015-11-18
file: by_date/futures_daily/2015/2015-11-18.parquet size: 9 KB rows: 108
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-11-18 | ES | Futures | 2180.43 | 2215.26 | 2173.24 | 2212.34 | 1543330.0 |
| 2015-11-18 | NQ | Futures | 5343.58 | 5444.71 | 5327.21 | 5439.74 | 242823.0 |
| 2015-11-18 | YM | Futures | 18022.1 | 18276.9 | 17965.3 | 18251.1 | 153348.0 |
| 2015-11-18 | CL | Futures | 65.15 | 65.87 | 63.76 | 64.79 | 372472.0 |
| 2015-11-18 | GC | Futures | 1381.5 | 1387.2 | 1370.9 | 1379.6 | 154641.0 |
| 2015-11-18 | ZN | Futures | 121.356608 | 121.446413 | 121.10216 | 121.326673 | 901423.0 |
| 2015-11-18 | A6 | Futures | 0.71013 | 0.71083 | 0.70563 | 0.70883 | 80941.0 |
| 2015-11-18 | AD | Futures | 0.76882 | 0.77004 | 0.76585 | 0.76789 | 55130.0 |
| 2015-11-18 | ALI | Futures | 2112.01 | 2112.01 | 2112.01 | 2112.01 | 4.0 |
| 2015-11-18 | B | Futures | 38.79 | 39.47 | 38.23 | 38.94 | 255682.0 |
| 2015-11-18 | B6 | Futures | 1.602 | 1.6057 | 1.5992 | 1.6036 | 53946.0 |
| 2015-11-18 | BFX | Futures | 4471.4 | 4473.8 | 4460.4 | 4467.1 | 68.0 |
| 2015-11-18 | BR | Futures | 0.161 | 0.1626 | 0.16081 | 0.16201 | 1874.0 |
| 2015-11-18 | BZ | Futures | 38.54 | 39.2 | 38.0 | 38.69 | 28751.0 |
| 2015-11-18 | C | Futures | 2457.0 | 2466.0 | 2440.0 | 2442.0 | 3677.0 |
| 2015-11-18 | CB | Futures | 236.187 | 237.122 | 236.187 | 237.122 | 24.0 |
| 2015-11-18 | CC | Futures | 2492.0 | 2497.0 | 2459.0 | 2463.0 | 16154.0 |
| 2015-11-18 | CNH | Futures | 7.1411 | 7.1474 | 7.1344 | 7.1462 | 192.0 |
| 2015-11-18 | CSC | Futures | 4.084 | 4.117 | 4.084 | 4.102 | 55.0 |
| 2015-11-18 | CT | Futures | 73.9 | 74.32 | 73.76 | 73.8 | 5663.0 |
| 2015-11-18 | DC | Futures | 32.64 | 33.06 | 32.59 | 32.95 | 416.0 |
| 2015-11-18 | DX | Futures | 93.297 | 93.493 | 92.965 | 93.288 | 32851.0 |
| 2015-11-18 | E1 | Futures | 1.25119 | 1.25347 | 1.24206 | 1.24447 | 28552.0 |
| 2015-11-18 | E6 | Futures | 1.24734 | 1.25297 | 1.24406 | 1.24758 | 196869.0 |
| 2015-11-18 | E7 | Futures | 1.241 | 1.2462 | 1.2372 | 1.2407 | 4014.0 |
| 2015-11-18 | EBM | Futures | 256.13 | 259.05 | 256.13 | 257.96 | 14202.0 |
| 2015-11-18 | ED | Futures | 95.6871 | 95.6895 | 95.6799 | 95.6871 | 132302.0 |
| 2015-11-18 | ER | Futures | 98.239 | 98.244 | 98.234 | 98.239 | 43542.0 |
| 2015-11-18 | EW | Futures | 1493.8 | 1521.4 | 1490.2 | 1520.6 | 20225.0 |
| 2015-11-18 | FBON | Futures | 114.95 | 115.29 | 114.91 | 115.24 | 749.0 |
| 2015-11-18 | FBTP | Futures | 104.93 | 105.25 | 104.84 | 105.2 | 84804.0 |
| 2015-11-18 | FBTS | Futures | 100.668 | 100.695 | 100.659 | 100.677 | 17671.0 |
| 2015-11-18 | FCE | Futures | 4097.9 | 4135.5 | 4074.9 | 4097.9 | 117875.0 |
| 2015-11-18 | FDAX | Futures | 12003.3 | 12168.5 | 11978.5 | 12075.4 | 90287.0 |
| 2015-11-18 | FDXM | Futures | 11215.1 | 11370.4 | 11192.4 | 11281.9 | 11349.0 |
| 2015-11-18 | FESX | Futures | 2568.4 | 2594.6 | 2558.7 | 2572.9 | 1000189.0 |
| 2015-11-18 | FGBL | Futures | 140.24 | 140.46 | 140.01 | 140.32 | 608228.0 |
| 2015-11-18 | FGBM | Futures | 126.0 | 126.04 | 125.93 | 125.97 | 398843.0 |
| 2015-11-18 | FGBS | Futures | 111.563 | 111.563 | 111.528 | 111.533 | 253362.0 |
| 2015-11-18 | FGBX | Futures | 157.9 | 159.04 | 157.31 | 158.51 | 24011.0 |
| 2015-11-18 | FMWO | Futures | 5637.2 | 5637.2 | 5603.9 | 5631.1 | 549.0 |
| 2015-11-18 | FOAT | Futures | 128.86 | 129.13 | 128.66 | 129.05 | 78911.0 |
| 2015-11-18 | FTDX | Futures | 1726.4 | 1730.1 | 1716.9 | 1726.4 | 50.0 |
| 2015-11-18 | FTI | Futures | 402.46 | 407.81 | 402.07 | 404.72 | 26042.0 |
| 2015-11-18 | FTUK | Futures | 5021.2 | 5072.6 | 5000.3 | 5046.1 | 89324.0 |
| 2015-11-18 | FVSA | Futures | 2153.27 | 2191.13 | 2091.75 | 2158.0 | 16394.0 |
| 2015-11-18 | FXXP | Futures | 294.3 | 296.3 | 293.5 | 295.6 | 13243.0 |
| 2015-11-18 | G | Futures | 103.93 | 104.15 | 103.8 | 103.99 | 204190.0 |
| 2015-11-18 | GF | Futures | 310.678 | 319.798 | 310.485 | 316.468 | 5431.0 |
| 2015-11-18 | GSCI | Futures | 537.05 | 537.29 | 533.72 | 533.88 | 134.0 |
> showing 50 of 108 rows — these rows as CSV