PREVIEW / futures_daily / 2009-11-10
file: by_date/futures_daily/2009/2009-11-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-11-10 | ES | Futures | 1052.79 | 1055.68 | 1046.52 | 1053.27 | 1810118.0 |
| 2009-11-10 | NQ | Futures | 1993.53 | 2005.39 | 1985.63 | 2000.87 | 255967.0 |
| 2009-11-10 | YM | Futures | 9253.0 | 9284.7 | 9217.6 | 9275.7 | 123406.0 |
| 2009-11-10 | CL | Futures | 194.17 | 197.28 | 190.86 | 193.7 | 371088.0 |
| 2009-11-10 | GC | Futures | 1525.8 | 1534.1 | 1516.8 | 1524.1 | 146659.0 |
| 2009-11-10 | ZN | Futures | 94.463598 | 94.774948 | 94.37642 | 94.513414 | 776738.0 |
| 2009-11-10 | A6 | Futures | 0.74962 | 0.751 | 0.74558 | 0.74954 | 70614.0 |
| 2009-11-10 | AD | Futures | 0.93385 | 0.94055 | 0.92941 | 0.93976 | 67707.0 |
| 2009-11-10 | B | Futures | 72.78 | 74.05 | 71.67 | 72.72 | 109243.0 |
| 2009-11-10 | B6 | Futures | 1.7436 | 1.7464 | 1.7269 | 1.7412 | 135820.0 |
| 2009-11-10 | BR | Futures | 0.23223 | 0.23223 | 0.23223 | 0.23223 | 4.0 |
| 2009-11-10 | C | Futures | 2141.0 | 2148.0 | 2073.0 | 2106.0 | 7790.0 |
| 2009-11-10 | CB | Futures | 80.861 | 81.224 | 80.861 | 81.224 | 5.0 |
| 2009-11-10 | CC | Futures | 2760.0 | 2773.0 | 2665.0 | 2698.0 | 14808.0 |
| 2009-11-10 | CT | Futures | 58.35 | 59.75 | 58.04 | 59.59 | 15000.0 |
| 2009-11-10 | DC | Futures | 24.73 | 25.31 | 24.61 | 25.31 | 277.0 |
| 2009-11-10 | DX | Futures | 76.735 | 76.955 | 76.607 | 76.684 | 12915.0 |
| 2009-11-10 | E1 | Futures | 1.31099 | 1.31311 | 1.30677 | 1.31073 | 52011.0 |
| 2009-11-10 | E6 | Futures | 1.77724 | 1.77997 | 1.77013 | 1.77523 | 220304.0 |
| 2009-11-10 | E7 | Futures | 1.7604 | 1.7628 | 1.7534 | 1.7582 | 2377.0 |
| 2009-11-10 | ED | Futures | 94.2569 | 94.2616 | 94.2521 | 94.2521 | 86559.0 |
| 2009-11-10 | ER | Futures | 97.174 | 97.179 | 97.169 | 97.169 | 53667.0 |
| 2009-11-10 | EW | Futures | 673.6 | 677.8 | 669.4 | 675.3 | 32148.0 |
| 2009-11-10 | FBTP | Futures | 62.64 | 62.97 | 62.61 | 62.97 | 2386.0 |
| 2009-11-10 | FCE | Futures | 2494.9 | 2503.5 | 2484.0 | 2491.3 | 89777.0 |
| 2009-11-10 | FDAX | Futures | 6130.9 | 6151.5 | 6089.5 | 6113.5 | 136559.0 |
| 2009-11-10 | FESX | Futures | 1705.9 | 1709.5 | 1694.6 | 1699.9 | 957692.0 |
| 2009-11-10 | FEU3 | Futures | 97.746 | 97.751 | 97.741 | 97.741 | 189.0 |
| 2009-11-10 | FGBL | Futures | 93.47 | 93.87 | 93.38 | 93.8 | 700803.0 |
| 2009-11-10 | FGBM | Futures | 99.22 | 99.4 | 99.16 | 99.36 | 346124.0 |
| 2009-11-10 | FGBS | Futures | 104.861 | 104.905 | 104.832 | 104.871 | 416875.0 |
| 2009-11-10 | FGBX | Futures | 86.28 | 86.93 | 86.16 | 86.89 | 2626.0 |
| 2009-11-10 | FTDX | Futures | 681.2 | 684.8 | 668.7 | 670.5 | 601.0 |
| 2009-11-10 | FTI | Futures | 256.85 | 257.05 | 254.81 | 255.42 | 290.0 |
| 2009-11-10 | FTUK | Futures | 3465.3 | 3479.9 | 3449.7 | 3462.6 | 86748.0 |
| 2009-11-10 | G | Futures | 75.68 | 76.12 | 75.62 | 76.09 | 91595.0 |
| 2009-11-10 | GF | Futures | 259.306 | 259.577 | 256.458 | 256.933 | 2222.0 |
| 2009-11-10 | GSCI | Futures | 997.63 | 1001.3 | 980.81 | 989.41 | 4049.0 |
| 2009-11-10 | HE | Futures | 84.833 | 85.481 | 84.185 | 84.795 | 18590.0 |
| 2009-11-10 | HG | Futures | 4.1415 | 4.1757 | 4.0928 | 4.1269 | 29378.0 |
| 2009-11-10 | HO | Futures | 1.9906 | 2.0251 | 1.966 | 1.9881 | 45653.0 |
| 2009-11-10 | HRC | Futures | 2586.3 | 2586.3 | 2586.3 | 2586.3 | 0.0 |
| 2009-11-10 | J1 | Futures | 0.0139618 | 0.0140108 | 0.0139229 | 0.013992 | 77757.0 |
| 2009-11-10 | J7 | Futures | 0.013798 | 0.013822 | 0.01375 | 0.013809 | 23.0 |
| 2009-11-10 | JB | Futures | 115.89 | 116.11 | 115.85 | 116.09 | 1385.0 |
| 2009-11-10 | KC | Futures | 368.11 | 369.82 | 351.48 | 353.85 | 20390.0 |
| 2009-11-10 | KE | Futures | 2417.26 | 2464.95 | 2375.38 | 2445.17 | 11209.0 |
| 2009-11-10 | KRW | Futures | 0.0008484 | 0.0008484 | 0.0008484 | 0.0008484 | 10.0 |
| 2009-11-10 | L | Futures | 97.73 | 97.76 | 97.73 | 97.75 | 31203.0 |
| 2009-11-10 | LBS | Futures | 754.0 | 755.0 | 747.4 | 749.1 | 149.0 |
> showing 50 of 88 rows — these rows as CSV