PREVIEW / futures_daily / 2024-03-20
file: by_date/futures_daily/2024/2024-03-20.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 |
|---|---|---|---|---|---|---|---|
| 2024-03-20 | ES | Futures | 5474.09 | 5534.69 | 5467.04 | 5523.2 | 1404974.0 |
| 2024-03-20 | NQ | Futures | 19190.7 | 19475.29 | 19141.87 | 19406.77 | 618809.0 |
| 2024-03-20 | YM | Futures | 40702.1 | 41158.1 | 40578.6 | 41108.7 | 157550.0 |
| 2024-03-20 | CL | Futures | 73.96 | 74.07 | 72.43 | 72.83 | 351161.0 |
| 2024-03-20 | GC | Futures | 2279.1 | 2311.5 | 2269.5 | 2278.6 | 233572.0 |
| 2024-03-20 | ZN | Futures | 110.922348 | 111.473105 | 110.827933 | 111.221331 | 1804600.0 |
| 2024-03-20 | A6 | Futures | 0.65677 | 0.66234 | 0.65476 | 0.66138 | 101886.0 |
| 2024-03-20 | AD | Futures | 0.74223 | 0.74686 | 0.74007 | 0.74616 | 104812.0 |
| 2024-03-20 | ALI | Futures | 2477.88 | 2494.35 | 2471.83 | 2480.07 | 5672.0 |
| 2024-03-20 | B | Futures | 81.26 | 81.45 | 79.81 | 80.14 | 386301.0 |
| 2024-03-20 | B6 | Futures | 1.2722 | 1.2788 | 1.2686 | 1.2782 | 94891.0 |
| 2024-03-20 | BFX | Futures | 3681.7 | 3681.7 | 3681.7 | 3681.7 | 0.0 |
| 2024-03-20 | BR | Futures | 0.19335 | 0.19335 | 0.19335 | 0.19335 | 0.0 |
| 2024-03-20 | BTC | Futures | 79239.5 | 84046.0 | 75396.8 | 81537.8 | 13914.0 |
| 2024-03-20 | BZ | Futures | 80.33 | 80.45 | 78.82 | 79.16 | 35304.0 |
| 2024-03-20 | C | Futures | 5871.0 | 6094.0 | 5690.0 | 6073.0 | 8061.0 |
| 2024-03-20 | CB | Futures | 288.715 | 290.111 | 288.715 | 288.715 | 13.0 |
| 2024-03-20 | CC | Futures | 4640.0 | 4939.0 | 4521.0 | 4877.0 | 23723.0 |
| 2024-03-20 | CNH | Futures | 7.0334 | 7.0373 | 7.0255 | 7.0275 | 419.0 |
| 2024-03-20 | CSC | Futures | 1.68 | 1.68 | 1.649 | 1.66 | 173.0 |
| 2024-03-20 | CT | Futures | 112.25 | 112.31 | 110.31 | 110.76 | 16312.0 |
| 2024-03-20 | DC | Futures | 16.16 | 16.26 | 15.88 | 15.98 | 237.0 |
| 2024-03-20 | DX | Futures | 102.779 | 103.057 | 102.283 | 102.298 | 21292.0 |
| 2024-03-20 | E1 | Futures | 1.16861 | 1.1718 | 1.16394 | 1.17103 | 31992.0 |
| 2024-03-20 | E6 | Futures | 1.1008 | 1.10665 | 1.09787 | 1.10584 | 233289.0 |
| 2024-03-20 | E7 | Futures | 1.1006 | 1.1065 | 1.0977 | 1.1057 | 4618.0 |
| 2024-03-20 | EBM | Futures | 257.4 | 258.05 | 254.49 | 257.4 | 31652.0 |
| 2024-03-20 | ER | Futures | 97.518 | 97.548 | 97.518 | 97.523 | 175902.0 |
| 2024-03-20 | ESG | Futures | 462.54 | 466.72 | 461.66 | 466.62 | 858.0 |
| 2024-03-20 | EW | Futures | 3044.7 | 3094.2 | 3036.1 | 3086.1 | 12180.0 |
| 2024-03-20 | FBON | Futures | 123.37 | 123.78 | 123.12 | 123.41 | 81.0 |
| 2024-03-20 | FBTP | Futures | 117.89 | 118.11 | 117.48 | 117.67 | 213287.0 |
| 2024-03-20 | FBTS | Futures | 106.463 | 106.483 | 106.312 | 106.363 | 142200.0 |
| 2024-03-20 | FCE | Futures | 8408.8 | 8502.0 | 8392.3 | 8437.1 | 42472.0 |
| 2024-03-20 | FDAX | Futures | 18898.9 | 19052.9 | 18844.2 | 18908.2 | 45822.0 |
| 2024-03-20 | FDIV | Futures | 187.7 | 188.4 | 187.7 | 187.9 | 12.0 |
| 2024-03-20 | FDXM | Futures | 18773.1 | 18924.0 | 18717.7 | 18780.3 | 35302.0 |
| 2024-03-20 | FDXS | Futures | 18659.9 | 18820.2 | 18615.0 | 18677.2 | 17091.0 |
| 2024-03-20 | FESX | Futures | 4997.1 | 5049.5 | 4981.9 | 5004.1 | 724481.0 |
| 2024-03-20 | FEU3 | Futures | 97.543 | 97.543 | 97.533 | 97.533 | 714.0 |
| 2024-03-20 | FGBL | Futures | 133.89 | 134.29 | 133.69 | 133.96 | 911529.0 |
| 2024-03-20 | FGBM | Futures | 117.78 | 117.97 | 117.69 | 117.76 | 659151.0 |
| 2024-03-20 | FGBS | Futures | 106.662 | 106.738 | 106.627 | 106.642 | 612417.0 |
| 2024-03-20 | FGBX | Futures | 134.25 | 135.31 | 133.66 | 134.72 | 117758.0 |
| 2024-03-20 | FMWO | Futures | 11513.7 | 11637.8 | 11498.7 | 11522.2 | 2083.0 |
| 2024-03-20 | FOAT | Futures | 126.55 | 126.91 | 126.3 | 126.58 | 217416.0 |
| 2024-03-20 | FSMX | Futures | 26996.4 | 27178.6 | 26758.6 | 26927.6 | 372.0 |
| 2024-03-20 | FTDX | Futures | 3501.5 | 3501.5 | 3501.5 | 3501.5 | 0.0 |
| 2024-03-20 | FTI | Futures | 883.3 | 890.51 | 881.15 | 882.83 | 9057.0 |
| 2024-03-20 | FTUK | Futures | 7769.2 | 7818.9 | 7748.7 | 7780.8 | 63083.0 |
> showing 50 of 130 rows — these rows as CSV