PREVIEW / futures_daily / 2019-02-19
file: by_date/futures_daily/2019/2019-02-19.parquet size: 10 KB rows: 115
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-19 | ES | Futures | 3006.57 | 3017.94 | 2994.66 | 3008.47 | 1198092.0 |
| 2019-02-19 | NQ | Futures | 8178.08 | 8213.97 | 8145.09 | 8183.29 | 386613.0 |
| 2019-02-19 | YM | Futures | 27303.8 | 27378.7 | 27201.5 | 27300.6 | 206825.0 |
| 2019-02-19 | CL | Futures | 58.04 | 58.64 | 57.54 | 58.35 | 838298.0 |
| 2019-02-19 | GC | Futures | 1656.2 | 1681.2 | 1654.7 | 1681.0 | 348636.0 |
| 2019-02-19 | ZN | Futures | 121.54929 | 121.813832 | 121.440361 | 121.720465 | 1313246.0 |
| 2019-02-19 | A6 | Futures | 0.73579 | 0.7394 | 0.73219 | 0.73889 | 133735.0 |
| 2019-02-19 | AD | Futures | 0.7645 | 0.76714 | 0.76273 | 0.76673 | 68404.0 |
| 2019-02-19 | B | Futures | 48.17 | 48.32 | 47.55 | 48.18 | 246650.0 |
| 2019-02-19 | B6 | Futures | 1.3267 | 1.3441 | 1.3255 | 1.3434 | 190147.0 |
| 2019-02-19 | BR | Futures | 0.21484 | 0.21556 | 0.21297 | 0.21512 | 2346.0 |
| 2019-02-19 | BTC | Futures | 5308.1 | 5853.6 | 5300.7 | 5802.0 | 15944.0 |
| 2019-02-19 | BZ | Futures | 47.57 | 47.94 | 47.05 | 47.67 | 46238.0 |
| 2019-02-19 | C | Futures | 1547.0 | 1559.0 | 1536.0 | 1557.0 | 6200.0 |
| 2019-02-19 | CB | Futures | 274.536 | 274.775 | 274.536 | 274.536 | 10.0 |
| 2019-02-19 | CC | Futures | 1589.0 | 1599.0 | 1560.0 | 1586.0 | 28047.0 |
| 2019-02-19 | CNH | Futures | 6.7767 | 6.7932 | 6.7517 | 6.7551 | 1365.0 |
| 2019-02-19 | CSC | Futures | 2.773 | 2.79 | 2.736 | 2.782 | 207.0 |
| 2019-02-19 | CT | Futures | 76.49 | 77.44 | 76.47 | 76.7 | 12345.0 |
| 2019-02-19 | DC | Futures | 23.33 | 23.64 | 23.09 | 23.57 | 280.0 |
| 2019-02-19 | DX | Futures | 92.189 | 92.442 | 91.794 | 91.888 | 21432.0 |
| 2019-02-19 | E1 | Futures | 1.17325 | 1.17854 | 1.1716 | 1.1776 | 23929.0 |
| 2019-02-19 | E6 | Futures | 1.25061 | 1.25779 | 1.24862 | 1.2558 | 282210.0 |
| 2019-02-19 | E7 | Futures | 1.2444 | 1.2516 | 1.2426 | 1.2497 | 6579.0 |
| 2019-02-19 | EBM | Futures | 200.23 | 201.26 | 199.46 | 199.72 | 13341.0 |
| 2019-02-19 | ED | Futures | 95.0672 | 95.1013 | 95.0647 | 95.094 | 402024.0 |
| 2019-02-19 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.401 | 35217.0 |
| 2019-02-19 | EW | Futures | 2040.7 | 2047.2 | 2029.8 | 2041.6 | 15154.0 |
| 2019-02-19 | FBON | Futures | 132.07 | 132.26 | 132.06 | 132.16 | 343.0 |
| 2019-02-19 | FBTP | Futures | 111.93 | 112.27 | 111.29 | 111.88 | 107873.0 |
| 2019-02-19 | FBTS | Futures | 105.275 | 105.37 | 105.067 | 105.209 | 56820.0 |
| 2019-02-19 | FCE | Futures | 4610.7 | 4616.1 | 4579.9 | 4601.3 | 71377.0 |
| 2019-02-19 | FDAX | Futures | 11874.6 | 11946.6 | 11806.3 | 11871.5 | 99635.0 |
| 2019-02-19 | FDXM | Futures | 11845.7 | 11917.0 | 11778.6 | 11842.6 | 44442.0 |
| 2019-02-19 | FESX | Futures | 2769.7 | 2777.4 | 2752.6 | 2765.4 | 756852.0 |
| 2019-02-19 | FGBL | Futures | 158.23 | 158.55 | 158.09 | 158.23 | 656664.0 |
| 2019-02-19 | FGBM | Futures | 132.56 | 132.65 | 132.51 | 132.52 | 403152.0 |
| 2019-02-19 | FGBS | Futures | 112.673 | 112.703 | 112.663 | 112.673 | 300651.0 |
| 2019-02-19 | FGBX | Futures | 189.13 | 190.15 | 188.73 | 189.26 | 48815.0 |
| 2019-02-19 | FMWO | Futures | 6960.8 | 6995.7 | 6937.5 | 6964.3 | 632.0 |
| 2019-02-19 | FOAT | Futures | 143.43 | 143.73 | 143.41 | 143.57 | 180676.0 |
| 2019-02-19 | FTDX | Futures | 2616.9 | 2635.8 | 2605.9 | 2613.4 | 124.0 |
| 2019-02-19 | FTI | Futures | 507.29 | 507.39 | 502.97 | 505.18 | 20140.0 |
| 2019-02-19 | FTUK | Futures | 6540.0 | 6548.1 | 6482.1 | 6495.3 | 113753.0 |
| 2019-02-19 | FVSA | Futures | 276.12 | 285.73 | 273.5 | 274.37 | 28392.0 |
| 2019-02-19 | FXXP | Futures | 323.5 | 324.2 | 321.7 | 323.2 | 35513.0 |
| 2019-02-19 | G | Futures | 117.71 | 117.84 | 117.54 | 117.56 | 173306.0 |
| 2019-02-19 | GF | Futures | 311.791 | 316.329 | 310.753 | 314.361 | 7801.0 |
| 2019-02-19 | GSCI | Futures | 485.79 | 485.79 | 483.84 | 484.53 | 29.0 |
| 2019-02-19 | HE | Futures | 66.588 | 66.645 | 63.93 | 63.93 | 16369.0 |
> showing 50 of 115 rows — these rows as CSV