PREVIEW / futures_daily / 2010-10-15
file: by_date/futures_daily/2010/2010-10-15.parquet size: 9 KB rows: 91
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-15 | ES | Futures | 1150.71 | 1156.59 | 1139.93 | 1151.69 | 2644031.0 |
| 2010-10-15 | NQ | Futures | 2341.49 | 2378.62 | 2336.1 | 2375.5 | 374142.0 |
| 2010-10-15 | YM | Futures | 10289.4 | 10332.2 | 10191.7 | 10257.7 | 145339.0 |
| 2010-10-15 | CL | Futures | 172.15 | 173.14 | 167.84 | 168.91 | 228253.0 |
| 2010-10-15 | GC | Futures | 1878.1 | 1884.5 | 1852.3 | 1864.9 | 196829.0 |
| 2010-10-15 | ZN | Futures | 104.548317 | 104.961245 | 104.10958 | 104.251525 | 1720019.0 |
| 2010-10-15 | A6 | Futures | 0.82796 | 0.83392 | 0.822 | 0.82376 | 122103.0 |
| 2010-10-15 | AD | Futures | 0.98499 | 0.98817 | 0.97568 | 0.97647 | 106366.0 |
| 2010-10-15 | B | Futures | 72.11 | 72.52 | 70.33 | 70.76 | 213942.0 |
| 2010-10-15 | B6 | Futures | 1.6609 | 1.6714 | 1.6573 | 1.6586 | 110139.0 |
| 2010-10-15 | BFX | Futures | 3047.6 | 3048.9 | 3016.3 | 3028.7 | 95.0 |
| 2010-10-15 | BR | Futures | 0.25588 | 0.25588 | 0.25413 | 0.25535 | 58.0 |
| 2010-10-15 | BZ | Futures | 76.53 | 77.12 | 74.79 | 75.24 | 1214.0 |
| 2010-10-15 | C | Futures | 2068.0 | 2076.0 | 2016.0 | 2019.0 | 4455.0 |
| 2010-10-15 | CC | Futures | 2380.0 | 2401.0 | 2313.0 | 2322.0 | 7315.0 |
| 2010-10-15 | CSC | Futures | 3.64 | 3.64 | 3.633 | 3.64 | 1.0 |
| 2010-10-15 | CT | Futures | 100.3 | 101.4 | 93.0 | 93.0 | 18931.0 |
| 2010-10-15 | DC | Futures | 25.22 | 25.47 | 24.47 | 24.62 | 383.0 |
| 2010-10-15 | DX | Futures | 77.22 | 77.601 | 76.578 | 77.514 | 37711.0 |
| 2010-10-15 | E1 | Futures | 1.37831 | 1.38514 | 1.36781 | 1.36886 | 44870.0 |
| 2010-10-15 | E6 | Futures | 1.66429 | 1.67447 | 1.64761 | 1.65057 | 459984.0 |
| 2010-10-15 | E7 | Futures | 1.6517 | 1.6613 | 1.635 | 1.638 | 7150.0 |
| 2010-10-15 | ED | Futures | 94.7221 | 94.7411 | 94.7126 | 94.7173 | 217994.0 |
| 2010-10-15 | ER | Futures | 97.232 | 97.242 | 97.222 | 97.227 | 111803.0 |
| 2010-10-15 | EW | Futures | 806.5 | 811.3 | 797.8 | 805.2 | 29303.0 |
| 2010-10-15 | FBTP | Futures | 67.97 | 68.09 | 67.91 | 67.95 | 5643.0 |
| 2010-10-15 | FCE | Futures | 2533.6 | 2541.3 | 2514.3 | 2533.3 | 146791.0 |
| 2010-10-15 | FDAX | Futures | 6976.2 | 7016.6 | 6934.3 | 6981.1 | 161380.0 |
| 2010-10-15 | FESX | Futures | 1769.4 | 1775.6 | 1753.1 | 1765.0 | 1469137.0 |
| 2010-10-15 | FEU3 | Futures | 97.795 | 97.8 | 97.79 | 97.79 | 17.0 |
| 2010-10-15 | FGBL | Futures | 103.68 | 103.82 | 103.07 | 103.37 | 1001932.0 |
| 2010-10-15 | FGBM | Futures | 106.71 | 106.84 | 106.39 | 106.64 | 479118.0 |
| 2010-10-15 | FGBS | Futures | 107.543 | 107.583 | 107.425 | 107.533 | 399796.0 |
| 2010-10-15 | FGBX | Futures | 106.25 | 106.66 | 105.23 | 105.92 | 5282.0 |
| 2010-10-15 | FTDX | Futures | 712.6 | 713.9 | 707.3 | 710.4 | 285.0 |
| 2010-10-15 | FTI | Futures | 273.17 | 274.14 | 271.29 | 272.89 | 39110.0 |
| 2010-10-15 | FTUK | Futures | 3943.9 | 3959.8 | 3900.7 | 3924.2 | 109471.0 |
| 2010-10-15 | G | Futures | 84.79 | 85.09 | 84.55 | 84.7 | 123895.0 |
| 2010-10-15 | GF | Futures | 273.809 | 277.837 | 273.746 | 275.383 | 3188.0 |
| 2010-10-15 | GSCI | Futures | 938.59 | 945.36 | 925.3 | 926.29 | 308.0 |
| 2010-10-15 | HE | Futures | 93.475 | 93.949 | 92.798 | 93.238 | 14101.0 |
| 2010-10-15 | HG | Futures | 5.0825 | 5.1579 | 5.0645 | 5.1239 | 41298.0 |
| 2010-10-15 | HO | Futures | 1.9431 | 1.9512 | 1.8877 | 1.8977 | 36978.0 |
| 2010-10-15 | HRC | Futures | 2549.8 | 2549.8 | 2549.8 | 2549.8 | 0.0 |
| 2010-10-15 | J1 | Futures | 0.0154287 | 0.0155405 | 0.0153973 | 0.01543 | 111256.0 |
| 2010-10-15 | J7 | Futures | 0.015319 | 0.015431 | 0.015292 | 0.015324 | 318.0 |
| 2010-10-15 | JB | Futures | 122.52 | 122.58 | 122.4 | 122.57 | 1031.0 |
| 2010-10-15 | KC | Futures | 465.48 | 469.57 | 454.44 | 462.25 | 8474.0 |
| 2010-10-15 | KE | Futures | 3090.46 | 3148.87 | 3063.34 | 3108.19 | 10425.0 |
| 2010-10-15 | L | Futures | 98.145 | 98.165 | 98.145 | 98.145 | 37412.0 |
> showing 50 of 91 rows — these rows as CSV