PREVIEW / futures_daily / 2009-11-17
file: by_date/futures_daily/2009/2009-11-17.parquet size: 9 KB rows: 89
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-11-17 | ES | Futures | 1067.02 | 1069.67 | 1060.99 | 1068.22 | 1517083.0 |
| 2009-11-17 | NQ | Futures | 2035.02 | 2045.18 | 2026.55 | 2041.79 | 214345.0 |
| 2009-11-17 | YM | Futures | 9409.1 | 9450.9 | 9377.4 | 9440.0 | 107448.0 |
| 2009-11-17 | CL | Futures | 193.42 | 195.49 | 191.65 | 194.01 | 143493.0 |
| 2009-11-17 | GC | Futures | 1576.1 | 1578.7 | 1559.1 | 1575.1 | 143710.0 |
| 2009-11-17 | ZN | Futures | 95.335378 | 95.534642 | 95.098752 | 95.447464 | 773704.0 |
| 2009-11-17 | A6 | Futures | 0.75447 | 0.75609 | 0.74453 | 0.74825 | 93599.0 |
| 2009-11-17 | AD | Futures | 0.94124 | 0.94233 | 0.92842 | 0.937 | 79529.0 |
| 2009-11-17 | B | Futures | 73.2 | 73.91 | 72.48 | 73.36 | 121112.0 |
| 2009-11-17 | B6 | Futures | 1.7501 | 1.7553 | 1.7429 | 1.7473 | 106211.0 |
| 2009-11-17 | BFX | Futures | 2869.6 | 2870.1 | 2852.4 | 2854.5 | 2910.0 |
| 2009-11-17 | BR | Futures | 0.23056 | 0.23056 | 0.23056 | 0.23056 | 23.0 |
| 2009-11-17 | C | Futures | 2091.0 | 2099.0 | 2075.0 | 2092.0 | 2349.0 |
| 2009-11-17 | CB | Futures | 80.686 | 80.686 | 79.61 | 80.686 | 8.0 |
| 2009-11-17 | CC | Futures | 2711.0 | 2717.0 | 2672.0 | 2695.0 | 4170.0 |
| 2009-11-17 | CT | Futures | 58.87 | 59.18 | 58.26 | 58.59 | 7944.0 |
| 2009-11-17 | DC | Futures | 24.81 | 24.93 | 24.61 | 24.81 | 91.0 |
| 2009-11-17 | DX | Futures | 76.505 | 77.307 | 76.5 | 77.046 | 15033.0 |
| 2009-11-17 | E1 | Futures | 1.3102 | 1.31298 | 1.29395 | 1.29831 | 65112.0 |
| 2009-11-17 | E6 | Futures | 1.77357 | 1.77748 | 1.75472 | 1.76029 | 280662.0 |
| 2009-11-17 | E7 | Futures | 1.757 | 1.7603 | 1.738 | 1.7434 | 3903.0 |
| 2009-11-17 | ED | Futures | 94.2687 | 94.271 | 94.2663 | 94.2687 | 107374.0 |
| 2009-11-17 | ER | Futures | 97.174 | 97.179 | 97.164 | 97.169 | 72268.0 |
| 2009-11-17 | EW | Futures | 686.3 | 688.0 | 682.4 | 685.7 | 28752.0 |
| 2009-11-17 | FBTP | Futures | 62.88 | 63.11 | 62.83 | 63.04 | 3163.0 |
| 2009-11-17 | FCE | Futures | 2548.0 | 2558.3 | 2533.4 | 2537.4 | 116277.0 |
| 2009-11-17 | FDAX | Futures | 6296.3 | 6325.6 | 6270.1 | 6291.4 | 119501.0 |
| 2009-11-17 | FESX | Futures | 1740.5 | 1744.7 | 1729.8 | 1733.4 | 843277.0 |
| 2009-11-17 | FEU3 | Futures | 97.746 | 97.746 | 97.741 | 97.741 | 8.0 |
| 2009-11-17 | FGBL | Futures | 94.05 | 94.28 | 93.88 | 94.2 | 720793.0 |
| 2009-11-17 | FGBM | Futures | 99.58 | 99.68 | 99.46 | 99.64 | 400470.0 |
| 2009-11-17 | FGBS | Futures | 105.002 | 105.05 | 104.968 | 105.011 | 454116.0 |
| 2009-11-17 | FGBX | Futures | 87.25 | 87.9 | 87.1 | 87.83 | 2339.0 |
| 2009-11-17 | FTDX | Futures | 696.3 | 697.7 | 691.9 | 693.2 | 438.0 |
| 2009-11-17 | FTI | Futures | 261.99 | 263.46 | 261.1 | 261.75 | 32960.0 |
| 2009-11-17 | FTUK | Futures | 3548.9 | 3556.5 | 3531.9 | 3541.2 | 87148.0 |
| 2009-11-17 | G | Futures | 76.54 | 76.89 | 76.41 | 76.85 | 100784.0 |
| 2009-11-17 | GF | Futures | 250.626 | 253.203 | 250.22 | 251.644 | 1097.0 |
| 2009-11-17 | GSCI | Futures | 999.56 | 1008.07 | 994.73 | 1007.3 | 370.0 |
| 2009-11-17 | HE | Futures | 83.766 | 85.974 | 82.696 | 85.606 | 13960.0 |
| 2009-11-17 | HG | Futures | 4.3213 | 4.3534 | 4.2844 | 4.3318 | 23810.0 |
| 2009-11-17 | HO | Futures | 1.9684 | 2.0007 | 1.9675 | 1.9938 | 5011.0 |
| 2009-11-17 | HRC | Futures | 2637.0 | 2637.0 | 2637.0 | 2637.0 | 0.0 |
| 2009-11-17 | J1 | Futures | 0.0140912 | 0.0141527 | 0.0140246 | 0.0140648 | 78951.0 |
| 2009-11-17 | J7 | Futures | 0.013925 | 0.013966 | 0.013843 | 0.013881 | 28.0 |
| 2009-11-17 | JB | Futures | 117.21 | 117.52 | 117.18 | 117.45 | 3091.0 |
| 2009-11-17 | KC | Futures | 360.32 | 360.32 | 354.25 | 358.34 | 7654.0 |
| 2009-11-17 | KE | Futures | 2601.05 | 2670.85 | 2583.6 | 2670.85 | 10543.0 |
| 2009-11-17 | KRW | Futures | 0.0008507 | 0.0008507 | 0.0008507 | 0.0008507 | 2.0 |
| 2009-11-17 | L | Futures | 97.73 | 97.74 | 97.72 | 97.74 | 15511.0 |
> showing 50 of 89 rows — these rows as CSV