PREVIEW / futures_daily / 2008-06-20
file: by_date/futures_daily/2008/2008-06-20.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-06-20 | ES | Futures | 1241.76 | 1242.68 | 1216.55 | 1220.02 | 2322976.0 |
| 2008-06-20 | NQ | Futures | 2216.57 | 2218.24 | 2144.26 | 2159.83 | 541065.0 |
| 2008-06-20 | YM | Futures | 10696.4 | 10705.3 | 10493.9 | 10518.8 | 199160.0 |
| 2008-06-20 | CL | Futures | 575.81 | 597.95 | 572.94 | 588.64 | 278598.0 |
| 2008-06-20 | GC | Futures | 1275.1 | 1288.8 | 1271.4 | 1279.8 | 90239.0 |
| 2008-06-20 | ZN | Futures | 82.444306 | 82.962099 | 82.386773 | 82.835528 | 857210.0 |
| 2008-06-20 | A6 | Futures | 0.72581 | 0.73098 | 0.72496 | 0.72882 | 35779.0 |
| 2008-06-20 | AD | Futures | 0.96628 | 0.97187 | 0.96215 | 0.96225 | 38723.0 |
| 2008-06-20 | B | Futures | 159.16 | 164.94 | 158.53 | 162.61 | 90300.0 |
| 2008-06-20 | B6 | Futures | 2.0175 | 2.0244 | 2.015 | 2.022 | 59379.0 |
| 2008-06-20 | BFX | Futures | 3905.1 | 3923.2 | 3799.7 | 3837.4 | 3000.0 |
| 2008-06-20 | BZ | Futures | 157.56 | 161.95 | 157.52 | 159.82 | 998.0 |
| 2008-06-20 | C | Futures | 1427.0 | 1454.0 | 1417.0 | 1450.0 | 2020.0 |
| 2008-06-20 | CB | Futures | 93.722 | 93.722 | 93.722 | 93.722 | 4.0 |
| 2008-06-20 | CC | Futures | 2757.0 | 2805.0 | 2745.0 | 2803.0 | 4305.0 |
| 2008-06-20 | CT | Futures | 79.12 | 81.5 | 78.26 | 80.12 | 4323.0 |
| 2008-06-20 | DC | Futures | 55.26 | 55.26 | 54.73 | 54.78 | 196.0 |
| 2008-06-20 | DX | Futures | 78.125 | 78.136 | 77.569 | 77.665 | 5755.0 |
| 2008-06-20 | E1 | Futures | 1.27685 | 1.29445 | 1.27579 | 1.28951 | 84288.0 |
| 2008-06-20 | E6 | Futures | 1.80717 | 1.82462 | 1.80577 | 1.82134 | 208215.0 |
| 2008-06-20 | E7 | Futures | 1.7893 | 1.8068 | 1.7885 | 1.8037 | 2080.0 |
| 2008-06-20 | ED | Futures | 91.4189 | 91.4755 | 91.4047 | 91.4614 | 191256.0 |
| 2008-06-20 | ER | Futures | 93.428 | 93.477 | 93.428 | 93.467 | 99990.0 |
| 2008-06-20 | EW | Futures | 861.3 | 862.2 | 845.1 | 847.5 | 30068.0 |
| 2008-06-20 | FCE | Futures | 3040.7 | 3046.6 | 2950.9 | 2974.6 | 169246.0 |
| 2008-06-20 | FDAX | Futures | 7629.5 | 7659.7 | 7404.9 | 7451.4 | 211018.0 |
| 2008-06-20 | FESX | Futures | 2068.3 | 2073.6 | 2006.1 | 2026.6 | 1862686.0 |
| 2008-06-20 | FEU3 | Futures | 94.008 | 94.018 | 93.998 | 94.013 | 1624.0 |
| 2008-06-20 | FGBL | Futures | 82.74 | 83.1 | 82.67 | 82.98 | 675014.0 |
| 2008-06-20 | FGBM | Futures | 88.96 | 89.3 | 88.9 | 89.2 | 391984.0 |
| 2008-06-20 | FGBS | Futures | 98.849 | 99.018 | 98.829 | 98.984 | 423441.0 |
| 2008-06-20 | FGBX | Futures | 74.72 | 75.66 | 74.72 | 75.4 | 1652.0 |
| 2008-06-20 | FTDX | Futures | 755.7 | 757.5 | 734.0 | 743.9 | 1303.0 |
| 2008-06-20 | FTI | Futures | 338.09 | 340.28 | 328.63 | 330.48 | 38171.0 |
| 2008-06-20 | FTUK | Futures | 3717.5 | 3730.1 | 3641.1 | 3672.5 | 130667.0 |
| 2008-06-20 | G | Futures | 65.91 | 66.37 | 65.88 | 66.21 | 55903.0 |
| 2008-06-20 | GF | Futures | 301.036 | 309.443 | 301.036 | 308.02 | 259.0 |
| 2008-06-20 | GSCI | Futures | 2195.46 | 2219.67 | 2183.61 | 2190.77 | 117.0 |
| 2008-06-20 | HE | Futures | 147.772 | 151.95 | 147.379 | 151.754 | 1770.0 |
| 2008-06-20 | HG | Futures | 5.2542 | 5.3518 | 5.2445 | 5.3386 | 6472.0 |
| 2008-06-20 | HO | Futures | 4.3944 | 4.5471 | 4.3944 | 4.4605 | 4997.0 |
| 2008-06-20 | J1 | Futures | 0.011835 | 0.0119291 | 0.0118248 | 0.0119278 | 134237.0 |
| 2008-06-20 | J7 | Futures | 0.011651 | 0.011728 | 0.011629 | 0.011723 | 76.0 |
| 2008-06-20 | JB | Futures | 111.25 | 111.73 | 111.12 | 111.63 | 1195.0 |
| 2008-06-20 | KC | Futures | 424.79 | 450.58 | 423.43 | 445.12 | 21324.0 |
| 2008-06-20 | KE | Futures | 5000.26 | 5059.47 | 4907.41 | 4924.91 | 10739.0 |
| 2008-06-20 | L | Futures | 92.912 | 93.006 | 92.907 | 92.976 | 49948.0 |
| 2008-06-20 | LE | Futures | 205.832 | 211.103 | 205.832 | 208.517 | 6802.0 |
| 2008-06-20 | MP | Futures | 0.04623 | 0.04643 | 0.04618 | 0.04634 | 19080.0 |
| 2008-06-20 | N6 | Futures | 0.57879 | 0.58149 | 0.57825 | 0.57918 | 635.0 |
> showing 50 of 81 rows — these rows as CSV