PREVIEW / futures_daily / 2019-03-14
file: by_date/futures_daily/2019/2019-03-14.parquet size: 10 KB rows: 115
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-03-14 | ES | Futures | 3047.17 | 3051.49 | 3033.67 | 3037.72 | 1247105.0 |
| 2019-03-14 | NQ | Futures | 8414.26 | 8432.41 | 8371.63 | 8373.36 | 361924.0 |
| 2019-03-14 | YM | Futures | 27219.6 | 27264.0 | 27078.2 | 27173.2 | 159714.0 |
| 2019-03-14 | CL | Futures | 60.22 | 60.64 | 59.88 | 60.49 | 248502.0 |
| 2019-03-14 | GC | Futures | 1636.9 | 1637.9 | 1615.6 | 1618.9 | 248206.0 |
| 2019-03-14 | ZN | Futures | 122.031538 | 122.171393 | 121.907222 | 122.031538 | 1295563.0 |
| 2019-03-14 | A6 | Futures | 0.73219 | 0.73271 | 0.72694 | 0.7292 | 59439.0 |
| 2019-03-14 | AD | Futures | 0.76171 | 0.76257 | 0.75908 | 0.7605 | 54683.0 |
| 2019-03-14 | B | Futures | 49.07 | 49.42 | 48.62 | 48.76 | 235989.0 |
| 2019-03-14 | B6 | Futures | 1.3702 | 1.3717 | 1.359 | 1.3619 | 76124.0 |
| 2019-03-14 | BR | Futures | 0.20797 | 0.20797 | 0.20717 | 0.20717 | 73.0 |
| 2019-03-14 | BTC | Futures | 5903.4 | 6003.3 | 5803.5 | 5911.1 | 4463.0 |
| 2019-03-14 | BZ | Futures | 48.63 | 49.02 | 48.23 | 48.38 | 32817.0 |
| 2019-03-14 | C | Futures | 1488.0 | 1521.0 | 1482.0 | 1496.0 | 11062.0 |
| 2019-03-14 | CB | Futures | 278.723 | 279.321 | 278.723 | 279.022 | 47.0 |
| 2019-03-14 | CC | Futures | 1495.0 | 1529.0 | 1490.0 | 1494.0 | 14952.0 |
| 2019-03-14 | CNH | Futures | 6.7116 | 6.7437 | 6.7116 | 6.7299 | 465.0 |
| 2019-03-14 | CSC | Futures | 2.813 | 2.831 | 2.813 | 2.828 | 22.0 |
| 2019-03-14 | CT | Futures | 80.37 | 80.56 | 78.58 | 78.88 | 19153.0 |
| 2019-03-14 | DC | Futures | 23.85 | 24.0 | 23.83 | 23.96 | 153.0 |
| 2019-03-14 | DX | Futures | 91.975 | 92.276 | 91.96 | 92.247 | 21703.0 |
| 2019-03-14 | E1 | Futures | 1.17286 | 1.17344 | 1.17111 | 1.17216 | 41169.0 |
| 2019-03-14 | E6 | Futures | 1.25303 | 1.25401 | 1.24924 | 1.24984 | 197543.0 |
| 2019-03-14 | E7 | Futures | 1.247 | 1.2478 | 1.2431 | 1.2436 | 5435.0 |
| 2019-03-14 | EBM | Futures | 197.92 | 199.51 | 197.13 | 198.72 | 23990.0 |
| 2019-03-14 | ED | Futures | 95.1062 | 95.1062 | 95.0965 | 95.1062 | 339825.0 |
| 2019-03-14 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 30736.0 |
| 2019-03-14 | EW | Futures | 2020.5 | 2023.4 | 2006.0 | 2013.1 | 12927.0 |
| 2019-03-14 | FBON | Futures | 133.76 | 134.07 | 133.72 | 133.8 | 288.0 |
| 2019-03-14 | FBTP | Futures | 113.94 | 114.69 | 113.9 | 114.59 | 75010.0 |
| 2019-03-14 | FBTS | Futures | 105.674 | 105.95 | 105.674 | 105.912 | 61880.0 |
| 2019-03-14 | FCE | Futures | 4712.4 | 4759.2 | 4704.4 | 4751.2 | 73743.0 |
| 2019-03-14 | FDAX | Futures | 12195.7 | 12229.3 | 12124.2 | 12187.8 | 106064.0 |
| 2019-03-14 | FDXM | Futures | 12134.0 | 12162.2 | 12059.9 | 12119.4 | 3199.0 |
| 2019-03-14 | FESX | Futures | 2840.4 | 2854.4 | 2827.3 | 2850.0 | 1152378.0 |
| 2019-03-14 | FGBL | Futures | 158.49 | 158.72 | 158.35 | 158.41 | 542776.0 |
| 2019-03-14 | FGBM | Futures | 132.49 | 132.56 | 132.42 | 132.45 | 325669.0 |
| 2019-03-14 | FGBS | Futures | 112.688 | 112.693 | 112.673 | 112.678 | 243431.0 |
| 2019-03-14 | FGBX | Futures | 189.25 | 189.89 | 188.95 | 189.15 | 34467.0 |
| 2019-03-14 | FMWO | Futures | 7037.7 | 7071.5 | 7037.7 | 7055.2 | 9454.0 |
| 2019-03-14 | FOAT | Futures | 145.26 | 145.5 | 145.23 | 145.27 | 127855.0 |
| 2019-03-14 | FTDX | Futures | 2617.8 | 2627.7 | 2604.0 | 2617.3 | 367.0 |
| 2019-03-14 | FTI | Futures | 503.62 | 510.14 | 503.3 | 508.38 | 18550.0 |
| 2019-03-14 | FTUK | Futures | 6467.5 | 6542.2 | 6465.2 | 6518.4 | 104101.0 |
| 2019-03-14 | FVSA | Futures | 248.46 | 249.27 | 242.75 | 244.38 | 19149.0 |
| 2019-03-14 | FXXP | Futures | 329.0 | 332.4 | 329.0 | 331.9 | 69391.0 |
| 2019-03-14 | G | Futures | 116.91 | 117.04 | 116.63 | 116.82 | 222313.0 |
| 2019-03-14 | GF | Futures | 308.649 | 310.948 | 307.419 | 309.344 | 5689.0 |
| 2019-03-14 | GSCI | Futures | 489.77 | 490.16 | 488.41 | 489.09 | 330.0 |
| 2019-03-14 | HE | Futures | 71.819 | 74.505 | 71.678 | 74.42 | 20621.0 |
> showing 50 of 115 rows — these rows as CSV