PREVIEW / futures_daily / 2023-08-21
file: by_date/futures_daily/2023/2023-08-21.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-08-21 | ES | Futures | 4746.03 | 4787.72 | 4734.93 | 4778.52 | 1361470.0 |
| 2023-08-21 | NQ | Futures | 16152.71 | 16427.62 | 16106.76 | 16396.99 | 641685.0 |
| 2023-08-21 | YM | Futures | 36734.3 | 36887.3 | 36461.1 | 36690.7 | 144074.0 |
| 2023-08-21 | CL | Futures | 70.59 | 71.45 | 69.9 | 70.03 | 361842.0 |
| 2023-08-21 | GC | Futures | 2065.5 | 2075.7 | 2060.3 | 2070.5 | 138109.0 |
| 2023-08-21 | ZN | Futures | 111.593276 | 111.640986 | 110.909435 | 111.020758 | 1514677.0 |
| 2023-08-21 | A6 | Futures | 0.64954 | 0.65101 | 0.64761 | 0.6505 | 59639.0 |
| 2023-08-21 | AD | Futures | 0.74592 | 0.74895 | 0.74466 | 0.74612 | 54577.0 |
| 2023-08-21 | ALI | Futures | 2371.94 | 2372.22 | 2335.0 | 2362.29 | 1164.0 |
| 2023-08-21 | B | Futures | 75.05 | 75.98 | 74.61 | 74.75 | 289239.0 |
| 2023-08-21 | B6 | Futures | 1.2756 | 1.2792 | 1.2735 | 1.2788 | 71139.0 |
| 2023-08-21 | BFX | Futures | 3950.6 | 3950.6 | 3950.6 | 3950.6 | 0.0 |
| 2023-08-21 | BR | Futures | 0.18714 | 0.18756 | 0.18616 | 0.18676 | 8359.0 |
| 2023-08-21 | BTC | Futures | 34698.8 | 34731.9 | 34169.0 | 34526.6 | 7374.0 |
| 2023-08-21 | BZ | Futures | 75.04 | 75.76 | 74.38 | 74.51 | 27958.0 |
| 2023-08-21 | C | Futures | 2259.0 | 2270.0 | 2255.0 | 2258.0 | 1354.0 |
| 2023-08-21 | CB | Futures | 257.166 | 260.024 | 257.166 | 260.024 | 10.0 |
| 2023-08-21 | CC | Futures | 2004.0 | 2029.0 | 1995.0 | 2012.0 | 17994.0 |
| 2023-08-21 | CNH | Futures | 7.0196 | 7.0534 | 7.0112 | 7.0147 | 3407.0 |
| 2023-08-21 | CSC | Futures | 2.09 | 2.137 | 2.086 | 2.124 | 374.0 |
| 2023-08-21 | CT | Futures | 106.61 | 106.65 | 105.27 | 105.27 | 2.0 |
| 2023-08-21 | DC | Futures | 19.21 | 19.78 | 19.21 | 19.65 | 1402.0 |
| 2023-08-21 | DX | Futures | 101.313 | 101.45 | 101.097 | 101.25 | 12438.0 |
| 2023-08-21 | E1 | Futures | 1.2058 | 1.21169 | 1.20527 | 1.2111 | 12828.0 |
| 2023-08-21 | E6 | Futures | 1.11434 | 1.11843 | 1.11382 | 1.11679 | 120744.0 |
| 2023-08-21 | E7 | Futures | 1.1144 | 1.1185 | 1.114 | 1.1168 | 2837.0 |
| 2023-08-21 | EBM | Futures | 340.12 | 340.49 | 333.9 | 335.73 | 8534.0 |
| 2023-08-21 | ER | Futures | 97.822 | 97.822 | 97.802 | 97.802 | 59137.0 |
| 2023-08-21 | ESG | Futures | 412.03 | 415.55 | 410.84 | 414.98 | 529.0 |
| 2023-08-21 | EW | Futures | 2733.2 | 2746.5 | 2713.2 | 2734.5 | 13013.0 |
| 2023-08-21 | FBON | Futures | 119.83 | 120.23 | 119.54 | 119.54 | 63.0 |
| 2023-08-21 | FBTP | Futures | 111.76 | 112.25 | 111.35 | 111.41 | 83370.0 |
| 2023-08-21 | FBTS | Futures | 105.936 | 106.078 | 105.926 | 105.936 | 79043.0 |
| 2023-08-21 | FCE | Futures | 7775.3 | 7874.3 | 7764.0 | 7807.3 | 50347.0 |
| 2023-08-21 | FDAX | Futures | 16555.5 | 16678.3 | 16518.5 | 16549.2 | 48541.0 |
| 2023-08-21 | FDIV | Futures | 181.73 | 181.73 | 181.73 | 181.73 | 0.0 |
| 2023-08-21 | FDXM | Futures | 16623.3 | 16746.6 | 16586.1 | 16616.9 | 38239.0 |
| 2023-08-21 | FDXS | Futures | 16527.4 | 16638.3 | 16480.9 | 16510.5 | 19000.0 |
| 2023-08-21 | FESX | Futures | 4288.1 | 4330.7 | 4277.0 | 4290.1 | 656944.0 |
| 2023-08-21 | FEU3 | Futures | 97.797 | 97.797 | 97.797 | 97.797 | 0.0 |
| 2023-08-21 | FGBL | Futures | 132.94 | 133.06 | 132.1 | 132.16 | 457446.0 |
| 2023-08-21 | FGBM | Futures | 118.02 | 118.05 | 117.6 | 117.64 | 465769.0 |
| 2023-08-21 | FGBS | Futures | 107.412 | 107.427 | 107.289 | 107.305 | 276669.0 |
| 2023-08-21 | FGBX | Futures | 132.93 | 133.3 | 130.88 | 130.98 | 53451.0 |
| 2023-08-21 | FMWO | Futures | 10077.0 | 10173.2 | 10075.9 | 10088.2 | 4787.0 |
| 2023-08-21 | FOAT | Futures | 124.14 | 124.22 | 123.32 | 123.37 | 125642.0 |
| 2023-08-21 | FSMX | Futures | 28354.4 | 28412.6 | 28176.5 | 28185.9 | 201.0 |
| 2023-08-21 | FTDX | Futures | 3247.5 | 3247.5 | 3223.9 | 3223.9 | 6.0 |
| 2023-08-21 | FTI | Futures | 768.31 | 774.0 | 765.44 | 766.6 | 11475.0 |
| 2023-08-21 | FTUK | Futures | 7391.8 | 7444.7 | 7376.1 | 7383.7 | 75998.0 |
> showing 50 of 130 rows — these rows as CSV