PREVIEW / futures_daily / 2009-12-30
file: by_date/futures_daily/2009/2009-12-30.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-30 | ES | Futures | 1086.88 | 1088.09 | 1078.88 | 1087.61 | 596890.0 |
| 2009-12-30 | NQ | Futures | 2116.19 | 2126.65 | 2106.29 | 2122.69 | 128388.0 |
| 2009-12-30 | YM | Futures | 9577.4 | 9585.6 | 9521.7 | 9582.0 | 44971.0 |
| 2009-12-30 | CL | Futures | 186.87 | 189.24 | 186.07 | 188.01 | 156075.0 |
| 2009-12-30 | GC | Futures | 1512.0 | 1512.3 | 1495.6 | 1503.7 | 91654.0 |
| 2009-12-30 | ZN | Futures | 93.207292 | 93.383606 | 93.144323 | 93.371012 | 362111.0 |
| 2009-12-30 | A6 | Futures | 0.72128 | 0.72266 | 0.71795 | 0.72095 | 32904.0 |
| 2009-12-30 | AD | Futures | 0.94638 | 0.94638 | 0.93315 | 0.93542 | 61432.0 |
| 2009-12-30 | B | Futures | 70.92 | 71.92 | 70.91 | 71.4 | 36571.0 |
| 2009-12-30 | B6 | Futures | 1.6511 | 1.671 | 1.6436 | 1.6681 | 76598.0 |
| 2009-12-30 | BFX | Futures | 2859.4 | 2859.4 | 2836.7 | 2847.5 | 158.0 |
| 2009-12-30 | C | Futures | 2263.0 | 2274.0 | 2254.0 | 2258.0 | 2648.0 |
| 2009-12-30 | CB | Futures | 71.803 | 71.803 | 71.433 | 71.433 | 5.0 |
| 2009-12-30 | CC | Futures | 2776.0 | 2809.0 | 2776.0 | 2790.0 | 2431.0 |
| 2009-12-30 | CT | Futures | 61.2 | 61.63 | 60.97 | 61.5 | 4775.0 |
| 2009-12-30 | DC | Futures | 24.08 | 24.08 | 23.95 | 23.98 | 202.0 |
| 2009-12-30 | DX | Futures | 79.627 | 79.881 | 79.474 | 79.601 | 12487.0 |
| 2009-12-30 | E1 | Futures | 1.27258 | 1.27429 | 1.26572 | 1.27218 | 31743.0 |
| 2009-12-30 | E6 | Futures | 1.69836 | 1.70002 | 1.68948 | 1.69682 | 134788.0 |
| 2009-12-30 | E7 | Futures | 1.6868 | 1.6882 | 1.6779 | 1.685 | 2139.0 |
| 2009-12-30 | EBM | Futures | 226.89 | 226.89 | 225.62 | 226.47 | 1112.0 |
| 2009-12-30 | ED | Futures | 94.2968 | 94.3205 | 94.2921 | 94.311 | 116508.0 |
| 2009-12-30 | ER | Futures | 97.237 | 97.242 | 97.223 | 97.228 | 82812.0 |
| 2009-12-30 | EW | Futures | 713.8 | 716.5 | 709.1 | 713.3 | 16359.0 |
| 2009-12-30 | FBTP | Futures | 62.92 | 62.94 | 62.75 | 62.75 | 2934.0 |
| 2009-12-30 | FCE | Futures | 2585.7 | 2592.6 | 2566.5 | 2570.7 | 39140.0 |
| 2009-12-30 | FDAX | Futures | 6569.4 | 6573.2 | 6506.6 | 6509.9 | 26500.0 |
| 2009-12-30 | FESX | Futures | 1789.8 | 1793.3 | 1774.2 | 1779.0 | 314584.0 |
| 2009-12-30 | FEU3 | Futures | 97.796 | 97.8 | 97.791 | 97.791 | 815.0 |
| 2009-12-30 | FGBL | Futures | 93.68 | 93.74 | 93.31 | 93.44 | 261375.0 |
| 2009-12-30 | FGBM | Futures | 99.57 | 99.66 | 99.39 | 99.4 | 153666.0 |
| 2009-12-30 | FGBS | Futures | 105.201 | 105.24 | 105.114 | 105.124 | 240643.0 |
| 2009-12-30 | FGBX | Futures | 86.68 | 87.02 | 86.38 | 86.68 | 2419.0 |
| 2009-12-30 | FTDX | Futures | 721.2 | 726.5 | 718.6 | 720.3 | 166.0 |
| 2009-12-30 | FTI | Futures | 274.79 | 275.2 | 272.3 | 273.4 | 11312.0 |
| 2009-12-30 | FTUK | Futures | 3608.7 | 3618.1 | 3579.3 | 3581.3 | 38784.0 |
| 2009-12-30 | G | Futures | 74.42 | 74.91 | 74.42 | 74.82 | 34656.0 |
| 2009-12-30 | GF | Futures | 257.407 | 258.764 | 257.34 | 258.018 | 587.0 |
| 2009-12-30 | GSCI | Futures | 995.31 | 1003.46 | 991.71 | 997.21 | 240.0 |
| 2009-12-30 | HE | Futures | 87.58 | 88.215 | 87.011 | 87.814 | 9100.0 |
| 2009-12-30 | HG | Futures | 4.5553 | 4.638 | 4.5435 | 4.6146 | 12367.0 |
| 2009-12-30 | HO | Futures | 1.977 | 1.9926 | 1.9738 | 1.9808 | 11278.0 |
| 2009-12-30 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-30 | J1 | Futures | 0.0136842 | 0.0136968 | 0.0135684 | 0.0136137 | 60619.0 |
| 2009-12-30 | J7 | Futures | 0.013522 | 0.013522 | 0.013402 | 0.013443 | 799.0 |
| 2009-12-30 | JB | Futures | 117.93 | 117.98 | 117.93 | 117.98 | 2199.0 |
| 2009-12-30 | KC | Futures | 355.3 | 359.6 | 354.0 | 355.69 | 6845.0 |
| 2009-12-30 | KE | Futures | 2425.15 | 2464.72 | 2425.15 | 2444.37 | 4481.0 |
| 2009-12-30 | L | Futures | 97.76 | 97.779 | 97.76 | 97.769 | 24691.0 |
| 2009-12-30 | LBS | Futures | 771.5 | 774.4 | 763.6 | 773.8 | 452.0 |
> showing 50 of 88 rows — these rows as CSV