PREVIEW / futures_daily / 2010-02-18
file: by_date/futures_daily/2010/2010-02-18.parquet size: 9 KB rows: 92
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-18 | ES | Futures | 1066.04 | 1072.82 | 1059.49 | 1071.61 | 1832739.0 |
| 2010-02-18 | NQ | Futures | 2049.46 | 2063.88 | 2041.26 | 2059.36 | 268313.0 |
| 2010-02-18 | YM | Futures | 9406.6 | 9486.0 | 9358.2 | 9476.9 | 102175.0 |
| 2010-02-18 | CL | Futures | 182.47 | 186.98 | 180.08 | 186.44 | 228169.0 |
| 2010-02-18 | GC | Futures | 1520.6 | 1543.3 | 1506.6 | 1534.9 | 188706.0 |
| 2010-02-18 | ZN | Futures | 94.844496 | 95.008217 | 94.328147 | 94.46668 | 1443270.0 |
| 2010-02-18 | A6 | Futures | 0.72802 | 0.73184 | 0.72347 | 0.73168 | 86279.0 |
| 2010-02-18 | AD | Futures | 0.94342 | 0.94964 | 0.94016 | 0.94925 | 75457.0 |
| 2010-02-18 | B | Futures | 68.07 | 69.99 | 67.55 | 69.8 | 181693.0 |
| 2010-02-18 | B6 | Futures | 1.6288 | 1.6293 | 1.6085 | 1.6228 | 126921.0 |
| 2010-02-18 | BFX | Futures | 2839.4 | 2856.6 | 2824.1 | 2856.6 | 1126.0 |
| 2010-02-18 | BR | Futures | 0.22256 | 0.22256 | 0.22256 | 0.22256 | 57.0 |
| 2010-02-18 | BZ | Futures | 71.44 | 73.25 | 70.96 | 73.2 | 50.0 |
| 2010-02-18 | C | Futures | 2290.0 | 2310.0 | 2279.0 | 2283.0 | 4675.0 |
| 2010-02-18 | CB | Futures | 73.531 | 73.777 | 73.531 | 73.777 | 3.0 |
| 2010-02-18 | CC | Futures | 2621.0 | 2654.0 | 2600.0 | 2617.0 | 4630.0 |
| 2010-02-18 | CT | Futures | 61.27 | 63.59 | 60.93 | 62.75 | 3581.0 |
| 2010-02-18 | DC | Futures | 21.88 | 22.13 | 21.83 | 22.07 | 116.0 |
| 2010-02-18 | DX | Futures | 81.996 | 82.576 | 81.615 | 81.828 | 28101.0 |
| 2010-02-18 | E1 | Futures | 1.2234 | 1.22696 | 1.21482 | 1.22392 | 44377.0 |
| 2010-02-18 | E6 | Futures | 1.61005 | 1.61656 | 1.59773 | 1.61194 | 346438.0 |
| 2010-02-18 | E7 | Futures | 1.599 | 1.6052 | 1.5864 | 1.6007 | 4055.0 |
| 2010-02-18 | EBM | Futures | 211.66 | 211.66 | 208.69 | 209.12 | 3930.0 |
| 2010-02-18 | ED | Futures | 94.3844 | 94.3891 | 94.3678 | 94.3844 | 189111.0 |
| 2010-02-18 | ER | Futures | 97.321 | 97.326 | 97.321 | 97.326 | 32378.0 |
| 2010-02-18 | EW | Futures | 712.6 | 716.1 | 708.6 | 715.4 | 22722.0 |
| 2010-02-18 | FBTP | Futures | 63.49 | 63.55 | 63.41 | 63.46 | 7078.0 |
| 2010-02-18 | FCE | Futures | 2397.8 | 2419.0 | 2383.3 | 2407.1 | 75772.0 |
| 2010-02-18 | FDAX | Futures | 6176.2 | 6239.5 | 6145.6 | 6213.3 | 152536.0 |
| 2010-02-18 | FESX | Futures | 1653.3 | 1672.4 | 1645.5 | 1664.1 | 1294320.0 |
| 2010-02-18 | FEU3 | Futures | 97.889 | 97.889 | 97.889 | 97.889 | 742.0 |
| 2010-02-18 | FGBL | Futures | 95.09 | 95.16 | 94.74 | 94.84 | 1029402.0 |
| 2010-02-18 | FGBM | Futures | 101.11 | 101.19 | 100.96 | 101.0 | 534305.0 |
| 2010-02-18 | FGBS | Futures | 106.024 | 106.063 | 106.0 | 106.015 | 577427.0 |
| 2010-02-18 | FGBX | Futures | 89.12 | 89.23 | 88.78 | 88.91 | 3677.0 |
| 2010-02-18 | FTDX | Futures | 714.6 | 722.1 | 714.6 | 719.0 | 601.0 |
| 2010-02-18 | FTI | Futures | 259.79 | 262.2 | 258.58 | 260.79 | 23391.0 |
| 2010-02-18 | FTUK | Futures | 3519.6 | 3572.6 | 3510.3 | 3552.8 | 105469.0 |
| 2010-02-18 | G | Futures | 75.26 | 75.34 | 74.93 | 74.99 | 75175.0 |
| 2010-02-18 | GF | Futures | 274.711 | 277.48 | 274.711 | 276.805 | 1369.0 |
| 2010-02-18 | GSCI | Futures | 944.36 | 961.95 | 940.65 | 961.95 | 443.0 |
| 2010-02-18 | HE | Futures | 92.598 | 94.404 | 92.129 | 94.036 | 16428.0 |
| 2010-02-18 | HG | Futures | 4.4403 | 4.5728 | 4.3699 | 4.5161 | 11674.0 |
| 2010-02-18 | HO | Futures | 1.8493 | 1.9025 | 1.8344 | 1.8986 | 12283.0 |
| 2010-02-18 | HRC | Futures | 2872.9 | 2872.9 | 2872.9 | 2872.9 | 0.0 |
| 2010-02-18 | J1 | Futures | 0.0138038 | 0.0138969 | 0.0137081 | 0.0137811 | 139643.0 |
| 2010-02-18 | J7 | Futures | 0.013628 | 0.01372 | 0.013544 | 0.013608 | 123.0 |
| 2010-02-18 | JB | Futures | 117.89 | 117.96 | 117.81 | 117.89 | 2248.0 |
| 2010-02-18 | KC | Futures | 344.79 | 352.75 | 344.28 | 350.31 | 11888.0 |
| 2010-02-18 | KE | Futures | 2270.26 | 2297.39 | 2225.04 | 2231.82 | 7573.0 |
> showing 50 of 92 rows — these rows as CSV