PREVIEW / futures_daily / 2016-03-31
file: by_date/futures_daily/2016/2016-03-31.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 |
|---|---|---|---|---|---|---|---|
| 2016-03-31 | ES | Futures | 2207.03 | 2211.59 | 2198.17 | 2202.73 | 1736311.0 |
| 2016-03-31 | NQ | Futures | 5264.33 | 5282.24 | 5243.18 | 5259.63 | 190526.0 |
| 2016-03-31 | YM | Futures | 18325.6 | 18361.0 | 18262.2 | 18294.4 | 120671.0 |
| 2016-03-31 | CL | Futures | 46.49 | 47.39 | 45.61 | 46.54 | 532152.0 |
| 2016-03-31 | GC | Futures | 1581.5 | 1601.2 | 1579.1 | 1592.6 | 120318.0 |
| 2016-03-31 | ZN | Futures | 125.570254 | 126.037955 | 125.479731 | 125.902171 | 1138040.0 |
| 2016-03-31 | A6 | Futures | 0.77375 | 0.77911 | 0.7701 | 0.77425 | 97107.0 |
| 2016-03-31 | AD | Futures | 0.78873 | 0.79731 | 0.78586 | 0.78801 | 86843.0 |
| 2016-03-31 | ALI | Futures | 2062.38 | 2088.88 | 2062.38 | 2088.88 | 19.0 |
| 2016-03-31 | B | Futures | 33.18 | 34.02 | 32.9 | 33.59 | 304367.0 |
| 2016-03-31 | B6 | Futures | 1.5143 | 1.5192 | 1.5086 | 1.5134 | 96230.0 |
| 2016-03-31 | BFX | Futures | 3976.9 | 3976.9 | 3949.4 | 3949.4 | 2.0 |
| 2016-03-31 | BR | Futures | 0.17774 | 0.18152 | 0.17761 | 0.1783 | 64.0 |
| 2016-03-31 | BZ | Futures | 32.85 | 33.69 | 32.56 | 33.25 | 26111.0 |
| 2016-03-31 | C | Futures | 2289.0 | 2296.0 | 2235.0 | 2274.0 | 17679.0 |
| 2016-03-31 | CB | Futures | 248.159 | 248.464 | 248.159 | 248.464 | 4.0 |
| 2016-03-31 | CC | Futures | 2167.0 | 2181.0 | 2131.0 | 2160.0 | 25901.0 |
| 2016-03-31 | CNH | Futures | 7.0527 | 7.056 | 7.0369 | 7.0451 | 47.0 |
| 2016-03-31 | CSC | Futures | 3.661 | 3.711 | 3.654 | 3.708 | 128.0 |
| 2016-03-31 | CT | Futures | 66.05 | 67.29 | 65.48 | 67.12 | 22632.0 |
| 2016-03-31 | DC | Futures | 28.71 | 29.21 | 28.67 | 29.15 | 223.0 |
| 2016-03-31 | DX | Futures | 88.43 | 88.584 | 87.913 | 88.176 | 20684.0 |
| 2016-03-31 | E1 | Futures | 1.30635 | 1.3169 | 1.30434 | 1.31226 | 24758.0 |
| 2016-03-31 | E6 | Futures | 1.32485 | 1.33395 | 1.32188 | 1.33091 | 231438.0 |
| 2016-03-31 | E7 | Futures | 1.3177 | 1.3266 | 1.3149 | 1.3237 | 3484.0 |
| 2016-03-31 | EBM | Futures | 199.13 | 199.13 | 195.92 | 196.56 | 34752.0 |
| 2016-03-31 | ED | Futures | 95.716 | 95.7208 | 95.7063 | 95.716 | 204346.0 |
| 2016-03-31 | ER | Futures | 98.259 | 98.264 | 98.254 | 98.254 | 48755.0 |
| 2016-03-31 | EW | Futures | 1522.5 | 1528.6 | 1517.7 | 1523.4 | 19994.0 |
| 2016-03-31 | FBON | Futures | 119.16 | 119.23 | 118.98 | 119.11 | 108.0 |
| 2016-03-31 | FBTP | Futures | 108.12 | 108.15 | 107.81 | 108.02 | 73294.0 |
| 2016-03-31 | FBTS | Futures | 101.024 | 101.06 | 101.024 | 101.06 | 19322.0 |
| 2016-03-31 | FCE | Futures | 3692.6 | 3693.0 | 3640.9 | 3652.6 | 97945.0 |
| 2016-03-31 | FDAX | Futures | 10804.3 | 10817.8 | 10702.3 | 10742.0 | 89597.0 |
| 2016-03-31 | FDXM | Futures | 10405.8 | 10416.1 | 10307.5 | 10344.7 | 17584.0 |
| 2016-03-31 | FESX | Futures | 2307.2 | 2307.2 | 2278.4 | 2286.2 | 1259082.0 |
| 2016-03-31 | FEU3 | Futures | 98.912 | 98.912 | 98.907 | 98.912 | 120.0 |
| 2016-03-31 | FGBL | Futures | 146.32 | 146.36 | 145.82 | 146.08 | 590955.0 |
| 2016-03-31 | FGBM | Futures | 127.52 | 127.53 | 127.36 | 127.44 | 391681.0 |
| 2016-03-31 | FGBS | Futures | 111.638 | 111.648 | 111.618 | 111.623 | 219088.0 |
| 2016-03-31 | FGBX | Futures | 174.26 | 174.38 | 173.02 | 173.7 | 35853.0 |
| 2016-03-31 | FMWO | Futures | 5580.5 | 5596.7 | 5576.8 | 5596.7 | 526.0 |
| 2016-03-31 | FOAT | Futures | 134.12 | 134.14 | 133.68 | 133.87 | 71093.0 |
| 2016-03-31 | FTDX | Futures | 1545.2 | 1548.5 | 1542.3 | 1547.1 | 58.0 |
| 2016-03-31 | FTI | Futures | 395.22 | 395.22 | 388.65 | 390.16 | 30579.0 |
| 2016-03-31 | FTUK | Futures | 5070.0 | 5072.9 | 5027.1 | 5044.9 | 116957.0 |
| 2016-03-31 | FVSA | Futures | 2617.13 | 2710.99 | 2617.13 | 2688.91 | 11281.0 |
| 2016-03-31 | FXXP | Futures | 267.8 | 268.0 | 265.3 | 266.3 | 22217.0 |
| 2016-03-31 | G | Futures | 108.64 | 108.82 | 108.48 | 108.67 | 184205.0 |
| 2016-03-31 | GF | Futures | 299.538 | 308.373 | 297.33 | 308.373 | 2615.0 |
> showing 50 of 110 rows — these rows as CSV