PREVIEW / futures_daily / 2020-10-14
file: by_date/futures_daily/2020/2020-10-14.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-10-14 | ES | Futures | 3934.43 | 3959.15 | 3900.73 | 3910.84 | 1539718.0 |
| 2020-10-14 | NQ | Futures | 13984.84 | 14098.58 | 13778.76 | 13862.7 | 597198.0 |
| 2020-10-14 | YM | Futures | 30765.4 | 30925.8 | 30513.5 | 30589.9 | 198474.0 |
| 2020-10-14 | CL | Futures | 28.86 | 29.53 | 28.6 | 29.47 | 264494.0 |
| 2020-10-14 | GC | Futures | 2238.5 | 2264.6 | 2226.2 | 2252.5 | 188302.0 |
| 2020-10-14 | ZN | Futures | 138.063245 | 138.187221 | 138.001256 | 138.078742 | 801761.0 |
| 2020-10-14 | A6 | Futures | 0.73492 | 0.73841 | 0.73441 | 0.73574 | 71553.0 |
| 2020-10-14 | AD | Futures | 0.77139 | 0.77266 | 0.76987 | 0.77103 | 54503.0 |
| 2020-10-14 | ALI | Futures | 2232.16 | 2232.16 | 2216.12 | 2217.01 | 129.0 |
| 2020-10-14 | B | Futures | 26.77 | 27.42 | 26.58 | 27.33 | 279124.0 |
| 2020-10-14 | B6 | Futures | 1.3121 | 1.3252 | 1.3047 | 1.321 | 134506.0 |
| 2020-10-14 | BR | Futures | 0.14112 | 0.1414 | 0.14018 | 0.14038 | 70.0 |
| 2020-10-14 | BTC | Futures | 15451.9 | 15626.5 | 15236.9 | 15330.9 | 3466.0 |
| 2020-10-14 | BZ | Futures | 26.25 | 26.87 | 26.07 | 26.8 | 28837.0 |
| 2020-10-14 | C | Futures | 1459.0 | 1465.0 | 1447.0 | 1454.0 | 5930.0 |
| 2020-10-14 | CB | Futures | 159.573 | 161.428 | 159.573 | 161.428 | 21.0 |
| 2020-10-14 | CC | Futures | 1562.0 | 1583.0 | 1550.0 | 1570.0 | 19077.0 |
| 2020-10-14 | CNH | Futures | 6.6288 | 6.6327 | 6.596 | 6.6067 | 527.0 |
| 2020-10-14 | CSC | Futures | 3.505 | 3.547 | 3.494 | 3.533 | 171.0 |
| 2020-10-14 | CT | Futures | 68.01 | 68.58 | 67.75 | 68.12 | 13709.0 |
| 2020-10-14 | DC | Futures | 28.72 | 28.99 | 28.52 | 28.92 | 403.0 |
| 2020-10-14 | DX | Futures | 90.356 | 90.491 | 90.066 | 90.188 | 24149.0 |
| 2020-10-14 | E1 | Futures | 1.23945 | 1.24454 | 1.23797 | 1.24216 | 17193.0 |
| 2020-10-14 | E6 | Futures | 1.25952 | 1.26257 | 1.257 | 1.26038 | 140896.0 |
| 2020-10-14 | E7 | Futures | 1.2532 | 1.2562 | 1.2505 | 1.254 | 5290.0 |
| 2020-10-14 | EBM | Futures | 244.72 | 245.93 | 242.61 | 245.32 | 42617.0 |
| 2020-10-14 | ED | Futures | 96.4939 | 96.4939 | 96.489 | 96.489 | 43142.0 |
| 2020-10-14 | ER | Futures | 98.45 | 98.45 | 98.445 | 98.445 | 35159.0 |
| 2020-10-14 | ESG | Futures | 326.09 | 327.27 | 323.9 | 323.9 | 20.0 |
| 2020-10-14 | EW | Futures | 2126.7 | 2144.3 | 2114.8 | 2116.2 | 10747.0 |
| 2020-10-14 | FBON | Futures | 149.49 | 149.67 | 149.4 | 149.46 | 270.0 |
| 2020-10-14 | FBTP | Futures | 137.54 | 137.81 | 137.43 | 137.62 | 112897.0 |
| 2020-10-14 | FBTS | Futures | 109.711 | 109.74 | 109.691 | 109.72 | 66006.0 |
| 2020-10-14 | FCE | Futures | 4778.8 | 4796.2 | 4747.9 | 4773.0 | 75803.0 |
| 2020-10-14 | FDAX | Futures | 13857.6 | 13916.2 | 13791.5 | 13879.4 | 63477.0 |
| 2020-10-14 | FDIV | Futures | 148.91 | 149.48 | 148.91 | 149.48 | 35.0 |
| 2020-10-14 | FDXM | Futures | 13787.1 | 13847.6 | 13722.4 | 13809.4 | 41960.0 |
| 2020-10-14 | FESX | Futures | 3021.3 | 3032.4 | 3000.0 | 3020.3 | 599063.0 |
| 2020-10-14 | FEU3 | Futures | 99.188 | 99.193 | 99.188 | 99.188 | 110.0 |
| 2020-10-14 | FGBL | Futures | 170.26 | 170.68 | 170.23 | 170.53 | 546064.0 |
| 2020-10-14 | FGBM | Futures | 135.37 | 135.51 | 135.35 | 135.45 | 303557.0 |
| 2020-10-14 | FGBS | Futures | 112.82 | 112.845 | 112.81 | 112.835 | 333654.0 |
| 2020-10-14 | FGBX | Futures | 234.25 | 236.19 | 234.1 | 235.37 | 61560.0 |
| 2020-10-14 | FMWO | Futures | 8684.2 | 8702.0 | 8597.7 | 8666.4 | 2116.0 |
| 2020-10-14 | FOAT | Futures | 158.51 | 158.8 | 158.47 | 158.64 | 140999.0 |
| 2020-10-14 | FTDX | Futures | 3288.0 | 3318.9 | 3265.9 | 3297.8 | 94.0 |
| 2020-10-14 | FTI | Futures | 530.82 | 531.51 | 526.45 | 529.29 | 19924.0 |
| 2020-10-14 | FTUK | Futures | 5692.5 | 5718.8 | 5615.6 | 5650.4 | 78766.0 |
| 2020-10-14 | FVSA | Futures | 171.42 | 173.92 | 168.91 | 169.99 | 10379.0 |
| 2020-10-14 | FXXP | Futures | 342.5 | 343.9 | 340.6 | 342.4 | 31500.0 |
> showing 50 of 119 rows — these rows as CSV