PREVIEW / futures_daily / 2013-09-17
file: by_date/futures_daily/2013/2013-09-17.parquet size: 9 KB rows: 103
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-17 | ES | Futures | 1734.98 | 1746.03 | 1733.7 | 1744.49 | 1448771.0 |
| 2013-09-17 | NQ | Futures | 3627.62 | 3662.65 | 3625.04 | 3656.91 | 225570.0 |
| 2013-09-17 | YM | Futures | 15338.9 | 15412.5 | 15328.9 | 15387.6 | 98897.0 |
| 2013-09-17 | CL | Futures | 187.36 | 187.59 | 184.83 | 185.57 | 213571.0 |
| 2013-09-17 | GC | Futures | 1737.3 | 1752.0 | 1727.0 | 1731.7 | 128901.0 |
| 2013-09-17 | ZN | Futures | 112.416885 | 112.714285 | 112.3744 | 112.516018 | 852762.0 |
| 2013-09-17 | A6 | Futures | 0.8748 | 0.87942 | 0.87187 | 0.87838 | 64679.0 |
| 2013-09-17 | AD | Futures | 0.97642 | 0.98127 | 0.97561 | 0.97955 | 51327.0 |
| 2013-09-17 | B | Futures | 108.39 | 108.88 | 106.32 | 107.09 | 214348.0 |
| 2013-09-17 | B6 | Futures | 1.6675 | 1.6719 | 1.6665 | 1.669 | 78622.0 |
| 2013-09-17 | BFX | Futures | 3384.0 | 3384.0 | 3374.3 | 3374.3 | 321.0 |
| 2013-09-17 | BR | Futures | 0.22049 | 0.22199 | 0.22049 | 0.22181 | 118.0 |
| 2013-09-17 | BZ | Futures | 109.18 | 109.69 | 107.15 | 107.91 | 6998.0 |
| 2013-09-17 | C | Futures | 1844.0 | 1845.0 | 1815.0 | 1822.0 | 5473.0 |
| 2013-09-17 | CB | Futures | 72.176 | 72.176 | 72.176 | 72.176 | 3.0 |
| 2013-09-17 | CC | Futures | 1968.0 | 1973.0 | 1938.0 | 1948.0 | 9427.0 |
| 2013-09-17 | CT | Futures | 101.37 | 101.37 | 100.95 | 100.95 | 16.0 |
| 2013-09-17 | DC | Futures | 24.58 | 24.6 | 24.49 | 24.58 | 98.0 |
| 2013-09-17 | DX | Futures | 77.577 | 77.658 | 77.41 | 77.458 | 13009.0 |
| 2013-09-17 | E1 | Futures | 1.38648 | 1.39033 | 1.38583 | 1.38892 | 17889.0 |
| 2013-09-17 | E6 | Futures | 1.57392 | 1.57864 | 1.57297 | 1.57687 | 103799.0 |
| 2013-09-17 | E7 | Futures | 1.5638 | 1.5682 | 1.5629 | 1.5667 | 1744.0 |
| 2013-09-17 | ED | Futures | 95.3255 | 95.3303 | 95.3208 | 95.3255 | 157161.0 |
| 2013-09-17 | ER | Futures | 97.847 | 97.852 | 97.837 | 97.837 | 71337.0 |
| 2013-09-17 | EW | Futures | 1255.0 | 1268.6 | 1253.3 | 1267.8 | 27903.0 |
| 2013-09-17 | FBTP | Futures | 77.47 | 77.98 | 77.39 | 77.86 | 31055.0 |
| 2013-09-17 | FBTS | Futures | 93.229 | 93.419 | 93.221 | 93.376 | 5493.0 |
| 2013-09-17 | FCE | Futures | 3196.1 | 3204.6 | 3185.7 | 3195.7 | 155120.0 |
| 2013-09-17 | FDAX | Futures | 9558.7 | 9579.8 | 9535.4 | 9552.1 | 31553.0 |
| 2013-09-17 | FDIV | Futures | 132.82 | 132.82 | 132.82 | 132.82 | 1400.0 |
| 2013-09-17 | FESX | Futures | 2015.1 | 2023.5 | 2008.1 | 2019.3 | 1120304.0 |
| 2013-09-17 | FEU3 | Futures | 98.463 | 98.463 | 98.458 | 98.458 | 5.0 |
| 2013-09-17 | FGBL | Futures | 117.76 | 117.91 | 117.51 | 117.57 | 514587.0 |
| 2013-09-17 | FGBM | Futures | 116.74 | 116.81 | 116.61 | 116.64 | 283994.0 |
| 2013-09-17 | FGBS | Futures | 110.318 | 110.328 | 110.278 | 110.293 | 191443.0 |
| 2013-09-17 | FGBX | Futures | 119.05 | 119.25 | 118.68 | 118.82 | 9804.0 |
| 2013-09-17 | FMWO | Futures | 5076.3 | 5094.0 | 5076.3 | 5091.5 | 156.0 |
| 2013-09-17 | FOAT | Futures | 105.22 | 105.42 | 105.14 | 105.27 | 37507.0 |
| 2013-09-17 | FTDX | Futures | 1012.0 | 1012.0 | 1007.8 | 1010.1 | 58.0 |
| 2013-09-17 | FTI | Futures | 328.07 | 329.59 | 328.03 | 328.9 | 37435.0 |
| 2013-09-17 | FTUK | Futures | 4941.0 | 4944.0 | 4904.7 | 4914.8 | 196316.0 |
| 2013-09-17 | FVSA | Futures | 2608.3 | 2627.87 | 2582.22 | 2595.26 | 3510.0 |
| 2013-09-17 | FXXP | Futures | 227.3 | 227.6 | 226.7 | 227.1 | 23928.0 |
| 2013-09-17 | G | Futures | 91.09 | 91.11 | 90.52 | 90.62 | 135108.0 |
| 2013-09-17 | GF | Futures | 260.021 | 260.021 | 257.168 | 257.371 | 2560.0 |
| 2013-09-17 | GSCI | Futures | 1075.45 | 1076.2 | 1062.3 | 1066.15 | 298.0 |
| 2013-09-17 | HE | Futures | 111.446 | 111.952 | 110.022 | 110.782 | 19892.0 |
| 2013-09-17 | HG | Futures | 4.0715 | 4.1025 | 4.0499 | 4.081 | 34690.0 |
| 2013-09-17 | HH | Futures | 40.628 | 40.628 | 40.164 | 40.434 | 4648.0 |
| 2013-09-17 | HO | Futures | 2.4376 | 2.4457 | 2.3857 | 2.3997 | 30284.0 |
> showing 50 of 103 rows — these rows as CSV