PREVIEW / futures_daily / 2015-06-17
file: by_date/futures_daily/2015/2015-06-17.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-06-17 | ES | Futures | 2214.75 | 2224.29 | 2203.1 | 2214.22 | 1578971.0 |
| 2015-06-17 | NQ | Futures | 5198.09 | 5225.82 | 5173.57 | 5200.42 | 225073.0 |
| 2015-06-17 | YM | Futures | 18316.9 | 18398.1 | 18230.7 | 18307.7 | 134212.0 |
| 2015-06-17 | CL | Futures | 101.08 | 103.24 | 99.11 | 100.76 | 232091.0 |
| 2015-06-17 | GC | Futures | 1542.5 | 1552.6 | 1533.1 | 1536.9 | 101554.0 |
| 2015-06-17 | ZN | Futures | 120.168649 | 120.392205 | 119.393656 | 120.347494 | 1223332.0 |
| 2015-06-17 | A6 | Futures | 0.76387 | 0.76595 | 0.75337 | 0.76397 | 101104.0 |
| 2015-06-17 | AD | Futures | 0.83048 | 0.83549 | 0.82608 | 0.83498 | 68040.0 |
| 2015-06-17 | ALI | Futures | 2338.36 | 2338.36 | 2338.36 | 2338.36 | 0.0 |
| 2015-06-17 | B | Futures | 59.83 | 61.59 | 58.89 | 60.09 | 331877.0 |
| 2015-06-17 | B6 | Futures | 1.6462 | 1.667 | 1.6437 | 1.665 | 117442.0 |
| 2015-06-17 | BFX | Futures | 4353.2 | 4356.8 | 4303.6 | 4315.1 | 62.0 |
| 2015-06-17 | BR | Futures | 0.18845 | 0.19112 | 0.18803 | 0.19058 | 31.0 |
| 2015-06-17 | BZ | Futures | 60.02 | 61.71 | 58.99 | 60.21 | 30479.0 |
| 2015-06-17 | C | Futures | 2320.0 | 2320.0 | 2294.0 | 2300.0 | 3484.0 |
| 2015-06-17 | CB | Futures | 159.663 | 159.663 | 159.258 | 159.258 | 21.0 |
| 2015-06-17 | CC | Futures | 2380.0 | 2380.0 | 2360.0 | 2369.0 | 10938.0 |
| 2015-06-17 | CNH | Futures | 7.0132 | 7.0164 | 7.0109 | 7.0109 | 11.0 |
| 2015-06-17 | CSC | Futures | 4.609 | 4.609 | 4.533 | 4.533 | 91.0 |
| 2015-06-17 | CT | Futures | 81.45 | 81.52 | 80.03 | 80.47 | 9947.0 |
| 2015-06-17 | DC | Futures | 37.3 | 37.32 | 36.55 | 36.68 | 104.0 |
| 2015-06-17 | DX | Futures | 89.181 | 89.481 | 88.282 | 88.451 | 58256.0 |
| 2015-06-17 | E1 | Futures | 1.36605 | 1.38535 | 1.36605 | 1.38192 | 17244.0 |
| 2015-06-17 | E6 | Futures | 1.32281 | 1.33596 | 1.31811 | 1.33303 | 251509.0 |
| 2015-06-17 | E7 | Futures | 1.3154 | 1.3285 | 1.3097 | 1.3257 | 4512.0 |
| 2015-06-17 | EBM | Futures | 291.02 | 295.12 | 291.02 | 292.66 | 12665.0 |
| 2015-06-17 | ED | Futures | 95.5695 | 95.6175 | 95.5407 | 95.5983 | 493067.0 |
| 2015-06-17 | ER | Futures | 98.048 | 98.053 | 98.043 | 98.048 | 60142.0 |
| 2015-06-17 | EW | Futures | 1604.9 | 1609.3 | 1594.0 | 1599.6 | 21191.0 |
| 2015-06-17 | FBTP | Futures | 95.78 | 96.54 | 95.61 | 96.28 | 83055.0 |
| 2015-06-17 | FBTS | Futures | 99.109 | 99.287 | 99.1 | 99.207 | 20967.0 |
| 2015-06-17 | FCE | Futures | 4027.0 | 4042.4 | 3958.2 | 3984.5 | 98241.0 |
| 2015-06-17 | FDAX | Futures | 12260.6 | 12299.3 | 12026.3 | 12137.9 | 72868.0 |
| 2015-06-17 | FDIV | Futures | 150.24 | 150.24 | 149.13 | 149.13 | 11.0 |
| 2015-06-17 | FESX | Futures | 2555.5 | 2565.1 | 2510.3 | 2533.3 | 1435723.0 |
| 2015-06-17 | FEU3 | Futures | 98.69 | 98.695 | 98.69 | 98.69 | 146.0 |
| 2015-06-17 | FGBL | Futures | 135.37 | 135.56 | 134.95 | 135.1 | 584347.0 |
| 2015-06-17 | FGBM | Futures | 123.7 | 123.81 | 123.64 | 123.7 | 363982.0 |
| 2015-06-17 | FGBS | Futures | 111.143 | 111.158 | 111.138 | 111.148 | 175770.0 |
| 2015-06-17 | FGBX | Futures | 153.53 | 153.57 | 151.95 | 152.52 | 19025.0 |
| 2015-06-17 | FMWO | Futures | 5852.0 | 5859.4 | 5832.3 | 5832.3 | 1624.0 |
| 2015-06-17 | FOAT | Futures | 122.83 | 123.31 | 122.62 | 122.95 | 76727.0 |
| 2015-06-17 | FTDX | Futures | 1555.7 | 1558.0 | 1526.9 | 1535.4 | 2966.0 |
| 2015-06-17 | FTI | Futures | 415.33 | 416.82 | 409.09 | 411.66 | 24347.0 |
| 2015-06-17 | FTUK | Futures | 5294.4 | 5309.9 | 5250.3 | 5274.6 | 128722.0 |
| 2015-06-17 | FVSA | Futures | 1887.53 | 2032.42 | 1859.36 | 1959.97 | 29353.0 |
| 2015-06-17 | FXXP | Futures | 295.9 | 296.1 | 292.3 | 293.9 | 42990.0 |
| 2015-06-17 | G | Futures | 101.7 | 101.86 | 100.98 | 101.05 | 144589.0 |
| 2015-06-17 | GF | Futures | 381.863 | 382.968 | 379.908 | 382.076 | 2745.0 |
| 2015-06-17 | GSCI | Futures | 735.49 | 738.07 | 719.48 | 727.49 | 15.0 |
> showing 50 of 108 rows — these rows as CSV