PREVIEW / futures_daily / 2015-09-16
file: by_date/futures_daily/2015/2015-09-16.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-16 | ES | Futures | 2095.86 | 2115.8 | 2087.88 | 2114.74 | 1644800.0 |
| 2015-09-16 | NQ | Futures | 5088.1 | 5123.76 | 5068.52 | 5122.3 | 214900.0 |
| 2015-09-16 | YM | Futures | 17041.9 | 17201.8 | 16989.2 | 17193.5 | 132834.0 |
| 2015-09-16 | CL | Futures | 73.13 | 76.66 | 72.6 | 76.31 | 249589.0 |
| 2015-09-16 | GC | Futures | 1425.7 | 1450.6 | 1423.8 | 1444.5 | 131151.0 |
| 2015-09-16 | ZN | Futures | 121.371576 | 121.536218 | 121.191966 | 121.191966 | 1032271.0 |
| 2015-09-16 | A6 | Futures | 0.71063 | 0.71693 | 0.70923 | 0.71593 | 73962.0 |
| 2015-09-16 | AD | Futures | 0.77261 | 0.77824 | 0.77261 | 0.77742 | 63163.0 |
| 2015-09-16 | ALI | Futures | 2225.15 | 2225.15 | 2225.15 | 2225.15 | 0.0 |
| 2015-09-16 | B | Futures | 43.56 | 45.62 | 43.24 | 45.09 | 288333.0 |
| 2015-09-16 | B6 | Futures | 1.6149 | 1.6347 | 1.6137 | 1.6304 | 103897.0 |
| 2015-09-16 | BFX | Futures | 4155.4 | 4205.6 | 4122.2 | 4122.2 | 121.0 |
| 2015-09-16 | BR | Futures | 0.15515 | 0.15666 | 0.15515 | 0.1565 | 7.0 |
| 2015-09-16 | BZ | Futures | 43.4 | 45.6 | 43.3 | 45.09 | 29740.0 |
| 2015-09-16 | C | Futures | 2334.0 | 2343.0 | 2323.0 | 2333.0 | 8262.0 |
| 2015-09-16 | CB | Futures | 190.943 | 193.772 | 190.943 | 193.772 | 1.0 |
| 2015-09-16 | CC | Futures | 2383.0 | 2409.0 | 2382.0 | 2396.0 | 17376.0 |
| 2015-09-16 | CNH | Futures | 7.1903 | 7.1903 | 7.1735 | 7.1735 | 40.0 |
| 2015-09-16 | CSC | Futures | 4.378 | 4.381 | 4.33 | 4.353 | 95.0 |
| 2015-09-16 | CT | Futures | 77.52 | 77.52 | 76.23 | 76.34 | 15.0 |
| 2015-09-16 | DC | Futures | 34.94 | 34.94 | 34.39 | 34.52 | 120.0 |
| 2015-09-16 | DX | Futures | 89.565 | 89.794 | 89.13 | 89.36 | 26770.0 |
| 2015-09-16 | E1 | Futures | 1.307 | 1.31626 | 1.30358 | 1.31017 | 19301.0 |
| 2015-09-16 | E6 | Futures | 1.32161 | 1.32829 | 1.31576 | 1.32302 | 178441.0 |
| 2015-09-16 | E7 | Futures | 1.3146 | 1.321 | 1.3086 | 1.3157 | 3394.0 |
| 2015-09-16 | EBM | Futures | 246.99 | 248.09 | 245.53 | 245.9 | 19789.0 |
| 2015-09-16 | ED | Futures | 95.6246 | 95.6391 | 95.615 | 95.6198 | 405342.0 |
| 2015-09-16 | ER | Futures | 98.122 | 98.126 | 98.122 | 98.122 | 40837.0 |
| 2015-09-16 | EW | Futures | 1498.6 | 1513.1 | 1493.4 | 1510.3 | 24990.0 |
| 2015-09-16 | FBTP | Futures | 100.96 | 101.1 | 100.65 | 100.74 | 68705.0 |
| 2015-09-16 | FBTS | Futures | 100.15 | 100.177 | 100.114 | 100.114 | 14860.0 |
| 2015-09-16 | FCE | Futures | 3812.0 | 3874.5 | 3807.4 | 3861.6 | 83671.0 |
| 2015-09-16 | FDAX | Futures | 11308.8 | 11429.9 | 11244.7 | 11318.2 | 123361.0 |
| 2015-09-16 | FESX | Futures | 2406.5 | 2435.8 | 2403.5 | 2430.5 | 1406086.0 |
| 2015-09-16 | FEU3 | Futures | 98.774 | 98.774 | 98.774 | 98.774 | 605.0 |
| 2015-09-16 | FGBL | Futures | 136.96 | 137.23 | 136.59 | 136.82 | 716704.0 |
| 2015-09-16 | FGBM | Futures | 124.75 | 124.82 | 124.65 | 124.69 | 443666.0 |
| 2015-09-16 | FGBS | Futures | 111.233 | 111.248 | 111.208 | 111.208 | 237880.0 |
| 2015-09-16 | FGBX | Futures | 153.13 | 154.11 | 152.38 | 153.09 | 33503.0 |
| 2015-09-16 | FMWO | Futures | 5450.8 | 5485.2 | 5438.4 | 5485.2 | 4166.0 |
| 2015-09-16 | FOAT | Futures | 125.22 | 125.47 | 124.83 | 125.04 | 63721.0 |
| 2015-09-16 | FTDX | Futures | 1662.8 | 1671.3 | 1662.3 | 1664.2 | 623.0 |
| 2015-09-16 | FTI | Futures | 377.03 | 381.89 | 376.38 | 380.85 | 29951.0 |
| 2015-09-16 | FTUK | Futures | 4930.7 | 5005.5 | 4930.7 | 4993.0 | 156846.0 |
| 2015-09-16 | FVSA | Futures | 2418.06 | 2422.68 | 2320.97 | 2330.21 | 15160.0 |
| 2015-09-16 | FXXP | Futures | 278.8 | 281.6 | 278.6 | 281.4 | 55301.0 |
| 2015-09-16 | G | Futures | 103.87 | 103.96 | 103.42 | 103.73 | 222739.0 |
| 2015-09-16 | GF | Futures | 341.57 | 341.925 | 334.246 | 334.601 | 5307.0 |
| 2015-09-16 | GSCI | Futures | 591.12 | 602.05 | 591.12 | 600.26 | 57.0 |
| 2015-09-16 | HE | Futures | 95.105 | 95.618 | 92.37 | 93.328 | 20040.0 |
> showing 50 of 107 rows — these rows as CSV