PREVIEW / futures_daily / 2020-08-24
file: by_date/futures_daily/2020/2020-08-24.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-08-24 | ES | Futures | 3825.59 | 3860.2 | 3819.68 | 3857.95 | 1282950.0 |
| 2020-08-24 | NQ | Futures | 13441.37 | 13605.6 | 13380.14 | 13505.49 | 617004.0 |
| 2020-08-24 | YM | Futures | 29900.2 | 30292.4 | 29875.5 | 30263.5 | 157196.0 |
| 2020-08-24 | CL | Futures | 30.72 | 31.02 | 30.54 | 30.82 | 294731.0 |
| 2020-08-24 | GC | Futures | 2300.5 | 2326.9 | 2280.3 | 2290.2 | 286258.0 |
| 2020-08-24 | ZN | Futures | 138.357372 | 138.465766 | 138.187038 | 138.264463 | 1526307.0 |
| 2020-08-24 | A6 | Futures | 0.73695 | 0.74117 | 0.73582 | 0.73674 | 53286.0 |
| 2020-08-24 | AD | Futures | 0.77017 | 0.77286 | 0.76667 | 0.76708 | 58450.0 |
| 2020-08-24 | ALI | Futures | 2134.96 | 2136.74 | 2106.37 | 2118.28 | 381.0 |
| 2020-08-24 | B | Futures | 28.69 | 29.13 | 28.55 | 29.09 | 176636.0 |
| 2020-08-24 | B6 | Futures | 1.329 | 1.3354 | 1.3257 | 1.3261 | 74071.0 |
| 2020-08-24 | BR | Futures | 0.1412 | 0.14243 | 0.14108 | 0.14163 | 7106.0 |
| 2020-08-24 | BTC | Futures | 15999.6 | 16222.4 | 15864.6 | 16121.1 | 2090.0 |
| 2020-08-24 | BZ | Futures | 27.96 | 28.44 | 27.88 | 28.41 | 21033.0 |
| 2020-08-24 | C | Futures | 1476.0 | 1557.0 | 1476.0 | 1529.0 | 3699.0 |
| 2020-08-24 | CB | Futures | 172.787 | 173.295 | 172.787 | 172.787 | 144.0 |
| 2020-08-24 | CC | Futures | 1581.0 | 1625.0 | 1577.0 | 1615.0 | 15672.0 |
| 2020-08-24 | CNH | Futures | 6.8198 | 6.8208 | 6.8086 | 6.8187 | 318.0 |
| 2020-08-24 | CSC | Futures | 3.2 | 3.332 | 3.2 | 3.318 | 222.0 |
| 2020-08-24 | CT | Futures | 64.86 | 66.03 | 64.82 | 65.9 | 31.0 |
| 2020-08-24 | DC | Futures | 25.84 | 27.08 | 25.82 | 26.95 | 570.0 |
| 2020-08-24 | DX | Futures | 90.039 | 90.16 | 89.668 | 90.111 | 16197.0 |
| 2020-08-24 | E1 | Futures | 1.24613 | 1.25226 | 1.24488 | 1.24693 | 18189.0 |
| 2020-08-24 | E6 | Futures | 1.26611 | 1.27212 | 1.26503 | 1.26589 | 140117.0 |
| 2020-08-24 | E7 | Futures | 1.2597 | 1.2658 | 1.2587 | 1.2596 | 6413.0 |
| 2020-08-24 | EBM | Futures | 221.85 | 224.1 | 221.85 | 222.45 | 8201.0 |
| 2020-08-24 | ED | Futures | 96.4451 | 96.4523 | 96.4403 | 96.4475 | 97889.0 |
| 2020-08-24 | ER | Futures | 98.406 | 98.406 | 98.401 | 98.406 | 23050.0 |
| 2020-08-24 | ESG | Futures | 312.68 | 313.04 | 312.02 | 313.04 | 929.0 |
| 2020-08-24 | EW | Futures | 2031.0 | 2060.8 | 2030.9 | 2059.8 | 11029.0 |
| 2020-08-24 | FBON | Futures | 147.11 | 147.2 | 146.69 | 146.82 | 285.0 |
| 2020-08-24 | FBTP | Futures | 133.79 | 134.01 | 133.41 | 133.68 | 49891.0 |
| 2020-08-24 | FBTS | Futures | 109.064 | 109.084 | 108.967 | 109.026 | 29525.0 |
| 2020-08-24 | FCE | Futures | 4787.0 | 4877.6 | 4786.5 | 4871.2 | 64590.0 |
| 2020-08-24 | FDAX | Futures | 13594.3 | 13922.0 | 13577.3 | 13880.1 | 70964.0 |
| 2020-08-24 | FDIV | Futures | 148.91 | 150.81 | 148.91 | 150.81 | 190.0 |
| 2020-08-24 | FDXM | Futures | 13559.0 | 13872.3 | 13528.3 | 13830.0 | 43203.0 |
| 2020-08-24 | FESX | Futures | 3012.1 | 3079.5 | 3008.4 | 3073.0 | 797638.0 |
| 2020-08-24 | FGBL | Futures | 169.32 | 169.35 | 168.86 | 169.13 | 461448.0 |
| 2020-08-24 | FGBM | Futures | 135.02 | 135.03 | 134.85 | 134.93 | 305009.0 |
| 2020-08-24 | FGBS | Futures | 112.744 | 112.749 | 112.719 | 112.734 | 190216.0 |
| 2020-08-24 | FGBX | Futures | 230.17 | 230.42 | 228.46 | 229.43 | 41385.0 |
| 2020-08-24 | FMWO | Futures | 8462.8 | 8505.4 | 8459.2 | 8466.3 | 1882.0 |
| 2020-08-24 | FOAT | Futures | 156.77 | 156.84 | 156.34 | 156.63 | 112252.0 |
| 2020-08-24 | FTDX | Futures | 3177.3 | 3214.1 | 3177.3 | 3185.0 | 63.0 |
| 2020-08-24 | FTI | Futures | 515.98 | 525.07 | 515.98 | 522.36 | 23501.0 |
| 2020-08-24 | FTUK | Futures | 5679.3 | 5781.9 | 5671.8 | 5767.2 | 78465.0 |
| 2020-08-24 | FVSA | Futures | 203.34 | 203.34 | 199.19 | 200.85 | 16755.0 |
| 2020-08-24 | FXXP | Futures | 338.6 | 343.1 | 338.5 | 342.2 | 41524.0 |
| 2020-08-24 | G | Futures | 126.79 | 127.01 | 126.74 | 126.85 | 431967.0 |
> showing 50 of 121 rows — these rows as CSV