PREVIEW / futures_daily / 2015-09-30
file: by_date/futures_daily/2015/2015-09-30.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-30 | ES | Futures | 1994.53 | 2032.3 | 1990.55 | 2030.44 | 2216643.0 |
| 2015-09-30 | NQ | Futures | 4768.91 | 4874.43 | 4754.0 | 4867.42 | 347070.0 |
| 2015-09-30 | YM | Futures | 16454.8 | 16709.6 | 16434.1 | 16685.9 | 202065.0 |
| 2015-09-30 | CL | Futures | 72.15 | 73.64 | 71.76 | 72.42 | 355853.0 |
| 2015-09-30 | GC | Futures | 1455.1 | 1455.7 | 1433.9 | 1439.6 | 156467.0 |
| 2015-09-30 | ZN | Futures | 123.362255 | 123.496963 | 122.943165 | 123.317353 | 1276596.0 |
| 2015-09-30 | A6 | Futures | 0.69633 | 0.70123 | 0.69613 | 0.69893 | 64238.0 |
| 2015-09-30 | AD | Futures | 0.76267 | 0.76943 | 0.76236 | 0.76697 | 63585.0 |
| 2015-09-30 | ALI | Futures | 2130.34 | 2130.34 | 2130.34 | 2130.34 | 0.0 |
| 2015-09-30 | B | Futures | 43.5 | 44.44 | 43.35 | 43.91 | 164061.0 |
| 2015-09-30 | B6 | Futures | 1.5952 | 1.6016 | 1.5902 | 1.5916 | 91246.0 |
| 2015-09-30 | BFX | Futures | 4030.2 | 4030.8 | 4030.2 | 4030.8 | 6.0 |
| 2015-09-30 | BR | Futures | 0.14942 | 0.1534 | 0.1481 | 0.15109 | 9040.0 |
| 2015-09-30 | BZ | Futures | 43.18 | 44.19 | 43.12 | 43.66 | 21906.0 |
| 2015-09-30 | C | Futures | 2323.0 | 2325.0 | 2277.0 | 2281.0 | 14235.0 |
| 2015-09-30 | CB | Futures | 187.474 | 187.474 | 185.013 | 186.957 | 25.0 |
| 2015-09-30 | CC | Futures | 2324.0 | 2340.0 | 2280.0 | 2283.0 | 25141.0 |
| 2015-09-30 | CNH | Futures | 7.1065 | 7.1275 | 7.1059 | 7.1213 | 106.0 |
| 2015-09-30 | CSC | Futures | 4.286 | 4.337 | 4.278 | 4.337 | 133.0 |
| 2015-09-30 | CT | Futures | 73.04 | 73.86 | 71.71 | 72.5 | 17963.0 |
| 2015-09-30 | DC | Futures | 34.37 | 34.83 | 34.3 | 34.81 | 118.0 |
| 2015-09-30 | DX | Futures | 89.836 | 90.313 | 89.771 | 90.234 | 24115.0 |
| 2015-09-30 | E1 | Futures | 1.31004 | 1.31004 | 1.30091 | 1.30421 | 14870.0 |
| 2015-09-30 | E6 | Futures | 1.31939 | 1.32079 | 1.30861 | 1.30955 | 202558.0 |
| 2015-09-30 | E7 | Futures | 1.3121 | 1.3134 | 1.3013 | 1.3023 | 3626.0 |
| 2015-09-30 | EBM | Futures | 253.21 | 256.86 | 252.47 | 255.03 | 22713.0 |
| 2015-09-30 | ED | Futures | 95.7256 | 95.7256 | 95.7063 | 95.7111 | 180533.0 |
| 2015-09-30 | ER | Futures | 98.136 | 98.141 | 98.131 | 98.136 | 45023.0 |
| 2015-09-30 | EW | Futures | 1417.7 | 1440.3 | 1417.0 | 1437.6 | 33739.0 |
| 2015-09-30 | FBTP | Futures | 102.54 | 102.77 | 102.47 | 102.58 | 75297.0 |
| 2015-09-30 | FBTS | Futures | 100.275 | 100.293 | 100.266 | 100.284 | 9711.0 |
| 2015-09-30 | FCE | Futures | 3658.3 | 3725.4 | 3657.9 | 3708.3 | 110435.0 |
| 2015-09-30 | FDAX | Futures | 10561.6 | 10721.3 | 10552.2 | 10638.7 | 127697.0 |
| 2015-09-30 | FESX | Futures | 2294.9 | 2330.1 | 2293.4 | 2316.6 | 1358250.0 |
| 2015-09-30 | FEU3 | Futures | 98.784 | 98.784 | 98.784 | 98.784 | 5.0 |
| 2015-09-30 | FGBL | Futures | 138.92 | 139.07 | 138.68 | 138.98 | 590227.0 |
| 2015-09-30 | FGBM | Futures | 125.18 | 125.26 | 125.11 | 125.21 | 359650.0 |
| 2015-09-30 | FGBS | Futures | 111.288 | 111.303 | 111.273 | 111.293 | 317875.0 |
| 2015-09-30 | FGBX | Futures | 158.92 | 158.98 | 158.02 | 158.67 | 28441.0 |
| 2015-09-30 | FMWO | Futures | 5235.5 | 5266.4 | 5223.1 | 5265.1 | 1454.0 |
| 2015-09-30 | FOAT | Futures | 126.86 | 127.15 | 126.78 | 127.06 | 84049.0 |
| 2015-09-30 | FTDX | Futures | 1637.2 | 1659.5 | 1637.2 | 1659.0 | 134.0 |
| 2015-09-30 | FTI | Futures | 362.48 | 367.35 | 362.48 | 365.83 | 35334.0 |
| 2015-09-30 | FTUK | Futures | 4777.5 | 4864.8 | 4768.7 | 4839.4 | 141466.0 |
| 2015-09-30 | FVSA | Futures | 2635.36 | 2709.33 | 2607.62 | 2663.1 | 5664.0 |
| 2015-09-30 | FXXP | Futures | 267.2 | 270.5 | 267.2 | 270.1 | 38052.0 |
| 2015-09-30 | G | Futures | 105.31 | 105.45 | 104.99 | 105.3 | 208030.0 |
| 2015-09-30 | GF | Futures | 319.687 | 324.702 | 314.138 | 316.357 | 5320.0 |
| 2015-09-30 | GSCI | Futures | 591.77 | 592.1 | 585.73 | 585.82 | 369.0 |
| 2015-09-30 | HE | Futures | 99.759 | 101.105 | 99.46 | 99.796 | 14310.0 |
> showing 50 of 107 rows — these rows as CSV