PREVIEW / futures_daily / 2022-01-21
file: by_date/futures_daily/2022/2022-01-21.parquet size: 10 KB rows: 126
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-21 | ES | Futures | 5016.73 | 5053.61 | 4934.51 | 4944.36 | 3012106.0 |
| 2022-01-21 | NQ | Futures | 16970.28 | 17127.62 | 16608.9 | 16629.65 | 1041723.0 |
| 2022-01-21 | YM | Futures | 37697.2 | 37943.7 | 37199.7 | 37261.9 | 335699.0 |
| 2022-01-21 | CL | Futures | 64.67 | 65.42 | 63.3 | 65.1 | 509103.0 |
| 2022-01-21 | GC | Futures | 2147.3 | 2151.0 | 2133.1 | 2137.1 | 225249.0 |
| 2022-01-21 | ZN | Futures | 130.749383 | 131.356331 | 130.717439 | 131.164664 | 2108462.0 |
| 2022-01-21 | A6 | Futures | 0.74044 | 0.74065 | 0.73491 | 0.73542 | 96863.0 |
| 2022-01-21 | AD | Futures | 0.81114 | 0.8114 | 0.80566 | 0.80663 | 86096.0 |
| 2022-01-21 | ALI | Futures | 3470.97 | 3478.46 | 3388.86 | 3406.61 | 1369.0 |
| 2022-01-21 | B | Futures | 60.23 | 61.26 | 59.51 | 61.02 | 288214.0 |
| 2022-01-21 | B6 | Futures | 1.3782 | 1.3787 | 1.3728 | 1.3739 | 114677.0 |
| 2022-01-21 | BFX | Futures | 4234.0 | 4244.2 | 4232.0 | 4232.0 | 12.0 |
| 2022-01-21 | BR | Futures | 0.15129 | 0.15187 | 0.14993 | 0.1503 | 10287.0 |
| 2022-01-21 | BTC | Futures | 53891.4 | 53904.5 | 47372.0 | 50032.2 | 11781.0 |
| 2022-01-21 | BZ | Futures | 58.9 | 59.49 | 57.8 | 59.27 | 29566.0 |
| 2022-01-21 | C | Futures | 1401.0 | 1402.0 | 1386.0 | 1389.0 | 7638.0 |
| 2022-01-21 | CB | Futures | 196.247 | 198.978 | 195.291 | 198.588 | 78.0 |
| 2022-01-21 | CC | Futures | 1653.0 | 1661.0 | 1620.0 | 1621.0 | 26905.0 |
| 2022-01-21 | CNH | Futures | 6.053 | 6.0547 | 6.0444 | 6.0492 | 147.0 |
| 2022-01-21 | CSC | Futures | 2.734 | 2.736 | 2.69 | 2.732 | 182.0 |
| 2022-01-21 | CT | Futures | 118.36 | 119.35 | 117.2 | 117.28 | 15815.0 |
| 2022-01-21 | DC | Futures | 27.14 | 27.26 | 26.82 | 27.2 | 386.0 |
| 2022-01-21 | DX | Futures | 92.575 | 92.614 | 92.276 | 92.422 | 13735.0 |
| 2022-01-21 | E1 | Futures | 1.21852 | 1.227 | 1.2183 | 1.22589 | 18408.0 |
| 2022-01-21 | E6 | Futures | 1.19979 | 1.20499 | 1.19868 | 1.20297 | 139580.0 |
| 2022-01-21 | E7 | Futures | 1.1931 | 1.1981 | 1.1919 | 1.1962 | 4236.0 |
| 2022-01-21 | EBM | Futures | 390.12 | 393.7 | 387.98 | 390.12 | 12527.0 |
| 2022-01-21 | ED | Futures | 96.4091 | 96.4236 | 96.4091 | 96.4187 | 140092.0 |
| 2022-01-21 | ER | Futures | 98.519 | 98.519 | 98.514 | 98.514 | 25533.0 |
| 2022-01-21 | ESG | Futures | 418.83 | 421.72 | 412.63 | 412.79 | 3656.0 |
| 2022-01-21 | EW | Futures | 2837.9 | 2856.4 | 2787.4 | 2790.2 | 27117.0 |
| 2022-01-21 | FBON | Futures | 147.26 | 147.4 | 147.02 | 147.3 | 279.0 |
| 2022-01-21 | FBTP | Futures | 134.38 | 134.55 | 134.15 | 134.3 | 126253.0 |
| 2022-01-21 | FBTS | Futures | 109.962 | 110.011 | 109.933 | 109.972 | 57833.0 |
| 2022-01-21 | FCE | Futures | 7097.4 | 7126.4 | 6995.8 | 7073.4 | 90434.0 |
| 2022-01-21 | FDAX | Futures | 16880.9 | 16884.1 | 16564.4 | 16708.1 | 126247.0 |
| 2022-01-21 | FDIV | Futures | 192.16 | 192.16 | 190.22 | 190.87 | 73.0 |
| 2022-01-21 | FDXM | Futures | 16956.2 | 16957.2 | 16638.2 | 16781.6 | 72428.0 |
| 2022-01-21 | FDXS | Futures | 16811.6 | 16811.6 | 16476.2 | 16629.0 | 30330.0 |
| 2022-01-21 | FESX | Futures | 4069.6 | 4080.7 | 4006.7 | 4051.8 | 1042091.0 |
| 2022-01-21 | FGBL | Futures | 165.64 | 166.25 | 165.56 | 165.92 | 704572.0 |
| 2022-01-21 | FGBM | Futures | 133.64 | 133.89 | 133.62 | 133.78 | 451672.0 |
| 2022-01-21 | FGBS | Futures | 112.593 | 112.674 | 112.593 | 112.654 | 378256.0 |
| 2022-01-21 | FGBX | Futures | 221.66 | 223.82 | 221.66 | 222.83 | 65159.0 |
| 2022-01-21 | FMWO | Futures | 10916.4 | 10975.5 | 10766.2 | 10962.5 | 7573.0 |
| 2022-01-21 | FOAT | Futures | 153.49 | 153.79 | 153.24 | 153.51 | 145621.0 |
| 2022-01-21 | FSMX | Futures | 35512.7 | 35512.7 | 34908.4 | 35245.2 | 432.0 |
| 2022-01-21 | FTDX | Futures | 3634.8 | 3655.5 | 3586.8 | 3614.7 | 274.0 |
| 2022-01-21 | FTI | Futures | 737.41 | 740.6 | 725.88 | 735.61 | 28940.0 |
| 2022-01-21 | FTUK | Futures | 7424.0 | 7439.9 | 7331.0 | 7394.2 | 140254.0 |
> showing 50 of 126 rows — these rows as CSV