PREVIEW / futures_daily / 2009-02-19
file: by_date/futures_daily/2009/2009-02-19.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-19 | ES | Futures | 736.78 | 752.36 | 731.82 | 736.07 | 2407562.0 |
| 2009-02-19 | NQ | Futures | 1317.55 | 1343.26 | 1302.73 | 1308.6 | 339233.0 |
| 2009-02-19 | YM | Futures | 6665.5 | 6781.2 | 6610.3 | 6644.1 | 193941.0 |
| 2009-02-19 | CL | Futures | 105.68 | 113.37 | 104.5 | 113.12 | 285979.0 |
| 2009-02-19 | GC | Futures | 1369.7 | 1370.9 | 1345.4 | 1355.1 | 116161.0 |
| 2009-02-19 | ZN | Futures | 94.367689 | 94.58284 | 93.519038 | 93.734189 | 798006.0 |
| 2009-02-19 | A6 | Futures | 0.5056 | 0.51647 | 0.50457 | 0.51092 | 24277.0 |
| 2009-02-19 | AD | Futures | 0.77963 | 0.78788 | 0.77796 | 0.78238 | 25732.0 |
| 2009-02-19 | B | Futures | 40.02 | 42.3 | 39.75 | 42.1 | 107656.0 |
| 2009-02-19 | B6 | Futures | 1.4785 | 1.5015 | 1.477 | 1.4857 | 68811.0 |
| 2009-02-19 | BFX | Futures | 1945.1 | 1967.4 | 1933.1 | 1954.0 | 435.0 |
| 2009-02-19 | BR | Futures | 0.1556 | 0.1567 | 0.15469 | 0.15473 | 8.0 |
| 2009-02-19 | BZ | Futures | 41.23 | 43.27 | 41.23 | 43.27 | 10.0 |
| 2009-02-19 | C | Futures | 1873.0 | 1877.0 | 1860.0 | 1864.0 | 3626.0 |
| 2009-02-19 | CB | Futures | 74.028 | 74.329 | 74.028 | 74.179 | 26.0 |
| 2009-02-19 | CC | Futures | 2244.0 | 2290.0 | 2234.0 | 2261.0 | 4658.0 |
| 2009-02-19 | CT | Futures | 42.76 | 42.96 | 41.92 | 42.26 | 2359.0 |
| 2009-02-19 | DC | Futures | 28.44 | 29.52 | 27.91 | 27.96 | 270.0 |
| 2009-02-19 | DX | Futures | 91.468 | 91.499 | 90.441 | 90.991 | 4479.0 |
| 2009-02-19 | E1 | Futures | 1.13058 | 1.13616 | 1.12699 | 1.13337 | 21367.0 |
| 2009-02-19 | E6 | Futures | 1.48521 | 1.5103 | 1.4839 | 1.50131 | 190106.0 |
| 2009-02-19 | E7 | Futures | 1.4686 | 1.4929 | 1.467 | 1.4841 | 1954.0 |
| 2009-02-19 | EBM | Futures | 217.05 | 219.35 | 216.28 | 218.58 | 2714.0 |
| 2009-02-19 | ED | Futures | 92.9518 | 93.0106 | 92.9259 | 92.9871 | 240594.0 |
| 2009-02-19 | ER | Futures | 96.366 | 96.371 | 96.341 | 96.351 | 137012.0 |
| 2009-02-19 | EW | Futures | 462.8 | 473.9 | 457.5 | 459.5 | 31830.0 |
| 2009-02-19 | FCE | Futures | 1787.0 | 1817.9 | 1768.7 | 1792.0 | 74239.0 |
| 2009-02-19 | FDAX | Futures | 4585.6 | 4671.9 | 4541.9 | 4603.6 | 158061.0 |
| 2009-02-19 | FESX | Futures | 1213.4 | 1234.1 | 1196.2 | 1215.1 | 1295694.0 |
| 2009-02-19 | FEU3 | Futures | 96.933 | 96.933 | 96.914 | 96.919 | 634.0 |
| 2009-02-19 | FGBL | Futures | 93.65 | 93.71 | 92.9 | 93.15 | 808590.0 |
| 2009-02-19 | FGBM | Futures | 98.45 | 98.46 | 97.82 | 97.98 | 486768.0 |
| 2009-02-19 | FGBS | Futures | 103.968 | 103.968 | 103.685 | 103.738 | 574273.0 |
| 2009-02-19 | FGBX | Futures | 85.62 | 85.99 | 84.49 | 84.92 | 2162.0 |
| 2009-02-19 | FTDX | Futures | 431.4 | 435.8 | 426.9 | 429.6 | 244.0 |
| 2009-02-19 | FTI | Futures | 194.02 | 196.95 | 191.29 | 193.61 | 14088.0 |
| 2009-02-19 | FTUK | Futures | 2635.8 | 2642.0 | 2588.2 | 2625.3 | 110616.0 |
| 2009-02-19 | G | Futures | 76.36 | 76.41 | 75.6 | 75.89 | 105577.0 |
| 2009-02-19 | GF | Futures | 248.984 | 254.595 | 248.352 | 254.244 | 561.0 |
| 2009-02-19 | GSCI | Futures | 668.26 | 695.61 | 668.26 | 693.42 | 361.0 |
| 2009-02-19 | HE | Futures | 116.227 | 117.919 | 115.357 | 117.097 | 5896.0 |
| 2009-02-19 | HG | Futures | 2.0506 | 2.1273 | 2.0485 | 2.0964 | 8604.0 |
| 2009-02-19 | HO | Futures | 1.2961 | 1.35 | 1.2732 | 1.3452 | 11046.0 |
| 2009-02-19 | HRC | Futures | 2982.9 | 2982.9 | 2982.9 | 2982.9 | 0.0 |
| 2009-02-19 | J1 | Futures | 0.0134902 | 0.0135433 | 0.013374 | 0.0133841 | 81617.0 |
| 2009-02-19 | J7 | Futures | 0.013328 | 0.013377 | 0.013216 | 0.013223 | 328.0 |
| 2009-02-19 | JB | Futures | 116.8 | 116.93 | 116.74 | 116.88 | 1.0 |
| 2009-02-19 | KC | Futures | 312.94 | 318.85 | 312.94 | 316.46 | 7120.0 |
| 2009-02-19 | KE | Futures | 2729.34 | 2796.79 | 2729.34 | 2789.3 | 8043.0 |
| 2009-02-19 | L | Futures | 96.541 | 96.6 | 96.487 | 96.59 | 64169.0 |
> showing 50 of 87 rows — these rows as CSV