PREVIEW / futures_daily / 2009-01-13
file: by_date/futures_daily/2009/2009-01-13.parquet size: 8 KB rows: 86
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-01-13 | ES | Futures | 820.11 | 825.31 | 809.26 | 820.11 | 2284001.0 |
| 2009-01-13 | NQ | Futures | 1348.57 | 1362.27 | 1324.81 | 1346.06 | 285219.0 |
| 2009-01-13 | YM | Futures | 7518.5 | 7556.8 | 7414.3 | 7486.4 | 179861.0 |
| 2009-01-13 | CL | Futures | 148.84 | 156.82 | 143.32 | 149.99 | 340615.0 |
| 2009-01-13 | GC | Futures | 1145.4 | 1159.2 | 1134.9 | 1144.2 | 98866.0 |
| 2009-01-13 | ZN | Futures | 96.567012 | 96.662635 | 96.196474 | 96.555059 | 366535.0 |
| 2009-01-13 | A6 | Futures | 0.53701 | 0.5374 | 0.51861 | 0.52257 | 31549.0 |
| 2009-01-13 | AD | Futures | 0.80684 | 0.80763 | 0.79535 | 0.80045 | 29484.0 |
| 2009-01-13 | B | Futures | 47.06 | 49.72 | 45.91 | 48.95 | 146861.0 |
| 2009-01-13 | B6 | Futures | 1.5367 | 1.5386 | 1.4993 | 1.5042 | 66055.0 |
| 2009-01-13 | BFX | Futures | 2157.2 | 2173.5 | 2150.7 | 2156.3 | 13951.0 |
| 2009-01-13 | BZ | Futures | 47.9 | 49.53 | 47.9 | 49.15 | 232.0 |
| 2009-01-13 | C | Futures | 1759.0 | 1803.0 | 1738.0 | 1789.0 | 9680.0 |
| 2009-01-13 | CB | Futures | 77.333 | 77.829 | 77.003 | 77.003 | 8.0 |
| 2009-01-13 | CC | Futures | 2188.0 | 2212.0 | 2140.0 | 2192.0 | 7563.0 |
| 2009-01-13 | CT | Futures | 45.51 | 46.09 | 44.92 | 45.0 | 13163.0 |
| 2009-01-13 | DC | Futures | 27.56 | 27.96 | 27.02 | 27.13 | 166.0 |
| 2009-01-13 | DX | Futures | 87.304 | 88.352 | 87.19 | 88.134 | 4650.0 |
| 2009-01-13 | E1 | Futures | 1.19319 | 1.19372 | 1.18175 | 1.18787 | 26928.0 |
| 2009-01-13 | E6 | Futures | 1.57838 | 1.57956 | 1.55233 | 1.55683 | 167800.0 |
| 2009-01-13 | E7 | Futures | 1.5604 | 1.561 | 1.5344 | 1.539 | 2438.0 |
| 2009-01-13 | EBM | Futures | 213.6 | 224.72 | 213.22 | 223.19 | 3506.0 |
| 2009-01-13 | ED | Futures | 93.4345 | 93.4345 | 93.3686 | 93.4157 | 204631.0 |
| 2009-01-13 | ER | Futures | 96.194 | 96.233 | 96.165 | 96.194 | 142300.0 |
| 2009-01-13 | EW | Futures | 503.3 | 510.7 | 495.9 | 508.0 | 28139.0 |
| 2009-01-13 | FCE | Futures | 1998.6 | 2001.4 | 1953.2 | 1980.1 | 126520.0 |
| 2009-01-13 | FDAX | Futures | 5138.1 | 5153.4 | 5034.3 | 5080.7 | 147159.0 |
| 2009-01-13 | FESX | Futures | 1402.4 | 1407.0 | 1372.0 | 1385.2 | 1212396.0 |
| 2009-01-13 | FEU3 | Futures | 96.771 | 96.776 | 96.736 | 96.761 | 352.0 |
| 2009-01-13 | FGBL | Futures | 93.51 | 93.72 | 93.39 | 93.46 | 662854.0 |
| 2009-01-13 | FGBM | Futures | 97.92 | 98.16 | 97.83 | 97.94 | 449384.0 |
| 2009-01-13 | FGBS | Futures | 103.589 | 103.628 | 103.503 | 103.522 | 489282.0 |
| 2009-01-13 | FGBX | Futures | 85.6 | 85.65 | 84.89 | 84.94 | 3469.0 |
| 2009-01-13 | FTDX | Futures | 424.2 | 429.6 | 415.2 | 426.9 | 394.0 |
| 2009-01-13 | FTI | Futures | 209.27 | 210.89 | 206.41 | 209.76 | 32551.0 |
| 2009-01-13 | FTUK | Futures | 2858.7 | 2872.5 | 2809.5 | 2847.9 | 116666.0 |
| 2009-01-13 | G | Futures | 76.63 | 76.67 | 76.12 | 76.14 | 81892.0 |
| 2009-01-13 | GF | Futures | 261.748 | 267.149 | 261.748 | 266.237 | 495.0 |
| 2009-01-13 | GSCI | Futures | 809.61 | 827.31 | 805.38 | 822.27 | 15.0 |
| 2009-01-13 | HE | Futures | 118.837 | 119.32 | 118.402 | 118.789 | 8215.0 |
| 2009-01-13 | HG | Futures | 2.0662 | 2.1844 | 1.9895 | 2.1774 | 15735.0 |
| 2009-01-13 | HO | Futures | 1.6445 | 1.7229 | 1.6155 | 1.6847 | 25170.0 |
| 2009-01-13 | HRC | Futures | 3130.5 | 3130.5 | 3130.5 | 3130.5 | 0.0 |
| 2009-01-13 | J1 | Futures | 0.0141496 | 0.0142367 | 0.0140624 | 0.0141811 | 71603.0 |
| 2009-01-13 | J7 | Futures | 0.013974 | 0.014061 | 0.013896 | 0.014011 | 101.0 |
| 2009-01-13 | JB | Futures | 116.92 | 117.06 | 116.37 | 116.88 | 22.0 |
| 2009-01-13 | KC | Futures | 325.96 | 333.96 | 324.53 | 327.96 | 7784.0 |
| 2009-01-13 | KE | Futures | 2965.43 | 3080.35 | 2950.44 | 2982.91 | 6900.0 |
| 2009-01-13 | L | Futures | 97.043 | 97.083 | 97.004 | 97.014 | 63243.0 |
| 2009-01-13 | LBS | Futures | 987.2 | 994.5 | 982.7 | 985.5 | 10.0 |
> showing 50 of 86 rows — these rows as CSV