PREVIEW / futures_daily / 2012-01-13
file: by_date/futures_daily/2012/2012-01-13.parquet size: 9 KB rows: 98
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-01-13 | ES | Futures | 1296.61 | 1299.62 | 1277.29 | 1293.6 | 2115831.0 |
| 2012-01-13 | NQ | Futures | 2719.47 | 2729.48 | 2685.74 | 2714.33 | 199235.0 |
| 2012-01-13 | YM | Futures | 12004.3 | 12030.4 | 11844.7 | 11982.1 | 113712.0 |
| 2012-01-13 | CL | Futures | 185.4 | 187.25 | 182.59 | 184.46 | 335624.0 |
| 2012-01-13 | GC | Futures | 2227.5 | 2228.7 | 2194.9 | 2201.8 | 177525.0 |
| 2012-01-13 | ZN | Futures | 113.192258 | 113.840383 | 113.111242 | 113.678351 | 996999.0 |
| 2012-01-13 | A6 | Futures | 0.91271 | 0.91609 | 0.90399 | 0.90969 | 125038.0 |
| 2012-01-13 | AD | Futures | 0.98385 | 0.98626 | 0.97472 | 0.97913 | 76962.0 |
| 2012-01-13 | B | Futures | 98.99 | 100.03 | 97.76 | 98.34 | 229345.0 |
| 2012-01-13 | B6 | Futures | 1.6024 | 1.6099 | 1.5913 | 1.5987 | 98304.0 |
| 2012-01-13 | BR | Futures | 0.26012 | 0.26012 | 0.25745 | 0.25883 | 78.0 |
| 2012-01-13 | BZ | Futures | 105.41 | 105.41 | 103.8 | 104.37 | 801.0 |
| 2012-01-13 | C | Futures | 1525.0 | 1550.0 | 1514.0 | 1540.0 | 11318.0 |
| 2012-01-13 | CB | Futures | 89.212 | 89.212 | 89.212 | 89.212 | 6.0 |
| 2012-01-13 | CC | Futures | 1783.0 | 1783.0 | 1731.0 | 1759.0 | 11619.0 |
| 2012-01-13 | CSC | Futures | 4.0 | 4.0 | 3.995 | 3.995 | 4.0 |
| 2012-01-13 | CT | Futures | 123.06 | 123.62 | 121.74 | 122.96 | 9745.0 |
| 2012-01-13 | DC | Futures | 29.79 | 29.87 | 29.08 | 29.18 | 602.0 |
| 2012-01-13 | DX | Futures | 78.897 | 79.856 | 78.581 | 79.608 | 26245.0 |
| 2012-01-13 | E1 | Futures | 1.39152 | 1.39677 | 1.37209 | 1.37747 | 32977.0 |
| 2012-01-13 | E6 | Futures | 1.53178 | 1.54003 | 1.50931 | 1.51469 | 400353.0 |
| 2012-01-13 | E7 | Futures | 1.518 | 1.5258 | 1.4956 | 1.5008 | 6147.0 |
| 2012-01-13 | EBM | Futures | 255.19 | 262.4 | 255.19 | 258.14 | 10229.0 |
| 2012-01-13 | ED | Futures | 95.0725 | 95.1059 | 95.0438 | 95.0725 | 501842.0 |
| 2012-01-13 | ER | Futures | 97.371 | 97.425 | 97.361 | 97.39 | 232147.0 |
| 2012-01-13 | EW | Futures | 916.5 | 919.9 | 902.5 | 913.3 | 19604.0 |
| 2012-01-13 | FBTP | Futures | 59.66 | 60.48 | 58.81 | 59.54 | 17657.0 |
| 2012-01-13 | FBTS | Futures | 81.551 | 82.281 | 80.852 | 81.382 | 3259.0 |
| 2012-01-13 | FCE | Futures | 2292.5 | 2309.6 | 2245.5 | 2276.1 | 4419.0 |
| 2012-01-13 | FDAX | Futures | 6888.7 | 6918.0 | 6699.9 | 6774.4 | 182827.0 |
| 2012-01-13 | FESX | Futures | 1575.8 | 1583.1 | 1537.7 | 1555.7 | 1274191.0 |
| 2012-01-13 | FEU3 | Futures | 97.935 | 97.949 | 97.935 | 97.949 | 100.0 |
| 2012-01-13 | FGBL | Futures | 112.49 | 113.48 | 112.27 | 113.25 | 821033.0 |
| 2012-01-13 | FGBM | Futures | 113.25 | 113.75 | 113.17 | 113.64 | 370702.0 |
| 2012-01-13 | FGBS | Futures | 109.874 | 109.964 | 109.849 | 109.939 | 511686.0 |
| 2012-01-13 | FGBX | Futures | 117.85 | 120.4 | 117.53 | 119.83 | 9761.0 |
| 2012-01-13 | FTDX | Futures | 673.9 | 673.9 | 658.6 | 664.6 | 84.0 |
| 2012-01-13 | FTI | Futures | 260.89 | 260.89 | 255.78 | 258.04 | 1955.0 |
| 2012-01-13 | FTUK | Futures | 4079.2 | 4088.9 | 3995.5 | 4026.5 | 110798.0 |
| 2012-01-13 | FVSA | Futures | 11331.72 | 12215.21 | 11197.27 | 12099.97 | 14119.0 |
| 2012-01-13 | FXXP | Futures | 177.1 | 177.1 | 174.0 | 175.3 | 2134.0 |
| 2012-01-13 | G | Futures | 94.41 | 95.18 | 94.39 | 95.04 | 114237.0 |
| 2012-01-13 | GF | Futures | 321.5 | 323.992 | 320.864 | 323.144 | 3003.0 |
| 2012-01-13 | GSCI | Futures | 1022.05 | 1024.01 | 1014.46 | 1020.02 | 2000.0 |
| 2012-01-13 | HE | Futures | 103.894 | 105.804 | 103.739 | 105.527 | 32035.0 |
| 2012-01-13 | HG | Futures | 4.8011 | 4.8658 | 4.7207 | 4.7972 | 56132.0 |
| 2012-01-13 | HO | Futures | 2.4671 | 2.4864 | 2.4416 | 2.4441 | 33065.0 |
| 2012-01-13 | HRC | Futures | 2876.8 | 2876.8 | 2876.8 | 2876.8 | 0.0 |
| 2012-01-13 | J1 | Futures | 0.0163611 | 0.0163912 | 0.0162895 | 0.0163285 | 61546.0 |
| 2012-01-13 | J7 | Futures | 0.016297 | 0.016321 | 0.016223 | 0.016261 | 296.0 |
> showing 50 of 98 rows — these rows as CSV