PREVIEW / futures_daily / 2009-09-24
file: by_date/futures_daily/2009/2009-09-24.parquet size: 9 KB rows: 88
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-09-24 | ES | Futures | 1020.96 | 1026.26 | 1004.08 | 1007.21 | 2315316.0 |
| 2009-09-24 | NQ | Futures | 1946.4 | 1960.52 | 1914.51 | 1918.47 | 351064.0 |
| 2009-09-24 | YM | Futures | 8818.1 | 8858.1 | 8715.5 | 8747.3 | 172622.0 |
| 2009-09-24 | CL | Futures | 169.22 | 170.31 | 162.46 | 163.17 | 357456.0 |
| 2009-09-24 | GC | Futures | 1394.5 | 1411.5 | 1370.4 | 1380.9 | 182497.0 |
| 2009-09-24 | ZN | Futures | 93.56691 | 94.0028 | 93.467278 | 93.81599 | 848695.0 |
| 2009-09-24 | A6 | Futures | 0.69653 | 0.70429 | 0.69217 | 0.69467 | 91411.0 |
| 2009-09-24 | AD | Futures | 0.9158 | 0.92093 | 0.90062 | 0.90456 | 101726.0 |
| 2009-09-24 | B | Futures | 63.78 | 64.18 | 60.97 | 61.19 | 187852.0 |
| 2009-09-24 | B6 | Futures | 1.6991 | 1.7049 | 1.667 | 1.671 | 176482.0 |
| 2009-09-24 | BFX | Futures | 2819.6 | 2841.4 | 2801.8 | 2801.8 | 30.0 |
| 2009-09-24 | BR | Futures | 0.21725 | 0.21725 | 0.21725 | 0.21725 | 122.0 |
| 2009-09-24 | BZ | Futures | 66.29 | 66.29 | 63.69 | 63.69 | 14.0 |
| 2009-09-24 | C | Futures | 2093.0 | 2120.0 | 2084.0 | 2094.0 | 6319.0 |
| 2009-09-24 | CB | Futures | 70.466 | 70.466 | 70.466 | 70.466 | 2.0 |
| 2009-09-24 | CC | Futures | 2752.0 | 2752.0 | 2681.0 | 2690.0 | 7146.0 |
| 2009-09-24 | CT | Futures | 55.66 | 55.99 | 54.65 | 55.93 | 6511.0 |
| 2009-09-24 | DC | Futures | 24.27 | 24.34 | 23.81 | 23.84 | 122.0 |
| 2009-09-24 | DX | Futures | 78.2 | 78.874 | 77.878 | 78.731 | 10539.0 |
| 2009-09-24 | E1 | Futures | 1.28286 | 1.29475 | 1.28008 | 1.28299 | 46827.0 |
| 2009-09-24 | E6 | Futures | 1.74204 | 1.75425 | 1.73351 | 1.73659 | 283645.0 |
| 2009-09-24 | E7 | Futures | 1.7255 | 1.7374 | 1.7169 | 1.7199 | 3256.0 |
| 2009-09-24 | ED | Futures | 94.1529 | 94.1765 | 94.1481 | 94.1576 | 184531.0 |
| 2009-09-24 | ER | Futures | 97.208 | 97.223 | 97.198 | 97.203 | 136392.0 |
| 2009-09-24 | EW | Futures | 671.8 | 675.0 | 656.0 | 658.7 | 48387.0 |
| 2009-09-24 | FCE | Futures | 2513.4 | 2542.5 | 2469.6 | 2480.4 | 169131.0 |
| 2009-09-24 | FDAX | Futures | 6178.7 | 6249.5 | 6077.0 | 6107.5 | 218756.0 |
| 2009-09-24 | FESX | Futures | 1710.1 | 1729.2 | 1678.4 | 1689.2 | 1615007.0 |
| 2009-09-24 | FEU3 | Futures | 97.781 | 97.791 | 97.776 | 97.776 | 337.0 |
| 2009-09-24 | FGBL | Futures | 93.09 | 93.41 | 92.98 | 93.34 | 873704.0 |
| 2009-09-24 | FGBM | Futures | 98.86 | 99.06 | 98.8 | 99.01 | 485686.0 |
| 2009-09-24 | FGBS | Futures | 104.721 | 104.832 | 104.716 | 104.813 | 485527.0 |
| 2009-09-24 | FGBX | Futures | 86.05 | 86.28 | 85.66 | 86.21 | 2374.0 |
| 2009-09-24 | FTDX | Futures | 672.3 | 673.2 | 660.7 | 663.8 | 409.0 |
| 2009-09-24 | FTI | Futures | 256.79 | 259.26 | 253.09 | 254.08 | 39386.0 |
| 2009-09-24 | FTUK | Futures | 3377.4 | 3408.6 | 3340.3 | 3353.5 | 145556.0 |
| 2009-09-24 | G | Futures | 76.13 | 76.33 | 75.96 | 76.28 | 179906.0 |
| 2009-09-24 | GF | Futures | 269.012 | 269.425 | 266.672 | 267.429 | 1178.0 |
| 2009-09-24 | GSCI | Futures | 905.55 | 906.55 | 878.53 | 878.53 | 647.0 |
| 2009-09-24 | HE | Futures | 75.458 | 76.22 | 75.077 | 75.229 | 6106.0 |
| 2009-09-24 | HG | Futures | 3.8461 | 3.9047 | 3.743 | 3.7757 | 26184.0 |
| 2009-09-24 | HO | Futures | 1.7554 | 1.7595 | 1.6805 | 1.6885 | 14764.0 |
| 2009-09-24 | HRC | Futures | 2738.7 | 2738.7 | 2738.7 | 2738.7 | 0.0 |
| 2009-09-24 | J1 | Futures | 0.0137358 | 0.0139053 | 0.0137107 | 0.0137609 | 118866.0 |
| 2009-09-24 | J7 | Futures | 0.01354 | 0.013719 | 0.013539 | 0.013581 | 93.0 |
| 2009-09-24 | JB | Futures | 117.0 | 117.22 | 116.88 | 117.2 | 2199.0 |
| 2009-09-24 | KC | Futures | 357.68 | 358.34 | 339.2 | 341.31 | 15872.0 |
| 2009-09-24 | KE | Futures | 2181.11 | 2262.54 | 2164.83 | 2250.91 | 12028.0 |
| 2009-09-24 | L | Futures | 97.878 | 97.897 | 97.838 | 97.858 | 93735.0 |
| 2009-09-24 | LBS | Futures | 714.1 | 718.9 | 703.9 | 708.8 | 266.0 |
> showing 50 of 88 rows — these rows as CSV