PREVIEW / futures_daily / 2021-10-28
file: by_date/futures_daily/2021/2021-10-28.parquet size: 10 KB rows: 125
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 |
|---|---|---|---|---|---|---|---|
| 2021-10-28 | ES | Futures | 5116.85 | 5162.97 | 5112.91 | 5160.44 | 1195785.0 |
| 2021-10-28 | NQ | Futures | 17983.3 | 18193.18 | 17979.56 | 18179.05 | 498210.0 |
| 2021-10-28 | YM | Futures | 38541.4 | 38822.1 | 38503.3 | 38748.1 | 156534.0 |
| 2021-10-28 | CL | Futures | 60.94 | 61.66 | 59.71 | 61.36 | 491585.0 |
| 2021-10-28 | GC | Futures | 2098.5 | 2114.8 | 2091.9 | 2103.0 | 220876.0 |
| 2021-10-28 | ZN | Futures | 133.209366 | 133.304708 | 132.827996 | 132.97101 | 2495837.0 |
| 2021-10-28 | A6 | Futures | 0.77084 | 0.77469 | 0.76689 | 0.77294 | 99524.0 |
| 2021-10-28 | AD | Futures | 0.82125 | 0.82339 | 0.81983 | 0.82217 | 71584.0 |
| 2021-10-28 | ALI | Futures | 2990.29 | 3094.8 | 2990.29 | 3078.68 | 73.0 |
| 2021-10-28 | B | Futures | 57.09 | 57.41 | 55.79 | 57.19 | 386021.0 |
| 2021-10-28 | B6 | Futures | 1.3948 | 1.4023 | 1.3928 | 1.3997 | 90458.0 |
| 2021-10-28 | BFX | Futures | 4335.0 | 4350.8 | 4335.0 | 4350.8 | 1.0 |
| 2021-10-28 | BR | Futures | 0.14561 | 0.14561 | 0.14256 | 0.14374 | 4891.0 |
| 2021-10-28 | BTC | Futures | 77755.9 | 82781.5 | 76814.0 | 81385.1 | 7829.0 |
| 2021-10-28 | BZ | Futures | 55.73 | 56.07 | 54.49 | 55.85 | 47582.0 |
| 2021-10-28 | C | Futures | 1498.0 | 1504.0 | 1486.0 | 1487.0 | 3992.0 |
| 2021-10-28 | CB | Futures | 149.719 | 151.098 | 148.95 | 148.99 | 7.0 |
| 2021-10-28 | CC | Futures | 1670.0 | 1681.0 | 1646.0 | 1651.0 | 20000.0 |
| 2021-10-28 | CNH | Futures | 6.1403 | 6.1521 | 6.1374 | 6.1378 | 416.0 |
| 2021-10-28 | CSC | Futures | 2.54 | 2.542 | 2.512 | 2.521 | 159.0 |
| 2021-10-28 | CT | Futures | 103.19 | 106.59 | 102.2 | 106.15 | 21371.0 |
| 2021-10-28 | DC | Futures | 24.18 | 24.18 | 23.8 | 23.87 | 390.0 |
| 2021-10-28 | DX | Futures | 90.714 | 90.796 | 90.115 | 90.174 | 35633.0 |
| 2021-10-28 | E1 | Futures | 1.22124 | 1.23019 | 1.21944 | 1.22975 | 31565.0 |
| 2021-10-28 | E6 | Futures | 1.2339 | 1.24336 | 1.23156 | 1.24251 | 277836.0 |
| 2021-10-28 | E7 | Futures | 1.2272 | 1.2366 | 1.2249 | 1.2358 | 7078.0 |
| 2021-10-28 | EBM | Futures | 419.2 | 420.67 | 414.79 | 415.89 | 19424.0 |
| 2021-10-28 | ED | Futures | 96.5199 | 96.5296 | 96.5005 | 96.5247 | 493277.0 |
| 2021-10-28 | ER | Futures | 98.47 | 98.48 | 98.465 | 98.47 | 150623.0 |
| 2021-10-28 | ESG | Futures | 427.16 | 430.93 | 426.79 | 430.76 | 301.0 |
| 2021-10-28 | EW | Futures | 2956.8 | 3007.3 | 2952.0 | 3000.3 | 12227.0 |
| 2021-10-28 | FBON | Futures | 148.51 | 148.51 | 147.34 | 148.02 | 2623.0 |
| 2021-10-28 | FBTP | Futures | 137.94 | 137.94 | 136.21 | 137.03 | 323099.0 |
| 2021-10-28 | FBTS | Futures | 110.147 | 110.147 | 109.837 | 109.982 | 148057.0 |
| 2021-10-28 | FCE | Futures | 6830.9 | 6879.9 | 6817.2 | 6878.4 | 49885.0 |
| 2021-10-28 | FDAX | Futures | 16774.5 | 16785.1 | 16688.9 | 16747.7 | 62990.0 |
| 2021-10-28 | FDIV | Futures | 184.46 | 184.46 | 184.17 | 184.17 | 25.0 |
| 2021-10-28 | FDXM | Futures | 16809.3 | 16832.9 | 16737.5 | 16795.4 | 44922.0 |
| 2021-10-28 | FDXS | Futures | 16669.2 | 16676.6 | 16582.1 | 16639.5 | 17136.0 |
| 2021-10-28 | FESX | Futures | 4030.7 | 4047.0 | 4021.6 | 4039.3 | 646874.0 |
| 2021-10-28 | FGBL | Futures | 167.1 | 167.14 | 165.8 | 166.56 | 1267716.0 |
| 2021-10-28 | FGBM | Futures | 134.09 | 134.32 | 133.47 | 133.98 | 1012053.0 |
| 2021-10-28 | FGBS | Futures | 112.509 | 112.554 | 112.368 | 112.488 | 696992.0 |
| 2021-10-28 | FGBX | Futures | 226.04 | 227.23 | 224.3 | 225.46 | 192121.0 |
| 2021-10-28 | FMWO | Futures | 11203.6 | 11299.1 | 11187.1 | 11282.6 | 2071.0 |
| 2021-10-28 | FOAT | Futures | 154.81 | 154.82 | 153.41 | 154.24 | 320719.0 |
| 2021-10-28 | FTDX | Futures | 3903.6 | 3933.4 | 3900.0 | 3933.4 | 35.0 |
| 2021-10-28 | FTI | Futures | 779.77 | 780.48 | 772.74 | 774.54 | 16309.0 |
| 2021-10-28 | FTUK | Futures | 7147.5 | 7160.3 | 7108.5 | 7129.7 | 78496.0 |
| 2021-10-28 | FVSA | Futures | 67.9 | 68.07 | 66.0 | 66.87 | 15183.0 |
> showing 50 of 125 rows — these rows as CSV