PREVIEW / futures_daily / 2020-08-11
file: by_date/futures_daily/2020/2020-08-11.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-11 | ES | Futures | 3771.0 | 3803.36 | 3736.39 | 3748.2 | 1733040.0 |
| 2020-08-11 | NQ | Futures | 12850.89 | 12950.13 | 12587.72 | 12626.02 | 561748.0 |
| 2020-08-11 | YM | Futures | 29675.1 | 30081.3 | 29505.8 | 29593.7 | 236391.0 |
| 2020-08-11 | CL | Futures | 30.63 | 31.33 | 30.27 | 30.36 | 432843.0 |
| 2020-08-11 | GC | Futures | 2407.4 | 2409.9 | 2257.3 | 2298.6 | 565001.0 |
| 2020-08-11 | ZN | Futures | 138.620615 | 138.682554 | 137.97025 | 138.00122 | 1529185.0 |
| 2020-08-11 | A6 | Futures | 0.73571 | 0.73962 | 0.73397 | 0.73582 | 91194.0 |
| 2020-08-11 | AD | Futures | 0.76033 | 0.76489 | 0.75977 | 0.76413 | 56698.0 |
| 2020-08-11 | ALI | Futures | 2177.22 | 2194.21 | 2177.22 | 2189.36 | 196.0 |
| 2020-08-11 | B | Futures | 29.04 | 29.52 | 28.62 | 28.69 | 202739.0 |
| 2020-08-11 | B6 | Futures | 1.3276 | 1.3336 | 1.3245 | 1.3267 | 93347.0 |
| 2020-08-11 | BR | Futures | 0.14393 | 0.1473 | 0.14393 | 0.14651 | 8816.0 |
| 2020-08-11 | BTC | Futures | 16423.7 | 16540.0 | 15308.7 | 15643.9 | 10291.0 |
| 2020-08-11 | BZ | Futures | 28.32 | 28.82 | 27.96 | 28.01 | 19786.0 |
| 2020-08-11 | C | Futures | 1543.0 | 1546.0 | 1506.0 | 1523.0 | 5045.0 |
| 2020-08-11 | CB | Futures | 171.155 | 173.856 | 171.155 | 173.856 | 8.0 |
| 2020-08-11 | CC | Futures | 1625.0 | 1625.0 | 1594.0 | 1608.0 | 31245.0 |
| 2020-08-11 | CNH | Futures | 6.8716 | 6.8716 | 6.8521 | 6.8543 | 798.0 |
| 2020-08-11 | CSC | Futures | 3.433 | 3.474 | 3.385 | 3.43 | 201.0 |
| 2020-08-11 | CT | Futures | 63.48 | 63.75 | 63.16 | 63.75 | 7.0 |
| 2020-08-11 | DC | Futures | 27.7 | 28.26 | 27.41 | 27.89 | 508.0 |
| 2020-08-11 | DX | Futures | 90.406 | 90.542 | 89.967 | 90.411 | 23497.0 |
| 2020-08-11 | E1 | Futures | 1.2417 | 1.2484 | 1.23864 | 1.23943 | 28179.0 |
| 2020-08-11 | E6 | Futures | 1.2608 | 1.26798 | 1.25865 | 1.26122 | 224689.0 |
| 2020-08-11 | E7 | Futures | 1.2546 | 1.2615 | 1.2523 | 1.2549 | 7349.0 |
| 2020-08-11 | EBM | Futures | 211.67 | 213.47 | 211.67 | 212.87 | 12263.0 |
| 2020-08-11 | ED | Futures | 96.4427 | 96.4427 | 96.4282 | 96.4282 | 215619.0 |
| 2020-08-11 | ER | Futures | 98.391 | 98.396 | 98.386 | 98.391 | 76129.0 |
| 2020-08-11 | ESG | Futures | 305.53 | 305.83 | 301.92 | 302.24 | 24.0 |
| 2020-08-11 | EW | Futures | 2068.2 | 2098.9 | 2060.8 | 2066.0 | 13865.0 |
| 2020-08-11 | FBON | Futures | 147.44 | 147.66 | 147.04 | 147.17 | 339.0 |
| 2020-08-11 | FBTP | Futures | 133.82 | 134.03 | 133.35 | 133.48 | 59317.0 |
| 2020-08-11 | FBTS | Futures | 108.919 | 108.958 | 108.88 | 108.9 | 34480.0 |
| 2020-08-11 | FCE | Futures | 4782.7 | 4882.3 | 4772.6 | 4858.1 | 77450.0 |
| 2020-08-11 | FDAX | Futures | 13535.9 | 13857.2 | 13513.5 | 13748.3 | 90808.0 |
| 2020-08-11 | FDIV | Futures | 147.16 | 149.76 | 147.11 | 149.0 | 230.0 |
| 2020-08-11 | FDXM | Futures | 13478.6 | 13807.8 | 13461.6 | 13698.7 | 46443.0 |
| 2020-08-11 | FESX | Futures | 3018.6 | 3089.7 | 3015.8 | 3071.2 | 912230.0 |
| 2020-08-11 | FGBL | Futures | 169.49 | 169.59 | 168.7 | 168.79 | 562874.0 |
| 2020-08-11 | FGBM | Futures | 135.05 | 135.11 | 134.83 | 134.86 | 320302.0 |
| 2020-08-11 | FGBS | Futures | 112.774 | 112.8 | 112.739 | 112.744 | 213677.0 |
| 2020-08-11 | FGBX | Futures | 231.18 | 231.41 | 227.72 | 228.27 | 42092.0 |
| 2020-08-11 | FMWO | Futures | 8295.7 | 8388.1 | 8255.4 | 8354.9 | 2970.0 |
| 2020-08-11 | FOAT | Futures | 157.01 | 157.18 | 156.46 | 156.57 | 140436.0 |
| 2020-08-11 | FTDX | Futures | 3124.2 | 3156.4 | 3124.2 | 3144.1 | 66.0 |
| 2020-08-11 | FTI | Futures | 524.69 | 528.28 | 520.5 | 525.7 | 37.0 |
| 2020-08-11 | FTUK | Futures | 5716.2 | 5838.1 | 5710.0 | 5780.0 | 104147.0 |
| 2020-08-11 | FVSA | Futures | 211.75 | 228.04 | 202.7 | 210.39 | 19723.0 |
| 2020-08-11 | FXXP | Futures | 339.2 | 343.3 | 338.4 | 341.3 | 62620.0 |
| 2020-08-11 | G | Futures | 127.65 | 127.7 | 126.81 | 126.88 | 279978.0 |
> showing 50 of 121 rows — these rows as CSV