PREVIEW / futures_daily / 2020-08-12
file: by_date/futures_daily/2020/2020-08-12.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-12 | ES | Futures | 3758.9 | 3807.3 | 3743.98 | 3793.23 | 1408718.0 |
| 2020-08-12 | NQ | Futures | 12684.05 | 12982.62 | 12626.02 | 12913.27 | 434240.0 |
| 2020-08-12 | YM | Futures | 29685.8 | 29967.7 | 29591.5 | 29863.8 | 162035.0 |
| 2020-08-12 | CL | Futures | 30.37 | 31.3 | 30.3 | 31.14 | 397831.0 |
| 2020-08-12 | GC | Futures | 2269.4 | 2316.0 | 2213.5 | 2301.8 | 459842.0 |
| 2020-08-12 | ZN | Futures | 138.109614 | 138.248978 | 137.753462 | 137.93928 | 1494585.0 |
| 2020-08-12 | A6 | Futures | 0.73479 | 0.73829 | 0.73129 | 0.73685 | 93254.0 |
| 2020-08-12 | AD | Futures | 0.76317 | 0.76733 | 0.76053 | 0.76591 | 60989.0 |
| 2020-08-12 | ALI | Futures | 2183.59 | 2194.21 | 2182.07 | 2184.2 | 467.0 |
| 2020-08-12 | B | Futures | 28.76 | 29.42 | 28.68 | 29.29 | 166478.0 |
| 2020-08-12 | B6 | Futures | 1.326 | 1.3271 | 1.3208 | 1.323 | 88540.0 |
| 2020-08-12 | BR | Futures | 0.14651 | 0.1473 | 0.14417 | 0.14504 | 8298.0 |
| 2020-08-12 | BTC | Futures | 15513.9 | 16068.0 | 15349.7 | 15958.5 | 6069.0 |
| 2020-08-12 | BZ | Futures | 28.06 | 28.72 | 28.02 | 28.6 | 16995.0 |
| 2020-08-12 | C | Futures | 1523.0 | 1543.0 | 1522.0 | 1536.0 | 2771.0 |
| 2020-08-12 | CB | Futures | 174.498 | 174.498 | 171.984 | 173.321 | 32.0 |
| 2020-08-12 | CC | Futures | 1606.0 | 1629.0 | 1606.0 | 1619.0 | 18695.0 |
| 2020-08-12 | CNH | Futures | 6.8543 | 6.8671 | 6.8442 | 6.8451 | 1054.0 |
| 2020-08-12 | CSC | Futures | 3.391 | 3.476 | 3.385 | 3.432 | 177.0 |
| 2020-08-12 | CT | Futures | 62.68 | 62.68 | 62.54 | 62.54 | 2.0 |
| 2020-08-12 | DC | Futures | 27.8 | 28.23 | 27.36 | 27.78 | 565.0 |
| 2020-08-12 | DX | Futures | 90.464 | 90.696 | 90.035 | 90.226 | 20587.0 |
| 2020-08-12 | E1 | Futures | 1.23977 | 1.24965 | 1.2358 | 1.24625 | 26536.0 |
| 2020-08-12 | E6 | Futures | 1.26058 | 1.26895 | 1.25747 | 1.26536 | 200610.0 |
| 2020-08-12 | E7 | Futures | 1.2544 | 1.2626 | 1.2512 | 1.2591 | 6484.0 |
| 2020-08-12 | EBM | Futures | 212.27 | 213.17 | 211.97 | 212.57 | 9665.0 |
| 2020-08-12 | ED | Futures | 96.433 | 96.4378 | 96.4233 | 96.4282 | 167457.0 |
| 2020-08-12 | ER | Futures | 98.391 | 98.396 | 98.386 | 98.396 | 40805.0 |
| 2020-08-12 | ESG | Futures | 306.67 | 307.38 | 306.27 | 307.06 | 15.0 |
| 2020-08-12 | EW | Futures | 2074.5 | 2091.8 | 2068.8 | 2079.8 | 11609.0 |
| 2020-08-12 | FBON | Futures | 147.09 | 147.36 | 146.67 | 146.95 | 192.0 |
| 2020-08-12 | FBTP | Futures | 133.5 | 133.61 | 133.09 | 133.4 | 65773.0 |
| 2020-08-12 | FBTS | Futures | 108.909 | 108.958 | 108.841 | 108.909 | 57999.0 |
| 2020-08-12 | FCE | Futures | 4858.1 | 4951.6 | 4858.1 | 4933.1 | 391.0 |
| 2020-08-12 | FDAX | Futures | 13684.1 | 13915.1 | 13619.8 | 13876.3 | 66400.0 |
| 2020-08-12 | FDIV | Futures | 150.66 | 150.66 | 150.62 | 150.62 | 80.0 |
| 2020-08-12 | FDXM | Futures | 13618.3 | 13863.9 | 13572.8 | 13826.3 | 35910.0 |
| 2020-08-12 | FESX | Futures | 3055.5 | 3115.5 | 3042.6 | 3104.4 | 772961.0 |
| 2020-08-12 | FEU3 | Futures | 99.139 | 99.144 | 99.139 | 99.144 | 1.0 |
| 2020-08-12 | FGBL | Futures | 168.98 | 169.0 | 168.09 | 168.39 | 643775.0 |
| 2020-08-12 | FGBM | Futures | 134.95 | 134.95 | 134.61 | 134.72 | 459227.0 |
| 2020-08-12 | FGBS | Futures | 112.769 | 112.769 | 112.694 | 112.709 | 368088.0 |
| 2020-08-12 | FGBX | Futures | 229.12 | 229.14 | 225.94 | 226.93 | 54692.0 |
| 2020-08-12 | FMWO | Futures | 8258.9 | 8411.8 | 8258.9 | 8401.1 | 4807.0 |
| 2020-08-12 | FOAT | Futures | 156.61 | 156.7 | 156.03 | 156.32 | 149504.0 |
| 2020-08-12 | FTDX | Futures | 3143.1 | 3167.6 | 3120.1 | 3166.1 | 85.0 |
| 2020-08-12 | FTI | Futures | 525.02 | 535.18 | 525.02 | 534.57 | 114.0 |
| 2020-08-12 | FTUK | Futures | 5785.7 | 5923.6 | 5765.8 | 5915.1 | 110584.0 |
| 2020-08-12 | FVSA | Futures | 210.39 | 210.39 | 201.68 | 204.17 | 13281.0 |
| 2020-08-12 | FXXP | Futures | 340.3 | 345.9 | 340.2 | 345.4 | 35406.0 |
> showing 50 of 121 rows — these rows as CSV