PREVIEW / futures_daily / 2010-11-09
file: by_date/futures_daily/2010/2010-11-09.parquet size: 9 KB rows: 93
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-11-09 | ES | Futures | 1195.06 | 1200.45 | 1182.32 | 1186.98 | 2324133.0 |
| 2010-11-09 | NQ | Futures | 2475.29 | 2492.3 | 2454.03 | 2467.63 | 269273.0 |
| 2010-11-09 | YM | Futures | 10567.6 | 10607.6 | 10483.9 | 10526.7 | 119411.0 |
| 2010-11-09 | CL | Futures | 178.85 | 180.66 | 176.23 | 178.79 | 367995.0 |
| 2010-11-09 | GC | Futures | 1916.6 | 1936.0 | 1878.8 | 1916.7 | 310218.0 |
| 2010-11-09 | ZN | Futures | 105.23223 | 105.438694 | 104.393469 | 104.496701 | 1334465.0 |
| 2010-11-09 | A6 | Futures | 0.846 | 0.85045 | 0.8356 | 0.8429 | 113447.0 |
| 2010-11-09 | AD | Futures | 0.98698 | 0.99203 | 0.98064 | 0.98747 | 90567.0 |
| 2010-11-09 | B | Futures | 75.08 | 75.92 | 74.34 | 75.31 | 114743.0 |
| 2010-11-09 | B6 | Futures | 1.675 | 1.6798 | 1.6554 | 1.6645 | 117630.0 |
| 2010-11-09 | BFX | Futures | 3058.5 | 3088.7 | 3058.5 | 3088.7 | 65.0 |
| 2010-11-09 | BR | Futures | 0.25003 | 0.25003 | 0.25003 | 0.25003 | 111.0 |
| 2010-11-09 | BZ | Futures | 79.95 | 80.0 | 78.79 | 79.67 | 239.0 |
| 2010-11-09 | C | Futures | 2011.0 | 2047.0 | 1996.0 | 2044.0 | 8775.0 |
| 2010-11-09 | CB | Futures | 97.201 | 97.201 | 97.201 | 97.201 | 3.0 |
| 2010-11-09 | CC | Futures | 2309.0 | 2361.0 | 2302.0 | 2340.0 | 19764.0 |
| 2010-11-09 | CSC | Futures | 3.314 | 3.339 | 3.261 | 3.339 | 32.0 |
| 2010-11-09 | CT | Futures | 126.28 | 128.01 | 124.65 | 128.01 | 11591.0 |
| 2010-11-09 | DC | Futures | 22.17 | 22.45 | 22.05 | 22.42 | 619.0 |
| 2010-11-09 | DX | Futures | 77.626 | 78.269 | 77.075 | 77.831 | 34808.0 |
| 2010-11-09 | E1 | Futures | 1.3598 | 1.36991 | 1.35415 | 1.35875 | 44655.0 |
| 2010-11-09 | E6 | Futures | 1.64537 | 1.65246 | 1.62585 | 1.63543 | 442912.0 |
| 2010-11-09 | E7 | Futures | 1.6328 | 1.6404 | 1.6136 | 1.623 | 7096.0 |
| 2010-11-09 | ED | Futures | 94.7363 | 94.7411 | 94.7173 | 94.7268 | 216773.0 |
| 2010-11-09 | ER | Futures | 97.173 | 97.208 | 97.173 | 97.193 | 152894.0 |
| 2010-11-09 | EW | Futures | 843.1 | 847.9 | 831.5 | 835.7 | 22549.0 |
| 2010-11-09 | FBTP | Futures | 66.83 | 66.84 | 66.42 | 66.53 | 4003.0 |
| 2010-11-09 | FCE | Futures | 2587.2 | 2622.8 | 2581.5 | 2611.1 | 139207.0 |
| 2010-11-09 | FDAX | Futures | 7264.0 | 7333.9 | 7250.0 | 7310.2 | 122803.0 |
| 2010-11-09 | FESX | Futures | 1785.6 | 1809.3 | 1779.4 | 1800.6 | 1183434.0 |
| 2010-11-09 | FEU3 | Futures | 97.746 | 97.756 | 97.746 | 97.756 | 11.0 |
| 2010-11-09 | FGBL | Futures | 103.28 | 103.55 | 102.7 | 103.09 | 1020299.0 |
| 2010-11-09 | FGBM | Futures | 106.43 | 106.61 | 106.13 | 106.35 | 504892.0 |
| 2010-11-09 | FGBS | Futures | 107.371 | 107.396 | 107.272 | 107.327 | 442680.0 |
| 2010-11-09 | FGBX | Futures | 106.94 | 107.5 | 105.7 | 106.63 | 2641.0 |
| 2010-11-09 | FTDX | Futures | 721.4 | 728.4 | 713.9 | 726.6 | 260.0 |
| 2010-11-09 | FTI | Futures | 277.66 | 279.18 | 276.74 | 278.38 | 23107.0 |
| 2010-11-09 | FTUK | Futures | 4035.8 | 4072.4 | 4026.5 | 4052.7 | 111360.0 |
| 2010-11-09 | FXXP | Futures | 176.6 | 176.6 | 176.6 | 176.6 | 1500.0 |
| 2010-11-09 | G | Futures | 84.59 | 84.59 | 84.09 | 84.17 | 109825.0 |
| 2010-11-09 | GF | Futures | 280.292 | 283.251 | 278.404 | 281.74 | 1039.0 |
| 2010-11-09 | GSCI | Futures | 993.9 | 995.47 | 979.54 | 985.73 | 1497.0 |
| 2010-11-09 | HE | Futures | 90.904 | 91.953 | 89.99 | 90.058 | 20880.0 |
| 2010-11-09 | HG | Futures | 5.2834 | 5.4022 | 5.242 | 5.3961 | 46247.0 |
| 2010-11-09 | HO | Futures | 2.0211 | 2.0409 | 2.0063 | 2.0303 | 55878.0 |
| 2010-11-09 | HRC | Futures | 2482.1 | 2482.1 | 2482.1 | 2482.1 | 0.0 |
| 2010-11-09 | J1 | Futures | 0.0154815 | 0.0156008 | 0.0153282 | 0.0153923 | 173673.0 |
| 2010-11-09 | J7 | Futures | 0.01536 | 0.015493 | 0.015224 | 0.015287 | 499.0 |
| 2010-11-09 | JB | Futures | 121.68 | 121.84 | 121.57 | 121.6 | 1719.0 |
| 2010-11-09 | KC | Futures | 515.57 | 540.25 | 514.45 | 538.26 | 19282.0 |
> showing 50 of 93 rows — these rows as CSV