PREVIEW / futures_daily / 2009-08-12
file: by_date/futures_daily/2009/2009-08-12.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-08-12 | ES | Futures | 952.24 | 970.23 | 945.77 | 961.6 | 2040882.0 |
| 2009-08-12 | NQ | Futures | 1797.64 | 1839.87 | 1787.5 | 1822.98 | 348712.0 |
| 2009-08-12 | YM | Futures | 8315.1 | 8484.8 | 8264.6 | 8408.1 | 142977.0 |
| 2009-08-12 | CL | Futures | 179.38 | 183.13 | 177.24 | 180.64 | 342269.0 |
| 2009-08-12 | GC | Futures | 1311.4 | 1319.4 | 1302.4 | 1316.8 | 64429.0 |
| 2009-08-12 | ZN | Futures | 91.544526 | 91.840029 | 90.953519 | 91.544526 | 786625.0 |
| 2009-08-12 | A6 | Futures | 0.66492 | 0.67127 | 0.65576 | 0.6703 | 106833.0 |
| 2009-08-12 | AD | Futures | 0.89605 | 0.91057 | 0.89171 | 0.9083 | 75641.0 |
| 2009-08-12 | B | Futures | 69.12 | 70.09 | 68.36 | 69.53 | 108802.0 |
| 2009-08-12 | B6 | Futures | 1.716 | 1.7247 | 1.707 | 1.7203 | 115981.0 |
| 2009-08-12 | BFX | Futures | 2567.9 | 2593.2 | 2567.9 | 2591.4 | 22.0 |
| 2009-08-12 | BR | Futures | 0.21109 | 0.21187 | 0.21109 | 0.21187 | 291.0 |
| 2009-08-12 | BZ | Futures | 72.54 | 72.85 | 72.52 | 72.52 | 3.0 |
| 2009-08-12 | C | Futures | 1881.0 | 1917.0 | 1876.0 | 1911.0 | 2230.0 |
| 2009-08-12 | CB | Futures | 71.337 | 71.337 | 70.498 | 71.052 | 6.0 |
| 2009-08-12 | CC | Futures | 2494.0 | 2552.0 | 2468.0 | 2545.0 | 9720.0 |
| 2009-08-12 | CT | Futures | 54.84 | 55.49 | 54.42 | 54.88 | 143.0 |
| 2009-08-12 | DC | Futures | 22.5 | 22.75 | 22.41 | 22.71 | 132.0 |
| 2009-08-12 | DX | Futures | 81.126 | 81.387 | 80.573 | 80.757 | 6026.0 |
| 2009-08-12 | E1 | Futures | 1.22358 | 1.23417 | 1.2208 | 1.22967 | 34725.0 |
| 2009-08-12 | E6 | Futures | 1.67951 | 1.6915 | 1.67227 | 1.68734 | 249029.0 |
| 2009-08-12 | E7 | Futures | 1.6626 | 1.6739 | 1.655 | 1.67 | 2214.0 |
| 2009-08-12 | ED | Futures | 93.9896 | 94.0038 | 93.9849 | 93.9991 | 150313.0 |
| 2009-08-12 | ER | Futures | 97.086 | 97.11 | 97.076 | 97.095 | 83017.0 |
| 2009-08-12 | EW | Futures | 619.6 | 633.1 | 616.1 | 627.5 | 32338.0 |
| 2009-08-12 | FCE | Futures | 2265.4 | 2300.8 | 2246.8 | 2292.9 | 12477.0 |
| 2009-08-12 | FDAX | Futures | 5830.9 | 5908.8 | 5765.1 | 5871.5 | 128522.0 |
| 2009-08-12 | FESX | Futures | 1585.9 | 1614.0 | 1568.0 | 1602.7 | 925834.0 |
| 2009-08-12 | FEU3 | Futures | 97.658 | 97.682 | 97.658 | 97.672 | 431.0 |
| 2009-08-12 | FGBL | Futures | 91.65 | 91.96 | 91.45 | 91.7 | 566242.0 |
| 2009-08-12 | FGBM | Futures | 97.46 | 97.71 | 97.41 | 97.54 | 330128.0 |
| 2009-08-12 | FGBS | Futures | 103.801 | 103.921 | 103.801 | 103.868 | 369253.0 |
| 2009-08-12 | FGBX | Futures | 84.95 | 85.18 | 84.53 | 84.78 | 1560.0 |
| 2009-08-12 | FTDX | Futures | 609.4 | 613.4 | 604.1 | 612.1 | 482.0 |
| 2009-08-12 | FTI | Futures | 235.26 | 238.81 | 231.84 | 238.48 | 276.0 |
| 2009-08-12 | FTUK | Futures | 3086.7 | 3139.5 | 3065.2 | 3125.2 | 119483.0 |
| 2009-08-12 | G | Futures | 75.5 | 75.62 | 75.27 | 75.45 | 59088.0 |
| 2009-08-12 | GF | Futures | 276.587 | 280.25 | 275.757 | 276.518 | 1694.0 |
| 2009-08-12 | GSCI | Futures | 962.64 | 964.37 | 950.2 | 961.0 | 3480.0 |
| 2009-08-12 | HE | Futures | 65.992 | 67.641 | 65.056 | 65.917 | 12491.0 |
| 2009-08-12 | HG | Futures | 3.8431 | 3.9814 | 3.7946 | 3.9645 | 31153.0 |
| 2009-08-12 | HO | Futures | 1.9345 | 1.9549 | 1.9047 | 1.9149 | 39240.0 |
| 2009-08-12 | HRC | Futures | 2586.5 | 2586.5 | 2586.5 | 2586.5 | 0.0 |
| 2009-08-12 | J1 | Futures | 0.0131217 | 0.0132375 | 0.0130084 | 0.0130915 | 105127.0 |
| 2009-08-12 | J7 | Futures | 0.012955 | 0.013049 | 0.012839 | 0.012911 | 20.0 |
| 2009-08-12 | JB | Futures | 115.57 | 115.88 | 115.57 | 115.82 | 2911.0 |
| 2009-08-12 | KC | Futures | 369.57 | 372.55 | 366.17 | 367.8 | 10834.0 |
| 2009-08-12 | KE | Futures | 2478.52 | 2495.3 | 2431.75 | 2489.31 | 8176.0 |
| 2009-08-12 | L | Futures | 97.475 | 97.534 | 97.435 | 97.524 | 91880.0 |
| 2009-08-12 | LBS | Futures | 794.8 | 804.6 | 789.6 | 795.6 | 233.0 |
> showing 50 of 86 rows — these rows as CSV