PREVIEW / futures_daily / 2023-04-17
file: by_date/futures_daily/2023/2023-04-17.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-17 | ES | Futures | 4567.56 | 4574.39 | 4538.83 | 4570.29 | 1298123.0 |
| 2023-04-17 | NQ | Futures | 14646.73 | 14652.83 | 14496.25 | 14617.91 | 540742.0 |
| 2023-04-17 | YM | Futures | 36567.2 | 36591.8 | 36366.8 | 36571.5 | 128275.0 |
| 2023-04-17 | CL | Futures | 71.86 | 72.03 | 70.15 | 70.47 | 229971.0 |
| 2023-04-17 | GC | Futures | 2234.8 | 2250.2 | 2211.8 | 2226.9 | 183425.0 |
| 2023-04-17 | ZN | Futures | 117.521797 | 117.633707 | 116.898297 | 117.010207 | 1067311.0 |
| 2023-04-17 | A6 | Futures | 0.68331 | 0.68459 | 0.68072 | 0.68276 | 56870.0 |
| 2023-04-17 | AD | Futures | 0.75875 | 0.75997 | 0.75556 | 0.75683 | 64129.0 |
| 2023-04-17 | ALI | Futures | 2617.2 | 2619.93 | 2589.06 | 2615.29 | 1151.0 |
| 2023-04-17 | B | Futures | 76.03 | 76.11 | 74.19 | 74.56 | 261810.0 |
| 2023-04-17 | B6 | Futures | 1.2495 | 1.251 | 1.2423 | 1.2444 | 76697.0 |
| 2023-04-17 | BFX | Futures | 4168.0 | 4168.0 | 4168.0 | 4168.0 | 0.0 |
| 2023-04-17 | BR | Futures | 0.18214 | 0.18291 | 0.18115 | 0.18178 | 212.0 |
| 2023-04-17 | BTC | Futures | 41650.7 | 41650.7 | 39880.4 | 40241.2 | 6895.0 |
| 2023-04-17 | BZ | Futures | 75.5 | 75.71 | 73.82 | 74.18 | 30271.0 |
| 2023-04-17 | C | Futures | 1704.0 | 1739.0 | 1694.0 | 1737.0 | 5379.0 |
| 2023-04-17 | CB | Futures | 233.445 | 233.445 | 233.445 | 233.445 | 32.0 |
| 2023-04-17 | CC | Futures | 1678.0 | 1700.0 | 1674.0 | 1695.0 | 26595.0 |
| 2023-04-17 | CNH | Futures | 6.5288 | 6.5477 | 6.5261 | 6.5441 | 344.0 |
| 2023-04-17 | CSC | Futures | 2.229 | 2.229 | 2.195 | 2.213 | 140.0 |
| 2023-04-17 | CT | Futures | 107.66 | 109.05 | 107.35 | 108.19 | 12605.0 |
| 2023-04-17 | DC | Futures | 21.1 | 21.14 | 20.6 | 20.87 | 465.0 |
| 2023-04-17 | DX | Futures | 98.998 | 99.624 | 98.939 | 99.497 | 12810.0 |
| 2023-04-17 | E1 | Futures | 1.20593 | 1.20887 | 1.19875 | 1.19993 | 17495.0 |
| 2023-04-17 | E6 | Futures | 1.13474 | 1.13499 | 1.12564 | 1.12754 | 174658.0 |
| 2023-04-17 | E7 | Futures | 1.1344 | 1.1346 | 1.1252 | 1.1271 | 4909.0 |
| 2023-04-17 | EBM | Futures | 369.6 | 379.96 | 368.49 | 378.85 | 30087.0 |
| 2023-04-17 | ER | Futures | 97.853 | 97.863 | 97.838 | 97.853 | 115123.0 |
| 2023-04-17 | ESG | Futures | 394.05 | 394.29 | 391.71 | 394.01 | 354.0 |
| 2023-04-17 | EW | Futures | 2678.8 | 2696.3 | 2670.0 | 2693.4 | 8384.0 |
| 2023-04-17 | FBON | Futures | 121.0 | 121.07 | 120.43 | 120.43 | 150.0 |
| 2023-04-17 | FBTP | Futures | 111.08 | 111.28 | 110.63 | 110.67 | 109703.0 |
| 2023-04-17 | FBTS | Futures | 106.219 | 106.259 | 106.108 | 106.138 | 56578.0 |
| 2023-04-17 | FCE | Futures | 8128.8 | 8157.7 | 8092.8 | 8099.9 | 16213.0 |
| 2023-04-17 | FDAX | Futures | 17043.8 | 17114.2 | 16961.7 | 16991.5 | 46468.0 |
| 2023-04-17 | FDIV | Futures | 187.94 | 187.94 | 187.94 | 187.94 | 0.0 |
| 2023-04-17 | FDXM | Futures | 17176.1 | 17260.1 | 17105.1 | 17136.3 | 30110.0 |
| 2023-04-17 | FDXS | Futures | 17045.9 | 17143.1 | 16990.3 | 17021.3 | 13639.0 |
| 2023-04-17 | FESX | Futures | 4438.5 | 4443.6 | 4402.7 | 4408.9 | 637174.0 |
| 2023-04-17 | FEU3 | Futures | 97.863 | 97.863 | 97.863 | 97.863 | 0.0 |
| 2023-04-17 | FGBL | Futures | 134.94 | 135.22 | 134.32 | 134.4 | 592843.0 |
| 2023-04-17 | FGBM | Futures | 119.03 | 119.15 | 118.74 | 118.82 | 426666.0 |
| 2023-04-17 | FGBS | Futures | 107.97 | 108.01 | 107.903 | 107.954 | 320332.0 |
| 2023-04-17 | FGBX | Futures | 139.53 | 140.13 | 137.74 | 137.86 | 57421.0 |
| 2023-04-17 | FMWO | Futures | 9948.2 | 9962.9 | 9887.1 | 9906.4 | 3580.0 |
| 2023-04-17 | FOAT | Futures | 125.92 | 126.14 | 125.38 | 125.45 | 135298.0 |
| 2023-04-17 | FSMX | Futures | 29693.8 | 29822.6 | 29580.8 | 29621.0 | 150.0 |
| 2023-04-17 | FTDX | Futures | 3580.8 | 3581.9 | 3556.7 | 3577.0 | 23.0 |
| 2023-04-17 | FTI | Futures | 801.7 | 803.36 | 797.36 | 798.23 | 2173.0 |
| 2023-04-17 | FTUK | Futures | 8051.4 | 8069.8 | 8026.5 | 8034.6 | 67698.0 |
> showing 50 of 130 rows — these rows as CSV