PREVIEW / futures_daily / 2023-12-18
file: by_date/futures_daily/2023/2023-12-18.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-12-18 | ES | Futures | 5049.92 | 5083.53 | 5048.86 | 5073.74 | 1139029.0 |
| 2023-12-18 | NQ | Futures | 17921.48 | 18085.3 | 17902.3 | 18048.81 | 463438.0 |
| 2023-12-18 | YM | Futures | 39236.0 | 39352.7 | 39221.5 | 39254.8 | 93800.0 |
| 2023-12-18 | CL | Futures | 63.93 | 66.2 | 62.99 | 64.61 | 354885.0 |
| 2023-12-18 | GC | Futures | 2167.6 | 2183.3 | 2163.5 | 2175.3 | 141406.0 |
| 2023-12-18 | ZN | Futures | 113.904203 | 114.094069 | 113.60358 | 113.666869 | 1111902.0 |
| 2023-12-18 | A6 | Futures | 0.6759 | 0.67927 | 0.6748 | 0.6759 | 65160.0 |
| 2023-12-18 | AD | Futures | 0.75376 | 0.75527 | 0.75189 | 0.75285 | 72878.0 |
| 2023-12-18 | ALI | Futures | 2443.2 | 2500.25 | 2439.91 | 2494.49 | 7362.0 |
| 2023-12-18 | B | Futures | 70.19 | 72.67 | 69.24 | 71.24 | 279466.0 |
| 2023-12-18 | B6 | Futures | 1.2685 | 1.2712 | 1.2637 | 1.2648 | 58275.0 |
| 2023-12-18 | BFX | Futures | 3786.3 | 3786.3 | 3786.3 | 3786.3 | 0.0 |
| 2023-12-18 | BR | Futures | 0.18928 | 0.19256 | 0.18928 | 0.19256 | 1.0 |
| 2023-12-18 | BTC | Futures | 54141.5 | 55490.2 | 52534.7 | 54341.6 | 6931.0 |
| 2023-12-18 | BZ | Futures | 69.74 | 72.04 | 68.66 | 70.63 | 30258.0 |
| 2023-12-18 | C | Futures | 2953.0 | 2977.0 | 2937.0 | 2956.0 | 6870.0 |
| 2023-12-18 | CB | Futures | 254.145 | 255.772 | 254.145 | 255.772 | 40.0 |
| 2023-12-18 | CC | Futures | 2462.0 | 2492.0 | 2454.0 | 2471.0 | 18493.0 |
| 2023-12-18 | CNH | Futures | 6.9134 | 6.9236 | 6.9056 | 6.9236 | 959.0 |
| 2023-12-18 | CSC | Futures | 1.764 | 1.768 | 1.731 | 1.732 | 189.0 |
| 2023-12-18 | CT | Futures | 96.19 | 96.33 | 95.04 | 95.1 | 17264.0 |
| 2023-12-18 | DC | Futures | 16.77 | 16.79 | 16.47 | 16.47 | 347.0 |
| 2023-12-18 | DX | Futures | 101.164 | 101.248 | 100.981 | 101.151 | 8319.0 |
| 2023-12-18 | E1 | Futures | 1.20563 | 1.20963 | 1.20345 | 1.20724 | 13267.0 |
| 2023-12-18 | E6 | Futures | 1.10806 | 1.11176 | 1.10776 | 1.11019 | 165281.0 |
| 2023-12-18 | E7 | Futures | 1.1067 | 1.1113 | 1.1067 | 1.1099 | 3763.0 |
| 2023-12-18 | EBM | Futures | 293.85 | 296.16 | 293.52 | 295.5 | 21674.0 |
| 2023-12-18 | ER | Futures | 97.812 | 97.858 | 97.802 | 97.807 | 186938.0 |
| 2023-12-18 | ESG | Futures | 428.12 | 429.96 | 428.12 | 429.47 | 702.0 |
| 2023-12-18 | EW | Futures | 2875.1 | 2886.7 | 2867.7 | 2873.8 | 13019.0 |
| 2023-12-18 | FBON | Futures | 125.94 | 126.33 | 125.59 | 125.67 | 156.0 |
| 2023-12-18 | FBTP | Futures | 117.71 | 118.34 | 117.53 | 117.64 | 125641.0 |
| 2023-12-18 | FBTS | Futures | 107.271 | 107.412 | 107.261 | 107.342 | 88092.0 |
| 2023-12-18 | FCE | Futures | 8041.4 | 8041.4 | 7998.6 | 8021.3 | 39798.0 |
| 2023-12-18 | FDAX | Futures | 17727.7 | 17738.2 | 17608.3 | 17629.2 | 42113.0 |
| 2023-12-18 | FDIV | Futures | 181.76 | 181.76 | 180.98 | 181.13 | 16.0 |
| 2023-12-18 | FDXM | Futures | 17595.3 | 17604.6 | 17475.7 | 17496.5 | 25001.0 |
| 2023-12-18 | FDXS | Futures | 17466.9 | 17489.7 | 17360.6 | 17381.2 | 13263.0 |
| 2023-12-18 | FESX | Futures | 4563.1 | 4567.1 | 4532.2 | 4541.1 | 544281.0 |
| 2023-12-18 | FEU3 | Futures | 97.843 | 97.848 | 97.812 | 97.812 | 5113.0 |
| 2023-12-18 | FGBL | Futures | 138.97 | 139.26 | 138.35 | 138.5 | 591294.0 |
| 2023-12-18 | FGBM | Futures | 120.76 | 120.96 | 120.55 | 120.64 | 470071.0 |
| 2023-12-18 | FGBS | Futures | 107.961 | 108.048 | 107.906 | 107.926 | 458243.0 |
| 2023-12-18 | FGBX | Futures | 146.01 | 146.54 | 143.89 | 144.32 | 74539.0 |
| 2023-12-18 | FMWO | Futures | 10768.7 | 10798.2 | 10751.3 | 10782.9 | 6888.0 |
| 2023-12-18 | FOAT | Futures | 130.4 | 130.74 | 129.87 | 129.99 | 113349.0 |
| 2023-12-18 | FSMX | Futures | 28080.9 | 28080.9 | 27718.1 | 27794.7 | 148.0 |
| 2023-12-18 | FTDX | Futures | 3272.2 | 3460.3 | 3272.2 | 3437.7 | 40.0 |
| 2023-12-18 | FTI | Futures | 816.02 | 818.03 | 812.38 | 813.86 | 9507.0 |
| 2023-12-18 | FTUK | Futures | 7617.3 | 7687.6 | 7608.3 | 7675.0 | 81037.0 |
> showing 50 of 130 rows — these rows as CSV