PREVIEW / futures_daily / 2023-04-19
file: by_date/futures_daily/2023/2023-04-19.parquet size: 10 KB rows: 130
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-19 | ES | Futures | 4569.47 | 4582.05 | 4541.57 | 4572.21 | 1292622.0 |
| 2023-04-19 | NQ | Futures | 14600.18 | 14662.53 | 14483.22 | 14614.03 | 529506.0 |
| 2023-04-19 | YM | Futures | 36544.7 | 36545.8 | 36371.1 | 36468.6 | 124516.0 |
| 2023-04-19 | CL | Futures | 70.59 | 70.83 | 68.47 | 69.09 | 350784.0 |
| 2023-04-19 | GC | Futures | 2239.0 | 2241.7 | 2197.9 | 2227.2 | 218808.0 |
| 2023-04-19 | ZN | Futures | 117.074156 | 117.10613 | 116.59454 | 116.834348 | 1356814.0 |
| 2023-04-19 | A6 | Futures | 0.68545 | 0.68682 | 0.68164 | 0.68413 | 55792.0 |
| 2023-04-19 | AD | Futures | 0.75739 | 0.75759 | 0.75293 | 0.75318 | 68838.0 |
| 2023-04-19 | ALI | Futures | 2661.73 | 2687.69 | 2637.15 | 2686.32 | 871.0 |
| 2023-04-19 | B | Futures | 74.68 | 74.9 | 72.48 | 73.12 | 333215.0 |
| 2023-04-19 | B6 | Futures | 1.2497 | 1.2545 | 1.2461 | 1.2508 | 87573.0 |
| 2023-04-19 | BFX | Futures | 4155.3 | 4155.3 | 4155.3 | 4155.3 | 0.0 |
| 2023-04-19 | BR | Futures | 0.17952 | 0.17952 | 0.17641 | 0.1765 | 290.0 |
| 2023-04-19 | BTC | Futures | 41446.4 | 41562.2 | 39505.9 | 39853.1 | 7617.0 |
| 2023-04-19 | BZ | Futures | 74.26 | 74.52 | 72.12 | 72.74 | 30732.0 |
| 2023-04-19 | C | Futures | 1757.0 | 1765.0 | 1744.0 | 1758.0 | 4311.0 |
| 2023-04-19 | CB | Futures | 234.424 | 235.011 | 234.424 | 234.424 | 26.0 |
| 2023-04-19 | CC | Futures | 1727.0 | 1735.0 | 1710.0 | 1728.0 | 26399.0 |
| 2023-04-19 | CNH | Futures | 6.5455 | 6.5702 | 6.5435 | 6.5549 | 135.0 |
| 2023-04-19 | CSC | Futures | 2.213 | 2.223 | 2.201 | 2.206 | 128.0 |
| 2023-04-19 | CT | Futures | 109.75 | 110.31 | 107.93 | 108.11 | 5731.0 |
| 2023-04-19 | DC | Futures | 20.92 | 21.11 | 20.72 | 20.93 | 217.0 |
| 2023-04-19 | DX | Futures | 99.14 | 99.638 | 99.076 | 99.372 | 11478.0 |
| 2023-04-19 | E1 | Futures | 1.20298 | 1.20357 | 1.19758 | 1.20127 | 15448.0 |
| 2023-04-19 | E6 | Futures | 1.13232 | 1.1333 | 1.12636 | 1.13006 | 162488.0 |
| 2023-04-19 | E7 | Futures | 1.1319 | 1.1328 | 1.1259 | 1.1295 | 4774.0 |
| 2023-04-19 | EBM | Futures | 383.29 | 383.29 | 375.15 | 375.89 | 18424.0 |
| 2023-04-19 | ER | Futures | 97.833 | 97.843 | 97.787 | 97.838 | 158244.0 |
| 2023-04-19 | ESG | Futures | 393.43 | 395.21 | 391.97 | 394.5 | 651.0 |
| 2023-04-19 | EW | Futures | 2689.1 | 2696.7 | 2668.2 | 2693.2 | 8192.0 |
| 2023-04-19 | FBON | Futures | 120.39 | 120.46 | 120.19 | 120.34 | 75.0 |
| 2023-04-19 | FBTP | Futures | 110.67 | 110.77 | 110.28 | 110.53 | 133290.0 |
| 2023-04-19 | FBTS | Futures | 106.027 | 106.067 | 105.936 | 105.996 | 98701.0 |
| 2023-04-19 | FCE | Futures | 8125.0 | 8175.7 | 8116.3 | 8156.6 | 75792.0 |
| 2023-04-19 | FDAX | Futures | 17090.7 | 17134.5 | 17029.9 | 17106.7 | 44279.0 |
| 2023-04-19 | FDIV | Futures | 189.87 | 189.87 | 189.87 | 189.87 | 0.0 |
| 2023-04-19 | FDXM | Futures | 17248.2 | 17282.6 | 17174.0 | 17252.5 | 26724.0 |
| 2023-04-19 | FDXS | Futures | 17119.6 | 17165.5 | 17057.6 | 17136.7 | 15267.0 |
| 2023-04-19 | FESX | Futures | 4436.5 | 4444.6 | 4410.9 | 4434.4 | 633766.0 |
| 2023-04-19 | FEU3 | Futures | 97.843 | 97.843 | 97.843 | 97.843 | 0.0 |
| 2023-04-19 | FGBL | Futures | 134.39 | 134.48 | 133.82 | 134.15 | 662911.0 |
| 2023-04-19 | FGBM | Futures | 118.66 | 118.68 | 118.31 | 118.53 | 469270.0 |
| 2023-04-19 | FGBS | Futures | 107.841 | 107.867 | 107.749 | 107.806 | 425764.0 |
| 2023-04-19 | FGBX | Futures | 138.78 | 139.05 | 137.6 | 138.51 | 55486.0 |
| 2023-04-19 | FMWO | Futures | 9948.2 | 9960.6 | 9895.0 | 9936.9 | 2426.0 |
| 2023-04-19 | FOAT | Futures | 125.42 | 125.53 | 124.92 | 125.25 | 125420.0 |
| 2023-04-19 | FSMX | Futures | 29527.0 | 29684.3 | 29475.3 | 29684.3 | 556.0 |
| 2023-04-19 | FTDX | Futures | 3557.2 | 3557.2 | 3545.5 | 3545.5 | 2.0 |
| 2023-04-19 | FTI | Futures | 802.28 | 802.28 | 796.67 | 800.01 | 13401.0 |
| 2023-04-19 | FTUK | Futures | 8058.1 | 8067.2 | 8022.4 | 8049.9 | 69224.0 |
> showing 50 of 130 rows — these rows as CSV