PREVIEW / futures_daily / 2012-07-13
file: by_date/futures_daily/2012/2012-07-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-07-13 | ES | Futures | 1346.16 | 1370.46 | 1345.65 | 1368.94 | 1758931.0 |
| 2012-07-13 | NQ | Futures | 2912.45 | 2966.68 | 2912.45 | 2957.79 | 187072.0 |
| 2012-07-13 | YM | Futures | 12127.2 | 12343.5 | 12127.2 | 12332.9 | 116885.0 |
| 2012-07-13 | CL | Futures | 156.58 | 159.77 | 156.07 | 158.84 | 260828.0 |
| 2012-07-13 | GC | Futures | 2100.4 | 2134.2 | 2092.9 | 2128.2 | 129985.0 |
| 2012-07-13 | ZN | Futures | 117.380352 | 117.462064 | 117.107976 | 117.271401 | 595688.0 |
| 2012-07-13 | A6 | Futures | 0.90602 | 0.91447 | 0.90485 | 0.91384 | 136383.0 |
| 2012-07-13 | AD | Futures | 0.98225 | 0.98837 | 0.98125 | 0.98706 | 94853.0 |
| 2012-07-13 | B | Futures | 89.6 | 91.97 | 89.59 | 91.11 | 257048.0 |
| 2012-07-13 | B6 | Futures | 1.6124 | 1.6283 | 1.6106 | 1.6266 | 106882.0 |
| 2012-07-13 | BR | Futures | 0.23181 | 0.23324 | 0.23181 | 0.23238 | 38.0 |
| 2012-07-13 | BZ | Futures | 96.25 | 98.48 | 96.25 | 97.62 | 1544.0 |
| 2012-07-13 | C | Futures | 1542.0 | 1575.0 | 1542.0 | 1556.0 | 11733.0 |
| 2012-07-13 | CB | Futures | 86.924 | 86.924 | 86.79 | 86.79 | 14.0 |
| 2012-07-13 | CC | Futures | 1649.0 | 1689.0 | 1640.0 | 1670.0 | 12819.0 |
| 2012-07-13 | CSC | Futures | 3.975 | 4.045 | 3.975 | 4.042 | 38.0 |
| 2012-07-13 | CT | Futures | 91.95 | 94.7 | 91.95 | 94.53 | 145.0 |
| 2012-07-13 | DC | Futures | 29.31 | 30.03 | 29.25 | 29.99 | 370.0 |
| 2012-07-13 | DX | Futures | 81.391 | 81.469 | 80.93 | 81.021 | 23554.0 |
| 2012-07-13 | E1 | Futures | 1.31349 | 1.31943 | 1.30949 | 1.31775 | 40799.0 |
| 2012-07-13 | E6 | Futures | 1.44042 | 1.44702 | 1.4357 | 1.44513 | 227048.0 |
| 2012-07-13 | E7 | Futures | 1.432 | 1.4379 | 1.4268 | 1.4362 | 3289.0 |
| 2012-07-13 | ED | Futures | 95.18 | 95.1895 | 95.1608 | 95.1752 | 178358.0 |
| 2012-07-13 | ER | Futures | 97.724 | 97.754 | 97.719 | 97.744 | 181758.0 |
| 2012-07-13 | EW | Futures | 938.9 | 954.3 | 938.5 | 953.0 | 19703.0 |
| 2012-07-13 | FBTP | Futures | 65.37 | 65.6 | 64.74 | 64.93 | 26950.0 |
| 2012-07-13 | FBTS | Futures | 84.302 | 85.063 | 83.996 | 84.906 | 5557.0 |
| 2012-07-13 | FCE | Futures | 2343.5 | 2371.1 | 2335.0 | 2366.2 | 31888.0 |
| 2012-07-13 | FDAX | Futures | 7057.3 | 7181.2 | 7028.3 | 7143.0 | 115131.0 |
| 2012-07-13 | FESX | Futures | 1512.9 | 1529.8 | 1503.4 | 1521.7 | 923010.0 |
| 2012-07-13 | FEU3 | Futures | 98.32 | 98.325 | 98.32 | 98.325 | 50.0 |
| 2012-07-13 | FGBL | Futures | 119.72 | 119.9 | 119.37 | 119.53 | 475095.0 |
| 2012-07-13 | FGBM | Futures | 116.71 | 116.8 | 116.62 | 116.69 | 272300.0 |
| 2012-07-13 | FGBS | Futures | 110.497 | 110.527 | 110.492 | 110.507 | 225963.0 |
| 2012-07-13 | FGBX | Futures | 128.52 | 129.23 | 128.05 | 128.42 | 3952.0 |
| 2012-07-13 | FOAT | Futures | 101.49 | 101.88 | 101.35 | 101.53 | 15346.0 |
| 2012-07-13 | FTDX | Futures | 684.9 | 701.7 | 684.9 | 698.4 | 117.0 |
| 2012-07-13 | FTI | Futures | 267.14 | 267.14 | 263.9 | 266.29 | 604.0 |
| 2012-07-13 | FTUK | Futures | 4063.9 | 4106.8 | 4062.4 | 4086.5 | 71399.0 |
| 2012-07-13 | FVSA | Futures | 7385.61 | 7524.18 | 7247.04 | 7330.18 | 3927.0 |
| 2012-07-13 | FXXP | Futures | 181.3 | 183.2 | 181.2 | 183.0 | 1673.0 |
| 2012-07-13 | G | Futures | 100.29 | 100.33 | 99.91 | 100.03 | 87922.0 |
| 2012-07-13 | GF | Futures | 278.573 | 278.622 | 272.8 | 274.33 | 5360.0 |
| 2012-07-13 | GSCI | Futures | 987.32 | 991.78 | 982.87 | 991.62 | 2049.0 |
| 2012-07-13 | HE | Futures | 98.186 | 98.186 | 96.556 | 96.636 | 26667.0 |
| 2012-07-13 | HG | Futures | 4.4066 | 4.5186 | 4.3963 | 4.5141 | 44880.0 |
| 2012-07-13 | HO | Futures | 2.2603 | 2.2949 | 2.2578 | 2.28 | 35242.0 |
| 2012-07-13 | HRC | Futures | 2450.1 | 2450.1 | 2450.1 | 2450.1 | 0.0 |
| 2012-07-13 | J1 | Futures | 0.0158153 | 0.0158717 | 0.0157952 | 0.0158203 | 48979.0 |
| 2012-07-13 | J7 | Futures | 0.015755 | 0.015812 | 0.015732 | 0.015758 | 247.0 |
> showing 50 of 98 rows — these rows as CSV