PREVIEW / futures_daily / 2009-02-18
file: by_date/futures_daily/2009/2009-02-18.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-18 | ES | Futures | 742.92 | 751.89 | 733.24 | 736.07 | 2732760.0 |
| 2009-02-18 | NQ | Futures | 1325.09 | 1346.06 | 1309.72 | 1319.22 | 355522.0 |
| 2009-02-18 | YM | Futures | 6695.7 | 6765.2 | 6627.2 | 6662.8 | 232469.0 |
| 2009-02-18 | CL | Futures | 107.88 | 109.65 | 104.78 | 105.32 | 219110.0 |
| 2009-02-18 | GC | Futures | 1346.4 | 1372.0 | 1334.4 | 1357.5 | 117775.0 |
| 2009-02-18 | ZN | Futures | 95.276105 | 95.455398 | 94.284019 | 94.606746 | 806978.0 |
| 2009-02-18 | A6 | Futures | 0.50362 | 0.50901 | 0.50164 | 0.50576 | 26725.0 |
| 2009-02-18 | AD | Futures | 0.77668 | 0.78395 | 0.77609 | 0.78041 | 29468.0 |
| 2009-02-18 | B | Futures | 40.52 | 41.88 | 39.46 | 39.66 | 100571.0 |
| 2009-02-18 | B6 | Futures | 1.4798 | 1.4855 | 1.464 | 1.4772 | 65289.0 |
| 2009-02-18 | BFX | Futures | 1975.9 | 1975.9 | 1912.0 | 1929.3 | 2677.0 |
| 2009-02-18 | BR | Futures | 0.15593 | 0.15593 | 0.15433 | 0.15487 | 17.0 |
| 2009-02-18 | BZ | Futures | 41.2 | 41.5 | 40.76 | 40.76 | 9.0 |
| 2009-02-18 | C | Futures | 1922.0 | 1926.0 | 1860.0 | 1891.0 | 3183.0 |
| 2009-02-18 | CB | Futures | 74.028 | 74.524 | 74.028 | 74.028 | 11.0 |
| 2009-02-18 | CC | Futures | 2300.0 | 2305.0 | 2242.0 | 2262.0 | 7432.0 |
| 2009-02-18 | CT | Futures | 42.83 | 43.1 | 42.21 | 42.72 | 4373.0 |
| 2009-02-18 | DC | Futures | 27.67 | 29.12 | 27.67 | 28.77 | 383.0 |
| 2009-02-18 | DX | Futures | 91.364 | 91.841 | 91.032 | 91.592 | 5493.0 |
| 2009-02-18 | E1 | Futures | 1.13683 | 1.14148 | 1.12407 | 1.13018 | 34463.0 |
| 2009-02-18 | E6 | Futures | 1.48899 | 1.49622 | 1.48082 | 1.48568 | 187427.0 |
| 2009-02-18 | E7 | Futures | 1.4716 | 1.4787 | 1.464 | 1.4687 | 2177.0 |
| 2009-02-18 | EBM | Futures | 218.97 | 218.97 | 216.28 | 217.43 | 4004.0 |
| 2009-02-18 | ED | Futures | 92.9588 | 92.9753 | 92.9165 | 92.9471 | 191023.0 |
| 2009-02-18 | ER | Futures | 96.4 | 96.41 | 96.361 | 96.375 | 105807.0 |
| 2009-02-18 | EW | Futures | 471.0 | 477.0 | 460.3 | 462.3 | 33073.0 |
| 2009-02-18 | FCE | Futures | 1797.3 | 1810.4 | 1760.5 | 1793.0 | 159425.0 |
| 2009-02-18 | FDAX | Futures | 4609.6 | 4646.2 | 4504.3 | 4600.4 | 194275.0 |
| 2009-02-18 | FESX | Futures | 1219.2 | 1227.8 | 1191.6 | 1218.6 | 1678272.0 |
| 2009-02-18 | FEU3 | Futures | 96.958 | 96.973 | 96.938 | 96.943 | 1567.0 |
| 2009-02-18 | FGBL | Futures | 93.97 | 94.16 | 93.58 | 93.91 | 826942.0 |
| 2009-02-18 | FGBM | Futures | 98.8 | 98.82 | 98.41 | 98.58 | 437149.0 |
| 2009-02-18 | FGBS | Futures | 104.127 | 104.146 | 103.93 | 103.949 | 391190.0 |
| 2009-02-18 | FGBX | Futures | 86.72 | 87.78 | 85.84 | 86.48 | 1526.0 |
| 2009-02-18 | FTDX | Futures | 431.4 | 433.1 | 422.4 | 429.6 | 269.0 |
| 2009-02-18 | FTI | Futures | 193.28 | 195.4 | 190.84 | 194.51 | 51034.0 |
| 2009-02-18 | FTUK | Futures | 2646.9 | 2650.8 | 2568.2 | 2615.8 | 132025.0 |
| 2009-02-18 | G | Futures | 76.41 | 76.93 | 76.24 | 76.64 | 89760.0 |
| 2009-02-18 | GF | Futures | 256.699 | 257.821 | 248.633 | 249.755 | 731.0 |
| 2009-02-18 | GSCI | Futures | 682.48 | 687.18 | 668.59 | 668.59 | 96.0 |
| 2009-02-18 | HE | Futures | 117.387 | 119.32 | 116.179 | 117.532 | 6694.0 |
| 2009-02-18 | HG | Futures | 2.0372 | 2.0682 | 2.009 | 2.0492 | 6881.0 |
| 2009-02-18 | HO | Futures | 1.3248 | 1.3485 | 1.2765 | 1.2807 | 6330.0 |
| 2009-02-18 | HRC | Futures | 2982.9 | 2982.9 | 2982.9 | 2982.9 | 0.0 |
| 2009-02-18 | J1 | Futures | 0.0136759 | 0.0137252 | 0.0134485 | 0.0134814 | 93192.0 |
| 2009-02-18 | J7 | Futures | 0.013509 | 0.013551 | 0.013289 | 0.013319 | 220.0 |
| 2009-02-18 | JB | Futures | 116.92 | 117.01 | 116.67 | 116.95 | 24.0 |
| 2009-02-18 | KC | Futures | 317.58 | 319.27 | 312.38 | 313.93 | 12071.0 |
| 2009-02-18 | KE | Futures | 2756.82 | 2764.32 | 2723.1 | 2730.59 | 6615.0 |
| 2009-02-18 | L | Futures | 96.62 | 96.64 | 96.512 | 96.546 | 136494.0 |
> showing 50 of 87 rows — these rows as CSV