PREVIEW / futures_daily / 2011-09-12
file: by_date/futures_daily/2011/2011-09-12.parquet size: 9 KB rows: 96
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-09-12 | ES | Futures | 1135.65 | 1156.01 | 1121.74 | 1155.26 | 1148718.0 |
| 2011-09-12 | NQ | Futures | 2459.43 | 2503.84 | 2416.44 | 2499.57 | 125382.0 |
| 2011-09-12 | YM | Futures | 10419.3 | 10565.3 | 10274.3 | 10556.7 | 138203.0 |
| 2011-09-12 | CL | Futures | 165.15 | 169.47 | 161.91 | 167.99 | 355070.0 |
| 2011-09-12 | GC | Futures | 2514.3 | 2518.3 | 2435.7 | 2448.2 | 226772.0 |
| 2011-09-12 | ZN | Futures | 112.421087 | 112.514939 | 111.871383 | 112.059087 | 934029.0 |
| 2011-09-12 | A6 | Futures | 0.90726 | 0.90752 | 0.89178 | 0.8924 | 28948.0 |
| 2011-09-12 | AD | Futures | 1.00055 | 1.00716 | 0.99565 | 1.00145 | 18139.0 |
| 2011-09-12 | B | Futures | 94.51 | 95.59 | 93.05 | 94.55 | 183511.0 |
| 2011-09-12 | B6 | Futures | 1.6501 | 1.6567 | 1.6448 | 1.6489 | 20474.0 |
| 2011-09-12 | BR | Futures | 0.26422 | 0.26425 | 0.25837 | 0.25837 | 1124.0 |
| 2011-09-12 | BZ | Futures | 97.31 | 98.93 | 96.59 | 97.94 | 1211.0 |
| 2011-09-12 | C | Futures | 1965.0 | 1970.0 | 1948.0 | 1955.0 | 22036.0 |
| 2011-09-12 | CB | Futures | 96.025 | 96.436 | 96.025 | 96.025 | 3.0 |
| 2011-09-12 | CC | Futures | 2246.0 | 2262.0 | 2239.0 | 2245.0 | 7906.0 |
| 2011-09-12 | CSC | Futures | 4.312 | 4.312 | 4.293 | 4.293 | 13.0 |
| 2011-09-12 | CT | Futures | 143.06 | 143.69 | 142.57 | 143.69 | 12.0 |
| 2011-09-12 | DC | Futures | 30.04 | 30.28 | 29.84 | 30.18 | 225.0 |
| 2011-09-12 | DX | Futures | 76.554 | 76.863 | 76.225 | 76.738 | 21695.0 |
| 2011-09-12 | E1 | Futures | 1.47918 | 1.49571 | 1.47406 | 1.48404 | 4529.0 |
| 2011-09-12 | E6 | Futures | 1.62214 | 1.6366 | 1.61354 | 1.62226 | 82291.0 |
| 2011-09-12 | E7 | Futures | 1.6103 | 1.6223 | 1.5999 | 1.6084 | 962.0 |
| 2011-09-12 | ED | Futures | 94.9268 | 94.9364 | 94.8886 | 94.922 | 303445.0 |
| 2011-09-12 | ER | Futures | 97.529 | 97.554 | 97.44 | 97.465 | 151604.0 |
| 2011-09-12 | EW | Futures | 819.5 | 830.3 | 805.0 | 829.8 | 61715.0 |
| 2011-09-12 | FBTP | Futures | 62.82 | 62.82 | 61.84 | 62.08 | 7517.0 |
| 2011-09-12 | FBTS | Futures | 81.671 | 81.775 | 81.149 | 81.293 | 874.0 |
| 2011-09-12 | FCE | Futures | 2087.8 | 2087.8 | 2011.0 | 2034.2 | 79586.0 |
| 2011-09-12 | FDAX | Futures | 5427.0 | 5501.8 | 5301.9 | 5428.0 | 270080.0 |
| 2011-09-12 | FESX | Futures | 1328.4 | 1337.0 | 1300.4 | 1319.0 | 1233620.0 |
| 2011-09-12 | FEU3 | Futures | 98.069 | 98.069 | 98.024 | 98.024 | 1.0 |
| 2011-09-12 | FGBL | Futures | 111.69 | 112.15 | 111.61 | 111.85 | 781482.0 |
| 2011-09-12 | FGBM | Futures | 111.63 | 111.74 | 111.38 | 111.49 | 416665.0 |
| 2011-09-12 | FGBS | Futures | 109.407 | 109.427 | 109.243 | 109.278 | 441118.0 |
| 2011-09-12 | FGBX | Futures | 111.9 | 113.3 | 111.7 | 112.8 | 5039.0 |
| 2011-09-12 | FTDX | Futures | 626.1 | 632.0 | 622.8 | 628.4 | 4064.0 |
| 2011-09-12 | FTI | Futures | 225.28 | 225.57 | 220.59 | 223.16 | 6511.0 |
| 2011-09-12 | FTUK | Futures | 3681.7 | 3707.9 | 3611.0 | 3668.8 | 92932.0 |
| 2011-09-12 | FVSA | Futures | 17328.31 | 18849.82 | 17328.31 | 18638.49 | 4271.0 |
| 2011-09-12 | FXXP | Futures | 152.2 | 152.6 | 152.1 | 152.3 | 23696.0 |
| 2011-09-12 | G | Futures | 92.25 | 92.93 | 92.22 | 92.52 | 96920.0 |
| 2011-09-12 | GF | Futures | 305.039 | 308.265 | 304.416 | 306.85 | 3241.0 |
| 2011-09-12 | GSCI | Futures | 1029.31 | 1043.33 | 1029.31 | 1036.44 | 2004.0 |
| 2011-09-12 | HE | Futures | 106.138 | 106.748 | 105.405 | 105.863 | 17555.0 |
| 2011-09-12 | HG | Futures | 5.2859 | 5.2918 | 5.1674 | 5.2475 | 35338.0 |
| 2011-09-12 | HO | Futures | 2.3922 | 2.4116 | 2.3648 | 2.3826 | 18074.0 |
| 2011-09-12 | HRC | Futures | 2910.3 | 2910.3 | 2910.3 | 2910.3 | 0.0 |
| 2011-09-12 | J1 | Futures | 0.0162268 | 0.0163964 | 0.0162154 | 0.0162632 | 26563.0 |
| 2011-09-12 | J7 | Futures | 0.016118 | 0.016304 | 0.016118 | 0.016165 | 100.0 |
| 2011-09-12 | JB | Futures | 124.42 | 124.62 | 124.38 | 124.55 | 1020.0 |
> showing 50 of 96 rows — these rows as CSV