PREVIEW / futures_daily / 2013-11-08
file: by_date/futures_daily/2013/2013-11-08.parquet size: 9 KB rows: 102
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-08 | ES | Futures | 1792.25 | 1816.13 | 1783.78 | 1814.08 | 2071703.0 |
| 2013-11-08 | NQ | Futures | 3815.12 | 3862.5 | 3801.62 | 3859.62 | 289374.0 |
| 2013-11-08 | YM | Futures | 15466.2 | 15640.3 | 15417.5 | 15621.4 | 171251.0 |
| 2013-11-08 | CL | Futures | 167.89 | 168.89 | 167.08 | 168.32 | 241690.0 |
| 2013-11-08 | GC | Futures | 1729.6 | 1737.0 | 1693.5 | 1698.9 | 182695.0 |
| 2013-11-08 | ZN | Futures | 115.277582 | 115.744924 | 114.158795 | 114.300413 | 1609004.0 |
| 2013-11-08 | A6 | Futures | 0.89104 | 0.8935 | 0.88112 | 0.88339 | 118007.0 |
| 2013-11-08 | AD | Futures | 0.96551 | 0.96642 | 0.96096 | 0.96248 | 56905.0 |
| 2013-11-08 | B | Futures | 103.59 | 105.26 | 103.09 | 104.99 | 227154.0 |
| 2013-11-08 | B6 | Futures | 1.6893 | 1.6902 | 1.6746 | 1.6792 | 114618.0 |
| 2013-11-08 | BR | Futures | 0.21939 | 0.22054 | 0.21604 | 0.21871 | 544.0 |
| 2013-11-08 | BZ | Futures | 104.17 | 105.94 | 103.78 | 105.69 | 9653.0 |
| 2013-11-08 | C | Futures | 1814.0 | 1817.0 | 1806.0 | 1813.0 | 2661.0 |
| 2013-11-08 | CB | Futures | 72.044 | 72.056 | 72.044 | 72.056 | 11.0 |
| 2013-11-08 | CC | Futures | 1999.0 | 1999.0 | 1981.0 | 1982.0 | 21623.0 |
| 2013-11-08 | CSC | Futures | 3.445 | 3.445 | 3.412 | 3.412 | 19.0 |
| 2013-11-08 | CT | Futures | 90.05 | 91.36 | 88.98 | 90.19 | 21440.0 |
| 2013-11-08 | DC | Futures | 26.18 | 26.27 | 25.98 | 26.05 | 344.0 |
| 2013-11-08 | DX | Futures | 77.134 | 77.729 | 76.976 | 77.545 | 32561.0 |
| 2013-11-08 | E1 | Futures | 1.40293 | 1.40537 | 1.39007 | 1.39329 | 50090.0 |
| 2013-11-08 | E6 | Futures | 1.58336 | 1.58761 | 1.57167 | 1.57616 | 259995.0 |
| 2013-11-08 | E7 | Futures | 1.573 | 1.579 | 1.5617 | 1.566 | 5355.0 |
| 2013-11-08 | ED | Futures | 95.3638 | 95.3686 | 95.359 | 95.3638 | 94833.0 |
| 2013-11-08 | ER | Futures | 97.896 | 97.906 | 97.886 | 97.896 | 99094.0 |
| 2013-11-08 | EW | Futures | 1291.3 | 1309.9 | 1285.3 | 1308.7 | 24760.0 |
| 2013-11-08 | FBTP | Futures | 81.49 | 81.56 | 80.94 | 81.19 | 42167.0 |
| 2013-11-08 | FBTS | Futures | 95.114 | 95.269 | 95.053 | 95.209 | 10357.0 |
| 2013-11-08 | FCE | Futures | 3290.8 | 3309.0 | 3259.8 | 3297.8 | 154121.0 |
| 2013-11-08 | FDAX | Futures | 10020.9 | 10098.0 | 9976.0 | 10068.6 | 118599.0 |
| 2013-11-08 | FESX | Futures | 2116.8 | 2132.3 | 2098.6 | 2123.8 | 1259594.0 |
| 2013-11-08 | FEU3 | Futures | 98.512 | 98.517 | 98.512 | 98.517 | 16.0 |
| 2013-11-08 | FGBL | Futures | 120.85 | 120.87 | 119.95 | 120.08 | 768832.0 |
| 2013-11-08 | FGBM | Futures | 118.67 | 118.7 | 118.25 | 118.33 | 603990.0 |
| 2013-11-08 | FGBS | Futures | 110.623 | 110.628 | 110.538 | 110.578 | 343146.0 |
| 2013-11-08 | FGBX | Futures | 121.42 | 121.61 | 120.12 | 120.41 | 22177.0 |
| 2013-11-08 | FMWO | Futures | 5220.6 | 5238.3 | 5220.6 | 5238.3 | 134.0 |
| 2013-11-08 | FOAT | Futures | 108.48 | 108.64 | 108.05 | 108.2 | 76723.0 |
| 2013-11-08 | FTDX | Futures | 1075.1 | 1075.1 | 1054.9 | 1067.1 | 72.0 |
| 2013-11-08 | FTI | Futures | 337.59 | 340.7 | 336.64 | 339.66 | 34653.0 |
| 2013-11-08 | FTUK | Futures | 4983.8 | 5041.6 | 4967.7 | 5012.7 | 112829.0 |
| 2013-11-08 | FVSA | Futures | 2136.2 | 2160.54 | 2081.43 | 2111.86 | 13711.0 |
| 2013-11-08 | FXXP | Futures | 234.5 | 235.8 | 232.8 | 235.1 | 5803.0 |
| 2013-11-08 | G | Futures | 92.63 | 92.78 | 91.85 | 92.02 | 171594.0 |
| 2013-11-08 | GF | Futures | 265.793 | 266.882 | 264.946 | 265.229 | 1397.0 |
| 2013-11-08 | GSCI | Futures | 1008.93 | 1017.35 | 1007.18 | 1013.94 | 2031.0 |
| 2013-11-08 | HE | Futures | 111.13 | 112.047 | 111.003 | 111.541 | 22122.0 |
| 2013-11-08 | HG | Futures | 4.1031 | 4.1354 | 4.0816 | 4.1202 | 60554.0 |
| 2013-11-08 | HH | Futures | 36.299 | 36.781 | 36.258 | 36.514 | 1930.0 |
| 2013-11-08 | HO | Futures | 2.2765 | 2.3058 | 2.2682 | 2.3003 | 56120.0 |
| 2013-11-08 | HRC | Futures | 2367.6 | 2367.6 | 2367.6 | 2367.6 | 0.0 |
> showing 50 of 102 rows — these rows as CSV