PREVIEW / futures_daily / 2009-08-11
file: by_date/futures_daily/2009/2009-08-11.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-11 | ES | Futures | 966.16 | 969.75 | 949.85 | 952.72 | 1612512.0 |
| 2009-08-11 | NQ | Futures | 1815.09 | 1821.85 | 1785.81 | 1797.92 | 267557.0 |
| 2009-08-11 | YM | Futures | 8406.3 | 8434.2 | 8284.5 | 8315.1 | 115849.0 |
| 2009-08-11 | CL | Futures | 182.18 | 183.44 | 176.9 | 178.81 | 389079.0 |
| 2009-08-11 | GC | Futures | 1311.1 | 1315.9 | 1304.5 | 1310.0 | 50678.0 |
| 2009-08-11 | ZN | Futures | 91.027395 | 91.606089 | 90.904268 | 91.482962 | 786046.0 |
| 2009-08-11 | A6 | Futures | 0.67143 | 0.67247 | 0.66331 | 0.6654 | 79845.0 |
| 2009-08-11 | AD | Futures | 0.908 | 0.90919 | 0.89408 | 0.89665 | 75481.0 |
| 2009-08-11 | B | Futures | 70.08 | 70.71 | 68.58 | 69.1 | 97316.0 |
| 2009-08-11 | B6 | Futures | 1.7164 | 1.7209 | 1.7111 | 1.7158 | 86941.0 |
| 2009-08-11 | BFX | Futures | 2597.3 | 2597.3 | 2581.7 | 2581.7 | 1.0 |
| 2009-08-11 | BR | Futures | 0.20844 | 0.2107 | 0.20844 | 0.2107 | 9.0 |
| 2009-08-11 | BZ | Futures | 72.37 | 72.37 | 71.58 | 72.08 | 16.0 |
| 2009-08-11 | C | Futures | 1911.0 | 1932.0 | 1880.0 | 1890.0 | 3746.0 |
| 2009-08-11 | CB | Futures | 71.337 | 71.337 | 71.337 | 71.337 | 1.0 |
| 2009-08-11 | CC | Futures | 2562.0 | 2576.0 | 2482.0 | 2511.0 | 6648.0 |
| 2009-08-11 | CT | Futures | 54.93 | 55.1 | 53.9 | 55.05 | 159.0 |
| 2009-08-11 | DC | Futures | 22.29 | 22.64 | 22.29 | 22.5 | 38.0 |
| 2009-08-11 | DX | Futures | 81.233 | 81.346 | 80.977 | 81.151 | 3592.0 |
| 2009-08-11 | E1 | Futures | 1.22093 | 1.22742 | 1.21868 | 1.22385 | 23503.0 |
| 2009-08-11 | E6 | Futures | 1.67903 | 1.68414 | 1.675 | 1.67951 | 165312.0 |
| 2009-08-11 | E7 | Futures | 1.6617 | 1.6667 | 1.6578 | 1.6623 | 1459.0 |
| 2009-08-11 | ED | Futures | 93.9755 | 93.9896 | 93.966 | 93.9849 | 95836.0 |
| 2009-08-11 | ER | Futures | 97.081 | 97.09 | 97.071 | 97.081 | 61235.0 |
| 2009-08-11 | EW | Futures | 629.0 | 631.9 | 617.1 | 620.3 | 26437.0 |
| 2009-08-11 | FCE | Futures | 2297.2 | 2312.9 | 2257.2 | 2265.4 | 113566.0 |
| 2009-08-11 | FDAX | Futures | 5963.1 | 5987.3 | 5784.8 | 5805.1 | 128023.0 |
| 2009-08-11 | FESX | Futures | 1611.0 | 1618.2 | 1575.8 | 1581.8 | 950387.0 |
| 2009-08-11 | FEU3 | Futures | 97.658 | 97.663 | 97.658 | 97.658 | 21.0 |
| 2009-08-11 | FGBL | Futures | 91.49 | 91.79 | 91.38 | 91.58 | 562009.0 |
| 2009-08-11 | FGBM | Futures | 97.23 | 97.56 | 97.2 | 97.46 | 289911.0 |
| 2009-08-11 | FGBS | Futures | 103.666 | 103.834 | 103.666 | 103.815 | 439300.0 |
| 2009-08-11 | FGBX | Futures | 84.53 | 85.16 | 84.53 | 84.73 | 1535.0 |
| 2009-08-11 | FTDX | Futures | 606.7 | 619.2 | 604.5 | 606.7 | 662.0 |
| 2009-08-11 | FTI | Futures | 238.81 | 239.14 | 233.7 | 234.48 | 254.0 |
| 2009-08-11 | FTUK | Futures | 3130.2 | 3134.5 | 3076.4 | 3087.7 | 96048.0 |
| 2009-08-11 | G | Futures | 75.47 | 75.61 | 75.07 | 75.27 | 89123.0 |
| 2009-08-11 | GF | Futures | 277.001 | 278.591 | 275.757 | 276.379 | 2529.0 |
| 2009-08-11 | GSCI | Futures | 962.02 | 970.18 | 948.78 | 951.83 | 3344.0 |
| 2009-08-11 | HE | Futures | 68.728 | 69.103 | 65.88 | 66.48 | 11484.0 |
| 2009-08-11 | HG | Futures | 3.8964 | 3.9442 | 3.8375 | 3.8424 | 25162.0 |
| 2009-08-11 | HO | Futures | 1.9637 | 1.9698 | 1.9069 | 1.9347 | 36733.0 |
| 2009-08-11 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-11 | J1 | Futures | 0.0129693 | 0.0131506 | 0.0129668 | 0.0131154 | 93376.0 |
| 2009-08-11 | J7 | Futures | 0.012813 | 0.012969 | 0.012804 | 0.012935 | 116.0 |
| 2009-08-11 | JB | Futures | 115.66 | 115.69 | 115.48 | 115.55 | 1825.0 |
| 2009-08-11 | KC | Futures | 368.48 | 372.82 | 364.0 | 371.47 | 13033.0 |
| 2009-08-11 | KE | Futures | 2515.69 | 2551.66 | 2478.52 | 2479.72 | 9717.0 |
| 2009-08-11 | L | Futures | 97.455 | 97.475 | 97.455 | 97.465 | 20896.0 |
| 2009-08-11 | LBS | Futures | 776.6 | 796.5 | 770.5 | 786.3 | 416.0 |
> showing 50 of 86 rows — these rows as CSV