PREVIEW / futures_daily / 2009-06-26
file: by_date/futures_daily/2009/2009-06-26.parquet size: 8 KB rows: 84
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-26 | ES | Futures | 879.81 | 881.73 | 871.65 | 876.93 | 1410004.0 |
| 2009-06-26 | NQ | Futures | 1659.4 | 1668.97 | 1648.42 | 1663.06 | 209361.0 |
| 2009-06-26 | YM | Futures | 7590.6 | 7607.8 | 7526.6 | 7554.5 | 111240.0 |
| 2009-06-26 | CL | Futures | 185.08 | 187.57 | 181.05 | 181.97 | 208025.0 |
| 2009-06-26 | GC | Futures | 1301.5 | 1313.9 | 1296.7 | 1302.8 | 73575.0 |
| 2009-06-26 | ZN | Futures | 91.593776 | 91.815404 | 91.273648 | 91.729215 | 644965.0 |
| 2009-06-26 | A6 | Futures | 0.64218 | 0.64628 | 0.64137 | 0.64563 | 59348.0 |
| 2009-06-26 | AD | Futures | 0.85526 | 0.86346 | 0.85447 | 0.85743 | 52911.0 |
| 2009-06-26 | B | Futures | 67.25 | 68.0 | 65.8 | 66.19 | 36928.0 |
| 2009-06-26 | B6 | Futures | 1.7054 | 1.7248 | 1.7044 | 1.7214 | 86568.0 |
| 2009-06-26 | BFX | Futures | 2320.0 | 2320.0 | 2281.9 | 2293.2 | 81.0 |
| 2009-06-26 | BR | Futures | 0.19613 | 0.19812 | 0.19566 | 0.19812 | 19.0 |
| 2009-06-26 | C | Futures | 1752.0 | 1753.0 | 1684.0 | 1734.0 | 2233.0 |
| 2009-06-26 | CC | Futures | 2281.0 | 2296.0 | 2214.0 | 2271.0 | 4214.0 |
| 2009-06-26 | CT | Futures | 49.07 | 49.36 | 48.23 | 48.55 | 128.0 |
| 2009-06-26 | DC | Futures | 21.33 | 21.52 | 21.02 | 21.24 | 256.0 |
| 2009-06-26 | DX | Futures | 82.492 | 82.492 | 81.786 | 81.99 | 6740.0 |
| 2009-06-26 | E1 | Futures | 1.21167 | 1.22755 | 1.21061 | 1.2253 | 39261.0 |
| 2009-06-26 | E6 | Futures | 1.66087 | 1.67571 | 1.65957 | 1.67084 | 198006.0 |
| 2009-06-26 | E7 | Futures | 1.6418 | 1.6586 | 1.6414 | 1.6537 | 2457.0 |
| 2009-06-26 | ED | Futures | 93.7819 | 93.815 | 93.7819 | 93.7866 | 164152.0 |
| 2009-06-26 | ER | Futures | 96.934 | 96.939 | 96.919 | 96.924 | 127319.0 |
| 2009-06-26 | EW | Futures | 554.5 | 558.6 | 550.0 | 554.8 | 23406.0 |
| 2009-06-26 | FCE | Futures | 2075.1 | 2089.8 | 2028.7 | 2040.2 | 113751.0 |
| 2009-06-26 | FDAX | Futures | 5289.5 | 5342.7 | 5215.4 | 5242.3 | 111103.0 |
| 2009-06-26 | FESX | Futures | 1440.4 | 1451.7 | 1417.1 | 1424.8 | 859964.0 |
| 2009-06-26 | FEU3 | Futures | 97.5 | 97.5 | 97.495 | 97.5 | 166.0 |
| 2009-06-26 | FGBL | Futures | 91.76 | 92.04 | 91.55 | 91.94 | 498158.0 |
| 2009-06-26 | FGBM | Futures | 98.03 | 98.03 | 97.72 | 97.92 | 298397.0 |
| 2009-06-26 | FGBS | Futures | 104.099 | 104.104 | 103.916 | 103.998 | 409446.0 |
| 2009-06-26 | FGBX | Futures | 82.13 | 82.69 | 82.06 | 82.61 | 1323.0 |
| 2009-06-26 | FTDX | Futures | 558.6 | 562.1 | 546.1 | 547.9 | 1250.0 |
| 2009-06-26 | FTI | Futures | 208.02 | 209.64 | 205.66 | 206.8 | 30944.0 |
| 2009-06-26 | FTUK | Futures | 2820.9 | 2838.8 | 2775.4 | 2792.0 | 84857.0 |
| 2009-06-26 | G | Futures | 75.7 | 75.85 | 75.26 | 75.79 | 59208.0 |
| 2009-06-26 | GF | Futures | 272.874 | 273.563 | 272.185 | 272.805 | 929.0 |
| 2009-06-26 | GSCI | Futures | 952.36 | 952.78 | 936.5 | 941.93 | 277.0 |
| 2009-06-26 | HE | Futures | 83.013 | 84.438 | 82.282 | 82.903 | 3924.0 |
| 2009-06-26 | HG | Futures | 3.254 | 3.2934 | 3.2126 | 3.2421 | 10540.0 |
| 2009-06-26 | HO | Futures | 1.8965 | 1.9106 | 1.8411 | 1.8521 | 9434.0 |
| 2009-06-26 | HRC | Futures | 2382.2 | 2382.2 | 2382.2 | 2382.2 | 0.0 |
| 2009-06-26 | J1 | Futures | 0.0131317 | 0.0132589 | 0.0131179 | 0.0132375 | 65323.0 |
| 2009-06-26 | J7 | Futures | 0.012955 | 0.013071 | 0.012942 | 0.013055 | 20.0 |
| 2009-06-26 | JB | Futures | 115.98 | 116.15 | 115.85 | 115.94 | 2503.0 |
| 2009-06-26 | KC | Futures | 327.1 | 328.05 | 322.35 | 323.44 | 3893.0 |
| 2009-06-26 | KE | Futures | 2889.8 | 2901.79 | 2875.41 | 2877.81 | 6314.0 |
| 2009-06-26 | L | Futures | 97.131 | 97.141 | 97.111 | 97.121 | 30215.0 |
| 2009-06-26 | LBS | Futures | 903.6 | 940.1 | 903.6 | 926.4 | 304.0 |
| 2009-06-26 | LE | Futures | 145.171 | 145.391 | 144.466 | 145.215 | 10667.0 |
| 2009-06-26 | MP | Futures | 0.03915 | 0.03953 | 0.03909 | 0.03922 | 11838.0 |
> showing 50 of 84 rows — these rows as CSV