PREVIEW / futures_daily / 2020-10-12
file: by_date/futures_daily/2020/2020-10-12.parquet size: 10 KB rows: 119
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-10-12 | ES | Futures | 3895.67 | 3978.25 | 3892.02 | 3968.98 | 1401063.0 |
| 2020-10-12 | NQ | Futures | 13571.53 | 14120.58 | 13531.01 | 14006.25 | 756438.0 |
| 2020-10-12 | YM | Futures | 30701.9 | 31055.0 | 30610.4 | 31003.3 | 173932.0 |
| 2020-10-12 | CL | Futures | 29.01 | 29.04 | 28.03 | 28.31 | 322035.0 |
| 2020-10-12 | GC | Futures | 2285.3 | 2290.5 | 2272.0 | 2278.1 | 157212.0 |
| 2020-10-12 | ZN | Futures | 137.691315 | 137.799795 | 137.660321 | 137.768801 | 195305.0 |
| 2020-10-12 | A6 | Futures | 0.74221 | 0.74293 | 0.73944 | 0.74056 | 70031.0 |
| 2020-10-12 | AD | Futures | 0.772 | 0.77362 | 0.77114 | 0.77276 | 39012.0 |
| 2020-10-12 | ALI | Futures | 2231.57 | 2236.62 | 2231.27 | 2236.02 | 115.0 |
| 2020-10-12 | B | Futures | 26.88 | 26.95 | 26.1 | 26.32 | 238874.0 |
| 2020-10-12 | B6 | Futures | 1.3218 | 1.3269 | 1.3191 | 1.3249 | 77232.0 |
| 2020-10-12 | BR | Futures | 0.14187 | 0.14218 | 0.14187 | 0.14203 | 3.0 |
| 2020-10-12 | BTC | Futures | 15263.7 | 15720.6 | 15156.3 | 15626.5 | 6338.0 |
| 2020-10-12 | BZ | Futures | 26.41 | 26.49 | 25.58 | 25.81 | 24754.0 |
| 2020-10-12 | C | Futures | 1506.0 | 1506.0 | 1484.0 | 1487.0 | 4796.0 |
| 2020-10-12 | CB | Futures | 156.016 | 156.016 | 155.991 | 155.991 | 4.0 |
| 2020-10-12 | CC | Futures | 1597.0 | 1611.0 | 1587.0 | 1605.0 | 12560.0 |
| 2020-10-12 | CNH | Futures | 6.6227 | 6.6435 | 6.5992 | 6.6342 | 1199.0 |
| 2020-10-12 | CSC | Futures | 3.48 | 3.518 | 3.47 | 3.518 | 36.0 |
| 2020-10-12 | CT | Futures | 67.22 | 68.65 | 67.22 | 67.57 | 21406.0 |
| 2020-10-12 | DC | Futures | 28.67 | 28.91 | 28.4 | 28.91 | 285.0 |
| 2020-10-12 | DX | Futures | 89.941 | 90.095 | 89.859 | 89.935 | 17459.0 |
| 2020-10-12 | E1 | Futures | 1.24579 | 1.24828 | 1.24318 | 1.24737 | 15894.0 |
| 2020-10-12 | E6 | Futures | 1.2675 | 1.26852 | 1.26423 | 1.2667 | 114451.0 |
| 2020-10-12 | E7 | Futures | 1.2608 | 1.2621 | 1.2579 | 1.2602 | 5702.0 |
| 2020-10-12 | EBM | Futures | 240.8 | 243.21 | 240.8 | 242.01 | 19343.0 |
| 2020-10-12 | ED | Futures | 96.489 | 96.4939 | 96.489 | 96.4939 | 11726.0 |
| 2020-10-12 | ER | Futures | 98.45 | 98.45 | 98.445 | 98.445 | 20194.0 |
| 2020-10-12 | ESG | Futures | 324.14 | 329.37 | 324.14 | 328.44 | 796.0 |
| 2020-10-12 | EW | Futures | 2131.3 | 2149.5 | 2128.4 | 2143.7 | 10864.0 |
| 2020-10-12 | FBON | Futures | 148.92 | 149.36 | 148.92 | 149.33 | 442.0 |
| 2020-10-12 | FBTP | Futures | 136.77 | 137.41 | 136.75 | 137.39 | 92748.0 |
| 2020-10-12 | FBTS | Futures | 109.653 | 109.74 | 109.653 | 109.72 | 57419.0 |
| 2020-10-12 | FCE | Futures | 4795.7 | 4828.1 | 4775.4 | 4809.7 | 15583.0 |
| 2020-10-12 | FDAX | Futures | 13900.2 | 14034.0 | 13879.4 | 13994.0 | 60128.0 |
| 2020-10-12 | FDIV | Futures | 150.14 | 150.76 | 150.14 | 150.76 | 30.0 |
| 2020-10-12 | FDXM | Futures | 13830.6 | 13963.2 | 13810.5 | 13923.5 | 39506.0 |
| 2020-10-12 | FESX | Futures | 3016.6 | 3051.8 | 3012.0 | 3045.3 | 635106.0 |
| 2020-10-12 | FEU3 | Futures | 99.188 | 99.188 | 99.188 | 99.188 | 30.0 |
| 2020-10-12 | FGBL | Futures | 169.94 | 170.06 | 169.8 | 170.0 | 307189.0 |
| 2020-10-12 | FGBM | Futures | 135.27 | 135.32 | 135.25 | 135.3 | 187022.0 |
| 2020-10-12 | FGBS | Futures | 112.785 | 112.8 | 112.785 | 112.795 | 179719.0 |
| 2020-10-12 | FGBX | Futures | 233.06 | 233.66 | 232.39 | 233.24 | 37516.0 |
| 2020-10-12 | FMWO | Futures | 8629.7 | 8749.4 | 8627.4 | 8710.3 | 1365.0 |
| 2020-10-12 | FOAT | Futures | 158.19 | 158.35 | 158.03 | 158.3 | 73562.0 |
| 2020-10-12 | FTDX | Futures | 3259.7 | 3322.0 | 3259.7 | 3302.9 | 41.0 |
| 2020-10-12 | FTI | Futures | 528.45 | 531.0 | 526.18 | 529.58 | 2315.0 |
| 2020-10-12 | FTUK | Futures | 5714.0 | 5744.6 | 5701.1 | 5713.1 | 61329.0 |
| 2020-10-12 | FVSA | Futures | 176.07 | 176.43 | 169.99 | 171.06 | 9624.0 |
| 2020-10-12 | FXXP | Futures | 343.5 | 345.8 | 342.5 | 344.9 | 35504.0 |
> showing 50 of 119 rows — these rows as CSV