PREVIEW / futures_daily / 2010-09-24
file: by_date/futures_daily/2010/2010-09-24.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-09-24 | ES | Futures | 1098.27 | 1121.79 | 1096.31 | 1120.57 | 1846093.0 |
| 2010-09-24 | NQ | Futures | 2248.23 | 2292.73 | 2243.69 | 2288.48 | 304445.0 |
| 2010-09-24 | YM | Futures | 9868.8 | 10050.2 | 9854.8 | 10034.4 | 124723.0 |
| 2010-09-24 | CL | Futures | 156.16 | 159.77 | 155.56 | 159.37 | 288499.0 |
| 2010-09-24 | GC | Futures | 1758.6 | 1769.2 | 1754.3 | 1764.5 | 110500.0 |
| 2010-09-24 | ZN | Futures | 103.72246 | 103.890212 | 103.361148 | 103.412764 | 1184606.0 |
| 2010-09-24 | A6 | Futures | 0.78893 | 0.79934 | 0.78667 | 0.79682 | 73662.0 |
| 2010-09-24 | AD | Futures | 0.95646 | 0.96726 | 0.95507 | 0.9633 | 78879.0 |
| 2010-09-24 | B | Futures | 67.26 | 68.47 | 67.0 | 68.01 | 137839.0 |
| 2010-09-24 | B6 | Futures | 1.6268 | 1.6439 | 1.6229 | 1.6412 | 99088.0 |
| 2010-09-24 | BFX | Futures | 2934.0 | 2979.8 | 2932.7 | 2975.5 | 694.0 |
| 2010-09-24 | BR | Futures | 0.24634 | 0.24634 | 0.24623 | 0.24634 | 66.0 |
| 2010-09-24 | BZ | Futures | 71.73 | 72.66 | 71.6 | 72.18 | 396.0 |
| 2010-09-24 | C | Futures | 2057.0 | 2079.0 | 2047.0 | 2055.0 | 2918.0 |
| 2010-09-24 | CB | Futures | 97.215 | 98.867 | 97.215 | 98.867 | 13.0 |
| 2010-09-24 | CC | Futures | 2297.0 | 2337.0 | 2292.0 | 2313.0 | 4695.0 |
| 2010-09-24 | CT | Futures | 82.25 | 84.88 | 81.71 | 84.58 | 11277.0 |
| 2010-09-24 | DC | Futures | 25.3 | 25.44 | 25.19 | 25.4 | 131.0 |
| 2010-09-24 | DX | Futures | 80.696 | 80.726 | 79.718 | 79.853 | 24568.0 |
| 2010-09-24 | E1 | Futures | 1.33301 | 1.34365 | 1.32947 | 1.33328 | 40986.0 |
| 2010-09-24 | E6 | Futures | 1.57463 | 1.59616 | 1.57132 | 1.59297 | 304147.0 |
| 2010-09-24 | E7 | Futures | 1.5628 | 1.5839 | 1.5594 | 1.5809 | 5200.0 |
| 2010-09-24 | ED | Futures | 94.6936 | 94.6983 | 94.6746 | 94.6936 | 113383.0 |
| 2010-09-24 | ER | Futures | 97.35 | 97.355 | 97.326 | 97.33 | 110991.0 |
| 2010-09-24 | EW | Futures | 761.5 | 780.3 | 760.5 | 778.3 | 24537.0 |
| 2010-09-24 | FBTP | Futures | 66.97 | 67.0 | 66.73 | 66.81 | 3981.0 |
| 2010-09-24 | FCE | Futures | 2428.8 | 2491.4 | 2418.3 | 2481.3 | 152067.0 |
| 2010-09-24 | FDAX | Futures | 6649.3 | 6800.9 | 6617.5 | 6777.8 | 168859.0 |
| 2010-09-24 | FESX | Futures | 1697.6 | 1741.9 | 1689.5 | 1735.0 | 1274914.0 |
| 2010-09-24 | FEU3 | Futures | 97.909 | 97.909 | 97.889 | 97.894 | 261.0 |
| 2010-09-24 | FGBL | Futures | 103.82 | 104.12 | 103.34 | 103.47 | 1125112.0 |
| 2010-09-24 | FGBM | Futures | 106.59 | 106.77 | 106.37 | 106.44 | 504975.0 |
| 2010-09-24 | FGBS | Futures | 107.666 | 107.73 | 107.617 | 107.642 | 384202.0 |
| 2010-09-24 | FGBX | Futures | 107.39 | 108.17 | 105.7 | 106.3 | 4090.0 |
| 2010-09-24 | FTDX | Futures | 677.4 | 684.9 | 674.3 | 684.4 | 617.0 |
| 2010-09-24 | FTI | Futures | 265.76 | 271.61 | 265.2 | 271.01 | 42302.0 |
| 2010-09-24 | FTUK | Futures | 3807.4 | 3868.2 | 3798.1 | 3854.1 | 105302.0 |
| 2010-09-24 | FXXP | Futures | 167.9 | 170.2 | 167.9 | 170.2 | 1365.0 |
| 2010-09-24 | G | Futures | 84.38 | 84.4 | 83.76 | 83.86 | 120654.0 |
| 2010-09-24 | GF | Futures | 275.755 | 275.755 | 272.485 | 273.303 | 1444.0 |
| 2010-09-24 | GSCI | Futures | 885.87 | 893.54 | 884.87 | 892.21 | 177.0 |
| 2010-09-24 | HE | Futures | 102.643 | 104.808 | 102.643 | 103.455 | 15715.0 |
| 2010-09-24 | HG | Futures | 4.7742 | 4.8529 | 4.7588 | 4.8289 | 22238.0 |
| 2010-09-24 | HO | Futures | 1.807 | 1.8369 | 1.8041 | 1.8272 | 19986.0 |
| 2010-09-24 | HRC | Futures | 2685.2 | 2685.2 | 2685.2 | 2685.2 | 0.0 |
| 2010-09-24 | J1 | Futures | 0.0148949 | 0.0149451 | 0.0147203 | 0.0148999 | 132646.0 |
| 2010-09-24 | J7 | Futures | 0.014769 | 0.014845 | 0.014622 | 0.014798 | 442.0 |
| 2010-09-24 | JB | Futures | 121.66 | 121.77 | 121.59 | 121.71 | 1995.0 |
| 2010-09-24 | KC | Futures | 451.22 | 455.56 | 442.04 | 447.87 | 10602.0 |
| 2010-09-24 | KE | Futures | 3087.33 | 3169.73 | 3076.9 | 3160.34 | 11503.0 |
> showing 50 of 90 rows — these rows as CSV