PREVIEW / futures_daily / 2016-01-04
file: by_date/futures_daily/2016/2016-01-04.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-01-04 | ES | Futures | 2176.6 | 2182.74 | 2115.18 | 2145.89 | 2216549.0 |
| 2016-01-04 | NQ | Futures | 5383.82 | 5400.53 | 5193.03 | 5280.66 | 368671.0 |
| 2016-01-04 | YM | Futures | 17950.7 | 18004.5 | 17446.7 | 17679.6 | 220242.0 |
| 2016-01-04 | CL | Futures | 55.92 | 57.1 | 54.03 | 54.67 | 431985.0 |
| 2016-01-04 | GC | Futures | 1369.0 | 1396.7 | 1368.4 | 1386.7 | 159785.0 |
| 2016-01-04 | ZN | Futures | 121.174924 | 121.836754 | 121.069633 | 121.445673 | 1118698.0 |
| 2016-01-04 | A6 | Futures | 0.72835 | 0.72895 | 0.71452 | 0.71723 | 93618.0 |
| 2016-01-04 | AD | Futures | 0.73781 | 0.73873 | 0.73126 | 0.7328 | 73086.0 |
| 2016-01-04 | ALI | Futures | 2087.14 | 2087.14 | 2087.14 | 2087.14 | 0.0 |
| 2016-01-04 | B | Futures | 32.71 | 33.87 | 32.01 | 32.4 | 217739.0 |
| 2016-01-04 | B6 | Futures | 1.5505 | 1.5591 | 1.543 | 1.548 | 95959.0 |
| 2016-01-04 | BFX | Futures | 4426.4 | 4426.4 | 4415.5 | 4425.8 | 6.0 |
| 2016-01-04 | BR | Futures | 0.15277 | 0.15325 | 0.15171 | 0.15233 | 38.0 |
| 2016-01-04 | BZ | Futures | 32.57 | 33.51 | 31.69 | 32.06 | 23650.0 |
| 2016-01-04 | C | Futures | 2375.0 | 2377.0 | 2323.0 | 2325.0 | 10975.0 |
| 2016-01-04 | CB | Futures | 264.647 | 264.647 | 258.524 | 258.524 | 12.0 |
| 2016-01-04 | CC | Futures | 2370.0 | 2373.0 | 2300.0 | 2303.0 | 25293.0 |
| 2016-01-04 | CNH | Futures | 7.3159 | 7.3587 | 7.3159 | 7.349 | 39.0 |
| 2016-01-04 | CSC | Futures | 3.851 | 3.895 | 3.807 | 3.812 | 80.0 |
| 2016-01-04 | CT | Futures | 74.12 | 74.44 | 73.22 | 73.34 | 21945.0 |
| 2016-01-04 | DC | Futures | 30.73 | 30.9 | 30.13 | 30.17 | 312.0 |
| 2016-01-04 | DX | Futures | 92.256 | 92.761 | 91.649 | 92.451 | 39008.0 |
| 2016-01-04 | E1 | Futures | 1.26652 | 1.27599 | 1.25819 | 1.26349 | 22262.0 |
| 2016-01-04 | E6 | Futures | 1.27268 | 1.28227 | 1.26274 | 1.26824 | 257251.0 |
| 2016-01-04 | E7 | Futures | 1.2655 | 1.2751 | 1.2558 | 1.2611 | 6974.0 |
| 2016-01-04 | EBM | Futures | 244.72 | 244.72 | 240.83 | 241.54 | 19747.0 |
| 2016-01-04 | ED | Futures | 95.5447 | 95.5784 | 95.5399 | 95.5591 | 172771.0 |
| 2016-01-04 | ER | Futures | 98.215 | 98.229 | 98.21 | 98.22 | 42743.0 |
| 2016-01-04 | EW | Futures | 1474.8 | 1477.0 | 1435.6 | 1453.2 | 34775.0 |
| 2016-01-04 | FBON | Futures | 115.71 | 116.02 | 115.71 | 115.73 | 529.0 |
| 2016-01-04 | FBTP | Futures | 104.92 | 105.39 | 104.86 | 105.15 | 59541.0 |
| 2016-01-04 | FBTS | Futures | 100.837 | 100.837 | 100.784 | 100.828 | 21803.0 |
| 2016-01-04 | FCE | Futures | 3824.2 | 3836.3 | 3753.5 | 3781.5 | 140013.0 |
| 2016-01-04 | FDAX | Futures | 11407.0 | 11411.4 | 11114.8 | 11130.0 | 126124.0 |
| 2016-01-04 | FDXM | Futures | 10907.3 | 10909.4 | 10627.4 | 10644.0 | 21986.0 |
| 2016-01-04 | FESX | Futures | 2440.7 | 2443.8 | 2386.0 | 2395.9 | 1449009.0 |
| 2016-01-04 | FGBL | Futures | 139.6 | 140.1 | 139.55 | 139.96 | 452904.0 |
| 2016-01-04 | FGBM | Futures | 125.52 | 125.71 | 125.52 | 125.61 | 348171.0 |
| 2016-01-04 | FGBS | Futures | 111.428 | 111.458 | 111.423 | 111.443 | 225439.0 |
| 2016-01-04 | FGBX | Futures | 156.14 | 157.91 | 156.14 | 156.88 | 24606.0 |
| 2016-01-04 | FMWO | Futures | 5515.8 | 5517.0 | 5444.8 | 5454.8 | 506.0 |
| 2016-01-04 | FOAT | Futures | 127.79 | 128.24 | 127.74 | 127.97 | 61659.0 |
| 2016-01-04 | FTDX | Futures | 1727.6 | 1727.6 | 1704.1 | 1718.0 | 505.0 |
| 2016-01-04 | FTI | Futures | 382.65 | 382.7 | 373.09 | 377.11 | 47016.0 |
| 2016-01-04 | FTUK | Futures | 5036.3 | 5051.0 | 4907.0 | 4911.9 | 157746.0 |
| 2016-01-04 | FVSA | Futures | 2380.94 | 2437.4 | 2333.89 | 2390.35 | 15955.0 |
| 2016-01-04 | FXXP | Futures | 282.1 | 283.2 | 278.2 | 279.0 | 49628.0 |
| 2016-01-04 | G | Futures | 104.18 | 104.66 | 104.18 | 104.54 | 140792.0 |
| 2016-01-04 | GF | Futures | 320.908 | 326.409 | 316.613 | 323.562 | 1977.0 |
| 2016-01-04 | GSCI | Futures | 496.72 | 497.03 | 481.99 | 485.43 | 1115.0 |
> showing 50 of 108 rows — these rows as CSV