PREVIEW / futures_daily / 2011-04-29
file: by_date/futures_daily/2011/2011-04-29.parquet size: 8 KB rows: 88
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-04-29 | ES | Futures | 1341.46 | 1350.13 | 1339.24 | 1346.17 | 1272342.0 |
| 2011-04-29 | NQ | Futures | 2734.47 | 2747.56 | 2730.19 | 2734.18 | 164125.0 |
| 2011-04-29 | YM | Futures | 11947.8 | 12030.5 | 11929.0 | 11992.9 | 78409.0 |
| 2011-04-29 | CL | Futures | 217.41 | 220.03 | 216.32 | 219.55 | 201831.0 |
| 2011-04-29 | GC | Futures | 2078.0 | 2124.7 | 2073.7 | 2106.6 | 157177.0 |
| 2011-04-29 | ZN | Futures | 101.922026 | 102.159054 | 101.790343 | 102.093212 | 681129.0 |
| 2011-04-29 | A6 | Futures | 0.93195 | 0.93649 | 0.92817 | 0.93589 | 78636.0 |
| 2011-04-29 | AD | Futures | 1.04591 | 1.05328 | 1.04153 | 1.05169 | 75038.0 |
| 2011-04-29 | B | Futures | 105.75 | 106.77 | 105.19 | 106.61 | 32111.0 |
| 2011-04-29 | B6 | Futures | 1.7282 | 1.7365 | 1.7261 | 1.735 | 66179.0 |
| 2011-04-29 | BFX | Futures | 3243.5 | 3266.4 | 3231.7 | 3250.1 | 163.0 |
| 2011-04-29 | BR | Futures | 0.27872 | 0.28008 | 0.27762 | 0.2794 | 61.0 |
| 2011-04-29 | BZ | Futures | 112.33 | 112.33 | 112.33 | 112.33 | 138.0 |
| 2011-04-29 | CB | Futures | 120.855 | 120.855 | 120.855 | 120.855 | 2.0 |
| 2011-04-29 | CC | Futures | 2613.0 | 2665.0 | 2603.0 | 2659.0 | 12715.0 |
| 2011-04-29 | CSC | Futures | 4.368 | 4.446 | 4.368 | 4.446 | 8.0 |
| 2011-04-29 | CT | Futures | 151.09 | 156.4 | 146.29 | 156.4 | 7536.0 |
| 2011-04-29 | DC | Futures | 29.6 | 30.0 | 29.27 | 29.91 | 159.0 |
| 2011-04-29 | DX | Futures | 72.889 | 73.014 | 72.651 | 72.742 | 18044.0 |
| 2011-04-29 | E1 | Futures | 1.49912 | 1.51837 | 1.49716 | 1.51641 | 43875.0 |
| 2011-04-29 | E6 | Futures | 1.75388 | 1.76039 | 1.7508 | 1.75542 | 178997.0 |
| 2011-04-29 | E7 | Futures | 1.7409 | 1.7474 | 1.7377 | 1.7424 | 3343.0 |
| 2011-04-29 | EBM | Futures | 225.45 | 230.15 | 223.57 | 229.68 | 5206.0 |
| 2011-04-29 | ED | Futures | 94.9311 | 94.9359 | 94.9311 | 94.9311 | 64795.0 |
| 2011-04-29 | ER | Futures | 97.252 | 97.252 | 97.232 | 97.237 | 29454.0 |
| 2011-04-29 | EW | Futures | 1004.7 | 1009.0 | 1001.7 | 1007.5 | 19197.0 |
| 2011-04-29 | FBTP | Futures | 64.39 | 64.58 | 64.36 | 64.57 | 3568.0 |
| 2011-04-29 | FCE | Futures | 2751.5 | 2765.4 | 2744.0 | 2760.3 | 59351.0 |
| 2011-04-29 | FDAX | Futures | 8003.9 | 8060.5 | 7991.7 | 8040.2 | 68261.0 |
| 2011-04-29 | FESX | Futures | 1886.3 | 1894.0 | 1879.2 | 1888.2 | 505356.0 |
| 2011-04-29 | FEU3 | Futures | 97.78 | 97.78 | 97.78 | 97.78 | 330.0 |
| 2011-04-29 | FGBL | Futures | 98.09 | 98.4 | 98.0 | 98.36 | 371524.0 |
| 2011-04-29 | FGBM | Futures | 103.03 | 103.22 | 102.89 | 103.18 | 207725.0 |
| 2011-04-29 | FGBS | Futures | 106.345 | 106.384 | 106.285 | 106.375 | 301365.0 |
| 2011-04-29 | FGBX | Futures | 94.41 | 95.07 | 94.16 | 94.96 | 3793.0 |
| 2011-04-29 | FTDX | Futures | 827.9 | 838.2 | 827.9 | 836.8 | 468.0 |
| 2011-04-29 | FTI | Futures | 293.91 | 295.55 | 292.26 | 294.36 | 16290.0 |
| 2011-04-29 | FXXP | Futures | 187.4 | 187.9 | 186.9 | 187.9 | 595.0 |
| 2011-04-29 | GF | Futures | 316.172 | 318.699 | 316.112 | 317.435 | 1275.0 |
| 2011-04-29 | GSCI | Futures | 1172.35 | 1186.72 | 1168.45 | 1185.63 | 54.0 |
| 2011-04-29 | HE | Futures | 101.846 | 102.324 | 100.385 | 101.235 | 1418.0 |
| 2011-04-29 | HG | Futures | 5.663 | 5.6915 | 5.5241 | 5.552 | 24287.0 |
| 2011-04-29 | HO | Futures | 2.6988 | 2.7263 | 2.6887 | 2.7219 | 35513.0 |
| 2011-04-29 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-29 | J1 | Futures | 0.0154099 | 0.0155054 | 0.0153873 | 0.0154903 | 65439.0 |
| 2011-04-29 | J7 | Futures | 0.015304 | 0.01541 | 0.015302 | 0.015395 | 787.0 |
| 2011-04-29 | KC | Futures | 715.32 | 722.99 | 706.69 | 719.04 | 6256.0 |
| 2011-04-29 | KE | Futures | 3480.65 | 3584.32 | 3441.15 | 3562.6 | 16806.0 |
| 2011-04-29 | LBS | Futures | 555.2 | 573.9 | 552.3 | 567.9 | 337.0 |
| 2011-04-29 | LE | Futures | 171.69 | 172.713 | 170.971 | 171.69 | 24777.0 |
> showing 50 of 88 rows — these rows as CSV