PREVIEW / futures_daily / 2008-04-28
file: by_date/futures_daily/2008/2008-04-28.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-04-28 | ES | Futures | 1295.22 | 1300.77 | 1290.36 | 1294.06 | 1155730.0 |
| 2008-04-28 | NQ | Futures | 2148.76 | 2170.55 | 2144.84 | 2153.51 | 189027.0 |
| 2008-04-28 | YM | Futures | 11437.0 | 11483.2 | 11405.9 | 11436.1 | 97007.0 |
| 2008-04-28 | CL | Futures | 520.07 | 524.35 | 516.61 | 519.19 | 201651.0 |
| 2008-04-28 | GC | Futures | 1260.4 | 1271.8 | 1258.7 | 1268.1 | 83084.0 |
| 2008-04-28 | ZN | Futures | 83.771155 | 84.146913 | 83.691449 | 84.05582 | 544093.0 |
| 2008-04-28 | A6 | Futures | 0.70799 | 0.71387 | 0.70799 | 0.71318 | 28145.0 |
| 2008-04-28 | AD | Futures | 0.96874 | 0.97591 | 0.96451 | 0.9707 | 33007.0 |
| 2008-04-28 | B | Futures | 141.73 | 142.03 | 140.39 | 141.19 | 50221.0 |
| 2008-04-28 | B6 | Futures | 2.0209 | 2.0339 | 2.0152 | 2.0269 | 68120.0 |
| 2008-04-28 | BFX | Futures | 4338.5 | 4379.1 | 4338.5 | 4374.6 | 32.0 |
| 2008-04-28 | BR | Futures | 0.21235 | 0.21235 | 0.21231 | 0.21235 | 11.0 |
| 2008-04-28 | BZ | Futures | 138.08 | 138.18 | 137.01 | 137.8 | 181.0 |
| 2008-04-28 | C | Futures | 1290.0 | 1311.0 | 1290.0 | 1301.0 | 1497.0 |
| 2008-04-28 | CC | Futures | 2487.0 | 2535.0 | 2476.0 | 2513.0 | 5624.0 |
| 2008-04-28 | CT | Futures | 79.93 | 81.89 | 79.84 | 80.06 | 16711.0 |
| 2008-04-28 | DC | Futures | 49.34 | 49.83 | 49.07 | 49.67 | 53.0 |
| 2008-04-28 | DX | Futures | 78.448 | 78.545 | 78.179 | 78.335 | 2472.0 |
| 2008-04-28 | E1 | Futures | 1.28792 | 1.29445 | 1.28499 | 1.28792 | 44800.0 |
| 2008-04-28 | E6 | Futures | 1.81389 | 1.82425 | 1.81237 | 1.81831 | 168962.0 |
| 2008-04-28 | E7 | Futures | 1.7974 | 1.8083 | 1.797 | 1.8027 | 2403.0 |
| 2008-04-28 | EBM | Futures | 179.37 | 183.08 | 179.37 | 179.81 | 684.0 |
| 2008-04-28 | ED | Futures | 91.3909 | 91.4803 | 91.3909 | 91.4615 | 170585.0 |
| 2008-04-28 | ER | Futures | 93.462 | 93.506 | 93.462 | 93.501 | 104265.0 |
| 2008-04-28 | EW | Futures | 833.1 | 839.2 | 829.4 | 835.2 | 14463.0 |
| 2008-04-28 | FCE | Futures | 3242.9 | 3266.5 | 3234.8 | 3253.4 | 78392.0 |
| 2008-04-28 | FDAX | Futures | 7913.1 | 7960.2 | 7892.1 | 7916.5 | 106170.0 |
| 2008-04-28 | FESX | Futures | 2200.8 | 2211.9 | 2193.2 | 2201.4 | 698697.0 |
| 2008-04-28 | FEU3 | Futures | 94.003 | 94.022 | 94.003 | 94.022 | 851.0 |
| 2008-04-28 | FGBL | Futures | 85.49 | 85.69 | 85.38 | 85.52 | 647370.0 |
| 2008-04-28 | FGBM | Futures | 91.86 | 92.1 | 91.81 | 91.81 | 383924.0 |
| 2008-04-28 | FGBS | Futures | 100.515 | 100.665 | 100.491 | 100.491 | 437868.0 |
| 2008-04-28 | FGBX | Futures | 74.9 | 74.97 | 74.54 | 74.75 | 1313.0 |
| 2008-04-28 | FTDX | Futures | 772.0 | 779.2 | 771.1 | 771.1 | 193.0 |
| 2008-04-28 | FTI | Futures | 354.43 | 357.57 | 353.48 | 356.05 | 21605.0 |
| 2008-04-28 | FTUK | Futures | 3971.7 | 3981.4 | 3947.8 | 3956.2 | 74351.0 |
| 2008-04-28 | G | Futures | 68.21 | 68.51 | 68.21 | 68.44 | 46169.0 |
| 2008-04-28 | GF | Futures | 298.4 | 298.4 | 295.693 | 296.318 | 350.0 |
| 2008-04-28 | GSCI | Futures | 1963.45 | 1974.24 | 1959.37 | 1966.34 | 136.0 |
| 2008-04-28 | HE | Futures | 149.517 | 150.308 | 148.331 | 149.814 | 140.0 |
| 2008-04-28 | HG | Futures | 5.4592 | 5.5038 | 5.4216 | 5.4773 | 10425.0 |
| 2008-04-28 | HO | Futures | 3.8232 | 3.8394 | 3.7823 | 3.8094 | 29217.0 |
| 2008-04-28 | J1 | Futures | 0.0122516 | 0.0122963 | 0.012207 | 0.0122759 | 78781.0 |
| 2008-04-28 | J7 | Futures | 0.011993 | 0.012034 | 0.011954 | 0.012018 | 74.0 |
| 2008-04-28 | JB | Futures | 112.55 | 113.02 | 112.18 | 112.52 | 1278.0 |
| 2008-04-28 | KC | Futures | 408.35 | 422.63 | 408.35 | 417.66 | 9255.0 |
| 2008-04-28 | KE | Futures | 4596.58 | 4693.46 | 4593.89 | 4692.12 | 7351.0 |
| 2008-04-28 | L | Futures | 93.527 | 93.616 | 93.527 | 93.596 | 50530.0 |
| 2008-04-28 | LE | Futures | 196.087 | 197.138 | 195.352 | 197.033 | 3208.0 |
| 2008-04-28 | MP | Futures | 0.04536 | 0.04543 | 0.04521 | 0.0453 | 7085.0 |
> showing 50 of 82 rows — these rows as CSV