PREVIEW / futures_daily / 2011-10-07
file: by_date/futures_daily/2011/2011-10-07.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-07 | ES | Futures | 1155.22 | 1171.69 | 1142.74 | 1152.97 | 2865466.0 |
| 2011-10-07 | NQ | Futures | 2516.34 | 2542.02 | 2492.66 | 2513.2 | 354155.0 |
| 2011-10-07 | YM | Futures | 10608.6 | 10738.3 | 10550.9 | 10630.7 | 153365.0 |
| 2011-10-07 | CL | Futures | 155.69 | 158.39 | 153.41 | 156.47 | 377540.0 |
| 2011-10-07 | GC | Futures | 2232.3 | 2252.1 | 2197.5 | 2208.6 | 129495.0 |
| 2011-10-07 | ZN | Futures | 111.147383 | 111.254643 | 110.23568 | 110.59768 | 1387092.0 |
| 2011-10-07 | A6 | Futures | 0.84886 | 0.86144 | 0.84833 | 0.85308 | 171530.0 |
| 2011-10-07 | AD | Futures | 0.96263 | 0.97594 | 0.95883 | 0.96163 | 121355.0 |
| 2011-10-07 | B | Futures | 90.81 | 91.8 | 89.76 | 91.06 | 154526.0 |
| 2011-10-07 | B6 | Futures | 1.6103 | 1.6319 | 1.6088 | 1.6223 | 141028.0 |
| 2011-10-07 | BFX | Futures | 2586.0 | 2652.3 | 2583.0 | 2603.3 | 105.0 |
| 2011-10-07 | BR | Futures | 0.25117 | 0.25386 | 0.25117 | 0.25144 | 64.0 |
| 2011-10-07 | BZ | Futures | 96.52 | 96.94 | 94.89 | 96.24 | 822.0 |
| 2011-10-07 | C | Futures | 1842.0 | 1842.0 | 1807.0 | 1817.0 | 3774.0 |
| 2011-10-07 | CB | Futures | 92.601 | 93.149 | 92.601 | 92.875 | 22.0 |
| 2011-10-07 | CC | Futures | 2104.0 | 2110.0 | 2061.0 | 2079.0 | 6373.0 |
| 2011-10-07 | CSC | Futures | 4.044 | 4.069 | 4.044 | 4.069 | 8.0 |
| 2011-10-07 | CT | Futures | 132.52 | 133.62 | 130.66 | 131.48 | 4650.0 |
| 2011-10-07 | DC | Futures | 27.96 | 28.78 | 27.91 | 28.48 | 369.0 |
| 2011-10-07 | DX | Futures | 77.605 | 77.801 | 77.016 | 77.702 | 35343.0 |
| 2011-10-07 | E1 | Futures | 1.42669 | 1.4364 | 1.41554 | 1.41764 | 26146.0 |
| 2011-10-07 | E6 | Futures | 1.60457 | 1.61569 | 1.59597 | 1.59931 | 329607.0 |
| 2011-10-07 | E7 | Futures | 1.5909 | 1.6018 | 1.5824 | 1.5856 | 5749.0 |
| 2011-10-07 | ED | Futures | 94.9459 | 94.9555 | 94.9125 | 94.9173 | 183344.0 |
| 2011-10-07 | ER | Futures | 97.238 | 97.268 | 97.209 | 97.253 | 192263.0 |
| 2011-10-07 | EW | Futures | 811.3 | 821.9 | 795.4 | 804.3 | 28763.0 |
| 2011-10-07 | FBTP | Futures | 62.9 | 62.93 | 62.39 | 62.78 | 4911.0 |
| 2011-10-07 | FBTS | Futures | 82.369 | 82.417 | 82.233 | 82.417 | 1275.0 |
| 2011-10-07 | FCE | Futures | 2196.0 | 2233.8 | 2181.0 | 2210.6 | 114836.0 |
| 2011-10-07 | FDAX | Futures | 6138.1 | 6253.2 | 6095.2 | 6169.1 | 173051.0 |
| 2011-10-07 | FESX | Futures | 1490.6 | 1518.5 | 1481.3 | 1501.9 | 1407338.0 |
| 2011-10-07 | FGBL | Futures | 109.93 | 110.24 | 109.29 | 109.56 | 775304.0 |
| 2011-10-07 | FGBM | Futures | 110.38 | 110.6 | 110.03 | 110.28 | 397104.0 |
| 2011-10-07 | FGBS | Futures | 108.835 | 108.979 | 108.751 | 108.885 | 570340.0 |
| 2011-10-07 | FGBX | Futures | 111.96 | 112.36 | 110.55 | 111.39 | 4870.0 |
| 2011-10-07 | FTDX | Futures | 608.6 | 614.1 | 602.1 | 603.5 | 211.0 |
| 2011-10-07 | FTI | Futures | 237.9 | 241.27 | 235.62 | 239.52 | 45485.0 |
| 2011-10-07 | FTUK | Futures | 3798.7 | 3838.6 | 3757.5 | 3788.3 | 136630.0 |
| 2011-10-07 | FVSA | Futures | 17835.48 | 17983.4 | 17264.91 | 17581.89 | 4462.0 |
| 2011-10-07 | FXXP | Futures | 160.3 | 162.7 | 159.6 | 161.0 | 4071.0 |
| 2011-10-07 | G | Futures | 91.4 | 91.57 | 90.12 | 90.71 | 188673.0 |
| 2011-10-07 | GF | Futures | 314.945 | 317.322 | 314.435 | 316.133 | 1314.0 |
| 2011-10-07 | GSCI | Futures | 960.01 | 969.99 | 950.18 | 961.59 | 1622.0 |
| 2011-10-07 | HE | Futures | 114.175 | 115.557 | 114.143 | 114.914 | 17252.0 |
| 2011-10-07 | HG | Futures | 4.3311 | 4.4171 | 4.3113 | 4.3318 | 51946.0 |
| 2011-10-07 | HO | Futures | 2.2879 | 2.3059 | 2.2634 | 2.2902 | 25274.0 |
| 2011-10-07 | HRC | Futures | 2706.8 | 2706.8 | 2706.8 | 2706.8 | 0.0 |
| 2011-10-07 | J1 | Futures | 0.0163976 | 0.0164215 | 0.0163336 | 0.0163712 | 88400.0 |
| 2011-10-07 | J7 | Futures | 0.016304 | 0.016321 | 0.016236 | 0.016272 | 279.0 |
| 2011-10-07 | JB | Futures | 124.56 | 124.59 | 124.41 | 124.53 | 2134.0 |
> showing 50 of 97 rows — these rows as CSV