PREVIEW / futures_daily / 2019-06-21
file: by_date/futures_daily/2019/2019-06-21.parquet size: 10 KB rows: 121
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-06-21 | ES | Futures | 3191.58 | 3203.99 | 3180.79 | 3183.76 | 1547604.0 |
| 2019-06-21 | NQ | Futures | 8937.45 | 8984.36 | 8895.13 | 8924.49 | 379078.0 |
| 2019-06-21 | YM | Futures | 28095.5 | 28268.8 | 28005.2 | 28032.5 | 203126.0 |
| 2019-06-21 | CL | Futures | 58.57 | 59.31 | 57.96 | 58.75 | 676047.0 |
| 2019-06-21 | GC | Futures | 1731.5 | 1761.6 | 1725.2 | 1742.6 | 518888.0 |
| 2019-06-21 | ZN | Futures | 127.207056 | 127.424797 | 126.84934 | 126.927104 | 1597384.0 |
| 2019-06-21 | A6 | Futures | 0.71427 | 0.71561 | 0.71201 | 0.71437 | 91355.0 |
| 2019-06-21 | AD | Futures | 0.76549 | 0.767 | 0.76317 | 0.76433 | 87271.0 |
| 2019-06-21 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-21 | B | Futures | 48.28 | 48.95 | 47.64 | 48.53 | 257918.0 |
| 2019-06-21 | B6 | Futures | 1.3016 | 1.306 | 1.2952 | 1.305 | 84232.0 |
| 2019-06-21 | BFX | Futures | 4116.5 | 4116.5 | 4110.0 | 4110.0 | 52.0 |
| 2019-06-21 | BR | Futures | 0.20795 | 0.20799 | 0.20747 | 0.20747 | 20.0 |
| 2019-06-21 | BTC | Futures | 14774.9 | 15458.7 | 14690.4 | 15335.8 | 6905.0 |
| 2019-06-21 | BZ | Futures | 47.57 | 48.32 | 47.02 | 47.91 | 51282.0 |
| 2019-06-21 | C | Futures | 1738.0 | 1780.0 | 1738.0 | 1771.0 | 3313.0 |
| 2019-06-21 | CB | Futures | 285.035 | 285.035 | 285.035 | 285.035 | 3.0 |
| 2019-06-21 | CC | Futures | 1630.0 | 1677.0 | 1629.0 | 1667.0 | 16912.0 |
| 2019-06-21 | CNH | Futures | 6.8648 | 6.8861 | 6.8465 | 6.8712 | 752.0 |
| 2019-06-21 | CSC | Futures | 3.075 | 3.083 | 3.067 | 3.07 | 40.0 |
| 2019-06-21 | CT | Futures | 66.31 | 66.99 | 63.09 | 64.05 | 2659.0 |
| 2019-06-21 | DC | Futures | 25.8 | 25.96 | 25.74 | 25.76 | 178.0 |
| 2019-06-21 | DX | Futures | 92.564 | 92.656 | 92.088 | 92.158 | 30648.0 |
| 2019-06-21 | E1 | Futures | 1.19125 | 1.19774 | 1.18777 | 1.19612 | 34718.0 |
| 2019-06-21 | E6 | Futures | 1.24049 | 1.24954 | 1.23913 | 1.24845 | 219540.0 |
| 2019-06-21 | E7 | Futures | 1.2335 | 1.243 | 1.2326 | 1.242 | 7126.0 |
| 2019-06-21 | EBM | Futures | 208.43 | 208.72 | 206.13 | 208.14 | 10463.0 |
| 2019-06-21 | ED | Futures | 95.445 | 95.4499 | 95.4158 | 95.4401 | 362499.0 |
| 2019-06-21 | ER | Futures | 98.504 | 98.504 | 98.489 | 98.494 | 96773.0 |
| 2019-06-21 | EW | Futures | 2040.8 | 2041.6 | 2022.9 | 2028.9 | 13312.0 |
| 2019-06-21 | FBON | Futures | 143.04 | 143.04 | 142.18 | 142.22 | 363.0 |
| 2019-06-21 | FBTP | Futures | 120.03 | 120.68 | 119.83 | 119.85 | 117866.0 |
| 2019-06-21 | FBTS | Futures | 106.727 | 106.871 | 106.622 | 106.632 | 66674.0 |
| 2019-06-21 | FCE | Futures | 5042.2 | 5094.3 | 5021.7 | 5045.0 | 86714.0 |
| 2019-06-21 | FDAX | Futures | 13001.2 | 13068.1 | 12902.8 | 12956.5 | 124403.0 |
| 2019-06-21 | FDIV | Futures | 146.88 | 146.88 | 146.74 | 146.74 | 40.0 |
| 2019-06-21 | FDXM | Futures | 12854.6 | 12906.6 | 12744.3 | 12796.9 | 48132.0 |
| 2019-06-21 | FESX | Futures | 3020.4 | 3044.8 | 3000.3 | 3010.8 | 1333252.0 |
| 2019-06-21 | FEU3 | Futures | 99.119 | 99.119 | 99.114 | 99.119 | 115.0 |
| 2019-06-21 | FGBL | Futures | 164.07 | 164.17 | 163.5 | 163.61 | 712519.0 |
| 2019-06-21 | FGBM | Futures | 134.43 | 134.45 | 134.2 | 134.24 | 442713.0 |
| 2019-06-21 | FGBS | Futures | 113.081 | 113.081 | 113.026 | 113.046 | 257878.0 |
| 2019-06-21 | FGBX | Futures | 209.51 | 209.73 | 207.22 | 207.82 | 48797.0 |
| 2019-06-21 | FMWO | Futures | 7344.1 | 7364.8 | 7336.0 | 7353.3 | 1849.0 |
| 2019-06-21 | FOAT | Futures | 151.03 | 151.06 | 150.46 | 150.57 | 116662.0 |
| 2019-06-21 | FTDX | Futures | 2826.1 | 2826.1 | 2795.5 | 2805.4 | 262.0 |
| 2019-06-21 | FTI | Futures | 529.12 | 531.42 | 525.73 | 528.54 | 29375.0 |
| 2019-06-21 | FTUK | Futures | 6800.9 | 6821.7 | 6746.9 | 6756.6 | 119026.0 |
| 2019-06-21 | FVSA | Futures | 197.97 | 205.58 | 196.58 | 203.51 | 39727.0 |
| 2019-06-21 | FXXP | Futures | 343.1 | 345.2 | 341.2 | 342.4 | 87862.0 |
> showing 50 of 121 rows — these rows as CSV