PREVIEW / futures_daily / 2022-08-01
file: by_date/futures_daily/2022/2022-08-01.parquet size: 10 KB rows: 126
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-08-01 | ES | Futures | 4641.48 | 4652.42 | 4596.04 | 4622.41 | 1776936.0 |
| 2022-08-01 | NQ | Futures | 14822.54 | 14968.42 | 14674.96 | 14801.42 | 622511.0 |
| 2022-08-01 | YM | Futures | 35891.8 | 36013.2 | 35645.8 | 35826.2 | 191675.0 |
| 2022-08-01 | CL | Futures | 83.48 | 83.64 | 78.36 | 79.6 | 365293.0 |
| 2022-08-01 | GC | Futures | 2039.9 | 2051.3 | 2030.5 | 2045.9 | 133742.0 |
| 2022-08-01 | ZN | Futures | 124.479389 | 125.057765 | 124.254465 | 124.784643 | 1352861.0 |
| 2022-08-01 | A6 | Futures | 0.71659 | 0.72243 | 0.71434 | 0.71982 | 77077.0 |
| 2022-08-01 | AD | Futures | 0.79231 | 0.79429 | 0.78881 | 0.78947 | 66053.0 |
| 2022-08-01 | ALI | Futures | 2772.78 | 2772.78 | 2717.66 | 2726.66 | 1757.0 |
| 2022-08-01 | B | Futures | 88.11 | 88.54 | 84.01 | 84.81 | 272835.0 |
| 2022-08-01 | B6 | Futures | 1.2366 | 1.2486 | 1.2346 | 1.2446 | 93305.0 |
| 2022-08-01 | BR | Futures | 0.16639 | 0.16804 | 0.16574 | 0.1663 | 8969.0 |
| 2022-08-01 | BTC | Futures | 32683.3 | 32724.7 | 31633.2 | 31819.7 | 5781.0 |
| 2022-08-01 | BZ | Futures | 86.17 | 86.58 | 82.21 | 82.98 | 25670.0 |
| 2022-08-01 | C | Futures | 1274.0 | 1290.0 | 1269.0 | 1282.0 | 5352.0 |
| 2022-08-01 | CB | Futures | 227.233 | 228.441 | 227.233 | 228.441 | 11.0 |
| 2022-08-01 | CC | Futures | 1392.0 | 1408.0 | 1382.0 | 1398.0 | 24764.0 |
| 2022-08-01 | CNH | Futures | 6.3633 | 6.4001 | 6.3608 | 6.391 | 615.0 |
| 2022-08-01 | CSC | Futures | 2.786 | 2.786 | 2.714 | 2.748 | 100.0 |
| 2022-08-01 | CT | Futures | 129.8 | 129.8 | 125.68 | 127.15 | 33.0 |
| 2022-08-01 | DC | Futures | 26.11 | 26.82 | 25.93 | 26.41 | 454.0 |
| 2022-08-01 | DX | Futures | 101.993 | 102.176 | 101.39 | 101.613 | 28391.0 |
| 2022-08-01 | E1 | Futures | 1.1655 | 1.17037 | 1.16357 | 1.16755 | 22930.0 |
| 2022-08-01 | E6 | Futures | 1.07898 | 1.0844 | 1.07703 | 1.08208 | 193098.0 |
| 2022-08-01 | E7 | Futures | 1.073 | 1.0778 | 1.0706 | 1.0756 | 6641.0 |
| 2022-08-01 | EBM | Futures | 481.28 | 481.98 | 466.91 | 471.12 | 11780.0 |
| 2022-08-01 | ED | Futures | 95.0201 | 95.0447 | 94.9955 | 95.025 | 64014.0 |
| 2022-08-01 | ER | Futures | 98.248 | 98.287 | 98.238 | 98.267 | 65541.0 |
| 2022-08-01 | ESG | Futures | 398.84 | 400.83 | 396.49 | 398.28 | 614.0 |
| 2022-08-01 | EW | Futures | 2738.2 | 2749.1 | 2704.6 | 2737.5 | 13302.0 |
| 2022-08-01 | FBON | Futures | 135.07 | 136.38 | 135.02 | 136.38 | 172.0 |
| 2022-08-01 | FBTP | Futures | 118.0 | 119.56 | 117.63 | 119.31 | 114538.0 |
| 2022-08-01 | FBTS | Futures | 107.778 | 108.251 | 107.66 | 108.202 | 78791.0 |
| 2022-08-01 | FCE | Futures | 7082.4 | 7117.0 | 7039.1 | 7064.9 | 47792.0 |
| 2022-08-01 | FDAX | Futures | 14509.7 | 14599.0 | 14435.4 | 14522.6 | 46925.0 |
| 2022-08-01 | FDIV | Futures | 159.77 | 160.62 | 159.77 | 160.62 | 1.0 |
| 2022-08-01 | FDXM | Futures | 14598.3 | 14688.2 | 14524.7 | 14611.3 | 27762.0 |
| 2022-08-01 | FDXS | Futures | 14484.8 | 14568.5 | 14406.4 | 14492.3 | 14316.0 |
| 2022-08-01 | FESX | Futures | 3679.7 | 3696.6 | 3656.9 | 3676.8 | 614005.0 |
| 2022-08-01 | FGBL | Futures | 155.27 | 156.46 | 154.69 | 156.35 | 562818.0 |
| 2022-08-01 | FGBM | Futures | 129.63 | 130.12 | 129.33 | 130.05 | 375919.0 |
| 2022-08-01 | FGBS | Futures | 111.883 | 112.04 | 111.801 | 112.0 | 412583.0 |
| 2022-08-01 | FGBX | Futures | 188.58 | 191.5 | 187.46 | 191.13 | 54382.0 |
| 2022-08-01 | FMWO | Futures | 9831.8 | 9890.4 | 9780.3 | 9875.0 | 16280.0 |
| 2022-08-01 | FOAT | Futures | 142.28 | 143.1 | 141.67 | 143.0 | 150606.0 |
| 2022-08-01 | FSMX | Futures | 29295.0 | 29488.5 | 29236.2 | 29364.5 | 92.0 |
| 2022-08-01 | FTDX | Futures | 3343.8 | 3369.5 | 3342.2 | 3368.4 | 77.0 |
| 2022-08-01 | FTI | Futures | 734.99 | 738.28 | 730.23 | 733.85 | 17173.0 |
| 2022-08-01 | FTUK | Futures | 7487.3 | 7524.8 | 7445.2 | 7480.7 | 96837.0 |
| 2022-08-01 | FVSA | Futures | 68.87 | 69.71 | 67.06 | 68.45 | 18077.0 |
> showing 50 of 126 rows — these rows as CSV