PREVIEW / futures_daily / 2020-08-21
file: by_date/futures_daily/2020/2020-08-21.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 |
|---|---|---|---|---|---|---|---|
| 2020-08-21 | ES | Futures | 3808.42 | 3822.77 | 3778.31 | 3818.55 | 1221450.0 |
| 2020-08-21 | NQ | Futures | 13324.14 | 13432.66 | 13239.41 | 13419.31 | 414226.0 |
| 2020-08-21 | YM | Futures | 29660.1 | 29904.5 | 29442.6 | 29856.2 | 175756.0 |
| 2020-08-21 | CL | Futures | 30.92 | 31.07 | 29.98 | 30.62 | 345368.0 |
| 2020-08-21 | GC | Futures | 2309.6 | 2318.4 | 2263.5 | 2299.4 | 355065.0 |
| 2020-08-21 | ZN | Futures | 138.248978 | 138.481251 | 138.171553 | 138.310917 | 994185.0 |
| 2020-08-21 | A6 | Futures | 0.74014 | 0.7424 | 0.73448 | 0.73664 | 76424.0 |
| 2020-08-21 | AD | Futures | 0.77022 | 0.77139 | 0.76697 | 0.76961 | 48941.0 |
| 2020-08-21 | ALI | Futures | 2131.38 | 2132.87 | 2114.11 | 2124.24 | 347.0 |
| 2020-08-21 | B | Futures | 29.03 | 29.06 | 28.1 | 28.59 | 221992.0 |
| 2020-08-21 | B6 | Futures | 1.3421 | 1.346 | 1.3262 | 1.3297 | 113024.0 |
| 2020-08-21 | BR | Futures | 0.14274 | 0.1435 | 0.14068 | 0.1412 | 5242.0 |
| 2020-08-21 | BTC | Futures | 16587.8 | 16587.8 | 15869.6 | 15999.6 | 9663.0 |
| 2020-08-21 | BZ | Futures | 28.27 | 28.4 | 27.45 | 27.92 | 25495.0 |
| 2020-08-21 | C | Futures | 1476.0 | 1490.0 | 1454.0 | 1486.0 | 2418.0 |
| 2020-08-21 | CB | Futures | 173.856 | 173.856 | 172.305 | 172.787 | 30.0 |
| 2020-08-21 | CC | Futures | 1576.0 | 1589.0 | 1546.0 | 1582.0 | 15638.0 |
| 2020-08-21 | CNH | Futures | 6.8079 | 6.8285 | 6.7994 | 6.8269 | 545.0 |
| 2020-08-21 | CSC | Futures | 3.176 | 3.202 | 3.163 | 3.186 | 95.0 |
| 2020-08-21 | CT | Futures | 64.49 | 64.49 | 64.29 | 64.45 | 4.0 |
| 2020-08-21 | DC | Futures | 25.96 | 26.04 | 25.63 | 25.81 | 333.0 |
| 2020-08-21 | DX | Futures | 89.532 | 90.295 | 89.412 | 90.064 | 25532.0 |
| 2020-08-21 | E1 | Futures | 1.2517 | 1.2542 | 1.24329 | 1.24568 | 21141.0 |
| 2020-08-21 | E6 | Futures | 1.27346 | 1.2756 | 1.26171 | 1.26546 | 195602.0 |
| 2020-08-21 | E7 | Futures | 1.267 | 1.2693 | 1.2554 | 1.2592 | 8321.0 |
| 2020-08-21 | EBM | Futures | 218.26 | 223.65 | 218.26 | 223.05 | 15147.0 |
| 2020-08-21 | ED | Futures | 96.4451 | 96.4499 | 96.4427 | 96.4451 | 76310.0 |
| 2020-08-21 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.406 | 25344.0 |
| 2020-08-21 | ESG | Futures | 308.46 | 310.28 | 308.46 | 310.28 | 105.0 |
| 2020-08-21 | EW | Futures | 2036.9 | 2040.0 | 2014.6 | 2029.9 | 10251.0 |
| 2020-08-21 | FBON | Futures | 147.14 | 147.24 | 146.93 | 147.02 | 163.0 |
| 2020-08-21 | FBTP | Futures | 133.96 | 134.02 | 133.5 | 133.68 | 56808.0 |
| 2020-08-21 | FBTS | Futures | 109.074 | 109.103 | 109.006 | 109.035 | 31853.0 |
| 2020-08-21 | FCE | Futures | 4793.4 | 4804.1 | 4705.2 | 4762.2 | 80316.0 |
| 2020-08-21 | FDAX | Futures | 13699.5 | 13742.5 | 13413.1 | 13545.9 | 76804.0 |
| 2020-08-21 | FDIV | Futures | 147.11 | 147.11 | 146.78 | 146.78 | 15.0 |
| 2020-08-21 | FDXM | Futures | 13650.0 | 13693.4 | 13363.2 | 13497.1 | 50569.0 |
| 2020-08-21 | FESX | Futures | 3033.3 | 3042.6 | 2968.7 | 3001.0 | 936843.0 |
| 2020-08-21 | FEU3 | Futures | 99.154 | 99.154 | 99.154 | 99.154 | 35.0 |
| 2020-08-21 | FGBL | Futures | 168.99 | 169.47 | 168.88 | 169.21 | 531631.0 |
| 2020-08-21 | FGBM | Futures | 134.92 | 135.09 | 134.88 | 134.99 | 324380.0 |
| 2020-08-21 | FGBS | Futures | 112.739 | 112.764 | 112.724 | 112.744 | 248451.0 |
| 2020-08-21 | FGBX | Futures | 229.63 | 230.83 | 228.99 | 229.78 | 39143.0 |
| 2020-08-21 | FMWO | Futures | 8399.9 | 8410.6 | 8327.7 | 8383.4 | 1481.0 |
| 2020-08-21 | FOAT | Futures | 156.59 | 156.83 | 156.54 | 156.64 | 111444.0 |
| 2020-08-21 | FTDX | Futures | 3153.8 | 3157.4 | 3124.7 | 3151.2 | 43.0 |
| 2020-08-21 | FTI | Futures | 515.52 | 516.77 | 507.27 | 513.35 | 28492.0 |
| 2020-08-21 | FTUK | Futures | 5687.4 | 5711.5 | 5616.9 | 5664.7 | 84278.0 |
| 2020-08-21 | FVSA | Futures | 203.75 | 216.2 | 203.75 | 209.15 | 31192.0 |
| 2020-08-21 | FXXP | Futures | 338.1 | 339.4 | 333.6 | 336.5 | 49184.0 |
> showing 50 of 122 rows — these rows as CSV