PREVIEW / futures_daily / 2020-09-09
file: by_date/futures_daily/2020/2020-09-09.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-09-09 | ES | Futures | 3731.6 | 3854.01 | 3709.37 | 3827.28 | 2011132.0 |
| 2020-09-09 | NQ | Futures | 12774.0 | 13322.69 | 12691.88 | 13222.88 | 720954.0 |
| 2020-09-09 | YM | Futures | 29338.6 | 30217.4 | 29133.9 | 29977.3 | 220385.0 |
| 2020-09-09 | CL | Futures | 26.61 | 27.81 | 26.15 | 27.52 | 455356.0 |
| 2020-09-09 | GC | Futures | 2290.5 | 2314.4 | 2275.0 | 2308.8 | 227182.0 |
| 2020-09-09 | ZN | Futures | 138.357689 | 138.481665 | 138.078742 | 138.156227 | 1206560.0 |
| 2020-09-09 | A6 | Futures | 0.74096 | 0.7497 | 0.73983 | 0.74796 | 206382.0 |
| 2020-09-09 | AD | Futures | 0.76672 | 0.77215 | 0.76555 | 0.77108 | 135093.0 |
| 2020-09-09 | ALI | Futures | 2139.72 | 2142.7 | 2119.47 | 2132.58 | 258.0 |
| 2020-09-09 | B | Futures | 25.27 | 26.26 | 25.1 | 26.0 | 278218.0 |
| 2020-09-09 | B6 | Futures | 1.3178 | 1.3224 | 1.3083 | 1.3191 | 209095.0 |
| 2020-09-09 | BR | Futures | 0.14793 | 0.14836 | 0.14793 | 0.14836 | 1.0 |
| 2020-09-09 | BTC | Futures | 13582.8 | 14021.6 | 13299.2 | 13933.8 | 5218.0 |
| 2020-09-09 | BZ | Futures | 24.82 | 25.69 | 24.49 | 25.44 | 30286.0 |
| 2020-09-09 | C | Futures | 1600.0 | 1602.0 | 1581.0 | 1584.0 | 1339.0 |
| 2020-09-09 | CB | Futures | 168.543 | 169.483 | 168.518 | 169.483 | 7.0 |
| 2020-09-09 | CC | Futures | 1680.0 | 1689.0 | 1667.0 | 1682.0 | 13989.0 |
| 2020-09-09 | CNH | Futures | 6.7529 | 6.7602 | 6.7303 | 6.7303 | 510.0 |
| 2020-09-09 | CSC | Futures | 3.258 | 3.258 | 3.24 | 3.251 | 45.0 |
| 2020-09-09 | CT | Futures | 63.77 | 64.07 | 63.77 | 64.07 | 16.0 |
| 2020-09-09 | DC | Futures | 26.36 | 26.36 | 26.14 | 26.25 | 108.0 |
| 2020-09-09 | DX | Futures | 90.348 | 90.474 | 89.952 | 90.081 | 24803.0 |
| 2020-09-09 | E1 | Futures | 1.2375 | 1.24556 | 1.23591 | 1.24466 | 42223.0 |
| 2020-09-09 | E6 | Futures | 1.26332 | 1.27002 | 1.26112 | 1.26713 | 426011.0 |
| 2020-09-09 | E7 | Futures | 1.2569 | 1.2637 | 1.2549 | 1.2608 | 12585.0 |
| 2020-09-09 | EBM | Futures | 227.54 | 228.15 | 226.94 | 227.54 | 18982.0 |
| 2020-09-09 | ED | Futures | 96.4306 | 96.4306 | 96.4233 | 96.4258 | 122069.0 |
| 2020-09-09 | ER | Futures | 98.411 | 98.416 | 98.406 | 98.411 | 86481.0 |
| 2020-09-09 | ESG | Futures | 308.35 | 311.75 | 308.35 | 309.52 | 28.0 |
| 2020-09-09 | EW | Futures | 1962.5 | 2008.4 | 1945.9 | 1998.6 | 20042.0 |
| 2020-09-09 | FBON | Futures | 147.25 | 147.33 | 146.75 | 146.79 | 481.0 |
| 2020-09-09 | FBTP | Futures | 132.92 | 133.3 | 132.8 | 132.87 | 101924.0 |
| 2020-09-09 | FBTS | Futures | 108.938 | 109.016 | 108.919 | 108.967 | 65258.0 |
| 2020-09-09 | FCE | Futures | 4830.4 | 4940.4 | 4808.4 | 4908.7 | 70728.0 |
| 2020-09-09 | FDAX | Futures | 13712.2 | 14146.2 | 13675.0 | 14076.6 | 86880.0 |
| 2020-09-09 | FDIV | Futures | 153.93 | 155.12 | 153.37 | 155.12 | 256.0 |
| 2020-09-09 | FDXM | Futures | 13664.9 | 14094.6 | 13622.5 | 14025.8 | 68294.0 |
| 2020-09-09 | FESX | Futures | 3000.1 | 3089.7 | 2992.7 | 3074.0 | 1041706.0 |
| 2020-09-09 | FEU3 | Futures | 99.154 | 99.159 | 99.154 | 99.159 | 115.0 |
| 2020-09-09 | FGBL | Futures | 169.55 | 169.62 | 168.74 | 168.91 | 609162.0 |
| 2020-09-09 | FGBM | Futures | 135.19 | 135.19 | 134.9 | 134.96 | 379964.0 |
| 2020-09-09 | FGBS | Futures | 112.769 | 112.795 | 112.744 | 112.754 | 319427.0 |
| 2020-09-09 | FGBX | Futures | 230.3 | 230.57 | 227.54 | 227.94 | 49913.0 |
| 2020-09-09 | FMWO | Futures | 8298.0 | 8468.7 | 8269.6 | 8418.9 | 3202.0 |
| 2020-09-09 | FOAT | Futures | 157.16 | 157.2 | 156.54 | 156.62 | 134051.0 |
| 2020-09-09 | FTDX | Futures | 3095.0 | 3167.6 | 3095.0 | 3160.9 | 98.0 |
| 2020-09-09 | FTI | Futures | 502.7 | 516.91 | 500.46 | 514.41 | 33144.0 |
| 2020-09-09 | FTUK | Futures | 5544.2 | 5706.7 | 5543.2 | 5696.8 | 136961.0 |
| 2020-09-09 | FVSA | Futures | 219.52 | 226.99 | 206.66 | 209.56 | 18301.0 |
| 2020-09-09 | FXXP | Futures | 334.8 | 342.7 | 333.4 | 341.6 | 65895.0 |
> showing 50 of 122 rows — these rows as CSV