PREVIEW / futures_daily / 2009-12-15
file: by_date/futures_daily/2009/2009-12-15.parquet size: 9 KB rows: 89
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-12-15 | ES | Futures | 1074.28 | 1076.94 | 1066.52 | 1070.16 | 1804825.0 |
| 2009-12-15 | NQ | Futures | 2044.37 | 2049.46 | 2026.27 | 2030.23 | 282377.0 |
| 2009-12-15 | YM | Futures | 9530.8 | 9547.2 | 9467.8 | 9497.9 | 103253.0 |
| 2009-12-15 | CL | Futures | 170.49 | 173.62 | 170.01 | 172.38 | 169614.0 |
| 2009-12-15 | GC | Futures | 1552.9 | 1555.3 | 1530.6 | 1545.7 | 154049.0 |
| 2009-12-15 | ZN | Futures | 94.718557 | 94.844496 | 94.302959 | 94.416304 | 747542.0 |
| 2009-12-15 | A6 | Futures | 0.73729 | 0.73786 | 0.72721 | 0.72973 | 65459.0 |
| 2009-12-15 | AD | Futures | 0.93197 | 0.93552 | 0.92664 | 0.93009 | 64208.0 |
| 2009-12-15 | B | Futures | 66.98 | 67.63 | 66.49 | 66.94 | 137965.0 |
| 2009-12-15 | B6 | Futures | 1.6927 | 1.6941 | 1.6822 | 1.6875 | 88457.0 |
| 2009-12-15 | BFX | Futures | 2847.4 | 2847.4 | 2817.3 | 2838.2 | 2044.0 |
| 2009-12-15 | BR | Futures | 0.22694 | 0.22694 | 0.22694 | 0.22694 | 6.0 |
| 2009-12-15 | BZ | Futures | 72.07 | 72.07 | 72.07 | 72.07 | 4.0 |
| 2009-12-15 | C | Futures | 2299.0 | 2306.0 | 2279.0 | 2290.0 | 7848.0 |
| 2009-12-15 | CB | Futures | 73.777 | 73.777 | 72.544 | 73.407 | 8.0 |
| 2009-12-15 | CC | Futures | 2918.0 | 2928.0 | 2882.0 | 2891.0 | 7189.0 |
| 2009-12-15 | CT | Futures | 61.37 | 62.1 | 60.96 | 61.05 | 8802.0 |
| 2009-12-15 | DC | Futures | 25.55 | 25.85 | 25.19 | 25.22 | 98.0 |
| 2009-12-15 | DX | Futures | 78.056 | 78.889 | 78.025 | 78.61 | 17246.0 |
| 2009-12-15 | E1 | Futures | 1.27891 | 1.27944 | 1.26493 | 1.26744 | 45741.0 |
| 2009-12-15 | E6 | Futures | 1.73411 | 1.73494 | 1.71624 | 1.71932 | 241078.0 |
| 2009-12-15 | E7 | Futures | 1.7222 | 1.7228 | 1.7044 | 1.7074 | 2792.0 |
| 2009-12-15 | EBM | Futures | 224.35 | 224.35 | 223.08 | 223.93 | 1799.0 |
| 2009-12-15 | ED | Futures | 94.2684 | 94.2731 | 94.24 | 94.2542 | 231324.0 |
| 2009-12-15 | ER | Futures | 97.174 | 97.179 | 97.135 | 97.149 | 163465.0 |
| 2009-12-15 | EW | Futures | 691.1 | 695.4 | 688.2 | 692.5 | 34537.0 |
| 2009-12-15 | FBTP | Futures | 63.27 | 63.37 | 63.06 | 63.21 | 3017.0 |
| 2009-12-15 | FCE | Futures | 2509.0 | 2511.9 | 2478.9 | 2506.1 | 159907.0 |
| 2009-12-15 | FDAX | Futures | 6340.9 | 6343.6 | 6257.6 | 6316.9 | 155867.0 |
| 2009-12-15 | FESX | Futures | 1732.9 | 1732.9 | 1707.7 | 1726.3 | 1065640.0 |
| 2009-12-15 | FEU3 | Futures | 97.727 | 97.731 | 97.707 | 97.712 | 1718.0 |
| 2009-12-15 | FGBL | Futures | 94.79 | 94.91 | 94.35 | 94.44 | 704569.0 |
| 2009-12-15 | FGBM | Futures | 100.19 | 100.33 | 99.96 | 100.01 | 371752.0 |
| 2009-12-15 | FGBS | Futures | 105.284 | 105.357 | 105.255 | 105.27 | 387001.0 |
| 2009-12-15 | FGBX | Futures | 87.85 | 88.3 | 87.6 | 87.83 | 1998.0 |
| 2009-12-15 | FTDX | Futures | 720.8 | 720.8 | 712.4 | 715.5 | 1736.0 |
| 2009-12-15 | FTI | Futures | 263.78 | 265.86 | 262.23 | 265.41 | 32272.0 |
| 2009-12-15 | FTUK | Futures | 3542.1 | 3542.1 | 3488.8 | 3508.6 | 189910.0 |
| 2009-12-15 | G | Futures | 75.87 | 75.99 | 75.62 | 75.7 | 71725.0 |
| 2009-12-15 | GF | Futures | 249.27 | 252.661 | 249.27 | 252.322 | 2278.0 |
| 2009-12-15 | GSCI | Futures | 929.43 | 941.47 | 929.43 | 937.49 | 902.0 |
| 2009-12-15 | HE | Futures | 88.383 | 90.59 | 87.881 | 90.223 | 15837.0 |
| 2009-12-15 | HG | Futures | 4.3435 | 4.3704 | 4.2931 | 4.3338 | 14997.0 |
| 2009-12-15 | HO | Futures | 1.8159 | 1.8355 | 1.8083 | 1.8094 | 8006.0 |
| 2009-12-15 | J1 | Futures | 0.0141914 | 0.0142102 | 0.0139976 | 0.0140303 | 90447.0 |
| 2009-12-15 | J7 | Futures | 0.014019 | 0.01403 | 0.013825 | 0.013855 | 224.0 |
| 2009-12-15 | JB | Futures | 117.72 | 117.91 | 117.64 | 117.9 | 977.0 |
| 2009-12-15 | KC | Futures | 379.77 | 388.88 | 376.64 | 383.28 | 14397.0 |
| 2009-12-15 | KE | Futures | 2411.59 | 2427.41 | 2374.28 | 2381.06 | 8985.0 |
| 2009-12-15 | L | Futures | 97.691 | 97.701 | 97.661 | 97.691 | 68875.0 |
> showing 50 of 89 rows — these rows as CSV