PREVIEW / futures_daily / 2013-11-20
file: by_date/futures_daily/2013/2013-11-20.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2013-11-20 | ES | Futures | 1834.11 | 1843.1 | 1822.81 | 1828.2 | 2066306.0 |
| 2013-11-20 | NQ | Futures | 3877.14 | 3903.27 | 3857.33 | 3866.52 | 290183.0 |
| 2013-11-20 | YM | Futures | 15852.3 | 15909.0 | 15754.8 | 15798.5 | 189282.0 |
| 2013-11-20 | CL | Futures | 166.11 | 167.16 | 164.98 | 166.04 | 225891.0 |
| 2013-11-20 | GC | Futures | 1685.6 | 1687.2 | 1640.2 | 1663.8 | 224187.0 |
| 2013-11-20 | ZN | Futures | 114.866888 | 115.178449 | 114.399547 | 114.527003 | 1612710.0 |
| 2013-11-20 | A6 | Futures | 0.88877 | 0.89085 | 0.87838 | 0.87961 | 98907.0 |
| 2013-11-20 | AD | Futures | 0.9648 | 0.96773 | 0.96409 | 0.96581 | 52553.0 |
| 2013-11-20 | B | Futures | 107.16 | 108.34 | 106.47 | 108.02 | 220188.0 |
| 2013-11-20 | B6 | Futures | 1.6911 | 1.6979 | 1.6882 | 1.6886 | 123795.0 |
| 2013-11-20 | BFX | Futures | 3452.1 | 3459.4 | 3442.5 | 3445.7 | 25.0 |
| 2013-11-20 | BR | Futures | 0.22316 | 0.22352 | 0.22275 | 0.22301 | 402.0 |
| 2013-11-20 | BZ | Futures | 108.0 | 109.05 | 107.2 | 108.74 | 5560.0 |
| 2013-11-20 | C | Futures | 1892.0 | 1912.0 | 1891.0 | 1905.0 | 5425.0 |
| 2013-11-20 | CB | Futures | 74.454 | 74.454 | 74.095 | 74.214 | 12.0 |
| 2013-11-20 | CC | Futures | 2078.0 | 2093.0 | 2071.0 | 2086.0 | 10462.0 |
| 2013-11-20 | CNH | Futures | 6.9928 | 6.9992 | 6.9928 | 6.9992 | 10.0 |
| 2013-11-20 | CSC | Futures | 3.402 | 3.402 | 3.379 | 3.387 | 14.0 |
| 2013-11-20 | CT | Futures | 88.88 | 90.85 | 88.43 | 88.72 | 6417.0 |
| 2013-11-20 | DC | Futures | 26.08 | 26.1 | 25.79 | 25.88 | 461.0 |
| 2013-11-20 | DX | Futures | 76.814 | 77.367 | 76.757 | 77.34 | 31442.0 |
| 2013-11-20 | E1 | Futures | 1.41115 | 1.41552 | 1.39804 | 1.39997 | 42068.0 |
| 2013-11-20 | E6 | Futures | 1.59728 | 1.60283 | 1.583 | 1.58371 | 287387.0 |
| 2013-11-20 | E7 | Futures | 1.587 | 1.5928 | 1.5728 | 1.5735 | 6562.0 |
| 2013-11-20 | ED | Futures | 95.3686 | 95.3757 | 95.3662 | 95.371 | 198255.0 |
| 2013-11-20 | ER | Futures | 97.886 | 97.901 | 97.881 | 97.896 | 80534.0 |
| 2013-11-20 | EW | Futures | 1317.9 | 1324.7 | 1309.1 | 1313.8 | 23106.0 |
| 2013-11-20 | FBTP | Futures | 81.72 | 81.83 | 81.47 | 81.66 | 39938.0 |
| 2013-11-20 | FBTS | Futures | 95.442 | 95.451 | 95.295 | 95.416 | 8745.0 |
| 2013-11-20 | FCE | Futures | 3300.1 | 3326.9 | 3284.9 | 3308.2 | 91530.0 |
| 2013-11-20 | FDAX | Futures | 10178.5 | 10252.3 | 10148.0 | 10211.2 | 90762.0 |
| 2013-11-20 | FESX | Futures | 2128.7 | 2148.4 | 2117.5 | 2135.8 | 794653.0 |
| 2013-11-20 | FEU3 | Futures | 98.512 | 98.517 | 98.507 | 98.517 | 2042.0 |
| 2013-11-20 | FGBL | Futures | 120.33 | 120.57 | 119.9 | 120.44 | 818307.0 |
| 2013-11-20 | FGBM | Futures | 118.44 | 118.63 | 118.28 | 118.57 | 531973.0 |
| 2013-11-20 | FGBS | Futures | 110.588 | 110.648 | 110.563 | 110.633 | 363105.0 |
| 2013-11-20 | FGBX | Futures | 120.64 | 121.01 | 119.61 | 120.66 | 14400.0 |
| 2013-11-20 | FMWO | Futures | 5325.6 | 5325.6 | 5325.6 | 5325.6 | 0.0 |
| 2013-11-20 | FOAT | Futures | 108.38 | 108.63 | 108.09 | 108.52 | 34433.0 |
| 2013-11-20 | FTDX | Futures | 1074.6 | 1074.6 | 1065.7 | 1072.3 | 120.0 |
| 2013-11-20 | FTI | Futures | 340.27 | 343.46 | 339.96 | 342.03 | 23106.0 |
| 2013-11-20 | FTUK | Futures | 5003.3 | 5034.8 | 4986.8 | 5013.4 | 73512.0 |
| 2013-11-20 | FVSA | Futures | 2057.36 | 2057.36 | 1984.75 | 1984.75 | 18467.0 |
| 2013-11-20 | FXXP | Futures | 235.2 | 236.4 | 234.3 | 235.7 | 4082.0 |
| 2013-11-20 | G | Futures | 92.28 | 92.49 | 92.05 | 92.39 | 148310.0 |
| 2013-11-20 | GF | Futures | 261.526 | 262.613 | 261.244 | 262.009 | 2136.0 |
| 2013-11-20 | GSCI | Futures | 1012.53 | 1020.07 | 1011.78 | 1018.33 | 115.0 |
| 2013-11-20 | HE | Futures | 108.453 | 110.416 | 108.242 | 109.812 | 12388.0 |
| 2013-11-20 | HG | Futures | 3.9949 | 4.0284 | 3.9829 | 4.0019 | 13404.0 |
| 2013-11-20 | HH | Futures | 37.335 | 37.725 | 37.243 | 37.694 | 5929.0 |
> showing 50 of 105 rows — these rows as CSV