PREVIEW / futures_daily / 2020-06-04
file: by_date/futures_daily/2020/2020-06-04.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-06-04 | ES | Futures | 3449.75 | 3459.7 | 3416.27 | 3441.72 | 1830904.0 |
| 2020-06-04 | NQ | Futures | 11103.84 | 11169.19 | 10974.01 | 11035.92 | 462358.0 |
| 2020-06-04 | YM | Futures | 28026.1 | 28136.1 | 27803.1 | 28013.3 | 227967.0 |
| 2020-06-04 | CL | Futures | 26.65 | 27.27 | 26.37 | 27.12 | 307612.0 |
| 2020-06-04 | GC | Futures | 2044.4 | 2075.9 | 2039.7 | 2073.9 | 198723.0 |
| 2020-06-04 | ZN | Futures | 136.991157 | 137.052899 | 136.420039 | 136.528088 | 28105.0 |
| 2020-06-04 | A6 | Futures | 0.71124 | 0.71792 | 0.70703 | 0.71298 | 114338.0 |
| 2020-06-04 | AD | Futures | 0.75089 | 0.75247 | 0.74836 | 0.75034 | 68861.0 |
| 2020-06-04 | ALI | Futures | 1886.95 | 1886.95 | 1866.75 | 1876.85 | 75.0 |
| 2020-06-04 | B | Futures | 25.92 | 26.25 | 25.55 | 26.18 | 172605.0 |
| 2020-06-04 | B6 | Futures | 1.2764 | 1.2825 | 1.269 | 1.2804 | 104306.0 |
| 2020-06-04 | BR | Futures | 0.1561 | 0.1561 | 0.15392 | 0.15455 | 89.0 |
| 2020-06-04 | BTC | Futures | 13442.4 | 13887.4 | 13261.6 | 13762.3 | 4328.0 |
| 2020-06-04 | BZ | Futures | 25.18 | 25.64 | 24.97 | 25.57 | 22661.0 |
| 2020-06-04 | C | Futures | 1844.0 | 1859.0 | 1807.0 | 1813.0 | 4488.0 |
| 2020-06-04 | CB | Futures | 215.582 | 218.792 | 215.582 | 218.792 | 29.0 |
| 2020-06-04 | CC | Futures | 1565.0 | 1580.0 | 1552.0 | 1559.0 | 13622.0 |
| 2020-06-04 | CNH | Futures | 7.0556 | 7.0683 | 7.0415 | 7.0415 | 307.0 |
| 2020-06-04 | CSC | Futures | 3.482 | 3.492 | 3.482 | 3.484 | 27.0 |
| 2020-06-04 | CT | Futures | 58.65 | 58.91 | 58.16 | 58.49 | 13450.0 |
| 2020-06-04 | DC | Futures | 29.16 | 29.16 | 28.96 | 29.11 | 119.0 |
| 2020-06-04 | DX | Futures | 94.106 | 94.411 | 93.371 | 93.465 | 30706.0 |
| 2020-06-04 | E1 | Futures | 1.18499 | 1.19365 | 1.18362 | 1.19296 | 32427.0 |
| 2020-06-04 | E6 | Futures | 1.20772 | 1.22142 | 1.20336 | 1.22008 | 294675.0 |
| 2020-06-04 | E7 | Futures | 1.2017 | 1.215 | 1.1971 | 1.2137 | 12633.0 |
| 2020-06-04 | EBM | Futures | 222.75 | 226.04 | 221.85 | 224.54 | 26408.0 |
| 2020-06-04 | ED | Futures | 96.3823 | 96.3895 | 96.3799 | 96.3823 | 160043.0 |
| 2020-06-04 | ER | Futures | 98.318 | 98.333 | 98.313 | 98.318 | 83743.0 |
| 2020-06-04 | EW | Futures | 1958.3 | 1969.8 | 1934.4 | 1960.5 | 11405.0 |
| 2020-06-04 | FBON | Futures | 142.7 | 143.97 | 142.43 | 143.59 | 2597.0 |
| 2020-06-04 | FBTP | Futures | 126.64 | 128.43 | 126.06 | 127.96 | 214890.0 |
| 2020-06-04 | FBTS | Futures | 107.836 | 108.23 | 107.691 | 108.115 | 137416.0 |
| 2020-06-04 | FCE | Futures | 4861.2 | 4905.4 | 4818.0 | 4864.1 | 72245.0 |
| 2020-06-04 | FDAX | Futures | 13270.3 | 13288.8 | 13036.0 | 13143.9 | 109777.0 |
| 2020-06-04 | FDXM | Futures | 13322.0 | 13347.5 | 13098.8 | 13206.7 | 68887.0 |
| 2020-06-04 | FESX | Futures | 3006.8 | 3016.9 | 2959.1 | 2985.7 | 1570819.0 |
| 2020-06-04 | FEU3 | Futures | 99.06 | 99.06 | 99.06 | 99.06 | 360.0 |
| 2020-06-04 | FGBL | Futures | 166.26 | 166.55 | 165.61 | 165.77 | 1106155.0 |
| 2020-06-04 | FGBM | Futures | 134.1 | 134.26 | 133.96 | 134.01 | 643454.0 |
| 2020-06-04 | FGBS | Futures | 112.674 | 112.714 | 112.609 | 112.629 | 528867.0 |
| 2020-06-04 | FGBX | Futures | 219.42 | 220.52 | 215.9 | 216.64 | 126868.0 |
| 2020-06-04 | FMWO | Futures | 7729.2 | 7746.8 | 7669.2 | 7708.0 | 3580.0 |
| 2020-06-04 | FOAT | Futures | 152.39 | 153.23 | 152.28 | 152.67 | 294312.0 |
| 2020-06-04 | FTDX | Futures | 3280.8 | 3300.0 | 3269.1 | 3274.7 | 87.0 |
| 2020-06-04 | FTI | Futures | 520.74 | 525.12 | 517.44 | 520.65 | 26085.0 |
| 2020-06-04 | FTUK | Futures | 6026.1 | 6037.9 | 5950.2 | 5973.3 | 105744.0 |
| 2020-06-04 | FVSA | Futures | 248.82 | 252.89 | 238.42 | 243.39 | 31478.0 |
| 2020-06-04 | FXXP | Futures | 339.5 | 342.1 | 337.3 | 338.8 | 154119.0 |
| 2020-06-04 | G | Futures | 125.92 | 126.22 | 125.5 | 125.6 | 240186.0 |
| 2020-06-04 | GF | Futures | 259.126 | 262.324 | 259.029 | 261.161 | 2923.0 |
> showing 50 of 119 rows — these rows as CSV