PREVIEW / futures_daily / 2015-09-15
file: by_date/futures_daily/2015/2015-09-15.parquet size: 9 KB rows: 105
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-15 | ES | Futures | 2067.4 | 2098.78 | 2058.63 | 2095.59 | 2035624.0 |
| 2015-09-15 | NQ | Futures | 5024.97 | 5102.43 | 5004.21 | 5087.23 | 246233.0 |
| 2015-09-15 | YM | Futures | 16789.1 | 17066.6 | 16720.0 | 17045.0 | 149660.0 |
| 2015-09-15 | CL | Futures | 71.54 | 73.29 | 71.23 | 72.28 | 170349.0 |
| 2015-09-15 | GC | Futures | 1429.1 | 1430.9 | 1421.9 | 1423.3 | 78878.0 |
| 2015-09-15 | ZN | Futures | 122.179821 | 122.329497 | 121.251836 | 121.371576 | 1005405.0 |
| 2015-09-15 | A6 | Futures | 0.71023 | 0.71333 | 0.70533 | 0.70923 | 59584.0 |
| 2015-09-15 | AD | Futures | 0.7722 | 0.77435 | 0.77148 | 0.77302 | 40576.0 |
| 2015-09-15 | ALI | Futures | 2190.96 | 2190.96 | 2190.96 | 2190.96 | 0.0 |
| 2015-09-15 | B | Futures | 43.14 | 43.73 | 42.61 | 43.28 | 268720.0 |
| 2015-09-15 | B6 | Futures | 1.6238 | 1.6272 | 1.6136 | 1.6138 | 59010.0 |
| 2015-09-15 | BFX | Futures | 4104.6 | 4124.4 | 4100.4 | 4124.4 | 33.0 |
| 2015-09-15 | BR | Futures | 0.15884 | 0.15884 | 0.1542 | 0.15515 | 171.0 |
| 2015-09-15 | BZ | Futures | 43.11 | 43.69 | 42.59 | 43.27 | 25784.0 |
| 2015-09-15 | C | Futures | 2355.0 | 2355.0 | 2322.0 | 2328.0 | 10266.0 |
| 2015-09-15 | CC | Futures | 2408.0 | 2410.0 | 2363.0 | 2374.0 | 17871.0 |
| 2015-09-15 | CNH | Futures | 7.1823 | 7.1895 | 7.1822 | 7.1895 | 140.0 |
| 2015-09-15 | CSC | Futures | 4.391 | 4.427 | 4.378 | 4.389 | 43.0 |
| 2015-09-15 | CT | Futures | 77.65 | 77.65 | 76.42 | 76.87 | 11.0 |
| 2015-09-15 | DC | Futures | 34.57 | 35.06 | 34.48 | 34.83 | 82.0 |
| 2015-09-15 | DX | Futures | 89.28 | 89.645 | 89.116 | 89.584 | 22339.0 |
| 2015-09-15 | E1 | Futures | 1.31423 | 1.31651 | 1.30345 | 1.30586 | 14385.0 |
| 2015-09-15 | E6 | Futures | 1.32759 | 1.32934 | 1.32091 | 1.32255 | 153718.0 |
| 2015-09-15 | E7 | Futures | 1.3203 | 1.322 | 1.3137 | 1.3153 | 3777.0 |
| 2015-09-15 | EBM | Futures | 249.19 | 251.01 | 247.36 | 247.72 | 19266.0 |
| 2015-09-15 | ED | Futures | 95.6535 | 95.6583 | 95.6198 | 95.6294 | 332147.0 |
| 2015-09-15 | ER | Futures | 98.126 | 98.131 | 98.122 | 98.126 | 42074.0 |
| 2015-09-15 | EW | Futures | 1476.6 | 1498.9 | 1472.6 | 1498.0 | 34974.0 |
| 2015-09-15 | FBTP | Futures | 101.28 | 101.52 | 100.88 | 101.03 | 73789.0 |
| 2015-09-15 | FBTS | Futures | 100.195 | 100.204 | 100.132 | 100.159 | 22977.0 |
| 2015-09-15 | FCE | Futures | 3773.3 | 3819.9 | 3742.4 | 3797.8 | 160187.0 |
| 2015-09-15 | FDAX | Futures | 11252.4 | 11344.7 | 11129.7 | 11290.0 | 163099.0 |
| 2015-09-15 | FESX | Futures | 2380.3 | 2410.3 | 2357.1 | 2399.0 | 1848814.0 |
| 2015-09-15 | FGBL | Futures | 138.18 | 138.23 | 136.83 | 137.13 | 656786.0 |
| 2015-09-15 | FGBM | Futures | 125.07 | 125.08 | 124.72 | 124.78 | 441249.0 |
| 2015-09-15 | FGBS | Futures | 111.258 | 111.273 | 111.228 | 111.233 | 221617.0 |
| 2015-09-15 | FGBX | Futures | 156.19 | 156.33 | 152.72 | 153.58 | 26966.0 |
| 2015-09-15 | FMWO | Futures | 5367.1 | 5415.1 | 5353.5 | 5410.1 | 4626.0 |
| 2015-09-15 | FOAT | Futures | 126.22 | 126.28 | 125.13 | 125.39 | 66310.0 |
| 2015-09-15 | FTDX | Futures | 1636.7 | 1653.3 | 1626.8 | 1650.5 | 1324.0 |
| 2015-09-15 | FTI | Futures | 372.43 | 377.64 | 369.13 | 375.28 | 21850.0 |
| 2015-09-15 | FTUK | Futures | 4882.5 | 4941.6 | 4814.1 | 4920.7 | 146009.0 |
| 2015-09-15 | FVSA | Futures | 2561.38 | 2653.85 | 2427.3 | 2538.27 | 7048.0 |
| 2015-09-15 | FXXP | Futures | 274.7 | 277.9 | 273.2 | 277.2 | 104575.0 |
| 2015-09-15 | G | Futures | 104.49 | 104.54 | 103.85 | 104.02 | 173048.0 |
| 2015-09-15 | GF | Futures | 345.609 | 347.563 | 340.46 | 342.236 | 4526.0 |
| 2015-09-15 | GSCI | Futures | 587.86 | 590.14 | 587.86 | 589.49 | 1369.0 |
| 2015-09-15 | HE | Futures | 91.55 | 95.413 | 91.311 | 94.866 | 21172.0 |
| 2015-09-15 | HG | Futures | 3.0207 | 3.0426 | 2.99 | 3.0375 | 36877.0 |
| 2015-09-15 | HH | Futures | 33.796 | 34.065 | 33.198 | 33.296 | 2239.0 |
> showing 50 of 105 rows — these rows as CSV