PREVIEW / futures_daily / 2020-06-08
file: by_date/futures_daily/2020/2020-06-08.parquet size: 10 KB rows: 120
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-08 | ES | Futures | 3532.46 | 3575.33 | 3522.22 | 3571.18 | 1602601.0 |
| 2020-06-08 | NQ | Futures | 11256.89 | 11350.9 | 11174.35 | 11332.27 | 391647.0 |
| 2020-06-08 | YM | Futures | 28942.7 | 29411.2 | 28843.5 | 29372.8 | 191224.0 |
| 2020-06-08 | CL | Futures | 28.57 | 29.32 | 27.52 | 27.69 | 416639.0 |
| 2020-06-08 | GC | Futures | 2025.1 | 2050.2 | 2017.9 | 2047.2 | 154767.0 |
| 2020-06-08 | ZN | Futures | 135.879792 | 136.251429 | 135.709458 | 136.06561 | 950189.0 |
| 2020-06-08 | A6 | Futures | 0.71637 | 0.72223 | 0.71524 | 0.72141 | 78277.0 |
| 2020-06-08 | AD | Futures | 0.7554 | 0.7587 | 0.75414 | 0.75829 | 66236.0 |
| 2020-06-08 | ALI | Futures | 1920.22 | 1944.58 | 1920.22 | 1934.19 | 128.0 |
| 2020-06-08 | B | Futures | 27.75 | 28.41 | 26.63 | 26.71 | 227881.0 |
| 2020-06-08 | B6 | Futures | 1.2872 | 1.2928 | 1.2818 | 1.2918 | 98667.0 |
| 2020-06-08 | BFX | Futures | 3601.4 | 3601.4 | 3560.8 | 3579.6 | 18.0 |
| 2020-06-08 | BR | Futures | 0.15958 | 0.16188 | 0.15958 | 0.16172 | 3.0 |
| 2020-06-08 | BTC | Futures | 13644.0 | 13769.2 | 13518.9 | 13602.3 | 3757.0 |
| 2020-06-08 | BZ | Futures | 27.11 | 27.77 | 26.01 | 26.08 | 28718.0 |
| 2020-06-08 | C | Futures | 1800.0 | 1800.0 | 1765.0 | 1769.0 | 8540.0 |
| 2020-06-08 | CB | Futures | 213.71 | 215.341 | 213.71 | 215.047 | 25.0 |
| 2020-06-08 | CC | Futures | 1566.0 | 1573.0 | 1550.0 | 1556.0 | 22804.0 |
| 2020-06-08 | CNH | Futures | 7.0048 | 7.022 | 6.9887 | 6.9887 | 1012.0 |
| 2020-06-08 | CSC | Futures | 3.443 | 3.508 | 3.443 | 3.508 | 11.0 |
| 2020-06-08 | CT | Futures | 60.59 | 60.59 | 59.05 | 59.28 | 15193.0 |
| 2020-06-08 | DC | Futures | 28.79 | 29.2 | 28.79 | 29.16 | 116.0 |
| 2020-06-08 | DX | Futures | 93.734 | 93.859 | 93.39 | 93.418 | 19422.0 |
| 2020-06-08 | E1 | Futures | 1.18488 | 1.19194 | 1.18157 | 1.19046 | 23957.0 |
| 2020-06-08 | E6 | Futures | 1.21406 | 1.21674 | 1.21126 | 1.21513 | 193781.0 |
| 2020-06-08 | E7 | Futures | 1.2077 | 1.2104 | 1.2048 | 1.2088 | 5489.0 |
| 2020-06-08 | EBM | Futures | 223.05 | 223.94 | 221.25 | 222.75 | 11787.0 |
| 2020-06-08 | ED | Futures | 96.3823 | 96.3847 | 96.3654 | 96.3702 | 185539.0 |
| 2020-06-08 | ER | Futures | 98.323 | 98.333 | 98.318 | 98.328 | 61680.0 |
| 2020-06-08 | ESG | Futures | 290.03 | 290.47 | 290.03 | 290.47 | 10.0 |
| 2020-06-08 | EW | Futures | 2025.3 | 2062.0 | 2019.4 | 2060.7 | 9849.0 |
| 2020-06-08 | FBON | Futures | 143.68 | 144.14 | 143.56 | 143.8 | 605.0 |
| 2020-06-08 | FBTP | Futures | 127.71 | 128.27 | 127.42 | 128.01 | 83976.0 |
| 2020-06-08 | FBTS | Futures | 108.105 | 108.221 | 108.027 | 108.173 | 42249.0 |
| 2020-06-08 | FCE | Futures | 5027.8 | 5076.8 | 4985.5 | 5023.9 | 56761.0 |
| 2020-06-08 | FDAX | Futures | 13579.6 | 13679.6 | 13407.2 | 13583.3 | 86491.0 |
| 2020-06-08 | FDXM | Futures | 13636.5 | 13747.0 | 13471.8 | 13648.2 | 61508.0 |
| 2020-06-08 | FESX | Futures | 3095.8 | 3115.1 | 3061.0 | 3089.4 | 1235165.0 |
| 2020-06-08 | FGBL | Futures | 165.37 | 165.95 | 165.09 | 165.78 | 532911.0 |
| 2020-06-08 | FGBM | Futures | 133.84 | 134.15 | 133.79 | 134.06 | 358123.0 |
| 2020-06-08 | FGBS | Futures | 112.578 | 112.669 | 112.573 | 112.634 | 251883.0 |
| 2020-06-08 | FGBX | Futures | 215.34 | 216.87 | 213.59 | 216.15 | 49144.0 |
| 2020-06-08 | FMWO | Futures | 7885.6 | 7971.5 | 7858.6 | 7922.1 | 5023.0 |
| 2020-06-08 | FOAT | Futures | 152.7 | 153.27 | 152.49 | 153.12 | 135406.0 |
| 2020-06-08 | FTDX | Futures | 3265.1 | 3265.6 | 3201.9 | 3226.2 | 318.0 |
| 2020-06-08 | FTI | Futures | 531.27 | 532.8 | 524.61 | 527.28 | 21166.0 |
| 2020-06-08 | FTUK | Futures | 6113.8 | 6139.7 | 6053.4 | 6107.2 | 91438.0 |
| 2020-06-08 | FVSA | Futures | 238.42 | 250.18 | 235.7 | 243.39 | 13871.0 |
| 2020-06-08 | FXXP | Futures | 345.4 | 349.0 | 343.7 | 346.8 | 70835.0 |
| 2020-06-08 | G | Futures | 125.25 | 125.43 | 125.05 | 125.29 | 120995.0 |
> showing 50 of 120 rows — these rows as CSV