PREVIEW / futures_daily / 2011-12-07
file: by_date/futures_daily/2011/2011-12-07.parquet size: 9 KB rows: 99
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-07 | ES | Futures | 1253.3 | 1265.78 | 1241.82 | 1261.78 | 2724649.0 |
| 2011-12-07 | NQ | Futures | 2650.46 | 2675.29 | 2615.65 | 2649.89 | 265639.0 |
| 2011-12-07 | YM | Futures | 11638.4 | 11769.0 | 11579.8 | 11733.5 | 139165.0 |
| 2011-12-07 | CL | Futures | 189.55 | 191.11 | 186.85 | 188.39 | 330533.0 |
| 2011-12-07 | GC | Futures | 2339.8 | 2358.7 | 2327.1 | 2355.8 | 105726.0 |
| 2011-12-07 | ZN | Futures | 111.710494 | 112.246791 | 111.509383 | 112.206568 | 30651.0 |
| 2011-12-07 | A6 | Futures | 0.89934 | 0.90515 | 0.89882 | 0.90286 | 96938.0 |
| 2011-12-07 | AD | Futures | 0.99045 | 0.99415 | 0.98705 | 0.98955 | 70022.0 |
| 2011-12-07 | B | Futures | 98.39 | 99.05 | 96.95 | 97.39 | 108762.0 |
| 2011-12-07 | B6 | Futures | 1.6281 | 1.6412 | 1.6267 | 1.6379 | 99923.0 |
| 2011-12-07 | BFX | Futures | 2458.0 | 2487.7 | 2458.0 | 2487.7 | 14.0 |
| 2011-12-07 | BR | Futures | 0.25698 | 0.25698 | 0.25586 | 0.25698 | 15.0 |
| 2011-12-07 | BZ | Futures | 103.09 | 104.04 | 103.0 | 103.36 | 733.0 |
| 2011-12-07 | C | Futures | 1442.0 | 1450.0 | 1411.0 | 1412.0 | 9969.0 |
| 2011-12-07 | CB | Futures | 88.673 | 89.077 | 88.673 | 89.077 | 4.0 |
| 2011-12-07 | CC | Futures | 1689.0 | 1714.0 | 1657.0 | 1661.0 | 11226.0 |
| 2011-12-07 | CSC | Futures | 3.978 | 3.978 | 3.978 | 3.978 | 5.0 |
| 2011-12-07 | CT | Futures | 120.4 | 120.81 | 118.17 | 118.89 | 5934.0 |
| 2011-12-07 | DC | Futures | 28.59 | 28.7 | 28.56 | 28.56 | 99.0 |
| 2011-12-07 | DX | Futures | 77.138 | 77.369 | 76.922 | 77.116 | 15629.0 |
| 2011-12-07 | E1 | Futures | 1.41751 | 1.42223 | 1.41265 | 1.41961 | 22664.0 |
| 2011-12-07 | E6 | Futures | 1.60194 | 1.60792 | 1.59561 | 1.60111 | 259934.0 |
| 2011-12-07 | E7 | Futures | 1.5883 | 1.5943 | 1.582 | 1.5874 | 4233.0 |
| 2011-12-07 | EBM | Futures | 231.61 | 232.26 | 229.64 | 230.3 | 4793.0 |
| 2011-12-07 | ED | Futures | 94.9387 | 94.9531 | 94.9364 | 94.9387 | 163205.0 |
| 2011-12-07 | ER | Futures | 97.287 | 97.337 | 97.282 | 97.307 | 169617.0 |
| 2011-12-07 | EW | Futures | 889.7 | 899.4 | 875.3 | 893.8 | 38411.0 |
| 2011-12-07 | FBTP | Futures | 60.72 | 61.39 | 59.81 | 60.22 | 14916.0 |
| 2011-12-07 | FBTS | Futures | 78.693 | 79.311 | 78.637 | 78.91 | 4313.0 |
| 2011-12-07 | FCE | Futures | 2291.7 | 2317.4 | 2234.2 | 2268.2 | 122847.0 |
| 2011-12-07 | FDAX | Futures | 6621.3 | 6665.3 | 6427.5 | 6514.4 | 173109.0 |
| 2011-12-07 | FESX | Futures | 1581.7 | 1598.3 | 1534.5 | 1559.1 | 1412942.0 |
| 2011-12-07 | FEU3 | Futures | 97.851 | 97.89 | 97.851 | 97.866 | 225.0 |
| 2011-12-07 | FGBL | Futures | 109.1 | 110.23 | 108.88 | 109.9 | 867431.0 |
| 2011-12-07 | FGBM | Futures | 111.3 | 111.89 | 111.16 | 111.7 | 648371.0 |
| 2011-12-07 | FGBS | Futures | 109.526 | 109.635 | 109.476 | 109.581 | 764465.0 |
| 2011-12-07 | FGBX | Futures | 111.45 | 113.84 | 110.94 | 113.38 | 19924.0 |
| 2011-12-07 | FTDX | Futures | 644.5 | 644.5 | 627.4 | 632.0 | 150.0 |
| 2011-12-07 | FTI | Futures | 258.29 | 260.05 | 252.57 | 255.85 | 43582.0 |
| 2011-12-07 | FTUK | Futures | 4012.2 | 4043.1 | 3945.1 | 3986.4 | 124402.0 |
| 2011-12-07 | FVSA | Futures | 14609.61 | 15573.59 | 14609.61 | 15209.42 | 827.0 |
| 2011-12-07 | FXXP | Futures | 170.1 | 170.7 | 166.9 | 168.3 | 13201.0 |
| 2011-12-07 | G | Futures | 92.71 | 93.15 | 92.44 | 92.79 | 156653.0 |
| 2011-12-07 | GF | Futures | 306.579 | 308.194 | 304.317 | 307.44 | 3900.0 |
| 2011-12-07 | GSCI | Futures | 1020.99 | 1021.3 | 1009.05 | 1009.91 | 1617.0 |
| 2011-12-07 | HE | Futures | 109.873 | 109.965 | 109.164 | 109.472 | 12114.0 |
| 2011-12-07 | HG | Futures | 4.7266 | 4.7675 | 4.6448 | 4.6903 | 36345.0 |
| 2011-12-07 | HO | Futures | 2.4624 | 2.4679 | 2.4238 | 2.4258 | 24006.0 |
| 2011-12-07 | HRC | Futures | 2745.9 | 2745.9 | 2745.9 | 2745.9 | 0.0 |
| 2011-12-07 | J1 | Futures | 0.0161677 | 0.0161878 | 0.0161526 | 0.0161803 | 47870.0 |
> showing 50 of 99 rows — these rows as CSV