PREVIEW / futures_daily / 2010-08-26
file: by_date/futures_daily/2010/2010-08-26.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-26 | ES | Futures | 1029.24 | 1035.58 | 1017.29 | 1019.0 | 1994211.0 |
| 2010-08-26 | NQ | Futures | 2025.97 | 2040.4 | 1997.67 | 2000.5 | 325465.0 |
| 2010-08-26 | YM | Futures | 9291.2 | 9343.9 | 9196.9 | 9215.4 | 146083.0 |
| 2010-08-26 | CL | Futures | 153.61 | 156.06 | 153.02 | 154.75 | 362828.0 |
| 2010-08-26 | GC | Futures | 1688.7 | 1693.6 | 1678.8 | 1682.4 | 78447.0 |
| 2010-08-26 | ZN | Futures | 103.308163 | 103.551482 | 103.167294 | 103.449032 | 1679437.0 |
| 2010-08-26 | A6 | Futures | 0.7322 | 0.73784 | 0.73055 | 0.73253 | 92457.0 |
| 2010-08-26 | AD | Futures | 0.93216 | 0.93848 | 0.93118 | 0.93325 | 79068.0 |
| 2010-08-26 | B | Futures | 63.9 | 65.49 | 63.66 | 65.03 | 71596.0 |
| 2010-08-26 | B6 | Futures | 1.6054 | 1.6186 | 1.6048 | 1.611 | 112670.0 |
| 2010-08-26 | BFX | Futures | 2783.3 | 2792.4 | 2782.2 | 2786.2 | 45.0 |
| 2010-08-26 | BR | Futures | 0.23833 | 0.23833 | 0.23741 | 0.23741 | 212.0 |
| 2010-08-26 | BZ | Futures | 69.02 | 69.02 | 69.02 | 69.02 | 152.0 |
| 2010-08-26 | C | Futures | 2240.0 | 2240.0 | 2194.0 | 2206.0 | 1800.0 |
| 2010-08-26 | CB | Futures | 96.645 | 96.645 | 96.09 | 96.09 | 3.0 |
| 2010-08-26 | CC | Futures | 2296.0 | 2304.0 | 2264.0 | 2269.0 | 7887.0 |
| 2010-08-26 | CT | Futures | 74.56 | 75.37 | 74.48 | 75.07 | 29.0 |
| 2010-08-26 | DC | Futures | 24.13 | 24.27 | 24.11 | 24.13 | 89.0 |
| 2010-08-26 | DX | Futures | 83.919 | 83.99 | 83.319 | 83.64 | 29364.0 |
| 2010-08-26 | E1 | Futures | 1.27524 | 1.28496 | 1.27301 | 1.28181 | 34303.0 |
| 2010-08-26 | E6 | Futures | 1.49727 | 1.50933 | 1.49585 | 1.502 | 333413.0 |
| 2010-08-26 | E7 | Futures | 1.4866 | 1.4986 | 1.485 | 1.4912 | 3864.0 |
| 2010-08-26 | ED | Futures | 94.5938 | 94.6104 | 94.5914 | 94.6009 | 179733.0 |
| 2010-08-26 | ER | Futures | 97.316 | 97.316 | 97.306 | 97.311 | 63172.0 |
| 2010-08-26 | EW | Futures | 708.3 | 714.4 | 701.8 | 703.3 | 28187.0 |
| 2010-08-26 | FBTP | Futures | 67.34 | 67.39 | 67.18 | 67.34 | 2934.0 |
| 2010-08-26 | FCE | Futures | 2280.9 | 2299.7 | 2263.1 | 2288.1 | 113493.0 |
| 2010-08-26 | FDAX | Futures | 6443.5 | 6475.1 | 6388.1 | 6426.1 | 128758.0 |
| 2010-08-26 | FESX | Futures | 1609.9 | 1621.0 | 1593.8 | 1609.9 | 1175876.0 |
| 2010-08-26 | FGBL | Futures | 104.61 | 104.93 | 104.4 | 104.61 | 954573.0 |
| 2010-08-26 | FGBM | Futures | 106.83 | 106.96 | 106.67 | 106.83 | 452941.0 |
| 2010-08-26 | FGBS | Futures | 107.873 | 107.883 | 107.814 | 107.834 | 385550.0 |
| 2010-08-26 | FGBX | Futures | 110.6 | 112.21 | 110.33 | 111.75 | 7244.0 |
| 2010-08-26 | FTDX | Futures | 635.1 | 641.2 | 635.1 | 639.5 | 280.0 |
| 2010-08-26 | FTI | Futures | 250.75 | 252.11 | 248.63 | 251.19 | 31261.0 |
| 2010-08-26 | FTUK | Futures | 3538.5 | 3554.4 | 3514.1 | 3541.3 | 77478.0 |
| 2010-08-26 | G | Futures | 85.01 | 85.03 | 84.61 | 84.71 | 112040.0 |
| 2010-08-26 | GF | Futures | 294.051 | 295.062 | 293.735 | 294.936 | 728.0 |
| 2010-08-26 | GSCI | Futures | 852.59 | 857.51 | 848.34 | 852.93 | 464.0 |
| 2010-08-26 | HE | Futures | 101.171 | 102.06 | 99.129 | 99.854 | 14805.0 |
| 2010-08-26 | HG | Futures | 4.3411 | 4.4512 | 4.3277 | 4.4385 | 20218.0 |
| 2010-08-26 | HO | Futures | 1.7195 | 1.7576 | 1.7144 | 1.7448 | 19035.0 |
| 2010-08-26 | HRC | Futures | 2730.7 | 2730.7 | 2730.7 | 2730.7 | 0.0 |
| 2010-08-26 | J1 | Futures | 0.0148746 | 0.0149224 | 0.0148243 | 0.0149186 | 105741.0 |
| 2010-08-26 | J7 | Futures | 0.014756 | 0.014808 | 0.014714 | 0.014806 | 286.0 |
| 2010-08-26 | JB | Futures | 121.83 | 121.9 | 121.59 | 121.66 | 1937.0 |
| 2010-08-26 | KC | Futures | 416.62 | 431.01 | 414.76 | 427.53 | 10802.0 |
| 2010-08-26 | KE | Futures | 2891.24 | 2973.64 | 2891.24 | 2941.31 | 17774.0 |
| 2010-08-26 | L | Futures | 98.106 | 98.125 | 98.096 | 98.115 | 45701.0 |
| 2010-08-26 | LBS | Futures | 623.2 | 636.8 | 622.9 | 636.8 | 498.0 |
> showing 50 of 89 rows — these rows as CSV