PREVIEW / futures_daily / 2012-12-20
file: by_date/futures_daily/2012/2012-12-20.parquet size: 9 KB rows: 101
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-20 | ES | Futures | 1462.15 | 1474.68 | 1460.36 | 1473.91 | 1647010.0 |
| 2012-12-20 | NQ | Futures | 3100.44 | 3116.88 | 3089.2 | 3102.75 | 243345.0 |
| 2012-12-20 | YM | Futures | 12928.2 | 13012.5 | 12904.6 | 13009.6 | 125615.0 |
| 2012-12-20 | CL | Futures | 159.19 | 160.69 | 158.42 | 159.97 | 178144.0 |
| 2012-12-20 | GC | Futures | 2222.7 | 2229.2 | 2180.2 | 2193.4 | 189984.0 |
| 2012-12-20 | ZN | Futures | 116.569645 | 116.762595 | 116.528298 | 116.569645 | 957300.0 |
| 2012-12-20 | A6 | Futures | 0.95271 | 0.95472 | 0.95115 | 0.95326 | 75078.0 |
| 2012-12-20 | AD | Futures | 1.01192 | 1.01402 | 1.01122 | 1.01372 | 63500.0 |
| 2012-12-20 | B | Futures | 102.67 | 103.19 | 102.29 | 102.76 | 136538.0 |
| 2012-12-20 | B6 | Futures | 1.6977 | 1.7027 | 1.6971 | 1.7011 | 96456.0 |
| 2012-12-20 | BFX | Futures | 3012.3 | 3029.1 | 3010.3 | 3010.6 | 174.0 |
| 2012-12-20 | BR | Futures | 0.23591 | 0.23615 | 0.2349 | 0.23615 | 298.0 |
| 2012-12-20 | BZ | Futures | 105.74 | 106.28 | 105.41 | 105.86 | 473.0 |
| 2012-12-20 | C | Futures | 1587.0 | 1592.0 | 1562.0 | 1577.0 | 13537.0 |
| 2012-12-20 | CB | Futures | 86.4 | 86.661 | 85.879 | 85.879 | 17.0 |
| 2012-12-20 | CC | Futures | 1780.0 | 1789.0 | 1744.0 | 1756.0 | 16389.0 |
| 2012-12-20 | CSC | Futures | 3.918 | 3.918 | 3.871 | 3.879 | 10.0 |
| 2012-12-20 | CT | Futures | 95.35 | 95.5 | 94.45 | 95.43 | 10544.0 |
| 2012-12-20 | DC | Futures | 29.27 | 29.27 | 28.82 | 28.93 | 265.0 |
| 2012-12-20 | DX | Futures | 76.581 | 76.605 | 76.253 | 76.49 | 21973.0 |
| 2012-12-20 | E1 | Futures | 1.40981 | 1.41933 | 1.40891 | 1.41393 | 26939.0 |
| 2012-12-20 | E6 | Futures | 1.55894 | 1.56955 | 1.55823 | 1.56295 | 204854.0 |
| 2012-12-20 | E7 | Futures | 1.5483 | 1.5588 | 1.5476 | 1.5523 | 5623.0 |
| 2012-12-20 | EBM | Futures | 279.23 | 280.07 | 272.84 | 276.17 | 30345.0 |
| 2012-12-20 | ED | Futures | 95.2199 | 95.2247 | 95.2151 | 95.2151 | 107678.0 |
| 2012-12-20 | ER | Futures | 97.847 | 97.847 | 97.837 | 97.842 | 43614.0 |
| 2012-12-20 | EW | Futures | 1039.5 | 1050.0 | 1038.7 | 1049.4 | 19377.0 |
| 2012-12-20 | FBTP | Futures | 75.7 | 75.88 | 75.59 | 75.7 | 15994.0 |
| 2012-12-20 | FBTS | Futures | 90.9 | 91.103 | 90.9 | 91.019 | 1947.0 |
| 2012-12-20 | FCE | Futures | 2755.6 | 2776.4 | 2752.3 | 2764.7 | 78437.0 |
| 2012-12-20 | FDAX | Futures | 8360.6 | 8414.1 | 8350.2 | 8390.1 | 78334.0 |
| 2012-12-20 | FESX | Futures | 1798.8 | 1817.9 | 1797.5 | 1809.7 | 767893.0 |
| 2012-12-20 | FEU3 | Futures | 98.453 | 98.453 | 98.448 | 98.448 | 4.0 |
| 2012-12-20 | FGBL | Futures | 119.18 | 119.44 | 119.16 | 119.29 | 425826.0 |
| 2012-12-20 | FGBM | Futures | 117.02 | 117.21 | 117.02 | 117.1 | 269534.0 |
| 2012-12-20 | FGBS | Futures | 110.482 | 110.532 | 110.472 | 110.487 | 174032.0 |
| 2012-12-20 | FGBX | Futures | 125.82 | 126.95 | 125.67 | 126.53 | 8047.0 |
| 2012-12-20 | FOAT | Futures | 106.0 | 106.22 | 105.93 | 106.12 | 24230.0 |
| 2012-12-20 | FTDX | Futures | 791.5 | 796.2 | 791.5 | 795.7 | 1214.0 |
| 2012-12-20 | FTI | Futures | 296.25 | 299.04 | 296.12 | 298.14 | 14999.0 |
| 2012-12-20 | FTUK | Futures | 4352.7 | 4370.7 | 4342.4 | 4360.0 | 74620.0 |
| 2012-12-20 | FVSA | Futures | 3797.05 | 3878.27 | 3776.74 | 3878.27 | 9144.0 |
| 2012-12-20 | FXXP | Futures | 202.2 | 202.9 | 202.2 | 202.9 | 7055.0 |
| 2012-12-20 | G | Futures | 97.75 | 97.9 | 97.57 | 97.77 | 99635.0 |
| 2012-12-20 | GF | Futures | 291.13 | 291.794 | 288.189 | 288.948 | 1974.0 |
| 2012-12-20 | GSCI | Futures | 1037.03 | 1039.45 | 1031.8 | 1037.44 | 151.0 |
| 2012-12-20 | HE | Futures | 99.183 | 99.47 | 98.638 | 99.212 | 12690.0 |
| 2012-12-20 | HG | Futures | 4.632 | 4.6403 | 4.5241 | 4.5408 | 52103.0 |
| 2012-12-20 | HH | Futures | 40.645 | 40.645 | 40.645 | 40.645 | 2921.0 |
| 2012-12-20 | HO | Futures | 2.4285 | 2.4546 | 2.4247 | 2.4453 | 24576.0 |
> showing 50 of 101 rows — these rows as CSV