PREVIEW / futures_daily / 2015-01-28
file: by_date/futures_daily/2015/2015-01-28.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-28 | ES | Futures | 2134.51 | 2144.99 | 2087.09 | 2087.35 | 2087277.0 |
| 2015-01-28 | NQ | Futures | 4880.19 | 4913.25 | 4779.82 | 4785.33 | 363115.0 |
| 2015-01-28 | YM | Futures | 17721.5 | 17811.1 | 17408.8 | 17415.9 | 209232.0 |
| 2015-01-28 | CL | Futures | 88.07 | 88.07 | 84.71 | 85.42 | 365440.0 |
| 2015-01-28 | GC | Futures | 1691.3 | 1692.7 | 1673.9 | 1683.0 | 150972.0 |
| 2015-01-28 | ZN | Futures | 122.16077 | 123.073516 | 122.013553 | 122.926299 | 1288777.0 |
| 2015-01-28 | A6 | Futures | 0.77417 | 0.78357 | 0.76976 | 0.77671 | 109519.0 |
| 2015-01-28 | AD | Futures | 0.82105 | 0.82115 | 0.81178 | 0.81433 | 62223.0 |
| 2015-01-28 | ALI | Futures | 2867.93 | 2867.93 | 2867.93 | 2867.93 | 14.0 |
| 2015-01-28 | B | Futures | 49.79 | 50.23 | 48.92 | 49.09 | 151159.0 |
| 2015-01-28 | B6 | Futures | 1.5968 | 1.5999 | 1.5906 | 1.5933 | 81516.0 |
| 2015-01-28 | BFX | Futures | 4276.2 | 4276.2 | 4235.1 | 4274.4 | 8.0 |
| 2015-01-28 | BR | Futures | 0.21277 | 0.2128 | 0.21137 | 0.2125 | 2145.0 |
| 2015-01-28 | BZ | Futures | 49.49 | 50.09 | 48.8 | 48.97 | 19430.0 |
| 2015-01-28 | C | Futures | 2091.0 | 2093.0 | 2073.0 | 2076.0 | 15696.0 |
| 2015-01-28 | CB | Futures | 140.478 | 141.813 | 140.478 | 141.731 | 5.0 |
| 2015-01-28 | CC | Futures | 2021.0 | 2031.0 | 2001.0 | 2004.0 | 17679.0 |
| 2015-01-28 | CNH | Futures | 7.1349 | 7.1477 | 7.1349 | 7.1477 | 1.0 |
| 2015-01-28 | CSC | Futures | 4.37 | 4.37 | 4.273 | 4.302 | 93.0 |
| 2015-01-28 | CT | Futures | 74.6 | 75.97 | 74.22 | 75.92 | 16679.0 |
| 2015-01-28 | DC | Futures | 34.38 | 34.5 | 33.87 | 34.38 | 159.0 |
| 2015-01-28 | DX | Futures | 89.323 | 89.83 | 89.162 | 89.666 | 33192.0 |
| 2015-01-28 | E1 | Futures | 1.41827 | 1.42466 | 1.40755 | 1.41317 | 12373.0 |
| 2015-01-28 | E6 | Futures | 1.33811 | 1.33952 | 1.32693 | 1.33081 | 302009.0 |
| 2015-01-28 | E7 | Futures | 1.3301 | 1.3314 | 1.319 | 1.3229 | 4960.0 |
| 2015-01-28 | EBM | Futures | 311.84 | 312.65 | 303.73 | 304.14 | 29444.0 |
| 2015-01-28 | ED | Futures | 95.4546 | 95.4594 | 95.4498 | 95.4546 | 185607.0 |
| 2015-01-28 | ER | Futures | 98.048 | 98.053 | 98.038 | 98.053 | 40376.0 |
| 2015-01-28 | EW | Futures | 1533.3 | 1541.9 | 1501.6 | 1502.2 | 22757.0 |
| 2015-01-28 | FBTP | Futures | 101.23 | 101.31 | 100.19 | 100.88 | 121738.0 |
| 2015-01-28 | FBTS | Futures | 99.076 | 99.094 | 98.969 | 99.031 | 28089.0 |
| 2015-01-28 | FCE | Futures | 3811.4 | 3811.8 | 3711.9 | 3760.8 | 112980.0 |
| 2015-01-28 | FDAX | Futures | 11903.5 | 11941.8 | 11715.8 | 11871.8 | 137505.0 |
| 2015-01-28 | FESX | Futures | 2449.8 | 2453.4 | 2385.6 | 2415.2 | 1324032.0 |
| 2015-01-28 | FEU3 | Futures | 98.665 | 98.67 | 98.665 | 98.67 | 280.0 |
| 2015-01-28 | FGBL | Futures | 138.49 | 139.38 | 138.19 | 138.99 | 674402.0 |
| 2015-01-28 | FGBM | Futures | 124.0 | 124.37 | 123.93 | 124.23 | 444671.0 |
| 2015-01-28 | FGBS | Futures | 111.078 | 111.148 | 111.068 | 111.118 | 229153.0 |
| 2015-01-28 | FGBX | Futures | 164.29 | 167.58 | 163.81 | 166.3 | 37739.0 |
| 2015-01-28 | FMWO | Futures | 5611.2 | 5633.5 | 5592.7 | 5593.9 | 528.0 |
| 2015-01-28 | FOAT | Futures | 127.49 | 127.79 | 127.17 | 127.7 | 66444.0 |
| 2015-01-28 | FTDX | Futures | 1399.3 | 1413.4 | 1396.0 | 1405.4 | 157.0 |
| 2015-01-28 | FTI | Futures | 395.14 | 395.31 | 386.31 | 390.16 | 40832.0 |
| 2015-01-28 | FTUK | Futures | 5302.6 | 5305.7 | 5219.6 | 5265.6 | 101307.0 |
| 2015-01-28 | FVSA | Futures | 1954.16 | 2031.64 | 1932.64 | 1979.99 | 8250.0 |
| 2015-01-28 | FXXP | Futures | 280.4 | 280.4 | 276.4 | 277.9 | 10788.0 |
| 2015-01-28 | G | Futures | 105.05 | 105.79 | 105.05 | 105.72 | 255587.0 |
| 2015-01-28 | GF | Futures | 343.467 | 348.19 | 341.485 | 344.732 | 4943.0 |
| 2015-01-28 | GSCI | Futures | 653.74 | 653.74 | 648.74 | 649.95 | 11.0 |
| 2015-01-28 | HE | Futures | 95.418 | 100.684 | 95.05 | 100.55 | 21515.0 |
> showing 50 of 107 rows — these rows as CSV