PREVIEW / futures_daily / 2012-10-29
file: by_date/futures_daily/2012/2012-10-29.parquet size: 9 KB rows: 94
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-29 | ES | Futures | 1431.26 | 1432.53 | 1421.84 | 1432.53 | 181669.0 |
| 2012-10-29 | NQ | Futures | 3054.3 | 3059.48 | 3031.0 | 3059.48 | 19101.0 |
| 2012-10-29 | YM | Futures | 12741.3 | 12747.1 | 12649.5 | 12747.1 | 15323.0 |
| 2012-10-29 | CL | Futures | 155.77 | 155.77 | 152.58 | 154.17 | 145729.0 |
| 2012-10-29 | GC | Futures | 2286.0 | 2293.5 | 2278.0 | 2281.3 | 57608.0 |
| 2012-10-29 | ZN | Futures | 116.61528 | 116.793822 | 116.505408 | 116.711418 | 348127.0 |
| 2012-10-29 | A6 | Futures | 0.93844 | 0.93853 | 0.93471 | 0.93562 | 52341.0 |
| 2012-10-29 | AD | Futures | 1.00449 | 1.00489 | 1.00128 | 1.00168 | 39592.0 |
| 2012-10-29 | B | Futures | 100.33 | 100.75 | 99.22 | 99.9 | 118613.0 |
| 2012-10-29 | B6 | Futures | 1.6818 | 1.6818 | 1.6715 | 1.6749 | 58008.0 |
| 2012-10-29 | BFX | Futures | 2817.8 | 2819.8 | 2817.8 | 2819.8 | 1.0 |
| 2012-10-29 | BR | Futures | 0.23838 | 0.23838 | 0.23789 | 0.23799 | 353.0 |
| 2012-10-29 | BZ | Futures | 102.84 | 103.81 | 102.34 | 103.01 | 790.0 |
| 2012-10-29 | C | Futures | 1572.0 | 1579.0 | 1545.0 | 1555.0 | 3289.0 |
| 2012-10-29 | CC | Futures | 1808.0 | 1811.0 | 1767.0 | 1772.0 | 8558.0 |
| 2012-10-29 | CSC | Futures | 4.13 | 4.162 | 4.095 | 4.099 | 9.0 |
| 2012-10-29 | CT | Futures | 93.43 | 94.11 | 93.22 | 93.7 | 5981.0 |
| 2012-10-29 | DC | Futures | 30.95 | 30.95 | 30.37 | 30.48 | 215.0 |
| 2012-10-29 | DX | Futures | 77.562 | 77.901 | 77.562 | 77.797 | 11538.0 |
| 2012-10-29 | E1 | Futures | 1.37891 | 1.37891 | 1.37312 | 1.37544 | 14418.0 |
| 2012-10-29 | E6 | Futures | 1.52497 | 1.52497 | 1.5179 | 1.52026 | 121660.0 |
| 2012-10-29 | E7 | Futures | 1.5157 | 1.5157 | 1.5088 | 1.5112 | 2177.0 |
| 2012-10-29 | ED | Futures | 95.2396 | 95.2396 | 95.2205 | 95.2253 | 103641.0 |
| 2012-10-29 | ER | Futures | 97.871 | 97.876 | 97.866 | 97.871 | 76840.0 |
| 2012-10-29 | EW | Futures | 992.1 | 992.1 | 980.8 | 992.0 | 980.0 |
| 2012-10-29 | FBTP | Futures | 72.41 | 72.41 | 71.94 | 71.98 | 16202.0 |
| 2012-10-29 | FBTS | Futures | 89.533 | 89.533 | 89.441 | 89.458 | 2386.0 |
| 2012-10-29 | FCE | Futures | 2577.2 | 2578.3 | 2550.1 | 2560.3 | 51183.0 |
| 2012-10-29 | FDAX | Futures | 7917.5 | 7918.6 | 7857.8 | 7895.1 | 59881.0 |
| 2012-10-29 | FESX | Futures | 1693.3 | 1693.3 | 1677.0 | 1683.8 | 477809.0 |
| 2012-10-29 | FGBL | Futures | 117.89 | 118.58 | 117.87 | 118.43 | 475667.0 |
| 2012-10-29 | FGBM | Futures | 116.25 | 116.49 | 116.2 | 116.41 | 327662.0 |
| 2012-10-29 | FGBS | Futures | 110.343 | 110.397 | 110.338 | 110.372 | 302209.0 |
| 2012-10-29 | FGBX | Futures | 123.46 | 125.32 | 123.46 | 125.09 | 7308.0 |
| 2012-10-29 | FOAT | Futures | 103.56 | 103.71 | 103.39 | 103.58 | 28896.0 |
| 2012-10-29 | FTDX | Futures | 751.4 | 752.8 | 748.1 | 751.4 | 63.0 |
| 2012-10-29 | FTI | Futures | 281.41 | 281.71 | 279.65 | 280.89 | 13987.0 |
| 2012-10-29 | FTUK | Futures | 4230.3 | 4238.4 | 4201.1 | 4224.1 | 43570.0 |
| 2012-10-29 | FVSA | Futures | 5229.11 | 5285.58 | 5195.23 | 5217.82 | 1287.0 |
| 2012-10-29 | FXXP | Futures | 193.9 | 194.5 | 193.5 | 193.9 | 1618.0 |
| 2012-10-29 | G | Futures | 98.37 | 98.86 | 98.37 | 98.81 | 88343.0 |
| 2012-10-29 | GF | Futures | 278.627 | 280.595 | 277.427 | 280.211 | 1789.0 |
| 2012-10-29 | GSCI | Futures | 1031.02 | 1034.58 | 1025.61 | 1025.61 | 119.0 |
| 2012-10-29 | HE | Futures | 97.699 | 97.699 | 95.492 | 96.704 | 17377.0 |
| 2012-10-29 | HG | Futures | 4.5762 | 4.5781 | 4.4747 | 4.4907 | 33556.0 |
| 2012-10-29 | HH | Futures | 44.248 | 44.248 | 44.248 | 44.248 | 150.0 |
| 2012-10-29 | HO | Futures | 2.494 | 2.5294 | 2.4916 | 2.5023 | 62408.0 |
| 2012-10-29 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-10-29 | J1 | Futures | 0.0157253 | 0.0157479 | 0.0156865 | 0.0156915 | 62549.0 |
| 2012-10-29 | J7 | Futures | 0.015659 | 0.015681 | 0.01562 | 0.015625 | 253.0 |
> showing 50 of 94 rows — these rows as CSV