PREVIEW / futures_daily / 2016-08-03
file: by_date/futures_daily/2016/2016-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 |
|---|---|---|---|---|---|---|---|
| 2016-08-03 | ES | Futures | 2323.76 | 2330.24 | 2316.21 | 2328.89 | 1371176.0 |
| 2016-08-03 | NQ | Futures | 5555.67 | 5574.53 | 5537.7 | 5573.36 | 170596.0 |
| 2016-08-03 | YM | Futures | 19060.4 | 19094.8 | 18997.7 | 19082.3 | 107918.0 |
| 2016-08-03 | CL | Futures | 45.0 | 46.7 | 44.42 | 46.28 | 655186.0 |
| 2016-08-03 | GC | Futures | 1758.4 | 1762.1 | 1745.7 | 1750.9 | 138588.0 |
| 2016-08-03 | ZN | Futures | 127.878932 | 128.105293 | 127.743115 | 128.04493 | 1022489.0 |
| 2016-08-03 | A6 | Futures | 0.77273 | 0.77365 | 0.76897 | 0.77009 | 70775.0 |
| 2016-08-03 | AD | Futures | 0.78119 | 0.7836 | 0.77853 | 0.78267 | 59272.0 |
| 2016-08-03 | ALI | Futures | 2142.29 | 2142.29 | 2142.29 | 2142.29 | 15.0 |
| 2016-08-03 | B | Futures | 33.15 | 34.36 | 32.85 | 34.07 | 320440.0 |
| 2016-08-03 | B6 | Futures | 1.4089 | 1.4108 | 1.4009 | 1.4047 | 65164.0 |
| 2016-08-03 | BR | Futures | 0.2021 | 0.20356 | 0.20043 | 0.20313 | 762.0 |
| 2016-08-03 | BZ | Futures | 32.98 | 34.16 | 32.64 | 33.89 | 30000.0 |
| 2016-08-03 | C | Futures | 2476.0 | 2541.0 | 2456.0 | 2533.0 | 11591.0 |
| 2016-08-03 | CB | Futures | 269.754 | 269.754 | 266.091 | 268.435 | 20.0 |
| 2016-08-03 | CC | Futures | 2115.0 | 2199.0 | 2107.0 | 2194.0 | 36677.0 |
| 2016-08-03 | CNH | Futures | 7.1885 | 7.1954 | 7.1844 | 7.1954 | 27.0 |
| 2016-08-03 | CSC | Futures | 3.83 | 3.834 | 3.819 | 3.834 | 41.0 |
| 2016-08-03 | CT | Futures | 83.45 | 83.64 | 82.92 | 83.64 | 17.0 |
| 2016-08-03 | DC | Futures | 30.65 | 30.85 | 30.49 | 30.7 | 224.0 |
| 2016-08-03 | DX | Futures | 88.425 | 88.862 | 88.425 | 88.844 | 12676.0 |
| 2016-08-03 | E1 | Futures | 1.30171 | 1.30259 | 1.28894 | 1.28957 | 18326.0 |
| 2016-08-03 | E6 | Futures | 1.30895 | 1.30913 | 1.29946 | 1.30005 | 116852.0 |
| 2016-08-03 | E7 | Futures | 1.3019 | 1.3019 | 1.2925 | 1.2931 | 1555.0 |
| 2016-08-03 | EBM | Futures | 202.99 | 203.59 | 201.48 | 202.38 | 8276.0 |
| 2016-08-03 | ED | Futures | 95.675 | 95.6798 | 95.6509 | 95.6605 | 199512.0 |
| 2016-08-03 | ER | Futures | 98.308 | 98.313 | 98.308 | 98.313 | 24179.0 |
| 2016-08-03 | EW | Futures | 1629.1 | 1637.6 | 1621.6 | 1636.9 | 12327.0 |
| 2016-08-03 | FBON | Futures | 123.51 | 123.55 | 123.26 | 123.36 | 31.0 |
| 2016-08-03 | FBTP | Futures | 109.49 | 109.72 | 109.48 | 109.6 | 62159.0 |
| 2016-08-03 | FBTS | Futures | 101.266 | 101.284 | 101.257 | 101.275 | 10319.0 |
| 2016-08-03 | FCE | Futures | 3772.1 | 3796.1 | 3747.2 | 3771.7 | 88002.0 |
| 2016-08-03 | FDAX | Futures | 10778.7 | 10871.8 | 10735.0 | 10816.4 | 82533.0 |
| 2016-08-03 | FDXM | Futures | 10501.1 | 10591.4 | 10463.8 | 10543.1 | 20786.0 |
| 2016-08-03 | FESX | Futures | 2272.7 | 2287.5 | 2261.7 | 2276.6 | 962463.0 |
| 2016-08-03 | FGBL | Futures | 149.85 | 150.2 | 149.75 | 149.94 | 438835.0 |
| 2016-08-03 | FGBM | Futures | 128.64 | 128.74 | 128.62 | 128.68 | 295256.0 |
| 2016-08-03 | FGBS | Futures | 111.817 | 111.837 | 111.808 | 111.827 | 175431.0 |
| 2016-08-03 | FGBX | Futures | 188.12 | 189.08 | 187.65 | 188.16 | 25020.0 |
| 2016-08-03 | FMWO | Futures | 5669.8 | 5682.0 | 5662.5 | 5679.6 | 43.0 |
| 2016-08-03 | FOAT | Futures | 137.86 | 138.09 | 137.76 | 137.95 | 76806.0 |
| 2016-08-03 | FTDX | Futures | 1632.7 | 1634.1 | 1618.2 | 1620.7 | 204.0 |
| 2016-08-03 | FTI | Futures | 391.93 | 395.03 | 390.8 | 393.1 | 24760.0 |
| 2016-08-03 | FTUK | Futures | 5511.4 | 5525.6 | 5476.8 | 5491.8 | 114039.0 |
| 2016-08-03 | FVSA | Futures | 2332.84 | 2401.17 | 2318.2 | 2323.08 | 13964.0 |
| 2016-08-03 | FXXP | Futures | 270.8 | 271.9 | 269.3 | 270.7 | 23966.0 |
| 2016-08-03 | G | Futures | 114.64 | 114.93 | 114.6 | 114.81 | 152484.0 |
| 2016-08-03 | GF | Futures | 290.439 | 295.331 | 289.59 | 294.483 | 2474.0 |
| 2016-08-03 | GSCI | Futures | 479.08 | 485.82 | 476.42 | 483.81 | 1688.0 |
| 2016-08-03 | HE | Futures | 83.463 | 83.947 | 82.218 | 82.322 | 14934.0 |
> showing 50 of 108 rows — these rows as CSV