PREVIEW / futures_daily / 2011-10-17
file: by_date/futures_daily/2011/2011-10-17.parquet size: 9 KB rows: 97
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 |
|---|---|---|---|---|---|---|---|
| 2011-10-17 | ES | Futures | 1216.11 | 1228.59 | 1191.41 | 1191.91 | 2385603.0 |
| 2011-10-17 | NQ | Futures | 2702.11 | 2726.37 | 2644.75 | 2649.32 | 314777.0 |
| 2011-10-17 | YM | Futures | 11104.3 | 11199.4 | 10850.6 | 10856.4 | 116582.0 |
| 2011-10-17 | CL | Futures | 164.28 | 165.84 | 161.54 | 162.5 | 167203.0 |
| 2011-10-17 | GC | Futures | 2273.4 | 2290.9 | 2248.6 | 2263.7 | 114497.0 |
| 2011-10-17 | ZN | Futures | 109.833458 | 110.477013 | 109.538495 | 110.450198 | 861280.0 |
| 2011-10-17 | A6 | Futures | 0.90128 | 0.90515 | 0.88554 | 0.8902 | 127546.0 |
| 2011-10-17 | AD | Futures | 0.98835 | 0.99465 | 0.97574 | 0.97944 | 79554.0 |
| 2011-10-17 | B | Futures | 98.32 | 99.55 | 95.93 | 96.31 | 198899.0 |
| 2011-10-17 | B6 | Futures | 1.65 | 1.6531 | 1.6407 | 1.643 | 75268.0 |
| 2011-10-17 | BFX | Futures | 2660.1 | 2660.1 | 2601.2 | 2602.5 | 264.0 |
| 2011-10-17 | BR | Futures | 0.25544 | 0.25544 | 0.25205 | 0.25465 | 17.0 |
| 2011-10-17 | BZ | Futures | 103.49 | 103.78 | 101.4 | 101.79 | 849.0 |
| 2011-10-17 | C | Futures | 1808.0 | 1813.0 | 1771.0 | 1792.0 | 5199.0 |
| 2011-10-17 | CB | Futures | 95.204 | 95.888 | 95.204 | 95.888 | 11.0 |
| 2011-10-17 | CC | Futures | 2105.0 | 2108.0 | 2036.0 | 2056.0 | 9696.0 |
| 2011-10-17 | CSC | Futures | 4.051 | 4.051 | 4.051 | 4.051 | 3.0 |
| 2011-10-17 | CT | Futures | 131.5 | 132.12 | 128.78 | 129.39 | 10989.0 |
| 2011-10-17 | DC | Futures | 28.16 | 28.85 | 27.92 | 28.66 | 323.0 |
| 2011-10-17 | DX | Futures | 75.406 | 76.117 | 75.298 | 76.012 | 24514.0 |
| 2011-10-17 | E1 | Futures | 1.47354 | 1.47905 | 1.45845 | 1.46094 | 16669.0 |
| 2011-10-17 | E6 | Futures | 1.65788 | 1.66194 | 1.63947 | 1.64162 | 282897.0 |
| 2011-10-17 | E7 | Futures | 1.6436 | 1.6476 | 1.6253 | 1.6276 | 4691.0 |
| 2011-10-17 | ED | Futures | 94.965 | 94.9698 | 94.9555 | 94.9602 | 113167.0 |
| 2011-10-17 | ER | Futures | 97.184 | 97.223 | 97.179 | 97.209 | 129545.0 |
| 2011-10-17 | EW | Futures | 856.1 | 863.5 | 829.6 | 831.5 | 28667.0 |
| 2011-10-17 | FBTP | Futures | 62.11 | 62.14 | 61.77 | 61.81 | 3645.0 |
| 2011-10-17 | FBTS | Futures | 82.048 | 82.144 | 81.952 | 81.968 | 588.0 |
| 2011-10-17 | FCE | Futures | 2332.1 | 2340.7 | 2250.3 | 2268.9 | 30366.0 |
| 2011-10-17 | FDAX | Futures | 6562.1 | 6613.7 | 6320.5 | 6372.7 | 185160.0 |
| 2011-10-17 | FESX | Futures | 1575.0 | 1587.6 | 1520.5 | 1535.8 | 1527489.0 |
| 2011-10-17 | FGBL | Futures | 107.84 | 109.2 | 107.56 | 108.92 | 895356.0 |
| 2011-10-17 | FGBM | Futures | 109.65 | 110.41 | 109.51 | 110.25 | 402631.0 |
| 2011-10-17 | FGBS | Futures | 108.741 | 109.029 | 108.741 | 108.959 | 528844.0 |
| 2011-10-17 | FGBX | Futures | 107.51 | 110.09 | 106.9 | 109.5 | 12442.0 |
| 2011-10-17 | FTDX | Futures | 639.4 | 643.5 | 613.6 | 624.2 | 288.0 |
| 2011-10-17 | FTI | Futures | 250.82 | 253.3 | 244.82 | 246.68 | 11876.0 |
| 2011-10-17 | FTUK | Futures | 3932.2 | 3962.4 | 3854.0 | 3880.2 | 111114.0 |
| 2011-10-17 | FVSA | Futures | 14188.77 | 15376.38 | 13876.25 | 15168.03 | 5816.0 |
| 2011-10-17 | FXXP | Futures | 167.4 | 168.3 | 163.7 | 164.1 | 1361.0 |
| 2011-10-17 | G | Futures | 89.58 | 90.53 | 89.47 | 90.36 | 103728.0 |
| 2011-10-17 | GF | Futures | 319.232 | 321.5 | 317.24 | 319.619 | 2002.0 |
| 2011-10-17 | GSCI | Futures | 1001.31 | 1005.86 | 988.46 | 989.95 | 208.0 |
| 2011-10-17 | HE | Futures | 115.91 | 117.163 | 114.978 | 116.585 | 21581.0 |
| 2011-10-17 | HG | Futures | 4.5488 | 4.5832 | 4.4092 | 4.4701 | 49513.0 |
| 2011-10-17 | HO | Futures | 2.4553 | 2.4795 | 2.4089 | 2.4179 | 38290.0 |
| 2011-10-17 | HRC | Futures | 2706.8 | 2706.8 | 2706.8 | 2706.8 | 0.0 |
| 2011-10-17 | J1 | Futures | 0.0163059 | 0.016419 | 0.0162343 | 0.01637 | 108127.0 |
| 2011-10-17 | J7 | Futures | 0.016197 | 0.016318 | 0.016138 | 0.016271 | 693.0 |
| 2011-10-17 | JB | Futures | 124.09 | 124.1 | 123.99 | 124.07 | 1422.0 |
> showing 50 of 97 rows — these rows as CSV