PREVIEW / futures_daily / 2020-10-16
file: by_date/futures_daily/2020/2020-10-16.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-16 | ES | Futures | 3908.03 | 3941.73 | 3888.65 | 3889.77 | 1398947.0 |
| 2020-10-16 | NQ | Futures | 13766.32 | 13917.98 | 13651.7 | 13658.65 | 527026.0 |
| 2020-10-16 | YM | Futures | 30593.2 | 30932.3 | 30501.6 | 30583.5 | 174908.0 |
| 2020-10-16 | CL | Futures | 29.34 | 29.44 | 28.76 | 29.31 | 256540.0 |
| 2020-10-16 | GC | Futures | 2258.9 | 2266.0 | 2245.2 | 2251.5 | 146910.0 |
| 2020-10-16 | ZN | Futures | 137.954765 | 138.094239 | 137.830789 | 137.923771 | 928432.0 |
| 2020-10-16 | A6 | Futures | 0.72825 | 0.72866 | 0.72599 | 0.72753 | 77471.0 |
| 2020-10-16 | AD | Futures | 0.76652 | 0.76916 | 0.76561 | 0.7688 | 66399.0 |
| 2020-10-16 | ALI | Futures | 2226.48 | 2241.59 | 2226.19 | 2233.3 | 185.0 |
| 2020-10-16 | B | Futures | 27.2 | 27.26 | 26.67 | 27.09 | 197161.0 |
| 2020-10-16 | B6 | Futures | 1.3089 | 1.3146 | 1.3036 | 1.3116 | 131435.0 |
| 2020-10-16 | BR | Futures | 0.14014 | 0.14045 | 0.13896 | 0.13916 | 109.0 |
| 2020-10-16 | BTC | Futures | 15599.7 | 15599.7 | 15082.4 | 15263.7 | 5373.0 |
| 2020-10-16 | BZ | Futures | 26.63 | 26.73 | 26.15 | 26.56 | 24159.0 |
| 2020-10-16 | C | Futures | 1450.0 | 1463.0 | 1444.0 | 1456.0 | 3613.0 |
| 2020-10-16 | CC | Futures | 1535.0 | 1557.0 | 1531.0 | 1550.0 | 14889.0 |
| 2020-10-16 | CNH | Futures | 6.602 | 6.6039 | 6.5726 | 6.5803 | 652.0 |
| 2020-10-16 | CSC | Futures | 3.679 | 3.679 | 3.635 | 3.652 | 43.0 |
| 2020-10-16 | CT | Futures | 68.2 | 69.22 | 68.19 | 69.1 | 19953.0 |
| 2020-10-16 | DC | Futures | 30.12 | 30.26 | 29.61 | 29.83 | 294.0 |
| 2020-10-16 | DX | Futures | 90.622 | 90.689 | 90.337 | 90.49 | 19361.0 |
| 2020-10-16 | E1 | Futures | 1.24035 | 1.24307 | 1.23775 | 1.23922 | 17212.0 |
| 2020-10-16 | E6 | Futures | 1.25572 | 1.25979 | 1.25411 | 1.25679 | 149396.0 |
| 2020-10-16 | E7 | Futures | 1.2495 | 1.2533 | 1.2477 | 1.2504 | 4960.0 |
| 2020-10-16 | EBM | Futures | 250.15 | 252.56 | 248.64 | 251.96 | 40940.0 |
| 2020-10-16 | ED | Futures | 96.4939 | 96.4987 | 96.4939 | 96.4939 | 52585.0 |
| 2020-10-16 | ER | Futures | 98.445 | 98.45 | 98.445 | 98.445 | 22053.0 |
| 2020-10-16 | ESG | Futures | 324.55 | 325.38 | 323.23 | 323.23 | 145.0 |
| 2020-10-16 | EW | Futures | 2139.6 | 2150.8 | 2125.1 | 2131.7 | 9285.0 |
| 2020-10-16 | FBON | Futures | 149.46 | 149.8 | 149.33 | 149.69 | 207.0 |
| 2020-10-16 | FBTP | Futures | 137.21 | 137.84 | 137.03 | 137.62 | 103896.0 |
| 2020-10-16 | FBTS | Futures | 109.595 | 109.788 | 109.595 | 109.74 | 96737.0 |
| 2020-10-16 | FCE | Futures | 4725.1 | 4790.4 | 4704.3 | 4768.6 | 88280.0 |
| 2020-10-16 | FDAX | Futures | 13588.9 | 13800.5 | 13529.2 | 13760.5 | 88168.0 |
| 2020-10-16 | FDIV | Futures | 146.45 | 148.06 | 146.45 | 147.96 | 220.0 |
| 2020-10-16 | FDXM | Futures | 13513.5 | 13730.9 | 13461.5 | 13691.1 | 54704.0 |
| 2020-10-16 | FESX | Futures | 2963.0 | 3006.5 | 2950.1 | 2996.3 | 974403.0 |
| 2020-10-16 | FGBL | Futures | 170.99 | 171.44 | 170.94 | 171.23 | 480346.0 |
| 2020-10-16 | FGBM | Futures | 135.59 | 135.75 | 135.59 | 135.69 | 294713.0 |
| 2020-10-16 | FGBS | Futures | 112.88 | 112.92 | 112.88 | 112.9 | 499809.0 |
| 2020-10-16 | FGBX | Futures | 237.19 | 238.98 | 237.13 | 238.04 | 53517.0 |
| 2020-10-16 | FMWO | Futures | 8606.0 | 8651.0 | 8565.8 | 8615.5 | 1542.0 |
| 2020-10-16 | FOAT | Futures | 158.96 | 159.32 | 158.95 | 159.21 | 106936.0 |
| 2020-10-16 | FTDX | Futures | 3231.4 | 3270.5 | 3228.8 | 3253.0 | 23.0 |
| 2020-10-16 | FTI | Futures | 521.16 | 528.22 | 518.66 | 525.64 | 30725.0 |
| 2020-10-16 | FTUK | Futures | 5587.8 | 5648.1 | 5573.0 | 5641.8 | 113402.0 |
| 2020-10-16 | FVSA | Futures | 178.57 | 180.01 | 172.49 | 174.28 | 9355.0 |
| 2020-10-16 | FXXP | Futures | 337.7 | 340.8 | 335.8 | 339.8 | 47701.0 |
| 2020-10-16 | G | Futures | 127.18 | 127.65 | 127.18 | 127.31 | 189979.0 |
| 2020-10-16 | GF | Futures | 264.08 | 264.08 | 259.916 | 261.514 | 5332.0 |
> showing 50 of 118 rows — these rows as CSV