PREVIEW / futures_daily / 2016-01-14
file: by_date/futures_daily/2016/2016-01-14.parquet size: 9 KB rows: 110
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-14 | ES | Futures | 2012.1 | 2058.83 | 1998.48 | 2044.95 | 3045826.0 |
| 2016-01-14 | NQ | Futures | 4902.0 | 5041.51 | 4834.6 | 4991.1 | 526505.0 |
| 2016-01-14 | YM | Futures | 16627.2 | 16961.4 | 16536.1 | 16847.6 | 304868.0 |
| 2016-01-14 | CL | Futures | 45.33 | 46.86 | 44.89 | 46.26 | 407645.0 |
| 2016-01-14 | GC | Futures | 1410.4 | 1412.7 | 1381.4 | 1384.6 | 174240.0 |
| 2016-01-14 | ZN | Futures | 123.070163 | 123.431161 | 122.859581 | 123.055121 | 1549100.0 |
| 2016-01-14 | A6 | Futures | 0.69488 | 0.69919 | 0.69047 | 0.69909 | 136600.0 |
| 2016-01-14 | AD | Futures | 0.71306 | 0.71337 | 0.7102 | 0.71235 | 94301.0 |
| 2016-01-14 | ALI | Futures | 2077.09 | 2077.09 | 2077.09 | 2077.09 | 0.0 |
| 2016-01-14 | B | Futures | 26.05 | 26.88 | 25.59 | 26.61 | 409375.0 |
| 2016-01-14 | B6 | Futures | 1.5171 | 1.5199 | 1.511 | 1.5156 | 80803.0 |
| 2016-01-14 | BFX | Futures | 4135.9 | 4151.0 | 4116.7 | 4151.0 | 49.0 |
| 2016-01-14 | BR | Futures | 0.15435 | 0.15494 | 0.15403 | 0.15494 | 10.0 |
| 2016-01-14 | BZ | Futures | 25.91 | 26.6 | 25.34 | 26.33 | 38299.0 |
| 2016-01-14 | C | Futures | 2182.0 | 2192.0 | 2165.0 | 2169.0 | 7483.0 |
| 2016-01-14 | CB | Futures | 263.689 | 274.821 | 263.689 | 274.821 | 8.0 |
| 2016-01-14 | CC | Futures | 2130.0 | 2134.0 | 2097.0 | 2106.0 | 15830.0 |
| 2016-01-14 | CNH | Futures | 7.3192 | 7.373 | 7.3188 | 7.3466 | 61.0 |
| 2016-01-14 | CSC | Futures | 3.78 | 3.824 | 3.78 | 3.794 | 52.0 |
| 2016-01-14 | CT | Futures | 72.65 | 73.16 | 72.33 | 72.51 | 13944.0 |
| 2016-01-14 | DC | Futures | 29.83 | 30.38 | 29.83 | 29.98 | 321.0 |
| 2016-01-14 | DX | Futures | 92.401 | 92.789 | 92.154 | 92.625 | 38487.0 |
| 2016-01-14 | E1 | Futures | 1.25794 | 1.264 | 1.25377 | 1.2587 | 18996.0 |
| 2016-01-14 | E6 | Futures | 1.27414 | 1.28151 | 1.26871 | 1.27198 | 228696.0 |
| 2016-01-14 | E7 | Futures | 1.2668 | 1.2743 | 1.2616 | 1.2648 | 7196.0 |
| 2016-01-14 | EBM | Futures | 235.54 | 236.24 | 233.77 | 234.83 | 30142.0 |
| 2016-01-14 | ED | Futures | 95.5832 | 95.6073 | 95.5784 | 95.6025 | 334847.0 |
| 2016-01-14 | ER | Futures | 98.234 | 98.239 | 98.225 | 98.225 | 92036.0 |
| 2016-01-14 | EW | Futures | 1340.6 | 1364.8 | 1328.6 | 1357.1 | 22676.0 |
| 2016-01-14 | FBON | Futures | 115.24 | 115.54 | 115.2 | 115.23 | 445.0 |
| 2016-01-14 | FBTP | Futures | 105.11 | 105.3 | 104.87 | 104.95 | 108611.0 |
| 2016-01-14 | FBTS | Futures | 100.846 | 100.864 | 100.811 | 100.811 | 19469.0 |
| 2016-01-14 | FCE | Futures | 3630.2 | 3673.5 | 3548.8 | 3614.7 | 78248.0 |
| 2016-01-14 | FDAX | Futures | 10670.2 | 10782.4 | 10423.0 | 10645.8 | 167193.0 |
| 2016-01-14 | FDXM | Futures | 10202.3 | 10306.0 | 9964.8 | 10179.5 | 36935.0 |
| 2016-01-14 | FESX | Futures | 2300.1 | 2332.0 | 2253.7 | 2302.3 | 2128015.0 |
| 2016-01-14 | FEU3 | Futures | 98.892 | 98.892 | 98.882 | 98.882 | 166.0 |
| 2016-01-14 | FGBL | Futures | 140.94 | 141.31 | 140.61 | 140.77 | 764449.0 |
| 2016-01-14 | FGBM | Futures | 126.01 | 126.14 | 125.96 | 126.03 | 468036.0 |
| 2016-01-14 | FGBS | Futures | 111.518 | 111.538 | 111.493 | 111.508 | 248787.0 |
| 2016-01-14 | FGBX | Futures | 160.17 | 160.91 | 158.48 | 158.81 | 38635.0 |
| 2016-01-14 | FMWO | Futures | 5180.8 | 5203.2 | 5154.6 | 5203.2 | 562.0 |
| 2016-01-14 | FOAT | Futures | 128.61 | 128.92 | 128.33 | 128.39 | 111341.0 |
| 2016-01-14 | FTDX | Futures | 1623.5 | 1629.3 | 1583.2 | 1604.8 | 775.0 |
| 2016-01-14 | FTI | Futures | 362.69 | 369.47 | 356.32 | 364.24 | 13247.0 |
| 2016-01-14 | FTUK | Futures | 4732.1 | 4851.6 | 4708.4 | 4793.6 | 166721.0 |
| 2016-01-14 | FVSA | Futures | 2783.16 | 2867.95 | 2698.37 | 2778.17 | 16888.0 |
| 2016-01-14 | FXXP | Futures | 266.4 | 269.7 | 261.0 | 266.4 | 64822.0 |
| 2016-01-14 | G | Futures | 105.78 | 106.24 | 105.7 | 105.84 | 200694.0 |
| 2016-01-14 | GF | Futures | 307.783 | 309.207 | 301.892 | 303.905 | 4869.0 |
> showing 50 of 110 rows — these rows as CSV