PREVIEW / futures_daily / 2009-06-08
file: by_date/futures_daily/2009/2009-06-08.parquet size: 8 KB rows: 84
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-08 | ES | Futures | 895.43 | 902.1 | 882.09 | 894.72 | 1980655.0 |
| 2009-06-08 | NQ | Futures | 1676.0 | 1685.55 | 1647.91 | 1674.59 | 260179.0 |
| 2009-06-08 | YM | Futures | 7848.6 | 7912.3 | 7738.3 | 7856.7 | 128930.0 |
| 2009-06-08 | CL | Futures | 181.88 | 183.56 | 177.78 | 181.27 | 289278.0 |
| 2009-06-08 | GC | Futures | 1324.0 | 1330.6 | 1306.7 | 1318.7 | 95712.0 |
| 2009-06-08 | ZN | Futures | 89.426751 | 89.685316 | 89.032746 | 89.242061 | 614682.0 |
| 2009-06-08 | A6 | Futures | 0.63243 | 0.63665 | 0.62389 | 0.62732 | 63462.0 |
| 2009-06-08 | AD | Futures | 0.87852 | 0.88404 | 0.87183 | 0.8803 | 65070.0 |
| 2009-06-08 | B | Futures | 65.52 | 66.55 | 64.69 | 65.69 | 65370.0 |
| 2009-06-08 | B6 | Futures | 1.6596 | 1.6759 | 1.6442 | 1.6695 | 107740.0 |
| 2009-06-08 | BFX | Futures | 2341.1 | 2341.1 | 2309.5 | 2325.1 | 327.0 |
| 2009-06-08 | BR | Futures | 0.19473 | 0.19477 | 0.19473 | 0.19473 | 5.0 |
| 2009-06-08 | C | Futures | 1902.0 | 1930.0 | 1892.0 | 1906.0 | 3441.0 |
| 2009-06-08 | CB | Futures | 74.463 | 74.463 | 73.326 | 73.326 | 14.0 |
| 2009-06-08 | CC | Futures | 2410.0 | 2437.0 | 2392.0 | 2414.0 | 6491.0 |
| 2009-06-08 | CT | Futures | 51.23 | 51.68 | 50.2 | 51.51 | 8812.0 |
| 2009-06-08 | DC | Futures | 22.86 | 22.98 | 22.68 | 22.75 | 141.0 |
| 2009-06-08 | DX | Futures | 83.307 | 83.956 | 82.978 | 83.379 | 13106.0 |
| 2009-06-08 | E1 | Futures | 1.21972 | 1.2237 | 1.20686 | 1.21469 | 48634.0 |
| 2009-06-08 | E6 | Futures | 1.65294 | 1.65993 | 1.63646 | 1.64678 | 212742.0 |
| 2009-06-08 | E7 | Futures | 1.634 | 1.6406 | 1.6176 | 1.6277 | 2332.0 |
| 2009-06-08 | ED | Futures | 93.629 | 93.6384 | 93.6101 | 93.6243 | 131161.0 |
| 2009-06-08 | ER | Futures | 96.65 | 96.674 | 96.645 | 96.655 | 70845.0 |
| 2009-06-08 | EW | Futures | 573.7 | 576.8 | 564.2 | 571.8 | 25758.0 |
| 2009-06-08 | FCE | Futures | 2161.6 | 2167.8 | 2128.4 | 2140.4 | 103609.0 |
| 2009-06-08 | FDAX | Futures | 5503.3 | 5512.0 | 5409.1 | 5454.8 | 129741.0 |
| 2009-06-08 | FESX | Futures | 1492.3 | 1499.5 | 1471.3 | 1480.3 | 930298.0 |
| 2009-06-08 | FEU3 | Futures | 97.244 | 97.244 | 97.234 | 97.234 | 1759.0 |
| 2009-06-08 | FGBL | Futures | 89.31 | 89.96 | 89.29 | 89.84 | 507334.0 |
| 2009-06-08 | FGBM | Futures | 95.88 | 96.35 | 95.78 | 96.25 | 373637.0 |
| 2009-06-08 | FGBS | Futures | 103.122 | 103.338 | 103.117 | 103.237 | 554622.0 |
| 2009-06-08 | FGBX | Futures | 79.36 | 81.48 | 79.28 | 81.34 | 2731.0 |
| 2009-06-08 | FTDX | Futures | 582.8 | 584.6 | 570.2 | 573.8 | 475.0 |
| 2009-06-08 | FTI | Futures | 218.86 | 219.4 | 215.28 | 216.18 | 28385.0 |
| 2009-06-08 | FTUK | Futures | 2941.1 | 2962.1 | 2906.8 | 2931.1 | 106253.0 |
| 2009-06-08 | G | Futures | 74.19 | 74.73 | 74.03 | 74.56 | 82016.0 |
| 2009-06-08 | GF | Futures | 265.708 | 266.741 | 260.264 | 264.192 | 1697.0 |
| 2009-06-08 | GSCI | Futures | 956.99 | 968.94 | 956.88 | 962.11 | 133.0 |
| 2009-06-08 | HE | Futures | 87.911 | 88.605 | 86.668 | 86.997 | 6517.0 |
| 2009-06-08 | HG | Futures | 3.1937 | 3.2479 | 3.1381 | 3.1698 | 21538.0 |
| 2009-06-08 | HO | Futures | 1.8562 | 1.8814 | 1.8367 | 1.8641 | 8850.0 |
| 2009-06-08 | HRC | Futures | 2310.2 | 2310.2 | 2310.2 | 2310.2 | 0.0 |
| 2009-06-08 | J1 | Futures | 0.0127866 | 0.0128333 | 0.0127488 | 0.0128106 | 73547.0 |
| 2009-06-08 | J7 | Futures | 0.012583 | 0.012653 | 0.012582 | 0.012637 | 23.0 |
| 2009-06-08 | JB | Futures | 114.63 | 114.65 | 114.15 | 114.33 | 1792.0 |
| 2009-06-08 | KC | Futures | 370.19 | 370.88 | 356.05 | 360.35 | 18465.0 |
| 2009-06-08 | KE | Futures | 3291.14 | 3300.89 | 3163.15 | 3182.66 | 10917.0 |
| 2009-06-08 | L | Futures | 96.876 | 96.974 | 96.856 | 96.905 | 83684.0 |
| 2009-06-08 | LBS | Futures | 967.4 | 967.4 | 929.6 | 929.6 | 264.0 |
| 2009-06-08 | LE | Futures | 142.659 | 143.276 | 141.998 | 142.087 | 4322.0 |
> showing 50 of 84 rows — these rows as CSV