PREVIEW / futures_daily / 2024-10-17
file: by_date/futures_daily/2024/2024-10-17.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-10-17 | ES | Futures | 6018.31 | 6063.83 | 6006.54 | 6022.66 | 1236083.0 |
| 2024-10-17 | NQ | Futures | 20850.77 | 21124.38 | 20798.21 | 20891.8 | 535486.0 |
| 2024-10-17 | YM | Futures | 43796.5 | 44007.7 | 43708.6 | 43968.3 | 105205.0 |
| 2024-10-17 | CL | Futures | 67.85 | 68.26 | 66.67 | 67.84 | 228841.0 |
| 2024-10-17 | GC | Futures | 2747.0 | 2769.8 | 2744.8 | 2764.5 | 181816.0 |
| 2024-10-17 | ZN | Futures | 112.689039 | 112.704684 | 112.141474 | 112.188408 | 1877074.0 |
| 2024-10-17 | A6 | Futures | 0.66669 | 0.67119 | 0.66604 | 0.66964 | 90981.0 |
| 2024-10-17 | AD | Futures | 0.73 | 0.7303 | 0.72744 | 0.72754 | 67800.0 |
| 2024-10-17 | ALI | Futures | 2618.66 | 2635.8 | 2578.75 | 2591.54 | 7205.0 |
| 2024-10-17 | B | Futures | 73.81 | 74.26 | 72.61 | 73.79 | 298428.0 |
| 2024-10-17 | B6 | Futures | 1.2983 | 1.3018 | 1.2969 | 1.3003 | 90024.0 |
| 2024-10-17 | BFX | Futures | 4351.8 | 4351.8 | 4351.8 | 4351.8 | 0.0 |
| 2024-10-17 | BR | Futures | 0.17113 | 0.17137 | 0.17054 | 0.17113 | 40.0 |
| 2024-10-17 | BTC | Futures | 74106.9 | 74478.5 | 72964.9 | 73117.9 | 7484.0 |
| 2024-10-17 | BZ | Futures | 72.27 | 72.67 | 71.06 | 72.22 | 36901.0 |
| 2024-10-17 | C | Futures | 5613.0 | 5825.0 | 5507.0 | 5707.0 | 2568.0 |
| 2024-10-17 | CB | Futures | 286.319 | 290.313 | 286.319 | 288.783 | 47.0 |
| 2024-10-17 | CC | Futures | 6289.0 | 6485.0 | 6132.0 | 6364.0 | 7812.0 |
| 2024-10-17 | CNH | Futures | 7.0777 | 7.0866 | 7.0667 | 7.0796 | 1631.0 |
| 2024-10-17 | CSC | Futures | 2.176 | 2.214 | 2.176 | 2.206 | 253.0 |
| 2024-10-17 | CT | Futures | 78.14 | 78.38 | 76.91 | 77.57 | 23989.0 |
| 2024-10-17 | DC | Futures | 21.18 | 21.55 | 21.18 | 21.45 | 432.0 |
| 2024-10-17 | DX | Futures | 103.063 | 103.412 | 102.973 | 103.369 | 18476.0 |
| 2024-10-17 | E1 | Futures | 1.17438 | 1.17716 | 1.17176 | 1.17196 | 21892.0 |
| 2024-10-17 | E6 | Futures | 1.09344 | 1.09464 | 1.08832 | 1.08972 | 212112.0 |
| 2024-10-17 | E7 | Futures | 1.0931 | 1.0942 | 1.088 | 1.0894 | 4567.0 |
| 2024-10-17 | EBM | Futures | 249.44 | 251.9 | 247.8 | 251.63 | 26616.0 |
| 2024-10-17 | ER | Futures | 97.704 | 97.785 | 97.694 | 97.765 | 524116.0 |
| 2024-10-17 | ESG | Futures | 520.7 | 522.67 | 519.02 | 519.28 | 323.0 |
| 2024-10-17 | EW | Futures | 3249.0 | 3262.7 | 3241.2 | 3252.5 | 8568.0 |
| 2024-10-17 | FBON | Futures | 126.16 | 126.47 | 126.03 | 126.22 | 194.0 |
| 2024-10-17 | FBTP | Futures | 121.2 | 121.61 | 121.07 | 121.37 | 289303.0 |
| 2024-10-17 | FBTS | Futures | 107.51 | 107.65 | 107.45 | 107.58 | 170683.0 |
| 2024-10-17 | FCE | Futures | 7508.2 | 7645.2 | 7508.2 | 7601.7 | 56190.0 |
| 2024-10-17 | FDAX | Futures | 19775.8 | 19994.9 | 19750.5 | 19901.0 | 38710.0 |
| 2024-10-17 | FDIV | Futures | 195.03 | 195.03 | 195.03 | 195.03 | 0.0 |
| 2024-10-17 | FDXM | Futures | 19740.0 | 19951.6 | 19707.8 | 19857.9 | 24556.0 |
| 2024-10-17 | FDXS | Futures | 19695.8 | 19906.9 | 19662.6 | 19813.4 | 24550.0 |
| 2024-10-17 | FESX | Futures | 4940.9 | 5001.0 | 4928.9 | 4975.0 | 737743.0 |
| 2024-10-17 | FEU3 | Futures | 97.704 | 97.765 | 97.699 | 97.765 | 3645.0 |
| 2024-10-17 | FGBL | Futures | 135.83 | 135.92 | 135.46 | 135.58 | 1187285.0 |
| 2024-10-17 | FGBM | Futures | 118.78 | 118.9 | 118.59 | 118.74 | 886250.0 |
| 2024-10-17 | FGBS | Futures | 107.189 | 107.285 | 107.124 | 107.235 | 920102.0 |
| 2024-10-17 | FGBX | Futures | 135.65 | 135.67 | 134.4 | 134.54 | 109542.0 |
| 2024-10-17 | FMWO | Futures | 12357.2 | 12418.3 | 12342.7 | 12375.9 | 8283.0 |
| 2024-10-17 | FOAT | Futures | 126.1 | 126.2 | 125.73 | 125.9 | 243291.0 |
| 2024-10-17 | FSMX | Futures | 27245.0 | 27372.1 | 27245.0 | 27308.0 | 122.0 |
| 2024-10-17 | FTDX | Futures | 3496.8 | 3496.8 | 3482.6 | 3491.2 | 2.0 |
| 2024-10-17 | FTI | Futures | 900.22 | 909.7 | 898.65 | 906.24 | 10255.0 |
| 2024-10-17 | FTUK | Futures | 8409.5 | 8451.1 | 8372.0 | 8443.6 | 91317.0 |
> showing 50 of 130 rows — these rows as CSV