PREVIEW / futures_daily / 2010-08-27
file: by_date/futures_daily/2010/2010-08-27.parquet size: 9 KB rows: 90
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-08-27 | ES | Futures | 1018.02 | 1038.26 | 1011.69 | 1037.53 | 2541324.0 |
| 2010-08-27 | NQ | Futures | 1998.8 | 2031.06 | 1973.9 | 2025.12 | 391994.0 |
| 2010-08-27 | YM | Futures | 9206.1 | 9380.9 | 9171.9 | 9376.3 | 158453.0 |
| 2010-08-27 | CL | Futures | 154.37 | 159.45 | 151.96 | 158.57 | 477903.0 |
| 2010-08-27 | GC | Futures | 1684.3 | 1691.2 | 1676.6 | 1682.6 | 86006.0 |
| 2010-08-27 | ZN | Futures | 103.538676 | 103.615514 | 102.514175 | 102.603818 | 2060149.0 |
| 2010-08-27 | A6 | Futures | 0.73303 | 0.74472 | 0.73179 | 0.74381 | 109964.0 |
| 2010-08-27 | AD | Futures | 0.93355 | 0.94046 | 0.92713 | 0.93829 | 109105.0 |
| 2010-08-27 | B | Futures | 64.68 | 66.66 | 64.48 | 66.41 | 70041.0 |
| 2010-08-27 | B6 | Futures | 1.6108 | 1.6135 | 1.6024 | 1.6098 | 108482.0 |
| 2010-08-27 | BFX | Futures | 2785.0 | 2813.4 | 2776.6 | 2813.4 | 34.0 |
| 2010-08-27 | BR | Futures | 0.23875 | 0.23961 | 0.23786 | 0.23786 | 70.0 |
| 2010-08-27 | BZ | Futures | 70.48 | 70.48 | 70.48 | 70.48 | 395.0 |
| 2010-08-27 | C | Futures | 2199.0 | 2217.0 | 2160.0 | 2160.0 | 3961.0 |
| 2010-08-27 | CB | Futures | 96.09 | 96.507 | 96.09 | 96.507 | 11.0 |
| 2010-08-27 | CC | Futures | 2274.0 | 2281.0 | 2242.0 | 2250.0 | 8226.0 |
| 2010-08-27 | CT | Futures | 75.08 | 75.8 | 74.79 | 74.9 | 76.0 |
| 2010-08-27 | DC | Futures | 24.17 | 24.22 | 24.11 | 24.16 | 65.0 |
| 2010-08-27 | DX | Futures | 83.632 | 83.894 | 83.345 | 83.625 | 23076.0 |
| 2010-08-27 | E1 | Futures | 1.28246 | 1.28509 | 1.27458 | 1.27616 | 39618.0 |
| 2010-08-27 | E6 | Futures | 1.50342 | 1.51123 | 1.49881 | 1.50543 | 313182.0 |
| 2010-08-27 | E7 | Futures | 1.4926 | 1.5002 | 1.4881 | 1.4946 | 3102.0 |
| 2010-08-27 | ED | Futures | 94.6009 | 94.608 | 94.5986 | 94.6033 | 113892.0 |
| 2010-08-27 | ER | Futures | 97.316 | 97.321 | 97.306 | 97.316 | 54571.0 |
| 2010-08-27 | EW | Futures | 702.4 | 719.1 | 696.7 | 718.6 | 29874.0 |
| 2010-08-27 | FBTP | Futures | 67.29 | 67.49 | 67.18 | 67.35 | 3981.0 |
| 2010-08-27 | FCE | Futures | 2280.9 | 2326.7 | 2260.8 | 2308.9 | 164524.0 |
| 2010-08-27 | FDAX | Futures | 6413.6 | 6505.6 | 6358.7 | 6478.4 | 166624.0 |
| 2010-08-27 | FESX | Futures | 1606.2 | 1638.3 | 1593.8 | 1627.8 | 1456710.0 |
| 2010-08-27 | FEU3 | Futures | 97.874 | 97.874 | 97.869 | 97.874 | 105.0 |
| 2010-08-27 | FGBL | Futures | 104.69 | 105.08 | 104.07 | 104.39 | 1121507.0 |
| 2010-08-27 | FGBM | Futures | 106.87 | 106.92 | 106.5 | 106.62 | 515698.0 |
| 2010-08-27 | FGBS | Futures | 107.834 | 107.849 | 107.76 | 107.795 | 447830.0 |
| 2010-08-27 | FGBX | Futures | 111.96 | 113.2 | 110.69 | 111.35 | 7087.0 |
| 2010-08-27 | FTDX | Futures | 642.6 | 649.6 | 637.7 | 646.5 | 207.0 |
| 2010-08-27 | FTI | Futures | 250.31 | 254.7 | 248.59 | 253.26 | 48315.0 |
| 2010-08-27 | FTUK | Futures | 3533.4 | 3599.8 | 3519.6 | 3583.3 | 111352.0 |
| 2010-08-27 | G | Futures | 84.71 | 85.1 | 84.45 | 84.67 | 76309.0 |
| 2010-08-27 | GF | Futures | 293.545 | 294.999 | 292.597 | 293.925 | 589.0 |
| 2010-08-27 | GSCI | Futures | 852.42 | 867.69 | 845.37 | 867.69 | 159.0 |
| 2010-08-27 | HE | Futures | 99.524 | 99.59 | 98.438 | 98.569 | 14412.0 |
| 2010-08-27 | HG | Futures | 4.4111 | 4.5446 | 4.4038 | 4.5173 | 25362.0 |
| 2010-08-27 | HO | Futures | 1.7377 | 1.78 | 1.7268 | 1.774 | 15671.0 |
| 2010-08-27 | HRC | Futures | 2730.7 | 2730.7 | 2730.7 | 2730.7 | 0.0 |
| 2010-08-27 | J1 | Futures | 0.014896 | 0.0149299 | 0.0147224 | 0.0147387 | 181268.0 |
| 2010-08-27 | J7 | Futures | 0.0148 | 0.014818 | 0.014613 | 0.014628 | 339.0 |
| 2010-08-27 | JB | Futures | 121.65 | 121.77 | 121.24 | 121.43 | 3452.0 |
| 2010-08-27 | KC | Futures | 427.53 | 450.23 | 422.33 | 443.53 | 14447.0 |
| 2010-08-27 | KE | Futures | 2947.56 | 3016.4 | 2938.18 | 2978.85 | 13291.0 |
| 2010-08-27 | L | Futures | 98.106 | 98.125 | 98.106 | 98.115 | 26023.0 |
> showing 50 of 90 rows — these rows as CSV