PREVIEW / futures_daily / 2022-08-18
file: by_date/futures_daily/2022/2022-08-18.parquet size: 10 KB rows: 128
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-18 | ES | Futures | 4800.77 | 4818.72 | 4776.66 | 4808.63 | 1366220.0 |
| 2022-08-18 | NQ | Futures | 15418.6 | 15501.38 | 15313.26 | 15441.72 | 530513.0 |
| 2022-08-18 | YM | Futures | 37167.8 | 37235.6 | 36980.8 | 37153.6 | 123706.0 |
| 2022-08-18 | CL | Futures | 74.49 | 77.85 | 74.33 | 77.06 | 247555.0 |
| 2022-08-18 | GC | Futures | 2033.7 | 2044.2 | 2024.2 | 2027.0 | 124319.0 |
| 2022-08-18 | ZN | Futures | 122.069489 | 122.599667 | 121.908829 | 122.198017 | 1155689.0 |
| 2022-08-18 | A6 | Futures | 0.71096 | 0.71434 | 0.70706 | 0.70896 | 93223.0 |
| 2022-08-18 | AD | Futures | 0.78536 | 0.78729 | 0.78202 | 0.78354 | 73333.0 |
| 2022-08-18 | ALI | Futures | 2727.68 | 2744.64 | 2708.17 | 2728.24 | 1166.0 |
| 2022-08-18 | B | Futures | 79.1 | 82.6 | 78.89 | 81.89 | 208551.0 |
| 2022-08-18 | B6 | Futures | 1.2233 | 1.2263 | 1.2103 | 1.2112 | 112706.0 |
| 2022-08-18 | BFX | Futures | 4226.8 | 4226.8 | 4206.1 | 4206.1 | 11.0 |
| 2022-08-18 | BR | Futures | 0.16678 | 0.17 | 0.16643 | 0.16704 | 5303.0 |
| 2022-08-18 | BTC | Futures | 32137.5 | 32593.5 | 32068.4 | 32241.1 | 3984.0 |
| 2022-08-18 | BZ | Futures | 77.3 | 80.81 | 77.19 | 80.13 | 21327.0 |
| 2022-08-18 | C | Futures | 1323.0 | 1331.0 | 1317.0 | 1323.0 | 4419.0 |
| 2022-08-18 | CB | Futures | 237.103 | 237.97 | 237.103 | 237.103 | 71.0 |
| 2022-08-18 | CC | Futures | 1422.0 | 1437.0 | 1405.0 | 1418.0 | 24131.0 |
| 2022-08-18 | CNH | Futures | 6.4028 | 6.4252 | 6.4 | 6.4167 | 570.0 |
| 2022-08-18 | CSC | Futures | 2.782 | 2.782 | 2.726 | 2.737 | 134.0 |
| 2022-08-18 | CT | Futures | 150.54 | 150.55 | 148.48 | 148.48 | 12.0 |
| 2022-08-18 | DC | Futures | 26.55 | 26.62 | 25.97 | 26.1 | 314.0 |
| 2022-08-18 | DX | Futures | 102.808 | 103.696 | 102.664 | 103.619 | 33746.0 |
| 2022-08-18 | E1 | Futures | 1.1649 | 1.16661 | 1.15776 | 1.15859 | 17996.0 |
| 2022-08-18 | E6 | Futures | 1.07256 | 1.07419 | 1.0622 | 1.06336 | 227077.0 |
| 2022-08-18 | E7 | Futures | 1.0662 | 1.0677 | 1.0558 | 1.057 | 8061.0 |
| 2022-08-18 | EBM | Futures | 452.19 | 452.89 | 431.51 | 439.92 | 14113.0 |
| 2022-08-18 | ED | Futures | 95.0078 | 95.0176 | 94.9734 | 94.998 | 114291.0 |
| 2022-08-18 | ER | Futures | 98.238 | 98.253 | 98.198 | 98.223 | 86125.0 |
| 2022-08-18 | ESG | Futures | 413.38 | 415.84 | 412.87 | 414.95 | 394.0 |
| 2022-08-18 | EW | Futures | 2837.2 | 2858.8 | 2826.9 | 2854.7 | 8898.0 |
| 2022-08-18 | FBON | Futures | 131.41 | 131.61 | 130.81 | 131.44 | 291.0 |
| 2022-08-18 | FBTP | Futures | 116.46 | 116.6 | 115.64 | 116.47 | 95502.0 |
| 2022-08-18 | FBTS | Futures | 107.296 | 107.345 | 107.059 | 107.315 | 40192.0 |
| 2022-08-18 | FCE | Futures | 7177.4 | 7225.7 | 7158.7 | 7203.8 | 54488.0 |
| 2022-08-18 | FDAX | Futures | 14670.0 | 14827.1 | 14641.0 | 14731.4 | 52184.0 |
| 2022-08-18 | FDIV | Futures | 161.96 | 162.35 | 161.96 | 162.35 | 2.0 |
| 2022-08-18 | FDXM | Futures | 14760.7 | 14917.7 | 14729.3 | 14821.4 | 26204.0 |
| 2022-08-18 | FDXS | Futures | 14648.0 | 14796.2 | 14610.4 | 14700.6 | 16433.0 |
| 2022-08-18 | FESX | Futures | 3727.4 | 3752.2 | 3716.5 | 3743.2 | 616322.0 |
| 2022-08-18 | FGBL | Futures | 152.18 | 152.45 | 151.23 | 152.14 | 530648.0 |
| 2022-08-18 | FGBM | Futures | 127.84 | 127.93 | 127.29 | 127.78 | 535259.0 |
| 2022-08-18 | FGBS | Futures | 111.293 | 111.339 | 111.156 | 111.288 | 446739.0 |
| 2022-08-18 | FGBX | Futures | 180.78 | 181.97 | 179.74 | 181.17 | 47372.0 |
| 2022-08-18 | FMWO | Futures | 10070.7 | 10146.8 | 10059.0 | 10118.7 | 2382.0 |
| 2022-08-18 | FOAT | Futures | 139.58 | 139.76 | 138.67 | 139.52 | 150374.0 |
| 2022-08-18 | FSMX | Futures | 29398.7 | 29600.8 | 29359.2 | 29415.8 | 484.0 |
| 2022-08-18 | FTDX | Futures | 3349.1 | 3362.0 | 3341.6 | 3357.2 | 182.0 |
| 2022-08-18 | FTI | Futures | 736.36 | 740.93 | 727.46 | 737.65 | 12463.0 |
| 2022-08-18 | FTUK | Futures | 7600.3 | 7666.7 | 7592.7 | 7639.9 | 81960.0 |
> showing 50 of 128 rows — these rows as CSV