PREVIEW / futures_daily / 2017-08-03
file: by_date/futures_daily/2017/2017-08-03.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2017-08-03 | ES | Futures | 2687.98 | 2689.34 | 2680.1 | 2686.35 | 1087355.0 |
| 2017-08-03 | NQ | Futures | 6948.92 | 6964.49 | 6908.95 | 6923.94 | 289423.0 |
| 2017-08-03 | YM | Futures | 23226.8 | 23244.8 | 23180.3 | 23228.9 | 85530.0 |
| 2017-08-03 | CL | Futures | 51.01 | 51.39 | 50.18 | 50.43 | 837763.0 |
| 2017-08-03 | GC | Futures | 1619.3 | 1624.9 | 1606.9 | 1621.6 | 207024.0 |
| 2017-08-03 | ZN | Futures | 124.150029 | 124.565555 | 124.134639 | 124.457826 | 1088192.0 |
| 2017-08-03 | A6 | Futures | 0.818 | 0.818 | 0.81266 | 0.81554 | 92405.0 |
| 2017-08-03 | AD | Futures | 0.80985 | 0.81077 | 0.80655 | 0.80863 | 65406.0 |
| 2017-08-03 | ALI | Futures | 2531.83 | 2531.83 | 2531.83 | 2531.83 | 0.0 |
| 2017-08-03 | B | Futures | 36.54 | 37.0 | 36.21 | 36.38 | 402658.0 |
| 2017-08-03 | B6 | Futures | 1.384 | 1.3886 | 1.3722 | 1.3746 | 136562.0 |
| 2017-08-03 | BR | Futures | 0.2367 | 0.23737 | 0.23629 | 0.23678 | 2054.0 |
| 2017-08-03 | BZ | Futures | 36.26 | 36.67 | 35.92 | 36.07 | 34779.0 |
| 2017-08-03 | C | Futures | 1599.0 | 1616.0 | 1591.0 | 1606.0 | 8620.0 |
| 2017-08-03 | CB | Futures | 332.084 | 335.095 | 332.084 | 334.456 | 28.0 |
| 2017-08-03 | CC | Futures | 1572.0 | 1582.0 | 1544.0 | 1565.0 | 29426.0 |
| 2017-08-03 | CSC | Futures | 3.577 | 3.598 | 3.509 | 3.526 | 108.0 |
| 2017-08-03 | CT | Futures | 84.21 | 84.53 | 83.13 | 83.5 | 38.0 |
| 2017-08-03 | DC | Futures | 29.6 | 30.05 | 29.25 | 29.35 | 790.0 |
| 2017-08-03 | DX | Futures | 86.63 | 86.752 | 86.425 | 86.567 | 21576.0 |
| 2017-08-03 | E1 | Futures | 1.26916 | 1.27321 | 1.26707 | 1.27039 | 31435.0 |
| 2017-08-03 | E6 | Futures | 1.36136 | 1.36571 | 1.35855 | 1.36273 | 194441.0 |
| 2017-08-03 | E7 | Futures | 1.3542 | 1.3585 | 1.3514 | 1.3555 | 3587.0 |
| 2017-08-03 | EBM | Futures | 182.89 | 183.16 | 181.77 | 182.05 | 8982.0 |
| 2017-08-03 | ED | Futures | 95.5886 | 95.5983 | 95.5886 | 95.5983 | 118526.0 |
| 2017-08-03 | ER | Futures | 98.342 | 98.342 | 98.337 | 98.337 | 32228.0 |
| 2017-08-03 | EW | Futures | 1860.9 | 1862.6 | 1850.8 | 1854.9 | 11705.0 |
| 2017-08-03 | FBON | Futures | 124.73 | 124.91 | 124.56 | 124.9 | 351.0 |
| 2017-08-03 | FBTP | Futures | 109.16 | 109.6 | 108.98 | 109.56 | 77034.0 |
| 2017-08-03 | FBTS | Futures | 102.982 | 103.0 | 102.963 | 103.0 | 36524.0 |
| 2017-08-03 | FCE | Futures | 4593.0 | 4617.2 | 4563.3 | 4606.4 | 70068.0 |
| 2017-08-03 | FDAX | Futures | 12809.7 | 12822.9 | 12724.5 | 12791.8 | 81714.0 |
| 2017-08-03 | FDXM | Futures | 12729.9 | 12743.5 | 12649.3 | 12713.1 | 27727.0 |
| 2017-08-03 | FESX | Futures | 2820.2 | 2830.8 | 2802.2 | 2826.7 | 764959.0 |
| 2017-08-03 | FGBL | Futures | 147.95 | 148.51 | 147.81 | 148.35 | 567138.0 |
| 2017-08-03 | FGBM | Futures | 129.13 | 129.18 | 129.02 | 129.14 | 351103.0 |
| 2017-08-03 | FGBS | Futures | 112.312 | 112.312 | 112.277 | 112.297 | 206190.0 |
| 2017-08-03 | FGBX | Futures | 166.04 | 167.54 | 165.58 | 167.05 | 37727.0 |
| 2017-08-03 | FMWO | Futures | 6557.9 | 6580.5 | 6557.9 | 6575.8 | 2150.0 |
| 2017-08-03 | FOAT | Futures | 135.71 | 136.04 | 135.55 | 136.0 | 151720.0 |
| 2017-08-03 | FTDX | Futures | 2262.1 | 2275.2 | 2258.6 | 2259.1 | 43.0 |
| 2017-08-03 | FTI | Futures | 482.93 | 484.55 | 480.11 | 483.62 | 22651.0 |
| 2017-08-03 | FTUK | Futures | 6359.7 | 6419.8 | 6330.8 | 6413.7 | 95985.0 |
| 2017-08-03 | FVSA | Futures | 430.15 | 439.05 | 421.25 | 428.67 | 23763.0 |
| 2017-08-03 | FXXP | Futures | 321.7 | 322.4 | 320.3 | 321.8 | 32112.0 |
| 2017-08-03 | G | Futures | 114.25 | 115.3 | 114.23 | 115.17 | 186052.0 |
| 2017-08-03 | GF | Futures | 330.869 | 332.68 | 328.839 | 330.705 | 3386.0 |
| 2017-08-03 | GSCI | Futures | 468.44 | 468.99 | 465.1 | 465.1 | 40.0 |
| 2017-08-03 | HE | Futures | 92.518 | 92.833 | 90.524 | 91.679 | 21675.0 |
| 2017-08-03 | HG | Futures | 3.5093 | 3.5215 | 3.4789 | 3.5008 | 66243.0 |
> showing 50 of 108 rows — these rows as CSV