PREVIEW / futures_daily / 2012-11-08
file: by_date/futures_daily/2012/2012-11-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-11-08 | ES | Futures | 1414.97 | 1422.35 | 1396.91 | 1399.71 | 2615376.0 |
| 2012-11-08 | NQ | Futures | 3006.26 | 3018.34 | 2955.35 | 2959.37 | 384377.0 |
| 2012-11-08 | YM | Futures | 12569.4 | 12627.0 | 12460.0 | 12474.7 | 168036.0 |
| 2012-11-08 | CL | Futures | 152.33 | 154.45 | 151.79 | 153.36 | 296599.0 |
| 2012-11-08 | GC | Futures | 2293.6 | 2316.6 | 2286.6 | 2304.4 | 165870.0 |
| 2012-11-08 | ZN | Futures | 117.301979 | 117.755201 | 117.260778 | 117.659063 | 1196307.0 |
| 2012-11-08 | A6 | Futures | 0.94262 | 0.94634 | 0.94125 | 0.94334 | 124009.0 |
| 2012-11-08 | AD | Futures | 1.0064 | 1.0081 | 1.00238 | 1.00318 | 77532.0 |
| 2012-11-08 | B | Futures | 97.88 | 99.09 | 97.26 | 98.31 | 144015.0 |
| 2012-11-08 | B6 | Futures | 1.6692 | 1.6715 | 1.6633 | 1.6686 | 99135.0 |
| 2012-11-08 | BFX | Futures | 2828.4 | 2828.4 | 2823.2 | 2823.2 | 12.0 |
| 2012-11-08 | BR | Futures | 0.23806 | 0.23808 | 0.23709 | 0.23745 | 73.0 |
| 2012-11-08 | BZ | Futures | 101.41 | 102.11 | 100.38 | 101.37 | 333.0 |
| 2012-11-08 | C | Futures | 1574.0 | 1577.0 | 1537.0 | 1540.0 | 3780.0 |
| 2012-11-08 | CB | Futures | 92.06 | 92.595 | 92.06 | 92.06 | 12.0 |
| 2012-11-08 | CC | Futures | 1815.0 | 1817.0 | 1756.0 | 1765.0 | 28708.0 |
| 2012-11-08 | CSC | Futures | 4.072 | 4.072 | 4.063 | 4.072 | 16.0 |
| 2012-11-08 | CT | Futures | 90.33 | 90.65 | 89.08 | 89.37 | 29941.0 |
| 2012-11-08 | DC | Futures | 30.31 | 30.45 | 30.02 | 30.34 | 356.0 |
| 2012-11-08 | DX | Futures | 78.399 | 78.564 | 78.288 | 78.347 | 20684.0 |
| 2012-11-08 | E1 | Futures | 1.36334 | 1.36398 | 1.35806 | 1.36154 | 26592.0 |
| 2012-11-08 | E6 | Futures | 1.50436 | 1.50507 | 1.498 | 1.50165 | 297795.0 |
| 2012-11-08 | E7 | Futures | 1.4955 | 1.4961 | 1.489 | 1.4927 | 4052.0 |
| 2012-11-08 | ED | Futures | 95.2349 | 95.2444 | 95.2349 | 95.2396 | 58062.0 |
| 2012-11-08 | ER | Futures | 97.896 | 97.906 | 97.876 | 97.886 | 156960.0 |
| 2012-11-08 | EW | Futures | 996.9 | 1001.8 | 983.2 | 984.5 | 25287.0 |
| 2012-11-08 | FBTP | Futures | 72.72 | 72.76 | 71.96 | 72.08 | 25635.0 |
| 2012-11-08 | FBTS | Futures | 89.776 | 89.868 | 89.617 | 89.734 | 4101.0 |
| 2012-11-08 | FCE | Futures | 2576.1 | 2584.3 | 2550.9 | 2559.1 | 102563.0 |
| 2012-11-08 | FDAX | Futures | 7954.2 | 7986.0 | 7870.4 | 7898.9 | 141244.0 |
| 2012-11-08 | FESX | Futures | 1696.0 | 1702.2 | 1678.3 | 1688.6 | 1049194.0 |
| 2012-11-08 | FEU3 | Futures | 98.517 | 98.517 | 98.507 | 98.507 | 263.0 |
| 2012-11-08 | FGBL | Futures | 119.27 | 119.66 | 119.15 | 119.5 | 747120.0 |
| 2012-11-08 | FGBM | Futures | 117.0 | 117.14 | 116.9 | 117.04 | 442202.0 |
| 2012-11-08 | FGBS | Futures | 110.527 | 110.537 | 110.487 | 110.522 | 438809.0 |
| 2012-11-08 | FGBX | Futures | 127.1 | 127.52 | 126.67 | 127.27 | 12144.0 |
| 2012-11-08 | FOAT | Futures | 104.23 | 104.41 | 104.2 | 104.37 | 16062.0 |
| 2012-11-08 | FTDX | Futures | 767.4 | 767.4 | 757.1 | 758.5 | 131.0 |
| 2012-11-08 | FTI | Futures | 286.21 | 287.07 | 283.68 | 284.88 | 31750.0 |
| 2012-11-08 | FTUK | Futures | 4253.0 | 4254.5 | 4200.3 | 4215.7 | 84786.0 |
| 2012-11-08 | FVSA | Futures | 4991.94 | 5116.17 | 4912.88 | 5071.0 | 8320.0 |
| 2012-11-08 | FXXP | Futures | 196.0 | 196.3 | 194.6 | 195.1 | 4982.0 |
| 2012-11-08 | G | Futures | 99.19 | 99.43 | 98.95 | 99.21 | 186009.0 |
| 2012-11-08 | GF | Futures | 276.371 | 277.667 | 275.843 | 277.475 | 811.0 |
| 2012-11-08 | GSCI | Futures | 1021.97 | 1023.67 | 1012.75 | 1018.73 | 2040.0 |
| 2012-11-08 | HE | Futures | 99.315 | 100.371 | 99.128 | 99.687 | 29905.0 |
| 2012-11-08 | HG | Futures | 4.44 | 4.4644 | 4.4136 | 4.4586 | 55606.0 |
| 2012-11-08 | HO | Futures | 2.4052 | 2.4309 | 2.3886 | 2.3954 | 50656.0 |
| 2012-11-08 | HRC | Futures | 2458.3 | 2458.3 | 2458.3 | 2458.3 | 0.0 |
| 2012-11-08 | J1 | Futures | 0.0156602 | 0.0157892 | 0.015654 | 0.0157767 | 108065.0 |
> showing 50 of 99 rows — these rows as CSV