PREVIEW / futures_daily / 2011-10-12
file: by_date/futures_daily/2011/2011-10-12.parquet size: 9 KB rows: 96
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-12 | ES | Futures | 1185.42 | 1213.87 | 1178.68 | 1196.15 | 2559219.0 |
| 2011-10-12 | NQ | Futures | 2610.51 | 2658.45 | 2596.24 | 2621.35 | 304865.0 |
| 2011-10-12 | YM | Futures | 10871.8 | 11105.2 | 10814.1 | 10966.9 | 116010.0 |
| 2011-10-12 | CL | Futures | 160.65 | 163.27 | 159.37 | 161.35 | 294230.0 |
| 2011-10-12 | GC | Futures | 2247.6 | 2287.0 | 2244.0 | 2271.8 | 112765.0 |
| 2011-10-12 | ZN | Futures | 110.074791 | 110.249087 | 109.417828 | 109.766421 | 1227257.0 |
| 2011-10-12 | A6 | Futures | 0.86909 | 0.89028 | 0.86047 | 0.88853 | 169246.0 |
| 2011-10-12 | AD | Futures | 0.97114 | 0.98585 | 0.96714 | 0.98414 | 100198.0 |
| 2011-10-12 | B | Futures | 94.0 | 96.21 | 93.68 | 95.27 | 233492.0 |
| 2011-10-12 | B6 | Futures | 1.6262 | 1.6479 | 1.6211 | 1.6431 | 125370.0 |
| 2011-10-12 | BR | Futures | 0.25611 | 0.25611 | 0.25611 | 0.25611 | 6.0 |
| 2011-10-12 | BZ | Futures | 100.05 | 101.66 | 100.05 | 100.69 | 1351.0 |
| 2011-10-12 | C | Futures | 1791.0 | 1807.0 | 1779.0 | 1786.0 | 7267.0 |
| 2011-10-12 | CB | Futures | 94.793 | 94.793 | 94.245 | 94.245 | 4.0 |
| 2011-10-12 | CC | Futures | 2036.0 | 2097.0 | 2036.0 | 2065.0 | 6731.0 |
| 2011-10-12 | CSC | Futures | 3.947 | 3.959 | 3.944 | 3.944 | 12.0 |
| 2011-10-12 | CT | Futures | 132.8 | 134.08 | 128.5 | 129.58 | 12285.0 |
| 2011-10-12 | DC | Futures | 27.65 | 27.86 | 27.52 | 27.69 | 189.0 |
| 2011-10-12 | DX | Futures | 76.574 | 76.809 | 75.705 | 75.861 | 34933.0 |
| 2011-10-12 | E1 | Futures | 1.44703 | 1.47314 | 1.44165 | 1.46895 | 26686.0 |
| 2011-10-12 | E6 | Futures | 1.63027 | 1.65238 | 1.62226 | 1.64688 | 316600.0 |
| 2011-10-12 | E7 | Futures | 1.6152 | 1.6381 | 1.6085 | 1.6328 | 5580.0 |
| 2011-10-12 | ED | Futures | 94.9507 | 94.965 | 94.9459 | 94.9602 | 188641.0 |
| 2011-10-12 | ER | Futures | 97.228 | 97.238 | 97.179 | 97.213 | 115373.0 |
| 2011-10-12 | EW | Futures | 824.7 | 849.8 | 820.1 | 835.2 | 33810.0 |
| 2011-10-12 | FBTP | Futures | 62.52 | 62.52 | 62.01 | 62.14 | 6541.0 |
| 2011-10-12 | FBTS | Futures | 82.353 | 82.353 | 82.192 | 82.224 | 1108.0 |
| 2011-10-12 | FCE | Futures | 2251.7 | 2330.0 | 2240.6 | 2315.6 | 25592.0 |
| 2011-10-12 | FDAX | Futures | 6347.1 | 6556.7 | 6305.3 | 6508.9 | 182191.0 |
| 2011-10-12 | FESX | Futures | 1527.8 | 1580.3 | 1517.8 | 1568.4 | 1752728.0 |
| 2011-10-12 | FEU3 | Futures | 97.771 | 97.771 | 97.771 | 97.771 | 30.0 |
| 2011-10-12 | FGBL | Futures | 109.01 | 109.11 | 107.73 | 108.06 | 928180.0 |
| 2011-10-12 | FGBM | Futures | 110.04 | 110.14 | 109.35 | 109.58 | 444938.0 |
| 2011-10-12 | FGBS | Futures | 108.86 | 108.875 | 108.621 | 108.726 | 508504.0 |
| 2011-10-12 | FGBX | Futures | 110.42 | 110.68 | 107.6 | 108.0 | 5881.0 |
| 2011-10-12 | FTDX | Futures | 602.1 | 626.5 | 602.1 | 625.6 | 270.0 |
| 2011-10-12 | FTI | Futures | 240.31 | 247.26 | 240.02 | 247.26 | 37.0 |
| 2011-10-12 | FTUK | Futures | 3839.3 | 3906.0 | 3819.9 | 3880.9 | 120313.0 |
| 2011-10-12 | FVSA | Futures | 16313.97 | 16313.97 | 15168.03 | 15293.04 | 7392.0 |
| 2011-10-12 | FXXP | Futures | 162.9 | 166.4 | 161.9 | 166.1 | 7978.0 |
| 2011-10-12 | G | Futures | 90.28 | 90.58 | 89.63 | 89.78 | 142758.0 |
| 2011-10-12 | GF | Futures | 317.24 | 319.01 | 316.299 | 317.185 | 2996.0 |
| 2011-10-12 | GSCI | Futures | 980.86 | 985.8 | 977.03 | 979.06 | 2385.0 |
| 2011-10-12 | HE | Futures | 112.022 | 112.761 | 111.732 | 112.407 | 16207.0 |
| 2011-10-12 | HG | Futures | 4.3338 | 4.5144 | 4.2855 | 4.4906 | 47030.0 |
| 2011-10-12 | HO | Futures | 2.3254 | 2.3691 | 2.3177 | 2.3535 | 32337.0 |
| 2011-10-12 | HRC | Futures | 2727.1 | 2727.1 | 2727.1 | 2727.1 | 0.0 |
| 2011-10-12 | J1 | Futures | 0.0164027 | 0.0164843 | 0.016223 | 0.016267 | 139542.0 |
| 2011-10-12 | J7 | Futures | 0.016296 | 0.016381 | 0.016126 | 0.016168 | 1037.0 |
| 2011-10-12 | JB | Futures | 124.4 | 124.48 | 124.3 | 124.3 | 1279.0 |
> showing 50 of 96 rows — these rows as CSV