PREVIEW / futures_daily / 2009-03-02
file: by_date/futures_daily/2009/2009-03-02.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-03-02 | ES | Futures | 690.51 | 692.87 | 659.82 | 666.2 | 2886199.0 |
| 2009-03-02 | NQ | Futures | 1245.72 | 1247.67 | 1201.0 | 1214.13 | 398697.0 |
| 2009-03-02 | YM | Futures | 6271.0 | 6277.3 | 6001.2 | 6045.8 | 251088.0 |
| 2009-03-02 | CL | Futures | 124.83 | 125.25 | 112.16 | 113.03 | 245234.0 |
| 2009-03-02 | GC | Futures | 1304.9 | 1331.5 | 1278.1 | 1304.5 | 124350.0 |
| 2009-03-02 | ZN | Futures | 93.268028 | 94.403548 | 93.268028 | 94.11668 | 99794.0 |
| 2009-03-02 | A6 | Futures | 0.50528 | 0.506 | 0.49815 | 0.49965 | 33379.0 |
| 2009-03-02 | AD | Futures | 0.76941 | 0.77196 | 0.75968 | 0.76332 | 40794.0 |
| 2009-03-02 | B | Futures | 45.42 | 45.51 | 41.9 | 42.25 | 81185.0 |
| 2009-03-02 | B6 | Futures | 1.4824 | 1.4846 | 1.4502 | 1.4584 | 77031.0 |
| 2009-03-02 | BFX | Futures | 1812.2 | 1823.8 | 1773.4 | 1777.9 | 132.0 |
| 2009-03-02 | BZ | Futures | 45.3 | 45.55 | 43.9 | 44.07 | 13.0 |
| 2009-03-02 | C | Futures | 1825.0 | 1825.0 | 1756.0 | 1757.0 | 6261.0 |
| 2009-03-02 | CB | Futures | 76.436 | 76.436 | 76.436 | 76.436 | 3.0 |
| 2009-03-02 | CC | Futures | 2081.0 | 2092.0 | 1934.0 | 1947.0 | 12674.0 |
| 2009-03-02 | CT | Futures | 40.75 | 40.75 | 38.78 | 39.14 | 6327.0 |
| 2009-03-02 | DC | Futures | 27.12 | 27.14 | 27.02 | 27.14 | 136.0 |
| 2009-03-02 | DX | Futures | 91.665 | 92.489 | 91.665 | 92.359 | 4516.0 |
| 2009-03-02 | E1 | Futures | 1.13497 | 1.13616 | 1.12673 | 1.12912 | 25600.0 |
| 2009-03-02 | E6 | Futures | 1.49349 | 1.49539 | 1.48497 | 1.48816 | 148934.0 |
| 2009-03-02 | E7 | Futures | 1.4766 | 1.4782 | 1.4682 | 1.4711 | 1585.0 |
| 2009-03-02 | EBM | Futures | 210.91 | 210.91 | 207.08 | 207.08 | 1905.0 |
| 2009-03-02 | ED | Futures | 92.98 | 92.9965 | 92.9494 | 92.9824 | 154576.0 |
| 2009-03-02 | ER | Futures | 96.444 | 96.464 | 96.429 | 96.454 | 66506.0 |
| 2009-03-02 | EW | Futures | 436.2 | 436.2 | 410.6 | 415.1 | 41100.0 |
| 2009-03-02 | FCE | Futures | 1651.1 | 1655.2 | 1591.6 | 1610.6 | 148861.0 |
| 2009-03-02 | FDAX | Futures | 4120.0 | 4134.1 | 4002.6 | 4038.6 | 179639.0 |
| 2009-03-02 | FESX | Futures | 1112.9 | 1115.7 | 1064.6 | 1080.1 | 1659130.0 |
| 2009-03-02 | FEU3 | Futures | 97.012 | 97.027 | 97.012 | 97.022 | 307.0 |
| 2009-03-02 | FGBL | Futures | 93.39 | 93.8 | 93.36 | 93.64 | 704001.0 |
| 2009-03-02 | FGBM | Futures | 98.14 | 98.55 | 98.08 | 98.48 | 417187.0 |
| 2009-03-02 | FGBS | Futures | 103.901 | 104.069 | 103.877 | 104.016 | 477175.0 |
| 2009-03-02 | FGBX | Futures | 85.4 | 85.7 | 85.21 | 85.33 | 5886.0 |
| 2009-03-02 | FTDX | Futures | 393.8 | 393.8 | 375.0 | 380.3 | 295.0 |
| 2009-03-02 | FTI | Futures | 176.59 | 176.59 | 168.69 | 170.11 | 42630.0 |
| 2009-03-02 | FTUK | Futures | 2435.8 | 2446.3 | 2337.4 | 2369.2 | 179711.0 |
| 2009-03-02 | G | Futures | 75.78 | 76.19 | 75.66 | 76.01 | 63204.0 |
| 2009-03-02 | GF | Futures | 259.504 | 259.504 | 254.104 | 256.558 | 202.0 |
| 2009-03-02 | GSCI | Futures | 715.29 | 716.39 | 685.98 | 686.86 | 213.0 |
| 2009-03-02 | HE | Futures | 117.774 | 117.87 | 115.647 | 116.517 | 5152.0 |
| 2009-03-02 | HG | Futures | 2.183 | 2.183 | 2.1217 | 2.1358 | 9727.0 |
| 2009-03-02 | HO | Futures | 1.4055 | 1.4055 | 1.2819 | 1.286 | 5550.0 |
| 2009-03-02 | HRC | Futures | 2953.0 | 2953.0 | 2953.0 | 2953.0 | 0.0 |
| 2009-03-02 | J1 | Futures | 0.0129319 | 0.0130355 | 0.0129041 | 0.0129243 | 82118.0 |
| 2009-03-02 | J7 | Futures | 0.012765 | 0.012865 | 0.012751 | 0.012769 | 202.0 |
| 2009-03-02 | JB | Futures | 116.94 | 117.07 | 116.36 | 116.52 | 1339.0 |
| 2009-03-02 | KC | Futures | 313.22 | 314.35 | 296.77 | 297.33 | 15842.0 |
| 2009-03-02 | KE | Futures | 2749.73 | 2790.4 | 2679.47 | 2696.73 | 5798.0 |
| 2009-03-02 | L | Futures | 96.551 | 96.59 | 96.531 | 96.571 | 37705.0 |
| 2009-03-02 | LBS | Futures | 821.8 | 841.4 | 788.7 | 838.6 | 101.0 |
> showing 50 of 86 rows — these rows as CSV