PREVIEW / futures_daily / 2011-08-29
file: by_date/futures_daily/2011/2011-08-29.parquet size: 9 KB rows: 92
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-08-29 | ES | Futures | 1167.43 | 1200.45 | 1164.2 | 1199.71 | 1832857.0 |
| 2011-08-29 | NQ | Futures | 2464.27 | 2533.74 | 2457.44 | 2528.04 | 198317.0 |
| 2011-08-29 | YM | Futures | 10650.9 | 10897.7 | 10632.0 | 10888.2 | 86289.0 |
| 2011-08-29 | CL | Futures | 162.54 | 166.9 | 162.12 | 166.24 | 208605.0 |
| 2011-08-29 | GC | Futures | 2484.3 | 2486.3 | 2400.7 | 2418.9 | 186016.0 |
| 2011-08-29 | ZN | Futures | 110.88364 | 110.923555 | 110.191781 | 110.457881 | 1315040.0 |
| 2011-08-29 | A6 | Futures | 0.91657 | 0.92492 | 0.91631 | 0.92292 | 65128.0 |
| 2011-08-29 | AD | Futures | 1.01523 | 1.02421 | 1.01403 | 1.01932 | 66125.0 |
| 2011-08-29 | B | Futures | 94.73 | 96.22 | 94.39 | 95.5 | 28590.0 |
| 2011-08-29 | B6 | Futures | 1.6999 | 1.7114 | 1.699 | 1.7066 | 57469.0 |
| 2011-08-29 | BFX | Futures | 2645.1 | 2662.5 | 2645.1 | 2657.0 | 84.0 |
| 2011-08-29 | BR | Futures | 0.27938 | 0.27985 | 0.27915 | 0.27985 | 648.0 |
| 2011-08-29 | BZ | Futures | 98.44 | 99.37 | 98.44 | 98.93 | 959.0 |
| 2011-08-29 | CB | Futures | 101.368 | 101.368 | 101.368 | 101.368 | 22.0 |
| 2011-08-29 | CC | Futures | 2423.0 | 2464.0 | 2421.0 | 2458.0 | 6202.0 |
| 2011-08-29 | CT | Futures | 133.8 | 136.79 | 133.8 | 135.96 | 10.0 |
| 2011-08-29 | DC | Futures | 30.28 | 30.46 | 30.21 | 30.3 | 92.0 |
| 2011-08-29 | DX | Futures | 73.073 | 73.197 | 72.855 | 73.065 | 13322.0 |
| 2011-08-29 | E1 | Futures | 1.62161 | 1.62226 | 1.58812 | 1.60526 | 26835.0 |
| 2011-08-29 | E6 | Futures | 1.72096 | 1.72844 | 1.71763 | 1.7225 | 164570.0 |
| 2011-08-29 | E7 | Futures | 1.7079 | 1.7212 | 1.7052 | 1.7099 | 2693.0 |
| 2011-08-29 | ED | Futures | 94.9334 | 94.9382 | 94.9263 | 94.9311 | 73861.0 |
| 2011-08-29 | ER | Futures | 97.494 | 97.504 | 97.474 | 97.474 | 35659.0 |
| 2011-08-29 | EW | Futures | 825.5 | 860.8 | 825.0 | 858.9 | 25689.0 |
| 2011-08-29 | FBTP | Futures | 64.31 | 64.44 | 64.23 | 64.4 | 1345.0 |
| 2011-08-29 | FCE | Futures | 2193.4 | 2229.9 | 2184.6 | 2210.2 | 46836.0 |
| 2011-08-29 | FDAX | Futures | 6023.7 | 6110.3 | 5970.8 | 6065.4 | 98531.0 |
| 2011-08-29 | FESX | Futures | 1425.9 | 1448.3 | 1416.9 | 1434.8 | 599608.0 |
| 2011-08-29 | FEU3 | Futures | 98.039 | 98.039 | 98.014 | 98.014 | 26.0 |
| 2011-08-29 | FGBL | Futures | 108.15 | 108.43 | 107.64 | 107.81 | 325828.0 |
| 2011-08-29 | FGBM | Futures | 109.82 | 110.01 | 109.39 | 109.51 | 209461.0 |
| 2011-08-29 | FGBS | Futures | 108.86 | 108.929 | 108.651 | 108.701 | 284939.0 |
| 2011-08-29 | FGBX | Futures | 106.61 | 106.87 | 105.14 | 105.45 | 2228.0 |
| 2011-08-29 | FTDX | Futures | 634.1 | 658.2 | 634.1 | 652.9 | 234.0 |
| 2011-08-29 | FTI | Futures | 229.64 | 231.6 | 227.16 | 229.56 | 20850.0 |
| 2011-08-29 | FVSA | Futures | 14863.92 | 14902.73 | 14184.76 | 14262.38 | 2889.0 |
| 2011-08-29 | FXXP | Futures | 154.3 | 155.9 | 153.8 | 155.3 | 1575.0 |
| 2011-08-29 | GF | Futures | 304.924 | 305.955 | 302.234 | 302.978 | 675.0 |
| 2011-08-29 | GSCI | Futures | 1040.04 | 1043.02 | 1036.13 | 1036.13 | 239.0 |
| 2011-08-29 | HE | Futures | 106.779 | 106.779 | 105.252 | 105.527 | 12968.0 |
| 2011-08-29 | HG | Futures | 5.4513 | 5.4691 | 5.393 | 5.438 | 19015.0 |
| 2011-08-29 | HO | Futures | 2.4209 | 2.4573 | 2.417 | 2.4353 | 9411.0 |
| 2011-08-29 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-08-29 | J1 | Futures | 0.0163851 | 0.0164165 | 0.016321 | 0.0163462 | 59473.0 |
| 2011-08-29 | J7 | Futures | 0.016283 | 0.016306 | 0.016214 | 0.016237 | 251.0 |
| 2011-08-29 | JB | Futures | 123.98 | 124.17 | 123.84 | 124.17 | 1821.0 |
| 2011-08-29 | KC | Futures | 659.57 | 671.0 | 659.57 | 670.29 | 8048.0 |
| 2011-08-29 | KE | Futures | 3321.42 | 3368.21 | 3313.0 | 3365.4 | 21644.0 |
| 2011-08-29 | KRW | Futures | 0.0009116 | 0.0009116 | 0.0009116 | 0.0009116 | 1.0 |
| 2011-08-29 | LBS | Futures | 484.1 | 487.6 | 475.8 | 480.2 | 222.0 |
> showing 50 of 92 rows — these rows as CSV