PREVIEW / futures_daily / 2015-11-25
file: by_date/futures_daily/2015/2015-11-25.parquet size: 9 KB rows: 110
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-25 | ES | Futures | 2216.86 | 2225.9 | 2215.0 | 2221.11 | 746319.0 |
| 2015-11-25 | NQ | Futures | 5454.36 | 5477.16 | 5447.93 | 5468.68 | 119712.0 |
| 2015-11-25 | YM | Futures | 18328.5 | 18399.7 | 18306.8 | 18367.7 | 67392.0 |
| 2015-11-25 | CL | Futures | 65.94 | 66.8 | 64.44 | 66.48 | 383158.0 |
| 2015-11-25 | GC | Futures | 1386.2 | 1392.7 | 1375.8 | 1379.6 | 100372.0 |
| 2015-11-25 | ZN | Futures | 121.581121 | 121.730796 | 121.476348 | 121.640991 | 1608815.0 |
| 2015-11-25 | A6 | Futures | 0.72543 | 0.72773 | 0.72213 | 0.72463 | 70242.0 |
| 2015-11-25 | AD | Futures | 0.76994 | 0.77117 | 0.76779 | 0.77035 | 42576.0 |
| 2015-11-25 | ALI | Futures | 2105.15 | 2105.15 | 2105.15 | 2105.15 | 4.0 |
| 2015-11-25 | B | Futures | 40.68 | 41.16 | 39.89 | 40.87 | 108227.0 |
| 2015-11-25 | B6 | Futures | 1.5882 | 1.5939 | 1.5855 | 1.5929 | 59660.0 |
| 2015-11-25 | BFX | Futures | 4483.5 | 4510.3 | 4483.5 | 4497.8 | 4.0 |
| 2015-11-25 | BR | Futures | 0.16085 | 0.16371 | 0.16085 | 0.16296 | 3739.0 |
| 2015-11-25 | BZ | Futures | 40.42 | 40.76 | 39.52 | 40.51 | 16061.0 |
| 2015-11-25 | C | Futures | 2430.0 | 2436.0 | 2391.0 | 2402.0 | 6945.0 |
| 2015-11-25 | CB | Futures | 240.279 | 240.279 | 237.867 | 238.702 | 13.0 |
| 2015-11-25 | CC | Futures | 2460.0 | 2466.0 | 2425.0 | 2436.0 | 18771.0 |
| 2015-11-25 | CNH | Futures | 7.1475 | 7.1492 | 7.1365 | 7.1452 | 204.0 |
| 2015-11-25 | CSC | Futures | 4.047 | 4.05 | 4.04 | 4.047 | 106.0 |
| 2015-11-25 | CT | Futures | 72.48 | 74.57 | 72.45 | 74.12 | 26526.0 |
| 2015-11-25 | DC | Futures | 32.33 | 32.33 | 32.18 | 32.27 | 92.0 |
| 2015-11-25 | DX | Futures | 93.161 | 93.741 | 92.932 | 93.367 | 30269.0 |
| 2015-11-25 | E1 | Futures | 1.24802 | 1.25119 | 1.23673 | 1.24218 | 25920.0 |
| 2015-11-25 | E6 | Futures | 1.24723 | 1.25262 | 1.23797 | 1.24395 | 248522.0 |
| 2015-11-25 | E7 | Futures | 1.2405 | 1.2457 | 1.2313 | 1.2371 | 4316.0 |
| 2015-11-25 | EBM | Futures | 257.59 | 260.15 | 256.86 | 259.78 | 23620.0 |
| 2015-11-25 | ED | Futures | 95.6583 | 95.6607 | 95.6511 | 95.6535 | 204702.0 |
| 2015-11-25 | ER | Futures | 98.249 | 98.283 | 98.244 | 98.274 | 130089.0 |
| 2015-11-25 | EW | Futures | 1536.7 | 1545.4 | 1534.7 | 1544.9 | 10530.0 |
| 2015-11-25 | FBON | Futures | 116.18 | 116.89 | 116.18 | 116.85 | 978.0 |
| 2015-11-25 | FBTP | Futures | 105.37 | 106.03 | 105.26 | 105.97 | 121071.0 |
| 2015-11-25 | FBTS | Futures | 100.749 | 100.892 | 100.74 | 100.856 | 31711.0 |
| 2015-11-25 | FCE | Futures | 4039.8 | 4104.6 | 4026.8 | 4088.3 | 90835.0 |
| 2015-11-25 | FDAX | Futures | 12090.3 | 12323.2 | 12026.9 | 12296.2 | 86862.0 |
| 2015-11-25 | FDXM | Futures | 11303.6 | 11511.4 | 11237.7 | 11487.7 | 13376.0 |
| 2015-11-25 | FESX | Futures | 2563.2 | 2603.6 | 2549.7 | 2593.1 | 974257.0 |
| 2015-11-25 | FEU3 | Futures | 98.922 | 98.922 | 98.922 | 98.922 | 20.0 |
| 2015-11-25 | FGBL | Futures | 140.3 | 140.9 | 140.18 | 140.83 | 674574.0 |
| 2015-11-25 | FGBM | Futures | 125.97 | 126.27 | 125.95 | 126.22 | 482286.0 |
| 2015-11-25 | FGBS | Futures | 111.533 | 111.633 | 111.528 | 111.598 | 556192.0 |
| 2015-11-25 | FGBX | Futures | 159.38 | 160.44 | 159.0 | 159.63 | 29666.0 |
| 2015-11-25 | FMWO | Futures | 5674.3 | 5691.6 | 5673.1 | 5690.4 | 45.0 |
| 2015-11-25 | FOAT | Futures | 128.85 | 129.4 | 128.74 | 129.36 | 76125.0 |
| 2015-11-25 | FTDX | Futures | 1710.2 | 1729.2 | 1708.3 | 1728.3 | 203.0 |
| 2015-11-25 | FTI | Futures | 402.51 | 407.98 | 400.68 | 406.81 | 29902.0 |
| 2015-11-25 | FTUK | Futures | 5056.2 | 5104.0 | 5055.8 | 5093.9 | 85768.0 |
| 2015-11-25 | FVSA | Futures | 2162.73 | 2186.39 | 2049.15 | 2077.55 | 8898.0 |
| 2015-11-25 | FXXP | Futures | 293.5 | 297.7 | 292.4 | 296.8 | 23554.0 |
| 2015-11-25 | G | Futures | 104.49 | 104.55 | 104.21 | 104.31 | 225201.0 |
| 2015-11-25 | GF | Futures | 317.964 | 320.377 | 317.385 | 318.447 | 2029.0 |
> showing 50 of 110 rows — these rows as CSV