PREVIEW / futures_daily / 2022-01-24
file: by_date/futures_daily/2022/2022-01-24.parquet size: 10 KB rows: 128
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 |
|---|---|---|---|---|---|---|---|
| 2022-01-24 | ES | Futures | 4943.24 | 4986.6 | 4744.73 | 4959.85 | 3846785.0 |
| 2022-01-24 | NQ | Futures | 16610.63 | 16808.9 | 15799.12 | 16715.53 | 1323080.0 |
| 2022-01-24 | YM | Futures | 37246.6 | 37537.9 | 36033.5 | 37366.6 | 465699.0 |
| 2022-01-24 | CL | Futures | 64.93 | 65.83 | 62.62 | 63.7 | 511695.0 |
| 2022-01-24 | GC | Futures | 2141.0 | 2152.4 | 2134.2 | 2148.6 | 244325.0 |
| 2022-01-24 | ZN | Futures | 131.06883 | 131.563971 | 130.829245 | 131.372304 | 2158245.0 |
| 2022-01-24 | A6 | Futures | 0.73522 | 0.73655 | 0.72661 | 0.73056 | 115990.0 |
| 2022-01-24 | AD | Futures | 0.80612 | 0.80779 | 0.79841 | 0.80191 | 101502.0 |
| 2022-01-24 | ALI | Futures | 3384.98 | 3398.02 | 3382.76 | 3394.96 | 1042.0 |
| 2022-01-24 | B | Futures | 61.02 | 61.73 | 59.02 | 59.87 | 270251.0 |
| 2022-01-24 | B6 | Futures | 1.3738 | 1.3749 | 1.3622 | 1.3665 | 126293.0 |
| 2022-01-24 | BFX | Futures | 4126.9 | 4126.9 | 4072.4 | 4072.4 | 6.0 |
| 2022-01-24 | BR | Futures | 0.1508 | 0.15109 | 0.14861 | 0.14931 | 2588.0 |
| 2022-01-24 | BTC | Futures | 50032.2 | 52622.7 | 46132.4 | 52202.6 | 5561.0 |
| 2022-01-24 | BZ | Futures | 59.27 | 59.95 | 57.33 | 58.16 | 23673.0 |
| 2022-01-24 | C | Futures | 1383.0 | 1387.0 | 1355.0 | 1358.0 | 8686.0 |
| 2022-01-24 | CB | Futures | 198.978 | 201.046 | 193.867 | 198.607 | 53.0 |
| 2022-01-24 | CC | Futures | 1616.0 | 1621.0 | 1568.0 | 1568.0 | 25526.0 |
| 2022-01-24 | CNH | Futures | 6.0492 | 6.0492 | 6.0297 | 6.0405 | 502.0 |
| 2022-01-24 | CSC | Futures | 2.723 | 2.736 | 2.682 | 2.689 | 149.0 |
| 2022-01-24 | CT | Futures | 117.72 | 118.98 | 115.77 | 116.92 | 17635.0 |
| 2022-01-24 | DC | Futures | 27.0 | 27.43 | 26.84 | 26.95 | 538.0 |
| 2022-01-24 | DX | Futures | 92.459 | 92.899 | 92.411 | 92.678 | 20382.0 |
| 2022-01-24 | E1 | Futures | 1.22522 | 1.22667 | 1.22009 | 1.22232 | 22945.0 |
| 2022-01-24 | E6 | Futures | 1.20319 | 1.20334 | 1.19752 | 1.20075 | 164397.0 |
| 2022-01-24 | E7 | Futures | 1.1963 | 1.1966 | 1.1907 | 1.194 | 5176.0 |
| 2022-01-24 | EBM | Futures | 391.91 | 403.01 | 391.55 | 402.29 | 30896.0 |
| 2022-01-24 | ED | Futures | 96.4187 | 96.4284 | 96.3994 | 96.4236 | 204182.0 |
| 2022-01-24 | ER | Futures | 98.514 | 98.519 | 98.509 | 98.509 | 34269.0 |
| 2022-01-24 | ESG | Futures | 414.92 | 414.92 | 395.85 | 413.39 | 7943.0 |
| 2022-01-24 | EW | Futures | 2788.7 | 2850.9 | 2712.0 | 2842.3 | 46599.0 |
| 2022-01-24 | FBON | Futures | 147.32 | 147.73 | 147.24 | 147.27 | 610.0 |
| 2022-01-24 | FBTP | Futures | 134.5 | 134.94 | 134.29 | 134.37 | 118742.0 |
| 2022-01-24 | FBTS | Futures | 110.001 | 110.04 | 109.972 | 109.991 | 49351.0 |
| 2022-01-24 | FCE | Futures | 7037.3 | 7077.4 | 6707.4 | 6793.5 | 107284.0 |
| 2022-01-24 | FDAX | Futures | 16647.0 | 16717.8 | 15912.0 | 16124.4 | 167231.0 |
| 2022-01-24 | FDIV | Futures | 185.16 | 185.7 | 185.16 | 185.6 | 84.0 |
| 2022-01-24 | FDXM | Futures | 16684.6 | 16791.3 | 15981.9 | 16195.3 | 109199.0 |
| 2022-01-24 | FDXS | Futures | 16558.5 | 16637.5 | 15839.8 | 16048.0 | 51185.0 |
| 2022-01-24 | FESX | Futures | 4022.5 | 4053.3 | 3836.9 | 3900.9 | 1580643.0 |
| 2022-01-24 | FGBL | Futures | 165.86 | 166.68 | 165.74 | 166.49 | 740078.0 |
| 2022-01-24 | FGBM | Futures | 133.79 | 134.15 | 133.71 | 134.05 | 459449.0 |
| 2022-01-24 | FGBS | Futures | 112.674 | 112.759 | 112.644 | 112.734 | 382064.0 |
| 2022-01-24 | FGBX | Futures | 222.65 | 224.63 | 222.26 | 223.98 | 67405.0 |
| 2022-01-24 | FMWO | Futures | 10850.1 | 10854.9 | 10355.7 | 10492.9 | 18032.0 |
| 2022-01-24 | FOAT | Futures | 153.5 | 154.0 | 153.36 | 153.83 | 161439.0 |
| 2022-01-24 | FSMX | Futures | 35015.4 | 35145.5 | 33499.4 | 33800.5 | 829.0 |
| 2022-01-24 | FTDX | Futures | 3593.0 | 3596.1 | 3429.9 | 3463.9 | 896.0 |
| 2022-01-24 | FTI | Futures | 731.04 | 736.83 | 702.53 | 711.62 | 37908.0 |
| 2022-01-24 | FTUK | Futures | 7369.8 | 7400.1 | 7133.9 | 7210.1 | 172762.0 |
> showing 50 of 128 rows — these rows as CSV