PREVIEW / futures_daily / 2015-08-17
file: by_date/futures_daily/2015/2015-08-17.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-08-17 | ES | Futures | 2214.49 | 2226.15 | 2198.86 | 2224.82 | 1292437.0 |
| 2015-08-17 | NQ | Futures | 5291.78 | 5332.94 | 5257.63 | 5329.43 | 191979.0 |
| 2015-08-17 | YM | Futures | 17910.2 | 17986.2 | 17764.4 | 17977.0 | 118291.0 |
| 2015-08-17 | CL | Futures | 69.87 | 70.49 | 68.94 | 69.17 | 212805.0 |
| 2015-08-17 | GC | Futures | 1437.4 | 1448.6 | 1436.6 | 1443.7 | 92581.0 |
| 2015-08-17 | ZN | Futures | 121.509984 | 121.927288 | 121.450369 | 121.867673 | 667866.0 |
| 2015-08-17 | A6 | Futures | 0.7296 | 0.73089 | 0.72633 | 0.72989 | 52093.0 |
| 2015-08-17 | AD | Futures | 0.78078 | 0.78273 | 0.77731 | 0.78109 | 46385.0 |
| 2015-08-17 | ALI | Futures | 2155.57 | 2155.57 | 2155.57 | 2155.57 | 0.0 |
| 2015-08-17 | B | Futures | 45.13 | 45.76 | 44.75 | 45.11 | 195605.0 |
| 2015-08-17 | B6 | Futures | 1.6468 | 1.6513 | 1.6393 | 1.64 | 64797.0 |
| 2015-08-17 | BR | Futures | 0.17047 | 0.17197 | 0.17002 | 0.17116 | 2301.0 |
| 2015-08-17 | BZ | Futures | 45.15 | 45.71 | 44.72 | 45.07 | 17487.0 |
| 2015-08-17 | C | Futures | 2162.0 | 2179.0 | 2158.0 | 2162.0 | 3402.0 |
| 2015-08-17 | CB | Futures | 171.901 | 175.062 | 171.901 | 173.056 | 14.0 |
| 2015-08-17 | CC | Futures | 2240.0 | 2267.0 | 2236.0 | 2241.0 | 15727.0 |
| 2015-08-17 | CNH | Futures | 7.2563 | 7.2694 | 7.2552 | 7.2609 | 41.0 |
| 2015-08-17 | CSC | Futures | 4.427 | 4.437 | 4.424 | 4.427 | 88.0 |
| 2015-08-17 | CT | Futures | 82.45 | 83.58 | 82.34 | 83.19 | 21.0 |
| 2015-08-17 | DC | Futures | 35.39 | 35.58 | 35.36 | 35.41 | 137.0 |
| 2015-08-17 | DX | Futures | 90.398 | 90.763 | 90.356 | 90.627 | 31625.0 |
| 2015-08-17 | E1 | Futures | 1.30065 | 1.30459 | 1.29685 | 1.3004 | 13140.0 |
| 2015-08-17 | E6 | Futures | 1.30624 | 1.30753 | 1.29955 | 1.30225 | 166997.0 |
| 2015-08-17 | E7 | Futures | 1.2991 | 1.3002 | 1.2925 | 1.2951 | 3223.0 |
| 2015-08-17 | EBM | Futures | 288.56 | 290.2 | 286.92 | 288.15 | 11878.0 |
| 2015-08-17 | ED | Futures | 95.6175 | 95.6246 | 95.6127 | 95.6222 | 133316.0 |
| 2015-08-17 | ER | Futures | 98.117 | 98.122 | 98.117 | 98.122 | 19671.0 |
| 2015-08-17 | EW | Futures | 1571.8 | 1587.5 | 1560.9 | 1587.1 | 15386.0 |
| 2015-08-17 | FBTP | Futures | 101.4 | 101.75 | 101.34 | 101.74 | 39093.0 |
| 2015-08-17 | FBTS | Futures | 100.159 | 100.213 | 100.151 | 100.168 | 9725.0 |
| 2015-08-17 | FCE | Futures | 4171.7 | 4210.2 | 4120.2 | 4175.5 | 33271.0 |
| 2015-08-17 | FDAX | Futures | 12194.9 | 12286.6 | 11952.2 | 12106.4 | 104450.0 |
| 2015-08-17 | FESX | Futures | 2598.4 | 2619.9 | 2556.2 | 2592.5 | 976238.0 |
| 2015-08-17 | FGBL | Futures | 138.09 | 138.37 | 137.86 | 138.27 | 347947.0 |
| 2015-08-17 | FGBM | Futures | 124.94 | 125.02 | 124.87 | 125.0 | 239134.0 |
| 2015-08-17 | FGBS | Futures | 111.303 | 111.308 | 111.278 | 111.288 | 115814.0 |
| 2015-08-17 | FGBX | Futures | 158.56 | 159.48 | 158.02 | 158.99 | 16862.0 |
| 2015-08-17 | FMWO | Futures | 5783.0 | 5788.0 | 5757.2 | 5786.7 | 249.0 |
| 2015-08-17 | FOAT | Futures | 126.21 | 126.47 | 126.03 | 126.32 | 33824.0 |
| 2015-08-17 | FTDX | Futures | 1673.0 | 1675.3 | 1649.9 | 1663.5 | 156.0 |
| 2015-08-17 | FTI | Futures | 409.91 | 411.89 | 403.5 | 407.88 | 10855.0 |
| 2015-08-17 | FTUK | Futures | 5229.3 | 5235.6 | 5164.1 | 5202.2 | 69839.0 |
| 2015-08-17 | FVSA | Futures | 1788.69 | 1903.95 | 1788.69 | 1822.84 | 8193.0 |
| 2015-08-17 | FXXP | Futures | 298.9 | 300.0 | 294.7 | 297.7 | 14053.0 |
| 2015-08-17 | G | Futures | 102.9 | 103.37 | 102.83 | 103.27 | 93906.0 |
| 2015-08-17 | GF | Futures | 361.036 | 361.036 | 357.071 | 360.735 | 1065.0 |
| 2015-08-17 | GSCI | Futures | 599.69 | 600.76 | 597.21 | 597.63 | 144.0 |
| 2015-08-17 | HE | Futures | 90.046 | 91.311 | 89.738 | 90.627 | 11526.0 |
| 2015-08-17 | HG | Futures | 2.9259 | 2.9309 | 2.8822 | 2.8966 | 45109.0 |
| 2015-08-17 | HH | Futures | 33.961 | 34.059 | 33.324 | 33.446 | 6796.0 |
> showing 50 of 105 rows — these rows as CSV