PREVIEW / futures_daily / 2011-05-02
file: by_date/futures_daily/2011/2011-05-02.parquet size: 9 KB rows: 92
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-05-02 | ES | Futures | 1349.63 | 1359.78 | 1341.22 | 1344.19 | 1707040.0 |
| 2011-05-02 | NQ | Futures | 2742.44 | 2765.22 | 2725.92 | 2735.03 | 286554.0 |
| 2011-05-02 | YM | Futures | 12022.0 | 12102.9 | 11970.3 | 12000.4 | 103909.0 |
| 2011-05-02 | CL | Futures | 219.48 | 221.29 | 213.56 | 218.76 | 310994.0 |
| 2011-05-02 | GC | Futures | 2120.7 | 2135.0 | 2084.8 | 2107.6 | 211656.0 |
| 2011-05-02 | ZN | Futures | 102.080044 | 102.356577 | 101.882521 | 102.172222 | 762139.0 |
| 2011-05-02 | A6 | Futures | 0.93606 | 0.93941 | 0.9316 | 0.93495 | 83888.0 |
| 2011-05-02 | AD | Futures | 1.05288 | 1.05308 | 1.04472 | 1.0476 | 66631.0 |
| 2011-05-02 | B | Futures | 106.6 | 107.13 | 103.08 | 105.95 | 40039.0 |
| 2011-05-02 | B6 | Futures | 1.7356 | 1.7381 | 1.7271 | 1.7321 | 69127.0 |
| 2011-05-02 | BFX | Futures | 3279.1 | 3290.8 | 3243.5 | 3269.6 | 135.0 |
| 2011-05-02 | BR | Futures | 0.27916 | 0.27942 | 0.27766 | 0.27894 | 237.0 |
| 2011-05-02 | BZ | Futures | 110.48 | 112.52 | 110.48 | 111.65 | 328.0 |
| 2011-05-02 | CB | Futures | 121.442 | 122.029 | 120.855 | 120.855 | 13.0 |
| 2011-05-02 | CC | Futures | 2655.0 | 2658.0 | 2582.0 | 2620.0 | 7841.0 |
| 2011-05-02 | CSC | Futures | 4.469 | 4.471 | 4.469 | 4.471 | 4.0 |
| 2011-05-02 | CT | Futures | 156.4 | 156.88 | 149.56 | 152.87 | 7893.0 |
| 2011-05-02 | DC | Futures | 29.88 | 30.12 | 29.71 | 30.02 | 221.0 |
| 2011-05-02 | DX | Futures | 72.82 | 73.113 | 72.531 | 72.774 | 23111.0 |
| 2011-05-02 | E1 | Futures | 1.51444 | 1.5185 | 1.5058 | 1.51536 | 33199.0 |
| 2011-05-02 | E6 | Futures | 1.75423 | 1.76312 | 1.74642 | 1.7566 | 214345.0 |
| 2011-05-02 | E7 | Futures | 1.7414 | 1.75 | 1.7337 | 1.7435 | 4960.0 |
| 2011-05-02 | EBM | Futures | 229.21 | 234.84 | 229.21 | 232.03 | 2997.0 |
| 2011-05-02 | ED | Futures | 94.9359 | 94.9406 | 94.9311 | 94.9311 | 83121.0 |
| 2011-05-02 | ER | Futures | 97.242 | 97.242 | 97.217 | 97.227 | 46231.0 |
| 2011-05-02 | EW | Futures | 1008.3 | 1015.4 | 1000.2 | 1001.5 | 21650.0 |
| 2011-05-02 | FBTP | Futures | 64.63 | 64.69 | 64.42 | 64.61 | 1734.0 |
| 2011-05-02 | FCE | Futures | 2783.1 | 2787.9 | 2750.8 | 2759.6 | 70622.0 |
| 2011-05-02 | FDAX | Futures | 8115.0 | 8141.2 | 8028.0 | 8067.5 | 98478.0 |
| 2011-05-02 | FESX | Futures | 1904.2 | 1909.3 | 1883.7 | 1892.7 | 589131.0 |
| 2011-05-02 | FEU3 | Futures | 97.77 | 97.775 | 97.77 | 97.77 | 13.0 |
| 2011-05-02 | FGBL | Futures | 98.29 | 98.37 | 98.03 | 98.28 | 276902.0 |
| 2011-05-02 | FGBM | Futures | 103.14 | 103.15 | 102.93 | 103.08 | 165384.0 |
| 2011-05-02 | FGBS | Futures | 106.35 | 106.355 | 106.266 | 106.305 | 232661.0 |
| 2011-05-02 | FGBX | Futures | 94.91 | 94.93 | 94.23 | 94.76 | 2764.0 |
| 2011-05-02 | FTDX | Futures | 844.9 | 844.9 | 828.8 | 833.3 | 485.0 |
| 2011-05-02 | FTI | Futures | 296.42 | 297.41 | 294.28 | 295.84 | 23380.0 |
| 2011-05-02 | FXXP | Futures | 189.3 | 189.3 | 187.6 | 187.6 | 1917.0 |
| 2011-05-02 | GF | Futures | 317.315 | 318.579 | 314.547 | 315.39 | 1100.0 |
| 2011-05-02 | GSCI | Futures | 1170.4 | 1190.94 | 1170.01 | 1174.7 | 196.0 |
| 2011-05-02 | HE | Futures | 101.235 | 102.003 | 100.414 | 101.102 | 17292.0 |
| 2011-05-02 | HG | Futures | 5.5627 | 5.5932 | 5.457 | 5.5746 | 25093.0 |
| 2011-05-02 | HO | Futures | 2.7279 | 2.7353 | 2.6379 | 2.7023 | 47482.0 |
| 2011-05-02 | HRC | Futures | 3000.1 | 3000.1 | 3000.1 | 3000.1 | 0.0 |
| 2011-05-02 | J1 | Futures | 0.015494 | 0.0155141 | 0.0153797 | 0.0154652 | 81744.0 |
| 2011-05-02 | J7 | Futures | 0.015389 | 0.015417 | 0.015289 | 0.01537 | 756.0 |
| 2011-05-02 | JB | Futures | 122.07 | 122.26 | 121.97 | 122.06 | 30.0 |
| 2011-05-02 | KC | Futures | 718.56 | 736.66 | 711.6 | 731.63 | 8341.0 |
| 2011-05-02 | KE | Futures | 3566.55 | 3657.39 | 3506.32 | 3517.18 | 13707.0 |
| 2011-05-02 | LBS | Futures | 569.1 | 585.6 | 567.9 | 578.6 | 703.0 |
> showing 50 of 92 rows — these rows as CSV