PREVIEW / futures_daily / 2016-03-22
file: by_date/futures_daily/2016/2016-03-22.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-22 | ES | Futures | 2193.87 | 2198.44 | 2178.3 | 2193.07 | 1496196.0 |
| 2016-03-22 | NQ | Futures | 5188.83 | 5217.62 | 5150.94 | 5210.57 | 190219.0 |
| 2016-03-22 | YM | Futures | 18228.9 | 18251.8 | 18123.9 | 18199.8 | 128386.0 |
| 2016-03-22 | CL | Futures | 50.49 | 50.86 | 49.49 | 50.32 | 463693.0 |
| 2016-03-22 | GC | Futures | 1598.8 | 1620.2 | 1596.9 | 1604.4 | 195733.0 |
| 2016-03-22 | ZN | Futures | 124.574502 | 124.921507 | 124.27276 | 124.363282 | 1050855.0 |
| 2016-03-22 | A6 | Futures | 0.76423 | 0.77061 | 0.7613 | 0.76788 | 76979.0 |
| 2016-03-22 | AD | Futures | 0.78075 | 0.78484 | 0.7783 | 0.78392 | 45423.0 |
| 2016-03-22 | ALI | Futures | 2073.69 | 2074.34 | 2069.81 | 2074.34 | 53.0 |
| 2016-03-22 | B | Futures | 34.54 | 35.05 | 34.12 | 34.8 | 268210.0 |
| 2016-03-22 | B6 | Futures | 1.5132 | 1.5165 | 1.4946 | 1.496 | 110728.0 |
| 2016-03-22 | BFX | Futures | 3981.6 | 4010.3 | 3965.8 | 4010.3 | 3.0 |
| 2016-03-22 | BR | Futures | 0.17596 | 0.1794 | 0.17583 | 0.17843 | 42.0 |
| 2016-03-22 | BZ | Futures | 34.22 | 34.72 | 33.78 | 34.45 | 31640.0 |
| 2016-03-22 | C | Futures | 2366.0 | 2373.0 | 2345.0 | 2358.0 | 10920.0 |
| 2016-03-22 | CB | Futures | 249.378 | 249.378 | 245.11 | 249.378 | 17.0 |
| 2016-03-22 | CC | Futures | 2238.0 | 2247.0 | 2215.0 | 2222.0 | 12973.0 |
| 2016-03-22 | CNH | Futures | 7.0832 | 7.0874 | 7.079 | 7.079 | 7.0 |
| 2016-03-22 | CSC | Futures | 3.601 | 3.601 | 3.58 | 3.587 | 54.0 |
| 2016-03-22 | CT | Futures | 66.65 | 67.12 | 66.18 | 67.04 | 9136.0 |
| 2016-03-22 | DC | Futures | 28.44 | 28.49 | 28.24 | 28.3 | 63.0 |
| 2016-03-22 | DX | Futures | 88.985 | 89.269 | 88.826 | 89.17 | 20351.0 |
| 2016-03-22 | E1 | Futures | 1.29919 | 1.30145 | 1.29529 | 1.29605 | 14126.0 |
| 2016-03-22 | E6 | Futures | 1.31418 | 1.31651 | 1.30806 | 1.31161 | 157210.0 |
| 2016-03-22 | E7 | Futures | 1.3071 | 1.3093 | 1.3011 | 1.3045 | 2337.0 |
| 2016-03-22 | EBM | Futures | 197.85 | 200.74 | 197.52 | 200.42 | 29256.0 |
| 2016-03-22 | ED | Futures | 95.6485 | 95.6678 | 95.634 | 95.6389 | 253189.0 |
| 2016-03-22 | ER | Futures | 98.254 | 98.259 | 98.254 | 98.259 | 19590.0 |
| 2016-03-22 | EW | Futures | 1507.5 | 1511.2 | 1495.1 | 1506.8 | 13546.0 |
| 2016-03-22 | FBON | Futures | 118.39 | 118.52 | 118.16 | 118.3 | 346.0 |
| 2016-03-22 | FBTP | Futures | 107.69 | 107.83 | 107.5 | 107.59 | 65886.0 |
| 2016-03-22 | FBTS | Futures | 101.051 | 101.051 | 101.015 | 101.024 | 13280.0 |
| 2016-03-22 | FCE | Futures | 3688.4 | 3699.2 | 3625.5 | 3689.7 | 100123.0 |
| 2016-03-22 | FDAX | Futures | 10729.1 | 10782.3 | 10517.5 | 10748.5 | 116184.0 |
| 2016-03-22 | FDXM | Futures | 10326.1 | 10382.0 | 10128.6 | 10349.9 | 25659.0 |
| 2016-03-22 | FESX | Futures | 2319.7 | 2324.4 | 2275.2 | 2315.8 | 1363679.0 |
| 2016-03-22 | FEU3 | Futures | 98.912 | 98.912 | 98.912 | 98.912 | 4.0 |
| 2016-03-22 | FGBL | Futures | 145.32 | 145.83 | 145.16 | 145.38 | 594136.0 |
| 2016-03-22 | FGBM | Futures | 127.25 | 127.43 | 127.19 | 127.23 | 382743.0 |
| 2016-03-22 | FGBS | Futures | 111.618 | 111.643 | 111.608 | 111.618 | 141178.0 |
| 2016-03-22 | FGBX | Futures | 170.84 | 172.07 | 170.32 | 171.21 | 25543.0 |
| 2016-03-22 | FMWO | Futures | 5540.7 | 5563.1 | 5535.8 | 5563.1 | 471.0 |
| 2016-03-22 | FOAT | Futures | 132.99 | 133.41 | 132.82 | 133.03 | 61108.0 |
| 2016-03-22 | FTDX | Futures | 1518.5 | 1528.5 | 1493.3 | 1526.6 | 109.0 |
| 2016-03-22 | FTI | Futures | 393.22 | 393.58 | 386.43 | 392.33 | 38225.0 |
| 2016-03-22 | FTUK | Futures | 5060.1 | 5065.1 | 4989.6 | 5058.5 | 131467.0 |
| 2016-03-22 | FVSA | Futures | 2705.47 | 2793.81 | 2644.74 | 2666.82 | 15355.0 |
| 2016-03-22 | FXXP | Futures | 268.6 | 268.8 | 264.1 | 268.2 | 15965.0 |
| 2016-03-22 | G | Futures | 108.27 | 108.5 | 108.01 | 108.27 | 138913.0 |
| 2016-03-22 | GF | Futures | 308.814 | 309.698 | 304.986 | 307.931 | 5636.0 |
> showing 50 of 110 rows — these rows as CSV