PREVIEW / futures_daily / 2009-08-19
file: by_date/futures_daily/2009/2009-08-19.parquet size: 8 KB rows: 86
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-08-19 | ES | Futures | 949.37 | 958.24 | 937.13 | 956.56 | 2127507.0 |
| 2009-08-19 | NQ | Futures | 1786.09 | 1802.42 | 1761.88 | 1800.45 | 292131.0 |
| 2009-08-19 | YM | Futures | 8307.0 | 8390.0 | 8216.8 | 8369.3 | 144978.0 |
| 2009-08-19 | CL | Futures | 179.39 | 185.41 | 174.1 | 184.21 | 376871.0 |
| 2009-08-19 | GC | Futures | 1299.8 | 1308.9 | 1290.2 | 1306.1 | 80904.0 |
| 2009-08-19 | ZN | Futures | 92.677289 | 93.342172 | 92.615726 | 92.96048 | 944592.0 |
| 2009-08-19 | A6 | Futures | 0.66283 | 0.66685 | 0.65568 | 0.6646 | 85511.0 |
| 2009-08-19 | AD | Futures | 0.89635 | 0.90267 | 0.88865 | 0.90099 | 64919.0 |
| 2009-08-19 | B | Futures | 69.26 | 70.94 | 67.41 | 70.65 | 145616.0 |
| 2009-08-19 | B6 | Futures | 1.7246 | 1.7283 | 1.7053 | 1.7229 | 119567.0 |
| 2009-08-19 | BFX | Futures | 2561.2 | 2576.0 | 2547.5 | 2574.1 | 1652.0 |
| 2009-08-19 | BR | Futures | 0.21331 | 0.21331 | 0.21086 | 0.21086 | 1.0 |
| 2009-08-19 | BZ | Futures | 72.12 | 73.69 | 72.12 | 73.69 | 11.0 |
| 2009-08-19 | C | Futures | 1809.0 | 1921.0 | 1807.0 | 1912.0 | 2038.0 |
| 2009-08-19 | CB | Futures | 68.21 | 68.21 | 67.074 | 68.21 | 10.0 |
| 2009-08-19 | CC | Futures | 2398.0 | 2593.0 | 2368.0 | 2525.0 | 9284.0 |
| 2009-08-19 | CT | Futures | 50.34 | 50.79 | 50.14 | 50.29 | 60.0 |
| 2009-08-19 | DC | Futures | 22.3 | 22.86 | 22.3 | 22.78 | 179.0 |
| 2009-08-19 | DX | Futures | 80.819 | 81.177 | 80.25 | 80.394 | 8964.0 |
| 2009-08-19 | E1 | Futures | 1.23099 | 1.24648 | 1.22808 | 1.24397 | 50415.0 |
| 2009-08-19 | E6 | Futures | 1.67737 | 1.69375 | 1.67203 | 1.69043 | 264852.0 |
| 2009-08-19 | E7 | Futures | 1.6612 | 1.6763 | 1.6551 | 1.6731 | 2462.0 |
| 2009-08-19 | ED | Futures | 94.0038 | 94.018 | 93.9967 | 94.0156 | 105208.0 |
| 2009-08-19 | ER | Futures | 97.12 | 97.135 | 97.11 | 97.125 | 42844.0 |
| 2009-08-19 | EW | Futures | 615.2 | 620.1 | 606.2 | 618.7 | 29596.0 |
| 2009-08-19 | FCE | Futures | 2246.4 | 2275.2 | 2224.8 | 2254.9 | 117867.0 |
| 2009-08-19 | FDAX | Futures | 5727.2 | 5793.6 | 5661.4 | 5740.4 | 136127.0 |
| 2009-08-19 | FESX | Futures | 1560.3 | 1578.8 | 1541.8 | 1563.3 | 1028239.0 |
| 2009-08-19 | FEU3 | Futures | 97.702 | 97.707 | 97.702 | 97.702 | 12.0 |
| 2009-08-19 | FGBL | Futures | 92.92 | 93.29 | 92.9 | 93.24 | 645290.0 |
| 2009-08-19 | FGBM | Futures | 98.38 | 98.59 | 98.33 | 98.51 | 324348.0 |
| 2009-08-19 | FGBS | Futures | 104.176 | 104.215 | 104.128 | 104.171 | 343583.0 |
| 2009-08-19 | FGBX | Futures | 86.37 | 87.16 | 86.37 | 87.02 | 689.0 |
| 2009-08-19 | FTDX | Futures | 615.7 | 615.7 | 602.7 | 612.1 | 770.0 |
| 2009-08-19 | FTI | Futures | 233.98 | 236.38 | 231.14 | 234.52 | 30117.0 |
| 2009-08-19 | FTUK | Futures | 3084.1 | 3134.2 | 3067.8 | 3104.0 | 96526.0 |
| 2009-08-19 | G | Futures | 76.56 | 76.84 | 76.41 | 76.78 | 60534.0 |
| 2009-08-19 | GF | Futures | 279.904 | 280.734 | 278.798 | 279.628 | 588.0 |
| 2009-08-19 | GSCI | Futures | 930.64 | 964.27 | 926.56 | 960.9 | 409.0 |
| 2009-08-19 | HE | Futures | 66.03 | 69.028 | 65.28 | 68.578 | 13577.0 |
| 2009-08-19 | HG | Futures | 3.8775 | 3.9088 | 3.7068 | 3.8615 | 12153.0 |
| 2009-08-19 | HO | Futures | 1.892 | 1.947 | 1.8587 | 1.9358 | 7244.0 |
| 2009-08-19 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-19 | J1 | Futures | 0.0132941 | 0.0134452 | 0.0132589 | 0.0133999 | 100468.0 |
| 2009-08-19 | J7 | Futures | 0.013085 | 0.013256 | 0.01308 | 0.013215 | 82.0 |
| 2009-08-19 | JB | Futures | 116.78 | 117.07 | 116.73 | 117.07 | 2188.0 |
| 2009-08-19 | KC | Futures | 338.5 | 340.53 | 334.83 | 340.13 | 4486.0 |
| 2009-08-19 | KE | Futures | 2388.58 | 2435.35 | 2338.22 | 2384.99 | 4942.0 |
| 2009-08-19 | L | Futures | 97.553 | 97.612 | 97.553 | 97.583 | 68732.0 |
| 2009-08-19 | LBS | Futures | 739.6 | 739.6 | 721.4 | 727.9 | 538.0 |
> showing 50 of 86 rows — these rows as CSV