PREVIEW / futures_daily / 2020-05-21
file: by_date/futures_daily/2020/2020-05-21.parquet size: 10 KB rows: 120
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-05-21 | ES | Futures | 3288.75 | 3290.14 | 3245.32 | 3249.75 | 1608225.0 |
| 2020-05-21 | NQ | Futures | 10885.16 | 10903.5 | 10721.51 | 10725.8 | 429220.0 |
| 2020-05-21 | YM | Futures | 26190.8 | 26313.5 | 25929.4 | 26010.5 | 213835.0 |
| 2020-05-21 | CL | Futures | 24.31 | 25.13 | 24.11 | 24.59 | 372814.0 |
| 2020-05-21 | GC | Futures | 2124.3 | 2124.3 | 2080.2 | 2088.2 | 238735.0 |
| 2020-05-21 | ZN | Futures | 137.33074 | 137.531403 | 137.299869 | 137.377047 | 1429655.0 |
| 2020-05-21 | A6 | Futures | 0.67775 | 0.67795 | 0.67281 | 0.67446 | 94427.0 |
| 2020-05-21 | AD | Futures | 0.72891 | 0.72946 | 0.72531 | 0.72657 | 53212.0 |
| 2020-05-21 | ALI | Futures | 1820.41 | 1826.95 | 1820.41 | 1826.95 | 4.0 |
| 2020-05-21 | B | Futures | 23.65 | 24.42 | 23.61 | 23.81 | 178546.0 |
| 2020-05-21 | B6 | Futures | 1.242 | 1.2435 | 1.237 | 1.2421 | 70209.0 |
| 2020-05-21 | BR | Futures | 0.14366 | 0.14755 | 0.14263 | 0.14722 | 4477.0 |
| 2020-05-21 | BTC | Futures | 13331.1 | 13365.9 | 12260.2 | 12621.8 | 8797.0 |
| 2020-05-21 | BZ | Futures | 22.89 | 23.64 | 22.83 | 23.05 | 29933.0 |
| 2020-05-21 | C | Futures | 1876.0 | 1883.0 | 1848.0 | 1861.0 | 4961.0 |
| 2020-05-21 | CB | Futures | 188.629 | 188.629 | 185.506 | 187.765 | 49.0 |
| 2020-05-21 | CC | Futures | 1566.0 | 1575.0 | 1520.0 | 1529.0 | 18245.0 |
| 2020-05-21 | CNH | Futures | 7.0482 | 7.0745 | 7.0438 | 7.0673 | 346.0 |
| 2020-05-21 | CSC | Futures | 3.392 | 3.455 | 3.374 | 3.407 | 166.0 |
| 2020-05-21 | CT | Futures | 56.68 | 57.22 | 55.87 | 56.6 | 15732.0 |
| 2020-05-21 | DC | Futures | 27.94 | 28.45 | 27.7 | 28.04 | 583.0 |
| 2020-05-21 | DX | Futures | 95.905 | 96.253 | 95.76 | 96.12 | 11523.0 |
| 2020-05-21 | E1 | Futures | 1.18112 | 1.18146 | 1.17315 | 1.17451 | 18504.0 |
| 2020-05-21 | E6 | Futures | 1.18052 | 1.18375 | 1.17596 | 1.178 | 138798.0 |
| 2020-05-21 | E7 | Futures | 1.1744 | 1.1775 | 1.1698 | 1.1719 | 6179.0 |
| 2020-05-21 | EBM | Futures | 226.34 | 227.84 | 225.44 | 227.54 | 25075.0 |
| 2020-05-21 | ED | Futures | 96.404 | 96.404 | 96.3847 | 96.3895 | 158443.0 |
| 2020-05-21 | ER | Futures | 98.289 | 98.293 | 98.279 | 98.284 | 34433.0 |
| 2020-05-21 | ESG | Futures | 267.46 | 267.46 | 266.55 | 266.63 | 55.0 |
| 2020-05-21 | EW | Futures | 1791.7 | 1801.6 | 1768.6 | 1794.3 | 14049.0 |
| 2020-05-21 | FBON | Futures | 141.68 | 141.68 | 141.22 | 141.62 | 489.0 |
| 2020-05-21 | FBTP | Futures | 125.47 | 125.73 | 124.95 | 125.52 | 75710.0 |
| 2020-05-21 | FBTS | Futures | 107.403 | 107.441 | 107.239 | 107.383 | 61845.0 |
| 2020-05-21 | FCE | Futures | 4316.4 | 4359.7 | 4292.2 | 4307.7 | 64511.0 |
| 2020-05-21 | FDAX | Futures | 11836.1 | 11846.7 | 11665.8 | 11684.3 | 64031.0 |
| 2020-05-21 | FDIV | Futures | 124.33 | 124.43 | 124.05 | 124.05 | 52.0 |
| 2020-05-21 | FDXM | Futures | 11897.9 | 11899.0 | 11720.5 | 11740.1 | 54962.0 |
| 2020-05-21 | FESX | Futures | 2677.3 | 2689.2 | 2649.8 | 2654.4 | 858671.0 |
| 2020-05-21 | FGBL | Futures | 168.06 | 168.43 | 167.83 | 168.31 | 432754.0 |
| 2020-05-21 | FGBM | Futures | 134.66 | 134.8 | 134.57 | 134.76 | 295682.0 |
| 2020-05-21 | FGBS | Futures | 112.79 | 112.835 | 112.785 | 112.815 | 203949.0 |
| 2020-05-21 | FGBX | Futures | 227.16 | 227.97 | 226.1 | 227.35 | 32434.0 |
| 2020-05-21 | FMWO | Futures | 7198.6 | 7270.4 | 7170.4 | 7185.6 | 2745.0 |
| 2020-05-21 | FOAT | Futures | 153.2 | 153.34 | 152.76 | 153.25 | 111625.0 |
| 2020-05-21 | FTDX | Futures | 3106.9 | 3128.6 | 3103.8 | 3103.8 | 90.0 |
| 2020-05-21 | FTI | Futures | 490.94 | 492.8 | 485.72 | 486.45 | 21150.0 |
| 2020-05-21 | FTUK | Futures | 5703.5 | 5744.1 | 5655.9 | 5669.1 | 89809.0 |
| 2020-05-21 | FVSA | Futures | 265.56 | 272.35 | 258.32 | 271.89 | 11826.0 |
| 2020-05-21 | FXXP | Futures | 314.3 | 317.2 | 313.0 | 313.9 | 52770.0 |
| 2020-05-21 | G | Futures | 126.48 | 126.93 | 126.37 | 126.84 | 312289.0 |
> showing 50 of 120 rows — these rows as CSV