PREVIEW / futures_daily / 2021-08-20
file: by_date/futures_daily/2021/2021-08-20.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-08-20 | ES | Futures | 4950.14 | 4991.45 | 4914.17 | 4987.51 | 1328852.0 |
| 2021-08-20 | NQ | Futures | 17239.83 | 17420.67 | 17133.41 | 17405.39 | 504460.0 |
| 2021-08-20 | YM | Futures | 37785.3 | 38081.3 | 37483.8 | 38014.1 | 161422.0 |
| 2021-08-20 | CL | Futures | 46.62 | 46.91 | 45.28 | 45.51 | 365009.0 |
| 2021-08-20 | GC | Futures | 2079.9 | 2089.5 | 2076.6 | 2081.3 | 107966.0 |
| 2021-08-20 | ZN | Futures | 135.923351 | 136.065679 | 135.686138 | 135.749395 | 1095887.0 |
| 2021-08-20 | A6 | Futures | 0.73316 | 0.73393 | 0.7288 | 0.73193 | 85693.0 |
| 2021-08-20 | AD | Futures | 0.7903 | 0.79117 | 0.78295 | 0.78919 | 113782.0 |
| 2021-08-20 | ALI | Futures | 2961.65 | 2964.78 | 2924.88 | 2933.43 | 380.0 |
| 2021-08-20 | B | Futures | 44.31 | 44.57 | 43.25 | 43.41 | 254451.0 |
| 2021-08-20 | B6 | Futures | 1.385 | 1.3852 | 1.3811 | 1.3832 | 80983.0 |
| 2021-08-20 | BFX | Futures | 4335.7 | 4366.8 | 4328.0 | 4366.8 | 32.0 |
| 2021-08-20 | BR | Futures | 0.1471 | 0.14886 | 0.14594 | 0.14826 | 15916.0 |
| 2021-08-20 | BTC | Futures | 62411.4 | 65951.3 | 62176.7 | 65341.2 | 5402.0 |
| 2021-08-20 | BZ | Futures | 43.29 | 43.5 | 42.12 | 42.37 | 27104.0 |
| 2021-08-20 | C | Futures | 1524.0 | 1531.0 | 1518.0 | 1520.0 | 2936.0 |
| 2021-08-20 | CB | Futures | 136.794 | 137.195 | 135.771 | 135.771 | 38.0 |
| 2021-08-20 | CC | Futures | 1684.0 | 1691.0 | 1643.0 | 1648.0 | 28339.0 |
| 2021-08-20 | CNH | Futures | 6.2826 | 6.2905 | 6.2777 | 6.2777 | 435.0 |
| 2021-08-20 | CSC | Futures | 2.493 | 2.506 | 2.459 | 2.466 | 160.0 |
| 2021-08-20 | CT | Futures | 85.81 | 87.43 | 85.81 | 86.84 | 13.0 |
| 2021-08-20 | DC | Futures | 22.38 | 22.6 | 22.17 | 22.24 | 513.0 |
| 2021-08-20 | DX | Futures | 90.472 | 90.617 | 90.332 | 90.384 | 15390.0 |
| 2021-08-20 | E1 | Futures | 1.22313 | 1.22673 | 1.22257 | 1.22437 | 14705.0 |
| 2021-08-20 | E6 | Futures | 1.24254 | 1.24552 | 1.24121 | 1.24467 | 112699.0 |
| 2021-08-20 | E7 | Futures | 1.2365 | 1.2393 | 1.2349 | 1.2385 | 3146.0 |
| 2021-08-20 | EBM | Futures | 385.43 | 410.8 | 384.69 | 401.98 | 9550.0 |
| 2021-08-20 | ED | Futures | 96.5369 | 96.5418 | 96.5369 | 96.5418 | 84696.0 |
| 2021-08-20 | ER | Futures | 98.465 | 98.47 | 98.465 | 98.47 | 12181.0 |
| 2021-08-20 | ESG | Futures | 406.49 | 412.64 | 406.49 | 412.44 | 329.0 |
| 2021-08-20 | EW | Futures | 2840.0 | 2873.6 | 2812.4 | 2871.6 | 7956.0 |
| 2021-08-20 | FBON | Futures | 151.76 | 151.8 | 151.7 | 151.79 | 57.0 |
| 2021-08-20 | FBTP | Futures | 141.96 | 142.01 | 141.78 | 141.99 | 68363.0 |
| 2021-08-20 | FBTS | Futures | 110.516 | 110.555 | 110.507 | 110.536 | 23905.0 |
| 2021-08-20 | FCE | Futures | 6578.3 | 6632.8 | 6553.9 | 6613.8 | 68167.0 |
| 2021-08-20 | FDAX | Futures | 16912.6 | 16951.2 | 16760.5 | 16910.5 | 67777.0 |
| 2021-08-20 | FDIV | Futures | 185.98 | 187.26 | 185.88 | 187.26 | 40.0 |
| 2021-08-20 | FDXM | Futures | 16835.1 | 16868.2 | 16677.4 | 16826.6 | 44897.0 |
| 2021-08-20 | FDXS | Futures | 16724.0 | 16762.1 | 16572.5 | 16719.7 | 9849.0 |
| 2021-08-20 | FESX | Futures | 3917.2 | 3937.5 | 3888.2 | 3925.7 | 668982.0 |
| 2021-08-20 | FGBL | Futures | 171.48 | 171.67 | 171.45 | 171.6 | 318524.0 |
| 2021-08-20 | FGBM | Futures | 135.81 | 135.9 | 135.81 | 135.86 | 195827.0 |
| 2021-08-20 | FGBS | Futures | 112.759 | 112.775 | 112.754 | 112.764 | 225575.0 |
| 2021-08-20 | FGBX | Futures | 233.24 | 233.94 | 233.13 | 233.43 | 43537.0 |
| 2021-08-20 | FMWO | Futures | 10793.9 | 10900.8 | 10745.7 | 10860.9 | 3236.0 |
| 2021-08-20 | FOAT | Futures | 158.55 | 158.67 | 158.5 | 158.64 | 95247.0 |
| 2021-08-20 | FTDX | Futures | 3940.1 | 3989.3 | 3909.3 | 3978.5 | 220.0 |
| 2021-08-20 | FTI | Futures | 730.44 | 738.47 | 728.96 | 737.01 | 22594.0 |
| 2021-08-20 | FTUK | Futures | 6945.4 | 6986.3 | 6903.1 | 6958.7 | 91315.0 |
| 2021-08-20 | FVSA | Futures | 86.44 | 88.58 | 78.28 | 82.55 | 33050.0 |
> showing 50 of 123 rows — these rows as CSV