PREVIEW / futures_daily / 2012-05-08
file: by_date/futures_daily/2012/2012-05-08.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-05-08 | ES | Futures | 1375.78 | 1378.56 | 1354.12 | 1368.98 | 2307638.0 |
| 2012-05-08 | NQ | Futures | 3020.98 | 3026.71 | 2959.68 | 3004.94 | 328108.0 |
| 2012-05-08 | YM | Futures | 12598.6 | 12618.1 | 12404.1 | 12513.0 | 172626.0 |
| 2012-05-08 | CL | Futures | 179.7 | 179.99 | 175.22 | 177.95 | 333767.0 |
| 2012-05-08 | GC | Futures | 2190.9 | 2191.7 | 2132.9 | 2144.9 | 218708.0 |
| 2012-05-08 | ZN | Futures | 114.923916 | 115.343594 | 114.883302 | 115.1676 | 1024459.0 |
| 2012-05-08 | A6 | Futures | 0.91412 | 0.91547 | 0.90387 | 0.90702 | 154508.0 |
| 2012-05-08 | AD | Futures | 1.01245 | 1.01296 | 1.00289 | 1.00672 | 100719.0 |
| 2012-05-08 | B | Futures | 102.04 | 102.41 | 99.74 | 101.63 | 152609.0 |
| 2012-05-08 | B6 | Futures | 1.6991 | 1.6998 | 1.6917 | 1.6962 | 102064.0 |
| 2012-05-08 | BFX | Futures | 2675.2 | 2680.9 | 2639.1 | 2640.1 | 55.0 |
| 2012-05-08 | BR | Futures | 0.24445 | 0.24514 | 0.24445 | 0.24514 | 163.0 |
| 2012-05-08 | BZ | Futures | 108.87 | 108.89 | 106.33 | 108.3 | 2686.0 |
| 2012-05-08 | C | Futures | 1537.0 | 1550.0 | 1522.0 | 1540.0 | 2218.0 |
| 2012-05-08 | CB | Futures | 70.643 | 70.777 | 70.508 | 70.777 | 15.0 |
| 2012-05-08 | CC | Futures | 1763.0 | 1772.0 | 1725.0 | 1754.0 | 10367.0 |
| 2012-05-08 | CSC | Futures | 3.405 | 3.41 | 3.371 | 3.375 | 27.0 |
| 2012-05-08 | CT | Futures | 105.83 | 106.98 | 105.28 | 105.43 | 14384.0 |
| 2012-05-08 | DC | Futures | 23.48 | 23.68 | 23.23 | 23.38 | 194.0 |
| 2012-05-08 | DX | Futures | 77.201 | 77.584 | 77.191 | 77.365 | 25491.0 |
| 2012-05-08 | E1 | Futures | 1.42342 | 1.42421 | 1.4157 | 1.42067 | 46934.0 |
| 2012-05-08 | E6 | Futures | 1.55928 | 1.55988 | 1.54997 | 1.55546 | 273862.0 |
| 2012-05-08 | E7 | Futures | 1.5443 | 1.545 | 1.5351 | 1.5405 | 3424.0 |
| 2012-05-08 | ED | Futures | 95.0693 | 95.0693 | 95.0454 | 95.0597 | 240266.0 |
| 2012-05-08 | ER | Futures | 97.577 | 97.582 | 97.548 | 97.553 | 142481.0 |
| 2012-05-08 | EW | Futures | 978.1 | 980.6 | 957.9 | 975.9 | 38098.0 |
| 2012-05-08 | FBTP | Futures | 67.09 | 67.35 | 66.56 | 66.76 | 17246.0 |
| 2012-05-08 | FBTS | Futures | 85.681 | 85.811 | 85.591 | 85.64 | 2006.0 |
| 2012-05-08 | FCE | Futures | 2296.2 | 2298.4 | 2226.9 | 2237.3 | 166274.0 |
| 2012-05-08 | FDAX | Futures | 7266.6 | 7276.0 | 7093.1 | 7124.6 | 172560.0 |
| 2012-05-08 | FESX | Futures | 1549.5 | 1552.3 | 1511.5 | 1517.1 | 1478269.0 |
| 2012-05-08 | FGBL | Futures | 116.39 | 116.96 | 116.37 | 116.89 | 638729.0 |
| 2012-05-08 | FGBM | Futures | 115.07 | 115.35 | 115.05 | 115.31 | 450242.0 |
| 2012-05-08 | FGBS | Futures | 110.193 | 110.218 | 110.178 | 110.208 | 370197.0 |
| 2012-05-08 | FGBX | Futures | 121.96 | 122.72 | 121.53 | 122.55 | 5728.0 |
| 2012-05-08 | FOAT | Futures | 96.13 | 96.74 | 96.13 | 96.25 | 16503.0 |
| 2012-05-08 | FTDX | Futures | 734.9 | 741.5 | 720.9 | 723.7 | 239.0 |
| 2012-05-08 | FTI | Futures | 264.2 | 264.33 | 258.78 | 259.52 | 42911.0 |
| 2012-05-08 | FTUK | Futures | 4108.2 | 4111.5 | 4022.5 | 4028.4 | 141158.0 |
| 2012-05-08 | FVSA | Futures | 9507.38 | 10003.41 | 9408.17 | 9871.14 | 3532.0 |
| 2012-05-08 | FXXP | Futures | 182.9 | 183.2 | 180.0 | 180.1 | 5626.0 |
| 2012-05-08 | G | Futures | 96.11 | 96.57 | 96.01 | 96.52 | 128125.0 |
| 2012-05-08 | GF | Futures | 318.54 | 318.644 | 315.051 | 315.312 | 2757.0 |
| 2012-05-08 | GSCI | Futures | 1029.01 | 1033.61 | 1018.37 | 1029.01 | 1721.0 |
| 2012-05-08 | HE | Futures | 89.766 | 90.539 | 89.072 | 89.926 | 28434.0 |
| 2012-05-08 | HG | Futures | 4.9313 | 4.9313 | 4.7886 | 4.8161 | 59751.0 |
| 2012-05-08 | HO | Futures | 2.453 | 2.4661 | 2.4152 | 2.458 | 64631.0 |
| 2012-05-08 | HRC | Futures | 2609.8 | 2609.8 | 2609.8 | 2609.8 | 0.0 |
| 2012-05-08 | J1 | Futures | 0.0156974 | 0.0157363 | 0.0156623 | 0.0157175 | 67353.0 |
| 2012-05-08 | J7 | Futures | 0.01562 | 0.01566 | 0.01559 | 0.015643 | 389.0 |
> showing 50 of 98 rows — these rows as CSV