PREVIEW / futures_daily / 2023-04-24
file: by_date/futures_daily/2023/2023-04-24.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-24 | ES | Futures | 4541.02 | 4556.61 | 4522.97 | 4551.42 | 1328041.0 |
| 2023-04-24 | NQ | Futures | 14488.77 | 14559.71 | 14374.86 | 14473.8 | 582286.0 |
| 2023-04-24 | YM | Futures | 36349.7 | 36459.0 | 36192.1 | 36434.3 | 121541.0 |
| 2023-04-24 | CL | Futures | 67.98 | 69.03 | 66.89 | 68.67 | 306720.0 |
| 2023-04-24 | GC | Futures | 2210.3 | 2220.8 | 2201.8 | 2218.9 | 139878.0 |
| 2023-04-24 | ZN | Futures | 117.122117 | 117.72963 | 117.10613 | 117.537784 | 840959.0 |
| 2023-04-24 | A6 | Futures | 0.68179 | 0.6822 | 0.67894 | 0.68164 | 55265.0 |
| 2023-04-24 | AD | Futures | 0.74867 | 0.74979 | 0.74731 | 0.74883 | 55158.0 |
| 2023-04-24 | ALI | Futures | 2625.13 | 2625.13 | 2593.16 | 2609.28 | 3782.0 |
| 2023-04-24 | B | Futures | 72.02 | 73.0 | 70.8 | 72.77 | 197899.0 |
| 2023-04-24 | B6 | Futures | 1.2506 | 1.2556 | 1.2479 | 1.2552 | 72558.0 |
| 2023-04-24 | BFX | Futures | 4146.5 | 4146.5 | 4146.5 | 4146.5 | 0.0 |
| 2023-04-24 | BR | Futures | 0.1774 | 0.17803 | 0.17645 | 0.17799 | 8887.0 |
| 2023-04-24 | BTC | Futures | 37190.8 | 37863.9 | 36517.7 | 37083.1 | 3402.0 |
| 2023-04-24 | BZ | Futures | 71.41 | 72.63 | 70.44 | 72.4 | 16684.0 |
| 2023-04-24 | C | Futures | 1768.0 | 1770.0 | 1741.0 | 1746.0 | 3378.0 |
| 2023-04-24 | CB | Futures | 235.892 | 235.892 | 234.424 | 234.889 | 24.0 |
| 2023-04-24 | CC | Futures | 1728.0 | 1734.0 | 1706.0 | 1722.0 | 14935.0 |
| 2023-04-24 | CNH | Futures | 6.5586 | 6.5766 | 6.5586 | 6.5689 | 138.0 |
| 2023-04-24 | CSC | Futures | 2.213 | 2.213 | 2.19 | 2.193 | 201.0 |
| 2023-04-24 | CT | Futures | 101.84 | 103.65 | 101.5 | 102.23 | 17001.0 |
| 2023-04-24 | DC | Futures | 21.0 | 21.01 | 20.55 | 20.59 | 376.0 |
| 2023-04-24 | DX | Futures | 99.159 | 99.34 | 98.773 | 98.791 | 11947.0 |
| 2023-04-24 | E1 | Futures | 1.2078 | 1.21418 | 1.20711 | 1.21369 | 16502.0 |
| 2023-04-24 | E6 | Futures | 1.13355 | 1.13983 | 1.13114 | 1.13947 | 157609.0 |
| 2023-04-24 | E7 | Futures | 1.1336 | 1.1392 | 1.1307 | 1.139 | 6063.0 |
| 2023-04-24 | EBM | Futures | 359.61 | 364.79 | 355.91 | 362.57 | 26063.0 |
| 2023-04-24 | ER | Futures | 97.848 | 97.858 | 97.797 | 97.818 | 128147.0 |
| 2023-04-24 | ESG | Futures | 390.88 | 393.52 | 390.75 | 392.83 | 689.0 |
| 2023-04-24 | EW | Futures | 2676.3 | 2693.6 | 2664.3 | 2681.3 | 8831.0 |
| 2023-04-24 | FBON | Futures | 120.71 | 120.85 | 120.26 | 120.51 | 55.0 |
| 2023-04-24 | FBTP | Futures | 110.78 | 111.06 | 110.13 | 110.5 | 112757.0 |
| 2023-04-24 | FBTS | Futures | 106.057 | 106.148 | 105.865 | 105.986 | 58176.0 |
| 2023-04-24 | FCE | Futures | 8178.9 | 8201.8 | 8161.0 | 8193.7 | 34805.0 |
| 2023-04-24 | FDAX | Futures | 17079.0 | 17123.8 | 17026.7 | 17057.7 | 41294.0 |
| 2023-04-24 | FDIV | Futures | 188.41 | 188.41 | 188.3 | 188.3 | 7.0 |
| 2023-04-24 | FDXM | Futures | 17232.1 | 17266.5 | 17170.8 | 17203.0 | 22650.0 |
| 2023-04-24 | FDXS | Futures | 17120.7 | 17150.6 | 17055.5 | 17087.5 | 12378.0 |
| 2023-04-24 | FESX | Futures | 4446.7 | 4456.9 | 4432.4 | 4444.6 | 549886.0 |
| 2023-04-24 | FEU3 | Futures | 97.828 | 97.828 | 97.828 | 97.828 | 0.0 |
| 2023-04-24 | FGBL | Futures | 134.43 | 134.93 | 134.0 | 134.41 | 543473.0 |
| 2023-04-24 | FGBM | Futures | 118.75 | 119.01 | 118.44 | 118.68 | 488043.0 |
| 2023-04-24 | FGBS | Futures | 107.888 | 107.99 | 107.749 | 107.841 | 305802.0 |
| 2023-04-24 | FGBX | Futures | 138.27 | 139.6 | 137.86 | 138.54 | 47056.0 |
| 2023-04-24 | FMWO | Futures | 9900.7 | 9943.6 | 9881.5 | 9909.7 | 2666.0 |
| 2023-04-24 | FOAT | Futures | 125.43 | 125.87 | 125.01 | 125.38 | 131367.0 |
| 2023-04-24 | FSMX | Futures | 29449.9 | 29647.4 | 29449.9 | 29461.5 | 323.0 |
| 2023-04-24 | FTDX | Futures | 3543.9 | 3561.0 | 3540.1 | 3548.1 | 16.0 |
| 2023-04-24 | FTI | Futures | 799.48 | 804.93 | 799.16 | 802.68 | 8725.0 |
| 2023-04-24 | FTUK | Futures | 8059.1 | 8080.0 | 8027.0 | 8064.7 | 62023.0 |
> showing 50 of 130 rows — these rows as CSV