PREVIEW / futures_daily / 2021-10-19
file: by_date/futures_daily/2021/2021-10-19.parquet size: 10 KB rows: 123
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-19 | ES | Futures | 5034.73 | 5081.7 | 5030.23 | 5074.67 | 1018177.0 |
| 2021-10-19 | NQ | Futures | 17631.31 | 17791.02 | 17607.38 | 17756.71 | 384792.0 |
| 2021-10-19 | YM | Futures | 38212.8 | 38478.3 | 38154.0 | 38432.6 | 128838.0 |
| 2021-10-19 | CL | Futures | 60.45 | 61.49 | 60.08 | 61.08 | 531465.0 |
| 2021-10-19 | GC | Futures | 2058.9 | 2083.6 | 2057.3 | 2065.6 | 166972.0 |
| 2021-10-19 | ZN | Futures | 132.859777 | 133.193475 | 132.669092 | 132.780325 | 1437829.0 |
| 2021-10-19 | A6 | Futures | 0.75992 | 0.76756 | 0.75957 | 0.76684 | 95404.0 |
| 2021-10-19 | AD | Futures | 0.82009 | 0.8246 | 0.81978 | 0.82136 | 66847.0 |
| 2021-10-19 | ALI | Futures | 3579.56 | 3599.3 | 3482.0 | 3491.73 | 672.0 |
| 2021-10-19 | B | Futures | 57.05 | 57.85 | 56.7 | 57.64 | 371791.0 |
| 2021-10-19 | B6 | Futures | 1.3937 | 1.4042 | 1.3934 | 1.4006 | 92221.0 |
| 2021-10-19 | BR | Futures | 0.14622 | 0.14638 | 0.1437 | 0.1441 | 1463.0 |
| 2021-10-19 | BTC | Futures | 82310.8 | 86133.5 | 82078.1 | 85974.0 | 15283.0 |
| 2021-10-19 | BZ | Futures | 55.66 | 56.51 | 55.39 | 56.3 | 45141.0 |
| 2021-10-19 | C | Futures | 1574.0 | 1574.0 | 1534.0 | 1537.0 | 7402.0 |
| 2021-10-19 | CB | Futures | 141.839 | 142.312 | 141.839 | 142.036 | 9.0 |
| 2021-10-19 | CC | Futures | 1684.0 | 1690.0 | 1622.0 | 1643.0 | 24314.0 |
| 2021-10-19 | CNH | Futures | 6.1829 | 6.1829 | 6.1256 | 6.1306 | 815.0 |
| 2021-10-19 | CSC | Futures | 2.564 | 2.584 | 2.564 | 2.584 | 103.0 |
| 2021-10-19 | CT | Futures | 99.99 | 101.14 | 98.23 | 100.64 | 14642.0 |
| 2021-10-19 | DC | Futures | 24.22 | 24.45 | 24.19 | 24.45 | 323.0 |
| 2021-10-19 | DX | Futures | 90.776 | 90.776 | 90.332 | 90.562 | 25677.0 |
| 2021-10-19 | E1 | Futures | 1.21418 | 1.22112 | 1.21384 | 1.21552 | 21175.0 |
| 2021-10-19 | E6 | Futures | 1.23507 | 1.24113 | 1.23465 | 1.23794 | 163848.0 |
| 2021-10-19 | E7 | Futures | 1.2284 | 1.2343 | 1.2279 | 1.2312 | 4045.0 |
| 2021-10-19 | EBM | Futures | 404.5 | 405.61 | 400.09 | 402.3 | 12582.0 |
| 2021-10-19 | ED | Futures | 96.5344 | 96.5489 | 96.5296 | 96.5344 | 173287.0 |
| 2021-10-19 | ER | Futures | 98.47 | 98.475 | 98.47 | 98.47 | 59558.0 |
| 2021-10-19 | ESG | Futures | 418.16 | 422.95 | 418.16 | 420.3 | 352.0 |
| 2021-10-19 | EW | Futures | 2958.7 | 2983.3 | 2956.5 | 2967.8 | 9262.0 |
| 2021-10-19 | FBON | Futures | 148.57 | 148.8 | 147.81 | 147.98 | 781.0 |
| 2021-10-19 | FBTP | Futures | 138.09 | 138.45 | 137.35 | 137.61 | 163697.0 |
| 2021-10-19 | FBTS | Futures | 110.206 | 110.283 | 110.128 | 110.177 | 75998.0 |
| 2021-10-19 | FCE | Futures | 6758.0 | 6769.7 | 6721.6 | 6741.9 | 38959.0 |
| 2021-10-19 | FDAX | Futures | 16555.3 | 16579.9 | 16500.8 | 16573.5 | 49223.0 |
| 2021-10-19 | FDIV | Futures | 181.52 | 182.65 | 181.52 | 182.65 | 30.0 |
| 2021-10-19 | FDXM | Futures | 16593.9 | 16628.2 | 16548.9 | 16620.7 | 35824.0 |
| 2021-10-19 | FDXS | Futures | 16444.1 | 16471.7 | 16394.1 | 16466.4 | 14557.0 |
| 2021-10-19 | FESX | Futures | 3970.8 | 3983.3 | 3963.2 | 3982.3 | 455196.0 |
| 2021-10-19 | FGBL | Futures | 166.58 | 166.98 | 165.85 | 166.05 | 846390.0 |
| 2021-10-19 | FGBM | Futures | 133.98 | 134.23 | 133.77 | 133.92 | 725929.0 |
| 2021-10-19 | FGBS | Futures | 112.478 | 112.549 | 112.453 | 112.498 | 476659.0 |
| 2021-10-19 | FGBX | Futures | 222.7 | 223.17 | 219.38 | 219.83 | 122293.0 |
| 2021-10-19 | FMWO | Futures | 11099.9 | 11145.9 | 11090.4 | 11140.0 | 7083.0 |
| 2021-10-19 | FOAT | Futures | 154.28 | 154.7 | 153.57 | 153.79 | 168880.0 |
| 2021-10-19 | FTDX | Futures | 3827.2 | 3840.5 | 3802.5 | 3839.0 | 94.0 |
| 2021-10-19 | FTI | Futures | 760.98 | 766.76 | 760.59 | 764.94 | 11973.0 |
| 2021-10-19 | FTUK | Futures | 7093.2 | 7118.4 | 7078.8 | 7111.9 | 66119.0 |
| 2021-10-19 | FVSA | Futures | 69.11 | 69.79 | 68.07 | 68.24 | 27236.0 |
| 2021-10-19 | FXXP | Futures | 446.1 | 446.2 | 444.2 | 445.9 | 58240.0 |
> showing 50 of 123 rows — these rows as CSV