PREVIEW / futures_daily / 2012-02-02
file: by_date/futures_daily/2012/2012-02-02.parquet size: 9 KB rows: 99
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-02-02 | ES | Futures | 1324.96 | 1330.73 | 1321.7 | 1327.47 | 1357576.0 |
| 2012-02-02 | NQ | Futures | 2845.84 | 2859.85 | 2835.55 | 2849.27 | 191477.0 |
| 2012-02-02 | YM | Futures | 12239.3 | 12282.8 | 12206.4 | 12249.0 | 80637.0 |
| 2012-02-02 | CL | Futures | 181.49 | 183.13 | 178.37 | 180.09 | 331240.0 |
| 2012-02-02 | GC | Futures | 2339.9 | 2362.2 | 2334.5 | 2355.9 | 142034.0 |
| 2012-02-02 | ZN | Futures | 114.096932 | 114.285968 | 113.961906 | 114.218455 | 964913.0 |
| 2012-02-02 | A6 | Futures | 0.94813 | 0.95267 | 0.94573 | 0.9484 | 107812.0 |
| 2012-02-02 | AD | Futures | 1.00493 | 1.00583 | 1.00162 | 1.00342 | 63671.0 |
| 2012-02-02 | B | Futures | 98.98 | 99.85 | 98.61 | 99.47 | 114871.0 |
| 2012-02-02 | B6 | Futures | 1.6552 | 1.6573 | 1.6506 | 1.6514 | 79429.0 |
| 2012-02-02 | BFX | Futures | 2730.2 | 2731.4 | 2727.8 | 2729.2 | 67.0 |
| 2012-02-02 | BR | Futures | 0.26852 | 0.27039 | 0.26852 | 0.27009 | 113.0 |
| 2012-02-02 | BZ | Futures | 106.21 | 106.32 | 105.16 | 106.01 | 768.0 |
| 2012-02-02 | C | Futures | 1475.0 | 1495.0 | 1470.0 | 1477.0 | 4740.0 |
| 2012-02-02 | CB | Futures | 82.887 | 82.887 | 82.215 | 82.618 | 10.0 |
| 2012-02-02 | CC | Futures | 1732.0 | 1748.0 | 1713.0 | 1725.0 | 14011.0 |
| 2012-02-02 | CSC | Futures | 3.83 | 3.83 | 3.783 | 3.783 | 17.0 |
| 2012-02-02 | CT | Futures | 120.29 | 122.2 | 119.38 | 121.34 | 12477.0 |
| 2012-02-02 | DC | Futures | 27.05 | 27.29 | 26.36 | 26.55 | 751.0 |
| 2012-02-02 | DX | Futures | 76.799 | 77.199 | 76.736 | 76.999 | 19622.0 |
| 2012-02-02 | E1 | Futures | 1.43602 | 1.43851 | 1.42643 | 1.4326 | 31047.0 |
| 2012-02-02 | E6 | Futures | 1.57409 | 1.57756 | 1.56417 | 1.57098 | 294235.0 |
| 2012-02-02 | E7 | Futures | 1.5599 | 1.563 | 1.5499 | 1.5566 | 5054.0 |
| 2012-02-02 | EBM | Futures | 282.38 | 283.69 | 278.78 | 282.71 | 10090.0 |
| 2012-02-02 | ED | Futures | 95.1202 | 95.1393 | 95.1154 | 95.1298 | 167789.0 |
| 2012-02-02 | ER | Futures | 97.489 | 97.499 | 97.469 | 97.474 | 111127.0 |
| 2012-02-02 | EW | Futures | 958.5 | 966.1 | 957.5 | 960.6 | 17807.0 |
| 2012-02-02 | FBTP | Futures | 64.47 | 64.78 | 63.64 | 64.66 | 19052.0 |
| 2012-02-02 | FBTS | Futures | 84.304 | 84.545 | 84.031 | 84.489 | 1380.0 |
| 2012-02-02 | FCE | Futures | 2400.0 | 2420.7 | 2385.1 | 2402.9 | 73030.0 |
| 2012-02-02 | FDAX | Futures | 7331.5 | 7373.5 | 7299.5 | 7356.9 | 139214.0 |
| 2012-02-02 | FESX | Futures | 1656.7 | 1666.0 | 1646.0 | 1657.3 | 967989.0 |
| 2012-02-02 | FEU3 | Futures | 98.043 | 98.043 | 98.028 | 98.028 | 100.0 |
| 2012-02-02 | FGBL | Futures | 112.52 | 113.13 | 112.39 | 112.55 | 759514.0 |
| 2012-02-02 | FGBM | Futures | 113.44 | 113.71 | 113.3 | 113.37 | 427246.0 |
| 2012-02-02 | FGBS | Futures | 109.919 | 109.954 | 109.854 | 109.864 | 403279.0 |
| 2012-02-02 | FGBX | Futures | 117.38 | 118.47 | 116.53 | 117.03 | 6227.0 |
| 2012-02-02 | FTDX | Futures | 701.3 | 706.4 | 701.3 | 705.0 | 154.0 |
| 2012-02-02 | FTI | Futures | 271.69 | 271.89 | 268.63 | 269.55 | 32758.0 |
| 2012-02-02 | FTUK | Futures | 4144.1 | 4164.6 | 4127.5 | 4147.0 | 91803.0 |
| 2012-02-02 | FVSA | Futures | 9987.28 | 10140.93 | 9910.45 | 9929.66 | 2768.0 |
| 2012-02-02 | FXXP | Futures | 183.6 | 183.7 | 182.9 | 183.6 | 5506.0 |
| 2012-02-02 | G | Futures | 94.55 | 94.71 | 93.94 | 94.15 | 170268.0 |
| 2012-02-02 | GF | Futures | 330.248 | 330.248 | 328.658 | 329.506 | 2565.0 |
| 2012-02-02 | GSCI | Futures | 1030.97 | 1033.47 | 1022.6 | 1029.4 | 19.0 |
| 2012-02-02 | HE | Futures | 109.187 | 109.701 | 108.19 | 108.462 | 17835.0 |
| 2012-02-02 | HG | Futures | 5.0518 | 5.0794 | 4.9693 | 4.9871 | 51316.0 |
| 2012-02-02 | HO | Futures | 2.4683 | 2.484 | 2.4513 | 2.4706 | 61641.0 |
| 2012-02-02 | HRC | Futures | 2837.4 | 2837.4 | 2837.4 | 2837.4 | 0.0 |
| 2012-02-02 | J1 | Futures | 0.0164842 | 0.0165193 | 0.0164766 | 0.0164917 | 50822.0 |
> showing 50 of 99 rows — these rows as CSV