PREVIEW / futures_daily / 2021-06-22
file: by_date/futures_daily/2021/2021-06-22.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-22 | ES | Futures | 4742.75 | 4772.25 | 4727.57 | 4761.86 | 1063749.0 |
| 2021-06-22 | NQ | Futures | 16309.39 | 16473.79 | 16228.34 | 16449.56 | 420968.0 |
| 2021-06-22 | YM | Futures | 36663.0 | 36786.6 | 36462.4 | 36687.9 | 132462.0 |
| 2021-06-22 | CL | Futures | 52.39 | 52.7 | 51.99 | 52.26 | 498555.0 |
| 2021-06-22 | GC | Futures | 2085.7 | 2093.8 | 2071.7 | 2078.9 | 172745.0 |
| 2021-06-22 | ZN | Futures | 133.772615 | 134.041457 | 133.614473 | 133.962386 | 1384211.0 |
| 2021-06-22 | A6 | Futures | 0.77351 | 0.77598 | 0.7688 | 0.77495 | 89036.0 |
| 2021-06-22 | AD | Futures | 0.82016 | 0.82412 | 0.81743 | 0.8229 | 68573.0 |
| 2021-06-22 | ALI | Futures | 2784.22 | 2805.46 | 2770.45 | 2804.02 | 397.0 |
| 2021-06-22 | B | Futures | 48.96 | 49.24 | 48.59 | 48.91 | 294724.0 |
| 2021-06-22 | B6 | Futures | 1.4151 | 1.4181 | 1.4076 | 1.4157 | 86918.0 |
| 2021-06-22 | BFX | Futures | 4247.0 | 4247.0 | 4245.5 | 4245.5 | 2.0 |
| 2021-06-22 | BR | Futures | 0.15803 | 0.16007 | 0.15739 | 0.15947 | 63.0 |
| 2021-06-22 | BTC | Futures | 45928.8 | 48261.5 | 41727.1 | 47058.9 | 14889.0 |
| 2021-06-22 | BZ | Futures | 47.76 | 48.06 | 47.46 | 47.76 | 39381.0 |
| 2021-06-22 | C | Futures | 1449.0 | 1461.0 | 1448.0 | 1458.0 | 1445.0 |
| 2021-06-22 | CB | Futures | 145.239 | 145.239 | 143.012 | 144.416 | 99.0 |
| 2021-06-22 | CC | Futures | 1558.0 | 1575.0 | 1556.0 | 1571.0 | 12559.0 |
| 2021-06-22 | CNH | Futures | 6.2713 | 6.2907 | 6.2687 | 6.2869 | 315.0 |
| 2021-06-22 | CSC | Futures | 2.571 | 2.571 | 2.529 | 2.529 | 57.0 |
| 2021-06-22 | CT | Futures | 78.22 | 79.12 | 77.95 | 78.53 | 2797.0 |
| 2021-06-22 | DC | Futures | 23.46 | 23.46 | 23.11 | 23.15 | 516.0 |
| 2021-06-22 | DX | Futures | 88.82 | 89.056 | 88.583 | 88.685 | 17330.0 |
| 2021-06-22 | E1 | Futures | 1.22605 | 1.22684 | 1.22156 | 1.22549 | 21528.0 |
| 2021-06-22 | E6 | Futures | 1.26967 | 1.2735 | 1.26584 | 1.27174 | 161650.0 |
| 2021-06-22 | E7 | Futures | 1.2632 | 1.2671 | 1.2595 | 1.2654 | 5567.0 |
| 2021-06-22 | EBM | Futures | 305.99 | 307.46 | 304.52 | 304.52 | 8930.0 |
| 2021-06-22 | ED | Futures | 96.5297 | 96.5393 | 96.5297 | 96.5393 | 131306.0 |
| 2021-06-22 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 85592.0 |
| 2021-06-22 | ESG | Futures | 390.24 | 393.8 | 390.24 | 393.0 | 497.0 |
| 2021-06-22 | EW | Futures | 2863.6 | 2874.9 | 2840.8 | 2867.8 | 8824.0 |
| 2021-06-22 | FBON | Futures | 147.55 | 147.87 | 147.42 | 147.57 | 507.0 |
| 2021-06-22 | FBTP | Futures | 137.64 | 138.06 | 137.41 | 137.57 | 114305.0 |
| 2021-06-22 | FBTS | Futures | 110.049 | 110.117 | 110.039 | 110.059 | 71046.0 |
| 2021-06-22 | FCE | Futures | 6594.2 | 6597.7 | 6545.4 | 6574.3 | 50693.0 |
| 2021-06-22 | FDAX | Futures | 16730.5 | 16754.1 | 16596.6 | 16741.2 | 49020.0 |
| 2021-06-22 | FDIV | Futures | 188.58 | 189.71 | 188.58 | 189.71 | 40.0 |
| 2021-06-22 | FDXM | Futures | 16647.5 | 16671.0 | 16515.3 | 16658.2 | 36846.0 |
| 2021-06-22 | FDXS | Futures | 16512.1 | 16564.0 | 16408.3 | 16552.4 | 3371.0 |
| 2021-06-22 | FESX | Futures | 3894.4 | 3900.1 | 3863.6 | 3897.7 | 478717.0 |
| 2021-06-22 | FEU3 | Futures | 99.198 | 99.198 | 99.198 | 99.198 | 20.0 |
| 2021-06-22 | FGBL | Futures | 166.73 | 166.81 | 166.3 | 166.57 | 680531.0 |
| 2021-06-22 | FGBM | Futures | 134.42 | 134.48 | 134.32 | 134.43 | 362153.0 |
| 2021-06-22 | FGBS | Futures | 112.544 | 112.559 | 112.534 | 112.544 | 284206.0 |
| 2021-06-22 | FGBX | Futures | 216.35 | 216.97 | 215.12 | 216.12 | 74305.0 |
| 2021-06-22 | FMWO | Futures | 10540.1 | 10597.7 | 10506.0 | 10570.7 | 4867.0 |
| 2021-06-22 | FOAT | Futures | 154.48 | 154.71 | 154.13 | 154.46 | 172489.0 |
| 2021-06-22 | FTDX | Futures | 3563.4 | 3601.4 | 3561.3 | 3601.4 | 96.0 |
| 2021-06-22 | FTI | Futures | 691.24 | 694.57 | 686.86 | 693.32 | 17650.0 |
| 2021-06-22 | FTUK | Futures | 6906.0 | 6918.3 | 6879.0 | 6915.4 | 69378.0 |
> showing 50 of 123 rows — these rows as CSV