PREVIEW / futures_daily / 2022-08-04
file: by_date/futures_daily/2022/2022-08-04.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-08-04 | ES | Futures | 4655.78 | 4681.58 | 4639.8 | 4658.02 | 1245063.0 |
| 2022-08-04 | NQ | Futures | 15126.28 | 15250.74 | 15055.2 | 15217.63 | 542680.0 |
| 2022-08-04 | YM | Futures | 35803.3 | 35934.5 | 35644.7 | 35732.2 | 132259.0 |
| 2022-08-04 | CL | Futures | 77.11 | 77.92 | 74.23 | 75.07 | 334931.0 |
| 2022-08-04 | GC | Futures | 2039.4 | 2073.7 | 2036.4 | 2067.8 | 153292.0 |
| 2022-08-04 | ZN | Futures | 123.772485 | 124.318729 | 123.483297 | 124.142003 | 1335255.0 |
| 2022-08-04 | A6 | Futures | 0.71224 | 0.71654 | 0.7109 | 0.71567 | 56260.0 |
| 2022-08-04 | AD | Futures | 0.78963 | 0.79105 | 0.7875 | 0.78927 | 56393.0 |
| 2022-08-04 | ALI | Futures | 2678.85 | 2696.29 | 2641.45 | 2687.85 | 2738.0 |
| 2022-08-04 | B | Futures | 82.33 | 82.8 | 79.02 | 79.8 | 264805.0 |
| 2022-08-04 | B6 | Futures | 1.2337 | 1.241 | 1.2246 | 1.2363 | 117755.0 |
| 2022-08-04 | BR | Futures | 0.16348 | 0.16591 | 0.16304 | 0.16556 | 4978.0 |
| 2022-08-04 | BTC | Futures | 32289.5 | 32289.5 | 30956.2 | 31025.3 | 7914.0 |
| 2022-08-04 | BZ | Futures | 80.47 | 80.99 | 77.27 | 78.08 | 21011.0 |
| 2022-08-04 | C | Futures | 1279.0 | 1305.0 | 1265.0 | 1302.0 | 9008.0 |
| 2022-08-04 | CB | Futures | 230.053 | 231.866 | 229.328 | 230.053 | 85.0 |
| 2022-08-04 | CC | Futures | 1359.0 | 1410.0 | 1350.0 | 1404.0 | 53011.0 |
| 2022-08-04 | CNH | Futures | 6.3703 | 6.3766 | 6.3608 | 6.3609 | 256.0 |
| 2022-08-04 | CSC | Futures | 2.664 | 2.664 | 2.621 | 2.635 | 70.0 |
| 2022-08-04 | CT | Futures | 127.15 | 127.15 | 126.5 | 126.93 | 5.0 |
| 2022-08-04 | DC | Futures | 25.51 | 25.61 | 24.97 | 25.1 | 367.0 |
| 2022-08-04 | DX | Futures | 102.606 | 102.649 | 101.81 | 101.835 | 25625.0 |
| 2022-08-04 | E1 | Futures | 1.15505 | 1.16235 | 1.15273 | 1.16224 | 19239.0 |
| 2022-08-04 | E6 | Futures | 1.07298 | 1.08171 | 1.07114 | 1.08129 | 171396.0 |
| 2022-08-04 | E7 | Futures | 1.0663 | 1.0751 | 1.0647 | 1.0748 | 6107.0 |
| 2022-08-04 | EBM | Futures | 475.32 | 484.09 | 472.52 | 479.88 | 10170.0 |
| 2022-08-04 | ED | Futures | 94.9808 | 94.9955 | 94.9415 | 94.9857 | 97261.0 |
| 2022-08-04 | ER | Futures | 98.238 | 98.258 | 98.213 | 98.253 | 91012.0 |
| 2022-08-04 | ESG | Futures | 401.12 | 402.78 | 399.81 | 401.34 | 355.0 |
| 2022-08-04 | EW | Futures | 2732.3 | 2745.9 | 2710.6 | 2712.6 | 7889.0 |
| 2022-08-04 | FBON | Futures | 134.58 | 135.05 | 134.11 | 135.05 | 96.0 |
| 2022-08-04 | FBTP | Futures | 119.25 | 120.08 | 118.79 | 119.77 | 89656.0 |
| 2022-08-04 | FBTS | Futures | 108.103 | 108.261 | 107.916 | 108.192 | 55908.0 |
| 2022-08-04 | FCE | Futures | 7119.2 | 7196.6 | 7105.5 | 7148.9 | 46271.0 |
| 2022-08-04 | FDAX | Futures | 14661.4 | 14840.0 | 14641.0 | 14678.6 | 51633.0 |
| 2022-08-04 | FDIV | Futures | 162.16 | 162.16 | 161.31 | 161.31 | 20.0 |
| 2022-08-04 | FDXM | Futures | 14746.7 | 14929.6 | 14732.6 | 14768.3 | 32840.0 |
| 2022-08-04 | FDXS | Futures | 14630.8 | 14810.2 | 14611.5 | 14648.0 | 19039.0 |
| 2022-08-04 | FESX | Futures | 3707.5 | 3749.2 | 3700.6 | 3717.4 | 800023.0 |
| 2022-08-04 | FGBL | Futures | 155.33 | 156.21 | 154.61 | 155.83 | 581392.0 |
| 2022-08-04 | FGBM | Futures | 129.37 | 129.87 | 129.02 | 129.71 | 357986.0 |
| 2022-08-04 | FGBS | Futures | 111.751 | 111.893 | 111.624 | 111.832 | 343572.0 |
| 2022-08-04 | FGBX | Futures | 190.78 | 191.66 | 188.95 | 190.52 | 46061.0 |
| 2022-08-04 | FMWO | Futures | 9862.3 | 9923.2 | 9844.7 | 9869.3 | 4331.0 |
| 2022-08-04 | FOAT | Futures | 142.27 | 143.05 | 141.57 | 142.7 | 215788.0 |
| 2022-08-04 | FSMX | Futures | 29915.1 | 30259.4 | 29790.0 | 30048.8 | 1205.0 |
| 2022-08-04 | FTDX | Futures | 3402.6 | 3448.7 | 3372.1 | 3419.2 | 99.0 |
| 2022-08-04 | FTI | Futures | 742.89 | 743.85 | 736.31 | 739.07 | 17049.0 |
| 2022-08-04 | FTUK | Futures | 7494.4 | 7553.2 | 7476.6 | 7510.6 | 86230.0 |
| 2022-08-04 | FVSA | Futures | 68.59 | 68.59 | 64.82 | 67.61 | 24779.0 |
> showing 50 of 127 rows — these rows as CSV