PREVIEW / futures_daily / 2015-01-26
file: by_date/futures_daily/2015/2015-01-26.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-01-26 | ES | Futures | 2132.94 | 2153.9 | 2122.98 | 2152.33 | 1264468.0 |
| 2015-01-26 | NQ | Futures | 4930.66 | 4964.02 | 4909.77 | 4953.57 | 187612.0 |
| 2015-01-26 | YM | Futures | 17841.7 | 17956.8 | 17754.1 | 17939.4 | 124612.0 |
| 2015-01-26 | CL | Futures | 86.86 | 89.19 | 85.23 | 86.76 | 310638.0 |
| 2015-01-26 | GC | Futures | 1691.9 | 1700.0 | 1669.2 | 1674.1 | 58779.0 |
| 2015-01-26 | ZN | Futures | 122.484648 | 122.661309 | 121.895779 | 122.013553 | 904980.0 |
| 2015-01-26 | A6 | Futures | 0.77064 | 0.77456 | 0.76711 | 0.77319 | 65921.0 |
| 2015-01-26 | AD | Futures | 0.81799 | 0.82044 | 0.81484 | 0.81738 | 45366.0 |
| 2015-01-26 | ALI | Futures | 2894.89 | 2894.89 | 2894.89 | 2894.89 | 9.0 |
| 2015-01-26 | B | Futures | 49.21 | 49.96 | 48.3 | 48.89 | 98376.0 |
| 2015-01-26 | B6 | Futures | 1.5776 | 1.5876 | 1.5754 | 1.5847 | 74184.0 |
| 2015-01-26 | BFX | Futures | 4236.4 | 4289.5 | 4236.4 | 4285.2 | 41.0 |
| 2015-01-26 | BR | Futures | 0.21043 | 0.21184 | 0.21043 | 0.21131 | 4334.0 |
| 2015-01-26 | BZ | Futures | 48.94 | 49.85 | 48.21 | 48.76 | 16830.0 |
| 2015-01-26 | C | Futures | 2117.0 | 2126.0 | 2093.0 | 2095.0 | 9640.0 |
| 2015-01-26 | CB | Futures | 137.192 | 137.192 | 136.185 | 136.185 | 1.0 |
| 2015-01-26 | CC | Futures | 2029.0 | 2043.0 | 2015.0 | 2020.0 | 14819.0 |
| 2015-01-26 | CNH | Futures | 7.1522 | 7.1658 | 7.1429 | 7.1435 | 65.0 |
| 2015-01-26 | CSC | Futures | 4.319 | 4.435 | 4.319 | 4.378 | 95.0 |
| 2015-01-26 | CT | Futures | 73.31 | 75.09 | 73.13 | 74.87 | 16780.0 |
| 2015-01-26 | DC | Futures | 34.17 | 35.11 | 34.17 | 34.74 | 320.0 |
| 2015-01-26 | DX | Futures | 90.398 | 90.729 | 89.877 | 90.033 | 35342.0 |
| 2015-01-26 | E1 | Futures | 1.45607 | 1.4636 | 1.41572 | 1.42249 | 18066.0 |
| 2015-01-26 | E6 | Futures | 1.31176 | 1.32917 | 1.30588 | 1.32587 | 394723.0 |
| 2015-01-26 | E7 | Futures | 1.3039 | 1.3212 | 1.2982 | 1.318 | 5770.0 |
| 2015-01-26 | EBM | Futures | 321.98 | 322.79 | 317.11 | 318.74 | 14263.0 |
| 2015-01-26 | ED | Futures | 95.4546 | 95.4594 | 95.4498 | 95.4546 | 100505.0 |
| 2015-01-26 | ER | Futures | 98.048 | 98.048 | 98.028 | 98.043 | 58748.0 |
| 2015-01-26 | EW | Futures | 1511.4 | 1538.9 | 1503.3 | 1537.7 | 20654.0 |
| 2015-01-26 | FBTP | Futures | 101.21 | 101.92 | 101.11 | 101.8 | 97130.0 |
| 2015-01-26 | FBTS | Futures | 99.227 | 99.227 | 98.987 | 99.156 | 18051.0 |
| 2015-01-26 | FCE | Futures | 3760.0 | 3830.2 | 3757.6 | 3813.4 | 105829.0 |
| 2015-01-26 | FDAX | Futures | 11741.4 | 12053.9 | 11737.5 | 11995.6 | 134582.0 |
| 2015-01-26 | FESX | Futures | 2412.3 | 2472.1 | 2411.6 | 2459.1 | 1143062.0 |
| 2015-01-26 | FEU3 | Futures | 98.66 | 98.66 | 98.66 | 98.66 | 17.0 |
| 2015-01-26 | FGBL | Futures | 139.11 | 139.26 | 138.45 | 138.47 | 547700.0 |
| 2015-01-26 | FGBM | Futures | 124.23 | 124.26 | 123.98 | 124.01 | 327109.0 |
| 2015-01-26 | FGBS | Futures | 111.108 | 111.123 | 111.068 | 111.073 | 198697.0 |
| 2015-01-26 | FGBX | Futures | 165.48 | 166.02 | 164.37 | 164.43 | 29866.0 |
| 2015-01-26 | FMWO | Futures | 5606.3 | 5632.3 | 5606.3 | 5631.0 | 186.0 |
| 2015-01-26 | FOAT | Futures | 127.97 | 128.13 | 127.56 | 127.62 | 57623.0 |
| 2015-01-26 | FTDX | Futures | 1380.6 | 1416.7 | 1378.2 | 1410.6 | 207.0 |
| 2015-01-26 | FTI | Futures | 389.86 | 397.99 | 389.25 | 396.22 | 39851.0 |
| 2015-01-26 | FTUK | Futures | 5257.4 | 5326.0 | 5248.8 | 5297.2 | 87555.0 |
| 2015-01-26 | FVSA | Futures | 1988.59 | 1997.2 | 1889.59 | 1906.81 | 12340.0 |
| 2015-01-26 | FXXP | Futures | 276.4 | 281.7 | 276.4 | 280.7 | 11767.0 |
| 2015-01-26 | G | Futures | 105.44 | 105.58 | 105.18 | 105.28 | 147249.0 |
| 2015-01-26 | GF | Futures | 339.334 | 343.973 | 329.634 | 337.352 | 8935.0 |
| 2015-01-26 | GSCI | Futures | 653.31 | 658.91 | 650.98 | 651.59 | 71.0 |
| 2015-01-26 | HE | Futures | 95.72 | 98.806 | 95.117 | 97.464 | 20243.0 |
> showing 50 of 107 rows — these rows as CSV