PREVIEW / futures_daily / 2019-08-30
file: by_date/futures_daily/2019/2019-08-30.parquet size: 10 KB rows: 120
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-08-30 | ES | Futures | 3154.35 | 3179.44 | 3143.56 | 3155.97 | 1642516.0 |
| 2019-08-30 | NQ | Futures | 8870.09 | 8946.37 | 8803.03 | 8854.55 | 450746.0 |
| 2019-08-30 | YM | Futures | 27685.0 | 27887.6 | 27614.6 | 27727.0 | 192172.0 |
| 2019-08-30 | CL | Futures | 58.16 | 58.25 | 56.03 | 56.59 | 708268.0 |
| 2019-08-30 | GC | Futures | 1895.8 | 1902.0 | 1881.9 | 1886.6 | 330849.0 |
| 2019-08-30 | ZN | Futures | 130.488715 | 130.535374 | 130.146552 | 130.442056 | 134475.0 |
| 2019-08-30 | A6 | Futures | 0.69277 | 0.6938 | 0.6903 | 0.69246 | 73150.0 |
| 2019-08-30 | AD | Futures | 0.75869 | 0.76111 | 0.75607 | 0.75682 | 91773.0 |
| 2019-08-30 | ALI | Futures | 2131.68 | 2140.18 | 2131.37 | 2140.18 | 25.0 |
| 2019-08-30 | B | Futures | 46.6 | 46.82 | 45.17 | 45.76 | 344394.0 |
| 2019-08-30 | B6 | Futures | 1.2442 | 1.249 | 1.24 | 1.2413 | 104922.0 |
| 2019-08-30 | BR | Futures | 0.19315 | 0.19457 | 0.19315 | 0.19457 | 39.0 |
| 2019-08-30 | BTC | Futures | 13701.5 | 13973.0 | 13458.7 | 13787.3 | 2856.0 |
| 2019-08-30 | BZ | Futures | 45.98 | 46.12 | 44.5 | 45.09 | 41940.0 |
| 2019-08-30 | C | Futures | 1526.0 | 1550.0 | 1521.0 | 1544.0 | 4344.0 |
| 2019-08-30 | CB | Futures | 263.925 | 263.925 | 262.833 | 263.335 | 6.0 |
| 2019-08-30 | CC | Futures | 1431.0 | 1461.0 | 1431.0 | 1458.0 | 17789.0 |
| 2019-08-30 | CNH | Futures | 7.1495 | 7.1708 | 7.1458 | 7.1676 | 472.0 |
| 2019-08-30 | CSC | Futures | 3.023 | 3.023 | 3.001 | 3.008 | 36.0 |
| 2019-08-30 | CT | Futures | 58.01 | 58.34 | 58.0 | 58.31 | 15.0 |
| 2019-08-30 | DC | Futures | 25.61 | 25.61 | 25.46 | 25.46 | 87.0 |
| 2019-08-30 | DX | Futures | 94.697 | 95.289 | 94.687 | 95.183 | 19951.0 |
| 2019-08-30 | E1 | Futures | 1.1771 | 1.17768 | 1.17084 | 1.172 | 26505.0 |
| 2019-08-30 | E6 | Futures | 1.20749 | 1.20787 | 1.19729 | 1.19882 | 214473.0 |
| 2019-08-30 | E7 | Futures | 1.2012 | 1.2015 | 1.191 | 1.1926 | 3804.0 |
| 2019-08-30 | EBM | Futures | 190.0 | 190.29 | 188.56 | 189.14 | 7937.0 |
| 2019-08-30 | ED | Futures | 95.3744 | 95.3793 | 95.3574 | 95.3647 | 241960.0 |
| 2019-08-30 | ER | Futures | 98.548 | 98.568 | 98.548 | 98.558 | 111379.0 |
| 2019-08-30 | EW | Futures | 1970.5 | 1985.6 | 1965.0 | 1976.1 | 13753.0 |
| 2019-08-30 | FBON | Futures | 146.46 | 146.55 | 146.32 | 146.46 | 274.0 |
| 2019-08-30 | FBTP | Futures | 130.81 | 131.46 | 130.16 | 130.52 | 152313.0 |
| 2019-08-30 | FBTS | Futures | 108.261 | 108.481 | 108.203 | 108.251 | 139292.0 |
| 2019-08-30 | FCE | Futures | 4948.4 | 4985.6 | 4931.7 | 4963.8 | 75429.0 |
| 2019-08-30 | FDAX | Futures | 12492.1 | 12620.0 | 12464.7 | 12543.7 | 104153.0 |
| 2019-08-30 | FDIV | Futures | 143.08 | 144.0 | 143.08 | 143.45 | 58.0 |
| 2019-08-30 | FDXM | Futures | 12329.4 | 12463.5 | 12311.7 | 12389.2 | 41461.0 |
| 2019-08-30 | FESX | Futures | 2982.8 | 3006.4 | 2976.7 | 2985.5 | 1072453.0 |
| 2019-08-30 | FEU3 | Futures | 99.183 | 99.188 | 99.183 | 99.188 | 50.0 |
| 2019-08-30 | FGBL | Futures | 170.12 | 170.46 | 169.85 | 170.3 | 721955.0 |
| 2019-08-30 | FGBM | Futures | 136.12 | 136.26 | 136.05 | 136.23 | 747830.0 |
| 2019-08-30 | FGBS | Futures | 113.358 | 113.408 | 113.338 | 113.398 | 769344.0 |
| 2019-08-30 | FGBX | Futures | 231.29 | 231.81 | 229.42 | 231.15 | 70296.0 |
| 2019-08-30 | FMWO | Futures | 7183.7 | 7235.6 | 7168.7 | 7171.0 | 991.0 |
| 2019-08-30 | FOAT | Futures | 156.48 | 156.58 | 156.08 | 156.4 | 170350.0 |
| 2019-08-30 | FTDX | Futures | 2725.4 | 2754.0 | 2725.4 | 2746.1 | 137.0 |
| 2019-08-30 | FTI | Futures | 526.28 | 529.83 | 524.67 | 528.34 | 22400.0 |
| 2019-08-30 | FTUK | Futures | 6636.6 | 6679.5 | 6623.7 | 6629.7 | 101239.0 |
| 2019-08-30 | FVSA | Futures | 215.09 | 220.11 | 209.45 | 217.6 | 24372.0 |
| 2019-08-30 | FXXP | Futures | 338.1 | 341.4 | 337.6 | 339.5 | 59818.0 |
| 2019-08-30 | G | Futures | 123.5 | 123.53 | 122.99 | 123.05 | 224545.0 |
> showing 50 of 120 rows — these rows as CSV