PREVIEW / futures_daily / 2013-11-01
file: by_date/futures_daily/2013/2013-11-01.parquet size: 9 KB rows: 103
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-01 | ES | Futures | 1803.29 | 1809.2 | 1794.56 | 1802.52 | 1602379.0 |
| 2013-11-01 | NQ | Futures | 3878.86 | 3891.78 | 3856.18 | 3868.24 | 230311.0 |
| 2013-11-01 | YM | Futures | 15446.3 | 15511.0 | 15403.5 | 15464.2 | 127925.0 |
| 2013-11-01 | CL | Futures | 171.38 | 171.97 | 167.89 | 168.34 | 282138.0 |
| 2013-11-01 | GC | Futures | 1749.9 | 1755.4 | 1726.7 | 1736.8 | 136964.0 |
| 2013-11-01 | ZN | Futures | 115.320068 | 115.362553 | 114.824402 | 114.909374 | 1110369.0 |
| 2013-11-01 | A6 | Futures | 0.89095 | 0.89378 | 0.88736 | 0.88868 | 74785.0 |
| 2013-11-01 | AD | Futures | 0.96743 | 0.96945 | 0.96541 | 0.96783 | 56944.0 |
| 2013-11-01 | B | Futures | 108.78 | 109.13 | 105.71 | 105.85 | 173009.0 |
| 2013-11-01 | B6 | Futures | 1.6834 | 1.6839 | 1.6693 | 1.6713 | 110483.0 |
| 2013-11-01 | BFX | Futures | 3463.6 | 3463.6 | 3443.8 | 3443.8 | 1.0 |
| 2013-11-01 | BR | Futures | 0.22514 | 0.22514 | 0.22359 | 0.224 | 579.0 |
| 2013-11-01 | BZ | Futures | 109.61 | 109.82 | 106.42 | 106.56 | 7373.0 |
| 2013-11-01 | C | Futures | 1796.0 | 1814.0 | 1791.0 | 1811.0 | 9866.0 |
| 2013-11-01 | CB | Futures | 72.536 | 72.896 | 72.176 | 72.176 | 16.0 |
| 2013-11-01 | CC | Futures | 1988.0 | 1988.0 | 1963.0 | 1976.0 | 15741.0 |
| 2013-11-01 | CNH | Futures | 7.0282 | 7.0282 | 7.0254 | 7.0254 | 10.0 |
| 2013-11-01 | CSC | Futures | 3.522 | 3.526 | 3.499 | 3.511 | 7.0 |
| 2013-11-01 | CT | Futures | 90.51 | 91.07 | 89.79 | 89.84 | 11756.0 |
| 2013-11-01 | DC | Futures | 26.72 | 26.87 | 26.49 | 26.61 | 303.0 |
| 2013-11-01 | DX | Futures | 76.538 | 77.053 | 76.529 | 76.995 | 31317.0 |
| 2013-11-01 | E1 | Futures | 1.41783 | 1.41822 | 1.40665 | 1.40858 | 34176.0 |
| 2013-11-01 | E6 | Futures | 1.60377 | 1.60389 | 1.59079 | 1.59233 | 241421.0 |
| 2013-11-01 | E7 | Futures | 1.5934 | 1.5934 | 1.5806 | 1.5821 | 4498.0 |
| 2013-11-01 | ED | Futures | 95.359 | 95.3638 | 95.3542 | 95.359 | 71708.0 |
| 2013-11-01 | ER | Futures | 97.876 | 97.896 | 97.871 | 97.881 | 144858.0 |
| 2013-11-01 | EW | Futures | 1314.0 | 1318.8 | 1303.3 | 1311.4 | 30140.0 |
| 2013-11-01 | FBTP | Futures | 81.2 | 81.51 | 81.18 | 81.26 | 24153.0 |
| 2013-11-01 | FBTS | Futures | 94.854 | 95.01 | 94.837 | 94.932 | 6540.0 |
| 2013-11-01 | FCE | Futures | 3330.7 | 3336.2 | 3303.2 | 3307.5 | 88578.0 |
| 2013-11-01 | FDAX | Futures | 10027.0 | 10042.6 | 9979.9 | 9992.6 | 82785.0 |
| 2013-11-01 | FESX | Futures | 2146.3 | 2151.2 | 2130.8 | 2134.4 | 658442.0 |
| 2013-11-01 | FEU3 | Futures | 98.502 | 98.512 | 98.502 | 98.502 | 430.0 |
| 2013-11-01 | FGBL | Futures | 120.97 | 121.08 | 120.65 | 120.79 | 606019.0 |
| 2013-11-01 | FGBM | Futures | 118.54 | 118.72 | 118.45 | 118.53 | 531383.0 |
| 2013-11-01 | FGBS | Futures | 110.573 | 110.613 | 110.538 | 110.563 | 367372.0 |
| 2013-11-01 | FGBX | Futures | 122.19 | 122.33 | 121.55 | 121.82 | 15458.0 |
| 2013-11-01 | FMWO | Futures | 5240.8 | 5240.8 | 5240.8 | 5240.8 | 0.0 |
| 2013-11-01 | FOAT | Futures | 108.8 | 108.94 | 108.6 | 108.73 | 43947.0 |
| 2013-11-01 | FTDX | Futures | 1068.5 | 1070.9 | 1064.3 | 1069.0 | 59.0 |
| 2013-11-01 | FTI | Futures | 338.19 | 338.5 | 336.34 | 336.94 | 22311.0 |
| 2013-11-01 | FTUK | Futures | 5042.3 | 5053.6 | 5019.4 | 5025.8 | 87763.0 |
| 2013-11-01 | FVSA | Futures | 2081.43 | 2111.86 | 2063.17 | 2087.51 | 2766.0 |
| 2013-11-01 | FXXP | Futures | 235.3 | 235.4 | 233.8 | 233.9 | 3477.0 |
| 2013-11-01 | G | Futures | 93.3 | 93.46 | 92.91 | 93.03 | 123844.0 |
| 2013-11-01 | GF | Futures | 265.995 | 266.076 | 263.616 | 263.737 | 2706.0 |
| 2013-11-01 | GSCI | Futures | 1037.7 | 1037.7 | 1018.94 | 1018.94 | 546.0 |
| 2013-11-01 | HE | Futures | 113.218 | 113.281 | 111.794 | 111.826 | 19006.0 |
| 2013-11-01 | HG | Futures | 4.1791 | 4.2114 | 4.1664 | 4.1766 | 42273.0 |
| 2013-11-01 | HH | Futures | 36.165 | 36.237 | 36.022 | 36.042 | 2310.0 |
> showing 50 of 103 rows — these rows as CSV