PREVIEW / futures_daily / 2012-09-11
file: by_date/futures_daily/2012/2012-09-11.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 |
|---|---|---|---|---|---|---|---|
| 2012-09-11 | ES | Futures | 1443.63 | 1455.79 | 1439.58 | 1448.7 | 1430082.0 |
| 2012-09-11 | NQ | Futures | 3195.95 | 3213.45 | 3188.2 | 3189.92 | 181217.0 |
| 2012-09-11 | YM | Futures | 12840.9 | 12959.0 | 12809.6 | 12904.3 | 3919.0 |
| 2012-09-11 | CL | Futures | 174.2 | 176.04 | 173.82 | 175.79 | 222006.0 |
| 2012-09-11 | GC | Futures | 2308.0 | 2323.8 | 2307.1 | 2316.3 | 109346.0 |
| 2012-09-11 | ZN | Futures | 116.95863 | 117.068502 | 116.656482 | 116.711418 | 636737.0 |
| 2012-09-11 | A6 | Futures | 0.93089 | 0.94135 | 0.92999 | 0.94016 | 38394.0 |
| 2012-09-11 | AD | Futures | 1.02456 | 1.03109 | 1.02446 | 1.02888 | 53835.0 |
| 2012-09-11 | B | Futures | 104.09 | 104.72 | 103.86 | 104.65 | 159590.0 |
| 2012-09-11 | B6 | Futures | 1.6696 | 1.6792 | 1.6693 | 1.6777 | 36408.0 |
| 2012-09-11 | BR | Futures | 0.23663 | 0.2374 | 0.23663 | 0.2374 | 350.0 |
| 2012-09-11 | BZ | Futures | 109.47 | 109.68 | 109.14 | 109.68 | 2056.0 |
| 2012-09-11 | C | Futures | 1741.0 | 1743.0 | 1703.0 | 1712.0 | 11846.0 |
| 2012-09-11 | CB | Futures | 98.095 | 98.215 | 98.095 | 98.215 | 3.0 |
| 2012-09-11 | CC | Futures | 2001.0 | 2020.0 | 1959.0 | 1985.0 | 12608.0 |
| 2012-09-11 | CSC | Futures | 3.973 | 3.985 | 3.962 | 3.979 | 7.0 |
| 2012-09-11 | CT | Futures | 99.32 | 99.32 | 97.85 | 97.85 | 49.0 |
| 2012-09-11 | DC | Futures | 29.6 | 30.02 | 29.46 | 29.87 | 116.0 |
| 2012-09-11 | DX | Futures | 78.041 | 78.041 | 77.426 | 77.475 | 6621.0 |
| 2012-09-11 | E1 | Futures | 1.36308 | 1.37441 | 1.36192 | 1.37325 | 7184.0 |
| 2012-09-11 | E6 | Futures | 1.50412 | 1.51708 | 1.50389 | 1.51578 | 60069.0 |
| 2012-09-11 | E7 | Futures | 1.4954 | 1.5079 | 1.4951 | 1.5067 | 920.0 |
| 2012-09-11 | ED | Futures | 95.1919 | 95.2157 | 95.1919 | 95.2062 | 145987.0 |
| 2012-09-11 | ER | Futures | 97.852 | 97.862 | 97.847 | 97.852 | 103103.0 |
| 2012-09-11 | EW | Futures | 1012.3 | 1021.3 | 1012.3 | 1014.6 | 3393.0 |
| 2012-09-11 | FBTP | Futures | 70.2 | 70.91 | 69.83 | 70.75 | 16914.0 |
| 2012-09-11 | FBTS | Futures | 88.855 | 89.273 | 88.83 | 89.114 | 3838.0 |
| 2012-09-11 | FCE | Futures | 2599.3 | 2637.6 | 2591.4 | 2636.5 | 84783.0 |
| 2012-09-11 | FDAX | Futures | 7841.2 | 7986.4 | 7831.9 | 7984.2 | 136056.0 |
| 2012-09-11 | FESX | Futures | 1702.8 | 1735.5 | 1698.8 | 1733.5 | 93703.0 |
| 2012-09-11 | FEU3 | Futures | 98.478 | 98.478 | 98.473 | 98.473 | 6.0 |
| 2012-09-11 | FGBL | Futures | 117.68 | 117.83 | 117.28 | 117.32 | 579888.0 |
| 2012-09-11 | FGBM | Futures | 115.98 | 116.02 | 115.76 | 115.77 | 323712.0 |
| 2012-09-11 | FGBS | Futures | 110.338 | 110.353 | 110.308 | 110.318 | 235040.0 |
| 2012-09-11 | FGBX | Futures | 123.92 | 124.2 | 122.89 | 123.18 | 5863.0 |
| 2012-09-11 | FOAT | Futures | 102.38 | 102.95 | 102.24 | 102.81 | 32003.0 |
| 2012-09-11 | FTI | Futures | 284.42 | 286.81 | 284.17 | 286.68 | 150.0 |
| 2012-09-11 | FTUK | Futures | 4195.2 | 4219.4 | 4195.2 | 4215.0 | 9670.0 |
| 2012-09-11 | FVSA | Futures | 6250.97 | 6353.45 | 6110.07 | 6110.07 | 3505.0 |
| 2012-09-11 | G | Futures | 99.3 | 99.32 | 99.06 | 99.22 | 143002.0 |
| 2012-09-11 | GF | Futures | 285.349 | 286.858 | 284.717 | 284.911 | 3490.0 |
| 2012-09-11 | GSCI | Futures | 1097.26 | 1098.31 | 1096.29 | 1096.29 | 1911.0 |
| 2012-09-11 | HE | Futures | 89.63 | 90.495 | 88.889 | 89.877 | 29263.0 |
| 2012-09-11 | HG | Futures | 4.7195 | 4.7709 | 4.6886 | 4.751 | 49136.0 |
| 2012-09-11 | HH | Futures | 40.109 | 40.109 | 40.109 | 40.109 | 1200.0 |
| 2012-09-11 | HO | Futures | 2.5577 | 2.5815 | 2.5576 | 2.5785 | 22362.0 |
| 2012-09-11 | HRC | Futures | 2471.7 | 2471.7 | 2471.7 | 2471.7 | 0.0 |
| 2012-09-11 | J1 | Futures | 0.0160095 | 0.016126 | 0.0160083 | 0.0161122 | 52766.0 |
| 2012-09-11 | J7 | Futures | 0.015947 | 0.016055 | 0.015947 | 0.016044 | 195.0 |
| 2012-09-11 | JB | Futures | 126.71 | 126.72 | 126.7 | 126.7 | 1592.0 |
> showing 50 of 93 rows — these rows as CSV