PREVIEW / futures_daily / 2009-07-02
file: by_date/futures_daily/2009/2009-07-02.parquet size: 8 KB rows: 85
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-07-02 | ES | Futures | 881.97 | 882.45 | 856.54 | 857.02 | 1850449.0 |
| 2009-07-02 | NQ | Futures | 1665.03 | 1665.88 | 1623.08 | 1627.59 | 263370.0 |
| 2009-07-02 | YM | Futures | 7620.4 | 7624.0 | 7427.3 | 7435.4 | 134523.0 |
| 2009-07-02 | CL | Futures | 182.13 | 183.5 | 174.34 | 175.58 | 243250.0 |
| 2009-07-02 | GC | Futures | 1302.6 | 1304.3 | 1282.8 | 1288.9 | 101814.0 |
| 2009-07-02 | ZN | Futures | 91.667652 | 92.246347 | 91.532213 | 92.07397 | 687226.0 |
| 2009-07-02 | A6 | Futures | 0.647 | 0.64716 | 0.6343 | 0.63583 | 76306.0 |
| 2009-07-02 | AD | Futures | 0.8601 | 0.86138 | 0.84943 | 0.85082 | 54816.0 |
| 2009-07-02 | B | Futures | 66.11 | 66.41 | 63.58 | 63.97 | 83446.0 |
| 2009-07-02 | B6 | Futures | 1.7165 | 1.7184 | 1.6999 | 1.7102 | 107146.0 |
| 2009-07-02 | BFX | Futures | 2346.7 | 2365.5 | 2321.7 | 2324.0 | 354.0 |
| 2009-07-02 | BR | Futures | 0.19732 | 0.19732 | 0.19732 | 0.19732 | 17.0 |
| 2009-07-02 | C | Futures | 1693.0 | 1702.0 | 1690.0 | 1698.0 | 1832.0 |
| 2009-07-02 | CB | Futures | 71.337 | 71.337 | 71.337 | 71.337 | 15.0 |
| 2009-07-02 | CC | Futures | 2217.0 | 2241.0 | 2202.0 | 2218.0 | 3444.0 |
| 2009-07-02 | CT | Futures | 52.17 | 52.36 | 50.91 | 52.19 | 99.0 |
| 2009-07-02 | DC | Futures | 20.29 | 20.31 | 19.97 | 20.03 | 122.0 |
| 2009-07-02 | DX | Futures | 81.729 | 82.482 | 81.729 | 82.272 | 3270.0 |
| 2009-07-02 | E1 | Futures | 1.23377 | 1.23377 | 1.21802 | 1.22424 | 34412.0 |
| 2009-07-02 | E6 | Futures | 1.67951 | 1.67998 | 1.66052 | 1.66491 | 228046.0 |
| 2009-07-02 | E7 | Futures | 1.6622 | 1.6627 | 1.6435 | 1.6478 | 2858.0 |
| 2009-07-02 | ED | Futures | 93.815 | 93.8622 | 93.815 | 93.848 | 189384.0 |
| 2009-07-02 | ER | Futures | 96.919 | 96.988 | 96.914 | 96.973 | 238070.0 |
| 2009-07-02 | EW | Futures | 562.6 | 563.2 | 545.3 | 546.7 | 23835.0 |
| 2009-07-02 | FCE | Futures | 2076.1 | 2091.4 | 2027.1 | 2033.0 | 144396.0 |
| 2009-07-02 | FDAX | Futures | 5334.4 | 5355.8 | 5162.2 | 5191.3 | 154776.0 |
| 2009-07-02 | FESX | Futures | 1443.9 | 1451.7 | 1405.2 | 1413.5 | 1185541.0 |
| 2009-07-02 | FEU3 | Futures | 97.49 | 97.549 | 97.49 | 97.549 | 260.0 |
| 2009-07-02 | FGBL | Futures | 91.92 | 92.53 | 91.88 | 92.46 | 783192.0 |
| 2009-07-02 | FGBM | Futures | 97.87 | 98.41 | 97.85 | 98.34 | 489015.0 |
| 2009-07-02 | FGBS | Futures | 103.969 | 104.229 | 103.964 | 104.196 | 646652.0 |
| 2009-07-02 | FGBX | Futures | 83.06 | 83.87 | 82.78 | 83.76 | 1379.0 |
| 2009-07-02 | FTDX | Futures | 561.2 | 566.6 | 552.3 | 555.0 | 389.0 |
| 2009-07-02 | FTI | Futures | 209.56 | 210.09 | 204.56 | 205.09 | 35028.0 |
| 2009-07-02 | FTUK | Futures | 2845.5 | 2847.4 | 2771.4 | 2786.4 | 126313.0 |
| 2009-07-02 | G | Futures | 75.37 | 75.63 | 75.02 | 75.43 | 117334.0 |
| 2009-07-02 | GF | Futures | 285.966 | 285.966 | 282.108 | 285.14 | 2709.0 |
| 2009-07-02 | GSCI | Futures | 917.94 | 920.02 | 907.5 | 909.59 | 784.0 |
| 2009-07-02 | HE | Futures | 88.094 | 88.418 | 85.863 | 88.022 | 10104.0 |
| 2009-07-02 | HG | Futures | 3.2793 | 3.2913 | 3.1817 | 3.2372 | 14672.0 |
| 2009-07-02 | HO | Futures | 1.8306 | 1.838 | 1.764 | 1.77 | 12456.0 |
| 2009-07-02 | HRC | Futures | 2280.5 | 2280.5 | 2280.5 | 2280.5 | 0.0 |
| 2009-07-02 | J1 | Futures | 0.0130449 | 0.0131645 | 0.0130449 | 0.0131519 | 89909.0 |
| 2009-07-02 | J7 | Futures | 0.01285 | 0.012997 | 0.01283 | 0.012971 | 43.0 |
| 2009-07-02 | JB | Futures | 116.42 | 116.42 | 116.26 | 116.42 | 1795.0 |
| 2009-07-02 | KC | Futures | 322.76 | 323.71 | 317.6 | 319.64 | 5533.0 |
| 2009-07-02 | KE | Futures | 2745.91 | 2774.69 | 2701.55 | 2706.34 | 10890.0 |
| 2009-07-02 | L | Futures | 97.141 | 97.209 | 97.131 | 97.2 | 50084.0 |
| 2009-07-02 | LBS | Futures | 860.2 | 862.0 | 843.8 | 861.1 | 221.0 |
| 2009-07-02 | LE | Futures | 150.722 | 150.722 | 148.916 | 149.576 | 15835.0 |
> showing 50 of 85 rows — these rows as CSV