PREVIEW / futures_daily / 2008-03-27
file: by_date/futures_daily/2008/2008-03-27.parquet size: 8 KB rows: 81
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-03-27 | ES | Futures | 1236.19 | 1248.22 | 1228.31 | 1231.32 | 2021529.0 |
| 2008-03-27 | NQ | Futures | 2020.76 | 2038.37 | 1992.82 | 2003.16 | 377784.0 |
| 2008-03-27 | YM | Futures | 10991.3 | 11084.5 | 10910.5 | 10940.6 | 183106.0 |
| 2008-03-27 | CL | Futures | 460.92 | 470.58 | 456.71 | 467.79 | 311980.0 |
| 2008-03-27 | GC | Futures | 1358.9 | 1359.9 | 1338.4 | 1351.0 | 85653.0 |
| 2008-03-27 | ZN | Futures | 86.651963 | 86.697509 | 86.048473 | 86.253432 | 956368.0 |
| 2008-03-27 | A6 | Futures | 0.69562 | 0.69928 | 0.69287 | 0.69562 | 40697.0 |
| 2008-03-27 | AD | Futures | 0.96353 | 0.96874 | 0.95861 | 0.96539 | 32870.0 |
| 2008-03-27 | B | Futures | 125.93 | 127.08 | 124.58 | 126.47 | 73000.0 |
| 2008-03-27 | B6 | Futures | 2.0389 | 2.0514 | 2.0339 | 2.035 | 89180.0 |
| 2008-03-27 | BFX | Futures | 4160.5 | 4205.5 | 4160.5 | 4192.6 | 119.0 |
| 2008-03-27 | BZ | Futures | 121.08 | 122.39 | 120.46 | 121.86 | 626.0 |
| 2008-03-27 | C | Futures | 1126.0 | 1149.0 | 1077.0 | 1149.0 | 5576.0 |
| 2008-03-27 | CC | Futures | 2209.0 | 2239.0 | 2099.0 | 2231.0 | 49.0 |
| 2008-03-27 | CT | Futures | 86.47 | 88.03 | 85.49 | 85.93 | 11026.0 |
| 2008-03-27 | DC | Futures | 47.32 | 47.91 | 47.24 | 47.8 | 132.0 |
| 2008-03-27 | DX | Futures | 77.367 | 77.722 | 77.206 | 77.518 | 7.0 |
| 2008-03-27 | E1 | Futures | 1.34694 | 1.34734 | 1.33362 | 1.33948 | 44729.0 |
| 2008-03-27 | E6 | Futures | 1.83788 | 1.83881 | 1.82472 | 1.83089 | 181038.0 |
| 2008-03-27 | E7 | Futures | 1.8222 | 1.8228 | 1.8092 | 1.8152 | 2501.0 |
| 2008-03-27 | EBM | Futures | 233.8 | 234.01 | 225.09 | 226.61 | 2847.0 |
| 2008-03-27 | ED | Futures | 91.9602 | 91.9837 | 91.9132 | 91.9461 | 191549.0 |
| 2008-03-27 | ER | Futures | 93.801 | 93.85 | 93.776 | 93.83 | 166037.0 |
| 2008-03-27 | EW | Futures | 775.6 | 783.4 | 769.4 | 769.8 | 26863.0 |
| 2008-03-27 | FCE | Futures | 2997.9 | 3056.6 | 2996.6 | 3035.4 | 149173.0 |
| 2008-03-27 | FDAX | Futures | 7421.2 | 7583.5 | 7417.8 | 7547.8 | 159468.0 |
| 2008-03-27 | FESX | Futures | 2061.3 | 2108.2 | 2060.7 | 2094.1 | 1224597.0 |
| 2008-03-27 | FEU3 | Futures | 94.309 | 94.368 | 94.304 | 94.353 | 3587.0 |
| 2008-03-27 | FGBL | Futures | 87.41 | 87.43 | 87.07 | 87.07 | 1088806.0 |
| 2008-03-27 | FGBM | Futures | 93.3 | 93.51 | 93.25 | 93.38 | 606682.0 |
| 2008-03-27 | FGBS | Futures | 101.271 | 101.422 | 101.242 | 101.344 | 599067.0 |
| 2008-03-27 | FGBX | Futures | 76.63 | 77.13 | 76.1 | 76.1 | 3384.0 |
| 2008-03-27 | FTDX | Futures | 668.1 | 700.6 | 668.1 | 698.8 | 859.0 |
| 2008-03-27 | FTI | Futures | 325.86 | 332.1 | 325.68 | 329.41 | 35544.0 |
| 2008-03-27 | FTUK | Futures | 3674.5 | 3729.5 | 3670.9 | 3718.5 | 111380.0 |
| 2008-03-27 | G | Futures | 70.04 | 70.09 | 69.83 | 69.86 | 96033.0 |
| 2008-03-27 | GF | Futures | 292.489 | 292.489 | 287.769 | 288.27 | 22.0 |
| 2008-03-27 | GSCI | Futures | 1811.14 | 1848.34 | 1811.14 | 1840.79 | 174.0 |
| 2008-03-27 | HE | Futures | 133.3 | 135.772 | 132.509 | 135.772 | 66.0 |
| 2008-03-27 | HG | Futures | 5.2172 | 5.432 | 5.19 | 5.4027 | 13267.0 |
| 2008-03-27 | HO | Futures | 3.3771 | 3.4657 | 3.3652 | 3.4524 | 20085.0 |
| 2008-03-27 | J1 | Futures | 0.0129407 | 0.0129994 | 0.0127927 | 0.0128322 | 105939.0 |
| 2008-03-27 | J7 | Futures | 0.01269 | 0.012722 | 0.012522 | 0.012562 | 71.0 |
| 2008-03-27 | JB | Futures | 116.96 | 117.3 | 116.96 | 117.08 | 2376.0 |
| 2008-03-27 | KC | Futures | 418.62 | 421.3 | 409.15 | 418.3 | 253.0 |
| 2008-03-27 | KE | Futures | 5737.92 | 5830.55 | 5568.76 | 5665.42 | 5006.0 |
| 2008-03-27 | L | Futures | 93.671 | 93.696 | 93.656 | 93.681 | 63042.0 |
| 2008-03-27 | LE | Futures | 188.994 | 189.257 | 185.369 | 186.209 | 4006.0 |
| 2008-03-27 | MP | Futures | 0.04413 | 0.04421 | 0.0441 | 0.04418 | 9787.0 |
| 2008-03-27 | N6 | Futures | 0.60321 | 0.60427 | 0.59971 | 0.60222 | 1815.0 |
> showing 50 of 81 rows — these rows as CSV