PREVIEW / futures_daily / 2016-01-12
file: by_date/futures_daily/2016/2016-01-12.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-01-12 | ES | Futures | 2043.88 | 2072.45 | 2028.39 | 2056.16 | 2428110.0 |
| 2016-01-12 | NQ | Futures | 5008.39 | 5094.56 | 4966.48 | 5055.87 | 417581.0 |
| 2016-01-12 | YM | Futures | 16846.6 | 17076.3 | 16730.7 | 16932.4 | 260381.0 |
| 2016-01-12 | CL | Futures | 46.27 | 47.91 | 44.52 | 45.27 | 627218.0 |
| 2016-01-12 | GC | Futures | 1410.9 | 1417.5 | 1396.9 | 1399.6 | 167654.0 |
| 2016-01-12 | ZN | Futures | 122.453458 | 123.220578 | 122.242876 | 123.055121 | 1465533.0 |
| 2016-01-12 | A6 | Futures | 0.69849 | 0.70139 | 0.69328 | 0.69779 | 104727.0 |
| 2016-01-12 | AD | Futures | 0.7193 | 0.72124 | 0.71429 | 0.71664 | 77693.0 |
| 2016-01-12 | ALI | Futures | 2057.31 | 2057.31 | 2057.31 | 2057.31 | 0.0 |
| 2016-01-12 | B | Futures | 27.52 | 28.17 | 26.28 | 26.67 | 389164.0 |
| 2016-01-12 | B6 | Futures | 1.5305 | 1.532 | 1.5102 | 1.5185 | 107795.0 |
| 2016-01-12 | BFX | Futures | 4245.4 | 4249.6 | 4227.3 | 4227.3 | 4.0 |
| 2016-01-12 | BR | Futures | 0.15318 | 0.15318 | 0.15318 | 0.15318 | 4.0 |
| 2016-01-12 | BZ | Futures | 26.92 | 27.87 | 26.02 | 26.39 | 40923.0 |
| 2016-01-12 | C | Futures | 2168.0 | 2188.0 | 2151.0 | 2171.0 | 15026.0 |
| 2016-01-12 | CB | Futures | 256.112 | 256.267 | 256.112 | 256.267 | 1.0 |
| 2016-01-12 | CC | Futures | 2120.0 | 2132.0 | 2103.0 | 2109.0 | 20646.0 |
| 2016-01-12 | CNH | Futures | 7.3884 | 7.3928 | 7.3392 | 7.3392 | 57.0 |
| 2016-01-12 | CSC | Futures | 3.716 | 3.733 | 3.716 | 3.733 | 35.0 |
| 2016-01-12 | CT | Futures | 72.04 | 72.95 | 71.98 | 72.14 | 18617.0 |
| 2016-01-12 | DC | Futures | 29.23 | 29.46 | 29.23 | 29.44 | 105.0 |
| 2016-01-12 | DX | Futures | 92.429 | 92.798 | 92.14 | 92.503 | 27241.0 |
| 2016-01-12 | E1 | Futures | 1.26425 | 1.26981 | 1.25971 | 1.26248 | 12524.0 |
| 2016-01-12 | E6 | Futures | 1.27204 | 1.2766 | 1.26713 | 1.27122 | 162441.0 |
| 2016-01-12 | E7 | Futures | 1.2655 | 1.2694 | 1.2601 | 1.2641 | 4437.0 |
| 2016-01-12 | EBM | Futures | 239.07 | 241.54 | 238.36 | 241.19 | 20109.0 |
| 2016-01-12 | ED | Futures | 95.588 | 95.5976 | 95.5736 | 95.5832 | 366454.0 |
| 2016-01-12 | ER | Futures | 98.239 | 98.239 | 98.229 | 98.239 | 34427.0 |
| 2016-01-12 | EW | Futures | 1371.5 | 1386.9 | 1357.5 | 1372.3 | 25388.0 |
| 2016-01-12 | FBON | Futures | 114.82 | 114.82 | 114.6 | 114.74 | 606.0 |
| 2016-01-12 | FBTP | Futures | 104.9 | 104.91 | 104.47 | 104.71 | 103517.0 |
| 2016-01-12 | FBTS | Futures | 100.846 | 100.873 | 100.828 | 100.864 | 18600.0 |
| 2016-01-12 | FCE | Futures | 3606.3 | 3713.8 | 3600.4 | 3671.8 | 92414.0 |
| 2016-01-12 | FDAX | Futures | 10639.3 | 10946.2 | 10600.8 | 10837.7 | 117685.0 |
| 2016-01-12 | FDIV | Futures | 127.71 | 130.3 | 127.62 | 129.19 | 39.0 |
| 2016-01-12 | FDXM | Futures | 10178.4 | 10465.6 | 10122.4 | 10361.9 | 25073.0 |
| 2016-01-12 | FESX | Futures | 2290.9 | 2352.5 | 2285.6 | 2327.4 | 1330651.0 |
| 2016-01-12 | FGBL | Futures | 140.46 | 140.73 | 139.88 | 140.49 | 721682.0 |
| 2016-01-12 | FGBM | Futures | 125.94 | 125.97 | 125.73 | 125.91 | 473906.0 |
| 2016-01-12 | FGBS | Futures | 111.518 | 111.523 | 111.483 | 111.513 | 172760.0 |
| 2016-01-12 | FGBX | Futures | 157.8 | 159.57 | 156.72 | 158.77 | 35637.0 |
| 2016-01-12 | FMWO | Futures | 5301.6 | 5301.6 | 5243.1 | 5254.3 | 439.0 |
| 2016-01-12 | FOAT | Futures | 128.3 | 128.35 | 127.75 | 128.27 | 78410.0 |
| 2016-01-12 | FTDX | Futures | 1628.8 | 1657.6 | 1625.9 | 1645.1 | 675.0 |
| 2016-01-12 | FTI | Futures | 361.41 | 370.97 | 361.19 | 366.94 | 22107.0 |
| 2016-01-12 | FTUK | Futures | 4782.6 | 4840.1 | 4736.1 | 4792.4 | 122118.0 |
| 2016-01-12 | FVSA | Futures | 2743.26 | 2788.15 | 2648.49 | 2723.31 | 9118.0 |
| 2016-01-12 | FXXP | Futures | 266.0 | 271.9 | 265.4 | 269.3 | 29971.0 |
| 2016-01-12 | G | Futures | 105.3 | 105.8 | 105.16 | 105.63 | 201898.0 |
| 2016-01-12 | GF | Futures | 309.305 | 312.397 | 305.427 | 308.274 | 5044.0 |
> showing 50 of 110 rows — these rows as CSV