PREVIEW / futures_daily / 2009-10-19
file: by_date/futures_daily/2009/2009-10-19.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-10-19 | ES | Futures | 1041.94 | 1057.85 | 1038.08 | 1052.31 | 1559384.0 |
| 2009-10-19 | NQ | Futures | 1952.9 | 1982.81 | 1945.28 | 1975.75 | 270731.0 |
| 2009-10-19 | YM | Futures | 8998.8 | 9136.8 | 8964.3 | 9088.6 | 129499.0 |
| 2009-10-19 | CL | Futures | 193.87 | 196.15 | 192.23 | 195.93 | 255788.0 |
| 2009-10-19 | GC | Futures | 1456.4 | 1473.4 | 1449.6 | 1462.8 | 94792.0 |
| 2009-10-19 | ZN | Futures | 94.102432 | 94.339058 | 93.915622 | 94.239426 | 585808.0 |
| 2009-10-19 | A6 | Futures | 0.73572 | 0.7472 | 0.73233 | 0.74583 | 65083.0 |
| 2009-10-19 | AD | Futures | 0.94893 | 0.95929 | 0.94598 | 0.9585 | 49986.0 |
| 2009-10-19 | B | Futures | 71.91 | 72.64 | 71.37 | 72.55 | 112208.0 |
| 2009-10-19 | B6 | Futures | 1.6976 | 1.7084 | 1.6893 | 1.7029 | 109031.0 |
| 2009-10-19 | BFX | Futures | 2930.7 | 2956.4 | 2930.7 | 2950.4 | 23.0 |
| 2009-10-19 | BR | Futures | 0.23134 | 0.23134 | 0.23056 | 0.23086 | 10.0 |
| 2009-10-19 | BZ | Futures | 75.68 | 76.09 | 75.68 | 76.09 | 2.0 |
| 2009-10-19 | C | Futures | 2196.0 | 2223.0 | 2186.0 | 2210.0 | 4330.0 |
| 2009-10-19 | CB | Futures | 71.542 | 71.542 | 71.542 | 71.542 | 5.0 |
| 2009-10-19 | CC | Futures | 2870.0 | 2920.0 | 2844.0 | 2900.0 | 7642.0 |
| 2009-10-19 | CT | Futures | 58.6 | 59.48 | 57.26 | 57.36 | 13905.0 |
| 2009-10-19 | DC | Futures | 24.17 | 24.27 | 23.93 | 24.01 | 205.0 |
| 2009-10-19 | DX | Futures | 77.388 | 77.664 | 76.827 | 77.087 | 9473.0 |
| 2009-10-19 | E1 | Futures | 1.29739 | 1.30677 | 1.29171 | 1.30439 | 39174.0 |
| 2009-10-19 | E6 | Futures | 1.76551 | 1.77357 | 1.75709 | 1.77084 | 189175.0 |
| 2009-10-19 | E7 | Futures | 1.7479 | 1.7576 | 1.7404 | 1.7539 | 2395.0 |
| 2009-10-19 | ED | Futures | 94.1812 | 94.1954 | 94.1765 | 94.186 | 150309.0 |
| 2009-10-19 | ER | Futures | 97.061 | 97.081 | 97.051 | 97.071 | 112905.0 |
| 2009-10-19 | EW | Futures | 680.0 | 694.6 | 678.3 | 689.0 | 35496.0 |
| 2009-10-19 | FBTP | Futures | 62.06 | 62.21 | 62.01 | 62.16 | 2697.0 |
| 2009-10-19 | FCE | Futures | 2526.0 | 2563.7 | 2524.4 | 2562.7 | 89713.0 |
| 2009-10-19 | FDAX | Futures | 6277.2 | 6376.8 | 6269.1 | 6370.2 | 122597.0 |
| 2009-10-19 | FESX | Futures | 1727.4 | 1755.5 | 1726.2 | 1754.3 | 907909.0 |
| 2009-10-19 | FEU3 | Futures | 97.648 | 97.648 | 97.628 | 97.643 | 81.0 |
| 2009-10-19 | FGBL | Futures | 93.51 | 93.6 | 93.32 | 93.48 | 436369.0 |
| 2009-10-19 | FGBM | Futures | 98.76 | 98.87 | 98.64 | 98.8 | 296728.0 |
| 2009-10-19 | FGBS | Futures | 104.416 | 104.479 | 104.377 | 104.45 | 404912.0 |
| 2009-10-19 | FGBX | Futures | 86.57 | 86.75 | 86.32 | 86.48 | 2296.0 |
| 2009-10-19 | FTDX | Futures | 683.0 | 688.8 | 681.2 | 683.9 | 305.0 |
| 2009-10-19 | FTI | Futures | 263.32 | 267.12 | 263.23 | 266.75 | 26870.0 |
| 2009-10-19 | FTUK | Futures | 3437.4 | 3485.8 | 3437.1 | 3481.5 | 87480.0 |
| 2009-10-19 | G | Futures | 76.96 | 77.04 | 76.78 | 76.94 | 65478.0 |
| 2009-10-19 | GF | Futures | 262.264 | 263.433 | 261.782 | 262.814 | 1765.0 |
| 2009-10-19 | GSCI | Futures | 1001.17 | 1014.36 | 999.21 | 1014.36 | 338.0 |
| 2009-10-19 | HE | Futures | 82.432 | 83.385 | 81.784 | 82.394 | 10147.0 |
| 2009-10-19 | HG | Futures | 3.9653 | 4.1374 | 3.9095 | 4.1339 | 28661.0 |
| 2009-10-19 | HO | Futures | 2.0212 | 2.0212 | 1.9894 | 2.0191 | 22899.0 |
| 2009-10-19 | HRC | Futures | 2763.8 | 2763.8 | 2763.8 | 2763.8 | 0.0 |
| 2009-10-19 | J1 | Futures | 0.0138099 | 0.0139003 | 0.0137835 | 0.0138488 | 74009.0 |
| 2009-10-19 | J7 | Futures | 0.013614 | 0.013716 | 0.013614 | 0.013668 | 50.0 |
| 2009-10-19 | JB | Futures | 117.08 | 117.28 | 116.97 | 117.05 | 2197.0 |
| 2009-10-19 | KC | Futures | 377.08 | 383.81 | 372.86 | 380.78 | 11108.0 |
| 2009-10-19 | KE | Futures | 2371.89 | 2484.72 | 2364.91 | 2460.3 | 9968.0 |
| 2009-10-19 | L | Futures | 97.779 | 97.779 | 97.74 | 97.75 | 32704.0 |
> showing 50 of 89 rows — these rows as CSV