PREVIEW / futures_daily / 2018-08-03
file: by_date/futures_daily/2018/2018-08-03.parquet size: 10 KB rows: 114
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 |
|---|---|---|---|---|---|---|---|
| 2018-08-03 | ES | Futures | 3074.47 | 3086.15 | 3067.95 | 3083.97 | 922242.0 |
| 2018-08-03 | NQ | Futures | 8618.35 | 8645.16 | 8583.66 | 8630.01 | 298355.0 |
| 2018-08-03 | YM | Futures | 26686.9 | 26802.8 | 26616.3 | 26774.3 | 115235.0 |
| 2018-08-03 | CL | Futures | 71.38 | 71.64 | 70.22 | 70.86 | 476615.0 |
| 2018-08-03 | GC | Futures | 1541.2 | 1557.0 | 1536.7 | 1550.3 | 280209.0 |
| 2018-08-03 | ZN | Futures | 118.639894 | 118.981751 | 118.577738 | 118.950673 | 1284592.0 |
| 2018-08-03 | A6 | Futures | 0.7575 | 0.76244 | 0.75586 | 0.76172 | 111225.0 |
| 2018-08-03 | AD | Futures | 0.77801 | 0.78181 | 0.77725 | 0.7809 | 78474.0 |
| 2018-08-03 | B | Futures | 53.48 | 53.75 | 52.84 | 53.37 | 175359.0 |
| 2018-08-03 | B6 | Futures | 1.3453 | 1.3478 | 1.3409 | 1.3441 | 95354.0 |
| 2018-08-03 | BR | Futures | 0.20186 | 0.20513 | 0.20186 | 0.20479 | 2396.0 |
| 2018-08-03 | BTC | Futures | 10720.1 | 10770.0 | 10356.8 | 10499.3 | 5700.0 |
| 2018-08-03 | BZ | Futures | 53.46 | 53.67 | 52.76 | 53.29 | 15946.0 |
| 2018-08-03 | C | Futures | 1465.0 | 1476.0 | 1447.0 | 1454.0 | 7949.0 |
| 2018-08-03 | CB | Futures | 278.849 | 280.048 | 278.849 | 279.509 | 7.0 |
| 2018-08-03 | CC | Futures | 1483.0 | 1497.0 | 1462.0 | 1467.0 | 24374.0 |
| 2018-08-03 | CNH | Futures | 6.951 | 6.9868 | 6.904 | 6.9226 | 652.0 |
| 2018-08-03 | CSC | Futures | 3.226 | 3.238 | 3.218 | 3.236 | 37.0 |
| 2018-08-03 | CT | Futures | 100.3 | 100.87 | 98.07 | 99.49 | 48.0 |
| 2018-08-03 | DC | Futures | 26.08 | 26.2 | 25.96 | 26.13 | 195.0 |
| 2018-08-03 | DX | Futures | 89.984 | 90.159 | 89.781 | 89.938 | 22574.0 |
| 2018-08-03 | E1 | Futures | 1.20445 | 1.20863 | 1.20325 | 1.20624 | 25822.0 |
| 2018-08-03 | E6 | Futures | 1.29977 | 1.30251 | 1.29664 | 1.29882 | 267096.0 |
| 2018-08-03 | E7 | Futures | 1.293 | 1.2959 | 1.2901 | 1.2923 | 3292.0 |
| 2018-08-03 | EBM | Futures | 223.88 | 224.14 | 219.7 | 220.74 | 15704.0 |
| 2018-08-03 | ED | Futures | 95.0107 | 95.0253 | 95.0107 | 95.0253 | 208226.0 |
| 2018-08-03 | ER | Futures | 98.362 | 98.367 | 98.357 | 98.362 | 110022.0 |
| 2018-08-03 | EW | Futures | 2115.0 | 2123.4 | 2109.5 | 2119.0 | 9399.0 |
| 2018-08-03 | FBON | Futures | 128.43 | 128.97 | 128.4 | 128.8 | 129.0 |
| 2018-08-03 | FBTP | Futures | 106.1 | 106.16 | 104.39 | 105.83 | 116206.0 |
| 2018-08-03 | FBTS | Futures | 102.169 | 102.281 | 101.186 | 102.058 | 93404.0 |
| 2018-08-03 | FCE | Futures | 4911.4 | 4932.1 | 4895.7 | 4913.7 | 45406.0 |
| 2018-08-03 | FDAX | Futures | 13150.3 | 13214.1 | 13121.0 | 13183.2 | 66476.0 |
| 2018-08-03 | FDXM | Futures | 12986.4 | 13046.3 | 12954.4 | 13014.8 | 28313.0 |
| 2018-08-03 | FESX | Futures | 2908.2 | 2915.7 | 2894.8 | 2907.3 | 699046.0 |
| 2018-08-03 | FEU3 | Futures | 99.011 | 99.011 | 99.011 | 99.011 | 24.0 |
| 2018-08-03 | FGBL | Futures | 152.05 | 152.76 | 152.05 | 152.7 | 668983.0 |
| 2018-08-03 | FGBM | Futures | 130.66 | 130.91 | 130.65 | 130.87 | 357474.0 |
| 2018-08-03 | FGBS | Futures | 112.578 | 112.653 | 112.578 | 112.618 | 393956.0 |
| 2018-08-03 | FGBX | Futures | 175.15 | 176.95 | 175.09 | 176.73 | 39079.0 |
| 2018-08-03 | FMWO | Futures | 7147.5 | 7175.4 | 7140.5 | 7168.4 | 732.0 |
| 2018-08-03 | FOAT | Futures | 139.78 | 140.3 | 139.77 | 140.29 | 118685.0 |
| 2018-08-03 | FTDX | Futures | 2838.2 | 2874.0 | 2838.2 | 2862.7 | 169.0 |
| 2018-08-03 | FTI | Futures | 527.21 | 528.55 | 525.5 | 526.89 | 20159.0 |
| 2018-08-03 | FTUK | Futures | 6742.6 | 6790.2 | 6708.3 | 6776.4 | 82511.0 |
| 2018-08-03 | FVSA | Futures | 275.16 | 278.98 | 268.47 | 272.29 | 18011.0 |
| 2018-08-03 | FXXP | Futures | 335.0 | 336.9 | 333.9 | 335.8 | 34534.0 |
| 2018-08-03 | G | Futures | 114.9 | 115.19 | 114.71 | 115.16 | 202311.0 |
| 2018-08-03 | GF | Futures | 312.289 | 316.795 | 311.409 | 316.64 | 1767.0 |
| 2018-08-03 | GSCI | Futures | 521.28 | 522.35 | 520.09 | 520.6 | 132.0 |
> showing 50 of 114 rows — these rows as CSV