PREVIEW / futures_daily / 2008-07-02
file: by_date/futures_daily/2008/2008-07-02.parquet size: 8 KB rows: 82
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-07-02 | ES | Futures | 1189.73 | 1197.59 | 1166.37 | 1167.99 | 2431509.0 |
| 2008-07-02 | NQ | Futures | 2080.01 | 2099.48 | 2025.23 | 2030.23 | 476841.0 |
| 2008-07-02 | YM | Futures | 10104.9 | 10158.2 | 9939.8 | 9956.6 | 218435.0 |
| 2008-07-02 | CL | Futures | 615.08 | 627.6 | 608.86 | 624.34 | 253397.0 |
| 2008-07-02 | GC | Futures | 1333.4 | 1342.4 | 1322.0 | 1340.4 | 125044.0 |
| 2008-07-02 | ZN | Futures | 83.871116 | 84.147272 | 83.606465 | 84.112753 | 958065.0 |
| 2008-07-02 | A6 | Futures | 0.73122 | 0.73871 | 0.72967 | 0.73724 | 49282.0 |
| 2008-07-02 | AD | Futures | 0.96038 | 0.97256 | 0.9593 | 0.96922 | 47934.0 |
| 2008-07-02 | B | Futures | 170.77 | 174.24 | 169.12 | 173.53 | 62622.0 |
| 2008-07-02 | B6 | Futures | 2.0427 | 2.0455 | 2.0322 | 2.0419 | 70120.0 |
| 2008-07-02 | BFX | Futures | 3508.2 | 3543.3 | 3497.5 | 3497.5 | 439.0 |
| 2008-07-02 | BR | Futures | 0.22627 | 0.22627 | 0.22437 | 0.2244 | 2.0 |
| 2008-07-02 | BZ | Futures | 167.64 | 171.25 | 167.05 | 170.97 | 542.0 |
| 2008-07-02 | C | Futures | 1539.0 | 1541.0 | 1519.0 | 1522.0 | 2286.0 |
| 2008-07-02 | CB | Futures | 95.316 | 95.316 | 95.163 | 95.163 | 4.0 |
| 2008-07-02 | CC | Futures | 2938.0 | 2947.0 | 2889.0 | 2913.0 | 5156.0 |
| 2008-07-02 | CT | Futures | 76.57 | 77.09 | 74.93 | 75.54 | 820.0 |
| 2008-07-02 | DC | Futures | 53.13 | 53.27 | 52.95 | 52.95 | 95.0 |
| 2008-07-02 | DX | Futures | 76.537 | 77.077 | 76.527 | 76.559 | 240.0 |
| 2008-07-02 | E1 | Futures | 1.30697 | 1.3163 | 1.30311 | 1.31497 | 66081.0 |
| 2008-07-02 | E6 | Futures | 1.84218 | 1.85365 | 1.84019 | 1.85306 | 202552.0 |
| 2008-07-02 | E7 | Futures | 1.8247 | 1.8358 | 1.8225 | 1.8351 | 2808.0 |
| 2008-07-02 | ED | Futures | 91.6171 | 91.6407 | 91.5841 | 91.636 | 193910.0 |
| 2008-07-02 | ER | Futures | 93.526 | 93.531 | 93.487 | 93.507 | 143228.0 |
| 2008-07-02 | EW | Futures | 811.5 | 817.1 | 786.3 | 787.7 | 35717.0 |
| 2008-07-02 | FCE | Futures | 2854.1 | 2886.4 | 2796.8 | 2831.1 | 137142.0 |
| 2008-07-02 | FDAX | Futures | 7127.7 | 7233.0 | 7059.4 | 7059.4 | 172730.0 |
| 2008-07-02 | FESX | Futures | 1939.8 | 1972.0 | 1922.2 | 1922.2 | 1482722.0 |
| 2008-07-02 | FEU3 | Futures | 94.062 | 94.067 | 94.043 | 94.052 | 1251.0 |
| 2008-07-02 | FGBL | Futures | 83.19 | 83.19 | 82.68 | 82.89 | 1015292.0 |
| 2008-07-02 | FGBM | Futures | 89.33 | 89.34 | 89.01 | 89.13 | 564313.0 |
| 2008-07-02 | FGBS | Futures | 99.013 | 99.018 | 98.853 | 98.902 | 553749.0 |
| 2008-07-02 | FGBX | Futures | 74.24 | 74.24 | 73.42 | 73.91 | 1858.0 |
| 2008-07-02 | FTDX | Futures | 689.6 | 693.2 | 661.5 | 661.5 | 1263.0 |
| 2008-07-02 | FTI | Futures | 314.27 | 315.44 | 307.49 | 308.13 | 35433.0 |
| 2008-07-02 | FTUK | Futures | 3564.9 | 3619.4 | 3487.9 | 3531.6 | 123505.0 |
| 2008-07-02 | G | Futures | 66.18 | 66.52 | 66.05 | 66.37 | 109875.0 |
| 2008-07-02 | GF | Futures | 306.053 | 306.053 | 302.257 | 304.155 | 215.0 |
| 2008-07-02 | GSCI | Futures | 2254.55 | 2304.93 | 2251.95 | 2303.11 | 102.0 |
| 2008-07-02 | HE | Futures | 141.185 | 143.234 | 140.986 | 142.484 | 4441.0 |
| 2008-07-02 | HG | Futures | 5.4271 | 5.6863 | 5.4041 | 5.6633 | 22949.0 |
| 2008-07-02 | HO | Futures | 4.6401 | 4.7969 | 4.6007 | 4.7716 | 12499.0 |
| 2008-07-02 | J1 | Futures | 0.0120512 | 0.0120754 | 0.0119609 | 0.0120525 | 144862.0 |
| 2008-07-02 | J7 | Futures | 0.011831 | 0.011864 | 0.011758 | 0.011845 | 72.0 |
| 2008-07-02 | JB | Futures | 112.71 | 112.71 | 112.34 | 112.39 | 845.0 |
| 2008-07-02 | KC | Futures | 470.76 | 473.95 | 465.15 | 473.19 | 9785.0 |
| 2008-07-02 | KE | Futures | 4733.08 | 4800.72 | 4705.23 | 4799.39 | 8638.0 |
| 2008-07-02 | L | Futures | 93.165 | 93.229 | 93.16 | 93.21 | 45838.0 |
| 2008-07-02 | LE | Futures | 205.683 | 207.821 | 205.087 | 206.827 | 4763.0 |
| 2008-07-02 | MP | Futures | 0.04594 | 0.04606 | 0.04588 | 0.046 | 14166.0 |
> showing 50 of 82 rows — these rows as CSV