PREVIEW / futures_daily / 2024-01-18
file: by_date/futures_daily/2024/2024-01-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 |
|---|---|---|---|---|---|---|---|
| 2024-01-18 | ES | Futures | 5047.27 | 5099.14 | 5042.51 | 5093.05 | 1746936.0 |
| 2024-01-18 | NQ | Futures | 17957.97 | 18246.98 | 17936.4 | 18230.2 | 852229.0 |
| 2024-01-18 | YM | Futures | 39020.4 | 39286.0 | 38864.1 | 39235.0 | 161810.0 |
| 2024-01-18 | CL | Futures | 64.53 | 65.83 | 63.97 | 65.61 | 396277.0 |
| 2024-01-18 | GC | Futures | 2141.8 | 2159.4 | 2140.3 | 2155.1 | 171928.0 |
| 2024-01-18 | ZN | Futures | 112.828291 | 113.065625 | 112.543491 | 112.60678 | 1703768.0 |
| 2024-01-18 | A6 | Futures | 0.66021 | 0.66242 | 0.6575 | 0.66092 | 104028.0 |
| 2024-01-18 | AD | Futures | 0.74605 | 0.74746 | 0.74454 | 0.74615 | 76064.0 |
| 2024-01-18 | ALI | Futures | 2383.14 | 2411.11 | 2353.52 | 2362.57 | 3936.0 |
| 2024-01-18 | B | Futures | 71.72 | 72.78 | 70.97 | 72.6 | 325286.0 |
| 2024-01-18 | B6 | Futures | 1.2683 | 1.2713 | 1.2654 | 1.2692 | 84096.0 |
| 2024-01-18 | BFX | Futures | 3624.6 | 3624.6 | 3624.6 | 3624.6 | 0.0 |
| 2024-01-18 | BR | Futures | 0.19228 | 0.19228 | 0.19114 | 0.1919 | 435.0 |
| 2024-01-18 | BTC | Futures | 55167.6 | 55425.7 | 52386.3 | 52760.6 | 13037.0 |
| 2024-01-18 | BZ | Futures | 70.88 | 72.01 | 70.23 | 71.83 | 28190.0 |
| 2024-01-18 | C | Futures | 3065.0 | 3103.0 | 3049.0 | 3080.0 | 11204.0 |
| 2024-01-18 | CB | Futures | 260.778 | 260.778 | 259.736 | 260.143 | 58.0 |
| 2024-01-18 | CC | Futures | 2562.0 | 2602.0 | 2555.0 | 2580.0 | 29379.0 |
| 2024-01-18 | CNH | Futures | 7.0137 | 7.0152 | 7.0011 | 7.0074 | 788.0 |
| 2024-01-18 | CSC | Futures | 1.688 | 1.688 | 1.677 | 1.677 | 338.0 |
| 2024-01-18 | CT | Futures | 98.43 | 99.31 | 98.17 | 99.2 | 18093.0 |
| 2024-01-18 | DC | Futures | 16.2 | 16.2 | 16.0 | 16.02 | 633.0 |
| 2024-01-18 | DX | Futures | 102.025 | 102.362 | 101.887 | 102.27 | 12405.0 |
| 2024-01-18 | E1 | Futures | 1.20854 | 1.21004 | 1.20148 | 1.20153 | 19941.0 |
| 2024-01-18 | E6 | Futures | 1.10523 | 1.10751 | 1.10138 | 1.1029 | 188196.0 |
| 2024-01-18 | E7 | Futures | 1.1049 | 1.1072 | 1.1012 | 1.1026 | 5823.0 |
| 2024-01-18 | EBM | Futures | 285.6 | 286.59 | 283.62 | 286.26 | 28604.0 |
| 2024-01-18 | ER | Futures | 97.706 | 97.721 | 97.69 | 97.695 | 206692.0 |
| 2024-01-18 | ESG | Futures | 427.96 | 431.64 | 427.83 | 431.35 | 394.0 |
| 2024-01-18 | EW | Futures | 2800.8 | 2826.0 | 2793.8 | 2823.5 | 12761.0 |
| 2024-01-18 | FBON | Futures | 123.47 | 123.84 | 123.21 | 123.4 | 56.0 |
| 2024-01-18 | FBTP | Futures | 116.23 | 116.74 | 116.06 | 116.33 | 230288.0 |
| 2024-01-18 | FBTS | Futures | 106.918 | 107.089 | 106.918 | 107.029 | 136387.0 |
| 2024-01-18 | FCE | Futures | 7668.9 | 7791.7 | 7668.9 | 7761.4 | 40180.0 |
| 2024-01-18 | FDAX | Futures | 17328.6 | 17513.0 | 17305.6 | 17461.7 | 54043.0 |
| 2024-01-18 | FDIV | Futures | 177.0 | 177.0 | 177.0 | 177.0 | 0.0 |
| 2024-01-18 | FDXM | Futures | 17198.2 | 17379.1 | 17176.4 | 17330.2 | 44386.0 |
| 2024-01-18 | FDXS | Futures | 17079.7 | 17264.5 | 17062.2 | 17216.0 | 29561.0 |
| 2024-01-18 | FESX | Futures | 4407.6 | 4476.4 | 4398.7 | 4456.5 | 762828.0 |
| 2024-01-18 | FEU3 | Futures | 97.716 | 97.716 | 97.7 | 97.7 | 327.0 |
| 2024-01-18 | FGBL | Futures | 135.92 | 136.22 | 135.46 | 135.68 | 977761.0 |
| 2024-01-18 | FGBM | Futures | 119.36 | 119.55 | 119.22 | 119.32 | 889914.0 |
| 2024-01-18 | FGBS | Futures | 107.52 | 107.581 | 107.494 | 107.525 | 563738.0 |
| 2024-01-18 | FGBX | Futures | 138.17 | 138.52 | 136.88 | 137.25 | 119431.0 |
| 2024-01-18 | FMWO | Futures | 10713.2 | 10798.2 | 10703.4 | 10755.7 | 4185.0 |
| 2024-01-18 | FOAT | Futures | 127.67 | 127.94 | 127.24 | 127.44 | 230019.0 |
| 2024-01-18 | FSMX | Futures | 26041.9 | 26560.1 | 25968.3 | 26300.5 | 884.0 |
| 2024-01-18 | FTDX | Futures | 3356.0 | 3381.7 | 3356.0 | 3381.2 | 13.0 |
| 2024-01-18 | FTI | Futures | 793.26 | 804.25 | 793.01 | 800.18 | 7568.0 |
| 2024-01-18 | FTUK | Futures | 7465.3 | 7503.4 | 7448.2 | 7481.3 | 104238.0 |
> showing 50 of 130 rows — these rows as CSV