PREVIEW / futures_daily / 2013-04-09
file: by_date/futures_daily/2013/2013-04-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-04-09 | ES | Futures | 1602.36 | 1610.83 | 1596.97 | 1604.93 | 1632380.0 |
| 2013-04-09 | NQ | Futures | 3216.64 | 3245.51 | 3203.06 | 3231.36 | 237574.0 |
| 2013-04-09 | YM | Futures | 14357.0 | 14426.9 | 14309.7 | 14386.5 | 131463.0 |
| 2013-04-09 | CL | Futures | 163.18 | 164.9 | 162.08 | 164.42 | 234720.0 |
| 2013-04-09 | GC | Futures | 2087.4 | 2110.9 | 2084.2 | 2106.4 | 126551.0 |
| 2013-04-09 | ZN | Futures | 118.227256 | 118.44988 | 118.143772 | 118.268998 | 1012488.0 |
| 2013-04-09 | A6 | Futures | 0.95617 | 0.96503 | 0.95543 | 0.96448 | 115019.0 |
| 2013-04-09 | AD | Futures | 0.98657 | 0.98999 | 0.98587 | 0.98818 | 52923.0 |
| 2013-04-09 | B | Futures | 101.01 | 102.47 | 100.49 | 102.22 | 206182.0 |
| 2013-04-09 | B6 | Futures | 1.5965 | 1.6049 | 1.5951 | 1.6041 | 89357.0 |
| 2013-04-09 | BFX | Futures | 3073.7 | 3073.7 | 3072.6 | 3072.6 | 5.0 |
| 2013-04-09 | BR | Futures | 0.2475 | 0.24839 | 0.2473 | 0.24817 | 104.0 |
| 2013-04-09 | BZ | Futures | 102.52 | 103.74 | 101.76 | 103.48 | 6775.0 |
| 2013-04-09 | C | Futures | 1544.0 | 1575.0 | 1544.0 | 1572.0 | 6838.0 |
| 2013-04-09 | CB | Futures | 88.747 | 88.994 | 88.747 | 88.747 | 23.0 |
| 2013-04-09 | CC | Futures | 1653.0 | 1677.0 | 1646.0 | 1674.0 | 23699.0 |
| 2013-04-09 | CNH | Futures | 7.2473 | 7.2473 | 7.2381 | 7.2381 | 30.0 |
| 2013-04-09 | CSC | Futures | 3.837 | 3.865 | 3.833 | 3.835 | 23.0 |
| 2013-04-09 | CT | Futures | 105.04 | 105.63 | 103.81 | 104.13 | 26368.0 |
| 2013-04-09 | DC | Futures | 29.51 | 29.62 | 29.3 | 29.36 | 244.0 |
| 2013-04-09 | DX | Futures | 79.558 | 79.597 | 79.169 | 79.206 | 21869.0 |
| 2013-04-09 | E1 | Futures | 1.37658 | 1.38314 | 1.37439 | 1.38211 | 27743.0 |
| 2013-04-09 | E6 | Futures | 1.53523 | 1.54561 | 1.53382 | 1.54502 | 245324.0 |
| 2013-04-09 | E7 | Futures | 1.5253 | 1.5355 | 1.5239 | 1.5349 | 3371.0 |
| 2013-04-09 | EBM | Futures | 285.84 | 286.72 | 284.97 | 285.55 | 15489.0 |
| 2013-04-09 | ED | Futures | 95.2349 | 95.2492 | 95.2349 | 95.2444 | 80615.0 |
| 2013-04-09 | ER | Futures | 97.798 | 97.817 | 97.788 | 97.803 | 130961.0 |
| 2013-04-09 | EW | Futures | 1156.2 | 1158.6 | 1148.2 | 1153.5 | 15262.0 |
| 2013-04-09 | FBTP | Futures | 77.03 | 77.2 | 76.7 | 76.83 | 21762.0 |
| 2013-04-09 | FBTS | Futures | 92.03 | 92.073 | 91.919 | 91.944 | 5059.0 |
| 2013-04-09 | FCE | Futures | 2781.8 | 2788.6 | 2753.2 | 2764.1 | 88055.0 |
| 2013-04-09 | FDAX | Futures | 8575.7 | 8599.6 | 8469.0 | 8486.2 | 116777.0 |
| 2013-04-09 | FESX | Futures | 1779.8 | 1784.0 | 1761.6 | 1767.2 | 706030.0 |
| 2013-04-09 | FEU3 | Futures | 98.399 | 98.404 | 98.399 | 98.404 | 242.0 |
| 2013-04-09 | FGBL | Futures | 122.26 | 122.42 | 121.96 | 122.2 | 776696.0 |
| 2013-04-09 | FGBM | Futures | 118.16 | 118.29 | 118.0 | 118.14 | 431366.0 |
| 2013-04-09 | FGBS | Futures | 110.462 | 110.507 | 110.442 | 110.472 | 347959.0 |
| 2013-04-09 | FGBX | Futures | 131.22 | 131.41 | 129.82 | 130.76 | 17076.0 |
| 2013-04-09 | FMWO | Futures | 4663.2 | 4663.2 | 4660.6 | 4660.6 | 20.0 |
| 2013-04-09 | FOAT | Futures | 109.31 | 109.39 | 108.72 | 109.0 | 55836.0 |
| 2013-04-09 | FTDX | Futures | 867.2 | 869.1 | 858.2 | 859.7 | 61.0 |
| 2013-04-09 | FTI | Futures | 294.84 | 295.15 | 292.52 | 293.72 | 23862.0 |
| 2013-04-09 | FTUK | Futures | 4648.0 | 4664.4 | 4631.7 | 4648.4 | 69609.0 |
| 2013-04-09 | FVSA | Futures | 3447.04 | 3447.04 | 3313.18 | 3380.11 | 5305.0 |
| 2013-04-09 | FXXP | Futures | 209.1 | 209.4 | 207.6 | 208.0 | 4851.0 |
| 2013-04-09 | G | Futures | 100.26 | 100.31 | 99.79 | 100.03 | 179031.0 |
| 2013-04-09 | GF | Futures | 262.397 | 262.857 | 261.616 | 262.122 | 1233.0 |
| 2013-04-09 | GSCI | Futures | 1017.42 | 1024.16 | 1012.68 | 1022.63 | 1994.0 |
| 2013-04-09 | HE | Futures | 87.67 | 88.274 | 87.469 | 87.897 | 330.0 |
| 2013-04-09 | HG | Futures | 4.3039 | 4.4047 | 4.3039 | 4.3906 | 70086.0 |
> showing 50 of 104 rows — these rows as CSV