PREVIEW / futures_daily / 2009-04-28
file: by_date/futures_daily/2009/2009-04-28.parquet size: 8 KB rows: 85
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-04-28 | ES | Futures | 814.89 | 821.09 | 799.17 | 811.8 | 2224466.0 |
| 2009-04-28 | NQ | Futures | 1540.89 | 1547.64 | 1517.86 | 1528.54 | 263519.0 |
| 2009-04-28 | YM | Futures | 7166.0 | 7214.5 | 7051.2 | 7146.3 | 162740.0 |
| 2009-04-28 | CL | Futures | 134.94 | 135.18 | 130.76 | 134.45 | 186823.0 |
| 2009-04-28 | GC | Futures | 1256.1 | 1256.8 | 1224.8 | 1237.3 | 81046.0 |
| 2009-04-28 | ZN | Futures | 94.98558 | 95.313283 | 94.402995 | 94.512229 | 686531.0 |
| 2009-04-28 | A6 | Futures | 0.56352 | 0.56464 | 0.55523 | 0.56241 | 41487.0 |
| 2009-04-28 | AD | Futures | 0.80783 | 0.80951 | 0.80271 | 0.80793 | 41177.0 |
| 2009-04-28 | B | Futures | 49.24 | 49.43 | 48.09 | 49.12 | 39021.0 |
| 2009-04-28 | B6 | Futures | 1.5221 | 1.5288 | 1.5104 | 1.5212 | 66613.0 |
| 2009-04-28 | BFX | Futures | 2074.8 | 2107.8 | 2051.1 | 2089.1 | 294.0 |
| 2009-04-28 | C | Futures | 1839.0 | 1857.0 | 1835.0 | 1849.0 | 2731.0 |
| 2009-04-28 | CB | Futures | 76.436 | 76.586 | 76.436 | 76.436 | 8.0 |
| 2009-04-28 | CC | Futures | 2095.0 | 2131.0 | 2088.0 | 2121.0 | 4311.0 |
| 2009-04-28 | CT | Futures | 48.94 | 49.27 | 48.18 | 48.8 | 10396.0 |
| 2009-04-28 | DC | Futures | 26.35 | 26.35 | 25.9 | 25.92 | 329.0 |
| 2009-04-28 | DX | Futures | 88.456 | 88.796 | 87.766 | 87.864 | 4082.0 |
| 2009-04-28 | E1 | Futures | 1.14746 | 1.16205 | 1.14401 | 1.16019 | 26533.0 |
| 2009-04-28 | E6 | Futures | 1.54328 | 1.56071 | 1.53652 | 1.55846 | 153277.0 |
| 2009-04-28 | E7 | Futures | 1.5256 | 1.5424 | 1.5189 | 1.5404 | 2264.0 |
| 2009-04-28 | EBM | Futures | 215.18 | 217.5 | 214.4 | 215.56 | 1988.0 |
| 2009-04-28 | ED | Futures | 93.3414 | 93.3462 | 93.3084 | 93.3226 | 193518.0 |
| 2009-04-28 | ER | Futures | 96.689 | 96.704 | 96.674 | 96.689 | 95714.0 |
| 2009-04-28 | EW | Futures | 525.8 | 534.4 | 515.9 | 526.3 | 43035.0 |
| 2009-04-28 | FCE | Futures | 1919.9 | 1934.2 | 1888.8 | 1911.7 | 131492.0 |
| 2009-04-28 | FDAX | Futures | 5055.7 | 5069.8 | 4961.4 | 5036.0 | 173321.0 |
| 2009-04-28 | FESX | Futures | 1333.9 | 1345.9 | 1312.9 | 1332.7 | 1258286.0 |
| 2009-04-28 | FEU3 | Futures | 97.264 | 97.273 | 97.264 | 97.273 | 1110.0 |
| 2009-04-28 | FGBL | Futures | 92.97 | 93.08 | 92.56 | 92.8 | 584385.0 |
| 2009-04-28 | FGBM | Futures | 97.95 | 98.04 | 97.84 | 97.95 | 397156.0 |
| 2009-04-28 | FGBS | Futures | 103.791 | 103.853 | 103.747 | 103.786 | 381277.0 |
| 2009-04-28 | FGBX | Futures | 84.28 | 84.28 | 83.75 | 83.97 | 835.0 |
| 2009-04-28 | FTDX | Futures | 499.1 | 503.6 | 485.6 | 492.8 | 807.0 |
| 2009-04-28 | FTI | Futures | 193.46 | 193.7 | 189.18 | 192.3 | 35028.0 |
| 2009-04-28 | FTUK | Futures | 2700.7 | 2719.3 | 2671.4 | 2696.7 | 112676.0 |
| 2009-04-28 | G | Futures | 76.84 | 76.97 | 76.64 | 76.81 | 80061.0 |
| 2009-04-28 | GF | Futures | 275.467 | 276.235 | 272.814 | 273.094 | 634.0 |
| 2009-04-28 | GSCI | Futures | 750.87 | 760.44 | 749.38 | 758.42 | 505.0 |
| 2009-04-28 | HE | Futures | 108.301 | 108.92 | 103.969 | 104.464 | 1573.0 |
| 2009-04-28 | HG | Futures | 2.7843 | 2.8124 | 2.6738 | 2.6964 | 15745.0 |
| 2009-04-28 | HO | Futures | 1.462 | 1.4701 | 1.4292 | 1.4543 | 26506.0 |
| 2009-04-28 | HRC | Futures | 2595.1 | 2595.1 | 2595.1 | 2595.1 | 0.0 |
| 2009-04-28 | J1 | Futures | 0.01304 | 0.0131874 | 0.0130362 | 0.013079 | 78392.0 |
| 2009-04-28 | J7 | Futures | 0.012904 | 0.01301 | 0.012862 | 0.012901 | 41.0 |
| 2009-04-28 | JB | Futures | 114.49 | 115.06 | 114.45 | 115.0 | 2349.0 |
| 2009-04-28 | KC | Futures | 319.76 | 323.22 | 316.15 | 322.11 | 5388.0 |
| 2009-04-28 | KE | Futures | 2786.5 | 2826.72 | 2786.5 | 2788.94 | 7099.0 |
| 2009-04-28 | L | Futures | 96.974 | 96.983 | 96.925 | 96.934 | 43173.0 |
| 2009-04-28 | LBS | Futures | 864.4 | 865.9 | 838.5 | 841.1 | 237.0 |
| 2009-04-28 | LE | Futures | 144.769 | 145.962 | 144.504 | 144.858 | 8121.0 |
> showing 50 of 85 rows — these rows as CSV