PREVIEW / futures_daily / 2023-03-20
file: by_date/futures_daily/2023/2023-03-20.parquet size: 10 KB rows: 131
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-03-20 | ES | Futures | 4337.22 | 4365.4 | 4264.46 | 4358.29 | 1818807.0 |
| 2023-03-20 | NQ | Futures | 14067.52 | 14134.03 | 13884.88 | 14065.85 | 694471.0 |
| 2023-03-20 | YM | Futures | 34442.3 | 34836.6 | 33922.6 | 34778.7 | 221270.0 |
| 2023-03-20 | CL | Futures | 58.19 | 59.06 | 55.98 | 58.99 | 418544.0 |
| 2023-03-20 | GC | Futures | 2226.1 | 2254.3 | 2204.0 | 2218.3 | 338016.0 |
| 2023-03-20 | ZN | Futures | 117.921476 | 119.456246 | 117.441861 | 117.761605 | 1980690.0 |
| 2023-03-20 | A6 | Futures | 0.68448 | 0.68626 | 0.67971 | 0.68484 | 84375.0 |
| 2023-03-20 | AD | Futures | 0.73956 | 0.74305 | 0.73789 | 0.74245 | 91008.0 |
| 2023-03-20 | ALI | Futures | 2467.82 | 2503.39 | 2467.82 | 2483.42 | 1389.0 |
| 2023-03-20 | B | Futures | 63.91 | 64.66 | 61.38 | 64.59 | 282569.0 |
| 2023-03-20 | B6 | Futures | 1.2279 | 1.2366 | 1.2244 | 1.236 | 95390.0 |
| 2023-03-20 | BFX | Futures | 3963.9 | 4003.5 | 3963.9 | 4003.5 | 3.0 |
| 2023-03-20 | BR | Futures | 0.16923 | 0.17131 | 0.16923 | 0.17009 | 76.0 |
| 2023-03-20 | BTC | Futures | 38186.1 | 39028.8 | 37132.7 | 37982.2 | 9810.0 |
| 2023-03-20 | BZ | Futures | 63.6 | 64.44 | 61.19 | 64.39 | 22185.0 |
| 2023-03-20 | C | Futures | 1621.0 | 1633.0 | 1611.0 | 1628.0 | 9186.0 |
| 2023-03-20 | CB | Futures | 238.828 | 238.828 | 238.828 | 238.828 | 11.0 |
| 2023-03-20 | CC | Futures | 1559.0 | 1605.0 | 1557.0 | 1599.0 | 33309.0 |
| 2023-03-20 | CNH | Futures | 6.5328 | 6.5571 | 6.5264 | 6.5264 | 798.0 |
| 2023-03-20 | CSC | Futures | 2.328 | 2.344 | 2.3 | 2.3 | 57.0 |
| 2023-03-20 | CT | Futures | 100.79 | 103.24 | 99.59 | 100.29 | 17454.0 |
| 2023-03-20 | DC | Futures | 22.24 | 22.36 | 21.82 | 21.82 | 182.0 |
| 2023-03-20 | DX | Futures | 101.08 | 101.3 | 100.581 | 100.609 | 14828.0 |
| 2023-03-20 | E1 | Futures | 1.17016 | 1.17182 | 1.16234 | 1.16614 | 12130.0 |
| 2023-03-20 | E6 | Futures | 1.10373 | 1.10954 | 1.09926 | 1.10862 | 201241.0 |
| 2023-03-20 | E7 | Futures | 1.1039 | 1.109 | 1.0988 | 1.1081 | 5920.0 |
| 2023-03-20 | EBM | Futures | 388.47 | 389.95 | 381.07 | 381.81 | 35393.0 |
| 2023-03-20 | ED | Futures | 95.145 | 95.41 | 95.005 | 95.08 | 63987.0 |
| 2023-03-20 | ER | Futures | 98.152 | 98.406 | 98.117 | 98.244 | 175274.0 |
| 2023-03-20 | ESG | Futures | 368.19 | 375.92 | 368.19 | 375.53 | 901.0 |
| 2023-03-20 | EW | Futures | 2566.0 | 2616.8 | 2511.6 | 2595.8 | 16215.0 |
| 2023-03-20 | FBON | Futures | 125.14 | 125.28 | 123.63 | 123.87 | 254.0 |
| 2023-03-20 | FBTP | Futures | 114.08 | 114.25 | 113.18 | 113.53 | 215218.0 |
| 2023-03-20 | FBTS | Futures | 106.926 | 107.088 | 106.825 | 106.946 | 145451.0 |
| 2023-03-20 | FCE | Futures | 7408.9 | 7648.0 | 7361.3 | 7598.8 | 87122.0 |
| 2023-03-20 | FDAX | Futures | 16007.0 | 16166.0 | 15591.0 | 16092.4 | 100630.0 |
| 2023-03-20 | FDIV | Futures | 177.05 | 177.05 | 176.79 | 176.79 | 22.0 |
| 2023-03-20 | FDXM | Futures | 16135.9 | 16300.5 | 15723.9 | 16229.5 | 73848.0 |
| 2023-03-20 | FDXS | Futures | 16027.6 | 16191.1 | 15621.5 | 16120.5 | 31315.0 |
| 2023-03-20 | FESX | Futures | 4115.6 | 4172.9 | 3999.2 | 4145.3 | 1416528.0 |
| 2023-03-20 | FEU3 | Futures | 98.234 | 98.234 | 98.234 | 98.234 | 0.0 |
| 2023-03-20 | FGBL | Futures | 138.34 | 141.05 | 137.84 | 138.71 | 979957.0 |
| 2023-03-20 | FGBM | Futures | 120.94 | 122.57 | 120.52 | 121.22 | 709905.0 |
| 2023-03-20 | FGBS | Futures | 108.892 | 109.583 | 108.666 | 109.05 | 772134.0 |
| 2023-03-20 | FGBX | Futures | 149.35 | 154.38 | 148.47 | 149.37 | 86042.0 |
| 2023-03-20 | FMWO | Futures | 9376.3 | 9447.5 | 9210.1 | 9394.4 | 6981.0 |
| 2023-03-20 | FOAT | Futures | 128.44 | 130.5 | 127.93 | 128.98 | 246754.0 |
| 2023-03-20 | FSMX | Futures | 27555.9 | 28420.6 | 26921.4 | 28261.2 | 479.0 |
| 2023-03-20 | FTDX | Futures | 3476.9 | 3476.9 | 3411.6 | 3471.6 | 182.0 |
| 2023-03-20 | FTI | Futures | 753.16 | 776.71 | 753.0 | 772.71 | 27535.0 |
> showing 50 of 131 rows — these rows as CSV