PREVIEW / futures_daily / 2010-03-16
file: by_date/futures_daily/2010/2010-03-16.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 |
|---|---|---|---|---|---|---|---|
| 2010-03-16 | ES | Futures | 1115.72 | 1125.45 | 1114.5 | 1124.48 | 2010549.0 |
| 2010-03-16 | NQ | Futures | 2174.71 | 2192.01 | 2174.14 | 2187.75 | 270071.0 |
| 2010-03-16 | YM | Futures | 9721.3 | 9773.7 | 9706.5 | 9766.3 | 113839.0 |
| 2010-03-16 | CL | Futures | 187.39 | 192.7 | 186.22 | 191.79 | 166486.0 |
| 2010-03-16 | GC | Futures | 1520.6 | 1549.4 | 1520.3 | 1540.1 | 141796.0 |
| 2010-03-16 | ZN | Futures | 95.43545 | 95.869074 | 95.29516 | 95.792552 | 826152.0 |
| 2010-03-16 | A6 | Futures | 0.7425 | 0.74701 | 0.74094 | 0.74529 | 75041.0 |
| 2010-03-16 | AD | Futures | 0.9683 | 0.97403 | 0.96751 | 0.97284 | 59214.0 |
| 2010-03-16 | B | Futures | 70.3 | 72.49 | 69.92 | 72.07 | 170058.0 |
| 2010-03-16 | B6 | Futures | 1.5621 | 1.5836 | 1.5542 | 1.5806 | 129278.0 |
| 2010-03-16 | BFX | Futures | 2952.9 | 2970.9 | 2952.9 | 2965.7 | 2222.0 |
| 2010-03-16 | BR | Futures | 0.2283 | 0.2283 | 0.2283 | 0.2283 | 217.0 |
| 2010-03-16 | BZ | Futures | 74.5 | 76.18 | 74.5 | 75.79 | 16.0 |
| 2010-03-16 | C | Futures | 2200.0 | 2220.0 | 2141.0 | 2198.0 | 7163.0 |
| 2010-03-16 | CC | Futures | 2418.0 | 2446.0 | 2324.0 | 2411.0 | 8344.0 |
| 2010-03-16 | CT | Futures | 65.67 | 66.64 | 65.15 | 66.55 | 7588.0 |
| 2010-03-16 | DC | Futures | 22.77 | 22.82 | 22.66 | 22.69 | 194.0 |
| 2010-03-16 | DX | Futures | 81.489 | 81.611 | 80.917 | 81.064 | 22453.0 |
| 2010-03-16 | E1 | Futures | 1.24038 | 1.25064 | 1.23959 | 1.24814 | 50796.0 |
| 2010-03-16 | E6 | Futures | 1.61809 | 1.63075 | 1.61572 | 1.62743 | 288581.0 |
| 2010-03-16 | E7 | Futures | 1.6047 | 1.6172 | 1.6025 | 1.6141 | 3157.0 |
| 2010-03-16 | EBM | Futures | 199.88 | 200.7 | 199.47 | 200.7 | 4879.0 |
| 2010-03-16 | ED | Futures | 94.3802 | 94.4087 | 94.3708 | 94.3992 | 304080.0 |
| 2010-03-16 | ER | Futures | 97.345 | 97.36 | 97.34 | 97.355 | 157024.0 |
| 2010-03-16 | EW | Futures | 758.7 | 768.1 | 758.7 | 767.6 | 27220.0 |
| 2010-03-16 | FBTP | Futures | 64.24 | 64.41 | 64.24 | 64.36 | 3920.0 |
| 2010-03-16 | FCE | Futures | 2511.2 | 2528.8 | 2501.9 | 2521.7 | 138844.0 |
| 2010-03-16 | FDAX | Futures | 6497.9 | 6545.4 | 6476.6 | 6523.5 | 169887.0 |
| 2010-03-16 | FESX | Futures | 1728.2 | 1741.7 | 1722.1 | 1736.1 | 1004321.0 |
| 2010-03-16 | FEU3 | Futures | 97.909 | 97.914 | 97.904 | 97.914 | 169.0 |
| 2010-03-16 | FGBL | Futures | 95.76 | 96.18 | 95.56 | 95.88 | 834834.0 |
| 2010-03-16 | FGBM | Futures | 101.47 | 101.83 | 101.35 | 101.56 | 494202.0 |
| 2010-03-16 | FGBS | Futures | 106.189 | 106.346 | 106.17 | 106.238 | 458882.0 |
| 2010-03-16 | FGBX | Futures | 90.05 | 90.48 | 89.58 | 90.11 | 3872.0 |
| 2010-03-16 | FTDX | Futures | 733.2 | 734.5 | 731.0 | 732.7 | 4000.0 |
| 2010-03-16 | FTI | Futures | 272.05 | 273.92 | 271.32 | 273.43 | 31474.0 |
| 2010-03-16 | FTUK | Futures | 3770.7 | 3779.5 | 3752.4 | 3774.1 | 251471.0 |
| 2010-03-16 | G | Futures | 76.07 | 76.38 | 75.89 | 76.29 | 84452.0 |
| 2010-03-16 | GF | Futures | 276.728 | 276.989 | 275.554 | 276.206 | 763.0 |
| 2010-03-16 | GSCI | Futures | 956.92 | 972.1 | 956.0 | 969.34 | 533.0 |
| 2010-03-16 | HE | Futures | 96.311 | 96.579 | 95.073 | 96.01 | 11728.0 |
| 2010-03-16 | HG | Futures | 4.5387 | 4.6234 | 4.5223 | 4.5974 | 25246.0 |
| 2010-03-16 | HO | Futures | 1.9 | 1.9527 | 1.8891 | 1.9465 | 14769.0 |
| 2010-03-16 | J1 | Futures | 0.0139008 | 0.0139825 | 0.0138643 | 0.0139372 | 125051.0 |
| 2010-03-16 | J7 | Futures | 0.013814 | 0.01387 | 0.013756 | 0.013826 | 176.0 |
| 2010-03-16 | JB | Futures | 118.08 | 118.13 | 118.01 | 118.06 | 1037.0 |
| 2010-03-16 | KC | Futures | 337.09 | 342.61 | 335.42 | 340.94 | 8262.0 |
| 2010-03-16 | KE | Futures | 2163.57 | 2208.99 | 2162.46 | 2192.37 | 5399.0 |
| 2010-03-16 | L | Futures | 97.868 | 97.878 | 97.848 | 97.858 | 37900.0 |
| 2010-03-16 | LBS | Futures | 855.1 | 864.2 | 848.8 | 856.7 | 263.0 |
> showing 50 of 89 rows — these rows as CSV