PREVIEW / futures_daily / 2009-05-07
file: by_date/futures_daily/2009/2009-05-07.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-05-07 | ES | Futures | 873.75 | 885.9 | 855.88 | 864.46 | 2743570.0 |
| 2009-05-07 | NQ | Futures | 1604.09 | 1615.33 | 1545.11 | 1566.74 | 392552.0 |
| 2009-05-07 | YM | Futures | 7599.3 | 7687.2 | 7458.4 | 7523.0 | 191026.0 |
| 2009-05-07 | CL | Futures | 151.64 | 157.75 | 149.38 | 152.74 | 377826.0 |
| 2009-05-07 | GC | Futures | 1263.5 | 1282.8 | 1258.5 | 1267.6 | 124794.0 |
| 2009-05-07 | ZN | Futures | 93.953919 | 94.038879 | 93.116454 | 93.407746 | 858139.0 |
| 2009-05-07 | A6 | Futures | 0.59415 | 0.60587 | 0.59335 | 0.59845 | 67996.0 |
| 2009-05-07 | AD | Futures | 0.84397 | 0.84672 | 0.83698 | 0.83875 | 65970.0 |
| 2009-05-07 | B | Futures | 55.1 | 56.93 | 54.3 | 55.32 | 90302.0 |
| 2009-05-07 | B6 | Futures | 1.5733 | 1.5812 | 1.5545 | 1.56 | 102518.0 |
| 2009-05-07 | BFX | Futures | 2272.7 | 2313.4 | 2255.1 | 2267.2 | 484.0 |
| 2009-05-07 | BZ | Futures | 59.13 | 59.95 | 59.13 | 59.95 | 1.0 |
| 2009-05-07 | C | Futures | 1805.0 | 1858.0 | 1798.0 | 1857.0 | 11301.0 |
| 2009-05-07 | CB | Futures | 76.135 | 76.135 | 76.135 | 76.135 | 2.0 |
| 2009-05-07 | CC | Futures | 2097.0 | 2178.0 | 2083.0 | 2172.0 | 7862.0 |
| 2009-05-07 | CT | Futures | 54.02 | 54.96 | 53.66 | 54.48 | 6154.0 |
| 2009-05-07 | DC | Futures | 25.34 | 25.8 | 25.13 | 25.58 | 312.0 |
| 2009-05-07 | DX | Futures | 86.659 | 87.056 | 86.041 | 86.608 | 5585.0 |
| 2009-05-07 | E1 | Futures | 1.17106 | 1.17915 | 1.16112 | 1.17292 | 53159.0 |
| 2009-05-07 | E6 | Futures | 1.57778 | 1.59675 | 1.57078 | 1.58501 | 249213.0 |
| 2009-05-07 | E7 | Futures | 1.561 | 1.5783 | 1.5527 | 1.5666 | 3006.0 |
| 2009-05-07 | ED | Futures | 93.431 | 93.4687 | 93.4216 | 93.4593 | 205795.0 |
| 2009-05-07 | ER | Futures | 96.753 | 96.802 | 96.733 | 96.792 | 235445.0 |
| 2009-05-07 | EW | Futures | 562.3 | 569.4 | 543.7 | 548.3 | 38802.0 |
| 2009-05-07 | FCE | Futures | 2086.8 | 2119.8 | 2039.9 | 2053.5 | 174581.0 |
| 2009-05-07 | FDAX | Futures | 5367.7 | 5429.2 | 5219.0 | 5241.3 | 201372.0 |
| 2009-05-07 | FESX | Futures | 1453.3 | 1475.5 | 1414.9 | 1424.5 | 1489997.0 |
| 2009-05-07 | FEU3 | Futures | 97.333 | 97.397 | 97.313 | 97.372 | 412.0 |
| 2009-05-07 | FGBL | Futures | 92.1 | 92.1 | 91.0 | 91.27 | 1159955.0 |
| 2009-05-07 | FGBM | Futures | 97.81 | 97.81 | 97.12 | 97.35 | 673879.0 |
| 2009-05-07 | FGBS | Futures | 103.805 | 103.824 | 103.565 | 103.719 | 836947.0 |
| 2009-05-07 | FGBX | Futures | 82.51 | 82.53 | 80.9 | 81.14 | 2648.0 |
| 2009-05-07 | FTDX | Futures | 575.6 | 588.2 | 549.5 | 557.6 | 1943.0 |
| 2009-05-07 | FTI | Futures | 212.31 | 216.8 | 210.01 | 211.74 | 48361.0 |
| 2009-05-07 | FTUK | Futures | 2929.8 | 2993.7 | 2893.5 | 2904.5 | 193318.0 |
| 2009-05-07 | G | Futures | 75.57 | 75.71 | 74.89 | 75.44 | 146342.0 |
| 2009-05-07 | GF | Futures | 273.443 | 275.467 | 271.139 | 274.211 | 339.0 |
| 2009-05-07 | GSCI | Futures | 864.64 | 868.04 | 838.91 | 848.48 | 481.0 |
| 2009-05-07 | HE | Futures | 100.377 | 100.901 | 99.178 | 100.04 | 9252.0 |
| 2009-05-07 | HG | Futures | 3.079 | 3.1191 | 2.9742 | 3.0453 | 14180.0 |
| 2009-05-07 | HO | Futures | 1.6255 | 1.6722 | 1.588 | 1.6204 | 47445.0 |
| 2009-05-07 | HRC | Futures | 2520.0 | 2520.0 | 2520.0 | 2520.0 | 0.0 |
| 2009-05-07 | J1 | Futures | 0.0128093 | 0.0128207 | 0.0126342 | 0.0127337 | 94439.0 |
| 2009-05-07 | J7 | Futures | 0.012606 | 0.01263 | 0.012466 | 0.012561 | 66.0 |
| 2009-05-07 | JB | Futures | 114.88 | 115.25 | 114.88 | 114.88 | 2573.0 |
| 2009-05-07 | KC | Futures | 344.83 | 348.57 | 342.2 | 345.25 | 9421.0 |
| 2009-05-07 | KE | Futures | 2959.59 | 3042.48 | 2936.43 | 2992.5 | 12347.0 |
| 2009-05-07 | L | Futures | 96.993 | 97.033 | 96.974 | 97.033 | 63619.0 |
| 2009-05-07 | LBS | Futures | 829.1 | 835.9 | 805.8 | 809.5 | 77.0 |
| 2009-05-07 | LE | Futures | 145.079 | 145.476 | 143.399 | 144.99 | 12253.0 |
> showing 50 of 85 rows — these rows as CSV