PREVIEW / futures_daily / 2009-10-16
file: by_date/futures_daily/2009/2009-10-16.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-16 | ES | Futures | 1051.58 | 1056.65 | 1039.29 | 1043.63 | 2017636.0 |
| 2009-10-16 | NQ | Futures | 1974.91 | 1984.5 | 1946.97 | 1954.59 | 333540.0 |
| 2009-10-16 | YM | Futures | 9051.4 | 9082.3 | 8973.3 | 9009.7 | 150071.0 |
| 2009-10-16 | CL | Futures | 191.76 | 194.09 | 189.49 | 193.63 | 214276.0 |
| 2009-10-16 | GC | Futures | 1452.9 | 1462.5 | 1442.8 | 1453.6 | 121668.0 |
| 2009-10-16 | ZN | Futures | 93.87826 | 94.239426 | 93.766174 | 94.152248 | 712649.0 |
| 2009-10-16 | A6 | Futures | 0.73968 | 0.74518 | 0.73314 | 0.73734 | 96823.0 |
| 2009-10-16 | AD | Futures | 0.95357 | 0.9583 | 0.94479 | 0.95002 | 68145.0 |
| 2009-10-16 | B | Futures | 71.46 | 72.03 | 70.33 | 71.82 | 123556.0 |
| 2009-10-16 | B6 | Futures | 1.692 | 1.7059 | 1.6904 | 1.7013 | 125902.0 |
| 2009-10-16 | BFX | Futures | 2947.5 | 2956.4 | 2852.8 | 2923.7 | 1252.0 |
| 2009-10-16 | BR | Futures | 0.23088 | 0.23096 | 0.23078 | 0.23096 | 17.0 |
| 2009-10-16 | BZ | Futures | 74.42 | 75.33 | 74.42 | 75.33 | 4.0 |
| 2009-10-16 | C | Futures | 2191.0 | 2207.0 | 2169.0 | 2202.0 | 4262.0 |
| 2009-10-16 | CB | Futures | 71.542 | 71.542 | 71.542 | 71.542 | 11.0 |
| 2009-10-16 | CC | Futures | 2852.0 | 2884.0 | 2815.0 | 2872.0 | 7418.0 |
| 2009-10-16 | CT | Futures | 58.34 | 58.95 | 57.54 | 58.87 | 9246.0 |
| 2009-10-16 | DC | Futures | 24.54 | 24.59 | 24.18 | 24.23 | 213.0 |
| 2009-10-16 | DX | Futures | 77.149 | 77.674 | 77.052 | 77.358 | 12408.0 |
| 2009-10-16 | E1 | Futures | 1.30148 | 1.30439 | 1.29237 | 1.29818 | 45991.0 |
| 2009-10-16 | E6 | Futures | 1.77001 | 1.77357 | 1.75947 | 1.76551 | 219870.0 |
| 2009-10-16 | E7 | Futures | 1.7528 | 1.7565 | 1.7427 | 1.7486 | 2729.0 |
| 2009-10-16 | ED | Futures | 94.1954 | 94.2001 | 94.1765 | 94.186 | 154146.0 |
| 2009-10-16 | ER | Futures | 97.051 | 97.071 | 97.051 | 97.061 | 80830.0 |
| 2009-10-16 | EW | Futures | 690.3 | 693.8 | 679.7 | 683.0 | 36879.0 |
| 2009-10-16 | FBTP | Futures | 61.87 | 62.14 | 61.86 | 62.1 | 3132.0 |
| 2009-10-16 | FCE | Futures | 2571.9 | 2573.2 | 2513.1 | 2519.7 | 128076.0 |
| 2009-10-16 | FDAX | Futures | 6381.1 | 6408.3 | 6237.0 | 6269.1 | 179912.0 |
| 2009-10-16 | FESX | Futures | 1759.1 | 1762.7 | 1716.1 | 1725.6 | 1384426.0 |
| 2009-10-16 | FEU3 | Futures | 97.623 | 97.638 | 97.623 | 97.633 | 1655.0 |
| 2009-10-16 | FGBL | Futures | 93.44 | 93.69 | 93.29 | 93.6 | 767757.0 |
| 2009-10-16 | FGBM | Futures | 98.74 | 98.92 | 98.69 | 98.86 | 468429.0 |
| 2009-10-16 | FGBS | Futures | 104.411 | 104.493 | 104.406 | 104.479 | 541620.0 |
| 2009-10-16 | FGBX | Futures | 86.14 | 86.89 | 86.02 | 86.71 | 1637.0 |
| 2009-10-16 | FTDX | Futures | 691.9 | 694.1 | 672.3 | 679.9 | 1426.0 |
| 2009-10-16 | FTI | Futures | 266.79 | 267.98 | 262.29 | 262.7 | 38200.0 |
| 2009-10-16 | FTUK | Futures | 3464.6 | 3478.9 | 3411.9 | 3433.8 | 130233.0 |
| 2009-10-16 | G | Futures | 77.07 | 77.13 | 76.68 | 77.0 | 116485.0 |
| 2009-10-16 | GF | Futures | 260.544 | 262.333 | 259.1 | 261.714 | 2730.0 |
| 2009-10-16 | GSCI | Futures | 989.17 | 1004.32 | 987.2 | 1004.32 | 1011.0 |
| 2009-10-16 | HE | Futures | 83.042 | 83.271 | 81.632 | 82.47 | 10404.0 |
| 2009-10-16 | HG | Futures | 3.9897 | 4.0064 | 3.9158 | 3.9653 | 16610.0 |
| 2009-10-16 | HO | Futures | 1.9831 | 2.0029 | 1.9654 | 1.9982 | 31637.0 |
| 2009-10-16 | HRC | Futures | 2763.8 | 2763.8 | 2763.8 | 2763.8 | 0.0 |
| 2009-10-16 | J1 | Futures | 0.0138664 | 0.0138777 | 0.0137534 | 0.0138225 | 101996.0 |
| 2009-10-16 | J7 | Futures | 0.013642 | 0.013684 | 0.013579 | 0.013642 | 104.0 |
| 2009-10-16 | JB | Futures | 117.26 | 117.29 | 117.1 | 117.16 | 1469.0 |
| 2009-10-16 | KC | Futures | 363.62 | 377.48 | 360.58 | 377.08 | 16445.0 |
| 2009-10-16 | KE | Futures | 2405.62 | 2431.21 | 2368.4 | 2375.38 | 7456.0 |
| 2009-10-16 | L | Futures | 97.779 | 97.789 | 97.77 | 97.77 | 29146.0 |
> showing 50 of 89 rows — these rows as CSV