PREVIEW / futures_daily / 2023-07-24
file: by_date/futures_daily/2023/2023-07-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-07-24 | ES | Futures | 4942.86 | 4973.45 | 4938.26 | 4963.7 | 1203661.0 |
| 2023-07-24 | NQ | Futures | 17020.94 | 17089.6 | 16941.89 | 17026.68 | 561877.0 |
| 2023-07-24 | YM | Futures | 37618.5 | 37874.6 | 37569.6 | 37814.0 | 127732.0 |
| 2023-07-24 | CL | Futures | 66.72 | 68.69 | 66.23 | 68.22 | 368285.0 |
| 2023-07-24 | GC | Futures | 2158.6 | 2165.5 | 2149.5 | 2157.1 | 197213.0 |
| 2023-07-24 | ZN | Futures | 114.249123 | 114.551285 | 113.867444 | 114.058284 | 1148885.0 |
| 2023-07-24 | A6 | Futures | 0.68307 | 0.68555 | 0.6814 | 0.68418 | 87880.0 |
| 2023-07-24 | AD | Futures | 0.76487 | 0.76896 | 0.76446 | 0.76795 | 55273.0 |
| 2023-07-24 | ALI | Futures | 2453.01 | 2462.23 | 2427.86 | 2456.92 | 1969.0 |
| 2023-07-24 | B | Futures | 70.92 | 72.86 | 70.46 | 72.49 | 295103.0 |
| 2023-07-24 | B6 | Futures | 1.2886 | 1.291 | 1.2824 | 1.2851 | 79569.0 |
| 2023-07-24 | BFX | Futures | 4177.3 | 4177.3 | 4177.3 | 4177.3 | 0.0 |
| 2023-07-24 | BR | Futures | 0.19394 | 0.19595 | 0.19329 | 0.19571 | 6857.0 |
| 2023-07-24 | BTC | Futures | 40083.5 | 40341.8 | 38580.0 | 38917.8 | 3844.0 |
| 2023-07-24 | BZ | Futures | 70.83 | 72.73 | 70.33 | 72.36 | 28032.0 |
| 2023-07-24 | C | Futures | 2156.0 | 2167.0 | 2145.0 | 2162.0 | 4612.0 |
| 2023-07-24 | CB | Futures | 243.236 | 244.784 | 243.236 | 244.784 | 53.0 |
| 2023-07-24 | CC | Futures | 1977.0 | 1986.0 | 1966.0 | 1981.0 | 13588.0 |
| 2023-07-24 | CNH | Futures | 6.8839 | 6.9088 | 6.8839 | 6.889 | 282.0 |
| 2023-07-24 | CSC | Futures | 2.011 | 2.074 | 2.011 | 2.074 | 297.0 |
| 2023-07-24 | CT | Futures | 105.64 | 106.94 | 105.64 | 106.66 | 68.0 |
| 2023-07-24 | DC | Futures | 18.48 | 19.17 | 18.39 | 19.17 | 826.0 |
| 2023-07-24 | DX | Futures | 98.806 | 99.243 | 98.718 | 99.167 | 14265.0 |
| 2023-07-24 | E1 | Futures | 1.23253 | 1.23529 | 1.22654 | 1.22914 | 14250.0 |
| 2023-07-24 | E6 | Futures | 1.14207 | 1.14386 | 1.13496 | 1.13608 | 197409.0 |
| 2023-07-24 | E7 | Futures | 1.1417 | 1.1439 | 1.1351 | 1.1362 | 4704.0 |
| 2023-07-24 | EBM | Futures | 375.27 | 388.81 | 374.17 | 387.72 | 53639.0 |
| 2023-07-24 | ER | Futures | 97.812 | 97.843 | 97.807 | 97.833 | 140656.0 |
| 2023-07-24 | ESG | Futures | 429.45 | 431.64 | 429.45 | 430.77 | 308.0 |
| 2023-07-24 | EW | Futures | 2879.3 | 2897.7 | 2871.9 | 2881.4 | 9651.0 |
| 2023-07-24 | FBON | Futures | 122.26 | 123.05 | 122.21 | 122.77 | 71.0 |
| 2023-07-24 | FBTP | Futures | 114.05 | 114.94 | 113.94 | 114.74 | 106778.0 |
| 2023-07-24 | FBTS | Futures | 106.068 | 106.31 | 106.027 | 106.229 | 104382.0 |
| 2023-07-24 | FCE | Futures | 8049.6 | 8068.5 | 8017.7 | 8058.8 | 36365.0 |
| 2023-07-24 | FDAX | Futures | 17210.8 | 17258.4 | 17151.5 | 17234.1 | 44300.0 |
| 2023-07-24 | FDIV | Futures | 189.24 | 189.24 | 189.24 | 189.24 | 0.0 |
| 2023-07-24 | FDXM | Futures | 17273.8 | 17324.8 | 17222.8 | 17304.6 | 32539.0 |
| 2023-07-24 | FDXS | Futures | 17180.0 | 17213.8 | 17111.4 | 17193.8 | 17997.0 |
| 2023-07-24 | FESX | Futures | 4469.5 | 4469.5 | 4442.1 | 4464.4 | 494708.0 |
| 2023-07-24 | FEU3 | Futures | 97.827 | 97.827 | 97.827 | 97.827 | 0.0 |
| 2023-07-24 | FGBL | Futures | 134.79 | 135.69 | 134.64 | 135.4 | 587823.0 |
| 2023-07-24 | FGBM | Futures | 118.4 | 118.87 | 118.33 | 118.72 | 500207.0 |
| 2023-07-24 | FGBS | Futures | 107.366 | 107.514 | 107.335 | 107.468 | 331796.0 |
| 2023-07-24 | FGBX | Futures | 139.78 | 141.72 | 139.49 | 140.7 | 57576.0 |
| 2023-07-24 | FMWO | Futures | 10574.7 | 10630.6 | 10574.7 | 10619.4 | 2111.0 |
| 2023-07-24 | FOAT | Futures | 125.99 | 126.81 | 125.81 | 126.56 | 126760.0 |
| 2023-07-24 | FSMX | Futures | 29460.1 | 29574.5 | 29420.6 | 29453.9 | 553.0 |
| 2023-07-24 | FTDX | Futures | 3427.1 | 3432.4 | 3422.4 | 3427.1 | 67.0 |
| 2023-07-24 | FTI | Futures | 809.53 | 811.32 | 806.38 | 808.97 | 11638.0 |
| 2023-07-24 | FTUK | Futures | 7781.0 | 7804.9 | 7734.3 | 7800.8 | 75899.0 |
> showing 50 of 130 rows — these rows as CSV