PREVIEW / futures_daily / 2020-10-09
file: by_date/futures_daily/2020/2020-10-09.parquet size: 10 KB rows: 118
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-09 | ES | Futures | 3872.92 | 3909.71 | 3870.67 | 3902.13 | 1185272.0 |
| 2020-10-09 | NQ | Futures | 13385.43 | 13590.35 | 13374.43 | 13573.85 | 408445.0 |
| 2020-10-09 | YM | Futures | 30551.2 | 30757.9 | 30493.0 | 30701.9 | 169790.0 |
| 2020-10-09 | CL | Futures | 29.66 | 29.77 | 28.99 | 29.15 | 331703.0 |
| 2020-10-09 | GC | Futures | 2242.0 | 2287.4 | 2241.6 | 2274.9 | 229847.0 |
| 2020-10-09 | ZN | Futures | 137.660321 | 137.846286 | 137.536345 | 137.691315 | 1004425.0 |
| 2020-10-09 | A6 | Futures | 0.73584 | 0.74375 | 0.73584 | 0.74262 | 71746.0 |
| 2020-10-09 | AD | Futures | 0.76804 | 0.77306 | 0.76799 | 0.77174 | 79478.0 |
| 2020-10-09 | ALI | Futures | 2190.86 | 2233.65 | 2190.86 | 2229.78 | 137.0 |
| 2020-10-09 | B | Futures | 27.36 | 27.49 | 26.89 | 27.04 | 254615.0 |
| 2020-10-09 | B6 | Futures | 1.3121 | 1.3237 | 1.3105 | 1.3224 | 98097.0 |
| 2020-10-09 | BR | Futures | 0.14081 | 0.14218 | 0.14081 | 0.14191 | 76.0 |
| 2020-10-09 | BTC | Futures | 14712.9 | 15055.5 | 14659.1 | 14927.8 | 3469.0 |
| 2020-10-09 | BZ | Futures | 26.86 | 26.95 | 26.36 | 26.51 | 26041.0 |
| 2020-10-09 | C | Futures | 1521.0 | 1523.0 | 1489.0 | 1501.0 | 4992.0 |
| 2020-10-09 | CB | Futures | 152.128 | 156.143 | 152.128 | 156.143 | 13.0 |
| 2020-10-09 | CC | Futures | 1623.0 | 1624.0 | 1582.0 | 1597.0 | 15058.0 |
| 2020-10-09 | CNH | Futures | 6.6265 | 6.6283 | 6.5684 | 6.5767 | 1734.0 |
| 2020-10-09 | CSC | Futures | 3.463 | 3.487 | 3.459 | 3.481 | 49.0 |
| 2020-10-09 | CT | Futures | 66.95 | 67.87 | 66.75 | 66.85 | 20722.0 |
| 2020-10-09 | DC | Futures | 28.37 | 28.59 | 28.17 | 28.56 | 136.0 |
| 2020-10-09 | DX | Futures | 90.39 | 90.434 | 89.835 | 89.897 | 19919.0 |
| 2020-10-09 | E1 | Futures | 1.23684 | 1.24737 | 1.2365 | 1.24658 | 17801.0 |
| 2020-10-09 | E6 | Futures | 1.2614 | 1.26911 | 1.26118 | 1.26836 | 157272.0 |
| 2020-10-09 | E7 | Futures | 1.2551 | 1.2626 | 1.2548 | 1.2619 | 5128.0 |
| 2020-10-09 | EBM | Futures | 240.8 | 242.01 | 238.69 | 241.41 | 26798.0 |
| 2020-10-09 | ED | Futures | 96.4939 | 96.4987 | 96.489 | 96.4939 | 57343.0 |
| 2020-10-09 | ER | Futures | 98.445 | 98.45 | 98.445 | 98.45 | 29863.0 |
| 2020-10-09 | ESG | Futures | 318.24 | 322.25 | 318.24 | 322.12 | 477.0 |
| 2020-10-09 | EW | Futures | 2131.5 | 2145.2 | 2122.2 | 2130.1 | 12382.0 |
| 2020-10-09 | FBON | Futures | 148.78 | 149.3 | 148.73 | 149.09 | 988.0 |
| 2020-10-09 | FBTP | Futures | 136.51 | 137.0 | 136.46 | 136.93 | 114098.0 |
| 2020-10-09 | FBTS | Futures | 109.624 | 109.691 | 109.605 | 109.672 | 58180.0 |
| 2020-10-09 | FCE | Futures | 4778.7 | 4810.3 | 4768.1 | 4795.7 | 43849.0 |
| 2020-10-09 | FDAX | Futures | 13953.5 | 13960.4 | 13852.8 | 13884.8 | 56821.0 |
| 2020-10-09 | FDIV | Futures | 150.33 | 150.33 | 149.86 | 149.86 | 150.0 |
| 2020-10-09 | FDXM | Futures | 13874.1 | 13906.0 | 13781.8 | 13814.7 | 38849.0 |
| 2020-10-09 | FESX | Futures | 3017.6 | 3027.7 | 3000.0 | 3016.6 | 665861.0 |
| 2020-10-09 | FGBL | Futures | 169.72 | 170.05 | 169.69 | 169.88 | 494210.0 |
| 2020-10-09 | FGBM | Futures | 135.18 | 135.31 | 135.17 | 135.26 | 312832.0 |
| 2020-10-09 | FGBS | Futures | 112.769 | 112.795 | 112.764 | 112.785 | 422118.0 |
| 2020-10-09 | FGBX | Futures | 232.37 | 233.93 | 231.93 | 232.85 | 58695.0 |
| 2020-10-09 | FMWO | Futures | 8569.3 | 8620.2 | 8561.0 | 8595.4 | 1728.0 |
| 2020-10-09 | FOAT | Futures | 158.05 | 158.36 | 158.01 | 158.17 | 127712.0 |
| 2020-10-09 | FTDX | Futures | 3232.4 | 3261.8 | 3232.4 | 3257.7 | 9.0 |
| 2020-10-09 | FTI | Futures | 523.21 | 530.2 | 522.23 | 528.45 | 23120.0 |
| 2020-10-09 | FTUK | Futures | 5720.7 | 5747.0 | 5698.2 | 5725.0 | 63590.0 |
| 2020-10-09 | FVSA | Futures | 182.38 | 183.5 | 174.21 | 176.07 | 20313.0 |
| 2020-10-09 | FXXP | Futures | 340.6 | 343.2 | 340.5 | 342.1 | 42822.0 |
| 2020-10-09 | G | Futures | 126.24 | 126.48 | 126.08 | 126.28 | 155519.0 |
> showing 50 of 118 rows — these rows as CSV