PREVIEW / futures_daily / 2010-08-02
file: by_date/futures_daily/2010/2010-08-02.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 |
|---|---|---|---|---|---|---|---|
| 2010-08-02 | ES | Futures | 1077.28 | 1096.54 | 1074.6 | 1094.1 | 1610959.0 |
| 2010-08-02 | NQ | Futures | 2115.1 | 2152.45 | 2110.29 | 2143.96 | 244657.0 |
| 2010-08-02 | YM | Futures | 9670.3 | 9840.4 | 9660.1 | 9816.4 | 106176.0 |
| 2010-08-02 | CL | Futures | 167.62 | 173.61 | 167.37 | 172.7 | 306098.0 |
| 2010-08-02 | GC | Futures | 1609.1 | 1622.8 | 1599.4 | 1611.3 | 89850.0 |
| 2010-08-02 | ZN | Futures | 101.438448 | 101.451254 | 101.131098 | 101.15671 | 712437.0 |
| 2010-08-02 | A6 | Futures | 0.74729 | 0.75442 | 0.74596 | 0.75276 | 70146.0 |
| 2010-08-02 | AD | Futures | 0.95844 | 0.96742 | 0.95824 | 0.96406 | 64713.0 |
| 2010-08-02 | B | Futures | 68.24 | 70.71 | 68.22 | 70.41 | 75146.0 |
| 2010-08-02 | B6 | Futures | 1.6309 | 1.6505 | 1.6284 | 1.649 | 119829.0 |
| 2010-08-02 | BFX | Futures | 2903.1 | 2947.7 | 2903.1 | 2941.1 | 156.0 |
| 2010-08-02 | BR | Futures | 0.23708 | 0.23708 | 0.23708 | 0.23708 | 72.0 |
| 2010-08-02 | BZ | Futures | 74.42 | 75.76 | 74.42 | 75.76 | 58.0 |
| 2010-08-02 | C | Futures | 2483.0 | 2487.0 | 2446.0 | 2461.0 | 4261.0 |
| 2010-08-02 | CB | Futures | 87.881 | 88.606 | 87.881 | 87.881 | 6.0 |
| 2010-08-02 | CC | Futures | 2570.0 | 2592.0 | 2535.0 | 2570.0 | 7942.0 |
| 2010-08-02 | CT | Futures | 69.13 | 70.71 | 69.13 | 70.54 | 106.0 |
| 2010-08-02 | DC | Futures | 23.74 | 23.74 | 23.57 | 23.59 | 187.0 |
| 2010-08-02 | DX | Futures | 82.216 | 82.317 | 81.54 | 81.697 | 16257.0 |
| 2010-08-02 | E1 | Futures | 1.26263 | 1.26972 | 1.25423 | 1.26342 | 32151.0 |
| 2010-08-02 | E6 | Futures | 1.54434 | 1.5603 | 1.54363 | 1.55699 | 256865.0 |
| 2010-08-02 | E7 | Futures | 1.5336 | 1.5491 | 1.5325 | 1.5458 | 3360.0 |
| 2010-08-02 | ED | Futures | 94.5179 | 94.5321 | 94.5179 | 94.5226 | 96897.0 |
| 2010-08-02 | ER | Futures | 97.272 | 97.281 | 97.242 | 97.262 | 72191.0 |
| 2010-08-02 | EW | Futures | 746.5 | 758.2 | 745.3 | 755.9 | 26377.0 |
| 2010-08-02 | FBTP | Futures | 66.07 | 66.26 | 66.03 | 66.23 | 1950.0 |
| 2010-08-02 | FCE | Futures | 2411.6 | 2471.0 | 2407.4 | 2461.1 | 114088.0 |
| 2010-08-02 | FDAX | Futures | 6729.1 | 6864.6 | 6729.1 | 6836.3 | 110205.0 |
| 2010-08-02 | FESX | Futures | 1708.9 | 1755.9 | 1705.2 | 1742.3 | 1141240.0 |
| 2010-08-02 | FEU3 | Futures | 97.82 | 97.83 | 97.82 | 97.82 | 32.0 |
| 2010-08-02 | FGBL | Futures | 100.33 | 100.36 | 100.04 | 100.24 | 496077.0 |
| 2010-08-02 | FGBM | Futures | 104.66 | 104.77 | 104.52 | 104.7 | 298568.0 |
| 2010-08-02 | FGBS | Futures | 107.279 | 107.338 | 107.249 | 107.333 | 239070.0 |
| 2010-08-02 | FGBX | Futures | 99.1 | 99.28 | 98.66 | 99.06 | 2055.0 |
| 2010-08-02 | FTDX | Futures | 679.2 | 689.7 | 679.2 | 686.2 | 549.0 |
| 2010-08-02 | FTI | Futures | 263.79 | 270.14 | 263.15 | 268.95 | 28391.0 |
| 2010-08-02 | FTUK | Futures | 3631.4 | 3705.8 | 3628.0 | 3685.5 | 92556.0 |
| 2010-08-02 | G | Futures | 81.45 | 81.53 | 81.32 | 81.45 | 52806.0 |
| 2010-08-02 | GF | Futures | 286.718 | 287.034 | 284.192 | 284.445 | 1829.0 |
| 2010-08-02 | GSCI | Futures | 901.13 | 915.39 | 901.13 | 913.18 | 820.0 |
| 2010-08-02 | HE | Futures | 104.201 | 105.485 | 103.773 | 104.86 | 18296.0 |
| 2010-08-02 | HG | Futures | 4.435 | 4.5488 | 4.4216 | 4.5395 | 28929.0 |
| 2010-08-02 | HO | Futures | 1.8299 | 1.9017 | 1.8293 | 1.8875 | 57899.0 |
| 2010-08-02 | HRC | Futures | 2826.8 | 2826.8 | 2826.8 | 2826.8 | 7.0 |
| 2010-08-02 | J1 | Futures | 0.0145601 | 0.0145802 | 0.0144833 | 0.0145487 | 84968.0 |
| 2010-08-02 | J7 | Futures | 0.014454 | 0.014468 | 0.014377 | 0.014439 | 100.0 |
| 2010-08-02 | JB | Futures | 120.91 | 120.98 | 120.8 | 120.85 | 1753.0 |
| 2010-08-02 | KC | Futures | 441.0 | 455.81 | 432.08 | 433.21 | 16690.0 |
| 2010-08-02 | KE | Futures | 2866.84 | 3080.97 | 2860.44 | 2985.09 | 21217.0 |
| 2010-08-02 | L | Futures | 98.106 | 98.106 | 98.096 | 98.096 | 14344.0 |
> showing 50 of 89 rows — these rows as CSV