PREVIEW / futures_daily / 2022-04-27
file: by_date/futures_daily/2022/2022-04-27.parquet size: 10 KB rows: 127
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-04-27 | ES | Futures | 4667.66 | 4765.24 | 4667.1 | 4702.25 | 2035627.0 |
| 2022-04-27 | NQ | Futures | 14800.8 | 15230.83 | 14797.64 | 14947.88 | 817196.0 |
| 2022-04-27 | YM | Futures | 36303.0 | 36793.5 | 36141.0 | 36372.0 | 239696.0 |
| 2022-04-27 | CL | Futures | 81.16 | 82.14 | 79.6 | 81.37 | 278781.0 |
| 2022-04-27 | GC | Futures | 2218.0 | 2218.8 | 2188.0 | 2196.3 | 178197.0 |
| 2022-04-27 | ZN | Futures | 123.234889 | 123.37878 | 122.371542 | 122.579384 | 1599187.0 |
| 2022-04-27 | A6 | Futures | 0.7298 | 0.73646 | 0.7274 | 0.72934 | 111395.0 |
| 2022-04-27 | AD | Futures | 0.78959 | 0.79242 | 0.78771 | 0.78908 | 90756.0 |
| 2022-04-27 | ALI | Futures | 3531.53 | 3565.76 | 3531.53 | 3565.76 | 46.0 |
| 2022-04-27 | B | Futures | 79.84 | 80.54 | 78.27 | 79.75 | 230068.0 |
| 2022-04-27 | B6 | Futures | 1.2752 | 1.278 | 1.268 | 1.2718 | 119387.0 |
| 2022-04-27 | BR | Futures | 0.16777 | 0.1695 | 0.16579 | 0.16858 | 9232.0 |
| 2022-04-27 | BTC | Futures | 53191.1 | 54892.1 | 52385.7 | 54065.9 | 4375.0 |
| 2022-04-27 | BZ | Futures | 78.18 | 78.81 | 76.6 | 78.05 | 21663.0 |
| 2022-04-27 | C | Futures | 1365.0 | 1386.0 | 1355.0 | 1366.0 | 3208.0 |
| 2022-04-27 | CB | Futures | 205.552 | 205.962 | 205.552 | 205.962 | 19.0 |
| 2022-04-27 | CC | Futures | 1537.0 | 1549.0 | 1520.0 | 1545.0 | 23565.0 |
| 2022-04-27 | CNH | Futures | 6.2555 | 6.2571 | 6.2408 | 6.2481 | 963.0 |
| 2022-04-27 | CSC | Futures | 3.211 | 3.213 | 3.154 | 3.181 | 41.0 |
| 2022-04-27 | CT | Futures | 138.22 | 142.98 | 138.03 | 142.98 | 15932.0 |
| 2022-04-27 | DC | Futures | 31.35 | 31.4 | 30.5 | 30.75 | 502.0 |
| 2022-04-27 | DX | Futures | 98.672 | 99.598 | 98.585 | 99.283 | 37470.0 |
| 2022-04-27 | E1 | Futures | 1.15818 | 1.15963 | 1.14928 | 1.15106 | 28719.0 |
| 2022-04-27 | E6 | Futures | 1.12675 | 1.12844 | 1.11343 | 1.11835 | 257166.0 |
| 2022-04-27 | E7 | Futures | 1.1202 | 1.1219 | 1.107 | 1.1119 | 7730.0 |
| 2022-04-27 | EBM | Futures | 582.36 | 590.45 | 580.25 | 588.69 | 6136.0 |
| 2022-04-27 | ED | Futures | 95.5665 | 95.5811 | 95.5276 | 95.5471 | 115948.0 |
| 2022-04-27 | ER | Futures | 98.401 | 98.406 | 98.381 | 98.391 | 82161.0 |
| 2022-04-27 | ESG | Futures | 396.56 | 401.36 | 392.9 | 395.83 | 484.0 |
| 2022-04-27 | EW | Futures | 2738.5 | 2776.9 | 2727.8 | 2743.9 | 22078.0 |
| 2022-04-27 | FBON | Futures | 134.82 | 135.2 | 134.24 | 134.85 | 125.0 |
| 2022-04-27 | FBTP | Futures | 121.4 | 121.55 | 120.84 | 121.25 | 132675.0 |
| 2022-04-27 | FBTS | Futures | 108.177 | 108.245 | 108.069 | 108.216 | 78734.0 |
| 2022-04-27 | FCE | Futures | 6590.7 | 6653.4 | 6507.8 | 6620.8 | 72326.0 |
| 2022-04-27 | FDAX | Futures | 14595.6 | 14842.8 | 14530.3 | 14733.7 | 71177.0 |
| 2022-04-27 | FDIV | Futures | 166.87 | 166.87 | 165.93 | 165.93 | 5.0 |
| 2022-04-27 | FDXM | Futures | 14622.9 | 14859.7 | 14545.8 | 14749.3 | 64585.0 |
| 2022-04-27 | FDXS | Futures | 14644.9 | 14751.2 | 14441.7 | 14642.7 | 42258.0 |
| 2022-04-27 | FESX | Futures | 3551.0 | 3609.8 | 3534.4 | 3583.3 | 918171.0 |
| 2022-04-27 | FGBL | Futures | 153.86 | 154.23 | 153.23 | 153.87 | 779875.0 |
| 2022-04-27 | FGBM | Futures | 128.42 | 128.66 | 128.06 | 128.53 | 483423.0 |
| 2022-04-27 | FGBS | Futures | 111.401 | 111.497 | 111.305 | 111.467 | 433074.0 |
| 2022-04-27 | FGBX | Futures | 191.54 | 192.15 | 189.99 | 190.86 | 66131.0 |
| 2022-04-27 | FMWO | Futures | 10081.6 | 10191.5 | 10026.0 | 10118.2 | 8275.0 |
| 2022-04-27 | FOAT | Futures | 141.76 | 142.03 | 141.15 | 141.69 | 199354.0 |
| 2022-04-27 | FSMX | Futures | 31103.1 | 31349.7 | 30931.1 | 31237.4 | 597.0 |
| 2022-04-27 | FTDX | Futures | 3237.4 | 3268.4 | 3221.0 | 3248.9 | 61.0 |
| 2022-04-27 | FTI | Futures | 678.27 | 685.77 | 672.95 | 681.74 | 23553.0 |
| 2022-04-27 | FTUK | Futures | 7321.8 | 7416.6 | 7301.8 | 7395.6 | 112194.0 |
| 2022-04-27 | FVSA | Futures | 101.56 | 103.34 | 97.85 | 100.92 | 21967.0 |
> showing 50 of 127 rows — these rows as CSV