PREVIEW / futures_daily / 2009-04-15
file: by_date/futures_daily/2009/2009-04-15.parquet size: 8 KB rows: 86
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-04-15 | ES | Futures | 798.45 | 810.61 | 792.5 | 808.7 | 2175733.0 |
| 2009-04-15 | NQ | Futures | 1474.89 | 1483.03 | 1453.26 | 1479.66 | 315134.0 |
| 2009-04-15 | YM | Futures | 7061.1 | 7171.4 | 7009.1 | 7158.0 | 167429.0 |
| 2009-04-15 | CL | Futures | 139.87 | 143.56 | 138.58 | 139.44 | 161407.0 |
| 2009-04-15 | GC | Futures | 1234.0 | 1249.1 | 1227.0 | 1237.2 | 56028.0 |
| 2009-04-15 | ZN | Futures | 95.992966 | 96.211435 | 95.750222 | 96.162886 | 523504.0 |
| 2009-04-15 | A6 | Futures | 0.57333 | 0.57939 | 0.56759 | 0.57373 | 48592.0 |
| 2009-04-15 | AD | Futures | 0.81138 | 0.81994 | 0.80813 | 0.8162 | 48942.0 |
| 2009-04-15 | B | Futures | 50.75 | 52.04 | 50.3 | 50.72 | 117195.0 |
| 2009-04-15 | B6 | Futures | 1.5493 | 1.565 | 1.5424 | 1.5565 | 75678.0 |
| 2009-04-15 | BFX | Futures | 1979.2 | 2002.4 | 1979.2 | 1995.6 | 7544.0 |
| 2009-04-15 | BR | Futures | 0.16993 | 0.17115 | 0.16993 | 0.17115 | 5.0 |
| 2009-04-15 | BZ | Futures | 53.79 | 54.05 | 53.54 | 53.54 | 25.0 |
| 2009-04-15 | C | Futures | 1839.0 | 1845.0 | 1799.0 | 1803.0 | 3235.0 |
| 2009-04-15 | CC | Futures | 2197.0 | 2214.0 | 2153.0 | 2163.0 | 8150.0 |
| 2009-04-15 | CT | Futures | 44.48 | 45.69 | 44.46 | 45.59 | 7545.0 |
| 2009-04-15 | DC | Futures | 27.67 | 27.81 | 27.5 | 27.5 | 162.0 |
| 2009-04-15 | DX | Futures | 87.627 | 88.188 | 87.38 | 87.9 | 3130.0 |
| 2009-04-15 | E1 | Futures | 1.16642 | 1.16735 | 1.15515 | 1.15979 | 26322.0 |
| 2009-04-15 | E6 | Futures | 1.5715 | 1.57576 | 1.55786 | 1.56284 | 154966.0 |
| 2009-04-15 | E7 | Futures | 1.5535 | 1.5572 | 1.54 | 1.5447 | 1544.0 |
| 2009-04-15 | EBM | Futures | 210.53 | 211.31 | 209.37 | 210.14 | 6054.0 |
| 2009-04-15 | ED | Futures | 93.2755 | 93.3037 | 93.266 | 93.299 | 115717.0 |
| 2009-04-15 | ER | Futures | 96.709 | 96.733 | 96.709 | 96.723 | 83431.0 |
| 2009-04-15 | EW | Futures | 503.1 | 511.1 | 498.2 | 509.8 | 30074.0 |
| 2009-04-15 | FCE | Futures | 1843.1 | 1885.3 | 1840.3 | 1860.3 | 153678.0 |
| 2009-04-15 | FDAX | Futures | 4909.7 | 5019.7 | 4895.6 | 4954.9 | 145561.0 |
| 2009-04-15 | FESX | Futures | 1304.5 | 1332.7 | 1300.3 | 1311.7 | 1200236.0 |
| 2009-04-15 | FEU3 | Futures | 97.303 | 97.303 | 97.303 | 97.303 | 50.0 |
| 2009-04-15 | FGBL | Futures | 92.57 | 92.94 | 92.5 | 92.79 | 537555.0 |
| 2009-04-15 | FGBM | Futures | 97.73 | 98.07 | 97.72 | 98.0 | 367877.0 |
| 2009-04-15 | FGBS | Futures | 103.675 | 103.767 | 103.666 | 103.757 | 380613.0 |
| 2009-04-15 | FGBX | Futures | 82.12 | 82.89 | 82.12 | 82.75 | 2282.0 |
| 2009-04-15 | FTDX | Futures | 478.4 | 495.5 | 478.4 | 492.8 | 258.0 |
| 2009-04-15 | FTI | Futures | 190.0 | 193.91 | 189.22 | 192.72 | 58734.0 |
| 2009-04-15 | FTUK | Futures | 2603.5 | 2648.4 | 2592.2 | 2598.5 | 109305.0 |
| 2009-04-15 | G | Futures | 78.27 | 78.39 | 77.67 | 77.82 | 75960.0 |
| 2009-04-15 | GF | Futures | 275.746 | 281.052 | 274.979 | 279.027 | 1365.0 |
| 2009-04-15 | GSCI | Futures | 797.44 | 803.82 | 791.06 | 795.74 | 265.0 |
| 2009-04-15 | HE | Futures | 117.336 | 118.656 | 116.428 | 117.831 | 731.0 |
| 2009-04-15 | HG | Futures | 2.9565 | 3.1473 | 2.9529 | 3.098 | 22672.0 |
| 2009-04-15 | HO | Futures | 1.5416 | 1.5762 | 1.53 | 1.5531 | 15476.0 |
| 2009-04-15 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-15 | J1 | Futures | 0.012764 | 0.0128534 | 0.0126543 | 0.0127148 | 77289.0 |
| 2009-04-15 | J7 | Futures | 0.012568 | 0.012673 | 0.012486 | 0.012542 | 322.0 |
| 2009-04-15 | JB | Futures | 114.47 | 114.77 | 114.39 | 114.65 | 910.0 |
| 2009-04-15 | KC | Futures | 323.49 | 327.43 | 321.52 | 325.46 | 12228.0 |
| 2009-04-15 | KE | Futures | 2783.0 | 2832.3 | 2755.89 | 2760.82 | 5332.0 |
| 2009-04-15 | L | Futures | 96.964 | 96.974 | 96.925 | 96.964 | 32510.0 |
| 2009-04-15 | LBS | Futures | 927.1 | 935.4 | 915.2 | 932.3 | 208.0 |
> showing 50 of 86 rows — these rows as CSV