PREVIEW / futures_daily / 2014-06-09
file: by_date/futures_daily/2014/2014-06-09.parquet size: 9 KB rows: 106
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 |
|---|---|---|---|---|---|---|---|
| 2014-06-09 | ES | Futures | 2016.77 | 2022.46 | 2013.15 | 2017.8 | 1026966.0 |
| 2014-06-09 | NQ | Futures | 4374.2 | 4377.65 | 4354.63 | 4367.0 | 148831.0 |
| 2014-06-09 | YM | Futures | 17009.4 | 17031.5 | 16977.3 | 17005.4 | 78005.0 |
| 2014-06-09 | CL | Futures | 186.95 | 190.21 | 186.66 | 189.92 | 246719.0 |
| 2014-06-09 | GC | Futures | 1650.9 | 1656.6 | 1649.1 | 1652.1 | 53765.0 |
| 2014-06-09 | ZN | Futures | 116.11266 | 116.141838 | 115.835472 | 115.952183 | 826588.0 |
| 2014-06-09 | A6 | Futures | 0.89693 | 0.89914 | 0.89635 | 0.89779 | 48425.0 |
| 2014-06-09 | AD | Futures | 0.92749 | 0.92992 | 0.92657 | 0.92901 | 49531.0 |
| 2014-06-09 | ALI | Futures | 2847.37 | 2850.85 | 2841.37 | 2841.37 | 5.0 |
| 2014-06-09 | B | Futures | 113.14 | 114.4 | 112.82 | 114.24 | 199593.0 |
| 2014-06-09 | B6 | Futures | 1.7666 | 1.7691 | 1.764 | 1.7651 | 69156.0 |
| 2014-06-09 | BFX | Futures | 3845.7 | 3848.1 | 3845.7 | 3848.1 | 1.0 |
| 2014-06-09 | BR | Futures | 0.22994 | 0.23149 | 0.22994 | 0.23118 | 70.0 |
| 2014-06-09 | BZ | Futures | 113.86 | 115.4 | 113.82 | 115.24 | 12440.0 |
| 2014-06-09 | C | Futures | 2024.0 | 2035.0 | 2017.0 | 2029.0 | 4325.0 |
| 2014-06-09 | CB | Futures | 108.995 | 108.995 | 108.995 | 108.995 | 11.0 |
| 2014-06-09 | CC | Futures | 2262.0 | 2272.0 | 2248.0 | 2263.0 | 17838.0 |
| 2014-06-09 | CNH | Futures | 7.1519 | 7.1519 | 7.1377 | 7.1377 | 3.0 |
| 2014-06-09 | CSC | Futures | 4.455 | 4.488 | 4.455 | 4.482 | 14.0 |
| 2014-06-09 | CT | Futures | 95.37 | 95.66 | 94.66 | 95.2 | 13853.0 |
| 2014-06-09 | DC | Futures | 35.2 | 35.43 | 35.2 | 35.36 | 40.0 |
| 2014-06-09 | DX | Futures | 76.425 | 76.672 | 76.316 | 76.65 | 17921.0 |
| 2014-06-09 | E1 | Futures | 1.43699 | 1.43892 | 1.42917 | 1.43006 | 26731.0 |
| 2014-06-09 | E6 | Futures | 1.61108 | 1.61368 | 1.60341 | 1.60412 | 172849.0 |
| 2014-06-09 | E7 | Futures | 1.6003 | 1.6028 | 1.5927 | 1.5934 | 1924.0 |
| 2014-06-09 | ED | Futures | 95.4114 | 95.4114 | 95.4091 | 95.4114 | 27968.0 |
| 2014-06-09 | ER | Futures | 97.881 | 97.886 | 97.876 | 97.881 | 51313.0 |
| 2014-06-09 | EW | Futures | 1456.3 | 1465.0 | 1452.4 | 1460.2 | 13251.0 |
| 2014-06-09 | FBTP | Futures | 91.22 | 91.7 | 91.21 | 91.57 | 53188.0 |
| 2014-06-09 | FBTS | Futures | 98.108 | 98.214 | 98.081 | 98.116 | 15203.0 |
| 2014-06-09 | FCE | Futures | 3662.3 | 3670.2 | 3646.3 | 3662.3 | 51654.0 |
| 2014-06-09 | FDAX | Futures | 11051.9 | 11068.0 | 11026.5 | 11049.7 | 40239.0 |
| 2014-06-09 | FESX | Futures | 2374.2 | 2382.1 | 2361.2 | 2374.2 | 569544.0 |
| 2014-06-09 | FEU3 | Futures | 98.497 | 98.502 | 98.497 | 98.502 | 1.0 |
| 2014-06-09 | FGBL | Futures | 126.54 | 126.75 | 126.37 | 126.43 | 334515.0 |
| 2014-06-09 | FGBM | Futures | 121.18 | 121.25 | 121.01 | 121.03 | 325091.0 |
| 2014-06-09 | FGBS | Futures | 110.713 | 110.728 | 110.693 | 110.703 | 150187.0 |
| 2014-06-09 | FGBX | Futures | 129.94 | 130.48 | 129.88 | 129.96 | 18722.0 |
| 2014-06-09 | FMWO | Futures | 5772.7 | 5781.5 | 5767.7 | 5781.5 | 262.0 |
| 2014-06-09 | FOAT | Futures | 116.27 | 116.84 | 116.21 | 116.46 | 66140.0 |
| 2014-06-09 | FTDX | Futures | 1240.8 | 1243.1 | 1237.5 | 1243.1 | 1163.0 |
| 2014-06-09 | FTI | Futures | 357.66 | 359.09 | 357.27 | 358.66 | 11680.0 |
| 2014-06-09 | FTUK | Futures | 5236.5 | 5240.7 | 5225.1 | 5235.4 | 41869.0 |
| 2014-06-09 | FVSA | Futures | 1386.89 | 1386.89 | 1349.53 | 1349.53 | 4242.0 |
| 2014-06-09 | FXXP | Futures | 261.3 | 262.0 | 260.6 | 261.4 | 2677.0 |
| 2014-06-09 | G | Futures | 93.62 | 93.62 | 93.34 | 93.43 | 86140.0 |
| 2014-06-09 | GF | Futures | 308.167 | 311.921 | 308.167 | 311.921 | 3976.0 |
| 2014-06-09 | GSCI | Futures | 1076.6 | 1082.07 | 1076.6 | 1081.57 | 1933.0 |
| 2014-06-09 | HE | Futures | 131.733 | 133.233 | 131.102 | 132.522 | 20832.0 |
| 2014-06-09 | HG | Futures | 3.9075 | 3.9094 | 3.857 | 3.8889 | 59582.0 |
> showing 50 of 106 rows — these rows as CSV