PREVIEW / futures_daily / 2010-04-09
file: by_date/futures_daily/2010/2010-04-09.parquet size: 9 KB rows: 91
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-04-09 | ES | Futures | 1152.48 | 1161.73 | 1151.99 | 1161.24 | 1450628.0 |
| 2010-04-09 | NQ | Futures | 2245.61 | 2260.64 | 2240.51 | 2259.79 | 190400.0 |
| 2010-04-09 | YM | Futures | 10002.5 | 10071.5 | 9997.0 | 10068.7 | 92829.0 |
| 2010-04-09 | CL | Futures | 200.19 | 202.08 | 196.82 | 198.69 | 442943.0 |
| 2010-04-09 | GC | Futures | 1580.3 | 1599.5 | 1578.4 | 1594.2 | 134636.0 |
| 2010-04-09 | ZN | Futures | 94.517188 | 94.682985 | 94.338637 | 94.606464 | 764399.0 |
| 2010-04-09 | A6 | Futures | 0.75661 | 0.76145 | 0.75489 | 0.75932 | 68547.0 |
| 2010-04-09 | AD | Futures | 0.98508 | 0.98794 | 0.97906 | 0.98212 | 72143.0 |
| 2010-04-09 | B | Futures | 76.64 | 77.39 | 75.7 | 76.46 | 159426.0 |
| 2010-04-09 | B6 | Futures | 1.5857 | 1.5976 | 1.5846 | 1.595 | 120119.0 |
| 2010-04-09 | BFX | Futures | 3026.7 | 3044.0 | 3021.8 | 3044.0 | 156.0 |
| 2010-04-09 | BR | Futures | 0.2282 | 0.2282 | 0.2282 | 0.2282 | 50.0 |
| 2010-04-09 | BZ | Futures | 80.12 | 80.12 | 80.12 | 80.12 | 802.0 |
| 2010-04-09 | C | Futures | 2159.0 | 2160.0 | 2137.0 | 2142.0 | 3930.0 |
| 2010-04-09 | CB | Futures | 76.985 | 76.985 | 76.985 | 76.985 | 3.0 |
| 2010-04-09 | CC | Futures | 2436.0 | 2451.0 | 2403.0 | 2417.0 | 8821.0 |
| 2010-04-09 | CT | Futures | 63.96 | 64.59 | 63.43 | 63.49 | 18409.0 |
| 2010-04-09 | DC | Futures | 23.07 | 23.58 | 22.54 | 22.61 | 400.0 |
| 2010-04-09 | DX | Futures | 82.665 | 82.837 | 82.092 | 82.326 | 27913.0 |
| 2010-04-09 | E1 | Futures | 1.22722 | 1.23617 | 1.22366 | 1.23248 | 61387.0 |
| 2010-04-09 | E6 | Futures | 1.58012 | 1.59774 | 1.57834 | 1.59183 | 382153.0 |
| 2010-04-09 | E7 | Futures | 1.5673 | 1.5848 | 1.5655 | 1.5788 | 5823.0 |
| 2010-04-09 | EBM | Futures | 209.73 | 210.55 | 208.09 | 208.5 | 9327.0 |
| 2010-04-09 | ED | Futures | 94.4039 | 94.4039 | 94.3897 | 94.3992 | 120768.0 |
| 2010-04-09 | ER | Futures | 97.36 | 97.365 | 97.35 | 97.355 | 100037.0 |
| 2010-04-09 | EW | Futures | 784.6 | 793.4 | 781.6 | 793.0 | 23715.0 |
| 2010-04-09 | FBTP | Futures | 64.95 | 64.95 | 64.76 | 64.83 | 4461.0 |
| 2010-04-09 | FCE | Futures | 2558.2 | 2593.1 | 2558.2 | 2590.2 | 110662.0 |
| 2010-04-09 | FDAX | Futures | 6757.4 | 6813.4 | 6757.4 | 6807.4 | 115545.0 |
| 2010-04-09 | FESX | Futures | 1766.8 | 1792.5 | 1766.8 | 1790.0 | 970870.0 |
| 2010-04-09 | FEU3 | Futures | 97.919 | 97.919 | 97.914 | 97.914 | 58.0 |
| 2010-04-09 | FGBL | Futures | 96.24 | 96.27 | 95.76 | 95.87 | 936649.0 |
| 2010-04-09 | FGBM | Futures | 101.94 | 101.99 | 101.65 | 101.69 | 585787.0 |
| 2010-04-09 | FGBS | Futures | 106.493 | 106.517 | 106.38 | 106.39 | 664639.0 |
| 2010-04-09 | FGBX | Futures | 91.66 | 91.73 | 90.79 | 90.88 | 3569.0 |
| 2010-04-09 | FTDX | Futures | 738.5 | 740.2 | 736.7 | 737.6 | 118.0 |
| 2010-04-09 | FTI | Futures | 285.03 | 288.03 | 285.03 | 287.58 | 25559.0 |
| 2010-04-09 | FTUK | Futures | 3864.1 | 3879.7 | 3858.7 | 3873.2 | 80009.0 |
| 2010-04-09 | G | Futures | 76.07 | 76.11 | 75.73 | 75.81 | 87558.0 |
| 2010-04-09 | GF | Futures | 294.929 | 299.952 | 294.929 | 298.843 | 975.0 |
| 2010-04-09 | GSCI | Futures | 1003.11 | 1003.11 | 989.31 | 991.89 | 1847.0 |
| 2010-04-09 | HE | Futures | 101.759 | 102.461 | 101.179 | 102.369 | 976.0 |
| 2010-04-09 | HG | Futures | 4.898 | 4.9506 | 4.8816 | 4.9048 | 27969.0 |
| 2010-04-09 | HO | Futures | 2.0455 | 2.0732 | 2.0272 | 2.0448 | 26323.0 |
| 2010-04-09 | HRC | Futures | 3221.8 | 3221.8 | 3221.8 | 3221.8 | 0.0 |
| 2010-04-09 | J1 | Futures | 0.0134657 | 0.0135097 | 0.0134117 | 0.0134871 | 91277.0 |
| 2010-04-09 | J7 | Futures | 0.013356 | 0.013401 | 0.013307 | 0.013379 | 139.0 |
| 2010-04-09 | JB | Futures | 117.6 | 117.73 | 117.49 | 117.62 | 1524.0 |
| 2010-04-09 | KC | Futures | 347.23 | 348.0 | 340.3 | 340.81 | 19905.0 |
| 2010-04-09 | KE | Futures | 2149.17 | 2193.48 | 2128.12 | 2142.52 | 9475.0 |
> showing 50 of 91 rows — these rows as CSV