PREVIEW / futures_daily / 2009-07-24
file: by_date/futures_daily/2009/2009-07-24.parquet size: 8 KB rows: 84
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-07-24 | ES | Futures | 925.86 | 939.29 | 923.46 | 938.09 | 1682233.0 |
| 2009-07-24 | NQ | Futures | 1779.05 | 1802.14 | 1770.33 | 1798.76 | 267261.0 |
| 2009-07-24 | YM | Futures | 8095.0 | 8178.9 | 8072.4 | 8172.6 | 101823.0 |
| 2009-07-24 | CL | Futures | 171.52 | 175.59 | 171.11 | 175.2 | 217270.0 |
| 2009-07-24 | GC | Futures | 1312.5 | 1321.3 | 1310.5 | 1319.5 | 70915.0 |
| 2009-07-24 | ZN | Futures | 91.630714 | 91.803091 | 91.421399 | 91.70459 | 544993.0 |
| 2009-07-24 | A6 | Futures | 0.65102 | 0.65568 | 0.65046 | 0.65399 | 51299.0 |
| 2009-07-24 | AD | Futures | 0.90633 | 0.91541 | 0.90445 | 0.91156 | 57882.0 |
| 2009-07-24 | B | Futures | 65.48 | 67.08 | 65.39 | 66.94 | 83024.0 |
| 2009-07-24 | B6 | Futures | 1.7167 | 1.7229 | 1.7069 | 1.7113 | 81089.0 |
| 2009-07-24 | BFX | Futures | 2437.9 | 2451.6 | 2424.3 | 2428.8 | 469.0 |
| 2009-07-24 | BR | Futures | 0.20423 | 0.20423 | 0.20423 | 0.20423 | 71.0 |
| 2009-07-24 | C | Futures | 1913.0 | 1948.0 | 1900.0 | 1944.0 | 2532.0 |
| 2009-07-24 | CC | Futures | 2551.0 | 2597.0 | 2520.0 | 2586.0 | 6755.0 |
| 2009-07-24 | CT | Futures | 52.44 | 52.72 | 50.65 | 50.76 | 252.0 |
| 2009-07-24 | DC | Futures | 21.34 | 21.65 | 20.93 | 21.57 | 211.0 |
| 2009-07-24 | DX | Futures | 80.967 | 81.11 | 80.593 | 80.752 | 2682.0 |
| 2009-07-24 | E1 | Futures | 1.23166 | 1.24092 | 1.23099 | 1.23814 | 26213.0 |
| 2009-07-24 | E6 | Futures | 1.67975 | 1.69221 | 1.67797 | 1.68758 | 166162.0 |
| 2009-07-24 | E7 | Futures | 1.662 | 1.6747 | 1.661 | 1.6703 | 1464.0 |
| 2009-07-24 | ED | Futures | 93.9094 | 93.9236 | 93.9047 | 93.9188 | 74917.0 |
| 2009-07-24 | ER | Futures | 97.071 | 97.081 | 97.061 | 97.071 | 46442.0 |
| 2009-07-24 | EW | Futures | 589.1 | 600.8 | 586.4 | 600.1 | 23712.0 |
| 2009-07-24 | FCE | Futures | 2204.1 | 2235.3 | 2194.0 | 2207.1 | 114727.0 |
| 2009-07-24 | FDAX | Futures | 5737.1 | 5822.7 | 5707.5 | 5732.7 | 122890.0 |
| 2009-07-24 | FESX | Futures | 1536.4 | 1559.1 | 1531.1 | 1538.8 | 1033953.0 |
| 2009-07-24 | FEU3 | Futures | 97.648 | 97.653 | 97.648 | 97.648 | 24.0 |
| 2009-07-24 | FGBL | Futures | 91.6 | 91.67 | 91.32 | 91.46 | 584369.0 |
| 2009-07-24 | FGBM | Futures | 97.86 | 97.92 | 97.61 | 97.73 | 335052.0 |
| 2009-07-24 | FGBS | Futures | 104.094 | 104.114 | 103.988 | 104.046 | 394367.0 |
| 2009-07-24 | FGBX | Futures | 82.89 | 83.15 | 82.48 | 82.92 | 2016.0 |
| 2009-07-24 | FTDX | Futures | 597.8 | 602.3 | 588.9 | 590.7 | 351.0 |
| 2009-07-24 | FTI | Futures | 225.05 | 227.97 | 224.23 | 225.83 | 30559.0 |
| 2009-07-24 | FTUK | Futures | 3004.4 | 3037.6 | 2990.1 | 3015.7 | 96698.0 |
| 2009-07-24 | G | Futures | 74.09 | 74.36 | 74.0 | 74.33 | 66702.0 |
| 2009-07-24 | GF | Futures | 282.039 | 282.659 | 280.04 | 282.659 | 1615.0 |
| 2009-07-24 | GSCI | Futures | 933.09 | 939.15 | 928.71 | 939.15 | 360.0 |
| 2009-07-24 | HE | Futures | 87.158 | 87.158 | 84.387 | 84.999 | 7937.0 |
| 2009-07-24 | HG | Futures | 3.5033 | 3.5721 | 3.4956 | 3.5412 | 12807.0 |
| 2009-07-24 | HO | Futures | 1.8045 | 1.8437 | 1.8043 | 1.8301 | 26281.0 |
| 2009-07-24 | HRC | Futures | 2459.7 | 2459.7 | 2434.4 | 2434.4 | 10.0 |
| 2009-07-24 | J1 | Futures | 0.0132576 | 0.0133155 | 0.013235 | 0.0132967 | 68048.0 |
| 2009-07-24 | J7 | Futures | 0.013076 | 0.013126 | 0.013066 | 0.013114 | 40.0 |
| 2009-07-24 | JB | Futures | 116.44 | 116.61 | 116.18 | 116.5 | 2790.0 |
| 2009-07-24 | KC | Futures | 337.95 | 340.26 | 334.83 | 336.33 | 4203.0 |
| 2009-07-24 | KE | Futures | 2688.36 | 2713.54 | 2628.4 | 2633.2 | 7226.0 |
| 2009-07-24 | L | Futures | 97.337 | 97.367 | 97.317 | 97.357 | 32758.0 |
| 2009-07-24 | LBS | Futures | 788.7 | 793.6 | 763.2 | 763.2 | 353.0 |
| 2009-07-24 | LE | Futures | 150.176 | 150.176 | 149.136 | 149.427 | 7421.0 |
| 2009-07-24 | MP | Futures | 0.03935 | 0.03957 | 0.03927 | 0.03931 | 11424.0 |
> showing 50 of 84 rows — these rows as CSV