PREVIEW / futures_daily / 2009-12-23
file: by_date/futures_daily/2009/2009-12-23.parquet size: 9 KB rows: 88
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-12-23 | ES | Futures | 1079.61 | 1085.67 | 1077.19 | 1081.3 | 727761.0 |
| 2009-12-23 | NQ | Futures | 2082.26 | 2095.83 | 2077.73 | 2094.98 | 135399.0 |
| 2009-12-23 | YM | Futures | 9502.5 | 9545.4 | 9476.9 | 9503.4 | 48436.0 |
| 2009-12-23 | CL | Futures | 176.72 | 182.6 | 176.08 | 181.82 | 205585.0 |
| 2009-12-23 | GC | Futures | 1493.5 | 1509.7 | 1486.7 | 1505.8 | 99747.0 |
| 2009-12-23 | ZN | Futures | 93.648078 | 93.925143 | 93.408794 | 93.597702 | 341446.0 |
| 2009-12-23 | A6 | Futures | 0.70503 | 0.71072 | 0.70413 | 0.70933 | 37840.0 |
| 2009-12-23 | AD | Futures | 0.93404 | 0.94342 | 0.93325 | 0.94214 | 53896.0 |
| 2009-12-23 | B | Futures | 67.62 | 69.5 | 67.28 | 69.31 | 108763.0 |
| 2009-12-23 | B6 | Futures | 1.6572 | 1.6607 | 1.6532 | 1.656 | 54172.0 |
| 2009-12-23 | BFX | Futures | 2825.4 | 2833.0 | 2803.9 | 2815.1 | 310.0 |
| 2009-12-23 | BR | Futures | 0.22635 | 0.22635 | 0.22635 | 0.22635 | 1.0 |
| 2009-12-23 | C | Futures | 2271.0 | 2274.0 | 2260.0 | 2263.0 | 2032.0 |
| 2009-12-23 | CB | Futures | 71.828 | 71.828 | 71.828 | 71.828 | 5.0 |
| 2009-12-23 | CC | Futures | 2814.0 | 2827.0 | 2789.0 | 2793.0 | 2760.0 |
| 2009-12-23 | CT | Futures | 60.28 | 60.38 | 59.8 | 60.25 | 4975.0 |
| 2009-12-23 | DC | Futures | 24.43 | 24.43 | 24.11 | 24.11 | 339.0 |
| 2009-12-23 | DX | Futures | 79.942 | 80.039 | 79.398 | 79.556 | 14986.0 |
| 2009-12-23 | E1 | Futures | 1.25807 | 1.27363 | 1.25662 | 1.26941 | 34164.0 |
| 2009-12-23 | E6 | Futures | 1.68711 | 1.70061 | 1.68487 | 1.69694 | 139657.0 |
| 2009-12-23 | E7 | Futures | 1.6754 | 1.6889 | 1.6733 | 1.6851 | 2312.0 |
| 2009-12-23 | EBM | Futures | 222.66 | 223.51 | 221.81 | 222.66 | 1411.0 |
| 2009-12-23 | ED | Futures | 94.311 | 94.3157 | 94.3015 | 94.3063 | 97918.0 |
| 2009-12-23 | ER | Futures | 97.218 | 97.242 | 97.213 | 97.233 | 139339.0 |
| 2009-12-23 | EW | Futures | 707.4 | 714.1 | 705.6 | 712.9 | 15042.0 |
| 2009-12-23 | FBTP | Futures | 63.23 | 63.41 | 63.17 | 63.27 | 1616.0 |
| 2009-12-23 | FCE | Futures | 2567.8 | 2570.4 | 2547.2 | 2556.7 | 55732.0 |
| 2009-12-23 | FDAX | Futures | 6548.7 | 6552.5 | 6490.8 | 6508.3 | 58370.0 |
| 2009-12-23 | FESX | Futures | 1777.8 | 1785.0 | 1762.2 | 1766.4 | 440885.0 |
| 2009-12-23 | FEU3 | Futures | 97.786 | 97.8 | 97.786 | 97.796 | 3582.0 |
| 2009-12-23 | FGBL | Futures | 94.17 | 94.33 | 93.82 | 93.98 | 311002.0 |
| 2009-12-23 | FGBM | Futures | 100.11 | 100.23 | 99.87 | 99.99 | 221478.0 |
| 2009-12-23 | FGBS | Futures | 105.43 | 105.494 | 105.396 | 105.44 | 217617.0 |
| 2009-12-23 | FGBX | Futures | 88.08 | 88.08 | 87.04 | 87.31 | 1070.0 |
| 2009-12-23 | FTDX | Futures | 720.3 | 721.7 | 715.5 | 715.9 | 223.0 |
| 2009-12-23 | FTI | Futures | 272.96 | 273.61 | 270.59 | 271.61 | 15358.0 |
| 2009-12-23 | FTUK | Futures | 3567.2 | 3580.9 | 3553.8 | 3559.8 | 45769.0 |
| 2009-12-23 | G | Futures | 75.58 | 75.72 | 75.09 | 75.23 | 48576.0 |
| 2009-12-23 | GF | Futures | 256.797 | 259.306 | 256.458 | 258.899 | 1682.0 |
| 2009-12-23 | GSCI | Futures | 947.92 | 972.56 | 947.92 | 972.56 | 424.0 |
| 2009-12-23 | HE | Futures | 86.61 | 88.082 | 86.61 | 87.881 | 7477.0 |
| 2009-12-23 | HG | Futures | 4.3276 | 4.4304 | 4.3097 | 4.4194 | 17226.0 |
| 2009-12-23 | HO | Futures | 1.8567 | 1.9229 | 1.8511 | 1.905 | 13348.0 |
| 2009-12-23 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-23 | J1 | Futures | 0.0137144 | 0.0137874 | 0.0137018 | 0.0137295 | 41813.0 |
| 2009-12-23 | J7 | Futures | 0.013558 | 0.013613 | 0.013533 | 0.013558 | 159.0 |
| 2009-12-23 | KC | Futures | 370.4 | 373.26 | 367.14 | 371.31 | 4555.0 |
| 2009-12-23 | KE | Futures | 2335.84 | 2366.36 | 2329.05 | 2365.23 | 5431.0 |
| 2009-12-23 | L | Futures | 97.779 | 97.789 | 97.74 | 97.779 | 33298.0 |
| 2009-12-23 | LBS | Futures | 783.3 | 789.6 | 782.3 | 785.3 | 232.0 |
> showing 50 of 88 rows — these rows as CSV