PREVIEW / futures_daily / 2014-08-26
file: by_date/futures_daily/2014/2014-08-26.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 |
|---|---|---|---|---|---|---|---|
| 2014-08-26 | ES | Futures | 2071.88 | 2080.45 | 2069.54 | 2076.03 | 878014.0 |
| 2014-08-26 | NQ | Futures | 4689.25 | 4702.51 | 4686.36 | 4698.48 | 147208.0 |
| 2014-08-26 | YM | Futures | 17204.2 | 17285.9 | 17190.1 | 17250.6 | 82766.0 |
| 2014-08-26 | CL | Futures | 173.9 | 175.74 | 173.88 | 174.83 | 176280.0 |
| 2014-08-26 | GC | Futures | 1675.5 | 1694.5 | 1673.3 | 1685.7 | 103850.0 |
| 2014-08-26 | ZN | Futures | 117.629901 | 117.834145 | 117.586134 | 117.673667 | 1951387.0 |
| 2014-08-26 | A6 | Futures | 0.8974 | 0.90059 | 0.89479 | 0.89827 | 78967.0 |
| 2014-08-26 | AD | Futures | 0.92423 | 0.92789 | 0.92302 | 0.92687 | 42596.0 |
| 2014-08-26 | ALI | Futures | 3059.97 | 3059.97 | 3045.04 | 3045.04 | 5.0 |
| 2014-08-26 | B | Futures | 107.99 | 108.73 | 107.73 | 107.87 | 78207.0 |
| 2014-08-26 | B6 | Futures | 1.7417 | 1.7444 | 1.7384 | 1.7393 | 73337.0 |
| 2014-08-26 | BFX | Futures | 3859.0 | 3882.3 | 3859.0 | 3878.6 | 74.0 |
| 2014-08-26 | BR | Futures | 0.2304 | 0.23248 | 0.2304 | 0.23243 | 5432.0 |
| 2014-08-26 | BZ | Futures | 108.88 | 109.5 | 108.5 | 108.63 | 9303.0 |
| 2014-08-26 | C | Futures | 2182.0 | 2182.0 | 2155.0 | 2178.0 | 1933.0 |
| 2014-08-26 | CB | Futures | 143.749 | 143.749 | 142.207 | 142.593 | 14.0 |
| 2014-08-26 | CC | Futures | 2378.0 | 2384.0 | 2353.0 | 2374.0 | 8777.0 |
| 2014-08-26 | CNH | Futures | 7.0579 | 7.0579 | 7.0547 | 7.0547 | 1.0 |
| 2014-08-26 | CSC | Futures | 5.116 | 5.129 | 5.116 | 5.124 | 4.0 |
| 2014-08-26 | CT | Futures | 85.35 | 86.17 | 85.19 | 86.11 | 12.0 |
| 2014-08-26 | DC | Futures | 40.99 | 41.64 | 40.97 | 41.53 | 102.0 |
| 2014-08-26 | DX | Futures | 78.444 | 78.534 | 78.292 | 78.481 | 16424.0 |
| 2014-08-26 | E1 | Futures | 1.40007 | 1.40302 | 1.39648 | 1.39763 | 39861.0 |
| 2014-08-26 | E6 | Futures | 1.55657 | 1.55928 | 1.5535 | 1.55444 | 162519.0 |
| 2014-08-26 | E7 | Futures | 1.5465 | 1.5492 | 1.5434 | 1.5443 | 2304.0 |
| 2014-08-26 | ED | Futures | 95.4139 | 95.4162 | 95.4115 | 95.4139 | 56787.0 |
| 2014-08-26 | ER | Futures | 97.955 | 97.955 | 97.94 | 97.945 | 71892.0 |
| 2014-08-26 | EW | Futures | 1484.5 | 1492.1 | 1482.9 | 1490.6 | 8438.0 |
| 2014-08-26 | FBTP | Futures | 94.34 | 94.89 | 94.34 | 94.65 | 55279.0 |
| 2014-08-26 | FBTS | Futures | 98.925 | 98.952 | 98.863 | 98.89 | 11548.0 |
| 2014-08-26 | FCE | Futures | 3440.5 | 3501.4 | 3439.7 | 3497.4 | 78608.0 |
| 2014-08-26 | FDAX | Futures | 10420.6 | 10564.8 | 10399.7 | 10563.2 | 88574.0 |
| 2014-08-26 | FESX | Futures | 2266.3 | 2300.1 | 2265.6 | 2299.4 | 873086.0 |
| 2014-08-26 | FEU3 | Futures | 98.567 | 98.571 | 98.562 | 98.567 | 59.0 |
| 2014-08-26 | FGBL | Futures | 131.22 | 131.33 | 131.09 | 131.15 | 559054.0 |
| 2014-08-26 | FGBM | Futures | 122.47 | 122.48 | 122.34 | 122.36 | 381528.0 |
| 2014-08-26 | FGBS | Futures | 110.928 | 110.928 | 110.868 | 110.873 | 400789.0 |
| 2014-08-26 | FGBX | Futures | 142.48 | 142.7 | 142.3 | 142.5 | 19302.0 |
| 2014-08-26 | FMWO | Futures | 5800.3 | 5829.2 | 5800.3 | 5829.2 | 145.0 |
| 2014-08-26 | FOAT | Futures | 121.34 | 121.61 | 121.3 | 121.4 | 85350.0 |
| 2014-08-26 | FTDX | Futures | 1166.9 | 1169.2 | 1160.3 | 1169.2 | 290.0 |
| 2014-08-26 | FTI | Futures | 352.04 | 355.83 | 351.82 | 355.66 | 21107.0 |
| 2014-08-26 | FTUK | Futures | 5225.0 | 5249.6 | 5211.5 | 5248.5 | 75434.0 |
| 2014-08-26 | FVSA | Futures | 1412.28 | 1433.68 | 1395.16 | 1395.16 | 6975.0 |
| 2014-08-26 | FXXP | Futures | 256.2 | 258.6 | 256.1 | 258.5 | 7106.0 |
| 2014-08-26 | G | Futures | 96.3 | 96.65 | 96.29 | 96.63 | 464412.0 |
| 2014-08-26 | GF | Futures | 330.433 | 333.419 | 329.89 | 332.294 | 1376.0 |
| 2014-08-26 | GSCI | Futures | 1012.75 | 1017.28 | 1010.99 | 1013.34 | 104.0 |
| 2014-08-26 | HE | Futures | 112.644 | 115.364 | 112.312 | 114.971 | 23260.0 |
| 2014-08-26 | HG | Futures | 4.1071 | 4.1084 | 4.0659 | 4.0748 | 23039.0 |
> showing 50 of 105 rows — these rows as CSV