PREVIEW / futures_daily / 2009-02-02
file: by_date/futures_daily/2009/2009-02-02.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-02 | ES | Futures | 777.86 | 781.4 | 761.33 | 775.5 | 1971078.0 |
| 2009-02-02 | NQ | Futures | 1320.34 | 1343.82 | 1289.6 | 1329.01 | 289561.0 |
| 2009-02-02 | YM | Futures | 7086.6 | 7102.7 | 6955.7 | 7022.5 | 165134.0 |
| 2009-02-02 | CL | Futures | 138.7 | 140.56 | 132.32 | 133.15 | 263645.0 |
| 2009-02-02 | GC | Futures | 1286.4 | 1289.2 | 1251.9 | 1258.9 | 96273.0 |
| 2009-02-02 | ZN | Futures | 93.829811 | 94.797992 | 93.793953 | 94.642605 | 389943.0 |
| 2009-02-02 | A6 | Futures | 0.50172 | 0.50394 | 0.49418 | 0.49854 | 22418.0 |
| 2009-02-02 | AD | Futures | 0.79928 | 0.80153 | 0.78778 | 0.78886 | 19473.0 |
| 2009-02-02 | B | Futures | 48.1 | 48.49 | 45.62 | 45.67 | 62158.0 |
| 2009-02-02 | B6 | Futures | 1.5036 | 1.5044 | 1.4592 | 1.4822 | 74374.0 |
| 2009-02-02 | BFX | Futures | 2079.6 | 2095.7 | 2029.6 | 2061.6 | 205.0 |
| 2009-02-02 | BR | Futures | 0.15451 | 0.15633 | 0.15385 | 0.1563 | 1.0 |
| 2009-02-02 | BZ | Futures | 48.38 | 48.39 | 46.9 | 46.94 | 13.0 |
| 2009-02-02 | C | Futures | 1961.0 | 1971.0 | 1932.0 | 1963.0 | 4479.0 |
| 2009-02-02 | CB | Futures | 74.689 | 74.689 | 74.689 | 74.689 | 1.0 |
| 2009-02-02 | CC | Futures | 2445.0 | 2445.0 | 2359.0 | 2398.0 | 3772.0 |
| 2009-02-02 | CT | Futures | 48.01 | 48.86 | 47.39 | 48.39 | 10630.0 |
| 2009-02-02 | DC | Futures | 27.1 | 27.4 | 26.81 | 26.83 | 150.0 |
| 2009-02-02 | DX | Futures | 89.886 | 90.182 | 89.311 | 89.674 | 4039.0 |
| 2009-02-02 | E1 | Futures | 1.14308 | 1.14906 | 1.13816 | 1.14387 | 26285.0 |
| 2009-02-02 | E6 | Futures | 1.51161 | 1.52652 | 1.50332 | 1.51788 | 143139.0 |
| 2009-02-02 | E7 | Futures | 1.4943 | 1.5088 | 1.486 | 1.5005 | 2326.0 |
| 2009-02-02 | EBM | Futures | 229.71 | 230.09 | 227.02 | 228.17 | 3861.0 |
| 2009-02-02 | ED | Futures | 93.0201 | 93.0389 | 92.907 | 92.9447 | 286431.0 |
| 2009-02-02 | ER | Futures | 96.248 | 96.282 | 96.204 | 96.228 | 95189.0 |
| 2009-02-02 | EW | Futures | 486.5 | 490.1 | 475.8 | 485.3 | 27238.0 |
| 2009-02-02 | FCE | Futures | 1819.3 | 1829.5 | 1771.7 | 1811.9 | 126767.0 |
| 2009-02-02 | FDAX | Futures | 4710.6 | 4711.2 | 4588.3 | 4668.6 | 147722.0 |
| 2009-02-02 | FESX | Futures | 1276.0 | 1276.6 | 1239.8 | 1262.2 | 1098856.0 |
| 2009-02-02 | FEU3 | Futures | 96.82 | 96.82 | 96.78 | 96.79 | 1675.0 |
| 2009-02-02 | FGBL | Futures | 91.4 | 92.03 | 91.36 | 91.65 | 435215.0 |
| 2009-02-02 | FGBM | Futures | 96.94 | 97.47 | 96.86 | 97.19 | 279022.0 |
| 2009-02-02 | FGBS | Futures | 103.445 | 103.623 | 103.388 | 103.488 | 315852.0 |
| 2009-02-02 | FGBX | Futures | 83.64 | 84.04 | 83.25 | 83.9 | 2339.0 |
| 2009-02-02 | FTDX | Futures | 427.8 | 427.8 | 416.1 | 417.9 | 371.0 |
| 2009-02-02 | FTI | Futures | 198.7 | 198.91 | 194.15 | 197.57 | 29523.0 |
| 2009-02-02 | FTUK | Futures | 2660.4 | 2673.5 | 2619.0 | 2645.3 | 104748.0 |
| 2009-02-02 | G | Futures | 73.49 | 73.82 | 73.37 | 73.56 | 24765.0 |
| 2009-02-02 | GF | Futures | 258.733 | 263.712 | 258.733 | 263.712 | 573.0 |
| 2009-02-02 | GSCI | Futures | 767.86 | 781.93 | 763.87 | 765.75 | 183.0 |
| 2009-02-02 | HE | Futures | 121.012 | 121.785 | 118.885 | 119.223 | 5022.0 |
| 2009-02-02 | HG | Futures | 2.0408 | 2.0633 | 1.969 | 2.0141 | 9195.0 |
| 2009-02-02 | HO | Futures | 1.5971 | 1.6038 | 1.4938 | 1.4951 | 33131.0 |
| 2009-02-02 | HRC | Futures | 3041.9 | 3041.9 | 3041.9 | 3041.9 | 0.0 |
| 2009-02-02 | J1 | Futures | 0.014046 | 0.0142418 | 0.0140283 | 0.014118 | 75827.0 |
| 2009-02-02 | J7 | Futures | 0.013946 | 0.014059 | 0.013891 | 0.013948 | 45.0 |
| 2009-02-02 | JB | Futures | 116.31 | 116.46 | 116.18 | 116.29 | 18.0 |
| 2009-02-02 | KC | Futures | 339.82 | 344.39 | 334.39 | 342.25 | 9806.0 |
| 2009-02-02 | KE | Futures | 2987.91 | 3012.89 | 2924.2 | 2962.93 | 5641.0 |
| 2009-02-02 | L | Futures | 96.851 | 96.856 | 96.778 | 96.787 | 34349.0 |
> showing 50 of 87 rows — these rows as CSV