PREVIEW / futures_daily / 2023-06-22
file: by_date/futures_daily/2023/2023-06-22.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-06-22 | ES | Futures | 4775.81 | 4794.22 | 4757.4 | 4790.7 | 1384002.0 |
| 2023-06-22 | NQ | Futures | 16454.98 | 16672.99 | 16373.19 | 16647.55 | 611017.0 |
| 2023-06-22 | YM | Futures | 36397.4 | 36425.0 | 36235.8 | 36357.0 | 133727.0 |
| 2023-06-22 | CL | Futures | 62.86 | 63.05 | 59.82 | 60.32 | 421348.0 |
| 2023-06-22 | GC | Futures | 2136.3 | 2138.3 | 2112.9 | 2114.8 | 171779.0 |
| 2023-06-22 | ZN | Futures | 115.314642 | 115.457772 | 114.662608 | 114.742124 | 1405552.0 |
| 2023-06-22 | A6 | Futures | 0.69016 | 0.69112 | 0.68484 | 0.68621 | 70504.0 |
| 2023-06-22 | AD | Futures | 0.7686 | 0.77012 | 0.76775 | 0.76967 | 64577.0 |
| 2023-06-22 | ALI | Futures | 2478.14 | 2500.6 | 2448.48 | 2453.47 | 944.0 |
| 2023-06-22 | B | Futures | 68.17 | 68.32 | 65.13 | 65.61 | 329526.0 |
| 2023-06-22 | B6 | Futures | 1.2801 | 1.2897 | 1.2752 | 1.2772 | 112955.0 |
| 2023-06-22 | BFX | Futures | 3926.0 | 3926.0 | 3926.0 | 3926.0 | 0.0 |
| 2023-06-22 | BR | Futures | 0.19357 | 0.19408 | 0.19268 | 0.19292 | 18.0 |
| 2023-06-22 | BTC | Futures | 40025.2 | 40911.8 | 39651.8 | 40491.8 | 10153.0 |
| 2023-06-22 | BZ | Futures | 67.76 | 67.96 | 64.78 | 65.28 | 30975.0 |
| 2023-06-22 | C | Futures | 1967.0 | 1971.0 | 1959.0 | 1965.0 | 1245.0 |
| 2023-06-22 | CB | Futures | 230.021 | 230.497 | 229.568 | 230.497 | 12.0 |
| 2023-06-22 | CC | Futures | 1876.0 | 1876.0 | 1856.0 | 1861.0 | 15951.0 |
| 2023-06-22 | CNH | Futures | 6.8648 | 6.8857 | 6.8539 | 6.8834 | 164.0 |
| 2023-06-22 | CSC | Futures | 1.955 | 1.955 | 1.942 | 1.951 | 137.0 |
| 2023-06-22 | CT | Futures | 100.22 | 101.28 | 98.82 | 100.46 | 4443.0 |
| 2023-06-22 | DC | Futures | 18.28 | 18.32 | 17.89 | 17.99 | 181.0 |
| 2023-06-22 | DX | Futures | 99.738 | 100.15 | 99.562 | 100.061 | 13595.0 |
| 2023-06-22 | E1 | Futures | 1.19875 | 1.2015 | 1.19291 | 1.19434 | 19809.0 |
| 2023-06-22 | E6 | Futures | 1.12933 | 1.13199 | 1.12529 | 1.12641 | 164655.0 |
| 2023-06-22 | E7 | Futures | 1.1294 | 1.132 | 1.1254 | 1.1265 | 4010.0 |
| 2023-06-22 | EBM | Futures | 362.82 | 370.51 | 358.43 | 367.58 | 40512.0 |
| 2023-06-22 | ER | Futures | 97.726 | 97.736 | 97.639 | 97.705 | 131967.0 |
| 2023-06-22 | ESG | Futures | 413.03 | 416.44 | 412.5 | 416.29 | 431.0 |
| 2023-06-22 | EW | Futures | 2730.4 | 2733.3 | 2699.1 | 2713.1 | 8981.0 |
| 2023-06-22 | FBON | Futures | 122.75 | 122.78 | 121.77 | 121.98 | 58.0 |
| 2023-06-22 | FBTP | Futures | 114.81 | 114.81 | 113.64 | 113.8 | 145799.0 |
| 2023-06-22 | FBTS | Futures | 106.058 | 106.088 | 105.755 | 105.805 | 120235.0 |
| 2023-06-22 | FCE | Futures | 7872.7 | 7879.2 | 7791.1 | 7856.4 | 69856.0 |
| 2023-06-22 | FDAX | Futures | 17090.1 | 17091.2 | 16871.0 | 17047.8 | 69937.0 |
| 2023-06-22 | FDIV | Futures | 182.7 | 184.44 | 182.5 | 183.62 | 32.0 |
| 2023-06-22 | FDXM | Futures | 17165.4 | 17165.4 | 16941.1 | 17117.6 | 40127.0 |
| 2023-06-22 | FDXS | Futures | 17045.9 | 17045.9 | 16831.5 | 17007.9 | 21864.0 |
| 2023-06-22 | FESX | Futures | 4400.6 | 4402.6 | 4343.8 | 4384.4 | 837098.0 |
| 2023-06-22 | FEU3 | Futures | 97.695 | 97.695 | 97.695 | 97.695 | 0.0 |
| 2023-06-22 | FGBL | Futures | 135.33 | 135.39 | 134.13 | 134.34 | 747975.0 |
| 2023-06-22 | FGBM | Futures | 118.58 | 118.58 | 117.97 | 118.03 | 569144.0 |
| 2023-06-22 | FGBS | Futures | 107.438 | 107.443 | 107.223 | 107.248 | 414965.0 |
| 2023-06-22 | FGBX | Futures | 141.64 | 141.83 | 139.33 | 140.17 | 76707.0 |
| 2023-06-22 | FMWO | Futures | 10244.8 | 10280.6 | 10220.2 | 10243.7 | 5294.0 |
| 2023-06-22 | FOAT | Futures | 126.68 | 126.75 | 125.46 | 125.68 | 188508.0 |
| 2023-06-22 | FSMX | Futures | 27692.8 | 28217.1 | 27688.7 | 28199.4 | 98.0 |
| 2023-06-22 | FTDX | Futures | 3316.5 | 3351.8 | 3316.5 | 3351.8 | 44.0 |
| 2023-06-22 | FTI | Futures | 793.84 | 800.14 | 790.16 | 799.12 | 15725.0 |
| 2023-06-22 | FTUK | Futures | 7682.4 | 7682.4 | 7586.4 | 7630.6 | 110300.0 |
> showing 50 of 130 rows — these rows as CSV