PREVIEW / futures_daily / 2021-04-28
file: by_date/futures_daily/2021/2021-04-28.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-04-28 | ES | Futures | 4690.89 | 4706.03 | 4682.47 | 4686.4 | 1282972.0 |
| 2021-04-28 | NQ | Futures | 16096.54 | 16140.37 | 16007.15 | 16023.59 | 501596.0 |
| 2021-04-28 | YM | Futures | 36599.2 | 36656.5 | 36463.9 | 36500.7 | 111004.0 |
| 2021-04-28 | CL | Futures | 44.88 | 45.95 | 44.62 | 45.47 | 387683.0 |
| 2021-04-28 | GC | Futures | 2082.5 | 2089.9 | 2065.4 | 2079.6 | 198578.0 |
| 2021-04-28 | ZN | Futures | 132.688556 | 132.877012 | 132.390168 | 132.76708 | 1705772.0 |
| 2021-04-28 | A6 | Futures | 0.79669 | 0.80002 | 0.79228 | 0.79936 | 96257.0 |
| 2021-04-28 | AD | Futures | 0.81693 | 0.82311 | 0.81597 | 0.82271 | 86695.0 |
| 2021-04-28 | ALI | Futures | 2751.51 | 2762.93 | 2751.22 | 2756.65 | 86.0 |
| 2021-04-28 | B | Futures | 43.2 | 44.06 | 42.87 | 43.68 | 375933.0 |
| 2021-04-28 | B6 | Futures | 1.4122 | 1.4167 | 1.4076 | 1.4162 | 72414.0 |
| 2021-04-28 | BR | Futures | 0.14443 | 0.14767 | 0.14305 | 0.14712 | 10729.0 |
| 2021-04-28 | BTC | Futures | 76583.5 | 78406.5 | 74808.9 | 76915.0 | 4383.0 |
| 2021-04-28 | BZ | Futures | 42.15 | 43.0 | 41.85 | 42.63 | 37322.0 |
| 2021-04-28 | C | Futures | 1480.0 | 1492.0 | 1471.0 | 1483.0 | 2357.0 |
| 2021-04-28 | CB | Futures | 151.305 | 151.305 | 149.86 | 151.099 | 38.0 |
| 2021-04-28 | CC | Futures | 1637.0 | 1652.0 | 1634.0 | 1647.0 | 8022.0 |
| 2021-04-28 | CNH | Futures | 6.2982 | 6.3037 | 6.289 | 6.2926 | 421.0 |
| 2021-04-28 | CSC | Futures | 2.97 | 2.998 | 2.963 | 2.997 | 29.0 |
| 2021-04-28 | CT | Futures | 85.02 | 85.02 | 82.64 | 83.47 | 13462.0 |
| 2021-04-28 | DC | Futures | 27.49 | 27.87 | 27.49 | 27.72 | 155.0 |
| 2021-04-28 | DX | Futures | 87.808 | 88.04 | 87.48 | 87.546 | 22954.0 |
| 2021-04-28 | E1 | Futures | 1.23263 | 1.23972 | 1.22723 | 1.23826 | 23429.0 |
| 2021-04-28 | E6 | Futures | 1.2896 | 1.29428 | 1.28587 | 1.29322 | 193239.0 |
| 2021-04-28 | E7 | Futures | 1.2829 | 1.2877 | 1.2794 | 1.2867 | 5619.0 |
| 2021-04-28 | EBM | Futures | 310.36 | 322.17 | 309.4 | 320.89 | 6536.0 |
| 2021-04-28 | ED | Futures | 96.4932 | 96.498 | 96.4835 | 96.498 | 203728.0 |
| 2021-04-28 | ER | Futures | 98.455 | 98.46 | 98.45 | 98.455 | 38117.0 |
| 2021-04-28 | ESG | Futures | 387.99 | 389.84 | 387.91 | 387.95 | 253.0 |
| 2021-04-28 | EW | Futures | 2952.0 | 2960.5 | 2938.2 | 2950.5 | 6397.0 |
| 2021-04-28 | FBON | Futures | 147.53 | 147.58 | 147.15 | 147.5 | 574.0 |
| 2021-04-28 | FBTP | Futures | 137.29 | 137.46 | 136.94 | 137.31 | 184747.0 |
| 2021-04-28 | FBTS | Futures | 109.961 | 110.01 | 109.932 | 109.961 | 69595.0 |
| 2021-04-28 | FCE | Futures | 6146.3 | 6188.3 | 6146.3 | 6174.5 | 46597.0 |
| 2021-04-28 | FDAX | Futures | 16287.2 | 16384.2 | 16256.3 | 16320.2 | 43431.0 |
| 2021-04-28 | FDIV | Futures | 183.97 | 183.97 | 183.87 | 183.87 | 138.0 |
| 2021-04-28 | FDXM | Futures | 16275.9 | 16364.2 | 16236.5 | 16300.4 | 49388.0 |
| 2021-04-28 | FDXS | Futures | 16163.7 | 16278.1 | 16154.2 | 16213.5 | 1461.0 |
| 2021-04-28 | FESX | Futures | 3752.6 | 3766.7 | 3745.0 | 3755.4 | 575395.0 |
| 2021-04-28 | FGBL | Futures | 166.79 | 166.87 | 166.25 | 166.68 | 803042.0 |
| 2021-04-28 | FGBM | Futures | 134.56 | 134.63 | 134.4 | 134.55 | 506642.0 |
| 2021-04-28 | FGBS | Futures | 112.629 | 112.639 | 112.604 | 112.624 | 229334.0 |
| 2021-04-28 | FGBX | Futures | 216.64 | 217.04 | 215.2 | 216.45 | 85222.0 |
| 2021-04-28 | FMWO | Futures | 10372.1 | 10410.9 | 10360.4 | 10390.9 | 1842.0 |
| 2021-04-28 | FOAT | Futures | 155.06 | 155.19 | 154.6 | 155.0 | 212173.0 |
| 2021-04-28 | FTDX | Futures | 3643.1 | 3643.1 | 3607.7 | 3612.3 | 310.0 |
| 2021-04-28 | FTI | Futures | 673.4 | 673.45 | 669.84 | 671.26 | 13831.0 |
| 2021-04-28 | FTUK | Futures | 6733.5 | 6773.0 | 6725.7 | 6752.0 | 68672.0 |
| 2021-04-28 | FVSA | Futures | 99.57 | 101.41 | 99.31 | 100.62 | 24161.0 |
| 2021-04-28 | FXXP | Futures | 413.8 | 415.2 | 412.8 | 414.3 | 77408.0 |
> showing 50 of 122 rows — these rows as CSV