PREVIEW / futures_daily / 2020-07-08
file: by_date/futures_daily/2020/2020-07-08.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-07-08 | ES | Futures | 3529.0 | 3563.89 | 3518.02 | 3560.79 | 1527612.0 |
| 2020-07-08 | NQ | Futures | 12216.89 | 12387.51 | 12192.81 | 12375.03 | 481023.0 |
| 2020-07-08 | YM | Futures | 27617.5 | 27862.9 | 27500.7 | 27830.8 | 209659.0 |
| 2020-07-08 | CL | Futures | 29.35 | 29.78 | 29.22 | 29.65 | 286740.0 |
| 2020-07-08 | GC | Futures | 2170.6 | 2196.9 | 2165.7 | 2185.8 | 247500.0 |
| 2020-07-08 | ZN | Futures | 138.00122 | 138.03219 | 137.768947 | 137.93928 | 928752.0 |
| 2020-07-08 | A6 | Futures | 0.71473 | 0.71895 | 0.71277 | 0.71843 | 77895.0 |
| 2020-07-08 | AD | Futures | 0.74627 | 0.75246 | 0.7452 | 0.75205 | 62671.0 |
| 2020-07-08 | ALI | Futures | 1984.9 | 2026.31 | 1984.9 | 2022.38 | 49.0 |
| 2020-07-08 | B | Futures | 27.89 | 28.32 | 27.85 | 28.2 | 185142.0 |
| 2020-07-08 | B6 | Futures | 1.2745 | 1.2822 | 1.2707 | 1.2821 | 80648.0 |
| 2020-07-08 | BR | Futures | 0.14734 | 0.14801 | 0.14706 | 0.14797 | 8.0 |
| 2020-07-08 | BTC | Futures | 12822.5 | 13180.6 | 12788.1 | 13098.0 | 5163.0 |
| 2020-07-08 | BZ | Futures | 27.36 | 27.68 | 27.25 | 27.57 | 19171.0 |
| 2020-07-08 | C | Futures | 1422.0 | 1434.0 | 1386.0 | 1406.0 | 700.0 |
| 2020-07-08 | CB | Futures | 200.63 | 200.63 | 196.324 | 196.351 | 61.0 |
| 2020-07-08 | CC | Futures | 1405.0 | 1409.0 | 1372.0 | 1377.0 | 16665.0 |
| 2020-07-08 | CNH | Futures | 6.9387 | 6.9459 | 6.9167 | 6.9167 | 282.0 |
| 2020-07-08 | CSC | Futures | 3.95 | 3.96 | 3.917 | 3.948 | 34.0 |
| 2020-07-08 | CT | Futures | 64.41 | 65.4 | 64.41 | 65.3 | 11.0 |
| 2020-07-08 | DC | Futures | 32.58 | 32.58 | 32.1 | 32.52 | 202.0 |
| 2020-07-08 | DX | Futures | 93.609 | 93.7 | 93.063 | 93.085 | 18909.0 |
| 2020-07-08 | E1 | Futures | 1.2074 | 1.21456 | 1.20638 | 1.21331 | 18091.0 |
| 2020-07-08 | E6 | Futures | 1.21165 | 1.21986 | 1.21026 | 1.2182 | 180863.0 |
| 2020-07-08 | E7 | Futures | 1.2056 | 1.2137 | 1.2043 | 1.2121 | 5639.0 |
| 2020-07-08 | EBM | Futures | 221.55 | 224.24 | 221.55 | 223.94 | 23837.0 |
| 2020-07-08 | ED | Futures | 96.4185 | 96.4185 | 96.404 | 96.4137 | 142843.0 |
| 2020-07-08 | ER | Futures | 98.377 | 98.382 | 98.372 | 98.372 | 49404.0 |
| 2020-07-08 | ESG | Futures | 285.99 | 287.84 | 284.83 | 287.84 | 260.0 |
| 2020-07-08 | EW | Futures | 1874.2 | 1891.6 | 1860.5 | 1883.1 | 11017.0 |
| 2020-07-08 | FBON | Futures | 145.54 | 145.79 | 145.52 | 145.67 | 423.0 |
| 2020-07-08 | FBTP | Futures | 130.45 | 130.86 | 130.45 | 130.6 | 54141.0 |
| 2020-07-08 | FBTS | Futures | 108.434 | 108.541 | 108.434 | 108.502 | 24320.0 |
| 2020-07-08 | FCE | Futures | 4893.3 | 4934.5 | 4861.9 | 4874.2 | 58332.0 |
| 2020-07-08 | FDAX | Futures | 13339.8 | 13448.7 | 13221.4 | 13250.1 | 81907.0 |
| 2020-07-08 | FDIV | Futures | 143.89 | 143.89 | 143.7 | 143.7 | 21.0 |
| 2020-07-08 | FDXM | Futures | 13284.8 | 13401.3 | 13172.6 | 13202.3 | 48105.0 |
| 2020-07-08 | FESX | Futures | 3041.7 | 3061.0 | 3014.9 | 3023.2 | 864522.0 |
| 2020-07-08 | FGBL | Futures | 168.27 | 168.5 | 168.18 | 168.28 | 435688.0 |
| 2020-07-08 | FGBM | Futures | 134.69 | 134.76 | 134.65 | 134.69 | 327433.0 |
| 2020-07-08 | FGBS | Futures | 112.734 | 112.759 | 112.724 | 112.734 | 167889.0 |
| 2020-07-08 | FGBX | Futures | 225.57 | 227.2 | 225.53 | 226.46 | 43086.0 |
| 2020-07-08 | FMWO | Futures | 7878.5 | 7914.1 | 7827.5 | 7848.9 | 1239.0 |
| 2020-07-08 | FOAT | Futures | 155.63 | 155.81 | 155.51 | 155.61 | 117426.0 |
| 2020-07-08 | FTDX | Futures | 3085.3 | 3101.2 | 3074.1 | 3075.1 | 27.0 |
| 2020-07-08 | FTI | Futures | 530.48 | 536.28 | 529.14 | 530.5 | 26672.0 |
| 2020-07-08 | FTUK | Futures | 5786.6 | 5833.9 | 5751.2 | 5782.3 | 80437.0 |
| 2020-07-08 | FVSA | Futures | 266.85 | 267.75 | 254.29 | 265.5 | 12247.0 |
| 2020-07-08 | FXXP | Futures | 336.5 | 339.7 | 335.4 | 336.9 | 40883.0 |
| 2020-07-08 | G | Futures | 127.26 | 127.41 | 127.0 | 127.13 | 145132.0 |
> showing 50 of 120 rows — these rows as CSV