PREVIEW / futures_daily / 2021-05-27
file: by_date/futures_daily/2021/2021-05-27.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-05-27 | ES | Futures | 4705.19 | 4725.95 | 4688.08 | 4711.93 | 1179928.0 |
| 2021-05-27 | NQ | Futures | 15804.73 | 15825.78 | 15709.86 | 15762.05 | 388603.0 |
| 2021-05-27 | YM | Futures | 37118.7 | 37423.9 | 36983.4 | 37272.4 | 142115.0 |
| 2021-05-27 | CL | Futures | 47.09 | 47.63 | 46.6 | 47.58 | 337542.0 |
| 2021-05-27 | GC | Futures | 2221.5 | 2229.9 | 2211.5 | 2220.5 | 211786.0 |
| 2021-05-27 | ZN | Futures | 133.520903 | 133.61513 | 133.238219 | 133.363856 | 985340.0 |
| 2021-05-27 | A6 | Futures | 0.79413 | 0.79551 | 0.79192 | 0.79408 | 67876.0 |
| 2021-05-27 | AD | Futures | 0.83583 | 0.84034 | 0.83436 | 0.83968 | 64646.0 |
| 2021-05-27 | ALI | Futures | 2759.01 | 2828.62 | 2759.01 | 2821.01 | 135.0 |
| 2021-05-27 | B | Futures | 44.89 | 45.29 | 44.44 | 45.25 | 270531.0 |
| 2021-05-27 | B6 | Futures | 1.4339 | 1.4441 | 1.4309 | 1.4431 | 99007.0 |
| 2021-05-27 | BR | Futures | 0.15046 | 0.15126 | 0.15046 | 0.15126 | 197.0 |
| 2021-05-27 | BTC | Futures | 56824.2 | 58773.0 | 54201.8 | 56309.9 | 5261.0 |
| 2021-05-27 | BZ | Futures | 43.85 | 44.21 | 43.38 | 44.18 | 26569.0 |
| 2021-05-27 | C | Futures | 1486.0 | 1486.0 | 1452.0 | 1462.0 | 5907.0 |
| 2021-05-27 | CB | Futures | 151.637 | 153.242 | 151.637 | 153.041 | 71.0 |
| 2021-05-27 | CC | Futures | 1613.0 | 1631.0 | 1589.0 | 1619.0 | 17022.0 |
| 2021-05-27 | CNH | Futures | 6.1949 | 6.2006 | 6.1773 | 6.1804 | 987.0 |
| 2021-05-27 | CSC | Futures | 2.667 | 2.681 | 2.661 | 2.675 | 60.0 |
| 2021-05-27 | CT | Futures | 76.89 | 77.19 | 76.13 | 77.03 | 11402.0 |
| 2021-05-27 | DC | Futures | 24.81 | 24.82 | 24.69 | 24.79 | 96.0 |
| 2021-05-27 | DX | Futures | 87.045 | 87.146 | 86.871 | 86.933 | 19021.0 |
| 2021-05-27 | E1 | Futures | 1.25424 | 1.25637 | 1.24962 | 1.25514 | 23177.0 |
| 2021-05-27 | E6 | Futures | 1.29967 | 1.3019 | 1.29769 | 1.30025 | 152471.0 |
| 2021-05-27 | E7 | Futures | 1.2933 | 1.2954 | 1.2912 | 1.2937 | 4370.0 |
| 2021-05-27 | EBM | Futures | 304.52 | 312.61 | 304.15 | 311.87 | 20674.0 |
| 2021-05-27 | ED | Futures | 96.5487 | 96.5584 | 96.5463 | 96.5584 | 193892.0 |
| 2021-05-27 | ER | Futures | 98.455 | 98.46 | 98.455 | 98.46 | 33777.0 |
| 2021-05-27 | ESG | Futures | 390.28 | 390.3 | 388.49 | 388.52 | 120.0 |
| 2021-05-27 | EW | Futures | 2900.1 | 2922.7 | 2886.9 | 2915.1 | 7593.0 |
| 2021-05-27 | FBON | Futures | 147.57 | 147.57 | 147.09 | 147.09 | 464.0 |
| 2021-05-27 | FBTP | Futures | 137.2 | 137.28 | 136.89 | 136.93 | 158710.0 |
| 2021-05-27 | FBTS | Futures | 110.039 | 110.059 | 110.0 | 110.039 | 82543.0 |
| 2021-05-27 | FCE | Futures | 6368.0 | 6436.3 | 6346.5 | 6404.4 | 54627.0 |
| 2021-05-27 | FDAX | Futures | 16469.5 | 16510.0 | 16358.6 | 16438.5 | 47726.0 |
| 2021-05-27 | FDIV | Futures | 186.57 | 187.21 | 186.18 | 186.42 | 70.0 |
| 2021-05-27 | FDXM | Futures | 16456.9 | 16489.9 | 16338.7 | 16418.5 | 45941.0 |
| 2021-05-27 | FDXS | Futures | 16367.0 | 16400.9 | 16251.6 | 16331.0 | 2341.0 |
| 2021-05-27 | FESX | Futures | 3809.3 | 3832.0 | 3796.0 | 3816.8 | 754802.0 |
| 2021-05-27 | FEU3 | Futures | 99.198 | 99.203 | 99.198 | 99.203 | 200.0 |
| 2021-05-27 | FGBL | Futures | 166.51 | 166.59 | 165.9 | 166.01 | 784831.0 |
| 2021-05-27 | FGBM | Futures | 134.58 | 134.59 | 134.37 | 134.41 | 419219.0 |
| 2021-05-27 | FGBS | Futures | 112.599 | 112.604 | 112.569 | 112.579 | 356974.0 |
| 2021-05-27 | FGBX | Futures | 214.94 | 215.13 | 212.71 | 213.01 | 84738.0 |
| 2021-05-27 | FMWO | Futures | 10419.1 | 10493.1 | 10419.1 | 10470.8 | 2298.0 |
| 2021-05-27 | FOAT | Futures | 154.73 | 154.73 | 154.13 | 154.21 | 189337.0 |
| 2021-05-27 | FTDX | Futures | 3475.6 | 3492.0 | 3468.4 | 3469.9 | 52.0 |
| 2021-05-27 | FTI | Futures | 678.5 | 678.64 | 672.17 | 674.36 | 16779.0 |
| 2021-05-27 | FTUK | Futures | 6835.8 | 6855.8 | 6810.0 | 6829.0 | 101432.0 |
| 2021-05-27 | FVSA | Futures | 103.64 | 103.64 | 96.09 | 97.91 | 22674.0 |
> showing 50 of 123 rows — these rows as CSV