PREVIEW / futures_daily / 2015-04-23
file: by_date/futures_daily/2015/2015-04-23.parquet size: 9 KB rows: 106
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-04-23 | ES | Futures | 2207.28 | 2223.32 | 2194.93 | 2215.43 | 1362552.0 |
| 2015-04-23 | NQ | Futures | 5153.24 | 5221.45 | 5129.44 | 5203.17 | 252582.0 |
| 2015-04-23 | YM | Futures | 18348.0 | 18474.9 | 18231.4 | 18392.0 | 170009.0 |
| 2015-04-23 | CL | Futures | 95.56 | 99.18 | 94.68 | 98.04 | 415569.0 |
| 2015-04-23 | GC | Futures | 1553.0 | 1566.8 | 1548.7 | 1562.7 | 118111.0 |
| 2015-04-23 | ZN | Futures | 122.027361 | 122.382565 | 121.93856 | 122.323364 | 1211509.0 |
| 2015-04-23 | A6 | Futures | 0.76226 | 0.76611 | 0.75832 | 0.76493 | 89485.0 |
| 2015-04-23 | AD | Futures | 0.83344 | 0.84181 | 0.8316 | 0.84048 | 62154.0 |
| 2015-04-23 | ALI | Futures | 2499.22 | 2499.22 | 2499.22 | 2499.22 | 0.0 |
| 2015-04-23 | B | Futures | 60.67 | 63.28 | 60.03 | 62.57 | 326736.0 |
| 2015-04-23 | B6 | Futures | 1.5824 | 1.5857 | 1.5741 | 1.584 | 76192.0 |
| 2015-04-23 | BFX | Futures | 4525.2 | 4542.3 | 4507.0 | 4542.3 | 25.0 |
| 2015-04-23 | BR | Futures | 0.18825 | 0.1897 | 0.18614 | 0.1897 | 96.0 |
| 2015-04-23 | BZ | Futures | 60.08 | 62.73 | 59.5 | 62.02 | 32671.0 |
| 2015-04-23 | C | Futures | 2075.0 | 2097.0 | 2069.0 | 2094.0 | 2306.0 |
| 2015-04-23 | CB | Futures | 154.87 | 155.761 | 154.547 | 154.951 | 19.0 |
| 2015-04-23 | CC | Futures | 2047.0 | 2071.0 | 2043.0 | 2067.0 | 10876.0 |
| 2015-04-23 | CNH | Futures | 6.9945 | 6.9978 | 6.9874 | 6.9874 | 14.0 |
| 2015-04-23 | CSC | Futures | 4.618 | 4.671 | 4.596 | 4.642 | 90.0 |
| 2015-04-23 | CT | Futures | 80.12 | 83.94 | 79.92 | 82.79 | 1801.0 |
| 2015-04-23 | DC | Futures | 37.33 | 38.23 | 37.29 | 38.08 | 478.0 |
| 2015-04-23 | DX | Futures | 92.235 | 92.625 | 91.395 | 91.506 | 47034.0 |
| 2015-04-23 | E1 | Futures | 1.31596 | 1.33991 | 1.31353 | 1.33749 | 28855.0 |
| 2015-04-23 | E6 | Futures | 1.26189 | 1.27624 | 1.25495 | 1.27377 | 277903.0 |
| 2015-04-23 | E7 | Futures | 1.2546 | 1.2689 | 1.2479 | 1.2664 | 6650.0 |
| 2015-04-23 | EBM | Futures | 293.65 | 297.27 | 292.85 | 296.86 | 13806.0 |
| 2015-04-23 | ED | Futures | 95.5429 | 95.5477 | 95.5381 | 95.5477 | 80394.0 |
| 2015-04-23 | ER | Futures | 98.068 | 98.077 | 98.068 | 98.073 | 53348.0 |
| 2015-04-23 | EW | Futures | 1604.2 | 1616.1 | 1595.2 | 1611.9 | 14506.0 |
| 2015-04-23 | FBTP | Futures | 102.77 | 103.09 | 102.58 | 102.72 | 87964.0 |
| 2015-04-23 | FBTS | Futures | 99.661 | 99.706 | 99.652 | 99.67 | 17307.0 |
| 2015-04-23 | FCE | Futures | 4253.3 | 4259.0 | 4189.1 | 4215.5 | 108311.0 |
| 2015-04-23 | FDAX | Futures | 13254.7 | 13290.2 | 12984.0 | 13035.1 | 133918.0 |
| 2015-04-23 | FDIV | Futures | 161.02 | 161.26 | 161.02 | 161.26 | 2.0 |
| 2015-04-23 | FESX | Futures | 2705.7 | 2711.6 | 2657.1 | 2677.0 | 1229447.0 |
| 2015-04-23 | FGBL | Futures | 141.47 | 141.77 | 141.28 | 141.41 | 613270.0 |
| 2015-04-23 | FGBM | Futures | 124.81 | 124.9 | 124.76 | 124.83 | 454902.0 |
| 2015-04-23 | FGBS | Futures | 111.278 | 111.298 | 111.268 | 111.298 | 257579.0 |
| 2015-04-23 | FGBX | Futures | 178.77 | 179.59 | 177.68 | 178.14 | 25714.0 |
| 2015-04-23 | FMWO | Futures | 5868.0 | 5900.1 | 5868.0 | 5900.1 | 136.0 |
| 2015-04-23 | FOAT | Futures | 130.38 | 130.75 | 130.28 | 130.37 | 69006.0 |
| 2015-04-23 | FTDX | Futures | 1570.6 | 1573.4 | 1547.6 | 1552.8 | 209.0 |
| 2015-04-23 | FTI | Futures | 436.63 | 437.76 | 431.01 | 434.48 | 33329.0 |
| 2015-04-23 | FTUK | Futures | 5514.2 | 5554.4 | 5484.6 | 5524.8 | 88028.0 |
| 2015-04-23 | FVSA | Futures | 1725.24 | 1788.55 | 1725.24 | 1760.85 | 15965.0 |
| 2015-04-23 | FXXP | Futures | 310.7 | 312.1 | 307.6 | 308.9 | 13117.0 |
| 2015-04-23 | G | Futures | 103.92 | 104.27 | 103.82 | 104.1 | 159098.0 |
| 2015-04-23 | GF | Futures | 356.504 | 363.034 | 355.816 | 363.034 | 3078.0 |
| 2015-04-23 | GSCI | Futures | 732.29 | 745.57 | 732.29 | 740.38 | 199.0 |
| 2015-04-23 | HE | Futures | 81.978 | 83.338 | 81.978 | 83.193 | 501.0 |
> showing 50 of 106 rows — these rows as CSV