PREVIEW / futures_daily / 2008-08-27
file: by_date/futures_daily/2008/2008-08-27.parquet size: 8 KB rows: 83
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 |
|---|---|---|---|---|---|---|---|
| 2008-08-27 | ES | Futures | 1176.09 | 1188.8 | 1170.54 | 1185.8 | 1442209.0 |
| 2008-08-27 | NQ | Futures | 2104.21 | 2132.02 | 2093.64 | 2115.61 | 297429.0 |
| 2008-08-27 | YM | Futures | 10135.1 | 10259.5 | 10094.3 | 10210.6 | 168640.0 |
| 2008-08-27 | CL | Futures | 501.74 | 517.26 | 500.01 | 510.86 | 265812.0 |
| 2008-08-27 | GC | Futures | 1159.8 | 1176.7 | 1155.1 | 1166.3 | 103839.0 |
| 2008-08-27 | ZN | Futures | 86.022837 | 86.241461 | 85.643122 | 86.149409 | 1447992.0 |
| 2008-08-27 | A6 | Futures | 0.65845 | 0.66556 | 0.6576 | 0.66069 | 40025.0 |
| 2008-08-27 | AD | Futures | 0.93642 | 0.94162 | 0.93543 | 0.93691 | 27555.0 |
| 2008-08-27 | B | Futures | 136.32 | 139.35 | 136.32 | 138.13 | 45203.0 |
| 2008-08-27 | B6 | Futures | 1.8901 | 1.901 | 1.8799 | 1.8843 | 69263.0 |
| 2008-08-27 | BFX | Futures | 3395.3 | 3415.0 | 3377.3 | 3409.3 | 92.0 |
| 2008-08-27 | BR | Futures | 0.22742 | 0.22742 | 0.22742 | 0.22742 | 20.0 |
| 2008-08-27 | BZ | Futures | 135.26 | 135.26 | 135.26 | 135.26 | 577.0 |
| 2008-08-27 | C | Futures | 1434.0 | 1467.0 | 1434.0 | 1461.0 | 3801.0 |
| 2008-08-27 | CC | Futures | 2580.0 | 2653.0 | 2577.0 | 2635.0 | 7457.0 |
| 2008-08-27 | CT | Futures | 70.98 | 72.13 | 70.98 | 71.56 | 77.0 |
| 2008-08-27 | DC | Futures | 42.62 | 42.92 | 42.62 | 42.77 | 55.0 |
| 2008-08-27 | DX | Futures | 81.903 | 81.903 | 81.279 | 81.702 | 6139.0 |
| 2008-08-27 | E1 | Futures | 1.21182 | 1.22115 | 1.20902 | 1.21355 | 59720.0 |
| 2008-08-27 | E6 | Futures | 1.71293 | 1.7285 | 1.7114 | 1.72042 | 244100.0 |
| 2008-08-27 | E7 | Futures | 1.6961 | 1.7115 | 1.6951 | 1.7038 | 3109.0 |
| 2008-08-27 | ED | Futures | 91.7375 | 91.7399 | 91.7328 | 91.7375 | 109242.0 |
| 2008-08-27 | ER | Futures | 93.63 | 93.635 | 93.62 | 93.625 | 69169.0 |
| 2008-08-27 | EW | Futures | 794.9 | 806.1 | 792.3 | 803.2 | 20436.0 |
| 2008-08-27 | FCE | Futures | 2853.4 | 2869.0 | 2810.4 | 2851.4 | 104694.0 |
| 2008-08-27 | FDAX | Futures | 7121.0 | 7137.3 | 7019.1 | 7137.3 | 135241.0 |
| 2008-08-27 | FESX | Futures | 1940.3 | 1950.9 | 1916.9 | 1950.3 | 1043786.0 |
| 2008-08-27 | FEU3 | Futures | 94.176 | 94.181 | 94.171 | 94.171 | 247.0 |
| 2008-08-27 | FGBL | Futures | 86.38 | 86.45 | 85.75 | 85.88 | 917625.0 |
| 2008-08-27 | FGBM | Futures | 91.93 | 92.06 | 91.47 | 91.54 | 625534.0 |
| 2008-08-27 | FGBS | Futures | 100.005 | 100.121 | 99.826 | 99.85 | 605514.0 |
| 2008-08-27 | FGBX | Futures | 77.29 | 77.38 | 76.51 | 76.75 | 1968.0 |
| 2008-08-27 | FTDX | Futures | 734.9 | 745.7 | 732.2 | 743.9 | 770.0 |
| 2008-08-27 | FTI | Futures | 310.0 | 313.26 | 307.47 | 311.92 | 24123.0 |
| 2008-08-27 | FTUK | Futures | 3545.2 | 3610.9 | 3526.4 | 3583.1 | 100794.0 |
| 2008-08-27 | G | Futures | 69.51 | 69.62 | 69.26 | 69.39 | 223842.0 |
| 2008-08-27 | GF | Futures | 299.388 | 299.922 | 295.784 | 296.919 | 151.0 |
| 2008-08-27 | GSCI | Futures | 1844.94 | 1860.26 | 1823.3 | 1833.68 | 60.0 |
| 2008-08-27 | HE | Futures | 154.347 | 154.559 | 149.574 | 149.574 | 6483.0 |
| 2008-08-27 | HG | Futures | 4.7958 | 4.8707 | 4.7664 | 4.8224 | 12412.0 |
| 2008-08-27 | HO | Futures | 3.7354 | 3.8469 | 3.7354 | 3.786 | 9153.0 |
| 2008-08-27 | J1 | Futures | 0.0116136 | 0.0117141 | 0.0115869 | 0.0116136 | 129129.0 |
| 2008-08-27 | J7 | Futures | 0.01142 | 0.011511 | 0.011389 | 0.011414 | 140.0 |
| 2008-08-27 | JB | Futures | 115.86 | 115.86 | 115.27 | 115.5 | 2543.0 |
| 2008-08-27 | KC | Futures | 437.01 | 449.1 | 435.24 | 436.86 | 17446.0 |
| 2008-08-27 | KE | Futures | 4580.86 | 4614.37 | 4415.87 | 4449.39 | 10161.0 |
| 2008-08-27 | L | Futures | 93.458 | 93.458 | 93.289 | 93.443 | 39169.0 |
| 2008-08-27 | LE | Futures | 195.882 | 195.974 | 191.76 | 192.223 | 7293.0 |
| 2008-08-27 | MP | Futures | 0.0473 | 0.04746 | 0.04729 | 0.04739 | 7956.0 |
| 2008-08-27 | N6 | Futures | 0.53422 | 0.54155 | 0.53368 | 0.53893 | 3104.0 |
> showing 50 of 83 rows — these rows as CSV