PREVIEW / futures_daily / 2016-11-29
file: by_date/futures_daily/2016/2016-11-29.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-11-29 | ES | Futures | 2379.78 | 2389.79 | 2375.46 | 2383.57 | 1405556.0 |
| 2016-11-29 | NQ | Futures | 5728.92 | 5772.24 | 5713.01 | 5745.42 | 175916.0 |
| 2016-11-29 | YM | Futures | 20042.3 | 20089.5 | 20012.9 | 20071.7 | 119176.0 |
| 2016-11-29 | CL | Futures | 50.59 | 50.69 | 48.36 | 48.8 | 732818.0 |
| 2016-11-29 | GC | Futures | 1536.7 | 1538.1 | 1518.7 | 1529.2 | 216185.0 |
| 2016-11-29 | ZN | Futures | 122.286006 | 122.407608 | 121.951601 | 122.346807 | 1214689.0 |
| 2016-11-29 | A6 | Futures | 0.76377 | 0.76469 | 0.75795 | 0.76377 | 84007.0 |
| 2016-11-29 | AD | Futures | 0.76439 | 0.76449 | 0.75993 | 0.76367 | 73071.0 |
| 2016-11-29 | ALI | Futures | 2356.94 | 2361.11 | 2356.94 | 2361.11 | 5.0 |
| 2016-11-29 | B | Futures | 36.55 | 36.56 | 34.95 | 35.25 | 407079.0 |
| 2016-11-29 | B6 | Futures | 1.3074 | 1.3192 | 1.3047 | 1.317 | 100976.0 |
| 2016-11-29 | BFX | Futures | 4108.6 | 4126.5 | 4108.6 | 4126.5 | 4.0 |
| 2016-11-29 | BR | Futures | 0.20324 | 0.20399 | 0.20185 | 0.20399 | 950.0 |
| 2016-11-29 | BZ | Futures | 36.27 | 36.27 | 34.69 | 34.99 | 48962.0 |
| 2016-11-29 | C | Futures | 2167.0 | 2167.0 | 2106.0 | 2126.0 | 5631.0 |
| 2016-11-29 | CB | Futures | 257.572 | 257.572 | 257.572 | 257.572 | 1.0 |
| 2016-11-29 | CC | Futures | 1831.0 | 1848.0 | 1817.0 | 1838.0 | 14927.0 |
| 2016-11-29 | CNH | Futures | 7.4463 | 7.4463 | 7.4332 | 7.4334 | 43.0 |
| 2016-11-29 | CSC | Futures | 3.868 | 3.875 | 3.854 | 3.875 | 64.0 |
| 2016-11-29 | CT | Futures | 82.82 | 82.82 | 81.41 | 81.91 | 12309.0 |
| 2016-11-29 | DC | Futures | 31.12 | 31.25 | 31.12 | 31.22 | 104.0 |
| 2016-11-29 | DX | Futures | 94.254 | 94.645 | 93.947 | 93.955 | 38830.0 |
| 2016-11-29 | E1 | Futures | 1.23036 | 1.23347 | 1.2255 | 1.23322 | 18901.0 |
| 2016-11-29 | E6 | Futures | 1.23093 | 1.23609 | 1.22571 | 1.23528 | 195819.0 |
| 2016-11-29 | E7 | Futures | 1.2244 | 1.2294 | 1.219 | 1.2286 | 2952.0 |
| 2016-11-29 | EBM | Futures | 194.17 | 194.47 | 188.88 | 189.47 | 19598.0 |
| 2016-11-29 | ED | Futures | 95.5886 | 95.5959 | 95.5838 | 95.5935 | 352537.0 |
| 2016-11-29 | ER | Futures | 98.279 | 98.283 | 98.274 | 98.279 | 58005.0 |
| 2016-11-29 | EW | Futures | 1731.4 | 1741.4 | 1729.2 | 1735.4 | 12161.0 |
| 2016-11-29 | FBON | Futures | 119.85 | 120.54 | 119.85 | 120.2 | 412.0 |
| 2016-11-29 | FBTP | Futures | 103.29 | 104.5 | 103.24 | 104.06 | 171818.0 |
| 2016-11-29 | FBTS | Futures | 100.583 | 100.718 | 100.583 | 100.664 | 46602.0 |
| 2016-11-29 | FCE | Futures | 3976.7 | 4027.9 | 3965.2 | 4016.8 | 98597.0 |
| 2016-11-29 | FDAX | Futures | 11167.7 | 11249.1 | 11133.9 | 11208.4 | 90505.0 |
| 2016-11-29 | FDXM | Futures | 11144.6 | 11224.8 | 11109.8 | 11184.2 | 21859.0 |
| 2016-11-29 | FESX | Futures | 2412.6 | 2439.0 | 2405.4 | 2431.0 | 983367.0 |
| 2016-11-29 | FGBL | Futures | 147.9 | 147.92 | 147.3 | 147.46 | 933161.0 |
| 2016-11-29 | FGBM | Futures | 128.83 | 128.85 | 128.65 | 128.71 | 622369.0 |
| 2016-11-29 | FGBS | Futures | 112.182 | 112.187 | 112.127 | 112.142 | 332529.0 |
| 2016-11-29 | FGBX | Futures | 175.26 | 175.32 | 173.34 | 173.81 | 54455.0 |
| 2016-11-29 | FMWO | Futures | 5738.8 | 5740.0 | 5732.8 | 5738.8 | 250.0 |
| 2016-11-29 | FOAT | Futures | 132.44 | 133.27 | 132.32 | 132.78 | 178961.0 |
| 2016-11-29 | FTDX | Futures | 1680.8 | 1681.8 | 1671.0 | 1676.9 | 27.0 |
| 2016-11-29 | FTI | Futures | 412.6 | 413.19 | 409.54 | 412.37 | 27296.0 |
| 2016-11-29 | FTUK | Futures | 5727.9 | 5739.3 | 5678.6 | 5711.5 | 105828.0 |
| 2016-11-29 | FVSA | Futures | 1366.74 | 1373.02 | 1319.61 | 1329.04 | 23255.0 |
| 2016-11-29 | FXXP | Futures | 280.1 | 281.9 | 278.9 | 281.1 | 24292.0 |
| 2016-11-29 | G | Futures | 110.44 | 110.83 | 110.3 | 110.55 | 228106.0 |
| 2016-11-29 | GF | Futures | 281.583 | 284.985 | 280.133 | 283.256 | 4277.0 |
| 2016-11-29 | GSCI | Futures | 494.91 | 494.91 | 490.35 | 490.35 | 71.0 |
> showing 50 of 110 rows — these rows as CSV