PREVIEW / futures_daily / 2018-07-04
file: by_date/futures_daily/2018/2018-07-04.parquet size: 6 KB rows: 34
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-07-04 | B | Futures | 57.45 | 57.74 | 57.25 | 57.71 | 97245.0 |
| 2018-07-04 | C | Futures | 1683.0 | 1692.0 | 1682.0 | 1692.0 | 2134.0 |
| 2018-07-04 | DX | Futures | 89.331 | 89.459 | 89.155 | 89.418 | 10798.0 |
| 2018-07-04 | EBM | Futures | 190.93 | 192.5 | 190.93 | 191.97 | 7350.0 |
| 2018-07-04 | ER | Futures | 98.357 | 98.362 | 98.357 | 98.362 | 17017.0 |
| 2018-07-04 | FBON | Futures | 129.28 | 129.41 | 129.21 | 129.31 | 198.0 |
| 2018-07-04 | FBTP | Futures | 108.16 | 108.43 | 107.71 | 108.28 | 29321.0 |
| 2018-07-04 | FBTS | Futures | 102.624 | 102.781 | 102.587 | 102.744 | 25942.0 |
| 2018-07-04 | FCE | Futures | 4764.7 | 4791.6 | 4759.7 | 4780.0 | 33982.0 |
| 2018-07-04 | FDAX | Futures | 12861.8 | 12896.3 | 12824.2 | 12862.8 | 44267.0 |
| 2018-07-04 | FDXM | Futures | 12692.3 | 12731.5 | 12660.3 | 12698.5 | 15195.0 |
| 2018-07-04 | FESX | Futures | 2832.2 | 2847.2 | 2828.0 | 2841.4 | 376985.0 |
| 2018-07-04 | FGBL | Futures | 153.21 | 153.47 | 153.0 | 153.17 | 316726.0 |
| 2018-07-04 | FGBM | Futures | 131.21 | 131.32 | 131.01 | 131.2 | 224486.0 |
| 2018-07-04 | FGBS | Futures | 112.779 | 112.789 | 112.688 | 112.744 | 157908.0 |
| 2018-07-04 | FGBX | Futures | 178.52 | 179.22 | 178.0 | 178.14 | 35235.0 |
| 2018-07-04 | FMWO | Futures | 6949.5 | 6955.3 | 6941.3 | 6948.3 | 374.0 |
| 2018-07-04 | FOAT | Futures | 141.31 | 141.46 | 141.11 | 141.25 | 63940.0 |
| 2018-07-04 | FTDX | Futures | 2646.0 | 2649.0 | 2611.2 | 2637.2 | 251.0 |
| 2018-07-04 | FTI | Futures | 506.24 | 507.9 | 505.51 | 506.75 | 10924.0 |
| 2018-07-04 | FTUK | Futures | 6692.2 | 6706.0 | 6679.8 | 6688.7 | 37665.0 |
| 2018-07-04 | FVSA | Futures | 323.63 | 323.63 | 311.97 | 315.86 | 11189.0 |
| 2018-07-04 | FXXP | Futures | 326.2 | 327.8 | 326.2 | 327.3 | 23829.0 |
| 2018-07-04 | G | Futures | 115.78 | 115.82 | 115.4 | 115.49 | 87938.0 |
| 2018-07-04 | JB | Futures | 138.74 | 138.79 | 138.74 | 138.76 | 1043.0 |
| 2018-07-04 | L | Futures | 99.435 | 99.435 | 99.405 | 99.41 | 77588.0 |
| 2018-07-04 | MFC | Futures | 4730.9 | 4753.7 | 4730.9 | 4745.2 | 14.0 |
| 2018-07-04 | MFS | Futures | 1998.3 | 2008.6 | 1995.8 | 2008.6 | 16178.0 |
| 2018-07-04 | MME | Futures | 1064.5 | 1074.2 | 1062.2 | 1065.2 | 9914.0 |
| 2018-07-04 | PSI | Futures | 5688.4 | 5703.9 | 5688.4 | 5703.9 | 1.0 |
| 2018-07-04 | RM | Futures | 1547.9 | 1552.5 | 1542.4 | 1547.0 | 2616.0 |
| 2018-07-04 | RS | Futures | 526.1 | 526.1 | 523.5 | 523.6 | 6513.0 |
| 2018-07-04 | SO3 | Futures | 96.343 | 96.343 | 96.343 | 96.343 | 150.0 |
| 2018-07-04 | ZTWA | Futures | 638.7 | 638.7 | 636.6 | 636.6 | 6.0 |
> showing 34 of 34 rows — these rows as CSV