PREVIEW / futures_daily / 2011-04-26
file: by_date/futures_daily/2011/2011-04-26.parquet size: 9 KB rows: 94
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-26 | ES | Futures | 1317.46 | 1332.8 | 1314.73 | 1327.6 | 1386038.0 |
| 2011-04-26 | NQ | Futures | 2707.42 | 2735.6 | 2702.29 | 2715.96 | 226453.0 |
| 2011-04-26 | YM | Futures | 11682.6 | 11808.6 | 11655.4 | 11769.1 | 88870.0 |
| 2011-04-26 | CL | Futures | 216.12 | 217.07 | 214.14 | 216.24 | 234441.0 |
| 2011-04-26 | GC | Futures | 2040.0 | 2041.8 | 2019.4 | 2035.0 | 145615.0 |
| 2011-04-26 | ZN | Futures | 101.36896 | 101.790343 | 101.316287 | 101.698166 | 802843.0 |
| 2011-04-26 | A6 | Futures | 0.9142 | 0.92003 | 0.91016 | 0.91865 | 84855.0 |
| 2011-04-26 | AD | Futures | 1.04173 | 1.0474 | 1.03984 | 1.04352 | 62748.0 |
| 2011-04-26 | B | Futures | 104.17 | 105.23 | 103.92 | 105.05 | 54335.0 |
| 2011-04-26 | B6 | Futures | 1.7122 | 1.7165 | 1.7059 | 1.7106 | 93629.0 |
| 2011-04-26 | BFX | Futures | 3170.9 | 3219.9 | 3170.9 | 3197.4 | 104.0 |
| 2011-04-26 | BR | Futures | 0.28021 | 0.28026 | 0.2792 | 0.28004 | 105.0 |
| 2011-04-26 | BZ | Futures | 110.35 | 110.69 | 110.35 | 110.69 | 316.0 |
| 2011-04-26 | C | Futures | 2068.0 | 2102.0 | 2060.0 | 2097.0 | 2801.0 |
| 2011-04-26 | CB | Futures | 118.509 | 118.509 | 118.509 | 118.509 | 7.0 |
| 2011-04-26 | CC | Futures | 2439.0 | 2467.0 | 2430.0 | 2462.0 | 4938.0 |
| 2011-04-26 | CSC | Futures | 4.456 | 4.464 | 4.448 | 4.456 | 8.0 |
| 2011-04-26 | CT | Futures | 163.46 | 163.89 | 158.75 | 158.75 | 7089.0 |
| 2011-04-26 | DC | Futures | 29.27 | 29.71 | 29.08 | 29.65 | 196.0 |
| 2011-04-26 | DX | Futures | 73.909 | 74.148 | 73.566 | 73.656 | 17287.0 |
| 2011-04-26 | E1 | Futures | 1.48616 | 1.49768 | 1.4787 | 1.49218 | 38198.0 |
| 2011-04-26 | E6 | Futures | 1.72486 | 1.7341 | 1.71467 | 1.73102 | 241838.0 |
| 2011-04-26 | E7 | Futures | 1.7121 | 1.7212 | 1.7018 | 1.7181 | 4868.0 |
| 2011-04-26 | EBM | Futures | 240.01 | 241.19 | 237.66 | 238.13 | 5692.0 |
| 2011-04-26 | ED | Futures | 94.9216 | 94.9264 | 94.9168 | 94.9216 | 163190.0 |
| 2011-04-26 | ER | Futures | 97.267 | 97.281 | 97.262 | 97.272 | 124694.0 |
| 2011-04-26 | EW | Futures | 985.7 | 999.9 | 983.7 | 994.1 | 21604.0 |
| 2011-04-26 | FBTP | Futures | 64.38 | 64.38 | 64.1 | 64.1 | 2806.0 |
| 2011-04-26 | FCE | Futures | 2682.0 | 2712.3 | 2682.0 | 2706.5 | 81899.0 |
| 2011-04-26 | FDAX | Futures | 7802.1 | 7894.5 | 7786.1 | 7872.1 | 90374.0 |
| 2011-04-26 | FESX | Futures | 1832.4 | 1855.5 | 1830.5 | 1850.4 | 605199.0 |
| 2011-04-26 | FEU3 | Futures | 97.815 | 97.825 | 97.815 | 97.815 | 86.0 |
| 2011-04-26 | FGBL | Futures | 97.96 | 98.08 | 97.81 | 98.03 | 477177.0 |
| 2011-04-26 | FGBM | Futures | 103.07 | 103.18 | 102.97 | 103.13 | 253624.0 |
| 2011-04-26 | FGBS | Futures | 106.424 | 106.444 | 106.37 | 106.434 | 321436.0 |
| 2011-04-26 | FGBX | Futures | 93.88 | 94.05 | 93.55 | 93.99 | 2706.0 |
| 2011-04-26 | FTDX | Futures | 821.7 | 826.1 | 820.8 | 821.7 | 345.0 |
| 2011-04-26 | FTI | Futures | 292.22 | 293.87 | 291.23 | 293.33 | 23342.0 |
| 2011-04-26 | FTUK | Futures | 4187.2 | 4227.4 | 4176.0 | 4221.8 | 66008.0 |
| 2011-04-26 | FXXP | Futures | 185.4 | 185.9 | 185.3 | 185.7 | 1055.0 |
| 2011-04-26 | G | Futures | 82.41 | 82.69 | 82.37 | 82.61 | 64939.0 |
| 2011-04-26 | GF | Futures | 311.9 | 313.464 | 309.734 | 309.854 | 2064.0 |
| 2011-04-26 | GSCI | Futures | 1174.07 | 1176.65 | 1170.01 | 1173.92 | 96.0 |
| 2011-04-26 | HE | Futures | 107.026 | 107.079 | 103.971 | 104.794 | 891.0 |
| 2011-04-26 | HG | Futures | 5.7294 | 5.7945 | 5.6763 | 5.7653 | 21973.0 |
| 2011-04-26 | HO | Futures | 2.6552 | 2.686 | 2.6465 | 2.6816 | 47805.0 |
| 2011-04-26 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-04-26 | J1 | Futures | 0.0153571 | 0.0154212 | 0.0153157 | 0.0153157 | 92185.0 |
| 2011-04-26 | J7 | Futures | 0.015258 | 0.015325 | 0.015237 | 0.015303 | 666.0 |
| 2011-04-26 | JB | Futures | 121.67 | 121.85 | 121.67 | 121.74 | 12.0 |
> showing 50 of 94 rows — these rows as CSV