PREVIEW / futures_daily / 2022-09-19
file: by_date/futures_daily/2022/2022-09-19.parquet size: 10 KB rows: 121
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 |
|---|---|---|---|---|---|---|---|
| 2022-09-19 | ES | Futures | 4335.15 | 4376.95 | 4286.94 | 4366.08 | 2100098.0 |
| 2022-09-19 | NQ | Futures | 13508.34 | 13674.08 | 13363.57 | 13626.2 | 632663.0 |
| 2022-09-19 | YM | Futures | 33676.2 | 33931.9 | 33286.6 | 33860.1 | 155409.0 |
| 2022-09-19 | CL | Futures | 72.49 | 73.41 | 69.86 | 72.96 | 262902.0 |
| 2022-09-19 | GC | Futures | 1928.8 | 1932.7 | 1908.4 | 1920.5 | 141171.0 |
| 2022-09-19 | ZN | Futures | 118.020086 | 118.10046 | 117.505698 | 117.650369 | 963169.0 |
| 2022-09-19 | A6 | Futures | 0.68772 | 0.68992 | 0.68358 | 0.68767 | 60283.0 |
| 2022-09-19 | AD | Futures | 0.76437 | 0.76584 | 0.76016 | 0.76422 | 72275.0 |
| 2022-09-19 | ALI | Futures | 2530.43 | 2540.2 | 2519.83 | 2525.41 | 1809.0 |
| 2022-09-19 | B | Futures | 77.85 | 78.82 | 75.35 | 78.34 | 138529.0 |
| 2022-09-19 | B6 | Futures | 1.1554 | 1.1575 | 1.1488 | 1.1552 | 49941.0 |
| 2022-09-19 | BTC | Futures | 26941.2 | 27120.9 | 25151.1 | 26927.3 | 12241.0 |
| 2022-09-19 | BZ | Futures | 76.25 | 77.02 | 73.61 | 76.54 | 17627.0 |
| 2022-09-19 | CB | Futures | 250.003 | 250.003 | 250.003 | 250.003 | 2.0 |
| 2022-09-19 | CC | Futures | 1376.0 | 1402.0 | 1373.0 | 1387.0 | 15720.0 |
| 2022-09-19 | CNH | Futures | 6.6038 | 6.6263 | 6.6016 | 6.6048 | 1006.0 |
| 2022-09-19 | CSC | Futures | 2.688 | 2.69 | 2.65 | 2.659 | 19.0 |
| 2022-09-19 | CT | Futures | 123.66 | 123.66 | 123.66 | 123.66 | 3.0 |
| 2022-09-19 | DC | Futures | 25.84 | 26.36 | 25.51 | 25.95 | 132.0 |
| 2022-09-19 | DX | Futures | 106.164 | 106.639 | 105.984 | 106.213 | 23223.0 |
| 2022-09-19 | E1 | Futures | 1.14483 | 1.14757 | 1.13935 | 1.14395 | 14263.0 |
| 2022-09-19 | E6 | Futures | 1.04877 | 1.05065 | 1.04399 | 1.04882 | 144699.0 |
| 2022-09-19 | E7 | Futures | 1.0474 | 1.0488 | 1.0422 | 1.0471 | 4917.0 |
| 2022-09-19 | EBM | Futures | 470.96 | 471.67 | 461.39 | 462.1 | 24705.0 |
| 2022-09-19 | ED | Futures | 94.5825 | 94.5825 | 94.5231 | 94.5528 | 138807.0 |
| 2022-09-19 | ER | Futures | 97.741 | 97.751 | 97.666 | 97.696 | 141347.0 |
| 2022-09-19 | ESG | Futures | 366.54 | 372.7 | 366.45 | 372.46 | 896.0 |
| 2022-09-19 | EW | Futures | 2582.7 | 2620.3 | 2549.6 | 2614.7 | 12973.0 |
| 2022-09-19 | FBON | Futures | 125.36 | 125.49 | 125.06 | 125.43 | 69.0 |
| 2022-09-19 | FBTP | Futures | 110.29 | 110.56 | 109.39 | 110.07 | 81916.0 |
| 2022-09-19 | FBTS | Futures | 105.759 | 105.869 | 105.649 | 105.739 | 48759.0 |
| 2022-09-19 | FCE | Futures | 6625.0 | 6646.3 | 6513.7 | 6610.3 | 51231.0 |
| 2022-09-19 | FDAX | Futures | 13956.5 | 14086.4 | 13780.8 | 14023.1 | 55066.0 |
| 2022-09-19 | FDIV | Futures | 155.6 | 156.99 | 155.6 | 156.04 | 30.0 |
| 2022-09-19 | FDXM | Futures | 13763.0 | 13872.7 | 13574.8 | 13814.7 | 46198.0 |
| 2022-09-19 | FDXS | Futures | 13708.5 | 13801.6 | 13507.3 | 13746.0 | 22205.0 |
| 2022-09-19 | FESX | Futures | 3462.7 | 3478.5 | 3407.3 | 3464.7 | 645098.0 |
| 2022-09-19 | FGBL | Futures | 142.97 | 143.04 | 141.96 | 142.4 | 352175.0 |
| 2022-09-19 | FGBM | Futures | 123.38 | 123.38 | 122.8 | 122.98 | 233094.0 |
| 2022-09-19 | FGBS | Futures | 109.867 | 109.872 | 109.611 | 109.662 | 242304.0 |
| 2022-09-19 | FGBX | Futures | 163.14 | 163.32 | 160.11 | 161.57 | 41268.0 |
| 2022-09-19 | FMWO | Futures | 9141.0 | 9235.1 | 9072.5 | 9168.9 | 4994.0 |
| 2022-09-19 | FOAT | Futures | 132.57 | 132.57 | 131.48 | 131.97 | 75428.0 |
| 2022-09-19 | FSMX | Futures | 25147.0 | 25451.6 | 25075.1 | 25425.1 | 221.0 |
| 2022-09-19 | FTDX | Futures | 3037.0 | 3037.0 | 2971.0 | 2994.4 | 90.0 |
| 2022-09-19 | FTI | Futures | 670.65 | 675.71 | 664.18 | 672.86 | 20059.0 |
| 2022-09-19 | FVSA | Futures | 63.88 | 66.35 | 62.83 | 64.12 | 35381.0 |
| 2022-09-19 | FXXP | Futures | 403.8 | 404.4 | 397.9 | 403.0 | 47723.0 |
| 2022-09-19 | GF | Futures | 226.109 | 228.201 | 225.89 | 227.733 | 6115.0 |
| 2022-09-19 | GSCI | Futures | 660.12 | 660.23 | 659.91 | 660.23 | 50.0 |
> showing 50 of 121 rows — these rows as CSV