PREVIEW / futures_daily / 2019-06-26
file: by_date/futures_daily/2019/2019-06-26.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-06-26 | ES | Futures | 3153.54 | 3171.35 | 3144.91 | 3148.69 | 1232682.0 |
| 2019-06-26 | NQ | Futures | 8788.06 | 8887.08 | 8768.78 | 8807.63 | 376979.0 |
| 2019-06-26 | YM | Futures | 27896.0 | 28038.8 | 27835.1 | 27878.2 | 180306.0 |
| 2019-06-26 | CL | Futures | 60.19 | 61.3 | 60.0 | 60.74 | 686817.0 |
| 2019-06-26 | GC | Futures | 1776.3 | 1777.2 | 1748.7 | 1761.6 | 421948.0 |
| 2019-06-26 | ZN | Futures | 127.580325 | 127.595878 | 126.973763 | 127.004869 | 1372796.0 |
| 2019-06-26 | A6 | Futures | 0.71787 | 0.72137 | 0.71684 | 0.72034 | 88185.0 |
| 2019-06-26 | AD | Futures | 0.76635 | 0.77033 | 0.76509 | 0.76993 | 78436.0 |
| 2019-06-26 | ALI | Futures | 2718.01 | 2718.01 | 2718.01 | 2718.01 | 0.0 |
| 2019-06-26 | B | Futures | 48.94 | 49.63 | 48.69 | 49.38 | 334760.0 |
| 2019-06-26 | B6 | Futures | 1.3002 | 1.3019 | 1.2972 | 1.2999 | 65310.0 |
| 2019-06-26 | BR | Futures | 0.20623 | 0.20623 | 0.20623 | 0.20623 | 63.0 |
| 2019-06-26 | BTC | Futures | 16637.7 | 19836.4 | 16539.7 | 19801.4 | 3776.0 |
| 2019-06-26 | BZ | Futures | 48.33 | 49.01 | 48.08 | 48.76 | 40759.0 |
| 2019-06-26 | C | Futures | 1749.0 | 1766.0 | 1743.0 | 1748.0 | 4272.0 |
| 2019-06-26 | CB | Futures | 287.748 | 288.828 | 287.748 | 288.711 | 75.0 |
| 2019-06-26 | CC | Futures | 1652.0 | 1657.0 | 1629.0 | 1639.0 | 14770.0 |
| 2019-06-26 | CNH | Futures | 6.89 | 6.8976 | 6.8718 | 6.8882 | 722.0 |
| 2019-06-26 | CSC | Futures | 3.073 | 3.085 | 3.073 | 3.078 | 59.0 |
| 2019-06-26 | CT | Futures | 64.88 | 66.75 | 64.88 | 65.49 | 46.0 |
| 2019-06-26 | DC | Futures | 25.96 | 26.02 | 25.94 | 25.94 | 75.0 |
| 2019-06-26 | DX | Futures | 92.121 | 92.285 | 92.011 | 92.168 | 13268.0 |
| 2019-06-26 | E1 | Futures | 1.19809 | 1.19902 | 1.19392 | 1.19461 | 25634.0 |
| 2019-06-26 | E6 | Futures | 1.24834 | 1.2508 | 1.246 | 1.24829 | 155624.0 |
| 2019-06-26 | E7 | Futures | 1.2419 | 1.2443 | 1.2395 | 1.2418 | 7396.0 |
| 2019-06-26 | EBM | Futures | 210.44 | 211.88 | 208.72 | 210.44 | 13711.0 |
| 2019-06-26 | ED | Futures | 95.4645 | 95.4645 | 95.4158 | 95.4158 | 331965.0 |
| 2019-06-26 | ER | Futures | 98.504 | 98.509 | 98.494 | 98.504 | 77048.0 |
| 2019-06-26 | EW | Futures | 2002.2 | 2013.7 | 1997.4 | 1999.3 | 9818.0 |
| 2019-06-26 | FBON | Futures | 142.73 | 142.88 | 142.63 | 142.81 | 113.0 |
| 2019-06-26 | FBTP | Futures | 119.87 | 120.25 | 119.44 | 120.05 | 93839.0 |
| 2019-06-26 | FBTS | Futures | 106.641 | 106.756 | 106.517 | 106.699 | 59054.0 |
| 2019-06-26 | FCE | Futures | 5021.7 | 5050.0 | 5013.4 | 5021.7 | 48273.0 |
| 2019-06-26 | FDAX | Futures | 12814.8 | 12954.9 | 12814.8 | 12870.1 | 104283.0 |
| 2019-06-26 | FDIV | Futures | 145.63 | 145.63 | 145.53 | 145.53 | 20.0 |
| 2019-06-26 | FDXM | Futures | 12646.6 | 12794.3 | 12646.6 | 12711.6 | 34017.0 |
| 2019-06-26 | FESX | Futures | 2988.1 | 3011.7 | 2988.1 | 2995.1 | 665606.0 |
| 2019-06-26 | FEU3 | Futures | 99.124 | 99.129 | 99.124 | 99.129 | 20.0 |
| 2019-06-26 | FGBL | Futures | 164.27 | 164.33 | 163.8 | 164.02 | 650645.0 |
| 2019-06-26 | FGBM | Futures | 134.42 | 134.44 | 134.25 | 134.32 | 433142.0 |
| 2019-06-26 | FGBS | Futures | 113.081 | 113.081 | 113.046 | 113.061 | 259026.0 |
| 2019-06-26 | FGBX | Futures | 209.65 | 209.86 | 208.39 | 209.09 | 75798.0 |
| 2019-06-26 | FMWO | Futures | 7285.2 | 7317.5 | 7277.1 | 7291.0 | 896.0 |
| 2019-06-26 | FOAT | Futures | 151.15 | 151.33 | 150.98 | 151.11 | 97793.0 |
| 2019-06-26 | FTDX | Futures | 2809.8 | 2809.8 | 2771.3 | 2771.3 | 93.0 |
| 2019-06-26 | FTI | Futures | 523.8 | 527.47 | 523.28 | 524.65 | 19247.0 |
| 2019-06-26 | FTUK | Futures | 6767.2 | 6801.9 | 6764.0 | 6786.2 | 57271.0 |
| 2019-06-26 | FVSA | Futures | 204.89 | 205.58 | 200.05 | 204.2 | 21345.0 |
| 2019-06-26 | FXXP | Futures | 340.9 | 342.8 | 340.5 | 340.8 | 44335.0 |
| 2019-06-26 | G | Futures | 120.19 | 120.34 | 119.87 | 120.05 | 174418.0 |
> showing 50 of 120 rows — these rows as CSV