PREVIEW / futures_daily / 2011-01-06
file: by_date/futures_daily/2011/2011-01-06.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 |
|---|---|---|---|---|---|---|---|
| 2011-01-06 | ES | Futures | 1251.81 | 1256.98 | 1246.4 | 1250.34 | 1614397.0 |
| 2011-01-06 | NQ | Futures | 2577.99 | 2587.64 | 2574.02 | 2584.24 | 177334.0 |
| 2011-01-06 | YM | Futures | 10914.8 | 10957.9 | 10869.9 | 10899.8 | 91622.0 |
| 2011-01-06 | CL | Futures | 185.4 | 185.89 | 180.03 | 181.12 | 440456.0 |
| 2011-01-06 | GC | Futures | 1870.9 | 1875.8 | 1854.4 | 1864.5 | 173240.0 |
| 2011-01-06 | ZN | Futures | 99.321676 | 99.828618 | 99.269682 | 99.672636 | 1033157.0 |
| 2011-01-06 | A6 | Futures | 0.84063 | 0.84241 | 0.83537 | 0.83613 | 99419.0 |
| 2011-01-06 | AD | Futures | 0.99453 | 0.9985 | 0.99155 | 0.99483 | 72102.0 |
| 2011-01-06 | B | Futures | 81.24 | 81.68 | 79.93 | 80.36 | 160895.0 |
| 2011-01-06 | B6 | Futures | 1.6078 | 1.6138 | 1.6015 | 1.6038 | 126000.0 |
| 2011-01-06 | BFX | Futures | 3037.9 | 3049.7 | 3018.8 | 3026.4 | 1095.0 |
| 2011-01-06 | BR | Futures | 0.25282 | 0.25289 | 0.25282 | 0.25289 | 104.0 |
| 2011-01-06 | BZ | Futures | 86.9 | 86.9 | 85.6 | 85.6 | 1462.0 |
| 2011-01-06 | C | Futures | 2112.0 | 2135.0 | 2100.0 | 2102.0 | 10084.0 |
| 2011-01-06 | CB | Futures | 109.122 | 110.002 | 109.122 | 110.002 | 1.0 |
| 2011-01-06 | CC | Futures | 2314.0 | 2334.0 | 2293.0 | 2297.0 | 6779.0 |
| 2011-01-06 | CT | Futures | 125.53 | 127.84 | 121.08 | 121.1 | 14908.0 |
| 2011-01-06 | DC | Futures | 23.18 | 23.52 | 23.18 | 23.36 | 334.0 |
| 2011-01-06 | DX | Futures | 80.425 | 81.074 | 80.315 | 80.947 | 31301.0 |
| 2011-01-06 | E1 | Futures | 1.35871 | 1.3646 | 1.35084 | 1.35949 | 41698.0 |
| 2011-01-06 | E6 | Futures | 1.5557 | 1.55748 | 1.53701 | 1.53914 | 388774.0 |
| 2011-01-06 | E7 | Futures | 1.5438 | 1.546 | 1.5256 | 1.5277 | 5414.0 |
| 2011-01-06 | EBM | Futures | 227.41 | 229.22 | 226.73 | 228.32 | 8526.0 |
| 2011-01-06 | ED | Futures | 94.8099 | 94.8194 | 94.7718 | 94.7861 | 317244.0 |
| 2011-01-06 | ER | Futures | 97.37 | 97.38 | 97.355 | 97.37 | 101276.0 |
| 2011-01-06 | EW | Futures | 898.6 | 903.5 | 896.1 | 898.5 | 21429.0 |
| 2011-01-06 | FBTP | Futures | 64.09 | 64.17 | 63.66 | 63.71 | 3529.0 |
| 2011-01-06 | FCE | Futures | 2614.3 | 2633.7 | 2593.0 | 2606.3 | 116015.0 |
| 2011-01-06 | FDAX | Futures | 7455.3 | 7559.2 | 7448.9 | 7484.8 | 137766.0 |
| 2011-01-06 | FESX | Futures | 1763.8 | 1779.3 | 1748.3 | 1758.2 | 1028891.0 |
| 2011-01-06 | FEU3 | Futures | 97.929 | 97.929 | 97.924 | 97.929 | 5.0 |
| 2011-01-06 | FGBL | Futures | 99.31 | 99.74 | 99.05 | 99.57 | 945021.0 |
| 2011-01-06 | FGBM | Futures | 104.9 | 105.21 | 104.8 | 105.07 | 431149.0 |
| 2011-01-06 | FGBS | Futures | 107.454 | 107.523 | 107.415 | 107.504 | 393878.0 |
| 2011-01-06 | FGBX | Futures | 97.9 | 98.74 | 97.32 | 98.19 | 4547.0 |
| 2011-01-06 | FTDX | Futures | 756.9 | 767.0 | 756.9 | 763.1 | 267.0 |
| 2011-01-06 | FTI | Futures | 287.12 | 287.8 | 284.76 | 285.6 | 30846.0 |
| 2011-01-06 | FTUK | Futures | 4168.7 | 4203.4 | 4136.7 | 4152.7 | 101291.0 |
| 2011-01-06 | FXXP | Futures | 182.2 | 183.2 | 182.2 | 182.2 | 259.0 |
| 2011-01-06 | G | Futures | 81.17 | 81.41 | 80.92 | 81.3 | 117525.0 |
| 2011-01-06 | GF | Futures | 301.669 | 304.284 | 301.669 | 303.724 | 871.0 |
| 2011-01-06 | GSCI | Futures | 1021.59 | 1022.32 | 1004.32 | 1005.05 | 130.0 |
| 2011-01-06 | HE | Futures | 98.448 | 100.455 | 98.229 | 100.047 | 21290.0 |
| 2011-01-06 | HG | Futures | 5.8693 | 5.8986 | 5.746 | 5.77 | 33813.0 |
| 2011-01-06 | HO | Futures | 2.139 | 2.1449 | 2.0963 | 2.1054 | 28039.0 |
| 2011-01-06 | HRC | Futures | 2748.5 | 2748.5 | 2691.7 | 2691.7 | 50.0 |
| 2011-01-06 | J1 | Futures | 0.0150958 | 0.0151636 | 0.015067 | 0.0150896 | 115383.0 |
| 2011-01-06 | J7 | Futures | 0.014979 | 0.015053 | 0.014962 | 0.014982 | 342.0 |
| 2011-01-06 | JB | Futures | 121.39 | 121.45 | 120.63 | 120.66 | 2714.0 |
| 2011-01-06 | KC | Futures | 572.85 | 580.82 | 569.17 | 571.38 | 7762.0 |
> showing 50 of 93 rows — these rows as CSV