PREVIEW / futures_daily / 2009-11-18
file: by_date/futures_daily/2009/2009-11-18.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 |
|---|---|---|---|---|---|---|---|
| 2009-11-18 | ES | Futures | 1068.22 | 1071.36 | 1061.71 | 1069.19 | 1480000.0 |
| 2009-11-18 | NQ | Futures | 2041.79 | 2046.87 | 2019.21 | 2032.48 | 256352.0 |
| 2009-11-18 | YM | Futures | 9437.3 | 9466.3 | 9385.5 | 9445.4 | 96278.0 |
| 2009-11-18 | CL | Futures | 194.37 | 196.83 | 192.81 | 194.93 | 187950.0 |
| 2009-11-18 | GC | Futures | 1577.2 | 1594.5 | 1570.4 | 1577.6 | 180277.0 |
| 2009-11-18 | ZN | Futures | 95.459918 | 95.49728 | 95.148568 | 95.198384 | 775864.0 |
| 2009-11-18 | A6 | Futures | 0.74987 | 0.75278 | 0.74688 | 0.74736 | 75227.0 |
| 2009-11-18 | AD | Futures | 0.93809 | 0.94351 | 0.93158 | 0.93286 | 70893.0 |
| 2009-11-18 | B | Futures | 73.81 | 74.45 | 73.08 | 73.82 | 136198.0 |
| 2009-11-18 | B6 | Futures | 1.748 | 1.7526 | 1.7388 | 1.7392 | 100375.0 |
| 2009-11-18 | BFX | Futures | 2866.7 | 2893.4 | 2857.6 | 2857.6 | 1639.0 |
| 2009-11-18 | BR | Futures | 0.23056 | 0.23064 | 0.23056 | 0.23062 | 11.0 |
| 2009-11-18 | BZ | Futures | 78.81 | 78.85 | 78.6 | 78.6 | 2.0 |
| 2009-11-18 | C | Futures | 2107.0 | 2164.0 | 2093.0 | 2160.0 | 2446.0 |
| 2009-11-18 | CB | Futures | 80.686 | 80.686 | 80.686 | 80.686 | 20.0 |
| 2009-11-18 | CC | Futures | 2715.0 | 2817.0 | 2703.0 | 2799.0 | 8985.0 |
| 2009-11-18 | CT | Futures | 58.68 | 59.7 | 58.52 | 59.15 | 9114.0 |
| 2009-11-18 | DC | Futures | 24.87 | 24.93 | 24.49 | 24.49 | 61.0 |
| 2009-11-18 | DX | Futures | 76.919 | 77.011 | 76.556 | 76.842 | 12025.0 |
| 2009-11-18 | E1 | Futures | 1.29977 | 1.31113 | 1.29924 | 1.30611 | 55914.0 |
| 2009-11-18 | E6 | Futures | 1.76148 | 1.77653 | 1.76136 | 1.77037 | 259800.0 |
| 2009-11-18 | E7 | Futures | 1.7446 | 1.7594 | 1.7446 | 1.7534 | 3508.0 |
| 2009-11-18 | ED | Futures | 94.2687 | 94.2758 | 94.2687 | 94.2734 | 101549.0 |
| 2009-11-18 | ER | Futures | 97.169 | 97.174 | 97.159 | 97.169 | 41476.0 |
| 2009-11-18 | EW | Futures | 685.7 | 688.5 | 680.8 | 682.6 | 26820.0 |
| 2009-11-18 | FBTP | Futures | 63.05 | 63.09 | 62.85 | 62.96 | 2502.0 |
| 2009-11-18 | FCE | Futures | 2556.6 | 2560.6 | 2528.4 | 2538.4 | 116384.0 |
| 2009-11-18 | FDAX | Futures | 6320.7 | 6362.1 | 6279.9 | 6308.8 | 119504.0 |
| 2009-11-18 | FESX | Futures | 1743.5 | 1751.9 | 1731.0 | 1738.8 | 876667.0 |
| 2009-11-18 | FEU3 | Futures | 97.741 | 97.741 | 97.741 | 97.741 | 217.0 |
| 2009-11-18 | FGBL | Futures | 94.25 | 94.28 | 93.95 | 94.2 | 619007.0 |
| 2009-11-18 | FGBM | Futures | 99.68 | 99.68 | 99.5 | 99.62 | 346176.0 |
| 2009-11-18 | FGBS | Futures | 105.04 | 105.04 | 104.987 | 105.021 | 474691.0 |
| 2009-11-18 | FGBX | Futures | 88.03 | 88.03 | 87.53 | 87.87 | 1350.0 |
| 2009-11-18 | FTDX | Futures | 697.2 | 703.5 | 695.4 | 697.7 | 540.0 |
| 2009-11-18 | FTI | Futures | 262.97 | 263.79 | 259.71 | 260.81 | 19184.0 |
| 2009-11-18 | FTUK | Futures | 3559.1 | 3563.5 | 3534.9 | 3544.5 | 75167.0 |
| 2009-11-18 | G | Futures | 76.83 | 76.95 | 76.67 | 76.8 | 85793.0 |
| 2009-11-18 | GF | Futures | 252.118 | 252.39 | 248.592 | 248.796 | 2194.0 |
| 2009-11-18 | GSCI | Futures | 1009.23 | 1016.0 | 999.56 | 1003.43 | 128.0 |
| 2009-11-18 | HE | Futures | 85.84 | 86.576 | 85.405 | 85.941 | 8669.0 |
| 2009-11-18 | HG | Futures | 4.3318 | 4.4042 | 4.3028 | 4.3256 | 8950.0 |
| 2009-11-18 | HO | Futures | 2.0035 | 2.0205 | 1.9755 | 1.9865 | 5881.0 |
| 2009-11-18 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-18 | J1 | Futures | 0.0140598 | 0.0141088 | 0.0140334 | 0.0140359 | 66419.0 |
| 2009-11-18 | J7 | Futures | 0.01388 | 0.013922 | 0.013853 | 0.013853 | 21.0 |
| 2009-11-18 | JB | Futures | 117.42 | 117.59 | 117.37 | 117.54 | 2183.0 |
| 2009-11-18 | KC | Futures | 359.13 | 369.56 | 359.13 | 364.41 | 7473.0 |
| 2009-11-18 | KE | Futures | 2658.05 | 2697.6 | 2616.17 | 2630.13 | 9293.0 |
| 2009-11-18 | L | Futures | 97.73 | 97.838 | 97.73 | 97.779 | 146173.0 |
> showing 50 of 89 rows — these rows as CSV