PREVIEW / futures_daily / 2021-08-09
file: by_date/futures_daily/2021/2021-08-09.parquet size: 10 KB rows: 124
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-09 | ES | Futures | 4977.4 | 4981.89 | 4959.69 | 4974.87 | 789726.0 |
| 2021-08-09 | NQ | Futures | 17409.43 | 17473.17 | 17309.05 | 17449.8 | 361388.0 |
| 2021-08-09 | YM | Futures | 38059.6 | 38065.0 | 37886.1 | 37949.0 | 101439.0 |
| 2021-08-09 | CL | Futures | 49.13 | 49.14 | 47.15 | 48.12 | 598381.0 |
| 2021-08-09 | GC | Futures | 2059.1 | 2060.0 | 1957.5 | 2014.2 | 289543.0 |
| 2021-08-09 | ZN | Futures | 135.527995 | 135.828466 | 135.274968 | 135.401482 | 1178694.0 |
| 2021-08-09 | A6 | Futures | 0.75439 | 0.75531 | 0.75157 | 0.75239 | 65729.0 |
| 2021-08-09 | AD | Futures | 0.80754 | 0.80896 | 0.80536 | 0.80632 | 56527.0 |
| 2021-08-09 | ALI | Futures | 2962.44 | 2962.44 | 2927.6 | 2939.31 | 535.0 |
| 2021-08-09 | B | Futures | 46.79 | 46.79 | 45.02 | 45.98 | 353678.0 |
| 2021-08-09 | B6 | Futures | 1.4087 | 1.4109 | 1.4055 | 1.4068 | 57192.0 |
| 2021-08-09 | BFX | Futures | 4401.0 | 4406.1 | 4401.0 | 4406.1 | 1.0 |
| 2021-08-09 | BR | Futures | 0.15202 | 0.15298 | 0.15058 | 0.15234 | 9200.0 |
| 2021-08-09 | BTC | Futures | 59340.8 | 62377.9 | 57510.5 | 61741.0 | 7172.0 |
| 2021-08-09 | BZ | Futures | 45.54 | 45.54 | 43.95 | 44.88 | 42738.0 |
| 2021-08-09 | C | Futures | 1453.0 | 1474.0 | 1453.0 | 1469.0 | 6697.0 |
| 2021-08-09 | CB | Futures | 131.78 | 132.783 | 131.78 | 132.783 | 2.0 |
| 2021-08-09 | CC | Futures | 1591.0 | 1601.0 | 1585.0 | 1592.0 | 37095.0 |
| 2021-08-09 | CNH | Futures | 6.2691 | 6.2744 | 6.2622 | 6.2712 | 595.0 |
| 2021-08-09 | CSC | Futures | 2.385 | 2.441 | 2.366 | 2.42 | 291.0 |
| 2021-08-09 | CT | Futures | 85.21 | 85.21 | 83.88 | 84.44 | 46.0 |
| 2021-08-09 | DC | Futures | 21.43 | 21.9 | 21.08 | 21.63 | 280.0 |
| 2021-08-09 | DX | Futures | 89.69 | 89.888 | 89.622 | 89.833 | 16360.0 |
| 2021-08-09 | E1 | Futures | 1.2274 | 1.22886 | 1.22055 | 1.22156 | 23665.0 |
| 2021-08-09 | E6 | Futures | 1.25158 | 1.2527 | 1.24898 | 1.24967 | 132285.0 |
| 2021-08-09 | E7 | Futures | 1.2426 | 1.2463 | 1.2426 | 1.2435 | 2641.0 |
| 2021-08-09 | EBM | Futures | 336.14 | 338.35 | 335.04 | 337.25 | 8586.0 |
| 2021-08-09 | ED | Futures | 96.5442 | 96.5442 | 96.5393 | 96.5442 | 49038.0 |
| 2021-08-09 | ER | Futures | 98.46 | 98.465 | 98.46 | 98.46 | 18135.0 |
| 2021-08-09 | ESG | Futures | 410.6 | 411.14 | 410.21 | 410.71 | 132.0 |
| 2021-08-09 | EW | Futures | 2915.2 | 2917.1 | 2889.6 | 2906.9 | 6492.0 |
| 2021-08-09 | FBON | Futures | 151.41 | 151.79 | 151.41 | 151.6 | 177.0 |
| 2021-08-09 | FBTP | Futures | 141.54 | 141.96 | 141.5 | 141.76 | 65612.0 |
| 2021-08-09 | FBTS | Futures | 110.487 | 110.507 | 110.477 | 110.487 | 26402.0 |
| 2021-08-09 | FCE | Futures | 6796.2 | 6819.7 | 6787.8 | 6798.7 | 27066.0 |
| 2021-08-09 | FDAX | Futures | 16837.7 | 16912.6 | 16802.3 | 16871.9 | 47068.0 |
| 2021-08-09 | FDIV | Futures | 185.83 | 186.27 | 185.83 | 186.27 | 10.0 |
| 2021-08-09 | FDXM | Futures | 16757.3 | 16828.7 | 16720.0 | 16788.2 | 31951.0 |
| 2021-08-09 | FDXS | Futures | 16655.1 | 16721.8 | 16613.8 | 16681.6 | 9788.0 |
| 2021-08-09 | FESX | Futures | 3943.7 | 3964.6 | 3940.4 | 3959.3 | 283226.0 |
| 2021-08-09 | FGBL | Futures | 170.93 | 171.37 | 170.87 | 170.99 | 405745.0 |
| 2021-08-09 | FGBM | Futures | 135.72 | 135.86 | 135.68 | 135.71 | 284845.0 |
| 2021-08-09 | FGBS | Futures | 112.759 | 112.785 | 112.744 | 112.749 | 181274.0 |
| 2021-08-09 | FGBX | Futures | 230.55 | 232.28 | 230.55 | 231.02 | 56893.0 |
| 2021-08-09 | FMWO | Futures | 10913.7 | 10941.9 | 10912.6 | 10932.5 | 3513.0 |
| 2021-08-09 | FOAT | Futures | 158.12 | 158.55 | 158.1 | 158.24 | 111878.0 |
| 2021-08-09 | FTDX | Futures | 3907.7 | 3941.6 | 3907.7 | 3926.7 | 138.0 |
| 2021-08-09 | FTI | Futures | 733.01 | 739.37 | 731.43 | 737.32 | 12784.0 |
| 2021-08-09 | FTUK | Futures | 6937.5 | 6969.0 | 6917.8 | 6967.6 | 53759.0 |
| 2021-08-09 | FVSA | Futures | 83.66 | 84.3 | 79.44 | 81.13 | 16383.0 |
> showing 50 of 124 rows — these rows as CSV