PREVIEW / futures_daily / 2012-10-22
file: by_date/futures_daily/2012/2012-10-22.parquet size: 9 KB rows: 100
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-10-22 | ES | Futures | 1449.83 | 1456.7 | 1441.95 | 1455.43 | 1777803.0 |
| 2012-10-22 | NQ | Futures | 3065.8 | 3098.6 | 3057.75 | 3092.56 | 278347.0 |
| 2012-10-22 | YM | Futures | 12939.5 | 12995.1 | 12864.3 | 12979.5 | 123349.0 |
| 2012-10-22 | CL | Futures | 162.29 | 164.49 | 159.63 | 159.77 | 275720.0 |
| 2012-10-22 | GC | Futures | 2300.0 | 2310.9 | 2289.0 | 2304.8 | 108139.0 |
| 2012-10-22 | ZN | Futures | 116.354334 | 116.395536 | 115.956049 | 116.120857 | 770503.0 |
| 2012-10-22 | A6 | Futures | 0.93389 | 0.93544 | 0.93144 | 0.93189 | 78491.0 |
| 2012-10-22 | AD | Futures | 1.0081 | 1.01081 | 1.00599 | 1.0086 | 66440.0 |
| 2012-10-22 | B | Futures | 100.76 | 101.7 | 100.0 | 100.29 | 218731.0 |
| 2012-10-22 | B6 | Futures | 1.6715 | 1.6761 | 1.6697 | 1.6712 | 75897.0 |
| 2012-10-22 | BFX | Futures | 2846.5 | 2849.7 | 2846.5 | 2849.7 | 9.0 |
| 2012-10-22 | BR | Futures | 0.23818 | 0.23847 | 0.23818 | 0.23845 | 82.0 |
| 2012-10-22 | BZ | Futures | 104.36 | 105.52 | 103.81 | 104.07 | 586.0 |
| 2012-10-22 | C | Futures | 1622.0 | 1652.0 | 1615.0 | 1650.0 | 5120.0 |
| 2012-10-22 | CB | Futures | 93.13 | 93.13 | 92.729 | 93.13 | 7.0 |
| 2012-10-22 | CC | Futures | 1866.0 | 1905.0 | 1855.0 | 1897.0 | 11912.0 |
| 2012-10-22 | CSC | Futures | 4.248 | 4.25 | 4.215 | 4.215 | 5.0 |
| 2012-10-22 | CT | Futures | 99.1 | 100.17 | 98.65 | 99.27 | 13445.0 |
| 2012-10-22 | DC | Futures | 31.35 | 31.61 | 31.06 | 31.28 | 298.0 |
| 2012-10-22 | DX | Futures | 77.198 | 77.252 | 77.039 | 77.233 | 14738.0 |
| 2012-10-22 | E1 | Futures | 1.3878 | 1.39282 | 1.38677 | 1.38857 | 22805.0 |
| 2012-10-22 | E6 | Futures | 1.53486 | 1.54145 | 1.53345 | 1.53698 | 205135.0 |
| 2012-10-22 | E7 | Futures | 1.5256 | 1.5322 | 1.5243 | 1.5278 | 3026.0 |
| 2012-10-22 | ED | Futures | 95.2444 | 95.254 | 95.2444 | 95.2492 | 100805.0 |
| 2012-10-22 | ER | Futures | 97.862 | 97.866 | 97.857 | 97.862 | 71681.0 |
| 2012-10-22 | EW | Futures | 1002.4 | 1005.7 | 995.7 | 1003.8 | 16803.0 |
| 2012-10-22 | FBTP | Futures | 73.21 | 73.48 | 73.17 | 73.28 | 10007.0 |
| 2012-10-22 | FBTS | Futures | 89.868 | 89.994 | 89.826 | 89.91 | 2109.0 |
| 2012-10-22 | FCE | Futures | 2625.7 | 2644.5 | 2608.0 | 2615.9 | 83401.0 |
| 2012-10-22 | FDAX | Futures | 8070.4 | 8099.4 | 8001.4 | 8023.3 | 112218.0 |
| 2012-10-22 | FESX | Futures | 1723.3 | 1737.6 | 1715.1 | 1719.2 | 820417.0 |
| 2012-10-22 | FEU3 | Futures | 98.483 | 98.483 | 98.483 | 98.483 | 2.0 |
| 2012-10-22 | FGBL | Futures | 117.19 | 117.26 | 116.73 | 116.9 | 681939.0 |
| 2012-10-22 | FGBM | Futures | 115.69 | 115.75 | 115.45 | 115.55 | 437421.0 |
| 2012-10-22 | FGBS | Futures | 110.203 | 110.218 | 110.143 | 110.178 | 285961.0 |
| 2012-10-22 | FGBX | Futures | 123.31 | 123.37 | 121.98 | 122.5 | 5875.0 |
| 2012-10-22 | FOAT | Futures | 103.81 | 103.85 | 103.61 | 103.68 | 13301.0 |
| 2012-10-22 | FTDX | Futures | 761.8 | 762.2 | 758.0 | 758.9 | 46.0 |
| 2012-10-22 | FTI | Futures | 285.05 | 287.97 | 285.01 | 285.83 | 25157.0 |
| 2012-10-22 | FTUK | Futures | 4266.2 | 4306.4 | 4264.7 | 4281.9 | 74514.0 |
| 2012-10-22 | FVSA | Futures | 5138.76 | 5161.35 | 4969.35 | 5093.59 | 3734.0 |
| 2012-10-22 | FXXP | Futures | 196.9 | 197.9 | 196.2 | 196.3 | 2351.0 |
| 2012-10-22 | G | Futures | 98.03 | 98.12 | 97.76 | 97.94 | 108646.0 |
| 2012-10-22 | GF | Futures | 285.972 | 286.116 | 283.283 | 283.716 | 1545.0 |
| 2012-10-22 | GSCI | Futures | 1062.56 | 1062.8 | 1047.19 | 1049.46 | 265.0 |
| 2012-10-22 | HE | Futures | 98.973 | 99.066 | 97.45 | 97.792 | 17748.0 |
| 2012-10-22 | HG | Futures | 4.6745 | 4.6938 | 4.6372 | 4.6546 | 43851.0 |
| 2012-10-22 | HH | Futures | 44.017 | 44.017 | 44.017 | 44.017 | 2220.0 |
| 2012-10-22 | HO | Futures | 2.5127 | 2.5393 | 2.4832 | 2.4857 | 86603.0 |
| 2012-10-22 | HRC | Futures | 2426.5 | 2426.5 | 2426.5 | 2426.5 | 0.0 |
> showing 50 of 100 rows — these rows as CSV