PREVIEW / futures_daily / 2009-12-10
file: by_date/futures_daily/2009/2009-12-10.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-10 | ES | Futures | 1056.16 | 1067.02 | 1053.75 | 1062.92 | 1327831.0 |
| 2009-12-10 | NQ | Futures | 2022.32 | 2041.51 | 2016.39 | 2031.91 | 183615.0 |
| 2009-12-10 | YM | Futures | 9378.3 | 9485.1 | 9354.5 | 9446.8 | 66163.0 |
| 2009-12-10 | CL | Futures | 172.3 | 173.73 | 169.89 | 171.67 | 407657.0 |
| 2009-12-10 | GC | Futures | 1555.5 | 1565.9 | 1544.1 | 1550.1 | 164026.0 |
| 2009-12-10 | ZN | Futures | 95.524566 | 95.650504 | 94.920059 | 95.2475 | 843627.0 |
| 2009-12-10 | A6 | Futures | 0.73217 | 0.73981 | 0.7316 | 0.73802 | 73023.0 |
| 2009-12-10 | AD | Futures | 0.93562 | 0.94234 | 0.93286 | 0.94006 | 69222.0 |
| 2009-12-10 | B | Futures | 67.66 | 68.07 | 66.15 | 66.81 | 91136.0 |
| 2009-12-10 | B6 | Futures | 1.6902 | 1.6968 | 1.6832 | 1.6882 | 78459.0 |
| 2009-12-10 | BR | Futures | 0.22619 | 0.22619 | 0.22619 | 0.22619 | 11.0 |
| 2009-12-10 | C | Futures | 2291.0 | 2310.0 | 2285.0 | 2309.0 | 12088.0 |
| 2009-12-10 | CB | Futures | 72.297 | 72.79 | 72.297 | 72.544 | 22.0 |
| 2009-12-10 | CC | Futures | 2921.0 | 2941.0 | 2907.0 | 2936.0 | 4457.0 |
| 2009-12-10 | CT | Futures | 60.64 | 61.06 | 60.01 | 60.1 | 6600.0 |
| 2009-12-10 | DC | Futures | 25.1 | 25.3 | 25.07 | 25.24 | 169.0 |
| 2009-12-10 | DX | Futures | 77.649 | 77.888 | 77.527 | 77.705 | 12452.0 |
| 2009-12-10 | E1 | Futures | 1.28603 | 1.2888 | 1.28062 | 1.28497 | 38783.0 |
| 2009-12-10 | E6 | Futures | 1.74394 | 1.74678 | 1.7379 | 1.74193 | 146904.0 |
| 2009-12-10 | E7 | Futures | 1.7272 | 1.7349 | 1.7258 | 1.7298 | 1272.0 |
| 2009-12-10 | EBM | Futures | 220.12 | 220.97 | 218.85 | 220.55 | 4052.0 |
| 2009-12-10 | ED | Futures | 94.2826 | 94.2873 | 94.2542 | 94.2684 | 180438.0 |
| 2009-12-10 | ER | Futures | 97.184 | 97.193 | 97.164 | 97.174 | 134183.0 |
| 2009-12-10 | EW | Futures | 674.7 | 682.3 | 672.2 | 679.2 | 39519.0 |
| 2009-12-10 | FBTP | Futures | 63.2 | 63.31 | 62.89 | 63.24 | 7839.0 |
| 2009-12-10 | FCE | Futures | 2487.6 | 2523.4 | 2486.6 | 2517.4 | 102753.0 |
| 2009-12-10 | FDAX | Futures | 6145.0 | 6248.9 | 6133.1 | 6207.6 | 149102.0 |
| 2009-12-10 | FESX | Futures | 1683.8 | 1707.7 | 1679.6 | 1701.8 | 90962.0 |
| 2009-12-10 | FEU3 | Futures | 97.756 | 97.756 | 97.736 | 97.736 | 1341.0 |
| 2009-12-10 | FGBL | Futures | 95.16 | 95.19 | 94.79 | 94.92 | 609039.0 |
| 2009-12-10 | FGBM | Futures | 100.45 | 100.5 | 100.18 | 100.23 | 405824.0 |
| 2009-12-10 | FGBS | Futures | 105.348 | 105.372 | 105.275 | 105.289 | 478784.0 |
| 2009-12-10 | FGBX | Futures | 88.51 | 88.6 | 87.92 | 88.06 | 2207.0 |
| 2009-12-10 | FTDX | Futures | 716.8 | 721.2 | 716.8 | 719.0 | 242.0 |
| 2009-12-10 | FTI | Futures | 255.42 | 259.3 | 255.18 | 259.05 | 531.0 |
| 2009-12-10 | FTUK | Futures | 3454.7 | 3489.8 | 3452.0 | 3480.1 | 31415.0 |
| 2009-12-10 | G | Futures | 76.84 | 76.85 | 75.94 | 76.16 | 108547.0 |
| 2009-12-10 | GF | Futures | 246.151 | 247.168 | 244.591 | 246.083 | 2692.0 |
| 2009-12-10 | GSCI | Futures | 927.06 | 930.38 | 920.62 | 926.11 | 3797.0 |
| 2009-12-10 | HE | Futures | 87.446 | 87.981 | 85.439 | 87.546 | 12097.0 |
| 2009-12-10 | HG | Futures | 4.3262 | 4.3366 | 4.2511 | 4.2807 | 21338.0 |
| 2009-12-10 | HO | Futures | 1.8253 | 1.8348 | 1.7984 | 1.8138 | 10714.0 |
| 2009-12-10 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-10 | J1 | Futures | 0.0143134 | 0.0143524 | 0.0142354 | 0.0142694 | 75641.0 |
| 2009-12-10 | J7 | Futures | 0.014127 | 0.014165 | 0.014063 | 0.014091 | 88.0 |
| 2009-12-10 | JB | Futures | 118.06 | 118.21 | 117.87 | 117.88 | 1241.0 |
| 2009-12-10 | KC | Futures | 368.84 | 375.34 | 368.84 | 371.44 | 6312.0 |
| 2009-12-10 | KE | Futures | 2384.45 | 2424.02 | 2365.23 | 2383.32 | 5572.0 |
| 2009-12-10 | L | Futures | 97.701 | 97.76 | 97.701 | 97.72 | 48442.0 |
| 2009-12-10 | LBS | Futures | 786.6 | 790.9 | 777.7 | 777.7 | 322.0 |
> showing 50 of 88 rows — these rows as CSV