PREVIEW / futures_daily / 2011-08-15
file: by_date/futures_daily/2011/2011-08-15.parquet size: 9 KB rows: 96
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-15 | ES | Futures | 1171.65 | 1193.5 | 1168.17 | 1190.27 | 2002026.0 |
| 2011-08-15 | NQ | Futures | 2486.76 | 2518.36 | 2478.51 | 2512.67 | 224281.0 |
| 2011-08-15 | YM | Futures | 10652.8 | 10822.1 | 10629.2 | 10780.5 | 110971.0 |
| 2011-08-15 | CL | Futures | 163.63 | 168.22 | 161.34 | 167.89 | 105366.0 |
| 2011-08-15 | GC | Futures | 2358.9 | 2388.8 | 2336.9 | 2373.6 | 127711.0 |
| 2011-08-15 | ZN | Futures | 110.457881 | 110.684065 | 110.138562 | 110.324831 | 809688.0 |
| 2011-08-15 | A6 | Futures | 0.89839 | 0.91039 | 0.89734 | 0.90987 | 93160.0 |
| 2011-08-15 | AD | Futures | 1.00874 | 1.01812 | 1.00664 | 1.01642 | 78273.0 |
| 2011-08-15 | B | Futures | 92.25 | 94.01 | 91.7 | 93.96 | 159386.0 |
| 2011-08-15 | B6 | Futures | 1.6934 | 1.7067 | 1.6905 | 1.7041 | 74092.0 |
| 2011-08-15 | BFX | Futures | 2766.3 | 2766.3 | 2729.2 | 2742.6 | 420.0 |
| 2011-08-15 | BR | Futures | 0.27867 | 0.27907 | 0.27867 | 0.27884 | 61.0 |
| 2011-08-15 | BZ | Futures | 95.4 | 97.06 | 95.31 | 97.04 | 953.0 |
| 2011-08-15 | C | Futures | 2002.0 | 2015.0 | 1983.0 | 1988.0 | 1512.0 |
| 2011-08-15 | CC | Futures | 2283.0 | 2314.0 | 2283.0 | 2298.0 | 7783.0 |
| 2011-08-15 | CSC | Futures | 4.74 | 4.745 | 4.74 | 4.745 | 17.0 |
| 2011-08-15 | CT | Futures | 131.11 | 137.2 | 131.07 | 136.3 | 75.0 |
| 2011-08-15 | DC | Futures | 32.38 | 32.73 | 32.01 | 32.61 | 455.0 |
| 2011-08-15 | DX | Futures | 73.954 | 74.024 | 73.128 | 73.216 | 21598.0 |
| 2011-08-15 | E1 | Futures | 1.6747 | 1.68111 | 1.63717 | 1.66947 | 38905.0 |
| 2011-08-15 | E6 | Futures | 1.69316 | 1.71882 | 1.69316 | 1.71549 | 307301.0 |
| 2011-08-15 | E7 | Futures | 1.6796 | 1.706 | 1.6796 | 1.703 | 3997.0 |
| 2011-08-15 | ED | Futures | 94.8667 | 94.9144 | 94.8644 | 94.9072 | 180040.0 |
| 2011-08-15 | ER | Futures | 97.573 | 97.573 | 97.499 | 97.514 | 160643.0 |
| 2011-08-15 | EW | Futures | 837.6 | 857.5 | 836.1 | 853.6 | 24628.0 |
| 2011-08-15 | FBTP | Futures | 64.0 | 64.23 | 64.0 | 64.14 | 1770.0 |
| 2011-08-15 | FCE | Futures | 2275.9 | 2293.1 | 2242.2 | 2268.5 | 9516.0 |
| 2011-08-15 | FDAX | Futures | 6493.3 | 6530.7 | 6422.3 | 6439.4 | 125183.0 |
| 2011-08-15 | FESX | Futures | 1499.6 | 1504.1 | 1476.5 | 1489.4 | 1110038.0 |
| 2011-08-15 | FEU3 | Futures | 98.054 | 98.059 | 98.054 | 98.059 | 10.0 |
| 2011-08-15 | FGBL | Futures | 106.53 | 106.81 | 106.27 | 106.64 | 374887.0 |
| 2011-08-15 | FGBM | Futures | 109.03 | 109.19 | 108.87 | 109.09 | 267196.0 |
| 2011-08-15 | FGBS | Futures | 108.785 | 108.835 | 108.691 | 108.75 | 392968.0 |
| 2011-08-15 | FGBX | Futures | 104.19 | 104.19 | 102.96 | 103.42 | 2264.0 |
| 2011-08-15 | FTDX | Futures | 673.4 | 680.5 | 668.9 | 674.7 | 683.0 |
| 2011-08-15 | FTI | Futures | 239.76 | 241.48 | 238.25 | 239.64 | 7474.0 |
| 2011-08-15 | FTUK | Futures | 3764.3 | 3798.8 | 3742.1 | 3761.8 | 90944.0 |
| 2011-08-15 | FVSA | Futures | 12496.56 | 12884.65 | 12496.56 | 12710.01 | 1409.0 |
| 2011-08-15 | FXXP | Futures | 161.9 | 161.9 | 159.9 | 160.7 | 4225.0 |
| 2011-08-15 | G | Futures | 89.38 | 89.67 | 89.26 | 89.55 | 64524.0 |
| 2011-08-15 | GF | Futures | 315.915 | 317.632 | 312.595 | 315.228 | 1360.0 |
| 2011-08-15 | GSCI | Futures | 1001.9 | 1024.46 | 1001.9 | 1022.42 | 546.0 |
| 2011-08-15 | HE | Futures | 109.496 | 110.29 | 109.252 | 109.893 | 19499.0 |
| 2011-08-15 | HG | Futures | 5.3017 | 5.3645 | 5.2719 | 5.3301 | 26071.0 |
| 2011-08-15 | HO | Futures | 2.3458 | 2.3888 | 2.345 | 2.3836 | 48128.0 |
| 2011-08-15 | HRC | Futures | 2868.4 | 2868.4 | 2868.4 | 2868.4 | 0.0 |
| 2011-08-15 | J1 | Futures | 0.0163562 | 0.0164165 | 0.016311 | 0.0163801 | 61336.0 |
| 2011-08-15 | J7 | Futures | 0.016254 | 0.016308 | 0.016203 | 0.016271 | 335.0 |
| 2011-08-15 | JB | Futures | 123.8 | 123.8 | 123.7 | 123.71 | 2576.0 |
| 2011-08-15 | KC | Futures | 569.67 | 586.94 | 568.02 | 581.27 | 10551.0 |
> showing 50 of 96 rows — these rows as CSV