PREVIEW / futures_daily / 2019-07-04
file: by_date/futures_daily/2019/2019-07-04.parquet size: 6 KB rows: 36
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 |
|---|---|---|---|---|---|---|---|
| 2019-07-04 | B | Futures | 48.02 | 48.17 | 47.32 | 47.59 | 114984.0 |
| 2019-07-04 | C | Futures | 1724.0 | 1748.0 | 1724.0 | 1744.0 | 8893.0 |
| 2019-07-04 | DX | Futures | 92.709 | 92.805 | 92.656 | 92.748 | 3030.0 |
| 2019-07-04 | EBM | Futures | 205.84 | 206.99 | 205.55 | 206.7 | 7918.0 |
| 2019-07-04 | ER | Futures | 98.533 | 98.533 | 98.524 | 98.529 | 60404.0 |
| 2019-07-04 | FBON | Futures | 144.82 | 144.93 | 144.43 | 144.59 | 278.0 |
| 2019-07-04 | FBTP | Futures | 125.2 | 125.57 | 124.32 | 124.56 | 107304.0 |
| 2019-07-04 | FBTS | Futures | 107.532 | 107.609 | 107.254 | 107.379 | 94704.0 |
| 2019-07-04 | FCE | Futures | 5136.3 | 5143.2 | 5127.2 | 5134.5 | 25466.0 |
| 2019-07-04 | FDAX | Futures | 13306.6 | 13312.9 | 13271.3 | 13286.1 | 45902.0 |
| 2019-07-04 | FDIV | Futures | 150.13 | 150.13 | 149.94 | 149.94 | 6.0 |
| 2019-07-04 | FDXM | Futures | 13141.6 | 13148.9 | 13108.4 | 13122.4 | 15639.0 |
| 2019-07-04 | FESX | Futures | 3090.2 | 3092.9 | 3081.5 | 3085.9 | 448245.0 |
| 2019-07-04 | FGBL | Futures | 165.18 | 165.5 | 165.08 | 165.31 | 483554.0 |
| 2019-07-04 | FGBM | Futures | 134.63 | 134.71 | 134.58 | 134.66 | 308312.0 |
| 2019-07-04 | FGBS | Futures | 113.116 | 113.121 | 113.091 | 113.111 | 174319.0 |
| 2019-07-04 | FGBX | Futures | 211.46 | 212.7 | 211.22 | 211.98 | 50724.0 |
| 2019-07-04 | FMWO | Futures | 7467.5 | 7472.1 | 7452.5 | 7469.8 | 373.0 |
| 2019-07-04 | FOAT | Futures | 152.64 | 153.0 | 152.52 | 152.83 | 193823.0 |
| 2019-07-04 | FTDX | Futures | 2908.0 | 2910.0 | 2883.8 | 2907.0 | 80.0 |
| 2019-07-04 | FTI | Futures | 539.61 | 540.6 | 539.09 | 539.74 | 9744.0 |
| 2019-07-04 | FTUK | Futures | 6975.4 | 6981.4 | 6957.0 | 6962.1 | 41603.0 |
| 2019-07-04 | FVSA | Futures | 173.05 | 179.97 | 173.05 | 177.9 | 13510.0 |
| 2019-07-04 | FXXP | Futures | 350.7 | 351.3 | 350.2 | 350.7 | 34032.0 |
| 2019-07-04 | G | Futures | 121.41 | 121.8 | 121.25 | 121.55 | 119714.0 |
| 2019-07-04 | JB | Futures | 141.35 | 141.42 | 141.35 | 141.41 | 444.0 |
| 2019-07-04 | L | Futures | 99.56 | 99.565 | 99.555 | 99.565 | 52728.0 |
| 2019-07-04 | MFC | Futures | 5103.3 | 5104.3 | 5089.3 | 5097.0 | 16.0 |
| 2019-07-04 | MFS | Futures | 2003.8 | 2006.0 | 1998.2 | 2003.8 | 16879.0 |
| 2019-07-04 | MME | Futures | 1088.9 | 1093.5 | 1086.9 | 1087.4 | 13970.0 |
| 2019-07-04 | PSI | Futures | 5538.7 | 5538.7 | 5535.5 | 5535.5 | 50.0 |
| 2019-07-04 | RM | Futures | 1208.7 | 1223.6 | 1207.1 | 1219.5 | 5110.0 |
| 2019-07-04 | RS | Futures | 424.2 | 424.6 | 422.2 | 422.6 | 3193.0 |
| 2019-07-04 | SO3 | Futures | 96.455 | 96.465 | 96.455 | 96.465 | 1128.0 |
| 2019-07-04 | ZRPA | Futures | 110.61 | 110.74 | 110.61 | 110.65 | 340.0 |
| 2019-07-04 | ZTWA | Futures | 626.0 | 627.6 | 625.8 | 627.1 | 1999.0 |
> showing 36 of 36 rows — these rows as CSV