PREVIEW / futures_daily / 2024-09-16
file: by_date/futures_daily/2024/2024-09-16.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-09-16 | ES | Futures | 5814.98 | 5834.16 | 5800.14 | 5830.58 | 1740015.0 |
| 2024-09-16 | NQ | Futures | 20240.47 | 20292.78 | 20031.23 | 20170.98 | 376502.0 |
| 2024-09-16 | YM | Futures | 42240.1 | 42611.3 | 42205.5 | 42482.8 | 91320.0 |
| 2024-09-16 | CL | Futures | 64.89 | 66.21 | 64.39 | 65.65 | 235884.0 |
| 2024-09-16 | GC | Futures | 2662.9 | 2672.5 | 2657.2 | 2663.8 | 127576.0 |
| 2024-09-16 | ZN | Futures | 115.552026 | 115.755408 | 115.442513 | 115.708474 | 1484483.0 |
| 2024-09-16 | A6 | Futures | 0.67159 | 0.67589 | 0.67094 | 0.67484 | 89147.0 |
| 2024-09-16 | AD | Futures | 0.73922 | 0.74052 | 0.73832 | 0.73912 | 73144.0 |
| 2024-09-16 | ALI | Futures | 2465.59 | 2538.62 | 2460.45 | 2522.68 | 2022.0 |
| 2024-09-16 | B | Futures | 70.76 | 72.04 | 70.2 | 71.41 | 232184.0 |
| 2024-09-16 | B6 | Futures | 1.3126 | 1.3216 | 1.3124 | 1.3205 | 77935.0 |
| 2024-09-16 | BFX | Futures | 4273.0 | 4273.0 | 4273.0 | 4273.0 | 0.0 |
| 2024-09-16 | BR | Futures | 0.17513 | 0.17825 | 0.17508 | 0.17542 | 14.0 |
| 2024-09-16 | BTC | Futures | 65975.2 | 65975.2 | 63365.7 | 63844.6 | 9573.0 |
| 2024-09-16 | BZ | Futures | 69.19 | 70.5 | 68.71 | 69.89 | 36417.0 |
| 2024-09-16 | C | Futures | 5288.0 | 5393.0 | 5185.0 | 5291.0 | 8146.0 |
| 2024-09-16 | CB | Futures | 309.636 | 309.636 | 309.636 | 309.636 | 0.0 |
| 2024-09-16 | CC | Futures | 6297.0 | 6428.0 | 6176.0 | 6360.0 | 8493.0 |
| 2024-09-16 | CNH | Futures | 7.0174 | 7.0174 | 7.003 | 7.0094 | 748.0 |
| 2024-09-16 | CSC | Futures | 2.28 | 2.281 | 2.235 | 2.235 | 29.0 |
| 2024-09-16 | CT | Futures | 78.74 | 81.41 | 78.74 | 80.6 | 33.0 |
| 2024-09-16 | DC | Futures | 22.2 | 22.22 | 21.61 | 21.66 | 277.0 |
| 2024-09-16 | DX | Futures | 100.505 | 100.52 | 99.971 | 100.161 | 15177.0 |
| 2024-09-16 | E1 | Futures | 1.20229 | 1.20916 | 1.20159 | 1.20628 | 18157.0 |
| 2024-09-16 | E6 | Futures | 1.11679 | 1.12256 | 1.11649 | 1.1209 | 149913.0 |
| 2024-09-16 | E7 | Futures | 1.1163 | 1.1221 | 1.116 | 1.1205 | 2552.0 |
| 2024-09-16 | EBM | Futures | 245.07 | 245.07 | 240.7 | 240.97 | 35017.0 |
| 2024-09-16 | ER | Futures | 97.609 | 97.624 | 97.594 | 97.609 | 251182.0 |
| 2024-09-16 | ESG | Futures | 502.39 | 502.47 | 500.52 | 502.23 | 2809.0 |
| 2024-09-16 | EW | Futures | 3097.5 | 3120.9 | 3095.7 | 3117.3 | 30067.0 |
| 2024-09-16 | FBON | Futures | 126.12 | 126.38 | 126.01 | 126.24 | 75.0 |
| 2024-09-16 | FBTP | Futures | 120.38 | 120.74 | 120.29 | 120.67 | 281566.0 |
| 2024-09-16 | FBTS | Futures | 107.47 | 107.54 | 107.43 | 107.52 | 89193.0 |
| 2024-09-16 | FCE | Futures | 7489.4 | 7522.0 | 7461.7 | 7482.9 | 20752.0 |
| 2024-09-16 | FDAX | Futures | 19132.4 | 19164.2 | 19029.1 | 19061.9 | 45349.0 |
| 2024-09-16 | FDIV | Futures | 190.64 | 190.64 | 190.64 | 190.64 | 0.0 |
| 2024-09-16 | FDXM | Futures | 19017.6 | 19072.0 | 18921.9 | 18954.1 | 1360.0 |
| 2024-09-16 | FDXS | Futures | 18988.1 | 19011.2 | 18881.5 | 18911.7 | 820.0 |
| 2024-09-16 | FESX | Futures | 4889.8 | 4892.8 | 4857.8 | 4863.8 | 1154561.0 |
| 2024-09-16 | FEU3 | Futures | 97.614 | 97.624 | 97.599 | 97.614 | 1373.0 |
| 2024-09-16 | FGBL | Futures | 136.56 | 136.85 | 136.38 | 136.8 | 768417.0 |
| 2024-09-16 | FGBM | Futures | 119.15 | 119.28 | 119.04 | 119.27 | 520865.0 |
| 2024-09-16 | FGBS | Futures | 107.31 | 107.34 | 107.245 | 107.33 | 475143.0 |
| 2024-09-16 | FGBX | Futures | 137.55 | 138.53 | 137.29 | 138.43 | 61915.0 |
| 2024-09-16 | FMWO | Futures | 12018.6 | 12062.6 | 11991.4 | 12009.2 | 55093.0 |
| 2024-09-16 | FOAT | Futures | 127.18 | 127.31 | 126.98 | 127.23 | 165541.0 |
| 2024-09-16 | FSMX | Futures | 25699.5 | 25699.5 | 25685.4 | 25685.4 | 5.0 |
| 2024-09-16 | FTDX | Futures | 3366.0 | 3366.0 | 3366.0 | 3366.0 | 0.0 |
| 2024-09-16 | FTI | Futures | 909.81 | 910.67 | 905.07 | 906.32 | 3714.0 |
| 2024-09-16 | FTUK | Futures | 8371.0 | 8394.5 | 8326.9 | 8353.4 | 241724.0 |
> showing 50 of 130 rows — these rows as CSV