PREVIEW / futures_daily / 2009-05-26
file: by_date/futures_daily/2009/2009-05-26.parquet size: 8 KB rows: 86
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-26 | ES | Futures | 843.49 | 868.27 | 835.62 | 866.12 | 2586181.0 |
| 2009-05-26 | NQ | Futures | 1527.69 | 1589.21 | 1508.59 | 1584.99 | 374372.0 |
| 2009-05-26 | YM | Futures | 7417.2 | 7610.9 | 7349.9 | 7589.4 | 178786.0 |
| 2009-05-26 | CL | Futures | 163.73 | 166.49 | 158.48 | 166.25 | 267127.0 |
| 2009-05-26 | GC | Futures | 1327.7 | 1331.6 | 1298.9 | 1322.3 | 87472.0 |
| 2009-05-26 | ZN | Futures | 92.558143 | 92.885847 | 91.890598 | 92.230439 | 990408.0 |
| 2009-05-26 | A6 | Futures | 0.62342 | 0.6282 | 0.61337 | 0.62469 | 53594.0 |
| 2009-05-26 | AD | Futures | 0.87823 | 0.88266 | 0.86701 | 0.88079 | 68442.0 |
| 2009-05-26 | B | Futures | 58.56 | 59.37 | 56.66 | 59.32 | 42482.0 |
| 2009-05-26 | B6 | Futures | 1.6567 | 1.6615 | 1.6415 | 1.657 | 84693.0 |
| 2009-05-26 | BFX | Futures | 2335.1 | 2354.0 | 2306.2 | 2344.5 | 100.0 |
| 2009-05-26 | BR | Futures | 0.18818 | 0.18994 | 0.18818 | 0.18896 | 7.0 |
| 2009-05-26 | BZ | Futures | 64.54 | 64.73 | 64.54 | 64.73 | 2.0 |
| 2009-05-26 | C | Futures | 1734.0 | 1741.0 | 1719.0 | 1737.0 | 2016.0 |
| 2009-05-26 | CB | Futures | 76.865 | 76.95 | 76.737 | 76.95 | 9.0 |
| 2009-05-26 | CC | Futures | 2130.0 | 2136.0 | 2100.0 | 2130.0 | 5151.0 |
| 2009-05-26 | CT | Futures | 52.84 | 52.97 | 50.43 | 50.94 | 5788.0 |
| 2009-05-26 | DC | Futures | 24.24 | 24.26 | 24.08 | 24.23 | 71.0 |
| 2009-05-26 | DX | Futures | 82.556 | 83.23 | 82.484 | 82.592 | 7242.0 |
| 2009-05-26 | E1 | Futures | 1.22304 | 1.22635 | 1.21376 | 1.2233 | 35256.0 |
| 2009-05-26 | E6 | Futures | 1.66242 | 1.66373 | 1.64274 | 1.65756 | 216548.0 |
| 2009-05-26 | E7 | Futures | 1.6424 | 1.6444 | 1.6237 | 1.6383 | 2825.0 |
| 2009-05-26 | ED | Futures | 93.6101 | 93.6478 | 93.5535 | 93.5795 | 248561.0 |
| 2009-05-26 | ER | Futures | 96.723 | 96.767 | 96.723 | 96.748 | 138870.0 |
| 2009-05-26 | EW | Futures | 530.9 | 553.3 | 523.4 | 551.2 | 31019.0 |
| 2009-05-26 | FCE | Futures | 2085.8 | 2128.1 | 2048.0 | 2115.1 | 133840.0 |
| 2009-05-26 | FDAX | Futures | 5325.8 | 5460.8 | 5232.1 | 5439.0 | 186684.0 |
| 2009-05-26 | FESX | Futures | 1453.3 | 1489.3 | 1429.3 | 1480.3 | 1218598.0 |
| 2009-05-26 | FEU3 | Futures | 97.313 | 97.342 | 97.313 | 97.328 | 968.0 |
| 2009-05-26 | FGBL | Futures | 90.3 | 90.6 | 89.97 | 90.29 | 678897.0 |
| 2009-05-26 | FGBM | Futures | 96.89 | 97.1 | 96.72 | 96.89 | 419669.0 |
| 2009-05-26 | FGBS | Futures | 103.651 | 103.762 | 103.623 | 103.685 | 448213.0 |
| 2009-05-26 | FGBX | Futures | 79.37 | 79.83 | 78.31 | 79.37 | 1854.0 |
| 2009-05-26 | FTDX | Futures | 565.7 | 575.6 | 548.6 | 570.2 | 997.0 |
| 2009-05-26 | FTI | Futures | 214.04 | 217.5 | 210.09 | 217.17 | 36928.0 |
| 2009-05-26 | FTUK | Futures | 2882.8 | 2942.7 | 2845.9 | 2928.4 | 109278.0 |
| 2009-05-26 | G | Futures | 75.26 | 75.8 | 75.26 | 75.7 | 157005.0 |
| 2009-05-26 | GF | Futures | 281.556 | 283.348 | 280.729 | 282.728 | 1032.0 |
| 2009-05-26 | GSCI | Futures | 881.9 | 904.72 | 874.43 | 904.51 | 291.0 |
| 2009-05-26 | HE | Futures | 99.103 | 99.478 | 97.98 | 98.204 | 4157.0 |
| 2009-05-26 | HG | Futures | 2.9482 | 3.0214 | 2.8701 | 3.0122 | 17764.0 |
| 2009-05-26 | HO | Futures | 1.5963 | 1.6689 | 1.5963 | 1.6689 | 8580.0 |
| 2009-05-26 | HRC | Futures | 2495.0 | 2495.0 | 2495.0 | 2495.0 | 0.0 |
| 2009-05-26 | J1 | Futures | 0.0133097 | 0.0133487 | 0.0132391 | 0.0132706 | 76167.0 |
| 2009-05-26 | J7 | Futures | 0.01312 | 0.013148 | 0.013059 | 0.01309 | 42.0 |
| 2009-05-26 | JB | Futures | 114.41 | 114.69 | 114.39 | 114.69 | 3480.0 |
| 2009-05-26 | KC | Futures | 372.4 | 380.02 | 364.64 | 378.08 | 9027.0 |
| 2009-05-26 | KE | Futures | 3210.69 | 3255.79 | 3183.87 | 3228.98 | 6274.0 |
| 2009-05-26 | L | Futures | 97.131 | 97.19 | 97.101 | 97.121 | 48236.0 |
| 2009-05-26 | LBS | Futures | 799.5 | 812.3 | 792.7 | 799.5 | 150.0 |
> showing 50 of 86 rows — these rows as CSV