PREVIEW / futures_daily / 2020-08-05
file: by_date/futures_daily/2020/2020-08-05.parquet size: 10 KB rows: 119
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-05 | ES | Futures | 3715.28 | 3740.61 | 3705.43 | 3732.45 | 1116787.0 |
| 2020-08-05 | NQ | Futures | 12860.47 | 12934.17 | 12831.74 | 12873.52 | 348822.0 |
| 2020-08-05 | YM | Futures | 28666.7 | 29057.8 | 28577.7 | 28994.6 | 155148.0 |
| 2020-08-05 | CL | Futures | 30.33 | 31.76 | 30.26 | 30.79 | 491268.0 |
| 2020-08-05 | GC | Futures | 2405.7 | 2445.0 | 2394.5 | 2420.2 | 366379.0 |
| 2020-08-05 | ZN | Futures | 139.131616 | 139.147101 | 138.744494 | 138.821918 | 1020589.0 |
| 2020-08-05 | A6 | Futures | 0.73674 | 0.74497 | 0.73602 | 0.73993 | 85743.0 |
| 2020-08-05 | AD | Futures | 0.76154 | 0.76713 | 0.76154 | 0.76428 | 79321.0 |
| 2020-08-05 | ALI | Futures | 2181.16 | 2187.54 | 2168.72 | 2172.66 | 204.0 |
| 2020-08-05 | B | Futures | 28.55 | 29.8 | 28.52 | 29.12 | 246975.0 |
| 2020-08-05 | B6 | Futures | 1.327 | 1.3367 | 1.3261 | 1.3321 | 94012.0 |
| 2020-08-05 | BR | Futures | 0.14944 | 0.15122 | 0.14881 | 0.1494 | 4970.0 |
| 2020-08-05 | BTC | Futures | 15575.5 | 16382.6 | 15308.7 | 16211.6 | 11366.0 |
| 2020-08-05 | BZ | Futures | 27.95 | 29.11 | 27.86 | 28.44 | 29337.0 |
| 2020-08-05 | C | Futures | 1515.0 | 1526.0 | 1507.0 | 1523.0 | 7687.0 |
| 2020-08-05 | CB | Futures | 171.422 | 173.856 | 167.33 | 171.717 | 41.0 |
| 2020-08-05 | CC | Futures | 1606.0 | 1630.0 | 1606.0 | 1625.0 | 23634.0 |
| 2020-08-05 | CNH | Futures | 6.8898 | 6.8898 | 6.8462 | 6.8534 | 768.0 |
| 2020-08-05 | CSC | Futures | 3.504 | 3.585 | 3.365 | 3.564 | 254.0 |
| 2020-08-05 | CT | Futures | 64.63 | 65.09 | 64.21 | 65.09 | 14.0 |
| 2020-08-05 | DC | Futures | 28.4 | 29.34 | 27.19 | 28.99 | 1208.0 |
| 2020-08-05 | DX | Futures | 89.972 | 90.059 | 89.383 | 89.687 | 20130.0 |
| 2020-08-05 | E1 | Futures | 1.24522 | 1.25635 | 1.24409 | 1.25158 | 29788.0 |
| 2020-08-05 | E6 | Futures | 1.26702 | 1.2785 | 1.26648 | 1.27373 | 210603.0 |
| 2020-08-05 | E7 | Futures | 1.2606 | 1.2721 | 1.2602 | 1.2674 | 6842.0 |
| 2020-08-05 | EBM | Futures | 215.26 | 216.46 | 214.36 | 214.66 | 11868.0 |
| 2020-08-05 | ED | Futures | 96.4572 | 96.4668 | 96.4572 | 96.4572 | 88530.0 |
| 2020-08-05 | ER | Futures | 98.386 | 98.391 | 98.382 | 98.382 | 50979.0 |
| 2020-08-05 | ESG | Futures | 301.69 | 301.92 | 301.3 | 301.92 | 13.0 |
| 2020-08-05 | EW | Futures | 2013.3 | 2041.4 | 2010.4 | 2040.0 | 10021.0 |
| 2020-08-05 | FBON | Futures | 147.57 | 147.57 | 146.74 | 146.79 | 63.0 |
| 2020-08-05 | FBTP | Futures | 133.7 | 133.83 | 133.18 | 133.3 | 60180.0 |
| 2020-08-05 | FBTS | Futures | 108.919 | 108.919 | 108.822 | 108.841 | 45298.0 |
| 2020-08-05 | FCE | Futures | 4732.0 | 4788.0 | 4730.0 | 4765.3 | 54595.0 |
| 2020-08-05 | FDAX | Futures | 13388.7 | 13552.3 | 13355.2 | 13439.2 | 66946.0 |
| 2020-08-05 | FDXM | Futures | 13344.1 | 13501.8 | 13306.0 | 13390.7 | 37807.0 |
| 2020-08-05 | FESX | Futures | 3001.9 | 3036.1 | 2991.8 | 3011.2 | 618473.0 |
| 2020-08-05 | FGBL | Futures | 170.03 | 170.07 | 169.12 | 169.21 | 492488.0 |
| 2020-08-05 | FGBM | Futures | 135.26 | 135.26 | 134.93 | 134.96 | 386152.0 |
| 2020-08-05 | FGBS | Futures | 112.81 | 112.825 | 112.769 | 112.78 | 326209.0 |
| 2020-08-05 | FGBX | Futures | 233.3 | 233.82 | 230.31 | 230.77 | 40967.0 |
| 2020-08-05 | FMWO | Futures | 8244.7 | 8272.0 | 8235.2 | 8267.2 | 1348.0 |
| 2020-08-05 | FOAT | Futures | 157.2 | 157.2 | 156.47 | 156.56 | 136342.0 |
| 2020-08-05 | FTDX | Futures | 3086.4 | 3101.2 | 3072.6 | 3080.2 | 73.0 |
| 2020-08-05 | FTI | Futures | 520.91 | 527.59 | 520.82 | 524.22 | 24635.0 |
| 2020-08-05 | FTUK | Futures | 5675.1 | 5741.7 | 5658.1 | 5730.8 | 77214.0 |
| 2020-08-05 | FVSA | Futures | 222.61 | 222.61 | 213.56 | 217.63 | 11357.0 |
| 2020-08-05 | FXXP | Futures | 335.1 | 338.0 | 334.6 | 335.8 | 58232.0 |
| 2020-08-05 | G | Futures | 128.25 | 128.3 | 127.61 | 127.7 | 210289.0 |
| 2020-08-05 | GF | Futures | 280.11 | 281.418 | 279.335 | 280.691 | 819.0 |
> showing 50 of 119 rows — these rows as CSV