PREVIEW / futures_daily / 2013-02-04
file: by_date/futures_daily/2013/2013-02-04.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-02-04 | ES | Futures | 1542.98 | 1543.49 | 1524.82 | 1528.14 | 1765571.0 |
| 2013-02-04 | NQ | Futures | 3182.63 | 3182.63 | 3124.67 | 3127.55 | 275933.0 |
| 2013-02-04 | YM | Futures | 13670.5 | 13678.3 | 13538.1 | 13576.3 | 114174.0 |
| 2013-02-04 | CL | Futures | 172.2 | 172.28 | 168.98 | 169.47 | 196975.0 |
| 2013-02-04 | GC | Futures | 2218.5 | 2231.2 | 2208.8 | 2228.2 | 112527.0 |
| 2013-02-04 | ZN | Futures | 115.549764 | 116.156179 | 115.301685 | 115.990793 | 1696401.0 |
| 2013-02-04 | A6 | Futures | 0.95078 | 0.95261 | 0.94959 | 0.95179 | 66779.0 |
| 2013-02-04 | AD | Futures | 1.0048 | 1.0069 | 1.00249 | 1.0037 | 59249.0 |
| 2013-02-04 | B | Futures | 109.31 | 109.43 | 108.26 | 108.51 | 146997.0 |
| 2013-02-04 | B6 | Futures | 1.6401 | 1.6478 | 1.6396 | 1.6468 | 103840.0 |
| 2013-02-04 | BFX | Futures | 3033.6 | 3033.6 | 3016.7 | 3017.7 | 49.0 |
| 2013-02-04 | BR | Futures | 0.24618 | 0.2464 | 0.24505 | 0.24542 | 48.0 |
| 2013-02-04 | BZ | Futures | 112.08 | 112.14 | 110.98 | 111.21 | 1968.0 |
| 2013-02-04 | C | Futures | 1541.0 | 1546.0 | 1526.0 | 1529.0 | 4543.0 |
| 2013-02-04 | CC | Futures | 1664.0 | 1673.0 | 1653.0 | 1662.0 | 11811.0 |
| 2013-02-04 | CSC | Futures | 3.588 | 3.597 | 3.588 | 3.597 | 3.0 |
| 2013-02-04 | CT | Futures | 104.33 | 104.33 | 102.32 | 102.87 | 23625.0 |
| 2013-02-04 | DC | Futures | 27.33 | 27.49 | 26.86 | 27.03 | 362.0 |
| 2013-02-04 | DX | Futures | 76.359 | 76.808 | 76.355 | 76.743 | 27260.0 |
| 2013-02-04 | E1 | Futures | 1.41779 | 1.41946 | 1.41251 | 1.41792 | 33800.0 |
| 2013-02-04 | E6 | Futures | 1.61036 | 1.61083 | 1.59326 | 1.59491 | 278973.0 |
| 2013-02-04 | E7 | Futures | 1.599 | 1.5997 | 1.5823 | 1.584 | 4575.0 |
| 2013-02-04 | EBM | Futures | 275.9 | 277.01 | 275.06 | 275.34 | 7636.0 |
| 2013-02-04 | ED | Futures | 95.2342 | 95.2342 | 95.2247 | 95.2295 | 120549.0 |
| 2013-02-04 | ER | Futures | 97.734 | 97.749 | 97.724 | 97.744 | 83217.0 |
| 2013-02-04 | EW | Futures | 1119.4 | 1120.3 | 1107.8 | 1113.3 | 19649.0 |
| 2013-02-04 | FBTP | Futures | 76.59 | 76.59 | 75.67 | 75.74 | 40529.0 |
| 2013-02-04 | FBTS | Futures | 91.417 | 91.425 | 91.154 | 91.196 | 8677.0 |
| 2013-02-04 | FCE | Futures | 2833.8 | 2835.7 | 2734.4 | 2747.9 | 173178.0 |
| 2013-02-04 | FDAX | Futures | 8552.2 | 8561.0 | 8302.7 | 8351.3 | 158132.0 |
| 2013-02-04 | FESX | Futures | 1849.9 | 1850.6 | 1778.4 | 1790.7 | 1500650.0 |
| 2013-02-04 | FEU3 | Futures | 98.344 | 98.349 | 98.344 | 98.349 | 16.0 |
| 2013-02-04 | FGBL | Futures | 116.94 | 118.05 | 116.93 | 117.9 | 1030766.0 |
| 2013-02-04 | FGBM | Futures | 115.62 | 116.21 | 115.62 | 116.14 | 672668.0 |
| 2013-02-04 | FGBS | Futures | 109.954 | 110.093 | 109.949 | 110.083 | 532431.0 |
| 2013-02-04 | FGBX | Futures | 123.33 | 125.18 | 123.22 | 125.1 | 10145.0 |
| 2013-02-04 | FOAT | Futures | 104.01 | 104.44 | 103.93 | 104.41 | 53497.0 |
| 2013-02-04 | FTDX | Futures | 836.5 | 836.5 | 824.6 | 824.6 | 50.0 |
| 2013-02-04 | FTI | Futures | 305.28 | 305.71 | 299.6 | 300.24 | 39024.0 |
| 2013-02-04 | FTUK | Futures | 4643.6 | 4647.6 | 4556.4 | 4560.1 | 127697.0 |
| 2013-02-04 | FVSA | Futures | 3048.75 | 3565.94 | 3039.67 | 3565.94 | 17231.0 |
| 2013-02-04 | FXXP | Futures | 207.2 | 207.6 | 204.1 | 204.2 | 5077.0 |
| 2013-02-04 | G | Futures | 96.44 | 96.79 | 96.05 | 96.69 | 192499.0 |
| 2013-02-04 | GF | Futures | 279.07 | 279.304 | 276.408 | 278.136 | 3797.0 |
| 2013-02-04 | GSCI | Futures | 1084.53 | 1089.51 | 1081.96 | 1082.12 | 309.0 |
| 2013-02-04 | HE | Futures | 99.646 | 99.898 | 98.218 | 98.974 | 22045.0 |
| 2013-02-04 | HG | Futures | 4.8599 | 4.8702 | 4.831 | 4.8393 | 46143.0 |
| 2013-02-04 | HH | Futures | 38.249 | 39.148 | 38.074 | 38.728 | 410.0 |
| 2013-02-04 | HO | Futures | 2.5534 | 2.5573 | 2.5359 | 2.5445 | 63382.0 |
| 2013-02-04 | HRC | Futures | 2346.5 | 2346.5 | 2346.5 | 2346.5 | 0.0 |
> showing 50 of 101 rows — these rows as CSV