PREVIEW / futures_daily / 2012-06-08
file: by_date/futures_daily/2012/2012-06-08.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-06-08 | ES | Futures | 1326.41 | 1339.76 | 1315.57 | 1339.0 | 1334158.0 |
| 2012-06-08 | NQ | Futures | 2906.41 | 2937.91 | 2884.64 | 2935.91 | 131002.0 |
| 2012-06-08 | YM | Futures | 12131.8 | 12234.9 | 12043.3 | 12229.1 | 59482.0 |
| 2012-06-08 | CL | Futures | 153.27 | 155.17 | 150.28 | 154.13 | 304641.0 |
| 2012-06-08 | GC | Futures | 2125.9 | 2133.9 | 2080.6 | 2127.4 | 158606.0 |
| 2012-06-08 | ZN | Futures | 116.358942 | 116.94455 | 116.304467 | 116.345323 | 1229867.0 |
| 2012-06-08 | A6 | Futures | 0.88947 | 0.89388 | 0.88291 | 0.89046 | 152576.0 |
| 2012-06-08 | AD | Futures | 0.97865 | 0.98026 | 0.9713 | 0.97744 | 113385.0 |
| 2012-06-08 | B | Futures | 89.89 | 90.49 | 87.88 | 90.03 | 200331.0 |
| 2012-06-08 | B6 | Futures | 1.6302 | 1.6306 | 1.6167 | 1.6226 | 110496.0 |
| 2012-06-08 | BFX | Futures | 2542.1 | 2565.3 | 2540.2 | 2563.8 | 8.0 |
| 2012-06-08 | BR | Futures | 0.23093 | 0.23243 | 0.23033 | 0.23243 | 388.0 |
| 2012-06-08 | BZ | Futures | 94.61 | 95.92 | 93.74 | 95.72 | 4800.0 |
| 2012-06-08 | C | Futures | 1514.0 | 1544.0 | 1511.0 | 1529.0 | 4846.0 |
| 2012-06-08 | CC | Futures | 1646.0 | 1671.0 | 1628.0 | 1646.0 | 17226.0 |
| 2012-06-08 | CSC | Futures | 3.638 | 3.638 | 3.617 | 3.638 | 21.0 |
| 2012-06-08 | CT | Futures | 91.51 | 91.6 | 86.6 | 89.18 | 32823.0 |
| 2012-06-08 | DC | Futures | 26.34 | 26.53 | 26.09 | 26.52 | 124.0 |
| 2012-06-08 | DX | Futures | 79.72 | 80.364 | 79.71 | 79.993 | 30048.0 |
| 2012-06-08 | E1 | Futures | 1.37001 | 1.37079 | 1.35574 | 1.36359 | 54500.0 |
| 2012-06-08 | E6 | Futures | 1.49971 | 1.50114 | 1.48443 | 1.49303 | 312801.0 |
| 2012-06-08 | E7 | Futures | 1.4857 | 1.4866 | 1.4702 | 1.4787 | 2681.0 |
| 2012-06-08 | ED | Futures | 95.0693 | 95.074 | 95.0693 | 95.0693 | 76499.0 |
| 2012-06-08 | ER | Futures | 97.533 | 97.538 | 97.528 | 97.533 | 47484.0 |
| 2012-06-08 | EW | Futures | 930.6 | 938.2 | 920.4 | 937.5 | 26796.0 |
| 2012-06-08 | FBTP | Futures | 66.03 | 66.28 | 65.66 | 65.87 | 15147.0 |
| 2012-06-08 | FBTS | Futures | 84.484 | 84.765 | 84.484 | 84.567 | 1459.0 |
| 2012-06-08 | FCE | Futures | 2234.7 | 2260.5 | 2220.7 | 2246.1 | 126290.0 |
| 2012-06-08 | FDAX | Futures | 6737.1 | 6822.3 | 6690.7 | 6770.8 | 179845.0 |
| 2012-06-08 | FESX | Futures | 1463.9 | 1489.4 | 1454.9 | 1478.4 | 1611758.0 |
| 2012-06-08 | FEU3 | Futures | 98.108 | 98.108 | 98.108 | 98.108 | 16.0 |
| 2012-06-08 | FGBL | Futures | 118.45 | 119.09 | 118.33 | 118.55 | 859679.0 |
| 2012-06-08 | FGBM | Futures | 115.77 | 116.03 | 115.67 | 115.85 | 459514.0 |
| 2012-06-08 | FGBS | Futures | 110.298 | 110.338 | 110.253 | 110.308 | 376398.0 |
| 2012-06-08 | FGBX | Futures | 130.27 | 131.47 | 130.0 | 130.4 | 8147.0 |
| 2012-06-08 | FOAT | Futures | 98.91 | 99.25 | 98.63 | 99.11 | 12776.0 |
| 2012-06-08 | FTDX | Futures | 697.5 | 697.5 | 686.2 | 696.1 | 116.0 |
| 2012-06-08 | FTI | Futures | 252.45 | 254.1 | 250.41 | 252.97 | 35919.0 |
| 2012-06-08 | FTUK | Futures | 3977.3 | 3985.3 | 3925.8 | 3960.5 | 110570.0 |
| 2012-06-08 | FVSA | Futures | 10242.32 | 10242.32 | 9757.57 | 9773.21 | 713.0 |
| 2012-06-08 | FXXP | Futures | 174.7 | 175.7 | 173.6 | 175.5 | 1272.0 |
| 2012-06-08 | G | Futures | 98.59 | 99.52 | 98.58 | 99.07 | 135452.0 |
| 2012-06-08 | GF | Futures | 314.048 | 315.627 | 313.357 | 314.542 | 1883.0 |
| 2012-06-08 | GSCI | Futures | 923.7 | 938.54 | 922.2 | 937.19 | 1810.0 |
| 2012-06-08 | HE | Futures | 97.872 | 98.661 | 97.503 | 97.819 | 23046.0 |
| 2012-06-08 | HG | Futures | 4.4107 | 4.4114 | 4.2739 | 4.3021 | 74984.0 |
| 2012-06-08 | HO | Futures | 2.171 | 2.2014 | 2.1496 | 2.1927 | 33515.0 |
| 2012-06-08 | HRC | Futures | 2502.2 | 2502.2 | 2502.2 | 2502.2 | 0.0 |
| 2012-06-08 | J1 | Futures | 0.0157413 | 0.0158504 | 0.0157238 | 0.0157789 | 84266.0 |
| 2012-06-08 | J7 | Futures | 0.015656 | 0.015774 | 0.015651 | 0.015705 | 281.0 |
> showing 50 of 99 rows — these rows as CSV