PREVIEW / futures_daily / 2013-07-09
file: by_date/futures_daily/2013/2013-07-09.parquet size: 9 KB rows: 104
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-09 | ES | Futures | 1685.79 | 1698.41 | 1684.76 | 1694.8 | 1281034.0 |
| 2013-07-09 | NQ | Futures | 3425.13 | 3452.9 | 3422.82 | 3440.46 | 162518.0 |
| 2013-07-09 | YM | Futures | 15030.9 | 15123.1 | 15027.9 | 15087.4 | 99480.0 |
| 2013-07-09 | CL | Futures | 179.41 | 182.48 | 178.21 | 180.34 | 285670.0 |
| 2013-07-09 | GC | Futures | 1639.8 | 1670.9 | 1635.5 | 1654.0 | 166683.0 |
| 2013-07-09 | ZN | Futures | 112.60504 | 112.843669 | 112.408521 | 112.74541 | 826053.0 |
| 2013-07-09 | A6 | Futures | 0.8524 | 0.85907 | 0.8479 | 0.85803 | 111784.0 |
| 2013-07-09 | AD | Futures | 0.95243 | 0.95666 | 0.95112 | 0.95535 | 64980.0 |
| 2013-07-09 | B | Futures | 103.61 | 104.53 | 103.22 | 104.13 | 166812.0 |
| 2013-07-09 | B6 | Futures | 1.5664 | 1.57 | 1.5524 | 1.5583 | 129532.0 |
| 2013-07-09 | BFX | Futures | 3119.4 | 3131.3 | 3119.4 | 3126.6 | 19.0 |
| 2013-07-09 | BR | Futures | 0.21687 | 0.21687 | 0.2165 | 0.2165 | 32.0 |
| 2013-07-09 | BZ | Futures | 103.9 | 105.15 | 103.9 | 104.84 | 7751.0 |
| 2013-07-09 | C | Futures | 1594.0 | 1616.0 | 1592.0 | 1612.0 | 4351.0 |
| 2013-07-09 | CB | Futures | 78.335 | 78.455 | 77.761 | 77.976 | 13.0 |
| 2013-07-09 | CC | Futures | 1618.0 | 1646.0 | 1618.0 | 1633.0 | 10011.0 |
| 2013-07-09 | CNH | Futures | 7.1326 | 7.1334 | 7.1265 | 7.1317 | 11.0 |
| 2013-07-09 | CSC | Futures | 3.471 | 3.471 | 3.456 | 3.461 | 10.0 |
| 2013-07-09 | CT | Futures | 102.94 | 103.42 | 102.74 | 103.23 | 53.0 |
| 2013-07-09 | DC | Futures | 26.49 | 26.7 | 26.43 | 26.5 | 165.0 |
| 2013-07-09 | DX | Futures | 80.742 | 81.201 | 80.575 | 81.025 | 41450.0 |
| 2013-07-09 | E1 | Futures | 1.33455 | 1.33494 | 1.31861 | 1.32234 | 41637.0 |
| 2013-07-09 | E6 | Futures | 1.51916 | 1.52246 | 1.50523 | 1.50936 | 283410.0 |
| 2013-07-09 | E7 | Futures | 1.5095 | 1.5125 | 1.4954 | 1.4995 | 3170.0 |
| 2013-07-09 | ED | Futures | 95.2725 | 95.2821 | 95.2678 | 95.2725 | 84438.0 |
| 2013-07-09 | ER | Futures | 97.847 | 97.847 | 97.832 | 97.837 | 93925.0 |
| 2013-07-09 | EW | Futures | 1208.5 | 1223.9 | 1208.1 | 1222.3 | 16334.0 |
| 2013-07-09 | FBTP | Futures | 77.49 | 77.72 | 77.12 | 77.33 | 32446.0 |
| 2013-07-09 | FBTS | Futures | 93.057 | 93.117 | 92.902 | 92.971 | 7560.0 |
| 2013-07-09 | FCE | Futures | 2978.4 | 2995.1 | 2973.0 | 2981.9 | 67955.0 |
| 2013-07-09 | FDAX | Futures | 8907.8 | 8981.0 | 8886.1 | 8949.4 | 93964.0 |
| 2013-07-09 | FDIV | Futures | 121.34 | 121.98 | 121.34 | 121.98 | 3495.0 |
| 2013-07-09 | FESX | Futures | 1868.5 | 1875.5 | 1860.1 | 1867.8 | 719109.0 |
| 2013-07-09 | FGBL | Futures | 118.84 | 119.48 | 118.77 | 119.37 | 582996.0 |
| 2013-07-09 | FGBM | Futures | 117.18 | 117.49 | 117.14 | 117.45 | 391865.0 |
| 2013-07-09 | FGBS | Futures | 110.402 | 110.452 | 110.392 | 110.447 | 315409.0 |
| 2013-07-09 | FGBX | Futures | 122.88 | 124.05 | 122.75 | 123.86 | 10810.0 |
| 2013-07-09 | FMWO | Futures | 4814.1 | 4814.1 | 4814.1 | 4814.1 | 0.0 |
| 2013-07-09 | FOAT | Futures | 106.41 | 106.64 | 106.29 | 106.6 | 34123.0 |
| 2013-07-09 | FTDX | Futures | 913.1 | 915.0 | 912.2 | 914.1 | 31.0 |
| 2013-07-09 | FTI | Futures | 312.59 | 314.63 | 312.06 | 313.76 | 22176.0 |
| 2013-07-09 | FTUK | Futures | 4813.5 | 4863.8 | 4805.7 | 4856.7 | 79933.0 |
| 2013-07-09 | FVSA | Futures | 3166.11 | 3195.7 | 3114.33 | 3136.52 | 5203.0 |
| 2013-07-09 | FXXP | Futures | 215.7 | 216.9 | 215.2 | 216.5 | 7150.0 |
| 2013-07-09 | G | Futures | 93.81 | 94.34 | 93.8 | 94.3 | 125198.0 |
| 2013-07-09 | GF | Futures | 255.261 | 255.513 | 253.112 | 254.671 | 3378.0 |
| 2013-07-09 | GSCI | Futures | 1045.52 | 1050.95 | 1042.88 | 1048.97 | 2729.0 |
| 2013-07-09 | HE | Futures | 98.709 | 99.096 | 98.063 | 98.321 | 25674.0 |
| 2013-07-09 | HG | Futures | 3.9353 | 3.9537 | 3.8382 | 3.8883 | 57953.0 |
| 2013-07-09 | HH | Futures | 41.214 | 41.27 | 40.412 | 40.735 | 1232.0 |
> showing 50 of 104 rows — these rows as CSV