PREVIEW / futures_daily / 2015-07-27
file: by_date/futures_daily/2015/2015-07-27.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-07-27 | ES | Futures | 2202.57 | 2205.22 | 2179.51 | 2187.99 | 1781810.0 |
| 2015-07-27 | NQ | Futures | 5326.51 | 5333.52 | 5257.92 | 5280.1 | 293740.0 |
| 2015-07-27 | YM | Futures | 18000.6 | 18021.1 | 17787.0 | 17866.1 | 165139.0 |
| 2015-07-27 | CL | Futures | 79.7 | 80.03 | 77.89 | 78.68 | 273614.0 |
| 2015-07-27 | GC | Futures | 1417.7 | 1426.3 | 1404.5 | 1416.0 | 53579.0 |
| 2015-07-27 | ZN | Futures | 120.928739 | 121.405658 | 120.913835 | 121.286428 | 794985.0 |
| 2015-07-27 | A6 | Futures | 0.71821 | 0.72356 | 0.71771 | 0.7193 | 76883.0 |
| 2015-07-27 | AD | Futures | 0.78365 | 0.78743 | 0.78344 | 0.78416 | 55343.0 |
| 2015-07-27 | ALI | Futures | 2230.58 | 2230.58 | 2230.58 | 2230.58 | 0.0 |
| 2015-07-27 | B | Futures | 50.83 | 51.17 | 49.33 | 49.92 | 128183.0 |
| 2015-07-27 | B6 | Futures | 1.6319 | 1.6409 | 1.6298 | 1.6368 | 71487.0 |
| 2015-07-27 | BFX | Futures | 4540.0 | 4540.0 | 4474.1 | 4474.1 | 13.0 |
| 2015-07-27 | BR | Futures | 0.17491 | 0.17677 | 0.17491 | 0.17605 | 8062.0 |
| 2015-07-27 | BZ | Futures | 50.79 | 51.08 | 49.31 | 49.87 | 18074.0 |
| 2015-07-27 | C | Futures | 2286.0 | 2301.0 | 2273.0 | 2284.0 | 7119.0 |
| 2015-07-27 | CB | Futures | 156.624 | 157.231 | 155.55 | 155.813 | 28.0 |
| 2015-07-27 | CC | Futures | 2338.0 | 2366.0 | 2327.0 | 2348.0 | 16191.0 |
| 2015-07-27 | CNH | Futures | 7.0147 | 7.0147 | 7.0123 | 7.0123 | 1.0 |
| 2015-07-27 | CSC | Futures | 4.343 | 4.351 | 4.305 | 4.32 | 137.0 |
| 2015-07-27 | CT | Futures | 80.57 | 80.57 | 78.35 | 78.7 | 62.0 |
| 2015-07-27 | DC | Futures | 35.04 | 35.3 | 34.57 | 34.7 | 305.0 |
| 2015-07-27 | DX | Futures | 91.138 | 91.184 | 90.201 | 90.431 | 48484.0 |
| 2015-07-27 | E1 | Futures | 1.32034 | 1.33456 | 1.32008 | 1.32059 | 20966.0 |
| 2015-07-27 | E6 | Futures | 1.29038 | 1.30836 | 1.28956 | 1.3046 | 221444.0 |
| 2015-07-27 | E7 | Futures | 1.2838 | 1.3011 | 1.2824 | 1.2974 | 4513.0 |
| 2015-07-27 | EBM | Futures | 302.09 | 302.5 | 296.76 | 297.58 | 14566.0 |
| 2015-07-27 | ED | Futures | 95.6318 | 95.6414 | 95.6318 | 95.6318 | 96064.0 |
| 2015-07-27 | ER | Futures | 98.107 | 98.112 | 98.107 | 98.107 | 8071.0 |
| 2015-07-27 | EW | Futures | 1546.3 | 1546.5 | 1529.0 | 1532.4 | 15031.0 |
| 2015-07-27 | FBTP | Futures | 100.6 | 100.71 | 100.1 | 100.39 | 47092.0 |
| 2015-07-27 | FBTS | Futures | 100.008 | 100.008 | 99.964 | 99.999 | 7791.0 |
| 2015-07-27 | FCE | Futures | 4210.4 | 4210.4 | 4101.6 | 4109.9 | 109134.0 |
| 2015-07-27 | FDAX | Futures | 12508.8 | 12514.4 | 12193.2 | 12245.2 | 132855.0 |
| 2015-07-27 | FDIV | Futures | 151.17 | 151.17 | 150.15 | 150.15 | 17.0 |
| 2015-07-27 | FESX | Futures | 2656.1 | 2656.9 | 2591.7 | 2602.8 | 1275901.0 |
| 2015-07-27 | FEU3 | Futures | 98.754 | 98.759 | 98.749 | 98.749 | 11.0 |
| 2015-07-27 | FGBL | Futures | 137.35 | 137.58 | 137.12 | 137.31 | 394083.0 |
| 2015-07-27 | FGBM | Futures | 124.55 | 124.61 | 124.47 | 124.54 | 297633.0 |
| 2015-07-27 | FGBS | Futures | 111.198 | 111.218 | 111.193 | 111.208 | 92253.0 |
| 2015-07-27 | FGBX | Futures | 157.06 | 157.55 | 156.19 | 156.62 | 27854.0 |
| 2015-07-27 | FMWO | Futures | 5772.0 | 5772.0 | 5736.3 | 5736.3 | 642.0 |
| 2015-07-27 | FOAT | Futures | 125.8 | 126.01 | 125.58 | 125.79 | 45507.0 |
| 2015-07-27 | FTDX | Futures | 1698.4 | 1698.4 | 1648.0 | 1654.6 | 510.0 |
| 2015-07-27 | FTI | Futures | 419.25 | 419.9 | 411.95 | 413.42 | 34975.0 |
| 2015-07-27 | FTUK | Futures | 5178.0 | 5195.5 | 5115.6 | 5135.9 | 88274.0 |
| 2015-07-27 | FVSA | Futures | 1772.08 | 1947.54 | 1772.08 | 1903.67 | 20089.0 |
| 2015-07-27 | FXXP | Futures | 301.0 | 301.3 | 294.8 | 296.0 | 12579.0 |
| 2015-07-27 | G | Futures | 102.26 | 102.54 | 102.22 | 102.34 | 122781.0 |
| 2015-07-27 | GF | Futures | 356.7 | 357.848 | 354.023 | 354.915 | 2833.0 |
| 2015-07-27 | GSCI | Futures | 636.33 | 637.0 | 630.59 | 633.67 | 300.0 |
> showing 50 of 108 rows — these rows as CSV