PREVIEW / futures_daily / 2016-11-03
file: by_date/futures_daily/2016/2016-11-03.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-03 | ES | Futures | 2258.64 | 2270.0 | 2249.45 | 2253.51 | 1795490.0 |
| 2016-11-03 | NQ | Futures | 5539.18 | 5573.94 | 5501.76 | 5509.12 | 280599.0 |
| 2016-11-03 | YM | Futures | 18755.9 | 18832.6 | 18712.9 | 18745.4 | 155396.0 |
| 2016-11-03 | CL | Futures | 49.63 | 50.09 | 48.42 | 48.73 | 540439.0 |
| 2016-11-03 | GC | Futures | 1665.5 | 1678.2 | 1650.2 | 1672.1 | 228551.0 |
| 2016-11-03 | ZN | Futures | 126.466075 | 126.77008 | 126.268472 | 126.496475 | 1078686.0 |
| 2016-11-03 | A6 | Futures | 0.78071 | 0.78367 | 0.77836 | 0.78346 | 74844.0 |
| 2016-11-03 | AD | Futures | 0.76546 | 0.76674 | 0.76439 | 0.76551 | 51599.0 |
| 2016-11-03 | ALI | Futures | 2312.77 | 2321.41 | 2312.77 | 2321.41 | 5.0 |
| 2016-11-03 | B | Futures | 35.82 | 36.1 | 34.93 | 35.21 | 283660.0 |
| 2016-11-03 | B6 | Futures | 1.2958 | 1.3165 | 1.2956 | 1.3125 | 233680.0 |
| 2016-11-03 | BFX | Futures | 4102.0 | 4102.0 | 4100.3 | 4100.3 | 6.0 |
| 2016-11-03 | BR | Futures | 0.20945 | 0.21092 | 0.20945 | 0.21003 | 3625.0 |
| 2016-11-03 | BZ | Futures | 35.5 | 35.92 | 34.77 | 35.04 | 33590.0 |
| 2016-11-03 | C | Futures | 2375.0 | 2381.0 | 2331.0 | 2338.0 | 9141.0 |
| 2016-11-03 | CB | Futures | 238.037 | 239.308 | 236.208 | 236.828 | 59.0 |
| 2016-11-03 | CC | Futures | 2012.0 | 2048.0 | 1986.0 | 2001.0 | 22338.0 |
| 2016-11-03 | CSC | Futures | 3.935 | 3.953 | 3.898 | 3.946 | 39.0 |
| 2016-11-03 | CT | Futures | 76.81 | 77.51 | 75.98 | 76.26 | 21999.0 |
| 2016-11-03 | DC | Futures | 30.79 | 31.27 | 30.6 | 31.12 | 546.0 |
| 2016-11-03 | DX | Futures | 90.689 | 90.727 | 90.345 | 90.462 | 24232.0 |
| 2016-11-03 | E1 | Futures | 1.28368 | 1.28792 | 1.27932 | 1.28169 | 22880.0 |
| 2016-11-03 | E6 | Futures | 1.28878 | 1.29196 | 1.2842 | 1.28953 | 172545.0 |
| 2016-11-03 | E7 | Futures | 1.2817 | 1.2849 | 1.2773 | 1.2825 | 2072.0 |
| 2016-11-03 | EBM | Futures | 191.23 | 191.82 | 190.35 | 190.94 | 14125.0 |
| 2016-11-03 | ED | Futures | 95.649 | 95.6683 | 95.6442 | 95.6442 | 192644.0 |
| 2016-11-03 | ER | Futures | 98.269 | 98.269 | 98.264 | 98.264 | 24493.0 |
| 2016-11-03 | EW | Futures | 1568.0 | 1578.9 | 1563.8 | 1567.1 | 15513.0 |
| 2016-11-03 | FBON | Futures | 123.22 | 123.49 | 122.97 | 123.27 | 417.0 |
| 2016-11-03 | FBTP | Futures | 106.59 | 106.67 | 106.29 | 106.37 | 117439.0 |
| 2016-11-03 | FBTS | Futures | 100.996 | 101.032 | 100.987 | 101.005 | 33083.0 |
| 2016-11-03 | FCE | Futures | 3929.3 | 3967.1 | 3913.7 | 3926.6 | 101051.0 |
| 2016-11-03 | FDAX | Futures | 10968.5 | 10994.4 | 10874.4 | 10912.5 | 97226.0 |
| 2016-11-03 | FDXM | Futures | 10939.0 | 10972.7 | 10851.5 | 10888.9 | 22990.0 |
| 2016-11-03 | FESX | Futures | 2382.9 | 2398.9 | 2367.7 | 2377.3 | 1062669.0 |
| 2016-11-03 | FEU3 | Futures | 98.942 | 98.947 | 98.942 | 98.947 | 5.0 |
| 2016-11-03 | FGBL | Futures | 148.43 | 148.55 | 147.85 | 148.0 | 792855.0 |
| 2016-11-03 | FGBM | Futures | 128.42 | 128.44 | 128.28 | 128.33 | 505761.0 |
| 2016-11-03 | FGBS | Futures | 111.852 | 111.852 | 111.823 | 111.837 | 178820.0 |
| 2016-11-03 | FGBX | Futures | 177.9 | 178.46 | 176.36 | 177.03 | 52968.0 |
| 2016-11-03 | FMWO | Futures | 5576.7 | 5590.0 | 5569.5 | 5573.1 | 97.0 |
| 2016-11-03 | FOAT | Futures | 135.69 | 135.83 | 135.29 | 135.42 | 184207.0 |
| 2016-11-03 | FTDX | Futures | 1654.8 | 1674.0 | 1654.8 | 1669.5 | 169.0 |
| 2016-11-03 | FTI | Futures | 407.6 | 410.4 | 403.69 | 405.48 | 33069.0 |
| 2016-11-03 | FTUK | Futures | 5763.8 | 5780.3 | 5675.2 | 5713.6 | 118779.0 |
| 2016-11-03 | FVSA | Futures | 1480.99 | 1511.91 | 1440.79 | 1468.62 | 13381.0 |
| 2016-11-03 | FXXP | Futures | 272.9 | 275.2 | 271.6 | 273.0 | 22842.0 |
| 2016-11-03 | G | Futures | 112.27 | 112.74 | 111.54 | 112.03 | 251065.0 |
| 2016-11-03 | GF | Futures | 271.661 | 272.52 | 267.527 | 270.265 | 2589.0 |
| 2016-11-03 | GSCI | Futures | 492.8 | 493.84 | 487.26 | 487.95 | 501.0 |
> showing 50 of 110 rows — these rows as CSV