PREVIEW / futures_daily / 2010-10-14
file: by_date/futures_daily/2010/2010-10-14.parquet size: 9 KB rows: 90
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-10-14 | ES | Futures | 1151.44 | 1157.33 | 1139.44 | 1150.22 | 2400204.0 |
| 2010-10-14 | NQ | Futures | 2331.85 | 2344.32 | 2314.56 | 2338.09 | 316761.0 |
| 2010-10-14 | YM | Futures | 10277.3 | 10327.5 | 10202.8 | 10283.8 | 134975.0 |
| 2010-10-14 | CL | Futures | 172.95 | 174.83 | 170.89 | 171.86 | 214511.0 |
| 2010-10-14 | GC | Futures | 1865.7 | 1886.8 | 1863.7 | 1872.5 | 184976.0 |
| 2010-10-14 | ZN | Futures | 105.077381 | 105.116093 | 104.496701 | 104.612837 | 1319817.0 |
| 2010-10-14 | A6 | Futures | 0.8251 | 0.83291 | 0.82477 | 0.82586 | 84592.0 |
| 2010-10-14 | AD | Futures | 0.98559 | 0.99124 | 0.98192 | 0.98242 | 82324.0 |
| 2010-10-14 | B | Futures | 72.97 | 73.59 | 71.85 | 72.26 | 189471.0 |
| 2010-10-14 | B6 | Futures | 1.6491 | 1.6673 | 1.649 | 1.6589 | 117720.0 |
| 2010-10-14 | BFX | Futures | 3041.9 | 3062.6 | 3033.0 | 3042.3 | 2276.0 |
| 2010-10-14 | BR | Futures | 0.25669 | 0.25669 | 0.25537 | 0.25537 | 341.0 |
| 2010-10-14 | BZ | Futures | 77.77 | 77.89 | 76.42 | 76.84 | 136.0 |
| 2010-10-14 | C | Futures | 2053.0 | 2079.0 | 2041.0 | 2076.0 | 5210.0 |
| 2010-10-14 | CB | Futures | 98.298 | 98.312 | 98.173 | 98.173 | 6.0 |
| 2010-10-14 | CC | Futures | 2374.0 | 2388.0 | 2337.0 | 2384.0 | 6934.0 |
| 2010-10-14 | CT | Futures | 94.3 | 97.23 | 93.87 | 97.23 | 8338.0 |
| 2010-10-14 | DC | Futures | 25.09 | 25.32 | 25.07 | 25.2 | 185.0 |
| 2010-10-14 | DX | Futures | 77.431 | 77.431 | 76.719 | 77.126 | 25308.0 |
| 2010-10-14 | E1 | Futures | 1.37043 | 1.38802 | 1.37017 | 1.37897 | 38967.0 |
| 2010-10-14 | E6 | Futures | 1.65045 | 1.66973 | 1.64986 | 1.66181 | 336100.0 |
| 2010-10-14 | E7 | Futures | 1.6379 | 1.6568 | 1.6373 | 1.6492 | 5940.0 |
| 2010-10-14 | ED | Futures | 94.7411 | 94.7458 | 94.7126 | 94.7221 | 305523.0 |
| 2010-10-14 | ER | Futures | 97.262 | 97.267 | 97.232 | 97.247 | 125779.0 |
| 2010-10-14 | EW | Futures | 806.6 | 811.8 | 798.7 | 806.4 | 26144.0 |
| 2010-10-14 | FBTP | Futures | 68.11 | 68.11 | 67.92 | 68.08 | 4959.0 |
| 2010-10-14 | FCE | Futures | 2537.3 | 2545.9 | 2515.0 | 2528.3 | 67092.0 |
| 2010-10-14 | FDAX | Futures | 6948.3 | 6985.4 | 6938.1 | 6956.9 | 136840.0 |
| 2010-10-14 | FESX | Futures | 1769.4 | 1778.7 | 1756.3 | 1764.4 | 1279315.0 |
| 2010-10-14 | FGBL | Futures | 104.11 | 104.26 | 103.58 | 103.94 | 796843.0 |
| 2010-10-14 | FGBM | Futures | 106.9 | 106.99 | 106.64 | 106.82 | 432836.0 |
| 2010-10-14 | FGBS | Futures | 107.607 | 107.632 | 107.524 | 107.563 | 383915.0 |
| 2010-10-14 | FGBX | Futures | 107.73 | 107.95 | 106.19 | 107.26 | 3552.0 |
| 2010-10-14 | FTDX | Futures | 716.1 | 716.1 | 708.6 | 711.3 | 782.0 |
| 2010-10-14 | FTI | Futures | 273.41 | 275.1 | 271.41 | 272.61 | 43007.0 |
| 2010-10-14 | FTUK | Futures | 3960.1 | 3975.3 | 3927.3 | 3948.4 | 108156.0 |
| 2010-10-14 | G | Futures | 85.16 | 85.29 | 84.95 | 85.08 | 102563.0 |
| 2010-10-14 | GF | Futures | 271.921 | 273.746 | 270.158 | 272.235 | 2023.0 |
| 2010-10-14 | GSCI | Futures | 951.88 | 951.88 | 938.59 | 941.56 | 474.0 |
| 2010-10-14 | HE | Futures | 96.52 | 96.554 | 93.035 | 93.171 | 26087.0 |
| 2010-10-14 | HG | Futures | 5.0992 | 5.1619 | 5.0204 | 5.0925 | 32516.0 |
| 2010-10-14 | HO | Futures | 1.9595 | 1.9738 | 1.9327 | 1.9426 | 29449.0 |
| 2010-10-14 | HRC | Futures | 2549.8 | 2549.8 | 2549.8 | 2549.8 | 0.0 |
| 2010-10-14 | J1 | Futures | 0.0153647 | 0.0155355 | 0.0153546 | 0.0154337 | 135117.0 |
| 2010-10-14 | J7 | Futures | 0.015255 | 0.015428 | 0.015253 | 0.015328 | 301.0 |
| 2010-10-14 | JB | Futures | 122.5 | 122.69 | 122.4 | 122.58 | 1226.0 |
| 2010-10-14 | KC | Futures | 462.13 | 468.95 | 459.52 | 465.23 | 8791.0 |
| 2010-10-14 | KE | Futures | 3095.67 | 3132.18 | 3080.03 | 3089.41 | 10280.0 |
| 2010-10-14 | L | Futures | 98.155 | 98.165 | 98.145 | 98.155 | 24590.0 |
| 2010-10-14 | LBS | Futures | 731.3 | 741.2 | 710.4 | 736.0 | 1008.0 |
> showing 50 of 90 rows — these rows as CSV