PREVIEW / futures_daily / 2010-08-23
file: by_date/futures_daily/2010/2010-08-23.parquet size: 9 KB rows: 90
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-23 | ES | Futures | 1043.63 | 1053.63 | 1038.02 | 1039.24 | 1567358.0 |
| 2010-08-23 | NQ | Futures | 2065.3 | 2085.67 | 2042.66 | 2048.04 | 275129.0 |
| 2010-08-23 | YM | Futures | 9432.7 | 9510.3 | 9378.1 | 9391.1 | 114381.0 |
| 2010-08-23 | CL | Futures | 155.89 | 157.11 | 153.46 | 154.2 | 252439.0 |
| 2010-08-23 | GC | Futures | 1670.8 | 1677.3 | 1663.1 | 1669.8 | 56766.0 |
| 2010-08-23 | ZN | Futures | 102.847137 | 103.116069 | 102.693462 | 102.988006 | 824400.0 |
| 2010-08-23 | A6 | Futures | 0.73369 | 0.74273 | 0.7332 | 0.7385 | 83391.0 |
| 2010-08-23 | AD | Futures | 0.94125 | 0.9452 | 0.9375 | 0.93908 | 64479.0 |
| 2010-08-23 | B | Futures | 64.69 | 65.07 | 63.64 | 63.96 | 125989.0 |
| 2010-08-23 | B6 | Futures | 1.6121 | 1.6209 | 1.6083 | 1.6118 | 90258.0 |
| 2010-08-23 | BFX | Futures | 2798.7 | 2863.1 | 2798.7 | 2813.9 | 282.0 |
| 2010-08-23 | BR | Futures | 0.23609 | 0.23609 | 0.23609 | 0.23609 | 206.0 |
| 2010-08-23 | BZ | Futures | 69.95 | 70.01 | 68.49 | 68.82 | 421.0 |
| 2010-08-23 | C | Futures | 2245.0 | 2288.0 | 2241.0 | 2279.0 | 3055.0 |
| 2010-08-23 | CB | Futures | 96.09 | 96.09 | 96.09 | 96.09 | 5.0 |
| 2010-08-23 | CC | Futures | 2348.0 | 2370.0 | 2331.0 | 2346.0 | 6256.0 |
| 2010-08-23 | CSC | Futures | 3.816 | 3.816 | 3.816 | 3.816 | 2.0 |
| 2010-08-23 | CT | Futures | 73.43 | 74.47 | 73.43 | 73.73 | 36.0 |
| 2010-08-23 | DC | Futures | 23.92 | 24.06 | 23.77 | 23.95 | 171.0 |
| 2010-08-23 | DX | Futures | 83.823 | 84.035 | 83.612 | 83.887 | 18463.0 |
| 2010-08-23 | E1 | Futures | 1.26972 | 1.27524 | 1.26132 | 1.26368 | 24567.0 |
| 2010-08-23 | E6 | Futures | 1.50271 | 1.50531 | 1.49538 | 1.4994 | 246326.0 |
| 2010-08-23 | E7 | Futures | 1.4925 | 1.4944 | 1.4847 | 1.4886 | 2813.0 |
| 2010-08-23 | ED | Futures | 94.5938 | 94.6152 | 94.5914 | 94.6104 | 117763.0 |
| 2010-08-23 | ER | Futures | 97.335 | 97.34 | 97.316 | 97.326 | 119740.0 |
| 2010-08-23 | EW | Futures | 720.3 | 727.7 | 713.0 | 714.2 | 23195.0 |
| 2010-08-23 | FBTP | Futures | 67.07 | 67.39 | 67.07 | 67.24 | 1507.0 |
| 2010-08-23 | FCE | Futures | 2329.0 | 2361.0 | 2320.5 | 2338.9 | 97533.0 |
| 2010-08-23 | FDAX | Futures | 6549.1 | 6589.3 | 6523.5 | 6534.4 | 107625.0 |
| 2010-08-23 | FESX | Futures | 1637.1 | 1661.2 | 1633.4 | 1643.3 | 901683.0 |
| 2010-08-23 | FEU3 | Futures | 97.889 | 97.889 | 97.884 | 97.884 | 2.0 |
| 2010-08-23 | FGBL | Futures | 103.66 | 103.79 | 103.56 | 103.69 | 507881.0 |
| 2010-08-23 | FGBM | Futures | 106.46 | 106.58 | 106.44 | 106.54 | 247494.0 |
| 2010-08-23 | FGBS | Futures | 107.809 | 107.863 | 107.79 | 107.834 | 291736.0 |
| 2010-08-23 | FGBX | Futures | 107.25 | 107.43 | 106.86 | 107.15 | 3453.0 |
| 2010-08-23 | FTDX | Futures | 650.0 | 657.1 | 650.0 | 651.8 | 122.0 |
| 2010-08-23 | FTI | Futures | 254.86 | 256.46 | 253.14 | 254.34 | 22871.0 |
| 2010-08-23 | FTUK | Futures | 3589.5 | 3624.2 | 3565.7 | 3592.6 | 75252.0 |
| 2010-08-23 | G | Futures | 83.9 | 84.13 | 83.87 | 84.04 | 76921.0 |
| 2010-08-23 | GF | Futures | 294.43 | 296.2 | 294.114 | 295.504 | 2243.0 |
| 2010-08-23 | GSCI | Futures | 861.07 | 862.94 | 849.87 | 852.93 | 661.0 |
| 2010-08-23 | HE | Futures | 102.488 | 103.674 | 102.093 | 103.048 | 11729.0 |
| 2010-08-23 | HG | Futures | 4.4258 | 4.4465 | 4.3945 | 4.4212 | 5955.0 |
| 2010-08-23 | HO | Futures | 1.7252 | 1.7373 | 1.7066 | 1.7104 | 10840.0 |
| 2010-08-23 | HRC | Futures | 2753.7 | 2753.7 | 2753.7 | 2753.7 | 0.0 |
| 2010-08-23 | J1 | Futures | 0.0147022 | 0.0147878 | 0.0146859 | 0.0147563 | 77487.0 |
| 2010-08-23 | J7 | Futures | 0.014584 | 0.014676 | 0.014578 | 0.014645 | 186.0 |
| 2010-08-23 | JB | Futures | 121.75 | 121.75 | 121.57 | 121.66 | 1319.0 |
| 2010-08-23 | KC | Futures | 459.03 | 467.83 | 452.46 | 454.44 | 8963.0 |
| 2010-08-23 | KE | Futures | 3004.27 | 3072.45 | 3004.27 | 3055.4 | 5017.0 |
> showing 50 of 90 rows — these rows as CSV