PREVIEW / futures_daily / 2009-06-18
file: by_date/futures_daily/2009/2009-06-18.parquet size: 8 KB rows: 85
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-06-18 | ES | Futures | 868.77 | 880.53 | 866.37 | 876.21 | 1888281.0 |
| 2009-06-18 | NQ | Futures | 1636.31 | 1647.29 | 1625.05 | 1632.37 | 316590.0 |
| 2009-06-18 | YM | Futures | 7612.3 | 7707.0 | 7596.0 | 7662.8 | 127188.0 |
| 2009-06-18 | CL | Futures | 187.92 | 190.31 | 186.34 | 189.21 | 150454.0 |
| 2009-06-18 | GC | Futures | 1301.4 | 1306.9 | 1288.2 | 1293.9 | 78321.0 |
| 2009-06-18 | ZN | Futures | 90.756516 | 90.830392 | 89.722254 | 89.845381 | 922654.0 |
| 2009-06-18 | A6 | Futures | 0.6335 | 0.6433 | 0.63173 | 0.6392 | 65108.0 |
| 2009-06-18 | AD | Futures | 0.87294 | 0.87976 | 0.86938 | 0.87215 | 59735.0 |
| 2009-06-18 | B | Futures | 67.91 | 68.38 | 66.77 | 67.97 | 101337.0 |
| 2009-06-18 | B6 | Futures | 1.7071 | 1.7151 | 1.6858 | 1.7027 | 118488.0 |
| 2009-06-18 | BFX | Futures | 2244.3 | 2263.1 | 2227.2 | 2249.7 | 617.0 |
| 2009-06-18 | BZ | Futures | 73.13 | 74.34 | 73.02 | 74.18 | 34.0 |
| 2009-06-18 | C | Futures | 1757.0 | 1777.0 | 1742.0 | 1749.0 | 2178.0 |
| 2009-06-18 | CB | Futures | 73.184 | 73.184 | 73.184 | 73.184 | 9.0 |
| 2009-06-18 | CC | Futures | 2272.0 | 2288.0 | 2257.0 | 2273.0 | 4588.0 |
| 2009-06-18 | CT | Futures | 48.16 | 50.42 | 47.63 | 49.84 | 8885.0 |
| 2009-06-18 | DC | Futures | 21.2 | 21.31 | 20.83 | 20.97 | 375.0 |
| 2009-06-18 | DX | Futures | 82.502 | 83.081 | 82.379 | 82.917 | 4617.0 |
| 2009-06-18 | E1 | Futures | 1.22782 | 1.23139 | 1.21603 | 1.2204 | 54996.0 |
| 2009-06-18 | E6 | Futures | 1.65387 | 1.66123 | 1.64568 | 1.64912 | 202138.0 |
| 2009-06-18 | E7 | Futures | 1.6372 | 1.6442 | 1.629 | 1.6322 | 2890.0 |
| 2009-06-18 | ED | Futures | 93.7111 | 93.7253 | 93.5931 | 93.645 | 399934.0 |
| 2009-06-18 | ER | Futures | 96.792 | 96.836 | 96.782 | 96.816 | 155017.0 |
| 2009-06-18 | EW | Futures | 550.1 | 556.5 | 546.2 | 554.8 | 26410.0 |
| 2009-06-18 | FCE | Futures | 2064.3 | 2091.4 | 2046.7 | 2081.6 | 63007.0 |
| 2009-06-18 | FDAX | Futures | 5288.4 | 5335.5 | 5237.9 | 5316.9 | 56207.0 |
| 2009-06-18 | FESX | Futures | 1420.7 | 1441.6 | 1409.3 | 1435.6 | 1158599.0 |
| 2009-06-18 | FEU3 | Futures | 97.367 | 97.401 | 97.367 | 97.392 | 2590.0 |
| 2009-06-18 | FGBL | Futures | 90.96 | 91.11 | 90.49 | 90.66 | 715874.0 |
| 2009-06-18 | FGBM | Futures | 97.05 | 97.18 | 96.8 | 96.97 | 407300.0 |
| 2009-06-18 | FGBS | Futures | 103.584 | 103.695 | 103.526 | 103.637 | 542805.0 |
| 2009-06-18 | FGBX | Futures | 81.7 | 81.98 | 80.77 | 81.34 | 1831.0 |
| 2009-06-18 | FTDX | Futures | 543.4 | 546.1 | 533.6 | 543.4 | 2542.0 |
| 2009-06-18 | FTI | Futures | 204.92 | 206.84 | 202.4 | 206.1 | 10080.0 |
| 2009-06-18 | FTUK | Futures | 2820.9 | 2841.8 | 2790.4 | 2825.5 | 133347.0 |
| 2009-06-18 | G | Futures | 75.06 | 75.49 | 74.64 | 74.84 | 85550.0 |
| 2009-06-18 | GF | Futures | 268.257 | 272.116 | 267.913 | 269.566 | 725.0 |
| 2009-06-18 | GSCI | Futures | 972.18 | 975.72 | 963.62 | 972.7 | 114.0 |
| 2009-06-18 | HE | Futures | 86.412 | 88.167 | 85.645 | 87.619 | 5501.0 |
| 2009-06-18 | HG | Futures | 3.1789 | 3.2098 | 3.1319 | 3.2042 | 6625.0 |
| 2009-06-18 | HO | Futures | 1.952 | 1.9665 | 1.9223 | 1.9371 | 7729.0 |
| 2009-06-18 | HRC | Futures | 2328.7 | 2328.7 | 2328.7 | 2328.7 | 0.0 |
| 2009-06-18 | J1 | Futures | 0.0131683 | 0.0131783 | 0.0130323 | 0.0130411 | 73098.0 |
| 2009-06-18 | J7 | Futures | 0.012981 | 0.012992 | 0.012852 | 0.012861 | 41.0 |
| 2009-06-18 | JB | Futures | 115.18 | 115.18 | 115.18 | 115.18 | 2913.0 |
| 2009-06-18 | KC | Futures | 330.56 | 336.1 | 326.41 | 333.75 | 5195.0 |
| 2009-06-18 | KE | Futures | 3036.38 | 3058.32 | 2998.6 | 3018.1 | 5540.0 |
| 2009-06-18 | L | Futures | 96.984 | 97.013 | 96.934 | 96.993 | 58131.0 |
| 2009-06-18 | LBS | Futures | 960.6 | 985.2 | 960.6 | 967.4 | 234.0 |
| 2009-06-18 | LE | Futures | 143.32 | 144.554 | 143.1 | 143.981 | 4808.0 |
> showing 50 of 85 rows — these rows as CSV