PREVIEW / futures_daily / 2010-05-28
file: by_date/futures_daily/2010/2010-05-28.parquet size: 9 KB rows: 89
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 |
|---|---|---|---|---|---|---|---|
| 2010-05-28 | ES | Futures | 1071.41 | 1077.74 | 1054.85 | 1059.97 | 2368730.0 |
| 2010-05-28 | NQ | Futures | 2112.6 | 2126.21 | 2082.25 | 2100.97 | 315745.0 |
| 2010-05-28 | YM | Futures | 9407.8 | 9447.3 | 9269.0 | 9308.5 | 147205.0 |
| 2010-05-28 | CL | Futures | 163.9 | 165.69 | 160.02 | 161.86 | 420674.0 |
| 2010-05-28 | GC | Futures | 1655.2 | 1660.5 | 1642.1 | 1657.3 | 96000.0 |
| 2010-05-28 | ZN | Futures | 98.113713 | 98.534583 | 98.088206 | 98.496322 | 439517.0 |
| 2010-05-28 | A6 | Futures | 0.69663 | 0.70048 | 0.69039 | 0.69294 | 117731.0 |
| 2010-05-28 | AD | Futures | 0.94066 | 0.9452 | 0.93612 | 0.93908 | 85864.0 |
| 2010-05-28 | B | Futures | 66.23 | 67.13 | 64.98 | 65.63 | 60198.0 |
| 2010-05-28 | B6 | Futures | 1.5119 | 1.5171 | 1.4987 | 1.5042 | 125150.0 |
| 2010-05-28 | BFX | Futures | 2831.1 | 2831.1 | 2793.4 | 2798.7 | 116.0 |
| 2010-05-28 | BR | Futures | 0.22507 | 0.22507 | 0.22465 | 0.22486 | 173.0 |
| 2010-05-28 | BZ | Futures | 71.49 | 71.49 | 70.21 | 70.78 | 8.0 |
| 2010-05-28 | C | Futures | 2416.0 | 2429.0 | 2380.0 | 2404.0 | 6710.0 |
| 2010-05-28 | CC | Futures | 2507.0 | 2521.0 | 2475.0 | 2491.0 | 6512.0 |
| 2010-05-28 | CT | Futures | 64.74 | 64.75 | 63.59 | 63.62 | 16486.0 |
| 2010-05-28 | DC | Futures | 22.8 | 22.89 | 22.28 | 22.28 | 140.0 |
| 2010-05-28 | DX | Futures | 87.494 | 88.056 | 87.083 | 87.739 | 25233.0 |
| 2010-05-28 | E1 | Futures | 1.14377 | 1.14706 | 1.13416 | 1.13824 | 48335.0 |
| 2010-05-28 | E6 | Futures | 1.46217 | 1.47353 | 1.45117 | 1.45791 | 366661.0 |
| 2010-05-28 | E7 | Futures | 1.4502 | 1.4613 | 1.4389 | 1.446 | 7982.0 |
| 2010-05-28 | ED | Futures | 94.1765 | 94.2144 | 94.1576 | 94.1765 | 261112.0 |
| 2010-05-28 | ER | Futures | 97.36 | 97.365 | 97.345 | 97.36 | 69308.0 |
| 2010-05-28 | EW | Futures | 747.7 | 752.9 | 738.2 | 742.6 | 38716.0 |
| 2010-05-28 | FBTP | Futures | 64.1 | 64.35 | 63.96 | 64.1 | 6336.0 |
| 2010-05-28 | FCE | Futures | 2334.1 | 2348.0 | 2290.0 | 2319.8 | 137924.0 |
| 2010-05-28 | FDAX | Futures | 6470.8 | 6506.7 | 6407.2 | 6463.7 | 143921.0 |
| 2010-05-28 | FESX | Futures | 1603.3 | 1616.7 | 1570.8 | 1596.5 | 1516519.0 |
| 2010-05-28 | FEU3 | Futures | 97.919 | 97.919 | 97.919 | 97.919 | 30.0 |
| 2010-05-28 | FGBL | Futures | 99.98 | 100.57 | 99.98 | 100.28 | 771500.0 |
| 2010-05-28 | FGBM | Futures | 104.74 | 105.01 | 104.71 | 104.84 | 456100.0 |
| 2010-05-28 | FGBS | Futures | 107.496 | 107.613 | 107.491 | 107.55 | 425213.0 |
| 2010-05-28 | FGBX | Futures | 98.39 | 99.49 | 98.26 | 98.89 | 2302.0 |
| 2010-05-28 | FTDX | Futures | 659.8 | 661.5 | 652.2 | 653.6 | 359.0 |
| 2010-05-28 | FTI | Futures | 253.34 | 254.87 | 249.4 | 252.63 | 35518.0 |
| 2010-05-28 | FTUK | Futures | 3527.1 | 3538.3 | 3478.4 | 3510.2 | 135618.0 |
| 2010-05-28 | G | Futures | 79.32 | 79.72 | 79.27 | 79.51 | 109384.0 |
| 2010-05-28 | GF | Futures | 274.466 | 274.845 | 272.887 | 273.898 | 1716.0 |
| 2010-05-28 | GSCI | Futures | 859.86 | 860.73 | 842.64 | 851.34 | 779.0 |
| 2010-05-28 | HE | Futures | 102.257 | 103.2 | 102.163 | 102.886 | 4612.0 |
| 2010-05-28 | HG | Futures | 4.3013 | 4.3278 | 4.1947 | 4.2157 | 26738.0 |
| 2010-05-28 | HO | Futures | 1.8012 | 1.8224 | 1.7776 | 1.7955 | 10267.0 |
| 2010-05-28 | HRC | Futures | 3017.0 | 3017.0 | 3017.0 | 3017.0 | 0.0 |
| 2010-05-28 | J1 | Futures | 0.0138291 | 0.0138806 | 0.0137562 | 0.0138517 | 125796.0 |
| 2010-05-28 | J7 | Futures | 0.013724 | 0.013769 | 0.013648 | 0.013741 | 1254.0 |
| 2010-05-28 | JB | Futures | 119.3 | 119.48 | 119.16 | 119.38 | 2039.0 |
| 2010-05-28 | KC | Futures | 342.74 | 343.88 | 339.94 | 340.83 | 8297.0 |
| 2010-05-28 | KE | Futures | 2147.64 | 2165.03 | 2093.3 | 2093.3 | 12603.0 |
| 2010-05-28 | L | Futures | 97.947 | 97.987 | 97.928 | 97.977 | 77055.0 |
| 2010-05-28 | LBS | Futures | 709.1 | 719.0 | 695.5 | 697.9 | 910.0 |
> showing 50 of 89 rows — these rows as CSV