PREVIEW / futures_daily / 2021-08-27
file: by_date/futures_daily/2021/2021-08-27.parquet size: 10 KB rows: 122
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-27 | ES | Futures | 5024.61 | 5069.57 | 5015.9 | 5064.51 | 1216414.0 |
| 2021-08-27 | NQ | Futures | 17635.26 | 17817.25 | 17611.61 | 17797.35 | 441045.0 |
| 2021-08-27 | YM | Futures | 38148.5 | 38415.3 | 38074.8 | 38388.2 | 113732.0 |
| 2021-08-27 | CL | Futures | 49.62 | 50.58 | 49.45 | 50.35 | 326056.0 |
| 2021-08-27 | GC | Futures | 2094.4 | 2125.5 | 2082.7 | 2122.7 | 203642.0 |
| 2021-08-27 | ZN | Futures | 135.13264 | 135.591252 | 135.037754 | 135.512181 | 2464215.0 |
| 2021-08-27 | A6 | Futures | 0.74234 | 0.75039 | 0.7407 | 0.74993 | 83780.0 |
| 2021-08-27 | AD | Futures | 0.79907 | 0.80425 | 0.79776 | 0.80338 | 74195.0 |
| 2021-08-27 | ALI | Futures | 3035.47 | 3097.62 | 3033.48 | 3045.45 | 144.0 |
| 2021-08-27 | B | Futures | 47.54 | 48.31 | 47.28 | 48.27 | 266247.0 |
| 2021-08-27 | B6 | Futures | 1.3908 | 1.3995 | 1.389 | 1.3981 | 88112.0 |
| 2021-08-27 | BFX | Futures | 4405.1 | 4409.2 | 4401.0 | 4409.2 | 11.0 |
| 2021-08-27 | BR | Futures | 0.15271 | 0.15425 | 0.15271 | 0.15417 | 324.0 |
| 2021-08-27 | BTC | Futures | 62863.0 | 65579.4 | 61717.9 | 64520.8 | 5609.0 |
| 2021-08-27 | BZ | Futures | 46.26 | 47.06 | 46.08 | 47.04 | 24007.0 |
| 2021-08-27 | C | Futures | 1533.0 | 1539.0 | 1523.0 | 1526.0 | 1632.0 |
| 2021-08-27 | CB | Futures | 138.293 | 138.293 | 138.293 | 138.293 | 102.0 |
| 2021-08-27 | CC | Futures | 1674.0 | 1691.0 | 1652.0 | 1658.0 | 17818.0 |
| 2021-08-27 | CNH | Futures | 6.2622 | 6.2626 | 6.2385 | 6.2398 | 642.0 |
| 2021-08-27 | CSC | Futures | 2.476 | 2.476 | 2.466 | 2.466 | 14.0 |
| 2021-08-27 | CT | Futures | 88.03 | 89.07 | 88.0 | 89.03 | 11.0 |
| 2021-08-27 | DC | Futures | 22.27 | 22.29 | 22.2 | 22.2 | 85.0 |
| 2021-08-27 | DX | Futures | 89.965 | 90.081 | 89.535 | 89.597 | 31609.0 |
| 2021-08-27 | E1 | Futures | 1.22437 | 1.23369 | 1.22111 | 1.23268 | 23251.0 |
| 2021-08-27 | E6 | Futures | 1.25079 | 1.25579 | 1.2485 | 1.25493 | 182266.0 |
| 2021-08-27 | E7 | Futures | 1.2444 | 1.2495 | 1.2423 | 1.2486 | 4666.0 |
| 2021-08-27 | EBM | Futures | 368.14 | 371.08 | 363.36 | 367.77 | 1573.0 |
| 2021-08-27 | ED | Futures | 96.5442 | 96.5466 | 96.5418 | 96.5466 | 125073.0 |
| 2021-08-27 | ER | Futures | 98.47 | 98.475 | 98.47 | 98.47 | 15783.0 |
| 2021-08-27 | ESG | Futures | 417.33 | 418.85 | 415.81 | 418.59 | 279.0 |
| 2021-08-27 | EW | Futures | 2913.6 | 2976.0 | 2906.8 | 2970.2 | 12747.0 |
| 2021-08-27 | FBON | Futures | 150.65 | 150.71 | 150.45 | 150.68 | 227.0 |
| 2021-08-27 | FBTP | Futures | 140.61 | 141.03 | 140.51 | 140.86 | 91707.0 |
| 2021-08-27 | FBTS | Futures | 110.448 | 110.487 | 110.429 | 110.477 | 47117.0 |
| 2021-08-27 | FCE | Futures | 6656.2 | 6680.7 | 6630.3 | 6669.2 | 33928.0 |
| 2021-08-27 | FDAX | Futures | 16860.2 | 17000.5 | 16841.9 | 16963.0 | 47631.0 |
| 2021-08-27 | FDXM | Futures | 16779.7 | 16917.2 | 16759.4 | 16878.8 | 32870.0 |
| 2021-08-27 | FDXS | Futures | 16660.4 | 16808.7 | 16651.9 | 16771.6 | 5726.0 |
| 2021-08-27 | FESX | Futures | 3939.0 | 3978.3 | 3935.2 | 3968.3 | 458377.0 |
| 2021-08-27 | FGBL | Futures | 170.35 | 170.6 | 170.16 | 170.48 | 540729.0 |
| 2021-08-27 | FGBM | Futures | 135.56 | 135.64 | 135.51 | 135.61 | 271148.0 |
| 2021-08-27 | FGBS | Futures | 112.729 | 112.739 | 112.724 | 112.729 | 221274.0 |
| 2021-08-27 | FGBX | Futures | 228.84 | 229.11 | 227.73 | 228.69 | 57916.0 |
| 2021-08-27 | FMWO | Futures | 11003.0 | 11084.1 | 10992.5 | 11060.6 | 2383.0 |
| 2021-08-27 | FOAT | Futures | 157.47 | 157.69 | 157.29 | 157.6 | 149042.0 |
| 2021-08-27 | FTDX | Futures | 3983.7 | 4021.6 | 3983.7 | 4020.1 | 48.0 |
| 2021-08-27 | FTI | Futures | 746.07 | 753.38 | 744.73 | 751.88 | 13296.0 |
| 2021-08-27 | FTUK | Futures | 6999.6 | 7035.0 | 6983.8 | 7024.7 | 54267.0 |
| 2021-08-27 | FVSA | Futures | 78.86 | 78.86 | 74.78 | 75.37 | 19953.0 |
| 2021-08-27 | FXXP | Futures | 447.2 | 450.1 | 446.4 | 449.4 | 38713.0 |
> showing 50 of 122 rows — these rows as CSV