PREVIEW / futures_daily / 2009-11-03
file: by_date/futures_daily/2009/2009-11-03.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-11-03 | ES | Futures | 1002.39 | 1006.97 | 990.09 | 1004.8 | 2315679.0 |
| 2009-11-03 | NQ | Futures | 1886.01 | 1893.63 | 1863.72 | 1891.37 | 323654.0 |
| 2009-11-03 | YM | Futures | 8842.6 | 8874.4 | 8740.0 | 8821.7 | 173566.0 |
| 2009-11-03 | CL | Futures | 191.35 | 195.46 | 187.57 | 195.05 | 373992.0 |
| 2009-11-03 | GC | Futures | 1465.9 | 1504.8 | 1459.2 | 1499.8 | 208684.0 |
| 2009-11-03 | ZN | Futures | 94.43869 | 94.762494 | 94.040162 | 94.177156 | 930628.0 |
| 2009-11-03 | A6 | Futures | 0.72829 | 0.73217 | 0.71778 | 0.72522 | 120181.0 |
| 2009-11-03 | AD | Futures | 0.91501 | 0.92537 | 0.90841 | 0.92359 | 87069.0 |
| 2009-11-03 | B | Futures | 71.86 | 73.53 | 70.53 | 73.33 | 72047.0 |
| 2009-11-03 | B6 | Futures | 1.7061 | 1.7119 | 1.6916 | 1.7062 | 133604.0 |
| 2009-11-03 | BFX | Futures | 2697.4 | 2697.4 | 2639.1 | 2670.3 | 361.0 |
| 2009-11-03 | BR | Futures | 0.22673 | 0.22673 | 0.22673 | 0.22673 | 24.0 |
| 2009-11-03 | BZ | Futures | 75.45 | 78.11 | 75.19 | 78.08 | 4.0 |
| 2009-11-03 | C | Futures | 2187.0 | 2244.0 | 2186.0 | 2224.0 | 3902.0 |
| 2009-11-03 | CC | Futures | 2850.0 | 2897.0 | 2828.0 | 2873.0 | 9764.0 |
| 2009-11-03 | CT | Futures | 58.43 | 58.95 | 57.65 | 58.21 | 9670.0 |
| 2009-11-03 | DC | Futures | 24.99 | 25.22 | 24.87 | 25.14 | 100.0 |
| 2009-11-03 | DX | Futures | 77.909 | 79.124 | 77.822 | 78.175 | 26379.0 |
| 2009-11-03 | E1 | Futures | 1.29277 | 1.29594 | 1.27797 | 1.28616 | 74125.0 |
| 2009-11-03 | E6 | Futures | 1.7507 | 1.75532 | 1.73316 | 1.74228 | 333458.0 |
| 2009-11-03 | E7 | Futures | 1.7342 | 1.7383 | 1.7164 | 1.7256 | 3781.0 |
| 2009-11-03 | ED | Futures | 94.2332 | 94.2332 | 94.2238 | 94.2285 | 105192.0 |
| 2009-11-03 | ER | Futures | 97.135 | 97.154 | 97.13 | 97.149 | 102193.0 |
| 2009-11-03 | EW | Futures | 640.1 | 648.8 | 632.2 | 647.9 | 50067.0 |
| 2009-11-03 | FBTP | Futures | 62.76 | 62.96 | 62.61 | 62.66 | 3776.0 |
| 2009-11-03 | FCE | Futures | 2372.1 | 2376.0 | 2335.4 | 2359.8 | 150360.0 |
| 2009-11-03 | FDAX | Futures | 5861.6 | 5873.0 | 5783.8 | 5840.9 | 182192.0 |
| 2009-11-03 | FESX | Futures | 1627.1 | 1629.5 | 1600.8 | 1615.1 | 1598071.0 |
| 2009-11-03 | FEU3 | Futures | 97.707 | 97.722 | 97.707 | 97.722 | 349.0 |
| 2009-11-03 | FGBL | Futures | 93.97 | 94.35 | 93.59 | 93.82 | 909546.0 |
| 2009-11-03 | FGBM | Futures | 99.25 | 99.48 | 99.11 | 99.23 | 461667.0 |
| 2009-11-03 | FGBS | Futures | 104.75 | 104.837 | 104.716 | 104.76 | 460977.0 |
| 2009-11-03 | FGBX | Futures | 87.26 | 87.9 | 86.71 | 87.05 | 2684.0 |
| 2009-11-03 | FTDX | Futures | 635.8 | 640.2 | 627.3 | 637.6 | 303.0 |
| 2009-11-03 | FTI | Futures | 245.93 | 246.66 | 242.08 | 244.78 | 40124.0 |
| 2009-11-03 | FTUK | Futures | 3340.9 | 3345.9 | 3286.2 | 3327.7 | 123150.0 |
| 2009-11-03 | G | Futures | 76.71 | 76.91 | 76.3 | 76.39 | 92317.0 |
| 2009-11-03 | GF | Futures | 261.576 | 262.539 | 260.338 | 260.475 | 1250.0 |
| 2009-11-03 | GSCI | Futures | 979.73 | 1007.47 | 975.0 | 1005.5 | 656.0 |
| 2009-11-03 | HE | Futures | 87.882 | 88.835 | 87.12 | 87.73 | 14466.0 |
| 2009-11-03 | HG | Futures | 4.1262 | 4.1659 | 4.0342 | 4.1193 | 28070.0 |
| 2009-11-03 | HO | Futures | 1.9825 | 2.0135 | 1.9403 | 2.0084 | 43507.0 |
| 2009-11-03 | HRC | Futures | 2713.1 | 2713.1 | 2713.1 | 2713.1 | 0.0 |
| 2009-11-03 | J1 | Futures | 0.0138966 | 0.0139757 | 0.0138652 | 0.0139041 | 75685.0 |
| 2009-11-03 | J7 | Futures | 0.013705 | 0.013791 | 0.013688 | 0.013723 | 51.0 |
| 2009-11-03 | KC | Futures | 374.18 | 374.97 | 366.92 | 372.46 | 12601.0 |
| 2009-11-03 | KE | Futures | 2412.6 | 2442.85 | 2367.24 | 2419.58 | 8408.0 |
| 2009-11-03 | L | Futures | 97.77 | 97.789 | 97.76 | 97.77 | 37805.0 |
| 2009-11-03 | LBS | Futures | 777.2 | 778.5 | 762.6 | 762.6 | 205.0 |
| 2009-11-03 | LE | Futures | 144.679 | 144.721 | 142.712 | 143.465 | 17195.0 |
> showing 50 of 87 rows — these rows as CSV