PREVIEW / futures_daily / 2019-05-21
file: by_date/futures_daily/2019/2019-05-21.parquet size: 10 KB rows: 119
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-05-21 | ES | Futures | 3076.34 | 3100.91 | 3074.45 | 3095.78 | 1303238.0 |
| 2019-05-21 | NQ | Futures | 8535.82 | 8624.54 | 8527.18 | 8600.06 | 436744.0 |
| 2019-05-21 | YM | Futures | 27147.9 | 27333.6 | 27139.4 | 27312.5 | 208634.0 |
| 2019-05-21 | CL | Futures | 64.97 | 65.46 | 64.43 | 64.79 | 641680.0 |
| 2019-05-21 | GC | Futures | 1590.3 | 1590.3 | 1579.4 | 1584.7 | 213168.0 |
| 2019-05-21 | ZN | Futures | 123.601025 | 123.678723 | 123.352394 | 123.46117 | 1308309.0 |
| 2019-05-21 | A6 | Futures | 0.71261 | 0.71477 | 0.70828 | 0.70993 | 117225.0 |
| 2019-05-21 | AD | Futures | 0.75327 | 0.75524 | 0.75302 | 0.75479 | 64709.0 |
| 2019-05-21 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-05-21 | B | Futures | 53.17 | 53.44 | 52.78 | 53.19 | 303740.0 |
| 2019-05-21 | B6 | Futures | 1.3052 | 1.3144 | 1.3011 | 1.3031 | 186348.0 |
| 2019-05-21 | BR | Futures | 0.19508 | 0.19828 | 0.19444 | 0.1974 | 3322.0 |
| 2019-05-21 | BTC | Futures | 12472.4 | 12588.4 | 12124.5 | 12449.2 | 7778.0 |
| 2019-05-21 | BZ | Futures | 53.01 | 53.29 | 52.62 | 53.04 | 55652.0 |
| 2019-05-21 | C | Futures | 1691.0 | 1722.0 | 1681.0 | 1719.0 | 8815.0 |
| 2019-05-21 | CB | Futures | 282.7 | 283.478 | 282.7 | 282.73 | 11.0 |
| 2019-05-21 | CC | Futures | 1610.0 | 1651.0 | 1598.0 | 1647.0 | 26891.0 |
| 2019-05-21 | CNH | Futures | 6.9501 | 6.958 | 6.9329 | 6.946 | 1325.0 |
| 2019-05-21 | CSC | Futures | 2.999 | 3.008 | 2.978 | 2.98 | 108.0 |
| 2019-05-21 | CT | Futures | 71.18 | 71.43 | 70.14 | 70.47 | 14216.0 |
| 2019-05-21 | DC | Futures | 25.24 | 25.41 | 25.12 | 25.18 | 462.0 |
| 2019-05-21 | DX | Futures | 93.733 | 93.911 | 93.585 | 93.835 | 14846.0 |
| 2019-05-21 | E1 | Futures | 1.16014 | 1.16037 | 1.15594 | 1.15676 | 20350.0 |
| 2019-05-21 | E6 | Futures | 1.22833 | 1.23075 | 1.22553 | 1.22734 | 171890.0 |
| 2019-05-21 | E7 | Futures | 1.2223 | 1.2245 | 1.2195 | 1.2212 | 4446.0 |
| 2019-05-21 | EBM | Futures | 203.53 | 205.26 | 201.81 | 202.96 | 21465.0 |
| 2019-05-21 | ED | Futures | 95.1892 | 95.1917 | 95.177 | 95.1795 | 192946.0 |
| 2019-05-21 | ER | Futures | 98.426 | 98.43 | 98.421 | 98.426 | 42106.0 |
| 2019-05-21 | EW | Futures | 1995.8 | 2020.5 | 1993.9 | 2017.2 | 15202.0 |
| 2019-05-21 | FBON | Futures | 137.63 | 137.91 | 137.58 | 137.78 | 744.0 |
| 2019-05-21 | FBTP | Futures | 114.79 | 115.39 | 114.63 | 115.3 | 77033.0 |
| 2019-05-21 | FBTS | Futures | 105.541 | 105.76 | 105.532 | 105.722 | 52646.0 |
| 2019-05-21 | FCE | Futures | 4830.7 | 4852.0 | 4809.8 | 4843.0 | 63753.0 |
| 2019-05-21 | FDAX | Futures | 12690.6 | 12818.0 | 12680.6 | 12784.3 | 103685.0 |
| 2019-05-21 | FDXM | Futures | 12574.4 | 12705.8 | 12570.2 | 12673.5 | 42355.0 |
| 2019-05-21 | FESX | Futures | 2927.8 | 2951.4 | 2926.9 | 2941.8 | 748160.0 |
| 2019-05-21 | FEU3 | Futures | 99.026 | 99.026 | 99.021 | 99.021 | 80.0 |
| 2019-05-21 | FGBL | Futures | 160.93 | 161.08 | 160.53 | 160.69 | 772870.0 |
| 2019-05-21 | FGBM | Futures | 133.51 | 133.54 | 133.37 | 133.41 | 410942.0 |
| 2019-05-21 | FGBS | Futures | 112.87 | 112.875 | 112.829 | 112.839 | 270814.0 |
| 2019-05-21 | FGBX | Futures | 196.47 | 196.94 | 195.27 | 195.65 | 51176.0 |
| 2019-05-21 | FMWO | Futures | 7101.6 | 7128.2 | 7085.4 | 7117.8 | 1229.0 |
| 2019-05-21 | FOAT | Futures | 147.38 | 147.5 | 147.14 | 147.28 | 113737.0 |
| 2019-05-21 | FTDX | Futures | 2813.3 | 2841.9 | 2810.3 | 2833.0 | 224.0 |
| 2019-05-21 | FTI | Futures | 520.46 | 523.43 | 519.75 | 521.25 | 26056.0 |
| 2019-05-21 | FTUK | Futures | 6693.1 | 6746.3 | 6689.4 | 6706.4 | 76373.0 |
| 2019-05-21 | FVSA | Futures | 223.83 | 227.39 | 218.84 | 220.26 | 55834.0 |
| 2019-05-21 | FXXP | Futures | 337.7 | 339.0 | 336.8 | 338.4 | 56280.0 |
| 2019-05-21 | G | Futures | 118.55 | 118.84 | 118.22 | 118.39 | 197705.0 |
| 2019-05-21 | GF | Futures | 284.548 | 284.793 | 278.759 | 280.623 | 6072.0 |
> showing 50 of 119 rows — these rows as CSV