PREVIEW / futures_daily / 2013-01-07
file: by_date/futures_daily/2013/2013-01-07.parquet size: 9 KB rows: 101
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-01-07 | ES | Futures | 1494.12 | 1494.63 | 1484.4 | 1489.52 | 1199834.0 |
| 2013-01-07 | NQ | Futures | 3133.03 | 3140.53 | 3117.17 | 3134.76 | 174832.0 |
| 2013-01-07 | YM | Futures | 13101.7 | 13106.6 | 13014.5 | 13048.8 | 86399.0 |
| 2013-01-07 | CL | Futures | 165.43 | 165.68 | 164.03 | 165.4 | 166292.0 |
| 2013-01-07 | GC | Futures | 2207.2 | 2216.2 | 2189.0 | 2193.9 | 140819.0 |
| 2013-01-07 | ZN | Futures | 116.03214 | 116.22509 | 115.990793 | 116.059704 | 680445.0 |
| 2013-01-07 | A6 | Futures | 0.95655 | 0.95701 | 0.95289 | 0.95536 | 77177.0 |
| 2013-01-07 | AD | Futures | 1.01493 | 1.01603 | 1.01272 | 1.01513 | 47675.0 |
| 2013-01-07 | B | Futures | 103.39 | 103.83 | 102.58 | 103.57 | 186789.0 |
| 2013-01-07 | B6 | Futures | 1.6798 | 1.6838 | 1.6738 | 1.6826 | 96245.0 |
| 2013-01-07 | BFX | Futures | 3052.0 | 3052.0 | 3022.4 | 3025.5 | 157.0 |
| 2013-01-07 | BR | Futures | 0.23993 | 0.24037 | 0.23976 | 0.23976 | 155.0 |
| 2013-01-07 | BZ | Futures | 105.52 | 106.03 | 105.02 | 105.88 | 1346.0 |
| 2013-01-07 | C | Futures | 1519.0 | 1548.0 | 1518.0 | 1544.0 | 5765.0 |
| 2013-01-07 | CB | Futures | 83.794 | 83.807 | 83.794 | 83.807 | 12.0 |
| 2013-01-07 | CC | Futures | 1675.0 | 1716.0 | 1670.0 | 1710.0 | 13198.0 |
| 2013-01-07 | CSC | Futures | 3.899 | 3.901 | 3.867 | 3.873 | 8.0 |
| 2013-01-07 | CT | Futures | 94.58 | 95.48 | 93.94 | 95.28 | 12050.0 |
| 2013-01-07 | DC | Futures | 29.1 | 29.24 | 28.94 | 29.01 | 151.0 |
| 2013-01-07 | DX | Futures | 77.743 | 77.927 | 77.478 | 77.511 | 36588.0 |
| 2013-01-07 | E1 | Futures | 1.3941 | 1.39887 | 1.38767 | 1.39809 | 21959.0 |
| 2013-01-07 | E6 | Futures | 1.54325 | 1.54832 | 1.53618 | 1.54738 | 229282.0 |
| 2013-01-07 | E7 | Futures | 1.5326 | 1.5376 | 1.5257 | 1.5368 | 4183.0 |
| 2013-01-07 | EBM | Futures | 272.56 | 273.39 | 269.5 | 269.78 | 13951.0 |
| 2013-01-07 | ED | Futures | 95.2342 | 95.2342 | 95.2247 | 95.2342 | 64002.0 |
| 2013-01-07 | ER | Futures | 97.803 | 97.817 | 97.798 | 97.808 | 171546.0 |
| 2013-01-07 | EW | Futures | 1071.9 | 1073.1 | 1067.8 | 1072.1 | 13822.0 |
| 2013-01-07 | FBTP | Futures | 76.72 | 76.81 | 76.14 | 76.25 | 19996.0 |
| 2013-01-07 | FBTS | Futures | 91.408 | 91.408 | 91.154 | 91.188 | 2739.0 |
| 2013-01-07 | FCE | Futures | 2803.5 | 2809.9 | 2782.4 | 2789.2 | 67735.0 |
| 2013-01-07 | FDAX | Futures | 8480.7 | 8494.9 | 8426.1 | 8444.1 | 73202.0 |
| 2013-01-07 | FESX | Futures | 1839.7 | 1845.2 | 1828.1 | 1830.2 | 560645.0 |
| 2013-01-07 | FEU3 | Futures | 98.423 | 98.423 | 98.409 | 98.413 | 181.0 |
| 2013-01-07 | FGBL | Futures | 118.16 | 118.35 | 118.02 | 118.25 | 528630.0 |
| 2013-01-07 | FGBM | Futures | 116.52 | 116.61 | 116.43 | 116.51 | 356214.0 |
| 2013-01-07 | FGBS | Futures | 110.333 | 110.358 | 110.303 | 110.343 | 323050.0 |
| 2013-01-07 | FGBX | Futures | 123.39 | 124.24 | 123.18 | 124.01 | 7801.0 |
| 2013-01-07 | FOAT | Futures | 105.21 | 105.4 | 105.06 | 105.28 | 23352.0 |
| 2013-01-07 | FTDX | Futures | 809.5 | 815.6 | 809.5 | 815.6 | 309.0 |
| 2013-01-07 | FTI | Futures | 302.22 | 302.74 | 301.23 | 301.79 | 19581.0 |
| 2013-01-07 | FTUK | Futures | 4450.1 | 4454.2 | 4421.8 | 4428.8 | 69580.0 |
| 2013-01-07 | FVSA | Futures | 3502.62 | 3614.3 | 3502.62 | 3594.0 | 6440.0 |
| 2013-01-07 | FXXP | Futures | 206.8 | 207.0 | 205.6 | 205.8 | 1542.0 |
| 2013-01-07 | G | Futures | 96.53 | 96.68 | 96.41 | 96.58 | 128451.0 |
| 2013-01-07 | GF | Futures | 290.608 | 291.178 | 289.66 | 290.798 | 835.0 |
| 2013-01-07 | GSCI | Futures | 1039.93 | 1046.05 | 1039.13 | 1043.47 | 492.0 |
| 2013-01-07 | HE | Futures | 98.867 | 99.642 | 98.494 | 99.04 | 17940.0 |
| 2013-01-07 | HG | Futures | 4.7559 | 4.7687 | 4.6904 | 4.7231 | 39008.0 |
| 2013-01-07 | HH | Futures | 39.271 | 39.318 | 38.038 | 38.344 | 135.0 |
| 2013-01-07 | HO | Futures | 2.4248 | 2.4406 | 2.4131 | 2.4307 | 28353.0 |
> showing 50 of 101 rows — these rows as CSV