PREVIEW / futures_daily / 2012-12-03
file: by_date/futures_daily/2012/2012-12-03.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-12-03 | ES | Futures | 1438.38 | 1449.32 | 1429.48 | 1432.02 | 1652126.0 |
| 2012-12-03 | NQ | Futures | 3079.04 | 3104.93 | 3067.82 | 3072.13 | 219674.0 |
| 2012-12-03 | YM | Futures | 12697.3 | 12772.5 | 12626.0 | 12645.6 | 121995.0 |
| 2012-12-03 | CL | Futures | 159.09 | 161.74 | 158.75 | 159.52 | 235987.0 |
| 2012-12-03 | GC | Futures | 2286.1 | 2298.6 | 2284.4 | 2293.6 | 104840.0 |
| 2012-12-03 | ZN | Futures | 117.823871 | 117.892541 | 117.576659 | 117.755201 | 105659.0 |
| 2012-12-03 | A6 | Futures | 0.94662 | 0.94825 | 0.94344 | 0.94553 | 103840.0 |
| 2012-12-03 | AD | Futures | 1.00981 | 1.01202 | 1.0081 | 1.0086 | 81752.0 |
| 2012-12-03 | B | Futures | 102.74 | 103.83 | 102.28 | 102.59 | 109768.0 |
| 2012-12-03 | B6 | Futures | 1.6732 | 1.6832 | 1.673 | 1.6808 | 125327.0 |
| 2012-12-03 | BFX | Futures | 2959.7 | 2963.5 | 2944.7 | 2951.0 | 19.0 |
| 2012-12-03 | BR | Futures | 0.22803 | 0.23005 | 0.22803 | 0.2287 | 148.0 |
| 2012-12-03 | BZ | Futures | 106.25 | 106.63 | 105.38 | 105.69 | 637.0 |
| 2012-12-03 | C | Futures | 1625.0 | 1627.0 | 1602.0 | 1625.0 | 3140.0 |
| 2012-12-03 | CB | Futures | 86.882 | 87.052 | 86.882 | 86.882 | 2.0 |
| 2012-12-03 | CC | Futures | 1879.0 | 1928.0 | 1870.0 | 1900.0 | 16675.0 |
| 2012-12-03 | CSC | Futures | 3.971 | 3.971 | 3.967 | 3.967 | 12.0 |
| 2012-12-03 | CT | Futures | 93.02 | 93.65 | 92.54 | 93.1 | 14093.0 |
| 2012-12-03 | DC | Futures | 29.72 | 29.8 | 29.48 | 29.61 | 46.0 |
| 2012-12-03 | DX | Futures | 77.678 | 77.697 | 77.276 | 77.365 | 23558.0 |
| 2012-12-03 | E1 | Futures | 1.38767 | 1.39307 | 1.38741 | 1.39076 | 31182.0 |
| 2012-12-03 | E6 | Futures | 1.53027 | 1.54004 | 1.52968 | 1.5378 | 273625.0 |
| 2012-12-03 | E7 | Futures | 1.5212 | 1.5307 | 1.5205 | 1.5286 | 3227.0 |
| 2012-12-03 | ED | Futures | 95.2301 | 95.2325 | 95.2301 | 95.2325 | 37221.0 |
| 2012-12-03 | ER | Futures | 97.871 | 97.881 | 97.871 | 97.876 | 77283.0 |
| 2012-12-03 | EW | Futures | 1017.9 | 1027.3 | 1013.2 | 1015.8 | 25916.0 |
| 2012-12-03 | FBTP | Futures | 75.15 | 75.93 | 74.99 | 75.44 | 45921.0 |
| 2012-12-03 | FBTS | Futures | 90.605 | 90.806 | 90.58 | 90.714 | 6216.0 |
| 2012-12-03 | FCE | Futures | 2690.8 | 2715.3 | 2680.2 | 2687.0 | 99348.0 |
| 2012-12-03 | FDAX | Futures | 8138.8 | 8204.6 | 8125.7 | 8146.0 | 123079.0 |
| 2012-12-03 | FESX | Futures | 1758.0 | 1775.0 | 1751.2 | 1756.6 | 828826.0 |
| 2012-12-03 | FGBL | Futures | 119.42 | 119.56 | 118.74 | 119.1 | 1261818.0 |
| 2012-12-03 | FGBM | Futures | 116.95 | 117.02 | 116.57 | 116.75 | 816282.0 |
| 2012-12-03 | FGBS | Futures | 110.457 | 110.472 | 110.363 | 110.412 | 738234.0 |
| 2012-12-03 | FGBX | Futures | 126.06 | 126.63 | 124.52 | 125.53 | 32380.0 |
| 2012-12-03 | FOAT | Futures | 105.45 | 105.65 | 105.39 | 105.47 | 90482.0 |
| 2012-12-03 | FTDX | Futures | 793.8 | 798.5 | 792.4 | 793.3 | 71.0 |
| 2012-12-03 | FTI | Futures | 289.55 | 292.08 | 288.65 | 289.3 | 26123.0 |
| 2012-12-03 | FTUK | Futures | 4302.8 | 4320.7 | 4286.3 | 4299.5 | 76484.0 |
| 2012-12-03 | FVSA | Futures | 4047.44 | 4116.43 | 3978.45 | 4081.93 | 13386.0 |
| 2012-12-03 | FXXP | Futures | 199.3 | 200.6 | 199.1 | 199.4 | 4807.0 |
| 2012-12-03 | G | Futures | 99.22 | 99.28 | 98.66 | 98.78 | 145499.0 |
| 2012-12-03 | GF | Futures | 275.238 | 276.614 | 274.859 | 276.282 | 1551.0 |
| 2012-12-03 | GSCI | Futures | 1046.34 | 1060.38 | 1046.34 | 1048.36 | 432.0 |
| 2012-12-03 | HE | Futures | 99.986 | 100.732 | 98.265 | 98.322 | 27448.0 |
| 2012-12-03 | HG | Futures | 4.6782 | 4.7096 | 4.6737 | 4.6981 | 43678.0 |
| 2012-12-03 | HH | Futures | 42.007 | 42.511 | 42.007 | 42.159 | 493.0 |
| 2012-12-03 | HO | Futures | 2.4766 | 2.4968 | 2.46 | 2.4678 | 17851.0 |
| 2012-12-03 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-12-03 | J1 | Futures | 0.0151982 | 0.0152708 | 0.0151757 | 0.0152283 | 101332.0 |
> showing 50 of 100 rows — these rows as CSV