PREVIEW / futures_daily / 2013-11-06
file: by_date/futures_daily/2013/2013-11-06.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-06 | ES | Futures | 1805.09 | 1818.19 | 1803.55 | 1813.57 | 1322195.0 |
| 2013-11-06 | NQ | Futures | 3882.02 | 3902.69 | 3870.82 | 3877.43 | 218082.0 |
| 2013-11-06 | YM | Futures | 15475.2 | 15619.4 | 15468.2 | 15604.5 | 133805.0 |
| 2013-11-06 | CL | Futures | 166.79 | 169.74 | 166.63 | 168.68 | 282722.0 |
| 2013-11-06 | GC | Futures | 1735.6 | 1748.4 | 1731.1 | 1742.8 | 97108.0 |
| 2013-11-06 | ZN | Futures | 114.696946 | 115.135964 | 114.65446 | 115.03683 | 1030712.0 |
| 2013-11-06 | A6 | Futures | 0.89482 | 0.89897 | 0.89359 | 0.89803 | 57063.0 |
| 2013-11-06 | AD | Futures | 0.96561 | 0.96945 | 0.965 | 0.96874 | 37914.0 |
| 2013-11-06 | B | Futures | 105.33 | 106.3 | 104.86 | 105.31 | 186452.0 |
| 2013-11-06 | B6 | Futures | 1.6837 | 1.6915 | 1.6835 | 1.6877 | 73815.0 |
| 2013-11-06 | BFX | Futures | 3498.4 | 3499.8 | 3496.9 | 3496.9 | 38.0 |
| 2013-11-06 | BR | Futures | 0.22156 | 0.22285 | 0.22026 | 0.22151 | 346.0 |
| 2013-11-06 | BZ | Futures | 106.35 | 106.99 | 105.67 | 106.01 | 7825.0 |
| 2013-11-06 | C | Futures | 1839.0 | 1851.0 | 1832.0 | 1843.0 | 5712.0 |
| 2013-11-06 | CC | Futures | 2037.0 | 2044.0 | 2025.0 | 2036.0 | 18013.0 |
| 2013-11-06 | CSC | Futures | 3.484 | 3.484 | 3.4 | 3.414 | 24.0 |
| 2013-11-06 | CT | Futures | 89.26 | 92.61 | 89.13 | 90.41 | 21420.0 |
| 2013-11-06 | DC | Futures | 26.46 | 26.55 | 25.89 | 26.01 | 453.0 |
| 2013-11-06 | DX | Futures | 76.972 | 76.986 | 76.657 | 76.756 | 14703.0 |
| 2013-11-06 | E1 | Futures | 1.4073 | 1.41295 | 1.40652 | 1.40961 | 22834.0 |
| 2013-11-06 | E6 | Futures | 1.59008 | 1.59893 | 1.58949 | 1.59575 | 185159.0 |
| 2013-11-06 | E7 | Futures | 1.5799 | 1.5886 | 1.5791 | 1.5855 | 3397.0 |
| 2013-11-06 | ED | Futures | 95.359 | 95.3638 | 95.359 | 95.359 | 59455.0 |
| 2013-11-06 | ER | Futures | 97.876 | 97.886 | 97.867 | 97.876 | 70975.0 |
| 2013-11-06 | EW | Futures | 1313.7 | 1323.3 | 1310.5 | 1313.9 | 13001.0 |
| 2013-11-06 | FBTP | Futures | 81.09 | 81.29 | 80.78 | 80.93 | 36981.0 |
| 2013-11-06 | FBTS | Futures | 94.958 | 95.019 | 94.846 | 94.88 | 9745.0 |
| 2013-11-06 | FCE | Futures | 3309.0 | 3329.2 | 3300.5 | 3318.7 | 101479.0 |
| 2013-11-06 | FDAX | Futures | 10037.0 | 10062.0 | 10012.6 | 10030.9 | 81192.0 |
| 2013-11-06 | FESX | Futures | 2133.7 | 2147.0 | 2130.1 | 2138.6 | 720930.0 |
| 2013-11-06 | FEU3 | Futures | 98.492 | 98.497 | 98.492 | 98.497 | 24.0 |
| 2013-11-06 | FGBL | Futures | 120.38 | 120.44 | 120.11 | 120.19 | 624338.0 |
| 2013-11-06 | FGBM | Futures | 118.29 | 118.34 | 118.17 | 118.22 | 601279.0 |
| 2013-11-06 | FGBS | Futures | 110.518 | 110.538 | 110.493 | 110.503 | 310162.0 |
| 2013-11-06 | FGBX | Futures | 121.26 | 121.36 | 120.6 | 120.72 | 15896.0 |
| 2013-11-06 | FMWO | Futures | 5286.4 | 5286.4 | 5286.4 | 5286.4 | 0.0 |
| 2013-11-06 | FOAT | Futures | 108.33 | 108.43 | 108.09 | 108.17 | 49030.0 |
| 2013-11-06 | FTDX | Futures | 1070.4 | 1077.9 | 1070.4 | 1076.1 | 61.0 |
| 2013-11-06 | FTI | Futures | 338.67 | 341.3 | 338.02 | 339.71 | 25194.0 |
| 2013-11-06 | FTUK | Futures | 5044.6 | 5064.8 | 5037.8 | 5045.3 | 72129.0 |
| 2013-11-06 | FVSA | Futures | 2075.34 | 2093.6 | 2038.82 | 2081.43 | 2575.0 |
| 2013-11-06 | FXXP | Futures | 235.0 | 236.2 | 235.0 | 235.5 | 4391.0 |
| 2013-11-06 | G | Futures | 92.58 | 92.6 | 92.25 | 92.41 | 141198.0 |
| 2013-11-06 | GF | Futures | 265.793 | 266.64 | 265.269 | 265.914 | 945.0 |
| 2013-11-06 | GSCI | Futures | 1009.6 | 1020.94 | 1009.6 | 1015.6 | 676.0 |
| 2013-11-06 | HE | Futures | 111.573 | 111.573 | 110.433 | 110.56 | 24094.0 |
| 2013-11-06 | HG | Futures | 4.131 | 4.1506 | 4.0797 | 4.0987 | 52242.0 |
| 2013-11-06 | HH | Futures | 35.683 | 36.36 | 35.683 | 35.888 | 2581.0 |
| 2013-11-06 | HO | Futures | 2.3006 | 2.3167 | 2.2943 | 2.2984 | 62641.0 |
| 2013-11-06 | HRC | Futures | 2342.7 | 2342.7 | 2342.7 | 2342.7 | 0.0 |
> showing 50 of 102 rows — these rows as CSV