PREVIEW / futures_daily / 2010-02-05
file: by_date/futures_daily/2010/2010-02-05.parquet size: 9 KB rows: 91
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-05 | ES | Futures | 1029.2 | 1032.35 | 1008.85 | 1027.26 | 3983950.0 |
| 2010-02-05 | NQ | Futures | 1961.24 | 1976.79 | 1934.94 | 1973.68 | 556768.0 |
| 2010-02-05 | YM | Futures | 9114.3 | 9138.0 | 8943.5 | 9080.5 | 242968.0 |
| 2010-02-05 | CL | Futures | 172.52 | 174.65 | 164.16 | 168.15 | 596142.0 |
| 2010-02-05 | GC | Futures | 1462.2 | 1467.3 | 1433.1 | 1444.5 | 253584.0 |
| 2010-02-05 | ZN | Futures | 95.31047 | 95.877194 | 95.159343 | 95.801631 | 1664425.0 |
| 2010-02-05 | A6 | Futures | 0.70145 | 0.706 | 0.69454 | 0.69942 | 177442.0 |
| 2010-02-05 | AD | Futures | 0.92032 | 0.92743 | 0.91558 | 0.91992 | 125044.0 |
| 2010-02-05 | B | Futures | 64.92 | 65.44 | 61.34 | 62.89 | 174059.0 |
| 2010-02-05 | B6 | Futures | 1.6368 | 1.638 | 1.6155 | 1.6203 | 175838.0 |
| 2010-02-05 | BFX | Futures | 2737.6 | 2738.2 | 2689.1 | 2701.3 | 679.0 |
| 2010-02-05 | BR | Futures | 0.21498 | 0.21498 | 0.2124 | 0.21369 | 200.0 |
| 2010-02-05 | BZ | Futures | 66.98 | 66.98 | 64.54 | 65.96 | 3.0 |
| 2010-02-05 | C | Futures | 2268.0 | 2288.0 | 2232.0 | 2237.0 | 5683.0 |
| 2010-02-05 | CB | Futures | 70.57 | 70.57 | 69.583 | 70.076 | 14.0 |
| 2010-02-05 | CC | Futures | 2652.0 | 2652.0 | 2529.0 | 2540.0 | 12204.0 |
| 2010-02-05 | CT | Futures | 56.33 | 56.56 | 54.26 | 54.31 | 24345.0 |
| 2010-02-05 | DC | Futures | 22.35 | 22.46 | 22.21 | 22.38 | 179.0 |
| 2010-02-05 | DX | Futures | 81.661 | 82.189 | 81.452 | 81.961 | 42679.0 |
| 2010-02-05 | E1 | Futures | 1.23619 | 1.23869 | 1.22155 | 1.22748 | 71603.0 |
| 2010-02-05 | E6 | Futures | 1.6252 | 1.62733 | 1.60815 | 1.61419 | 464958.0 |
| 2010-02-05 | E7 | Futures | 1.6137 | 1.6159 | 1.597 | 1.603 | 4794.0 |
| 2010-02-05 | EBM | Futures | 212.08 | 212.5 | 211.23 | 211.66 | 8574.0 |
| 2010-02-05 | ED | Futures | 94.3773 | 94.382 | 94.3441 | 94.3631 | 384998.0 |
| 2010-02-05 | ER | Futures | 97.306 | 97.316 | 97.277 | 97.291 | 250582.0 |
| 2010-02-05 | EW | Futures | 676.8 | 679.0 | 660.7 | 674.5 | 46334.0 |
| 2010-02-05 | FBTP | Futures | 63.44 | 63.5 | 63.29 | 63.38 | 8840.0 |
| 2010-02-05 | FCE | Futures | 2397.7 | 2400.0 | 2297.4 | 2320.6 | 273680.0 |
| 2010-02-05 | FDAX | Futures | 6047.3 | 6048.4 | 5880.1 | 5961.0 | 290430.0 |
| 2010-02-05 | FESX | Futures | 1619.8 | 1619.8 | 1554.5 | 1580.9 | 3291283.0 |
| 2010-02-05 | FEU3 | Futures | 97.865 | 97.865 | 97.855 | 97.855 | 532.0 |
| 2010-02-05 | FGBL | Futures | 95.49 | 96.02 | 95.44 | 95.76 | 1238589.0 |
| 2010-02-05 | FGBM | Futures | 101.11 | 101.51 | 101.11 | 101.38 | 770219.0 |
| 2010-02-05 | FGBS | Futures | 105.859 | 106.034 | 105.854 | 105.98 | 1014396.0 |
| 2010-02-05 | FGBX | Futures | 89.71 | 90.93 | 89.64 | 90.61 | 3965.0 |
| 2010-02-05 | FTDX | Futures | 698.7 | 702.2 | 679.7 | 683.6 | 1865.0 |
| 2010-02-05 | FTI | Futures | 260.47 | 261.16 | 252.51 | 255.19 | 71391.0 |
| 2010-02-05 | FTUK | Futures | 3398.4 | 3405.1 | 3332.1 | 3365.9 | 226147.0 |
| 2010-02-05 | G | Futures | 76.21 | 76.42 | 76.09 | 76.18 | 99517.0 |
| 2010-02-05 | GF | Futures | 263.366 | 266.405 | 263.096 | 265.595 | 4093.0 |
| 2010-02-05 | GSCI | Futures | 906.36 | 911.41 | 874.03 | 884.87 | 4963.0 |
| 2010-02-05 | HE | Futures | 89.821 | 90.289 | 88.65 | 89.286 | 14061.0 |
| 2010-02-05 | HG | Futures | 3.9524 | 4.0055 | 3.8779 | 3.942 | 48342.0 |
| 2010-02-05 | HO | Futures | 1.7968 | 1.8106 | 1.701 | 1.7453 | 66558.0 |
| 2010-02-05 | HRC | Futures | 2848.9 | 2848.9 | 2848.9 | 2848.9 | 0.0 |
| 2010-02-05 | J1 | Futures | 0.0141171 | 0.0141712 | 0.0140013 | 0.0141146 | 189145.0 |
| 2010-02-05 | J7 | Futures | 0.013935 | 0.013991 | 0.01383 | 0.013938 | 166.0 |
| 2010-02-05 | JB | Futures | 117.29 | 117.6 | 117.25 | 117.38 | 1714.0 |
| 2010-02-05 | KC | Futures | 342.16 | 343.2 | 334.48 | 335.26 | 17362.0 |
| 2010-02-05 | KE | Futures | 2203.55 | 2209.21 | 2171.9 | 2191.12 | 12229.0 |
> showing 50 of 91 rows — these rows as CSV