PREVIEW / futures_daily / 2018-10-15
file: by_date/futures_daily/2018/2018-10-15.parquet size: 10 KB rows: 116
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-10-15 | ES | Futures | 3004.1 | 3013.59 | 2977.25 | 2981.32 | 1763922.0 |
| 2018-10-15 | NQ | Futures | 8335.98 | 8338.59 | 8201.24 | 8219.54 | 641765.0 |
| 2018-10-15 | YM | Futures | 26688.3 | 26822.1 | 26443.0 | 26537.7 | 294513.0 |
| 2018-10-15 | CL | Futures | 74.68 | 75.59 | 73.68 | 74.63 | 211953.0 |
| 2018-10-15 | GC | Futures | 1547.8 | 1567.7 | 1546.8 | 1559.3 | 291572.0 |
| 2018-10-15 | ZN | Futures | 117.705316 | 117.860949 | 117.674189 | 117.689752 | 1416067.0 |
| 2018-10-15 | A6 | Futures | 0.73189 | 0.73591 | 0.73086 | 0.73498 | 66733.0 |
| 2018-10-15 | AD | Futures | 0.77744 | 0.78139 | 0.77567 | 0.77957 | 71768.0 |
| 2018-10-15 | B | Futures | 59.51 | 60.19 | 58.67 | 59.35 | 284648.0 |
| 2018-10-15 | B6 | Futures | 1.3513 | 1.3595 | 1.3505 | 1.3567 | 88828.0 |
| 2018-10-15 | BFX | Futures | 4067.5 | 4105.4 | 4067.5 | 4105.4 | 10.0 |
| 2018-10-15 | BR | Futures | 0.20087 | 0.20357 | 0.20087 | 0.2035 | 62.0 |
| 2018-10-15 | BTC | Futures | 8896.3 | 9769.3 | 8816.9 | 9220.9 | 6704.0 |
| 2018-10-15 | BZ | Futures | 59.05 | 59.73 | 58.23 | 58.91 | 31577.0 |
| 2018-10-15 | C | Futures | 1479.0 | 1491.0 | 1426.0 | 1453.0 | 8476.0 |
| 2018-10-15 | CB | Futures | 270.876 | 272.769 | 270.876 | 271.687 | 17.0 |
| 2018-10-15 | CC | Futures | 1516.0 | 1521.0 | 1455.0 | 1495.0 | 20064.0 |
| 2018-10-15 | CNH | Futures | 6.9845 | 6.9845 | 6.966 | 6.9711 | 210.0 |
| 2018-10-15 | CSC | Futures | 3.174 | 3.174 | 3.146 | 3.15 | 59.0 |
| 2018-10-15 | CT | Futures | 88.34 | 88.85 | 87.38 | 88.36 | 15163.0 |
| 2018-10-15 | DC | Futures | 26.41 | 26.41 | 26.21 | 26.24 | 255.0 |
| 2018-10-15 | DX | Futures | 90.253 | 90.305 | 89.902 | 90.015 | 13754.0 |
| 2018-10-15 | E1 | Futures | 1.20255 | 1.21038 | 1.20137 | 1.20706 | 22328.0 |
| 2018-10-15 | E6 | Futures | 1.29084 | 1.29679 | 1.28979 | 1.29423 | 157712.0 |
| 2018-10-15 | E7 | Futures | 1.2845 | 1.2905 | 1.2835 | 1.2879 | 2286.0 |
| 2018-10-15 | EBM | Futures | 212.61 | 213.13 | 211.57 | 212.61 | 20152.0 |
| 2018-10-15 | ED | Futures | 95.0525 | 95.0573 | 95.028 | 95.0329 | 277586.0 |
| 2018-10-15 | ER | Futures | 98.381 | 98.386 | 98.377 | 98.381 | 86953.0 |
| 2018-10-15 | EW | Futures | 1971.6 | 1991.7 | 1953.1 | 1978.1 | 17633.0 |
| 2018-10-15 | FBON | Futures | 126.15 | 126.41 | 125.94 | 126.17 | 574.0 |
| 2018-10-15 | FBTP | Futures | 103.14 | 103.73 | 103.03 | 103.31 | 48371.0 |
| 2018-10-15 | FBTS | Futures | 101.066 | 101.235 | 100.963 | 101.075 | 48264.0 |
| 2018-10-15 | FCE | Futures | 4541.6 | 4568.9 | 4525.1 | 4558.2 | 63161.0 |
| 2018-10-15 | FDAX | Futures | 12040.6 | 12238.8 | 12017.4 | 12207.8 | 104354.0 |
| 2018-10-15 | FDXM | Futures | 11835.7 | 12025.8 | 11810.9 | 11996.3 | 45525.0 |
| 2018-10-15 | FESX | Futures | 2668.9 | 2694.9 | 2660.5 | 2689.9 | 998018.0 |
| 2018-10-15 | FEU3 | Futures | 98.996 | 99.006 | 98.996 | 99.006 | 1.0 |
| 2018-10-15 | FGBL | Futures | 151.84 | 152.04 | 151.65 | 151.77 | 428866.0 |
| 2018-10-15 | FGBM | Futures | 130.53 | 130.59 | 130.47 | 130.52 | 305474.0 |
| 2018-10-15 | FGBS | Futures | 112.598 | 112.613 | 112.578 | 112.603 | 329144.0 |
| 2018-10-15 | FGBX | Futures | 174.95 | 175.21 | 174.18 | 174.44 | 30103.0 |
| 2018-10-15 | FMWO | Futures | 6838.5 | 6881.3 | 6813.0 | 6877.9 | 2022.0 |
| 2018-10-15 | FOAT | Futures | 139.19 | 139.27 | 139.01 | 139.1 | 80087.0 |
| 2018-10-15 | FTDX | Futures | 2529.3 | 2541.5 | 2503.7 | 2538.1 | 152.0 |
| 2018-10-15 | FTI | Futures | 478.66 | 483.05 | 476.47 | 481.77 | 8132.0 |
| 2018-10-15 | FTUK | Futures | 6248.3 | 6271.1 | 6196.0 | 6259.0 | 106754.0 |
| 2018-10-15 | FVSA | Futures | 359.6 | 360.55 | 343.43 | 347.24 | 50076.0 |
| 2018-10-15 | FXXP | Futures | 309.5 | 310.9 | 307.6 | 310.6 | 60700.0 |
| 2018-10-15 | G | Futures | 113.44 | 113.63 | 113.4 | 113.56 | 194333.0 |
| 2018-10-15 | GF | Futures | 321.301 | 323.692 | 319.69 | 322.757 | 6320.0 |
> showing 50 of 116 rows — these rows as CSV