PREVIEW / futures_daily / 2019-05-06
file: by_date/futures_daily/2019/2019-05-06.parquet size: 10 KB rows: 113
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-06 | ES | Futures | 3151.68 | 3173.82 | 3114.68 | 3167.61 | 2037157.0 |
| 2019-05-06 | NQ | Futures | 8998.72 | 9007.36 | 8834.53 | 8991.23 | 630196.0 |
| 2019-05-06 | YM | Futures | 27744.3 | 27916.3 | 27372.7 | 27872.0 | 282576.0 |
| 2019-05-06 | CL | Futures | 63.07 | 64.63 | 61.64 | 63.91 | 768810.0 |
| 2019-05-06 | GC | Futures | 1595.4 | 1602.3 | 1590.8 | 1597.8 | 244342.0 |
| 2019-05-06 | ZN | Futures | 122.886209 | 123.430091 | 122.886209 | 122.948367 | 1421616.0 |
| 2019-05-06 | A6 | Futures | 0.72096 | 0.72271 | 0.71848 | 0.7223 | 93077.0 |
| 2019-05-06 | AD | Futures | 0.75276 | 0.75342 | 0.74988 | 0.75312 | 65375.0 |
| 2019-05-06 | B | Futures | 52.02 | 52.9 | 50.69 | 52.49 | 227024.0 |
| 2019-05-06 | B6 | Futures | 1.3514 | 1.3521 | 1.3429 | 1.3447 | 72288.0 |
| 2019-05-06 | BR | Futures | 0.20068 | 0.2022 | 0.19976 | 0.20196 | 2178.0 |
| 2019-05-06 | BTC | Futures | 8869.1 | 8961.9 | 8606.2 | 8884.6 | 7075.0 |
| 2019-05-06 | BZ | Futures | 51.88 | 52.76 | 50.53 | 52.35 | 36208.0 |
| 2019-05-06 | CB | Futures | 278.125 | 278.125 | 278.095 | 278.095 | 3.0 |
| 2019-05-06 | CC | Futures | 1583.0 | 1606.0 | 1567.0 | 1575.0 | 14339.0 |
| 2019-05-06 | CNH | Futures | 6.7692 | 6.8316 | 6.7692 | 6.7804 | 1167.0 |
| 2019-05-06 | CSC | Futures | 3.008 | 3.033 | 3.008 | 3.024 | 94.0 |
| 2019-05-06 | CT | Futures | 78.71 | 78.72 | 76.43 | 76.99 | 31814.0 |
| 2019-05-06 | DC | Futures | 25.49 | 25.64 | 25.32 | 25.46 | 447.0 |
| 2019-05-06 | DX | Futures | 93.297 | 93.422 | 93.192 | 93.233 | 9238.0 |
| 2019-05-06 | E1 | Futures | 1.15221 | 1.15396 | 1.14882 | 1.15139 | 19476.0 |
| 2019-05-06 | E6 | Futures | 1.23163 | 1.23459 | 1.23119 | 1.23398 | 121218.0 |
| 2019-05-06 | E7 | Futures | 1.2261 | 1.2285 | 1.2251 | 1.2279 | 4797.0 |
| 2019-05-06 | EBM | Futures | 196.34 | 197.49 | 195.47 | 196.91 | 18950.0 |
| 2019-05-06 | ED | Futures | 95.1599 | 95.1795 | 95.1599 | 95.1648 | 143950.0 |
| 2019-05-06 | ER | Futures | 98.416 | 98.416 | 98.411 | 98.411 | 11408.0 |
| 2019-05-06 | EW | Futures | 2091.6 | 2105.5 | 2059.8 | 2100.4 | 14762.0 |
| 2019-05-06 | FBON | Futures | 136.62 | 136.66 | 136.44 | 136.53 | 403.0 |
| 2019-05-06 | FBTP | Futures | 115.8 | 115.8 | 115.3 | 115.69 | 40851.0 |
| 2019-05-06 | FBTS | Futures | 105.931 | 106.046 | 105.931 | 106.017 | 25327.0 |
| 2019-05-06 | FCE | Futures | 4908.7 | 4935.7 | 4859.2 | 4915.9 | 97172.0 |
| 2019-05-06 | FDAX | Futures | 12985.3 | 13000.6 | 12783.2 | 12955.9 | 125750.0 |
| 2019-05-06 | FDIV | Futures | 147.9 | 148.64 | 147.3 | 148.64 | 35.0 |
| 2019-05-06 | FDXM | Futures | 12875.9 | 12888.5 | 12672.5 | 12843.6 | 51480.0 |
| 2019-05-06 | FESX | Futures | 3000.4 | 3000.4 | 2949.7 | 2989.0 | 1037984.0 |
| 2019-05-06 | FGBL | Futures | 159.74 | 160.08 | 159.55 | 159.67 | 324782.0 |
| 2019-05-06 | FGBM | Futures | 133.07 | 133.14 | 132.98 | 133.02 | 186770.0 |
| 2019-05-06 | FGBS | Futures | 112.774 | 112.784 | 112.759 | 112.769 | 91493.0 |
| 2019-05-06 | FGBX | Futures | 193.36 | 194.35 | 192.57 | 192.89 | 18953.0 |
| 2019-05-06 | FMWO | Futures | 7186.0 | 7285.5 | 7177.9 | 7258.9 | 2456.0 |
| 2019-05-06 | FOAT | Futures | 146.93 | 146.97 | 146.61 | 146.78 | 59193.0 |
| 2019-05-06 | FTDX | Futures | 2784.6 | 2812.8 | 2775.8 | 2806.8 | 448.0 |
| 2019-05-06 | FTI | Futures | 530.78 | 534.09 | 526.74 | 532.62 | 29118.0 |
| 2019-05-06 | FVSA | Futures | 215.76 | 221.34 | 206.68 | 210.17 | 44003.0 |
| 2019-05-06 | FXXP | Futures | 342.3 | 343.6 | 338.4 | 342.6 | 75033.0 |
| 2019-05-06 | GF | Futures | 282.415 | 287.308 | 278.304 | 283.196 | 2260.0 |
| 2019-05-06 | GSCI | Futures | 495.2 | 496.83 | 494.41 | 496.83 | 45.0 |
| 2019-05-06 | HE | Futures | 85.021 | 85.021 | 85.021 | 85.021 | 6124.0 |
| 2019-05-06 | HG | Futures | 3.205 | 3.2617 | 3.1392 | 3.24 | 89108.0 |
| 2019-05-06 | HH | Futures | 16.885 | 16.945 | 16.791 | 16.825 | 1569.0 |
> showing 50 of 113 rows — these rows as CSV