PREVIEW / futures_daily / 2021-05-19
file: by_date/futures_daily/2021/2021-05-19.parquet size: 10 KB rows: 122
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 |
|---|---|---|---|---|---|---|---|
| 2021-05-19 | ES | Futures | 4616.54 | 4626.64 | 4550.9 | 4613.74 | 2313119.0 |
| 2021-05-19 | NQ | Futures | 15204.37 | 15274.73 | 14941.68 | 15263.77 | 669351.0 |
| 2021-05-19 | YM | Futures | 36690.1 | 36797.2 | 36152.2 | 36616.5 | 244203.0 |
| 2021-05-19 | CL | Futures | 46.48 | 46.51 | 44.09 | 45.09 | 615261.0 |
| 2021-05-19 | GC | Futures | 2192.5 | 2217.3 | 2171.4 | 2205.8 | 398212.0 |
| 2021-05-19 | ZN | Futures | 133.065468 | 133.253924 | 132.610033 | 132.704261 | 2044316.0 |
| 2021-05-19 | A6 | Futures | 0.79895 | 0.79966 | 0.79064 | 0.79136 | 112585.0 |
| 2021-05-19 | AD | Futures | 0.83993 | 0.84054 | 0.83436 | 0.83497 | 90723.0 |
| 2021-05-19 | ALI | Futures | 2789.44 | 2804.94 | 2747.17 | 2751.68 | 1022.0 |
| 2021-05-19 | B | Futures | 44.74 | 44.78 | 42.71 | 43.6 | 386890.0 |
| 2021-05-19 | B6 | Futures | 1.4403 | 1.4421 | 1.4315 | 1.4324 | 98961.0 |
| 2021-05-19 | BR | Futures | 0.15104 | 0.15104 | 0.14846 | 0.14858 | 5274.0 |
| 2021-05-19 | BTC | Futures | 59265.8 | 60115.1 | 41713.2 | 54328.7 | 26734.0 |
| 2021-05-19 | BZ | Futures | 43.77 | 43.79 | 41.67 | 42.55 | 42607.0 |
| 2021-05-19 | C | Futures | 1529.0 | 1529.0 | 1485.0 | 1496.0 | 7508.0 |
| 2021-05-19 | CB | Futures | 152.75 | 153.927 | 152.75 | 153.535 | 11.0 |
| 2021-05-19 | CC | Futures | 1661.0 | 1671.0 | 1633.0 | 1645.0 | 16513.0 |
| 2021-05-19 | CNH | Futures | 6.239 | 6.2508 | 6.2364 | 6.2503 | 685.0 |
| 2021-05-19 | CSC | Futures | 2.806 | 2.806 | 2.776 | 2.792 | 287.0 |
| 2021-05-19 | CT | Futures | 78.5 | 78.57 | 76.61 | 77.32 | 15976.0 |
| 2021-05-19 | DC | Futures | 26.07 | 26.07 | 25.76 | 25.83 | 524.0 |
| 2021-05-19 | DX | Futures | 86.755 | 87.243 | 86.663 | 87.157 | 32530.0 |
| 2021-05-19 | E1 | Futures | 1.25536 | 1.25559 | 1.24467 | 1.24591 | 27091.0 |
| 2021-05-19 | E6 | Futures | 1.30324 | 1.30547 | 1.29631 | 1.29769 | 191975.0 |
| 2021-05-19 | E7 | Futures | 1.2965 | 1.2988 | 1.2897 | 1.2912 | 5909.0 |
| 2021-05-19 | EBM | Futures | 312.61 | 314.45 | 308.56 | 311.14 | 34040.0 |
| 2021-05-19 | ED | Futures | 96.5246 | 96.5318 | 96.5246 | 96.527 | 132122.0 |
| 2021-05-19 | ER | Futures | 98.46 | 98.465 | 98.455 | 98.46 | 44241.0 |
| 2021-05-19 | ESG | Futures | 380.17 | 381.46 | 376.77 | 381.46 | 1582.0 |
| 2021-05-19 | EW | Futures | 2876.0 | 2876.0 | 2810.8 | 2857.6 | 10942.0 |
| 2021-05-19 | FBON | Futures | 145.43 | 145.55 | 144.88 | 145.39 | 944.0 |
| 2021-05-19 | FBTP | Futures | 135.08 | 135.23 | 134.55 | 135.02 | 179745.0 |
| 2021-05-19 | FBTS | Futures | 109.835 | 109.845 | 109.757 | 109.815 | 104519.0 |
| 2021-05-19 | FCE | Futures | 6265.7 | 6273.2 | 6146.0 | 6216.4 | 65007.0 |
| 2021-05-19 | FDAX | Futures | 16309.6 | 16340.5 | 15941.8 | 16121.9 | 90728.0 |
| 2021-05-19 | FDIV | Futures | 185.49 | 185.49 | 182.84 | 183.77 | 142.0 |
| 2021-05-19 | FDXM | Futures | 16288.6 | 16317.4 | 15922.4 | 16102.3 | 88165.0 |
| 2021-05-19 | FDXS | Futures | 16218.8 | 16232.5 | 15835.4 | 16016.5 | 4346.0 |
| 2021-05-19 | FESX | Futures | 3754.5 | 3764.8 | 3669.4 | 3714.8 | 1308832.0 |
| 2021-05-19 | FGBL | Futures | 165.0 | 165.35 | 164.54 | 165.14 | 1007072.0 |
| 2021-05-19 | FGBM | Futures | 134.06 | 134.18 | 133.92 | 134.1 | 469355.0 |
| 2021-05-19 | FGBS | Futures | 112.564 | 112.584 | 112.544 | 112.574 | 406625.0 |
| 2021-05-19 | FGBX | Futures | 209.87 | 211.25 | 208.6 | 210.66 | 92558.0 |
| 2021-05-19 | FMWO | Futures | 10258.2 | 10268.8 | 10131.3 | 10187.7 | 3669.0 |
| 2021-05-19 | FOAT | Futures | 152.76 | 153.13 | 152.36 | 152.91 | 211062.0 |
| 2021-05-19 | FTDX | Futures | 3392.3 | 3410.3 | 3362.0 | 3389.3 | 176.0 |
| 2021-05-19 | FTI | Futures | 662.83 | 663.88 | 651.06 | 658.65 | 15753.0 |
| 2021-05-19 | FTUK | Futures | 6795.9 | 6812.4 | 6698.5 | 6749.6 | 119515.0 |
| 2021-05-19 | FVSA | Futures | 114.06 | 128.38 | 112.76 | 122.65 | 58187.0 |
| 2021-05-19 | FXXP | Futures | 415.4 | 416.1 | 409.1 | 412.7 | 105196.0 |
> showing 50 of 122 rows — these rows as CSV