PREVIEW / futures_daily / 2009-12-02
file: by_date/futures_daily/2009/2009-12-02.parquet size: 9 KB rows: 89
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-12-02 | ES | Futures | 1068.94 | 1075.94 | 1065.09 | 1068.7 | 1669060.0 |
| 2009-12-02 | NQ | Futures | 2022.04 | 2039.25 | 2016.11 | 2022.32 | 246295.0 |
| 2009-12-02 | YM | Futures | 9496.3 | 9537.1 | 9452.7 | 9477.2 | 105251.0 |
| 2009-12-02 | CL | Futures | 189.58 | 191.26 | 185.49 | 186.41 | 340897.0 |
| 2009-12-02 | GC | Futures | 1647.6 | 1677.0 | 1646.9 | 1669.6 | 191901.0 |
| 2009-12-02 | ZN | Futures | 96.256974 | 96.356606 | 95.970532 | 95.970532 | 59921.0 |
| 2009-12-02 | A6 | Futures | 0.74607 | 0.75035 | 0.7451 | 0.74615 | 86708.0 |
| 2009-12-02 | AD | Futures | 0.94233 | 0.94529 | 0.9375 | 0.93789 | 80497.0 |
| 2009-12-02 | B | Futures | 73.65 | 73.9 | 71.93 | 72.3 | 64501.0 |
| 2009-12-02 | B6 | Futures | 1.7285 | 1.7373 | 1.7219 | 1.7314 | 98572.0 |
| 2009-12-02 | BFX | Futures | 2831.1 | 2853.5 | 2821.9 | 2846.9 | 171.0 |
| 2009-12-02 | BR | Futures | 0.23063 | 0.23087 | 0.23031 | 0.23087 | 406.0 |
| 2009-12-02 | C | Futures | 2252.0 | 2260.0 | 2226.0 | 2229.0 | 1046.0 |
| 2009-12-02 | CB | Futures | 77.725 | 77.725 | 75.628 | 75.628 | 52.0 |
| 2009-12-02 | CC | Futures | 2870.0 | 2891.0 | 2845.0 | 2858.0 | 4242.0 |
| 2009-12-02 | CT | Futures | 59.91 | 60.39 | 59.56 | 59.98 | 4820.0 |
| 2009-12-02 | DC | Futures | 25.34 | 25.44 | 25.15 | 25.22 | 136.0 |
| 2009-12-02 | DX | Futures | 76.031 | 76.281 | 75.959 | 76.27 | 12525.0 |
| 2009-12-02 | E1 | Futures | 1.32156 | 1.32381 | 1.31733 | 1.31773 | 42113.0 |
| 2009-12-02 | E6 | Futures | 1.78684 | 1.79075 | 1.78151 | 1.78186 | 226483.0 |
| 2009-12-02 | E7 | Futures | 1.7701 | 1.7736 | 1.7644 | 1.7648 | 2234.0 |
| 2009-12-02 | ED | Futures | 94.2805 | 94.2852 | 94.2758 | 94.2781 | 121617.0 |
| 2009-12-02 | ER | Futures | 97.149 | 97.164 | 97.149 | 97.159 | 59567.0 |
| 2009-12-02 | EW | Futures | 672.7 | 682.2 | 670.9 | 677.8 | 30303.0 |
| 2009-12-02 | FBTP | Futures | 63.21 | 63.45 | 63.21 | 63.43 | 5216.0 |
| 2009-12-02 | FCE | Futures | 2504.5 | 2527.7 | 2495.5 | 2517.4 | 93158.0 |
| 2009-12-02 | FDAX | Futures | 6283.2 | 6327.8 | 6259.8 | 6285.4 | 120741.0 |
| 2009-12-02 | FESX | Futures | 1717.3 | 1728.6 | 1707.1 | 1716.7 | 984240.0 |
| 2009-12-02 | FEU3 | Futures | 97.727 | 97.732 | 97.727 | 97.732 | 1.0 |
| 2009-12-02 | FGBL | Futures | 95.03 | 95.26 | 94.98 | 95.22 | 1044118.0 |
| 2009-12-02 | FGBM | Futures | 100.11 | 100.31 | 100.07 | 100.24 | 631632.0 |
| 2009-12-02 | FGBS | Futures | 105.084 | 105.161 | 105.065 | 105.137 | 837610.0 |
| 2009-12-02 | FGBX | Futures | 88.9 | 89.06 | 88.44 | 88.77 | 11920.0 |
| 2009-12-02 | FTDX | Futures | 719.0 | 719.0 | 709.7 | 714.6 | 477.0 |
| 2009-12-02 | FTI | Futures | 257.83 | 259.83 | 257.22 | 258.52 | 31972.0 |
| 2009-12-02 | FTUK | Futures | 3522.0 | 3549.2 | 3504.1 | 3531.6 | 86874.0 |
| 2009-12-02 | G | Futures | 77.52 | 77.63 | 77.29 | 77.4 | 100417.0 |
| 2009-12-02 | GF | Futures | 254.017 | 256.051 | 253.407 | 254.831 | 3351.0 |
| 2009-12-02 | GSCI | Futures | 997.63 | 997.63 | 980.81 | 987.48 | 383.0 |
| 2009-12-02 | HE | Futures | 89.219 | 89.721 | 88.449 | 89.185 | 10553.0 |
| 2009-12-02 | HG | Futures | 4.438 | 4.5152 | 4.4249 | 4.4952 | 19840.0 |
| 2009-12-02 | HO | Futures | 1.9692 | 1.9767 | 1.9363 | 1.9456 | 10541.0 |
| 2009-12-02 | HRC | Futures | 2561.7 | 2561.7 | 2561.7 | 2561.7 | 0.0 |
| 2009-12-02 | J1 | Futures | 0.0144779 | 0.0145018 | 0.0143511 | 0.0143599 | 99463.0 |
| 2009-12-02 | J7 | Futures | 0.014301 | 0.01431 | 0.014166 | 0.014173 | 53.0 |
| 2009-12-02 | JB | Futures | 118.16 | 118.4 | 118.07 | 118.35 | 1741.0 |
| 2009-12-02 | KC | Futures | 372.22 | 375.6 | 370.4 | 374.04 | 6781.0 |
| 2009-12-02 | KE | Futures | 2578.92 | 2594.74 | 2537.08 | 2557.43 | 5455.0 |
| 2009-12-02 | KRW | Futures | 0.0008506 | 0.0008511 | 0.0008499 | 0.0008506 | 90.0 |
| 2009-12-02 | L | Futures | 97.73 | 97.75 | 97.72 | 97.73 | 34973.0 |
> showing 50 of 89 rows — these rows as CSV