PREVIEW / futures_daily / 2012-10-03
file: by_date/futures_daily/2012/2012-10-03.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-10-03 | ES | Futures | 1465.86 | 1474.51 | 1461.03 | 1470.44 | 1553817.0 |
| 2012-10-03 | NQ | Futures | 3216.25 | 3241.56 | 3207.91 | 3230.92 | 203387.0 |
| 2012-10-03 | YM | Futures | 13093.8 | 13146.5 | 13045.9 | 13110.4 | 119271.0 |
| 2012-10-03 | CL | Futures | 165.39 | 165.72 | 158.28 | 159.08 | 339506.0 |
| 2012-10-03 | GC | Futures | 2371.5 | 2381.9 | 2367.2 | 2376.3 | 119091.0 |
| 2012-10-03 | ZN | Futures | 117.425585 | 117.604127 | 117.356915 | 117.549191 | 770031.0 |
| 2012-10-03 | A6 | Futures | 0.9269 | 0.92708 | 0.92072 | 0.92126 | 131097.0 |
| 2012-10-03 | AD | Futures | 1.01804 | 1.01844 | 1.01362 | 1.01402 | 87059.0 |
| 2012-10-03 | B | Futures | 101.3 | 101.35 | 98.01 | 98.45 | 187943.0 |
| 2012-10-03 | B6 | Futures | 1.6842 | 1.6856 | 1.6776 | 1.6784 | 90075.0 |
| 2012-10-03 | BFX | Futures | 2884.3 | 2887.3 | 2884.3 | 2884.8 | 5.0 |
| 2012-10-03 | BR | Futures | 0.23779 | 0.23808 | 0.23779 | 0.23806 | 95.0 |
| 2012-10-03 | BZ | Futures | 104.61 | 104.61 | 101.88 | 102.16 | 2152.0 |
| 2012-10-03 | C | Futures | 1620.0 | 1621.0 | 1576.0 | 1585.0 | 9971.0 |
| 2012-10-03 | CB | Futures | 95.004 | 95.699 | 94.201 | 95.392 | 25.0 |
| 2012-10-03 | CC | Futures | 1859.0 | 1870.0 | 1810.0 | 1822.0 | 13754.0 |
| 2012-10-03 | CSC | Futures | 4.07 | 4.158 | 4.063 | 4.149 | 22.0 |
| 2012-10-03 | CT | Futures | 92.72 | 93.18 | 91.43 | 93.12 | 11998.0 |
| 2012-10-03 | DC | Futures | 30.48 | 31.17 | 30.39 | 31.08 | 194.0 |
| 2012-10-03 | DX | Futures | 77.348 | 77.581 | 77.29 | 77.551 | 13938.0 |
| 2012-10-03 | E1 | Futures | 1.37608 | 1.37737 | 1.37106 | 1.37222 | 29536.0 |
| 2012-10-03 | E6 | Futures | 1.52249 | 1.52461 | 1.51767 | 1.52014 | 226853.0 |
| 2012-10-03 | E7 | Futures | 1.5135 | 1.5155 | 1.5085 | 1.511 | 4496.0 |
| 2012-10-03 | ED | Futures | 95.2253 | 95.2349 | 95.2205 | 95.2301 | 75550.0 |
| 2012-10-03 | ER | Futures | 97.866 | 97.881 | 97.866 | 97.871 | 72850.0 |
| 2012-10-03 | EW | Futures | 1005.7 | 1009.3 | 999.6 | 1003.9 | 18046.0 |
| 2012-10-03 | FBTP | Futures | 71.18 | 71.67 | 71.18 | 71.26 | 17365.0 |
| 2012-10-03 | FBTS | Futures | 89.433 | 89.592 | 89.366 | 89.407 | 2210.0 |
| 2012-10-03 | FCE | Futures | 2545.7 | 2559.1 | 2533.7 | 2546.4 | 110820.0 |
| 2012-10-03 | FDAX | Futures | 8006.3 | 8045.2 | 7970.1 | 8028.2 | 115184.0 |
| 2012-10-03 | FESX | Futures | 1689.9 | 1699.4 | 1681.1 | 1692.6 | 872604.0 |
| 2012-10-03 | FGBL | Futures | 118.46 | 118.6 | 118.21 | 118.33 | 517386.0 |
| 2012-10-03 | FGBM | Futures | 116.27 | 116.36 | 116.16 | 116.27 | 287322.0 |
| 2012-10-03 | FGBS | Futures | 110.353 | 110.377 | 110.328 | 110.353 | 207756.0 |
| 2012-10-03 | FGBX | Futures | 125.8 | 126.04 | 125.0 | 125.21 | 3817.0 |
| 2012-10-03 | FOAT | Futures | 102.91 | 103.11 | 102.91 | 102.95 | 22547.0 |
| 2012-10-03 | FTDX | Futures | 778.7 | 778.7 | 768.8 | 772.1 | 16.0 |
| 2012-10-03 | FTI | Futures | 278.67 | 280.33 | 277.81 | 279.77 | 25192.0 |
| 2012-10-03 | FTUK | Futures | 4230.7 | 4249.0 | 4212.0 | 4240.9 | 74134.0 |
| 2012-10-03 | FVSA | Futures | 5682.36 | 5719.03 | 5560.16 | 5560.16 | 1560.0 |
| 2012-10-03 | FXXP | Futures | 194.8 | 195.6 | 194.5 | 195.1 | 1145.0 |
| 2012-10-03 | G | Futures | 99.75 | 99.79 | 99.58 | 99.69 | 110454.0 |
| 2012-10-03 | GF | Futures | 283.257 | 284.717 | 281.894 | 282.867 | 1733.0 |
| 2012-10-03 | GSCI | Futures | 1056.8 | 1058.73 | 1042.69 | 1046.32 | 143.0 |
| 2012-10-03 | HE | Futures | 95.896 | 96.642 | 94.218 | 94.312 | 33128.0 |
| 2012-10-03 | HG | Futures | 4.875 | 4.8763 | 4.8332 | 4.8628 | 37447.0 |
| 2012-10-03 | HH | Futures | 44.183 | 44.196 | 43.29 | 43.29 | 1040.0 |
| 2012-10-03 | HO | Futures | 2.5236 | 2.5236 | 2.4627 | 2.4685 | 55860.0 |
| 2012-10-03 | HRC | Futures | 2443.1 | 2443.1 | 2443.1 | 2443.1 | 0.0 |
| 2012-10-03 | J1 | Futures | 0.016022 | 0.0160371 | 0.0159332 | 0.0159519 | 84315.0 |
> showing 50 of 99 rows — these rows as CSV