PREVIEW / futures_daily / 2020-03-04
file: by_date/futures_daily/2020/2020-03-04.parquet size: 10 KB rows: 121
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-03-04 | ES | Futures | 3227.35 | 3379.9 | 3214.66 | 3363.97 | 2590464.0 |
| 2020-03-04 | NQ | Futures | 9815.62 | 10265.82 | 9759.13 | 10204.46 | 939032.0 |
| 2020-03-04 | YM | Futures | 27104.7 | 28434.3 | 26977.7 | 28318.8 | 381744.0 |
| 2020-03-04 | CL | Futures | 47.93 | 49.43 | 47.63 | 47.76 | 745856.0 |
| 2020-03-04 | GC | Futures | 1999.7 | 2017.0 | 1990.6 | 2003.2 | 313344.0 |
| 2020-03-04 | ZN | Futures | 134.932037 | 135.427599 | 134.467449 | 135.040441 | 43117.0 |
| 2020-03-04 | A6 | Futures | 0.67559 | 0.67959 | 0.67446 | 0.67815 | 122544.0 |
| 2020-03-04 | AD | Futures | 0.75295 | 0.75607 | 0.75028 | 0.75194 | 107743.0 |
| 2020-03-04 | ALI | Futures | 2074.53 | 2087.47 | 2071.22 | 2081.75 | 180.0 |
| 2020-03-04 | B | Futures | 44.33 | 45.11 | 43.42 | 43.49 | 363501.0 |
| 2020-03-04 | B6 | Futures | 1.2999 | 1.3057 | 1.2954 | 1.3051 | 131448.0 |
| 2020-03-04 | BR | Futures | 0.18197 | 0.18197 | 0.17783 | 0.17841 | 252.0 |
| 2020-03-04 | BTC | Futures | 12893.1 | 13010.0 | 12703.3 | 12790.9 | 1842.0 |
| 2020-03-04 | BZ | Futures | 42.83 | 43.91 | 42.26 | 42.33 | 39712.0 |
| 2020-03-04 | C | Futures | 1813.0 | 1821.0 | 1796.0 | 1799.0 | 1868.0 |
| 2020-03-04 | CB | Futures | 216.931 | 217.628 | 216.68 | 217.628 | 22.0 |
| 2020-03-04 | CC | Futures | 1733.0 | 1743.0 | 1716.0 | 1720.0 | 16692.0 |
| 2020-03-04 | CNH | Futures | 6.9118 | 6.9156 | 6.8841 | 6.8876 | 1110.0 |
| 2020-03-04 | CSC | Futures | 3.181 | 3.183 | 3.163 | 3.181 | 76.0 |
| 2020-03-04 | CT | Futures | 60.62 | 61.67 | 60.53 | 60.64 | 16832.0 |
| 2020-03-04 | DC | Futures | 26.16 | 26.37 | 26.03 | 26.16 | 157.0 |
| 2020-03-04 | DX | Futures | 94.288 | 94.696 | 94.216 | 94.446 | 22197.0 |
| 2020-03-04 | E1 | Futures | 1.19649 | 1.199 | 1.19089 | 1.19557 | 50628.0 |
| 2020-03-04 | E6 | Futures | 1.20474 | 1.20604 | 1.19612 | 1.20076 | 304342.0 |
| 2020-03-04 | E7 | Futures | 1.1981 | 1.1998 | 1.1899 | 1.1945 | 8245.0 |
| 2020-03-04 | EBM | Futures | 204.95 | 209.35 | 204.4 | 205.77 | 1817.0 |
| 2020-03-04 | ED | Futures | 96.0455 | 96.1037 | 96.0043 | 96.0455 | 801979.0 |
| 2020-03-04 | ER | Futures | 98.494 | 98.499 | 98.47 | 98.489 | 203886.0 |
| 2020-03-04 | ESG | Futures | 273.34 | 280.26 | 272.26 | 280.26 | 675.0 |
| 2020-03-04 | EW | Futures | 1923.8 | 2001.4 | 1914.9 | 1999.7 | 27023.0 |
| 2020-03-04 | FBON | Futures | 146.94 | 147.57 | 146.92 | 147.05 | 1769.0 |
| 2020-03-04 | FBTP | Futures | 132.06 | 133.02 | 131.52 | 131.93 | 307999.0 |
| 2020-03-04 | FBTS | Futures | 108.451 | 108.615 | 108.307 | 108.403 | 151244.0 |
| 2020-03-04 | FCE | Futures | 4868.3 | 5008.1 | 4841.7 | 4940.3 | 155424.0 |
| 2020-03-04 | FDAX | Futures | 12522.6 | 12981.6 | 12522.6 | 12780.2 | 149245.0 |
| 2020-03-04 | FDIV | Futures | 143.08 | 143.08 | 142.38 | 142.38 | 3.0 |
| 2020-03-04 | FDXM | Futures | 12376.4 | 12818.1 | 12374.3 | 12619.7 | 156386.0 |
| 2020-03-04 | FESX | Futures | 2932.2 | 3053.8 | 2932.2 | 3004.4 | 2140320.0 |
| 2020-03-04 | FGBL | Futures | 170.24 | 170.36 | 169.5 | 169.92 | 1170399.0 |
| 2020-03-04 | FGBM | Futures | 135.63 | 135.68 | 135.36 | 135.56 | 899318.0 |
| 2020-03-04 | FGBS | Futures | 113.122 | 113.137 | 113.061 | 113.127 | 649778.0 |
| 2020-03-04 | FGBX | Futures | 231.72 | 232.43 | 228.84 | 230.4 | 131606.0 |
| 2020-03-04 | FMWO | Futures | 7296.3 | 7510.6 | 7296.3 | 7360.9 | 8521.0 |
| 2020-03-04 | FOAT | Futures | 156.65 | 156.79 | 156.22 | 156.58 | 372365.0 |
| 2020-03-04 | FTDX | Futures | 2961.0 | 2985.6 | 2942.9 | 2958.9 | 108.0 |
| 2020-03-04 | FTI | Futures | 526.69 | 543.25 | 524.92 | 535.02 | 51927.0 |
| 2020-03-04 | FTUK | Futures | 6252.9 | 6446.6 | 6241.6 | 6363.1 | 200163.0 |
| 2020-03-04 | FVSA | Futures | 204.99 | 208.25 | 193.6 | 200.93 | 79350.0 |
| 2020-03-04 | FXXP | Futures | 346.4 | 356.9 | 345.5 | 351.6 | 143641.0 |
| 2020-03-04 | G | Futures | 124.71 | 125.13 | 124.45 | 124.71 | 292685.0 |
> showing 50 of 121 rows — these rows as CSV