PREVIEW / futures_daily / 2018-12-03
file: by_date/futures_daily/2018/2018-12-03.parquet size: 10 KB rows: 114
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 |
|---|---|---|---|---|---|---|---|
| 2018-12-03 | ES | Futures | 3029.58 | 3051.81 | 3007.89 | 3026.6 | 1909240.0 |
| 2018-12-03 | NQ | Futures | 8178.3 | 8292.13 | 8148.39 | 8198.34 | 575964.0 |
| 2018-12-03 | YM | Futures | 27182.2 | 27471.8 | 27047.4 | 27217.0 | 246839.0 |
| 2018-12-03 | CL | Futures | 55.49 | 56.97 | 55.05 | 56.02 | 758010.0 |
| 2018-12-03 | GC | Futures | 1547.0 | 1562.9 | 1545.5 | 1561.9 | 247720.0 |
| 2018-12-03 | ZN | Futures | 118.903691 | 119.386153 | 118.794748 | 119.214957 | 116128.0 |
| 2018-12-03 | A6 | Futures | 0.75782 | 0.76101 | 0.75618 | 0.75638 | 118449.0 |
| 2018-12-03 | AD | Futures | 0.76283 | 0.7686 | 0.76233 | 0.76556 | 108312.0 |
| 2018-12-03 | B | Futures | 44.04 | 45.96 | 43.94 | 45.3 | 294774.0 |
| 2018-12-03 | B6 | Futures | 1.3111 | 1.3198 | 1.3068 | 1.3095 | 109336.0 |
| 2018-12-03 | BFX | Futures | 4115.2 | 4123.4 | 4115.2 | 4123.4 | 9.0 |
| 2018-12-03 | BTC | Futures | 6240.7 | 6301.8 | 5630.4 | 5798.2 | 3383.0 |
| 2018-12-03 | BZ | Futures | 43.41 | 45.37 | 43.13 | 44.71 | 33207.0 |
| 2018-12-03 | C | Futures | 1463.0 | 1470.0 | 1432.0 | 1456.0 | 5325.0 |
| 2018-12-03 | CB | Futures | 271.529 | 272.44 | 271.529 | 271.894 | 35.0 |
| 2018-12-03 | CC | Futures | 1521.0 | 1527.0 | 1484.0 | 1518.0 | 19710.0 |
| 2018-12-03 | CNH | Futures | 6.9952 | 6.9952 | 6.9105 | 6.9166 | 815.0 |
| 2018-12-03 | CSC | Futures | 2.922 | 2.922 | 2.888 | 2.901 | 35.0 |
| 2018-12-03 | CT | Futures | 87.15 | 89.16 | 86.85 | 87.09 | 30535.0 |
| 2018-12-03 | DC | Futures | 24.32 | 24.37 | 24.15 | 24.29 | 151.0 |
| 2018-12-03 | DX | Futures | 92.2 | 92.229 | 91.806 | 92.119 | 15843.0 |
| 2018-12-03 | E1 | Futures | 1.18774 | 1.19082 | 1.18715 | 1.18798 | 16018.0 |
| 2018-12-03 | E6 | Futures | 1.26154 | 1.26655 | 1.25982 | 1.26243 | 196671.0 |
| 2018-12-03 | E7 | Futures | 1.2547 | 1.2604 | 1.2536 | 1.2563 | 3010.0 |
| 2018-12-03 | EBM | Futures | 210.01 | 211.05 | 209.24 | 210.27 | 17837.0 |
| 2018-12-03 | ED | Futures | 94.9304 | 94.9304 | 94.9133 | 94.9157 | 369759.0 |
| 2018-12-03 | ER | Futures | 98.391 | 98.391 | 98.386 | 98.391 | 21865.0 |
| 2018-12-03 | EW | Futures | 1992.7 | 2012.3 | 1971.9 | 1992.7 | 22049.0 |
| 2018-12-03 | FBON | Futures | 128.54 | 128.75 | 128.45 | 128.71 | 2302.0 |
| 2018-12-03 | FBTP | Futures | 107.53 | 108.16 | 107.35 | 107.97 | 226246.0 |
| 2018-12-03 | FBTS | Futures | 103.632 | 104.026 | 103.604 | 103.97 | 139510.0 |
| 2018-12-03 | FCE | Futures | 4554.6 | 4568.5 | 4498.7 | 4511.2 | 93118.0 |
| 2018-12-03 | FDAX | Futures | 12131.0 | 12162.5 | 12016.4 | 12057.9 | 105842.0 |
| 2018-12-03 | FDXM | Futures | 11903.9 | 11954.5 | 11808.8 | 11849.1 | 49585.0 |
| 2018-12-03 | FESX | Futures | 2712.5 | 2720.9 | 2688.2 | 2697.4 | 1203190.0 |
| 2018-12-03 | FGBL | Futures | 154.09 | 154.75 | 154.09 | 154.56 | 1605468.0 |
| 2018-12-03 | FGBM | Futures | 131.52 | 131.72 | 131.46 | 131.63 | 1405181.0 |
| 2018-12-03 | FGBS | Futures | 112.718 | 112.764 | 112.698 | 112.744 | 1066991.0 |
| 2018-12-03 | FGBX | Futures | 178.97 | 180.72 | 178.8 | 180.24 | 128469.0 |
| 2018-12-03 | FMWO | Futures | 6923.0 | 6938.1 | 6851.2 | 6865.1 | 7164.0 |
| 2018-12-03 | FOAT | Futures | 141.2 | 141.49 | 141.17 | 141.43 | 316438.0 |
| 2018-12-03 | FTDX | Futures | 2603.9 | 2624.1 | 2596.1 | 2601.0 | 265.0 |
| 2018-12-03 | FTI | Futures | 490.81 | 491.93 | 484.92 | 486.03 | 29635.0 |
| 2018-12-03 | FTUK | Futures | 6317.1 | 6388.6 | 6297.0 | 6326.0 | 141722.0 |
| 2018-12-03 | FVSA | Futures | 304.41 | 321.55 | 303.41 | 314.49 | 29106.0 |
| 2018-12-03 | FXXP | Futures | 314.9 | 316.2 | 311.9 | 313.1 | 94347.0 |
| 2018-12-03 | G | Futures | 115.91 | 116.67 | 115.9 | 116.58 | 179379.0 |
| 2018-12-03 | GF | Futures | 314.064 | 314.926 | 310.62 | 311.051 | 5709.0 |
| 2018-12-03 | GSCI | Futures | 469.11 | 469.22 | 465.67 | 468.09 | 111.0 |
| 2018-12-03 | HE | Futures | 82.376 | 82.767 | 78.047 | 80.452 | 30222.0 |
> showing 50 of 114 rows — these rows as CSV