PREVIEW / futures_daily / 2011-08-11
file: by_date/futures_daily/2011/2011-08-11.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-08-11 | ES | Futures | 1115.29 | 1175.87 | 1095.43 | 1160.48 | 4482222.0 |
| 2011-08-11 | NQ | Futures | 2371.75 | 2487.62 | 2342.99 | 2457.44 | 421381.0 |
| 2011-08-11 | YM | Futures | 10138.5 | 10629.2 | 10001.4 | 10478.9 | 241447.0 |
| 2011-08-11 | CL | Futures | 157.05 | 164.76 | 155.29 | 164.28 | 502092.0 |
| 2011-08-11 | GC | Futures | 2427.6 | 2454.0 | 2341.8 | 2364.8 | 347101.0 |
| 2011-08-11 | ZN | Futures | 110.91025 | 111.003385 | 109.845852 | 110.032122 | 1855590.0 |
| 2011-08-11 | A6 | Futures | 0.87977 | 0.89699 | 0.87534 | 0.89221 | 216034.0 |
| 2011-08-11 | AD | Futures | 1.00215 | 1.01303 | 1.00025 | 1.01073 | 141542.0 |
| 2011-08-11 | B | Futures | 89.82 | 92.38 | 89.19 | 92.23 | 149772.0 |
| 2011-08-11 | B6 | Futures | 1.6775 | 1.6892 | 1.6754 | 1.6861 | 114327.0 |
| 2011-08-11 | BR | Futures | 0.2706 | 0.27394 | 0.2706 | 0.27285 | 1053.0 |
| 2011-08-11 | BZ | Futures | 92.72 | 95.26 | 92.36 | 95.26 | 1030.0 |
| 2011-08-11 | C | Futures | 1992.0 | 1996.0 | 1975.0 | 1985.0 | 4426.0 |
| 2011-08-11 | CB | Futures | 108.491 | 108.491 | 108.491 | 108.491 | 14.0 |
| 2011-08-11 | CC | Futures | 2251.0 | 2272.0 | 2232.0 | 2263.0 | 15760.0 |
| 2011-08-11 | CSC | Futures | 4.791 | 4.791 | 4.681 | 4.681 | 11.0 |
| 2011-08-11 | CT | Futures | 129.12 | 129.25 | 126.22 | 126.91 | 20.0 |
| 2011-08-11 | DC | Futures | 32.78 | 32.91 | 31.76 | 31.76 | 845.0 |
| 2011-08-11 | DX | Futures | 74.286 | 74.663 | 73.732 | 74.088 | 34059.0 |
| 2011-08-11 | E1 | Futures | 1.80261 | 1.81072 | 1.70361 | 1.71551 | 83069.0 |
| 2011-08-11 | E6 | Futures | 1.68141 | 1.6972 | 1.6744 | 1.68746 | 448990.0 |
| 2011-08-11 | E7 | Futures | 1.6692 | 1.6847 | 1.6623 | 1.6751 | 4820.0 |
| 2011-08-11 | ED | Futures | 94.9049 | 94.9382 | 94.8572 | 94.8953 | 468871.0 |
| 2011-08-11 | ER | Futures | 97.697 | 97.707 | 97.633 | 97.653 | 231357.0 |
| 2011-08-11 | EW | Futures | 791.6 | 840.8 | 774.7 | 827.3 | 51042.0 |
| 2011-08-11 | FBTP | Futures | 63.72 | 64.26 | 63.47 | 64.03 | 10820.0 |
| 2011-08-11 | FCE | Futures | 2166.3 | 2225.9 | 2035.9 | 2174.5 | 352635.0 |
| 2011-08-11 | FDAX | Futures | 6166.4 | 6359.2 | 5867.7 | 6210.7 | 288001.0 |
| 2011-08-11 | FESX | Futures | 1415.6 | 1452.8 | 1327.7 | 1421.4 | 3568200.0 |
| 2011-08-11 | FEU3 | Futures | 98.203 | 98.233 | 98.188 | 98.193 | 78.0 |
| 2011-08-11 | FGBL | Futures | 107.3 | 107.93 | 106.52 | 106.93 | 1141867.0 |
| 2011-08-11 | FGBM | Futures | 109.35 | 109.85 | 108.94 | 109.16 | 729132.0 |
| 2011-08-11 | FGBS | Futures | 108.929 | 109.113 | 108.79 | 108.885 | 762980.0 |
| 2011-08-11 | FGBX | Futures | 106.03 | 106.71 | 103.93 | 104.86 | 7053.0 |
| 2011-08-11 | FTDX | Futures | 633.2 | 652.0 | 610.9 | 640.8 | 568.0 |
| 2011-08-11 | FTI | Futures | 230.26 | 236.42 | 220.22 | 230.46 | 424.0 |
| 2011-08-11 | FTUK | Futures | 3502.2 | 3723.0 | 3475.0 | 3633.4 | 246038.0 |
| 2011-08-11 | FXXP | Futures | 154.3 | 155.9 | 148.6 | 155.1 | 4183.0 |
| 2011-08-11 | G | Futures | 89.64 | 90.18 | 89.48 | 89.92 | 159991.0 |
| 2011-08-11 | GF | Futures | 308.588 | 314.484 | 307.5 | 312.08 | 3085.0 |
| 2011-08-11 | GSCI | Futures | 990.0 | 1009.5 | 980.84 | 1009.5 | 1966.0 |
| 2011-08-11 | HE | Futures | 106.382 | 108.519 | 105.71 | 107.603 | 20432.0 |
| 2011-08-11 | HG | Futures | 5.1404 | 5.3823 | 5.0974 | 5.299 | 55858.0 |
| 2011-08-11 | HO | Futures | 2.3051 | 2.3527 | 2.2872 | 2.3472 | 66383.0 |
| 2011-08-11 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-11 | J1 | Futures | 0.0163751 | 0.0164995 | 0.0162858 | 0.0163612 | 135577.0 |
| 2011-08-11 | J7 | Futures | 0.016263 | 0.016383 | 0.016179 | 0.016252 | 1021.0 |
| 2011-08-11 | JB | Futures | 123.93 | 124.11 | 123.64 | 123.64 | 2880.0 |
| 2011-08-11 | KC | Futures | 556.19 | 571.92 | 554.18 | 569.79 | 17079.0 |
| 2011-08-11 | KE | Futures | 3005.59 | 3161.15 | 2999.83 | 3103.53 | 16026.0 |
> showing 50 of 96 rows — these rows as CSV