PREVIEW / futures_daily / 2021-06-25
file: by_date/futures_daily/2021/2021-06-25.parquet size: 10 KB rows: 123
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 |
|---|---|---|---|---|---|---|---|
| 2021-06-25 | ES | Futures | 4790.8 | 4807.38 | 4781.25 | 4801.2 | 906160.0 |
| 2021-06-25 | NQ | Futures | 16573.58 | 16606.46 | 16513.01 | 16542.72 | 379758.0 |
| 2021-06-25 | YM | Futures | 37076.1 | 37285.4 | 37011.1 | 37227.9 | 108975.0 |
| 2021-06-25 | CL | Futures | 52.6 | 53.21 | 52.26 | 53.12 | 364721.0 |
| 2021-06-25 | GC | Futures | 2076.9 | 2094.8 | 2074.5 | 2079.4 | 161203.0 |
| 2021-06-25 | ZN | Futures | 133.709358 | 133.867501 | 133.361445 | 133.456331 | 1252104.0 |
| 2021-06-25 | A6 | Futures | 0.77803 | 0.78141 | 0.77762 | 0.77818 | 62120.0 |
| 2021-06-25 | AD | Futures | 0.8228 | 0.82614 | 0.82224 | 0.82376 | 43406.0 |
| 2021-06-25 | ALI | Futures | 2853.95 | 2885.8 | 2853.95 | 2876.04 | 103.0 |
| 2021-06-25 | B | Futures | 49.41 | 49.79 | 48.97 | 49.77 | 246618.0 |
| 2021-06-25 | B6 | Futures | 1.4137 | 1.4152 | 1.4087 | 1.4091 | 64988.0 |
| 2021-06-25 | BFX | Futures | 4255.2 | 4270.0 | 4255.2 | 4270.0 | 2.0 |
| 2021-06-25 | BR | Futures | 0.16199 | 0.16247 | 0.15999 | 0.16047 | 1005.0 |
| 2021-06-25 | BTC | Futures | 49754.5 | 50766.0 | 44846.7 | 45872.5 | 6633.0 |
| 2021-06-25 | BZ | Futures | 48.24 | 48.66 | 47.86 | 48.65 | 26340.0 |
| 2021-06-25 | C | Futures | 1439.0 | 1454.0 | 1434.0 | 1446.0 | 6215.0 |
| 2021-06-25 | CB | Futures | 140.405 | 141.608 | 140.405 | 141.408 | 30.0 |
| 2021-06-25 | CC | Futures | 1539.0 | 1571.0 | 1533.0 | 1561.0 | 17937.0 |
| 2021-06-25 | CNH | Futures | 6.2706 | 6.2733 | 6.2547 | 6.2647 | 191.0 |
| 2021-06-25 | CSC | Futures | 2.489 | 2.489 | 2.48 | 2.486 | 45.0 |
| 2021-06-25 | CT | Futures | 81.08 | 81.63 | 81.08 | 81.42 | 12.0 |
| 2021-06-25 | DC | Futures | 22.6 | 22.6 | 22.5 | 22.56 | 94.0 |
| 2021-06-25 | DX | Futures | 88.762 | 88.795 | 88.462 | 88.775 | 16636.0 |
| 2021-06-25 | E1 | Futures | 1.22572 | 1.23077 | 1.22538 | 1.22583 | 17274.0 |
| 2021-06-25 | E6 | Futures | 1.27116 | 1.27584 | 1.27057 | 1.27105 | 130205.0 |
| 2021-06-25 | E7 | Futures | 1.2647 | 1.2694 | 1.2642 | 1.2647 | 3719.0 |
| 2021-06-25 | EBM | Futures | 302.68 | 303.05 | 295.32 | 296.43 | 19574.0 |
| 2021-06-25 | ED | Futures | 96.5248 | 96.5297 | 96.52 | 96.5248 | 75878.0 |
| 2021-06-25 | ER | Futures | 98.455 | 98.46 | 98.455 | 98.46 | 32477.0 |
| 2021-06-25 | ESG | Futures | 395.0 | 396.52 | 395.0 | 395.98 | 528.0 |
| 2021-06-25 | EW | Futures | 2906.9 | 2929.5 | 2894.1 | 2924.3 | 12135.0 |
| 2021-06-25 | FBON | Futures | 147.7 | 147.84 | 147.09 | 147.17 | 123.0 |
| 2021-06-25 | FBTP | Futures | 137.85 | 137.94 | 137.09 | 137.21 | 120534.0 |
| 2021-06-25 | FBTS | Futures | 110.068 | 110.088 | 110.01 | 110.049 | 72354.0 |
| 2021-06-25 | FCE | Futures | 6617.1 | 6621.1 | 6575.8 | 6593.7 | 40022.0 |
| 2021-06-25 | FDAX | Futures | 16704.8 | 16732.7 | 16619.1 | 16701.6 | 39571.0 |
| 2021-06-25 | FDIV | Futures | 188.82 | 189.02 | 188.82 | 189.02 | 10.0 |
| 2021-06-25 | FDXM | Futures | 16607.0 | 16648.6 | 16536.7 | 16618.7 | 26267.0 |
| 2021-06-25 | FDXS | Futures | 16514.2 | 16541.8 | 16431.6 | 16513.2 | 2458.0 |
| 2021-06-25 | FESX | Futures | 3901.0 | 3906.7 | 3879.2 | 3894.9 | 450510.0 |
| 2021-06-25 | FGBL | Futures | 166.85 | 166.91 | 166.3 | 166.39 | 551487.0 |
| 2021-06-25 | FGBM | Futures | 134.49 | 134.51 | 134.35 | 134.37 | 309142.0 |
| 2021-06-25 | FGBS | Futures | 112.544 | 112.549 | 112.534 | 112.539 | 154015.0 |
| 2021-06-25 | FGBX | Futures | 216.55 | 216.72 | 214.6 | 214.75 | 53581.0 |
| 2021-06-25 | FMWO | Futures | 10655.3 | 10670.5 | 10629.4 | 10658.8 | 3279.0 |
| 2021-06-25 | FOAT | Futures | 154.74 | 154.78 | 154.07 | 154.17 | 130919.0 |
| 2021-06-25 | FTDX | Futures | 3629.6 | 3664.0 | 3629.1 | 3648.1 | 12.0 |
| 2021-06-25 | FTI | Futures | 698.95 | 699.47 | 695.86 | 697.69 | 12993.0 |
| 2021-06-25 | FTUK | Futures | 6945.9 | 6973.5 | 6933.6 | 6959.2 | 54518.0 |
| 2021-06-25 | FVSA | Futures | 82.52 | 84.12 | 81.6 | 81.83 | 18417.0 |
> showing 50 of 123 rows — these rows as CSV