PREVIEW / futures_daily / 2016-03-16
file: by_date/futures_daily/2016/2016-03-16.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-03-16 | ES | Futures | 2154.68 | 2171.86 | 2144.21 | 2165.96 | 2043775.0 |
| 2016-03-16 | NQ | Futures | 5122.15 | 5179.14 | 5100.12 | 5156.23 | 283358.0 |
| 2016-03-16 | YM | Futures | 17834.9 | 17974.2 | 17773.5 | 17921.2 | 147997.0 |
| 2016-03-16 | CL | Futures | 46.71 | 48.72 | 46.6 | 48.55 | 374538.0 |
| 2016-03-16 | GC | Futures | 1584.4 | 1625.2 | 1576.6 | 1580.2 | 203811.0 |
| 2016-03-16 | ZN | Futures | 123.910668 | 124.634851 | 123.6391 | 124.408544 | 1330804.0 |
| 2016-03-16 | A6 | Futures | 0.75199 | 0.76211 | 0.74743 | 0.75897 | 106524.0 |
| 2016-03-16 | AD | Futures | 0.76593 | 0.78096 | 0.76286 | 0.77717 | 78721.0 |
| 2016-03-16 | ALI | Futures | 2079.51 | 2079.51 | 2079.51 | 2079.51 | 0.0 |
| 2016-03-16 | B | Futures | 32.6 | 33.68 | 32.34 | 33.59 | 263872.0 |
| 2016-03-16 | B6 | Futures | 1.4907 | 1.5035 | 1.4803 | 1.4982 | 114647.0 |
| 2016-03-16 | BFX | Futures | 4019.6 | 4024.9 | 3989.8 | 4024.9 | 50.0 |
| 2016-03-16 | BR | Futures | 0.16704 | 0.16948 | 0.16529 | 0.16948 | 1101.0 |
| 2016-03-16 | BZ | Futures | 32.14 | 33.32 | 32.03 | 33.25 | 31153.0 |
| 2016-03-16 | C | Futures | 2381.0 | 2386.0 | 2365.0 | 2385.0 | 7008.0 |
| 2016-03-16 | CB | Futures | 243.952 | 245.11 | 242.976 | 243.312 | 24.0 |
| 2016-03-16 | CC | Futures | 2233.0 | 2235.0 | 2208.0 | 2226.0 | 10130.0 |
| 2016-03-16 | CNH | Futures | 7.1222 | 7.1301 | 7.0779 | 7.0941 | 6.0 |
| 2016-03-16 | CSC | Futures | 3.52 | 3.532 | 3.518 | 3.52 | 19.0 |
| 2016-03-16 | CT | Futures | 66.61 | 67.2 | 66.06 | 66.98 | 12292.0 |
| 2016-03-16 | DC | Futures | 27.45 | 27.72 | 27.45 | 27.56 | 33.0 |
| 2016-03-16 | DX | Futures | 90.118 | 90.518 | 89.092 | 89.432 | 30941.0 |
| 2016-03-16 | E1 | Futures | 1.27795 | 1.29391 | 1.27243 | 1.28788 | 21182.0 |
| 2016-03-16 | E6 | Futures | 1.29873 | 1.31476 | 1.29313 | 1.30905 | 229317.0 |
| 2016-03-16 | E7 | Futures | 1.2916 | 1.3076 | 1.2861 | 1.3019 | 5135.0 |
| 2016-03-16 | EBM | Futures | 202.35 | 205.25 | 201.38 | 202.03 | 41393.0 |
| 2016-03-16 | ED | Futures | 95.6003 | 95.6774 | 95.581 | 95.6726 | 580523.0 |
| 2016-03-16 | ER | Futures | 98.239 | 98.249 | 98.234 | 98.244 | 79127.0 |
| 2016-03-16 | EW | Futures | 1466.2 | 1483.9 | 1458.8 | 1481.1 | 24728.0 |
| 2016-03-16 | FBON | Futures | 117.92 | 117.96 | 117.7 | 117.88 | 134.0 |
| 2016-03-16 | FBTP | Futures | 106.77 | 107.15 | 106.7 | 107.1 | 73836.0 |
| 2016-03-16 | FBTS | Futures | 100.961 | 101.015 | 100.943 | 100.961 | 27049.0 |
| 2016-03-16 | FCE | Futures | 3728.0 | 3744.2 | 3691.7 | 3710.5 | 113158.0 |
| 2016-03-16 | FDAX | Futures | 10801.4 | 10869.2 | 10752.6 | 10825.8 | 161202.0 |
| 2016-03-16 | FDXM | Futures | 10332.3 | 10405.8 | 10294.1 | 10367.5 | 1883.0 |
| 2016-03-16 | FESX | Futures | 2334.5 | 2347.0 | 2312.7 | 2326.7 | 1642689.0 |
| 2016-03-16 | FEU3 | Futures | 98.902 | 98.902 | 98.902 | 98.902 | 1.0 |
| 2016-03-16 | FGBL | Futures | 144.19 | 144.72 | 144.08 | 144.45 | 672951.0 |
| 2016-03-16 | FGBM | Futures | 126.94 | 127.11 | 126.86 | 127.0 | 451914.0 |
| 2016-03-16 | FGBS | Futures | 111.563 | 111.598 | 111.548 | 111.573 | 189429.0 |
| 2016-03-16 | FGBX | Futures | 166.88 | 168.44 | 166.77 | 167.81 | 30457.0 |
| 2016-03-16 | FMWO | Futures | 5472.2 | 5478.4 | 5469.7 | 5475.9 | 4034.0 |
| 2016-03-16 | FOAT | Futures | 131.76 | 132.32 | 131.7 | 132.12 | 67261.0 |
| 2016-03-16 | FTDX | Futures | 1561.4 | 1561.4 | 1555.2 | 1557.6 | 565.0 |
| 2016-03-16 | FTI | Futures | 392.25 | 394.29 | 390.03 | 392.91 | 21868.0 |
| 2016-03-16 | FTUK | Futures | 5033.7 | 5054.3 | 5005.2 | 5040.7 | 213712.0 |
| 2016-03-16 | FVSA | Futures | 2771.73 | 2876.64 | 2766.21 | 2826.94 | 14047.0 |
| 2016-03-16 | FXXP | Futures | 268.6 | 269.4 | 266.6 | 268.1 | 131471.0 |
| 2016-03-16 | G | Futures | 107.52 | 107.87 | 107.45 | 107.72 | 153633.0 |
| 2016-03-16 | GF | Futures | 323.931 | 326.336 | 321.281 | 324.864 | 4161.0 |
> showing 50 of 110 rows — these rows as CSV