PREVIEW / futures_daily / 2010-07-06
file: by_date/futures_daily/2010/2010-07-06.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-07-06 | ES | Futures | 989.98 | 1012.9 | 978.04 | 999.01 | 2431642.0 |
| 2010-07-06 | NQ | Futures | 1949.0 | 1994.84 | 1930.61 | 1963.15 | 359579.0 |
| 2010-07-06 | YM | Futures | 8870.5 | 9057.3 | 8789.1 | 8951.9 | 159114.0 |
| 2010-07-06 | CL | Futures | 153.91 | 157.75 | 151.83 | 153.73 | 325727.0 |
| 2010-07-06 | GC | Futures | 1653.5 | 1657.5 | 1622.6 | 1630.2 | 148108.0 |
| 2010-07-06 | ZN | Futures | 100.285884 | 100.670072 | 100.157821 | 100.593234 | 949430.0 |
| 2010-07-06 | A6 | Futures | 0.69151 | 0.70386 | 0.6838 | 0.69855 | 129053.0 |
| 2010-07-06 | AD | Futures | 0.92851 | 0.94145 | 0.92446 | 0.93513 | 109708.0 |
| 2010-07-06 | B | Futures | 62.7 | 64.3 | 62.09 | 62.72 | 78600.0 |
| 2010-07-06 | B6 | Futures | 1.5768 | 1.5802 | 1.5651 | 1.5717 | 105053.0 |
| 2010-07-06 | BFX | Futures | 2702.2 | 2731.8 | 2702.2 | 2723.5 | 95.0 |
| 2010-07-06 | BR | Futures | 0.23167 | 0.23167 | 0.23144 | 0.23144 | 1.0 |
| 2010-07-06 | BZ | Futures | 68.38 | 68.38 | 67.03 | 67.03 | 111.0 |
| 2010-07-06 | C | Futures | 2540.0 | 2598.0 | 2533.0 | 2577.0 | 2676.0 |
| 2010-07-06 | CB | Futures | 83.053 | 83.294 | 83.053 | 83.294 | 11.0 |
| 2010-07-06 | CC | Futures | 2495.0 | 2510.0 | 2451.0 | 2475.0 | 5618.0 |
| 2010-07-06 | CSC | Futures | 3.774 | 3.776 | 3.76 | 3.769 | 9.0 |
| 2010-07-06 | CT | Futures | 65.25 | 66.18 | 64.78 | 64.88 | 154.0 |
| 2010-07-06 | DC | Futures | 22.79 | 23.09 | 22.79 | 23.06 | 351.0 |
| 2010-07-06 | DX | Futures | 85.623 | 85.749 | 84.705 | 84.973 | 19165.0 |
| 2010-07-06 | E1 | Futures | 1.23597 | 1.24516 | 1.23242 | 1.24136 | 50878.0 |
| 2010-07-06 | E6 | Futures | 1.48509 | 1.49775 | 1.47611 | 1.49266 | 359963.0 |
| 2010-07-06 | E7 | Futures | 1.4742 | 1.4868 | 1.4655 | 1.4819 | 4868.0 |
| 2010-07-06 | ED | Futures | 94.3186 | 94.347 | 94.3186 | 94.3328 | 158175.0 |
| 2010-07-06 | ER | Futures | 97.257 | 97.267 | 97.222 | 97.237 | 179907.0 |
| 2010-07-06 | EW | Futures | 684.0 | 702.5 | 676.0 | 684.6 | 31397.0 |
| 2010-07-06 | FBTP | Futures | 65.29 | 65.3 | 64.95 | 65.02 | 2090.0 |
| 2010-07-06 | FCE | Futures | 2195.7 | 2275.3 | 2195.7 | 2250.3 | 152332.0 |
| 2010-07-06 | FDAX | Futures | 6362.5 | 6530.0 | 6360.3 | 6449.0 | 161359.0 |
| 2010-07-06 | FESX | Futures | 1554.8 | 1609.3 | 1554.2 | 1587.6 | 1433588.0 |
| 2010-07-06 | FEU3 | Futures | 97.82 | 97.82 | 97.795 | 97.795 | 13.0 |
| 2010-07-06 | FGBL | Futures | 101.26 | 101.3 | 100.79 | 100.98 | 672104.0 |
| 2010-07-06 | FGBM | Futures | 105.52 | 105.55 | 105.2 | 105.33 | 371791.0 |
| 2010-07-06 | FGBS | Futures | 107.544 | 107.564 | 107.451 | 107.519 | 351720.0 |
| 2010-07-06 | FGBX | Futures | 101.2 | 101.25 | 100.37 | 100.68 | 5428.0 |
| 2010-07-06 | FTDX | Futures | 645.6 | 661.5 | 645.6 | 657.1 | 715.0 |
| 2010-07-06 | FTI | Futures | 242.97 | 251.13 | 242.97 | 248.87 | 34554.0 |
| 2010-07-06 | FTUK | Futures | 3315.2 | 3400.9 | 3310.1 | 3380.9 | 105469.0 |
| 2010-07-06 | G | Futures | 81.42 | 81.47 | 81.19 | 81.31 | 107229.0 |
| 2010-07-06 | GF | Futures | 285.455 | 287.35 | 284.697 | 286.781 | 2288.0 |
| 2010-07-06 | GSCI | Futures | 829.88 | 837.74 | 817.76 | 820.49 | 223.0 |
| 2010-07-06 | HE | Futures | 97.25 | 98.282 | 97.25 | 97.463 | 13398.0 |
| 2010-07-06 | HG | Futures | 3.9221 | 4.0446 | 3.8906 | 3.979 | 30253.0 |
| 2010-07-06 | HO | Futures | 1.7089 | 1.7474 | 1.6857 | 1.7019 | 19062.0 |
| 2010-07-06 | HRC | Futures | 2899.3 | 2899.3 | 2899.3 | 2899.3 | 0.0 |
| 2010-07-06 | J1 | Futures | 0.014355 | 0.0144166 | 0.0143122 | 0.0144028 | 143510.0 |
| 2010-07-06 | J7 | Futures | 0.014247 | 0.014309 | 0.014207 | 0.014294 | 183.0 |
| 2010-07-06 | JB | Futures | 120.66 | 120.71 | 120.36 | 120.38 | 916.0 |
| 2010-07-06 | KC | Futures | 410.48 | 410.61 | 393.91 | 395.92 | 15432.0 |
| 2010-07-06 | KE | Futures | 2190.34 | 2288.36 | 2189.28 | 2220.17 | 17998.0 |
> showing 50 of 91 rows — these rows as CSV