PREVIEW / futures_daily / 2011-07-08
file: by_date/futures_daily/2011/2011-07-08.parquet size: 9 KB rows: 95
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-07-08 | ES | Futures | 1342.22 | 1345.2 | 1320.12 | 1332.54 | 2253551.0 |
| 2011-07-08 | NQ | Futures | 2750.39 | 2757.79 | 2705.4 | 2742.7 | 283491.0 |
| 2011-07-08 | YM | Futures | 11984.9 | 12027.4 | 11827.0 | 11926.3 | 122904.0 |
| 2011-07-08 | CL | Futures | 189.56 | 190.31 | 183.44 | 184.59 | 347999.0 |
| 2011-07-08 | GC | Futures | 2074.1 | 2092.4 | 2064.0 | 2086.4 | 159728.0 |
| 2011-07-08 | ZN | Futures | 104.337594 | 105.521736 | 104.058189 | 105.348771 | 1756412.0 |
| 2011-07-08 | A6 | Futures | 0.92874 | 0.93014 | 0.92274 | 0.92613 | 114141.0 |
| 2011-07-08 | AD | Futures | 1.03878 | 1.04167 | 1.03069 | 1.03628 | 90475.0 |
| 2011-07-08 | B | Futures | 100.71 | 101.69 | 99.15 | 100.35 | 152196.0 |
| 2011-07-08 | B6 | Futures | 1.6601 | 1.6714 | 1.6558 | 1.6662 | 134967.0 |
| 2011-07-08 | BFX | Futures | 3053.9 | 3059.9 | 2998.2 | 2998.2 | 23.0 |
| 2011-07-08 | BR | Futures | 0.28107 | 0.28154 | 0.28107 | 0.28154 | 24.0 |
| 2011-07-08 | BZ | Futures | 104.18 | 104.3 | 103.48 | 104.22 | 1374.0 |
| 2011-07-08 | C | Futures | 2161.0 | 2184.0 | 2088.0 | 2094.0 | 3944.0 |
| 2011-07-08 | CC | Futures | 2534.0 | 2545.0 | 2444.0 | 2450.0 | 10535.0 |
| 2011-07-08 | CSC | Futures | 4.509 | 4.509 | 4.509 | 4.509 | 3.0 |
| 2011-07-08 | CT | Futures | 151.83 | 154.86 | 150.65 | 151.29 | 40.0 |
| 2011-07-08 | DC | Futures | 30.68 | 30.93 | 30.64 | 30.82 | 135.0 |
| 2011-07-08 | DX | Futures | 74.489 | 74.999 | 74.405 | 74.785 | 32049.0 |
| 2011-07-08 | E1 | Futures | 1.54902 | 1.56524 | 1.53516 | 1.56419 | 60100.0 |
| 2011-07-08 | E6 | Futures | 1.70195 | 1.70314 | 1.68366 | 1.68818 | 369874.0 |
| 2011-07-08 | E7 | Futures | 1.6893 | 1.6906 | 1.6714 | 1.6758 | 6236.0 |
| 2011-07-08 | ED | Futures | 94.9525 | 94.9525 | 94.9287 | 94.943 | 207448.0 |
| 2011-07-08 | ER | Futures | 97.262 | 97.291 | 97.257 | 97.281 | 129551.0 |
| 2011-07-08 | EW | Futures | 1001.5 | 1005.2 | 985.7 | 995.6 | 18192.0 |
| 2011-07-08 | FBTP | Futures | 63.19 | 63.24 | 62.33 | 62.77 | 21635.0 |
| 2011-07-08 | FCE | Futures | 2777.5 | 2782.0 | 2717.0 | 2721.2 | 147650.0 |
| 2011-07-08 | FDAX | Futures | 8040.0 | 8064.0 | 7918.7 | 7935.8 | 149262.0 |
| 2011-07-08 | FESX | Futures | 1834.4 | 1838.3 | 1787.0 | 1791.5 | 1601919.0 |
| 2011-07-08 | FEU3 | Futures | 97.805 | 97.82 | 97.8 | 97.82 | 330.0 |
| 2011-07-08 | FGBL | Futures | 101.1 | 102.28 | 100.96 | 102.24 | 1172025.0 |
| 2011-07-08 | FGBM | Futures | 105.34 | 106.13 | 105.23 | 106.11 | 683346.0 |
| 2011-07-08 | FGBS | Futures | 107.045 | 107.328 | 107.005 | 107.318 | 772826.0 |
| 2011-07-08 | FGBX | Futures | 96.05 | 98.44 | 95.87 | 98.06 | 7538.0 |
| 2011-07-08 | FTDX | Futures | 811.8 | 814.5 | 801.6 | 802.9 | 429.0 |
| 2011-07-08 | FTI | Futures | 284.03 | 284.81 | 280.17 | 281.2 | 40511.0 |
| 2011-07-08 | FTUK | Futures | 4253.5 | 4266.9 | 4193.2 | 4201.3 | 123435.0 |
| 2011-07-08 | FXXP | Futures | 187.2 | 187.5 | 184.8 | 185.2 | 1174.0 |
| 2011-07-08 | G | Futures | 84.36 | 85.24 | 84.36 | 85.17 | 132717.0 |
| 2011-07-08 | GF | Futures | 334.311 | 336.751 | 333.033 | 333.73 | 4142.0 |
| 2011-07-08 | GSCI | Futures | 1088.42 | 1093.24 | 1075.1 | 1082.12 | 1588.0 |
| 2011-07-08 | HE | Futures | 105.235 | 106.419 | 104.959 | 105.951 | 25042.0 |
| 2011-07-08 | HG | Futures | 5.8516 | 5.8913 | 5.7842 | 5.8324 | 40937.0 |
| 2011-07-08 | HO | Futures | 2.5208 | 2.5471 | 2.4936 | 2.5164 | 28032.0 |
| 2011-07-08 | HRC | Futures | 2947.4 | 3031.0 | 2947.4 | 3031.0 | 1.0 |
| 2011-07-08 | J1 | Futures | 0.0154864 | 0.0156222 | 0.0153884 | 0.0155958 | 133170.0 |
| 2011-07-08 | J7 | Futures | 0.015363 | 0.015515 | 0.015276 | 0.015492 | 423.0 |
| 2011-07-08 | JB | Futures | 122.48 | 122.51 | 122.34 | 122.37 | 1313.0 |
| 2011-07-08 | KC | Futures | 635.44 | 639.34 | 621.48 | 622.9 | 8096.0 |
| 2011-07-08 | KE | Futures | 2780.89 | 2824.1 | 2761.68 | 2793.37 | 10831.0 |
> showing 50 of 95 rows — these rows as CSV