PREVIEW / futures_daily / 2011-11-01
file: by_date/futures_daily/2011/2011-11-01.parquet size: 9 KB rows: 98
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-01 | ES | Futures | 1245.31 | 1245.81 | 1206.38 | 1222.35 | 3666184.0 |
| 2011-11-01 | NQ | Futures | 2686.13 | 2688.99 | 2605.66 | 2629.34 | 445641.0 |
| 2011-11-01 | YM | Futures | 11441.5 | 11448.2 | 11114.8 | 11222.4 | 185319.0 |
| 2011-11-01 | CL | Futures | 173.68 | 174.24 | 167.28 | 172.95 | 351343.0 |
| 2011-11-01 | GC | Futures | 2316.5 | 2329.8 | 2269.9 | 2311.2 | 174289.0 |
| 2011-11-01 | ZN | Futures | 111.107161 | 112.032272 | 110.892643 | 111.764124 | 1749685.0 |
| 2011-11-01 | A6 | Futures | 0.92177 | 0.92406 | 0.89802 | 0.90471 | 193507.0 |
| 2011-11-01 | AD | Futures | 0.99975 | 1.00195 | 0.97904 | 0.98254 | 121183.0 |
| 2011-11-01 | B | Futures | 95.86 | 96.16 | 93.13 | 95.93 | 125712.0 |
| 2011-11-01 | B6 | Futures | 1.6786 | 1.6793 | 1.6577 | 1.6652 | 128152.0 |
| 2011-11-01 | BFX | Futures | 2507.6 | 2507.6 | 2447.9 | 2447.9 | 299.0 |
| 2011-11-01 | BR | Futures | 0.26212 | 0.26212 | 0.25503 | 0.2581 | 990.0 |
| 2011-11-01 | BZ | Futures | 99.63 | 101.3 | 98.7 | 101.3 | 1038.0 |
| 2011-11-01 | C | Futures | 1756.0 | 1760.0 | 1721.0 | 1724.0 | 6745.0 |
| 2011-11-01 | CB | Futures | 92.053 | 93.697 | 92.053 | 93.697 | 1.0 |
| 2011-11-01 | CC | Futures | 2091.0 | 2091.0 | 2018.0 | 2039.0 | 13975.0 |
| 2011-11-01 | CSC | Futures | 4.154 | 4.154 | 4.154 | 4.154 | 2.0 |
| 2011-11-01 | CT | Futures | 132.47 | 132.47 | 127.34 | 128.33 | 18523.0 |
| 2011-11-01 | DC | Futures | 29.4 | 29.79 | 29.39 | 29.67 | 178.0 |
| 2011-11-01 | DX | Futures | 75.229 | 76.417 | 75.194 | 75.975 | 37507.0 |
| 2011-11-01 | E1 | Futures | 1.49834 | 1.4986 | 1.4654 | 1.48167 | 30478.0 |
| 2011-11-01 | E6 | Futures | 1.65597 | 1.65728 | 1.62597 | 1.63828 | 432717.0 |
| 2011-11-01 | E7 | Futures | 1.6416 | 1.643 | 1.6122 | 1.6243 | 5722.0 |
| 2011-11-01 | ED | Futures | 94.9889 | 94.9936 | 94.9459 | 94.9793 | 249936.0 |
| 2011-11-01 | ER | Futures | 97.223 | 97.307 | 97.218 | 97.273 | 179495.0 |
| 2011-11-01 | EW | Futures | 885.9 | 889.3 | 853.1 | 866.6 | 61140.0 |
| 2011-11-01 | FBTP | Futures | 60.37 | 60.37 | 59.13 | 60.03 | 11103.0 |
| 2011-11-01 | FBTS | Futures | 80.764 | 80.764 | 79.624 | 80.451 | 2385.0 |
| 2011-11-01 | FCE | Futures | 2303.7 | 2303.7 | 2190.7 | 2200.0 | 148341.0 |
| 2011-11-01 | FDAX | Futures | 6563.8 | 6563.8 | 6262.4 | 6341.7 | 256382.0 |
| 2011-11-01 | FESX | Futures | 1549.1 | 1550.4 | 1484.6 | 1496.6 | 2108905.0 |
| 2011-11-01 | FEU3 | Futures | 97.826 | 97.836 | 97.826 | 97.836 | 998.0 |
| 2011-11-01 | FGBL | Futures | 110.84 | 112.09 | 110.69 | 111.77 | 1042929.0 |
| 2011-11-01 | FGBM | Futures | 111.49 | 112.03 | 111.25 | 111.87 | 546888.0 |
| 2011-11-01 | FGBS | Futures | 109.178 | 109.352 | 109.109 | 109.302 | 841795.0 |
| 2011-11-01 | FGBX | Futures | 112.69 | 114.84 | 112.18 | 114.03 | 5077.0 |
| 2011-11-01 | FTDX | Futures | 636.2 | 636.2 | 613.6 | 617.8 | 252.0 |
| 2011-11-01 | FTI | Futures | 250.28 | 250.36 | 241.22 | 244.28 | 62771.0 |
| 2011-11-01 | FTUK | Futures | 3946.2 | 3946.2 | 3812.7 | 3868.3 | 193206.0 |
| 2011-11-01 | FVSA | Futures | 15022.18 | 16980.69 | 15022.18 | 16584.82 | 4182.0 |
| 2011-11-01 | FXXP | Futures | 165.4 | 165.4 | 162.3 | 163.5 | 1584.0 |
| 2011-11-01 | G | Futures | 91.75 | 92.79 | 91.5 | 92.53 | 158470.0 |
| 2011-11-01 | GF | Futures | 309.826 | 316.133 | 308.166 | 316.133 | 1769.0 |
| 2011-11-01 | GSCI | Futures | 986.27 | 1008.29 | 984.23 | 1004.45 | 346.0 |
| 2011-11-01 | HE | Futures | 112.568 | 114.271 | 111.315 | 112.536 | 17032.0 |
| 2011-11-01 | HG | Futures | 4.7764 | 4.8393 | 4.5812 | 4.6348 | 52924.0 |
| 2011-11-01 | HO | Futures | 2.4467 | 2.4518 | 2.3856 | 2.4402 | 66828.0 |
| 2011-11-01 | HRC | Futures | 2685.6 | 2685.6 | 2685.6 | 2685.6 | 0.0 |
| 2011-11-01 | J1 | Futures | 0.0161112 | 0.0161225 | 0.0159152 | 0.0160609 | 108838.0 |
| 2011-11-01 | J7 | Futures | 0.016027 | 0.016027 | 0.015821 | 0.015963 | 524.0 |
> showing 50 of 98 rows — these rows as CSV