PREVIEW / futures_daily / 2014-01-13
file: by_date/futures_daily/2014/2014-01-13.parquet size: 9 KB rows: 104
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-01-13 | ES | Futures | 1895.23 | 1895.49 | 1865.33 | 1871.0 | 1710408.0 |
| 2014-01-13 | NQ | Futures | 4096.34 | 4100.07 | 4015.0 | 4034.55 | 333010.0 |
| 2014-01-13 | YM | Futures | 16361.1 | 16367.1 | 16153.5 | 16188.4 | 139484.0 |
| 2014-01-13 | CL | Futures | 163.88 | 163.97 | 161.41 | 162.06 | 212208.0 |
| 2014-01-13 | GC | Futures | 1652.0 | 1662.1 | 1645.8 | 1656.5 | 116647.0 |
| 2014-01-13 | ZN | Futures | 113.790294 | 114.133683 | 113.761679 | 114.076451 | 762470.0 |
| 2014-01-13 | A6 | Futures | 0.85301 | 0.86235 | 0.85273 | 0.85968 | 96372.0 |
| 2014-01-13 | AD | Futures | 0.92716 | 0.93243 | 0.92514 | 0.93111 | 60864.0 |
| 2014-01-13 | B | Futures | 108.56 | 108.92 | 107.51 | 107.91 | 213137.0 |
| 2014-01-13 | B6 | Futures | 1.731 | 1.7334 | 1.7163 | 1.7208 | 95800.0 |
| 2014-01-13 | BR | Futures | 0.21702 | 0.2186 | 0.21668 | 0.21673 | 374.0 |
| 2014-01-13 | BZ | Futures | 110.92 | 111.07 | 109.73 | 110.06 | 7315.0 |
| 2014-01-13 | C | Futures | 1831.0 | 1843.0 | 1820.0 | 1841.0 | 6543.0 |
| 2014-01-13 | CB | Futures | 84.396 | 85.353 | 84.396 | 84.887 | 25.0 |
| 2014-01-13 | CC | Futures | 2005.0 | 2018.0 | 1991.0 | 2013.0 | 11705.0 |
| 2014-01-13 | CSC | Futures | 3.899 | 3.915 | 3.899 | 3.911 | 11.0 |
| 2014-01-13 | CT | Futures | 94.33 | 96.31 | 94.2 | 95.41 | 17938.0 |
| 2014-01-13 | DC | Futures | 30.09 | 30.35 | 30.07 | 30.32 | 105.0 |
| 2014-01-13 | DX | Futures | 76.785 | 76.89 | 76.609 | 76.658 | 18576.0 |
| 2014-01-13 | E1 | Futures | 1.42364 | 1.42916 | 1.4194 | 1.42813 | 26711.0 |
| 2014-01-13 | E6 | Futures | 1.61321 | 1.61545 | 1.60979 | 1.61404 | 138853.0 |
| 2014-01-13 | E7 | Futures | 1.6028 | 1.6049 | 1.5993 | 1.6035 | 3594.0 |
| 2014-01-13 | EBM | Futures | 269.39 | 271.82 | 269.39 | 271.48 | 22202.0 |
| 2014-01-13 | ED | Futures | 95.3662 | 95.371 | 95.3662 | 95.3662 | 58256.0 |
| 2014-01-13 | ER | Futures | 97.852 | 97.852 | 97.842 | 97.847 | 32835.0 |
| 2014-01-13 | EW | Futures | 1375.1 | 1376.5 | 1352.1 | 1357.3 | 19259.0 |
| 2014-01-13 | FBTP | Futures | 83.1 | 83.39 | 83.06 | 83.28 | 41084.0 |
| 2014-01-13 | FBTS | Futures | 96.021 | 96.1 | 96.021 | 96.082 | 8801.0 |
| 2014-01-13 | FCE | Futures | 3313.7 | 3320.3 | 3289.6 | 3316.0 | 51446.0 |
| 2014-01-13 | FDAX | Futures | 10531.7 | 10564.4 | 10460.7 | 10545.6 | 79392.0 |
| 2014-01-13 | FESX | Futures | 2185.8 | 2190.7 | 2165.4 | 2184.4 | 602195.0 |
| 2014-01-13 | FEU3 | Futures | 98.458 | 98.463 | 98.458 | 98.463 | 6.0 |
| 2014-01-13 | FGBL | Futures | 119.42 | 119.91 | 119.3 | 119.69 | 507434.0 |
| 2014-01-13 | FGBM | Futures | 117.73 | 117.95 | 117.65 | 117.85 | 300863.0 |
| 2014-01-13 | FGBS | Futures | 110.413 | 110.428 | 110.393 | 110.418 | 194541.0 |
| 2014-01-13 | FGBX | Futures | 119.42 | 120.24 | 119.09 | 119.83 | 16720.0 |
| 2014-01-13 | FMWO | Futures | 5427.1 | 5427.1 | 5427.1 | 5427.1 | 0.0 |
| 2014-01-13 | FOAT | Futures | 108.17 | 108.42 | 108.02 | 108.34 | 32907.0 |
| 2014-01-13 | FTDX | Futures | 1147.9 | 1153.1 | 1140.4 | 1153.1 | 180.0 |
| 2014-01-13 | FTI | Futures | 345.69 | 346.46 | 343.76 | 346.03 | 5013.0 |
| 2014-01-13 | FTUK | Futures | 5071.4 | 5080.5 | 5032.8 | 5071.0 | 67469.0 |
| 2014-01-13 | FVSA | Futures | 1810.82 | 1831.22 | 1800.62 | 1831.22 | 3776.0 |
| 2014-01-13 | FXXP | Futures | 242.5 | 242.5 | 241.5 | 242.1 | 3139.0 |
| 2014-01-13 | G | Futures | 91.52 | 92.07 | 91.52 | 91.94 | 107392.0 |
| 2014-01-13 | GF | Futures | 271.022 | 271.385 | 267.637 | 268.402 | 4083.0 |
| 2014-01-13 | GSCI | Futures | 999.08 | 1001.21 | 997.52 | 999.0 | 1394.0 |
| 2014-01-13 | HE | Futures | 103.954 | 103.954 | 102.867 | 103.109 | 21374.0 |
| 2014-01-13 | HG | Futures | 4.2248 | 4.2608 | 4.1863 | 4.2267 | 43803.0 |
| 2014-01-13 | HH | Futures | 42.205 | 43.127 | 42.135 | 42.816 | 1350.0 |
| 2014-01-13 | HO | Futures | 2.3383 | 2.3466 | 2.3222 | 2.3286 | 36458.0 |
> showing 50 of 104 rows — these rows as CSV