PREVIEW / futures_daily / 2011-11-18
file: by_date/futures_daily/2011/2011-11-18.parquet size: 9 KB rows: 96
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-11-18 | ES | Futures | 1212.87 | 1227.59 | 1206.63 | 1211.87 | 2178618.0 |
| 2011-11-18 | NQ | Futures | 2591.11 | 2613.94 | 2567.14 | 2567.99 | 257930.0 |
| 2011-11-18 | YM | Futures | 11279.1 | 11392.5 | 11235.9 | 11304.1 | 114426.0 |
| 2011-11-18 | CL | Futures | 184.94 | 188.03 | 181.28 | 183.1 | 341638.0 |
| 2011-11-18 | GC | Futures | 2324.3 | 2347.2 | 2310.7 | 2329.2 | 147927.0 |
| 2011-11-18 | ZN | Futures | 112.260198 | 112.35405 | 111.670272 | 111.804346 | 870981.0 |
| 2011-11-18 | A6 | Futures | 0.87657 | 0.88589 | 0.87331 | 0.87692 | 114669.0 |
| 2011-11-18 | AD | Futures | 0.97214 | 0.98034 | 0.97044 | 0.97384 | 66544.0 |
| 2011-11-18 | B | Futures | 95.18 | 97.36 | 94.69 | 95.21 | 199844.0 |
| 2011-11-18 | B6 | Futures | 1.6447 | 1.6579 | 1.642 | 1.6469 | 78187.0 |
| 2011-11-18 | BFX | Futures | 2424.5 | 2437.5 | 2399.6 | 2405.3 | 66.0 |
| 2011-11-18 | BR | Futures | 0.25187 | 0.25239 | 0.25187 | 0.25239 | 41.0 |
| 2011-11-18 | BZ | Futures | 102.32 | 102.32 | 100.01 | 100.53 | 768.0 |
| 2011-11-18 | C | Futures | 1664.0 | 1664.0 | 1623.0 | 1627.0 | 1835.0 |
| 2011-11-18 | CB | Futures | 90.409 | 90.409 | 90.409 | 90.409 | 2.0 |
| 2011-11-18 | CC | Futures | 1942.0 | 1947.0 | 1892.0 | 1906.0 | 8564.0 |
| 2011-11-18 | CSC | Futures | 4.307 | 4.361 | 4.307 | 4.329 | 30.0 |
| 2011-11-18 | CT | Futures | 127.88 | 129.12 | 122.18 | 122.23 | 5111.0 |
| 2011-11-18 | DC | Futures | 30.58 | 31.02 | 30.03 | 30.75 | 564.0 |
| 2011-11-18 | DX | Futures | 77.104 | 77.124 | 76.319 | 76.824 | 25794.0 |
| 2011-11-18 | E1 | Futures | 1.42499 | 1.44506 | 1.42315 | 1.43037 | 23355.0 |
| 2011-11-18 | E6 | Futures | 1.60947 | 1.62716 | 1.6072 | 1.61509 | 288299.0 |
| 2011-11-18 | E7 | Futures | 1.5957 | 1.6131 | 1.5936 | 1.6013 | 4521.0 |
| 2011-11-18 | ED | Futures | 94.8266 | 94.8576 | 94.8075 | 94.8409 | 263628.0 |
| 2011-11-18 | ER | Futures | 97.199 | 97.238 | 97.169 | 97.209 | 194692.0 |
| 2011-11-18 | EW | Futures | 863.7 | 875.5 | 857.9 | 863.0 | 20401.0 |
| 2011-11-18 | FBTP | Futures | 56.54 | 57.66 | 56.4 | 57.63 | 10950.0 |
| 2011-11-18 | FBTS | Futures | 78.42 | 79.271 | 78.42 | 78.982 | 1705.0 |
| 2011-11-18 | FCE | Futures | 2121.7 | 2160.6 | 2119.2 | 2139.2 | 95716.0 |
| 2011-11-18 | FDAX | Futures | 6252.1 | 6410.7 | 6248.9 | 6319.5 | 165706.0 |
| 2011-11-18 | FESX | Futures | 1467.3 | 1505.9 | 1467.3 | 1489.2 | 1326493.0 |
| 2011-11-18 | FGBL | Futures | 111.65 | 111.68 | 110.19 | 110.44 | 812651.0 |
| 2011-11-18 | FGBM | Futures | 111.83 | 111.84 | 111.12 | 111.25 | 398280.0 |
| 2011-11-18 | FGBS | Futures | 109.377 | 109.402 | 109.228 | 109.273 | 442506.0 |
| 2011-11-18 | FGBX | Futures | 115.86 | 115.86 | 113.02 | 113.63 | 4663.0 |
| 2011-11-18 | FTDX | Futures | 621.0 | 621.5 | 611.8 | 616.4 | 226.0 |
| 2011-11-18 | FTI | Futures | 240.68 | 245.77 | 240.22 | 242.15 | 41503.0 |
| 2011-11-18 | FTUK | Futures | 3849.3 | 3885.6 | 3827.4 | 3853.6 | 107616.0 |
| 2011-11-18 | FVSA | Futures | 16323.35 | 16666.1 | 16066.29 | 16259.09 | 3427.0 |
| 2011-11-18 | FXXP | Futures | 161.8 | 163.6 | 161.4 | 161.9 | 1436.0 |
| 2011-11-18 | G | Futures | 92.61 | 92.93 | 91.97 | 92.2 | 117342.0 |
| 2011-11-18 | GF | Futures | 322.573 | 322.788 | 317.349 | 317.565 | 3643.0 |
| 2011-11-18 | GSCI | Futures | 1020.99 | 1022.93 | 999.67 | 1005.49 | 301.0 |
| 2011-11-18 | HE | Futures | 111.167 | 112.215 | 110.859 | 112.153 | 14123.0 |
| 2011-11-18 | HG | Futures | 4.476 | 4.5624 | 4.4186 | 4.5116 | 7425.0 |
| 2011-11-18 | HO | Futures | 2.4846 | 2.5117 | 2.4443 | 2.446 | 10440.0 |
| 2011-11-18 | HRC | Futures | 2664.5 | 2664.5 | 2664.5 | 2664.5 | 0.0 |
| 2011-11-18 | J1 | Futures | 0.0163285 | 0.0164177 | 0.0163197 | 0.0163336 | 80848.0 |
| 2011-11-18 | J7 | Futures | 0.016234 | 0.016316 | 0.016224 | 0.016234 | 317.0 |
| 2011-11-18 | JB | Futures | 124.85 | 124.98 | 124.72 | 124.92 | 1820.0 |
> showing 50 of 96 rows — these rows as CSV