PREVIEW / futures_daily / 2011-09-30
file: by_date/futures_daily/2011/2011-09-30.parquet size: 9 KB rows: 98
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-09-30 | ES | Futures | 1155.22 | 1157.72 | 1119.53 | 1124.03 | 2980938.0 |
| 2011-09-30 | NQ | Futures | 2503.21 | 2509.49 | 2422.46 | 2436.44 | 386656.0 |
| 2011-09-30 | YM | Futures | 10670.0 | 10688.3 | 10375.1 | 10414.5 | 145939.0 |
| 2011-09-30 | CL | Futures | 156.64 | 156.94 | 148.08 | 149.34 | 367957.0 |
| 2011-09-30 | GC | Futures | 2185.0 | 2217.6 | 2170.8 | 2190.4 | 152884.0 |
| 2011-09-30 | ZN | Futures | 111.227828 | 111.93842 | 111.227828 | 111.63005 | 1096662.0 |
| 2011-09-30 | A6 | Futures | 0.85141 | 0.85475 | 0.84156 | 0.84526 | 133774.0 |
| 2011-09-30 | AD | Futures | 0.96323 | 0.96463 | 0.95093 | 0.95663 | 126504.0 |
| 2011-09-30 | B | Futures | 90.35 | 90.37 | 87.52 | 88.2 | 200821.0 |
| 2011-09-30 | B6 | Futures | 1.6276 | 1.634 | 1.6199 | 1.6291 | 116510.0 |
| 2011-09-30 | BFX | Futures | 2584.8 | 2584.8 | 2555.4 | 2555.8 | 99.0 |
| 2011-09-30 | BR | Futures | 0.24035 | 0.24157 | 0.23579 | 0.23601 | 257.0 |
| 2011-09-30 | BZ | Futures | 94.9 | 94.9 | 92.67 | 93.21 | 1275.0 |
| 2011-09-30 | C | Futures | 1848.0 | 1854.0 | 1796.0 | 1798.0 | 11633.0 |
| 2011-09-30 | CB | Futures | 93.149 | 93.149 | 93.012 | 93.012 | 6.0 |
| 2011-09-30 | CC | Futures | 2116.0 | 2116.0 | 2028.0 | 2045.0 | 9691.0 |
| 2011-09-30 | CSC | Futures | 4.098 | 4.098 | 3.947 | 3.959 | 54.0 |
| 2011-09-30 | CT | Futures | 132.02 | 132.79 | 128.34 | 129.17 | 10192.0 |
| 2011-09-30 | DC | Futures | 28.33 | 28.33 | 27.3 | 27.52 | 269.0 |
| 2011-09-30 | DX | Futures | 77.02 | 77.865 | 76.937 | 77.629 | 29947.0 |
| 2011-09-30 | E1 | Futures | 1.46396 | 1.46567 | 1.44625 | 1.45136 | 20878.0 |
| 2011-09-30 | E6 | Futures | 1.6231 | 1.62501 | 1.59919 | 1.60338 | 323034.0 |
| 2011-09-30 | E7 | Futures | 1.609 | 1.611 | 1.5854 | 1.5897 | 5229.0 |
| 2011-09-30 | ED | Futures | 94.9841 | 94.9889 | 94.9602 | 94.965 | 166324.0 |
| 2011-09-30 | ER | Futures | 97.332 | 97.351 | 97.302 | 97.337 | 6838.0 |
| 2011-09-30 | EW | Futures | 804.6 | 806.9 | 777.2 | 781.7 | 37535.0 |
| 2011-09-30 | FBTP | Futures | 62.14 | 62.65 | 62.08 | 62.3 | 7004.0 |
| 2011-09-30 | FBTS | Futures | 81.887 | 82.08 | 81.847 | 81.984 | 1487.0 |
| 2011-09-30 | FCE | Futures | 2154.2 | 2159.6 | 2105.3 | 2130.3 | 110052.0 |
| 2011-09-30 | FDAX | Futures | 6113.1 | 6121.3 | 5892.7 | 5940.5 | 202603.0 |
| 2011-09-30 | FESX | Futures | 1458.0 | 1459.3 | 1422.8 | 1433.4 | 1480553.0 |
| 2011-09-30 | FEU3 | Futures | 97.9 | 97.9 | 97.88 | 97.89 | 28.0 |
| 2011-09-30 | FGBL | Futures | 109.75 | 110.68 | 109.61 | 110.43 | 879918.0 |
| 2011-09-30 | FGBM | Futures | 110.33 | 110.83 | 110.22 | 110.67 | 454824.0 |
| 2011-09-30 | FGBS | Futures | 108.93 | 109.039 | 108.875 | 108.974 | 557437.0 |
| 2011-09-30 | FGBX | Futures | 112.22 | 113.81 | 112.05 | 113.08 | 6025.0 |
| 2011-09-30 | FTDX | Futures | 621.9 | 623.3 | 599.8 | 604.0 | 238.0 |
| 2011-09-30 | FTI | Futures | 234.71 | 235.08 | 230.01 | 233.05 | 40833.0 |
| 2011-09-30 | FTUK | Futures | 3705.8 | 3717.6 | 3592.0 | 3653.4 | 29961.0 |
| 2011-09-30 | FVSA | Futures | 18680.76 | 18828.68 | 18089.06 | 18723.02 | 785.0 |
| 2011-09-30 | FXXP | Futures | 157.9 | 158.5 | 155.4 | 156.7 | 14229.0 |
| 2011-09-30 | G | Futures | 91.55 | 92.11 | 91.3 | 92.02 | 127735.0 |
| 2011-09-30 | GF | Futures | 316.586 | 321.567 | 313.869 | 318.171 | 2664.0 |
| 2011-09-30 | GSCI | Futures | 952.09 | 952.09 | 931.1 | 936.24 | 346.0 |
| 2011-09-30 | HE | Futures | 111.25 | 113.114 | 109.901 | 112.857 | 37901.0 |
| 2011-09-30 | HG | Futures | 4.2742 | 4.3907 | 4.0956 | 4.171 | 76052.0 |
| 2011-09-30 | HO | Futures | 2.2835 | 2.2848 | 2.225 | 2.2314 | 35303.0 |
| 2011-09-30 | HRC | Futures | 2747.5 | 2747.5 | 2747.5 | 2747.5 | 1.0 |
| 2011-09-30 | J1 | Futures | 0.0163725 | 0.0164441 | 0.0162896 | 0.0163172 | 94374.0 |
| 2011-09-30 | J7 | Futures | 0.016273 | 0.016343 | 0.016193 | 0.016218 | 516.0 |
> showing 50 of 98 rows — these rows as CSV