PREVIEW / futures_daily / 2015-08-11
file: by_date/futures_daily/2015/2015-08-11.parquet size: 9 KB rows: 106
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-11 | ES | Futures | 2226.41 | 2227.47 | 2194.62 | 2204.16 | 1783349.0 |
| 2015-08-11 | NQ | Futures | 5350.16 | 5352.78 | 5236.91 | 5266.39 | 301820.0 |
| 2015-08-11 | YM | Futures | 18022.2 | 18024.2 | 17764.4 | 17824.0 | 161616.0 |
| 2015-08-11 | CL | Futures | 74.4 | 75.28 | 70.88 | 71.53 | 538005.0 |
| 2015-08-11 | GC | Futures | 1424.9 | 1444.6 | 1411.3 | 1429.9 | 191830.0 |
| 2015-08-11 | ZN | Futures | 121.226813 | 122.165747 | 121.167198 | 121.957095 | 1253972.0 |
| 2015-08-11 | A6 | Futures | 0.73267 | 0.73554 | 0.72009 | 0.72078 | 140513.0 |
| 2015-08-11 | AD | Futures | 0.7861 | 0.78672 | 0.77731 | 0.77874 | 70830.0 |
| 2015-08-11 | ALI | Futures | 2179.61 | 2179.61 | 2179.61 | 2179.61 | 0.0 |
| 2015-08-11 | B | Futures | 47.3 | 47.85 | 45.52 | 46.01 | 225226.0 |
| 2015-08-11 | B6 | Futures | 1.6404 | 1.6433 | 1.6368 | 1.6374 | 74674.0 |
| 2015-08-11 | BR | Futures | 0.17143 | 0.1723 | 0.16835 | 0.16979 | 836.0 |
| 2015-08-11 | BZ | Futures | 47.0 | 47.8 | 45.5 | 45.97 | 25091.0 |
| 2015-08-11 | C | Futures | 2210.0 | 2235.0 | 2161.0 | 2196.0 | 6413.0 |
| 2015-08-11 | CB | Futures | 164.485 | 165.458 | 164.485 | 165.458 | 6.0 |
| 2015-08-11 | CC | Futures | 2272.0 | 2320.0 | 2229.0 | 2270.0 | 34964.0 |
| 2015-08-11 | CNH | Futures | 7.0324 | 7.2506 | 7.0324 | 7.2363 | 80.0 |
| 2015-08-11 | CSC | Futures | 4.495 | 4.5 | 4.46 | 4.46 | 55.0 |
| 2015-08-11 | CT | Futures | 77.24 | 77.24 | 76.74 | 76.74 | 9.0 |
| 2015-08-11 | DC | Futures | 35.92 | 36.09 | 35.56 | 35.73 | 164.0 |
| 2015-08-11 | DX | Futures | 91.025 | 91.404 | 90.712 | 91.114 | 44824.0 |
| 2015-08-11 | E1 | Futures | 1.29215 | 1.29685 | 1.28351 | 1.28478 | 20790.0 |
| 2015-08-11 | E6 | Futures | 1.29485 | 1.30319 | 1.28815 | 1.29637 | 258539.0 |
| 2015-08-11 | E7 | Futures | 1.2878 | 1.296 | 1.281 | 1.2892 | 4518.0 |
| 2015-08-11 | EBM | Futures | 298.4 | 298.4 | 292.25 | 292.66 | 14560.0 |
| 2015-08-11 | ED | Futures | 95.6031 | 95.6318 | 95.6031 | 95.627 | 231511.0 |
| 2015-08-11 | ER | Futures | 98.122 | 98.122 | 98.117 | 98.122 | 15917.0 |
| 2015-08-11 | EW | Futures | 1581.2 | 1581.2 | 1558.8 | 1564.2 | 19453.0 |
| 2015-08-11 | FBTP | Futures | 101.12 | 101.77 | 101.06 | 101.68 | 64471.0 |
| 2015-08-11 | FBTS | Futures | 100.142 | 100.222 | 100.142 | 100.213 | 8313.0 |
| 2015-08-11 | FCE | Futures | 4316.3 | 4326.3 | 4247.5 | 4254.2 | 80653.0 |
| 2015-08-11 | FDAX | Futures | 12783.0 | 12794.6 | 12450.8 | 12479.0 | 129836.0 |
| 2015-08-11 | FESX | Futures | 2710.9 | 2716.1 | 2663.5 | 2667.2 | 990063.0 |
| 2015-08-11 | FEU3 | Futures | 98.764 | 98.764 | 98.764 | 98.764 | 12.0 |
| 2015-08-11 | FGBL | Futures | 137.6 | 138.28 | 137.52 | 138.24 | 497060.0 |
| 2015-08-11 | FGBM | Futures | 124.81 | 125.03 | 124.8 | 125.01 | 346931.0 |
| 2015-08-11 | FGBS | Futures | 111.298 | 111.313 | 111.293 | 111.308 | 161895.0 |
| 2015-08-11 | FGBX | Futures | 156.45 | 158.81 | 156.25 | 158.65 | 28387.0 |
| 2015-08-11 | FMWO | Futures | 5824.9 | 5824.9 | 5785.5 | 5785.5 | 147.0 |
| 2015-08-11 | FOAT | Futures | 125.91 | 126.49 | 125.79 | 126.49 | 54035.0 |
| 2015-08-11 | FTDX | Futures | 1676.7 | 1679.1 | 1654.6 | 1658.8 | 442.0 |
| 2015-08-11 | FTI | Futures | 428.02 | 428.02 | 423.16 | 424.36 | 25.0 |
| 2015-08-11 | FTUK | Futures | 5307.2 | 5307.2 | 5250.7 | 5262.7 | 76681.0 |
| 2015-08-11 | FVSA | Futures | 1644.88 | 1758.92 | 1640.49 | 1754.54 | 12463.0 |
| 2015-08-11 | FXXP | Futures | 305.5 | 306.5 | 301.5 | 301.7 | 13774.0 |
| 2015-08-11 | G | Futures | 102.72 | 103.36 | 102.62 | 103.27 | 170051.0 |
| 2015-08-11 | GF | Futures | 362.933 | 364.011 | 362.33 | 362.804 | 1922.0 |
| 2015-08-11 | GSCI | Futures | 619.15 | 619.15 | 605.05 | 607.03 | 2337.0 |
| 2015-08-11 | HE | Futures | 86.251 | 86.627 | 85.123 | 85.26 | 15288.0 |
| 2015-08-11 | HG | Futures | 2.9846 | 3.0314 | 2.8872 | 2.9097 | 84514.0 |
> showing 50 of 106 rows — these rows as CSV