PREVIEW / futures_daily / 2020-09-29
file: by_date/futures_daily/2020/2020-09-29.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-09-29 | ES | Futures | 3762.26 | 3778.27 | 3726.02 | 3745.4 | 1326597.0 |
| 2020-09-29 | NQ | Futures | 13183.99 | 13254.32 | 13069.96 | 13125.81 | 444170.0 |
| 2020-09-29 | YM | Futures | 29603.8 | 29734.0 | 29297.0 | 29506.9 | 175150.0 |
| 2020-09-29 | CL | Futures | 29.14 | 29.22 | 27.58 | 28.21 | 379599.0 |
| 2020-09-29 | GC | Futures | 2227.9 | 2249.6 | 2221.2 | 2247.7 | 217795.0 |
| 2020-09-29 | ZN | Futures | 138.55915 | 138.66763 | 138.481665 | 138.636636 | 788134.0 |
| 2020-09-29 | A6 | Futures | 0.72599 | 0.73297 | 0.72588 | 0.73194 | 83335.0 |
| 2020-09-29 | AD | Futures | 0.75786 | 0.75918 | 0.75538 | 0.75725 | 62057.0 |
| 2020-09-29 | ALI | Futures | 2152.24 | 2153.43 | 2147.48 | 2147.48 | 19.0 |
| 2020-09-29 | B | Futures | 27.08 | 27.11 | 25.77 | 26.22 | 331441.0 |
| 2020-09-29 | B6 | Futures | 1.3018 | 1.3089 | 1.3007 | 1.3046 | 101452.0 |
| 2020-09-29 | BR | Futures | 0.13916 | 0.13959 | 0.13872 | 0.1392 | 103.0 |
| 2020-09-29 | BTC | Futures | 14739.7 | 14766.6 | 14350.1 | 14531.5 | 4764.0 |
| 2020-09-29 | BZ | Futures | 26.51 | 26.58 | 25.28 | 25.71 | 40045.0 |
| 2020-09-29 | C | Futures | 1645.0 | 1646.0 | 1608.0 | 1629.0 | 5832.0 |
| 2020-09-29 | CB | Futures | 166.434 | 167.196 | 166.434 | 166.688 | 12.0 |
| 2020-09-29 | CC | Futures | 1695.0 | 1707.0 | 1669.0 | 1699.0 | 14129.0 |
| 2020-09-29 | CNH | Futures | 6.7066 | 6.7142 | 6.7031 | 6.7061 | 501.0 |
| 2020-09-29 | CSC | Futures | 3.373 | 3.386 | 3.361 | 3.383 | 124.0 |
| 2020-09-29 | CT | Futures | 64.9 | 64.91 | 63.94 | 64.52 | 16780.0 |
| 2020-09-29 | DC | Futures | 27.71 | 27.86 | 27.57 | 27.84 | 126.0 |
| 2020-09-29 | DX | Futures | 90.999 | 91.139 | 90.665 | 90.73 | 17392.0 |
| 2020-09-29 | E1 | Futures | 1.22654 | 1.23458 | 1.22654 | 1.23412 | 26133.0 |
| 2020-09-29 | E6 | Futures | 1.25122 | 1.26027 | 1.25122 | 1.25931 | 176883.0 |
| 2020-09-29 | E7 | Futures | 1.2452 | 1.2537 | 1.2451 | 1.2529 | 6291.0 |
| 2020-09-29 | EBM | Futures | 232.06 | 233.57 | 231.46 | 231.76 | 20444.0 |
| 2020-09-29 | ED | Futures | 96.4793 | 96.489 | 96.4745 | 96.4842 | 171359.0 |
| 2020-09-29 | ER | Futures | 98.435 | 98.44 | 98.431 | 98.435 | 55839.0 |
| 2020-09-29 | ESG | Futures | 310.39 | 310.58 | 308.37 | 309.19 | 10.0 |
| 2020-09-29 | EW | Futures | 1988.4 | 1992.1 | 1957.7 | 1970.8 | 11823.0 |
| 2020-09-29 | FBON | Futures | 148.08 | 148.49 | 148.08 | 148.42 | 182.0 |
| 2020-09-29 | FBTP | Futures | 135.15 | 135.68 | 135.15 | 135.67 | 124354.0 |
| 2020-09-29 | FBTS | Futures | 109.325 | 109.421 | 109.325 | 109.411 | 67621.0 |
| 2020-09-29 | FCE | Futures | 4702.1 | 4705.0 | 4659.0 | 4684.2 | 57697.0 |
| 2020-09-29 | FDAX | Futures | 13735.5 | 13786.1 | 13557.4 | 13643.8 | 63873.0 |
| 2020-09-29 | FDIV | Futures | 147.01 | 147.82 | 146.54 | 147.54 | 351.0 |
| 2020-09-29 | FDXM | Futures | 13664.1 | 13715.0 | 13491.2 | 13575.0 | 43414.0 |
| 2020-09-29 | FESX | Futures | 2985.2 | 2988.9 | 2946.4 | 2961.2 | 632237.0 |
| 2020-09-29 | FGBL | Futures | 169.83 | 170.09 | 169.78 | 170.06 | 501636.0 |
| 2020-09-29 | FGBM | Futures | 135.13 | 135.24 | 135.13 | 135.21 | 276996.0 |
| 2020-09-29 | FGBS | Futures | 112.775 | 112.79 | 112.759 | 112.775 | 310551.0 |
| 2020-09-29 | FGBX | Futures | 232.37 | 233.7 | 232.24 | 233.62 | 48018.0 |
| 2020-09-29 | FMWO | Futures | 8340.7 | 8340.7 | 8276.8 | 8304.0 | 1349.0 |
| 2020-09-29 | FOAT | Futures | 157.92 | 158.16 | 157.88 | 158.15 | 136267.0 |
| 2020-09-29 | FTDX | Futures | 3145.0 | 3164.0 | 3145.0 | 3159.4 | 58.0 |
| 2020-09-29 | FTI | Futures | 515.29 | 516.18 | 510.07 | 511.44 | 19594.0 |
| 2020-09-29 | FTUK | Futures | 5673.9 | 5673.9 | 5572.5 | 5611.7 | 97090.0 |
| 2020-09-29 | FVSA | Futures | 207.27 | 210.99 | 200.96 | 204.3 | 9825.0 |
| 2020-09-29 | FXXP | Futures | 336.2 | 336.2 | 332.7 | 333.7 | 32441.0 |
| 2020-09-29 | G | Futures | 127.08 | 127.3 | 127.01 | 127.27 | 253771.0 |
> showing 50 of 119 rows — these rows as CSV