PREVIEW / futures_daily / 2015-09-25
file: by_date/futures_daily/2015/2015-09-25.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-25 | ES | Futures | 2035.22 | 2075.38 | 2032.03 | 2041.61 | 2080724.0 |
| 2015-09-25 | NQ | Futures | 4948.09 | 5046.01 | 4893.72 | 4926.46 | 344913.0 |
| 2015-09-25 | YM | Futures | 16605.4 | 16892.3 | 16589.9 | 16717.9 | 231288.0 |
| 2015-09-25 | CL | Futures | 72.36 | 74.49 | 72.05 | 73.4 | 338622.0 |
| 2015-09-25 | GC | Futures | 1485.8 | 1485.9 | 1471.7 | 1478.8 | 140350.0 |
| 2015-09-25 | ZN | Futures | 122.494139 | 122.598912 | 122.075049 | 122.464204 | 1202302.0 |
| 2015-09-25 | A6 | Futures | 0.69593 | 0.70143 | 0.69563 | 0.69933 | 75162.0 |
| 2015-09-25 | AD | Futures | 0.7681 | 0.76994 | 0.76656 | 0.7682 | 50221.0 |
| 2015-09-25 | ALI | Futures | 2134.21 | 2134.21 | 2134.21 | 2134.21 | 30.0 |
| 2015-09-25 | B | Futures | 43.66 | 44.54 | 43.43 | 44.1 | 116545.0 |
| 2015-09-25 | B6 | Futures | 1.6026 | 1.6066 | 1.5933 | 1.5994 | 79042.0 |
| 2015-09-25 | BFX | Futures | 4043.5 | 4071.9 | 4043.5 | 4071.9 | 6.0 |
| 2015-09-25 | BR | Futures | 0.15392 | 0.15392 | 0.15004 | 0.15146 | 214.0 |
| 2015-09-25 | BZ | Futures | 43.65 | 44.31 | 43.22 | 43.86 | 14025.0 |
| 2015-09-25 | C | Futures | 2386.0 | 2405.0 | 2381.0 | 2388.0 | 7923.0 |
| 2015-09-25 | CB | Futures | 198.053 | 198.053 | 197.438 | 197.438 | 6.0 |
| 2015-09-25 | CC | Futures | 2423.0 | 2426.0 | 2388.0 | 2402.0 | 15962.0 |
| 2015-09-25 | CNH | Futures | 7.1882 | 7.1882 | 7.1647 | 7.1673 | 6.0 |
| 2015-09-25 | CSC | Futures | 4.355 | 4.355 | 4.337 | 4.337 | 71.0 |
| 2015-09-25 | CT | Futures | 72.1 | 73.38 | 72.1 | 72.74 | 13867.0 |
| 2015-09-25 | DC | Futures | 35.26 | 35.32 | 34.92 | 34.99 | 77.0 |
| 2015-09-25 | DX | Futures | 90.145 | 90.608 | 90.038 | 90.191 | 43885.0 |
| 2015-09-25 | E1 | Futures | 1.30053 | 1.30548 | 1.29216 | 1.29774 | 17422.0 |
| 2015-09-25 | E6 | Futures | 1.31107 | 1.31517 | 1.30381 | 1.31236 | 216443.0 |
| 2015-09-25 | E7 | Futures | 1.3042 | 1.3078 | 1.2967 | 1.3051 | 5013.0 |
| 2015-09-25 | EBM | Futures | 253.21 | 258.32 | 252.84 | 257.96 | 21220.0 |
| 2015-09-25 | ED | Futures | 95.6967 | 95.7111 | 95.6775 | 95.7015 | 281369.0 |
| 2015-09-25 | ER | Futures | 98.126 | 98.136 | 98.126 | 98.131 | 25328.0 |
| 2015-09-25 | EW | Futures | 1455.6 | 1478.5 | 1451.3 | 1456.2 | 19432.0 |
| 2015-09-25 | FBTP | Futures | 102.25 | 102.28 | 101.84 | 101.97 | 84388.0 |
| 2015-09-25 | FBTS | Futures | 100.275 | 100.284 | 100.248 | 100.266 | 16282.0 |
| 2015-09-25 | FCE | Futures | 3663.7 | 3752.4 | 3657.0 | 3723.7 | 136038.0 |
| 2015-09-25 | FDAX | Futures | 10570.9 | 10734.5 | 10530.7 | 10688.8 | 125834.0 |
| 2015-09-25 | FDIV | Futures | 128.03 | 128.5 | 128.03 | 128.08 | 10.0 |
| 2015-09-25 | FESX | Futures | 2289.6 | 2337.6 | 2283.6 | 2328.6 | 1500344.0 |
| 2015-09-25 | FGBL | Futures | 138.59 | 138.65 | 138.04 | 138.31 | 620298.0 |
| 2015-09-25 | FGBM | Futures | 125.09 | 125.15 | 124.97 | 125.08 | 375933.0 |
| 2015-09-25 | FGBS | Futures | 111.273 | 111.283 | 111.253 | 111.278 | 172107.0 |
| 2015-09-25 | FGBX | Futures | 158.51 | 158.57 | 156.57 | 157.37 | 25169.0 |
| 2015-09-25 | FMWO | Futures | 5356.6 | 5357.9 | 5340.5 | 5355.4 | 363.0 |
| 2015-09-25 | FOAT | Futures | 126.69 | 126.78 | 126.21 | 126.41 | 63138.0 |
| 2015-09-25 | FTDX | Futures | 1599.7 | 1656.2 | 1599.7 | 1650.5 | 209.0 |
| 2015-09-25 | FTI | Futures | 361.05 | 369.08 | 360.14 | 367.26 | 44749.0 |
| 2015-09-25 | FTUK | Futures | 4828.6 | 4904.2 | 4823.8 | 4892.1 | 118828.0 |
| 2015-09-25 | FVSA | Futures | 2519.77 | 2663.1 | 2487.41 | 2501.28 | 7493.0 |
| 2015-09-25 | FXXP | Futures | 268.2 | 272.6 | 268.2 | 271.4 | 19668.0 |
| 2015-09-25 | G | Futures | 105.02 | 105.08 | 104.55 | 104.67 | 182965.0 |
| 2015-09-25 | GF | Futures | 324.747 | 327.765 | 323.593 | 327.765 | 2337.0 |
| 2015-09-25 | GSCI | Futures | 587.37 | 592.34 | 587.37 | 591.61 | 141.0 |
| 2015-09-25 | HE | Futures | 97.815 | 99.535 | 97.515 | 98.375 | 14728.0 |
> showing 50 of 107 rows — these rows as CSV