PREVIEW / futures_daily / 2009-06-02
file: by_date/futures_daily/2009/2009-06-02.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-02 | ES | Futures | 894.95 | 904.49 | 890.67 | 898.29 | 1946965.0 |
| 2009-06-02 | NQ | Futures | 1651.56 | 1679.09 | 1645.38 | 1661.11 | 294033.0 |
| 2009-06-02 | YM | Futures | 7789.4 | 7876.4 | 7757.1 | 7816.3 | 133096.0 |
| 2009-06-02 | CL | Futures | 181.14 | 183.82 | 179.7 | 182.49 | 266861.0 |
| 2009-06-02 | GC | Futures | 1352.5 | 1368.3 | 1343.6 | 1362.9 | 88676.0 |
| 2009-06-02 | ZN | Futures | 91.077407 | 91.356562 | 90.749703 | 91.06527 | 81421.0 |
| 2009-06-02 | A6 | Futures | 0.64535 | 0.65587 | 0.64136 | 0.6546 | 65939.0 |
| 2009-06-02 | AD | Futures | 0.90176 | 0.91259 | 0.89733 | 0.91092 | 79389.0 |
| 2009-06-02 | B | Futures | 64.98 | 66.22 | 64.74 | 65.86 | 67862.0 |
| 2009-06-02 | B6 | Futures | 1.7105 | 1.727 | 1.6985 | 1.7245 | 114237.0 |
| 2009-06-02 | BFX | Futures | 2377.5 | 2392.4 | 2374.1 | 2377.5 | 168.0 |
| 2009-06-02 | BR | Futures | 0.19695 | 0.19853 | 0.19675 | 0.19853 | 26.0 |
| 2009-06-02 | BZ | Futures | 71.81 | 71.87 | 71.81 | 71.87 | 1.0 |
| 2009-06-02 | C | Futures | 1820.0 | 1843.0 | 1788.0 | 1827.0 | 5269.0 |
| 2009-06-02 | CC | Futures | 2318.0 | 2360.0 | 2299.0 | 2357.0 | 7502.0 |
| 2009-06-02 | CT | Futures | 53.47 | 54.48 | 52.97 | 54.26 | 11216.0 |
| 2009-06-02 | DC | Futures | 24.72 | 24.9 | 24.33 | 24.42 | 113.0 |
| 2009-06-02 | DX | Futures | 81.485 | 81.866 | 80.707 | 80.805 | 6709.0 |
| 2009-06-02 | E1 | Futures | 1.23882 | 1.25208 | 1.23418 | 1.25009 | 38650.0 |
| 2009-06-02 | E6 | Futures | 1.67772 | 1.69906 | 1.67167 | 1.6974 | 238976.0 |
| 2009-06-02 | E7 | Futures | 1.6585 | 1.6792 | 1.6525 | 1.6777 | 2944.0 |
| 2009-06-02 | ED | Futures | 93.6313 | 93.662 | 93.629 | 93.6549 | 127331.0 |
| 2009-06-02 | ER | Futures | 96.753 | 96.787 | 96.748 | 96.772 | 133577.0 |
| 2009-06-02 | EW | Futures | 572.7 | 581.5 | 570.1 | 577.5 | 25495.0 |
| 2009-06-02 | FCE | Futures | 2177.2 | 2211.4 | 2168.1 | 2196.1 | 122762.0 |
| 2009-06-02 | FDAX | Futures | 5565.4 | 5641.1 | 5555.6 | 5613.3 | 140386.0 |
| 2009-06-02 | FESX | Futures | 1508.5 | 1530.7 | 1504.9 | 1522.9 | 1048756.0 |
| 2009-06-02 | FEU3 | Futures | 97.337 | 97.352 | 97.333 | 97.352 | 829.0 |
| 2009-06-02 | FGBL | Futures | 89.73 | 90.02 | 89.63 | 89.82 | 831470.0 |
| 2009-06-02 | FGBM | Futures | 96.72 | 96.95 | 96.64 | 96.88 | 472660.0 |
| 2009-06-02 | FGBS | Futures | 103.81 | 103.901 | 103.762 | 103.877 | 685555.0 |
| 2009-06-02 | FGBX | Futures | 78.6 | 78.98 | 78.39 | 78.7 | 12836.0 |
| 2009-06-02 | FTDX | Futures | 581.9 | 591.7 | 581.0 | 588.2 | 486.0 |
| 2009-06-02 | FTI | Futures | 219.56 | 222.53 | 219.15 | 221.83 | 28848.0 |
| 2009-06-02 | FTUK | Futures | 2965.0 | 2983.0 | 2940.7 | 2976.0 | 117607.0 |
| 2009-06-02 | G | Futures | 74.75 | 74.84 | 74.37 | 74.39 | 83563.0 |
| 2009-06-02 | GF | Futures | 275.148 | 276.044 | 267.844 | 267.844 | 2610.0 |
| 2009-06-02 | GSCI | Futures | 971.71 | 981.74 | 968.51 | 980.24 | 401.0 |
| 2009-06-02 | HE | Futures | 93.723 | 93.942 | 90.872 | 90.872 | 4310.0 |
| 2009-06-02 | HG | Futures | 3.2465 | 3.3105 | 3.2078 | 3.2324 | 17297.0 |
| 2009-06-02 | HO | Futures | 1.8489 | 1.8973 | 1.8416 | 1.8844 | 10769.0 |
| 2009-06-02 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-06-02 | J1 | Futures | 0.0130551 | 0.013224 | 0.01304 | 0.0131773 | 84492.0 |
| 2009-06-02 | J7 | Futures | 0.012883 | 0.013037 | 0.012867 | 0.012998 | 56.0 |
| 2009-06-02 | JB | Futures | 114.25 | 114.33 | 114.0 | 114.16 | 1189.0 |
| 2009-06-02 | KC | Futures | 392.08 | 395.95 | 387.92 | 393.46 | 9207.0 |
| 2009-06-02 | KE | Futures | 3537.37 | 3537.37 | 3455.7 | 3505.67 | 11194.0 |
| 2009-06-02 | L | Futures | 97.101 | 97.16 | 97.101 | 97.141 | 59812.0 |
| 2009-06-02 | LBS | Futures | 890.3 | 949.2 | 890.3 | 949.2 | 663.0 |
| 2009-06-02 | LE | Futures | 143.717 | 144.333 | 141.646 | 142.131 | 9685.0 |
> showing 50 of 85 rows — these rows as CSV