PREVIEW / futures_daily / 2009-02-17
file: by_date/futures_daily/2009/2009-02-17.parquet size: 8 KB rows: 87
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-02-17 | ES | Futures | 768.65 | 773.14 | 741.74 | 741.74 | 2998314.0 |
| 2009-02-17 | NQ | Futures | 1368.7 | 1371.77 | 1318.11 | 1322.02 | 383318.0 |
| 2009-02-17 | YM | Futures | 6901.4 | 6920.1 | 6677.9 | 6684.2 | 241723.0 |
| 2009-02-17 | CL | Futures | 118.47 | 120.27 | 107.01 | 108.5 | 202333.0 |
| 2009-02-17 | GC | Futures | 1305.6 | 1353.6 | 1300.7 | 1342.6 | 137885.0 |
| 2009-02-17 | ZN | Futures | 94.104727 | 95.371728 | 93.805906 | 95.192435 | 688889.0 |
| 2009-02-17 | A6 | Futures | 0.51623 | 0.51766 | 0.50227 | 0.50433 | 32500.0 |
| 2009-02-17 | AD | Futures | 0.7924 | 0.79269 | 0.77491 | 0.77668 | 35742.0 |
| 2009-02-17 | B | Futures | 43.78 | 44.12 | 40.34 | 41.14 | 91699.0 |
| 2009-02-17 | B6 | Futures | 1.478 | 1.4875 | 1.4672 | 1.482 | 78680.0 |
| 2009-02-17 | BFX | Futures | 1975.9 | 1979.8 | 1952.8 | 1955.8 | 12178.0 |
| 2009-02-17 | BR | Futures | 0.15999 | 0.15999 | 0.15666 | 0.15666 | 10.0 |
| 2009-02-17 | BZ | Futures | 42.39 | 42.51 | 42.28 | 42.28 | 36.0 |
| 2009-02-17 | C | Futures | 1933.0 | 1937.0 | 1892.0 | 1927.0 | 1893.0 |
| 2009-02-17 | CB | Futures | 75.35 | 75.35 | 74.012 | 74.028 | 5.0 |
| 2009-02-17 | CC | Futures | 2350.0 | 2350.0 | 2291.0 | 2322.0 | 3835.0 |
| 2009-02-17 | CT | Futures | 42.86 | 43.61 | 41.95 | 42.37 | 13620.0 |
| 2009-02-17 | DC | Futures | 27.91 | 28.36 | 27.64 | 27.72 | 175.0 |
| 2009-02-17 | DX | Futures | 90.171 | 91.468 | 90.171 | 91.167 | 6675.0 |
| 2009-02-17 | E1 | Futures | 1.14281 | 1.14853 | 1.12859 | 1.13723 | 41773.0 |
| 2009-02-17 | E6 | Futures | 1.51409 | 1.51788 | 1.48674 | 1.49337 | 252617.0 |
| 2009-02-17 | E7 | Futures | 1.5002 | 1.5004 | 1.4697 | 1.4763 | 3907.0 |
| 2009-02-17 | EBM | Futures | 226.25 | 226.25 | 216.67 | 220.89 | 6651.0 |
| 2009-02-17 | ED | Futures | 93.0106 | 93.0154 | 92.9094 | 92.9636 | 271030.0 |
| 2009-02-17 | ER | Futures | 96.415 | 96.434 | 96.371 | 96.405 | 140867.0 |
| 2009-02-17 | EW | Futures | 485.8 | 488.6 | 468.1 | 469.6 | 29619.0 |
| 2009-02-17 | FCE | Futures | 1840.7 | 1840.7 | 1782.4 | 1795.2 | 141992.0 |
| 2009-02-17 | FDAX | Futures | 4737.9 | 4744.5 | 4584.0 | 4624.9 | 181160.0 |
| 2009-02-17 | FESX | Futures | 1254.2 | 1254.2 | 1209.4 | 1220.3 | 1618957.0 |
| 2009-02-17 | FEU3 | Futures | 96.998 | 96.998 | 96.958 | 96.973 | 1133.0 |
| 2009-02-17 | FGBL | Futures | 93.54 | 94.1 | 93.51 | 93.94 | 746312.0 |
| 2009-02-17 | FGBM | Futures | 98.52 | 98.82 | 98.45 | 98.76 | 365670.0 |
| 2009-02-17 | FGBS | Futures | 104.011 | 104.136 | 103.978 | 104.112 | 400611.0 |
| 2009-02-17 | FGBX | Futures | 86.94 | 87.39 | 86.37 | 87.28 | 1033.0 |
| 2009-02-17 | FTDX | Futures | 434.0 | 437.6 | 423.3 | 430.5 | 189.0 |
| 2009-02-17 | FTI | Futures | 199.56 | 199.64 | 193.2 | 193.94 | 20885.0 |
| 2009-02-17 | FTUK | Futures | 2667.9 | 2677.7 | 2598.4 | 2624.0 | 152541.0 |
| 2009-02-17 | G | Futures | 76.1 | 76.5 | 75.96 | 76.45 | 80608.0 |
| 2009-02-17 | GF | Futures | 265.045 | 265.045 | 256.629 | 257.049 | 789.0 |
| 2009-02-17 | GSCI | Futures | 695.61 | 701.29 | 684.67 | 687.62 | 308.0 |
| 2009-02-17 | HE | Futures | 122.268 | 122.606 | 117.435 | 118.015 | 5962.0 |
| 2009-02-17 | HG | Futures | 2.1654 | 2.1654 | 2.0245 | 2.0323 | 10859.0 |
| 2009-02-17 | HO | Futures | 1.4479 | 1.4479 | 1.3235 | 1.3331 | 7207.0 |
| 2009-02-17 | HRC | Futures | 2982.9 | 2982.9 | 2982.9 | 2982.9 | 0.0 |
| 2009-02-17 | J1 | Futures | 0.0137656 | 0.0138212 | 0.0136203 | 0.0136696 | 116189.0 |
| 2009-02-17 | J7 | Futures | 0.0136 | 0.013634 | 0.013463 | 0.013505 | 242.0 |
| 2009-02-17 | JB | Futures | 116.55 | 116.82 | 116.5 | 116.81 | 1440.0 |
| 2009-02-17 | KC | Futures | 321.1 | 322.93 | 317.02 | 318.01 | 12827.0 |
| 2009-02-17 | KE | Futures | 2861.75 | 2871.74 | 2748.08 | 2751.83 | 9849.0 |
| 2009-02-17 | L | Futures | 96.773 | 96.792 | 96.615 | 96.63 | 92031.0 |
> showing 50 of 87 rows — these rows as CSV