PREVIEW / futures_daily / 2010-06-23
file: by_date/futures_daily/2010/2010-06-23.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-06-23 | ES | Futures | 1063.87 | 1070.69 | 1053.63 | 1060.7 | 2235636.0 |
| 2010-06-23 | NQ | Futures | 2126.42 | 2139.15 | 2102.65 | 2120.76 | 321722.0 |
| 2010-06-23 | YM | Futures | 9461.3 | 9531.6 | 9399.4 | 9466.9 | 155006.0 |
| 2010-06-23 | CL | Futures | 165.57 | 166.23 | 160.55 | 163.07 | 365038.0 |
| 2010-06-23 | GC | Futures | 1692.3 | 1701.5 | 1671.2 | 1684.3 | 138832.0 |
| 2010-06-23 | ZN | Futures | 99.082095 | 99.581539 | 98.979645 | 99.466283 | 1135193.0 |
| 2010-06-23 | A6 | Futures | 0.71571 | 0.72101 | 0.71107 | 0.71728 | 132524.0 |
| 2010-06-23 | AD | Futures | 0.95923 | 0.9609 | 0.94362 | 0.95034 | 108725.0 |
| 2010-06-23 | B | Futures | 68.43 | 68.6 | 66.28 | 66.92 | 159099.0 |
| 2010-06-23 | B6 | Futures | 1.5363 | 1.5539 | 1.5361 | 1.5529 | 128499.0 |
| 2010-06-23 | BFX | Futures | 2865.4 | 2879.6 | 2843.7 | 2847.5 | 77.0 |
| 2010-06-23 | BR | Futures | 0.22948 | 0.22948 | 0.22948 | 0.22948 | 246.0 |
| 2010-06-23 | BZ | Futures | 73.74 | 73.74 | 71.64 | 72.18 | 351.0 |
| 2010-06-23 | C | Futures | 2495.0 | 2502.0 | 2470.0 | 2484.0 | 1857.0 |
| 2010-06-23 | CB | Futures | 82.811 | 82.811 | 82.811 | 82.811 | 2.0 |
| 2010-06-23 | CC | Futures | 2548.0 | 2560.0 | 2511.0 | 2555.0 | 5693.0 |
| 2010-06-23 | CSC | Futures | 3.581 | 3.581 | 3.581 | 3.581 | 2.0 |
| 2010-06-23 | CT | Futures | 65.66 | 67.12 | 65.34 | 67.12 | 2351.0 |
| 2010-06-23 | DC | Futures | 21.91 | 22.06 | 21.86 | 22.0 | 195.0 |
| 2010-06-23 | DX | Futures | 87.084 | 87.396 | 86.585 | 86.729 | 24321.0 |
| 2010-06-23 | E1 | Futures | 1.18777 | 1.19381 | 1.18094 | 1.19211 | 42617.0 |
| 2010-06-23 | E6 | Futures | 1.45187 | 1.46062 | 1.44453 | 1.4579 | 312742.0 |
| 2010-06-23 | E7 | Futures | 1.4412 | 1.45 | 1.4341 | 1.4474 | 3836.0 |
| 2010-06-23 | ED | Futures | 94.2616 | 94.2711 | 94.1999 | 94.2332 | 269881.0 |
| 2010-06-23 | ER | Futures | 97.296 | 97.296 | 97.276 | 97.281 | 84589.0 |
| 2010-06-23 | EW | Futures | 734.4 | 739.8 | 723.7 | 731.8 | 26965.0 |
| 2010-06-23 | FBTP | Futures | 64.97 | 65.02 | 64.8 | 64.94 | 3546.0 |
| 2010-06-23 | FCE | Futures | 2410.2 | 2430.0 | 2382.9 | 2394.1 | 157734.0 |
| 2010-06-23 | FDAX | Futures | 6779.7 | 6830.8 | 6727.5 | 6760.7 | 155111.0 |
| 2010-06-23 | FESX | Futures | 1677.3 | 1694.7 | 1662.5 | 1674.2 | 1265017.0 |
| 2010-06-23 | FEU3 | Futures | 97.845 | 97.845 | 97.835 | 97.84 | 124.0 |
| 2010-06-23 | FGBL | Futures | 100.24 | 100.49 | 100.12 | 100.45 | 704379.0 |
| 2010-06-23 | FGBM | Futures | 104.91 | 105.12 | 104.87 | 105.07 | 389301.0 |
| 2010-06-23 | FGBS | Futures | 107.618 | 107.677 | 107.583 | 107.613 | 395098.0 |
| 2010-06-23 | FGBX | Futures | 98.97 | 99.44 | 98.63 | 99.15 | 2662.0 |
| 2010-06-23 | FTDX | Futures | 683.1 | 688.4 | 680.0 | 683.6 | 194.0 |
| 2010-06-23 | FTI | Futures | 266.38 | 268.71 | 264.4 | 265.78 | 33520.0 |
| 2010-06-23 | FTUK | Futures | 3554.7 | 3588.8 | 3531.7 | 3547.5 | 106398.0 |
| 2010-06-23 | G | Futures | 80.94 | 80.95 | 80.43 | 80.69 | 85162.0 |
| 2010-06-23 | GF | Futures | 281.792 | 284.129 | 281.476 | 282.676 | 958.0 |
| 2010-06-23 | GSCI | Futures | 866.6 | 866.6 | 850.2 | 856.35 | 362.0 |
| 2010-06-23 | HE | Futures | 102.291 | 102.573 | 101.478 | 101.916 | 4189.0 |
| 2010-06-23 | HG | Futures | 3.9843 | 4.0339 | 3.9301 | 3.9569 | 18263.0 |
| 2010-06-23 | HO | Futures | 1.8802 | 1.8915 | 1.8336 | 1.8499 | 11727.0 |
| 2010-06-23 | HRC | Futures | 2994.3 | 2994.3 | 2994.3 | 2994.3 | 0.0 |
| 2010-06-23 | J1 | Futures | 0.0139209 | 0.0140405 | 0.0139058 | 0.0140241 | 115414.0 |
| 2010-06-23 | J7 | Futures | 0.013804 | 0.013932 | 0.013804 | 0.013919 | 129.0 |
| 2010-06-23 | JB | Futures | 119.93 | 120.11 | 119.93 | 119.99 | 1487.0 |
| 2010-06-23 | KC | Futures | 402.57 | 405.46 | 398.93 | 403.07 | 10589.0 |
| 2010-06-23 | KE | Futures | 2143.3 | 2178.08 | 2140.04 | 2151.99 | 11089.0 |
> showing 50 of 91 rows — these rows as CSV