PREVIEW / futures_daily / 2010-10-08
file: by_date/futures_daily/2010/2010-10-08.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-10-08 | ES | Futures | 1133.56 | 1140.91 | 1122.77 | 1137.48 | 1969643.0 |
| 2010-10-08 | NQ | Futures | 2283.66 | 2300.95 | 2247.38 | 2291.31 | 313502.0 |
| 2010-10-08 | YM | Futures | 10154.5 | 10211.2 | 10058.6 | 10186.1 | 129720.0 |
| 2010-10-08 | CL | Futures | 169.66 | 173.2 | 167.31 | 172.22 | 414081.0 |
| 2010-10-08 | GC | Futures | 1813.5 | 1836.1 | 1801.8 | 1828.6 | 190657.0 |
| 2010-10-08 | ZN | Futures | 105.064477 | 105.42579 | 104.716069 | 105.141901 | 1357571.0 |
| 2010-10-08 | A6 | Futures | 0.81738 | 0.82225 | 0.80849 | 0.82141 | 124154.0 |
| 2010-10-08 | AD | Futures | 0.97182 | 0.97984 | 0.96597 | 0.97638 | 106196.0 |
| 2010-10-08 | B | Futures | 71.62 | 72.86 | 70.53 | 72.41 | 140815.0 |
| 2010-10-08 | B6 | Futures | 1.6467 | 1.6567 | 1.642 | 1.655 | 106960.0 |
| 2010-10-08 | BFX | Futures | 2983.2 | 3004.4 | 2975.9 | 2998.4 | 134.0 |
| 2010-10-08 | BR | Futures | 0.24986 | 0.25383 | 0.24986 | 0.25383 | 93.0 |
| 2010-10-08 | BZ | Futures | 75.37 | 77.45 | 75.2 | 76.99 | 227.0 |
| 2010-10-08 | C | Futures | 2014.0 | 2045.0 | 1995.0 | 2041.0 | 5033.0 |
| 2010-10-08 | CC | Futures | 2279.0 | 2340.0 | 2250.0 | 2321.0 | 6970.0 |
| 2010-10-08 | CT | Futures | 88.45 | 91.2 | 88.45 | 90.71 | 15900.0 |
| 2010-10-08 | DC | Futures | 25.3 | 25.65 | 25.3 | 25.54 | 295.0 |
| 2010-10-08 | DX | Futures | 77.897 | 78.238 | 77.606 | 77.81 | 29529.0 |
| 2010-10-08 | E1 | Futures | 1.35914 | 1.36964 | 1.35468 | 1.3636 | 42741.0 |
| 2010-10-08 | E6 | Futures | 1.64549 | 1.65341 | 1.63531 | 1.64466 | 413239.0 |
| 2010-10-08 | E7 | Futures | 1.633 | 1.6407 | 1.623 | 1.6322 | 6296.0 |
| 2010-10-08 | ED | Futures | 94.7411 | 94.7506 | 94.7363 | 94.7411 | 138632.0 |
| 2010-10-08 | ER | Futures | 97.252 | 97.262 | 97.237 | 97.257 | 96216.0 |
| 2010-10-08 | EW | Futures | 790.3 | 797.5 | 779.5 | 793.8 | 25377.0 |
| 2010-10-08 | FBTP | Futures | 67.69 | 67.96 | 67.69 | 67.93 | 4141.0 |
| 2010-10-08 | FCE | Futures | 2478.0 | 2482.3 | 2450.4 | 2469.8 | 134778.0 |
| 2010-10-08 | FDAX | Futures | 6768.7 | 6791.2 | 6717.0 | 6775.1 | 127345.0 |
| 2010-10-08 | FESX | Futures | 1733.8 | 1738.8 | 1717.5 | 1731.9 | 1159768.0 |
| 2010-10-08 | FEU3 | Futures | 97.82 | 97.82 | 97.81 | 97.82 | 25.0 |
| 2010-10-08 | FGBL | Futures | 104.14 | 104.3 | 103.69 | 104.26 | 989228.0 |
| 2010-10-08 | FGBM | Futures | 106.73 | 106.89 | 106.52 | 106.87 | 506060.0 |
| 2010-10-08 | FGBS | Futures | 107.533 | 107.573 | 107.499 | 107.568 | 361687.0 |
| 2010-10-08 | FGBX | Futures | 108.24 | 108.35 | 106.95 | 108.13 | 2470.0 |
| 2010-10-08 | FTDX | Futures | 679.1 | 680.9 | 676.5 | 679.1 | 126.0 |
| 2010-10-08 | FTI | Futures | 271.37 | 271.37 | 267.69 | 269.77 | 32186.0 |
| 2010-10-08 | FTUK | Futures | 3901.4 | 3909.0 | 3857.5 | 3895.9 | 106351.0 |
| 2010-10-08 | G | Futures | 84.82 | 85.2 | 84.7 | 85.19 | 111738.0 |
| 2010-10-08 | GF | Futures | 274.371 | 274.874 | 268.21 | 270.914 | 1485.0 |
| 2010-10-08 | GSCI | Futures | 921.07 | 943.77 | 920.16 | 938.18 | 1677.0 |
| 2010-10-08 | HE | Futures | 96.384 | 100.343 | 96.317 | 99.937 | 24729.0 |
| 2010-10-08 | HG | Futures | 4.9237 | 5.0738 | 4.8803 | 5.0378 | 41895.0 |
| 2010-10-08 | HO | Futures | 1.917 | 1.9476 | 1.8924 | 1.941 | 25826.0 |
| 2010-10-08 | HRC | Futures | 2527.3 | 2527.3 | 2527.3 | 2527.3 | 0.0 |
| 2010-10-08 | J1 | Futures | 0.0152629 | 0.0153797 | 0.0152215 | 0.0153169 | 118717.0 |
| 2010-10-08 | J7 | Futures | 0.015144 | 0.015273 | 0.01512 | 0.015212 | 261.0 |
| 2010-10-08 | JB | Futures | 122.46 | 122.81 | 122.38 | 122.77 | 1348.0 |
| 2010-10-08 | KC | Futures | 430.88 | 453.7 | 426.29 | 451.71 | 12924.0 |
| 2010-10-08 | KE | Futures | 2917.32 | 3168.68 | 2912.1 | 3164.51 | 7779.0 |
| 2010-10-08 | L | Futures | 98.165 | 98.165 | 98.155 | 98.165 | 19855.0 |
| 2010-10-08 | LBS | Futures | 659.2 | 677.8 | 657.4 | 677.8 | 1217.0 |
> showing 50 of 89 rows — these rows as CSV