PREVIEW / futures_daily / 2009-09-10
file: by_date/futures_daily/2009/2009-09-10.parquet size: 9 KB rows: 88
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-09-10 | ES | Futures | 990.62 | 1001.66 | 985.82 | 999.5 | 1445592.0 |
| 2009-09-10 | NQ | Futures | 1876.75 | 1899.27 | 1871.4 | 1897.58 | 186098.0 |
| 2009-09-10 | YM | Futures | 8605.7 | 8690.1 | 8573.0 | 8664.7 | 74846.0 |
| 2009-09-10 | CL | Futures | 178.74 | 180.74 | 176.8 | 179.49 | 345551.0 |
| 2009-09-10 | GC | Futures | 1373.5 | 1383.1 | 1359.2 | 1378.0 | 129181.0 |
| 2009-09-10 | ZN | Futures | 93.268014 | 94.052616 | 93.093657 | 93.977892 | 817971.0 |
| 2009-09-10 | A6 | Futures | 0.69176 | 0.69362 | 0.68538 | 0.69225 | 75123.0 |
| 2009-09-10 | AD | Futures | 0.91363 | 0.9159 | 0.90634 | 0.91413 | 60780.0 |
| 2009-09-10 | B | Futures | 66.86 | 67.43 | 65.96 | 66.7 | 98657.0 |
| 2009-09-10 | B6 | Futures | 1.7218 | 1.7363 | 1.7148 | 1.7337 | 72212.0 |
| 2009-09-10 | BFX | Futures | 2779.4 | 2779.4 | 2767.4 | 2776.1 | 55.0 |
| 2009-09-10 | BR | Futures | 0.21641 | 0.21665 | 0.21585 | 0.21585 | 146.0 |
| 2009-09-10 | BZ | Futures | 69.66 | 69.66 | 69.42 | 69.42 | 2.0 |
| 2009-09-10 | C | Futures | 2005.0 | 2032.0 | 1988.0 | 2020.0 | 17616.0 |
| 2009-09-10 | CB | Futures | 68.045 | 68.045 | 68.045 | 68.045 | 40.0 |
| 2009-09-10 | CC | Futures | 2660.0 | 2707.0 | 2637.0 | 2691.0 | 6058.0 |
| 2009-09-10 | CT | Futures | 52.0 | 52.18 | 51.36 | 52.18 | 73.0 |
| 2009-09-10 | DC | Futures | 22.59 | 23.06 | 22.59 | 22.92 | 157.0 |
| 2009-09-10 | DX | Futures | 78.915 | 79.114 | 78.573 | 78.7 | 15492.0 |
| 2009-09-10 | E1 | Futures | 1.27031 | 1.27625 | 1.26291 | 1.27282 | 30089.0 |
| 2009-09-10 | E6 | Futures | 1.7264 | 1.73185 | 1.7187 | 1.7283 | 191080.0 |
| 2009-09-10 | E7 | Futures | 1.7087 | 1.7163 | 1.6992 | 1.7117 | 1485.0 |
| 2009-09-10 | ED | Futures | 94.1387 | 94.1481 | 94.1198 | 94.1245 | 172513.0 |
| 2009-09-10 | ER | Futures | 97.184 | 97.208 | 97.179 | 97.198 | 114054.0 |
| 2009-09-10 | EW | Futures | 647.7 | 656.1 | 643.4 | 654.2 | 47899.0 |
| 2009-09-10 | FCE | Futures | 2434.7 | 2444.2 | 2408.5 | 2427.1 | 113171.0 |
| 2009-09-10 | FDAX | Futures | 6135.9 | 6176.0 | 6084.9 | 6135.4 | 160461.0 |
| 2009-09-10 | FESX | Futures | 1682.0 | 1689.2 | 1659.9 | 1674.2 | 89361.0 |
| 2009-09-10 | FEU3 | Futures | 97.761 | 97.771 | 97.756 | 97.771 | 3454.0 |
| 2009-09-10 | FGBL | Futures | 92.8 | 93.45 | 92.6 | 93.17 | 859938.0 |
| 2009-09-10 | FGBM | Futures | 98.75 | 99.15 | 98.69 | 98.98 | 480093.0 |
| 2009-09-10 | FGBS | Futures | 104.648 | 104.803 | 104.643 | 104.721 | 554851.0 |
| 2009-09-10 | FGBX | Futures | 84.84 | 85.73 | 84.51 | 85.54 | 1490.0 |
| 2009-09-10 | FTDX | Futures | 655.4 | 662.5 | 652.7 | 659.8 | 150.0 |
| 2009-09-10 | FTI | Futures | 251.11 | 253.09 | 249.3 | 251.94 | 151.0 |
| 2009-09-10 | FTUK | Futures | 3318.7 | 3322.7 | 3266.3 | 3288.5 | 36850.0 |
| 2009-09-10 | G | Futures | 75.79 | 76.41 | 75.66 | 76.27 | 127280.0 |
| 2009-09-10 | GF | Futures | 275.896 | 276.446 | 273.693 | 274.725 | 2330.0 |
| 2009-09-10 | GSCI | Futures | 926.56 | 931.56 | 917.15 | 931.56 | 3082.0 |
| 2009-09-10 | HE | Futures | 77.947 | 81.02 | 77.534 | 78.584 | 21927.0 |
| 2009-09-10 | HG | Futures | 4.0447 | 4.1199 | 3.9472 | 4.0085 | 22211.0 |
| 2009-09-10 | HO | Futures | 1.8214 | 1.8228 | 1.7861 | 1.8061 | 10198.0 |
| 2009-09-10 | HRC | Futures | 2738.7 | 2738.7 | 2738.7 | 2738.7 | 0.0 |
| 2009-09-10 | J1 | Futures | 0.0136592 | 0.0137421 | 0.0136178 | 0.0136982 | 78939.0 |
| 2009-09-10 | J7 | Futures | 0.013471 | 0.013559 | 0.013448 | 0.013519 | 25.0 |
| 2009-09-10 | JB | Futures | 117.29 | 117.35 | 117.05 | 117.21 | 1767.0 |
| 2009-09-10 | KC | Futures | 330.89 | 333.13 | 325.21 | 329.04 | 5934.0 |
| 2009-09-10 | KE | Futures | 2196.24 | 2219.5 | 2175.3 | 2203.22 | 11536.0 |
| 2009-09-10 | L | Futures | 97.71 | 97.77 | 97.681 | 97.74 | 106697.0 |
| 2009-09-10 | LBS | Futures | 712.4 | 722.2 | 706.7 | 721.8 | 327.0 |
> showing 50 of 88 rows — these rows as CSV