PREVIEW / futures_daily / 2018-03-01
file: by_date/futures_daily/2018/2018-03-01.parquet size: 10 KB rows: 111
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 |
|---|---|---|---|---|---|---|---|
| 2018-03-01 | ES | Futures | 2954.41 | 2968.27 | 2889.47 | 2910.93 | 2818966.0 |
| 2018-03-01 | NQ | Futures | 8057.13 | 8079.68 | 7834.02 | 7918.05 | 793737.0 |
| 2018-03-01 | YM | Futures | 26460.1 | 26560.3 | 25765.1 | 25964.4 | 453185.0 |
| 2018-03-01 | CL | Futures | 61.99 | 62.27 | 60.61 | 61.42 | 812505.0 |
| 2018-03-01 | GC | Futures | 1685.2 | 1689.0 | 1665.1 | 1667.2 | 421743.0 |
| 2018-03-01 | ZN | Futures | 119.152189 | 119.753812 | 119.090484 | 119.661255 | 197034.0 |
| 2018-03-01 | A6 | Futures | 0.79833 | 0.79925 | 0.79339 | 0.79812 | 164393.0 |
| 2018-03-01 | AD | Futures | 0.79112 | 0.7928 | 0.78747 | 0.79163 | 124030.0 |
| 2018-03-01 | B | Futures | 46.6 | 46.94 | 45.61 | 46.07 | 340966.0 |
| 2018-03-01 | B6 | Futures | 1.4311 | 1.4345 | 1.4268 | 1.4328 | 146100.0 |
| 2018-03-01 | BTC | Futures | 14496.1 | 15397.8 | 14177.1 | 15349.2 | 1345.0 |
| 2018-03-01 | BZ | Futures | 46.17 | 46.35 | 45.04 | 45.5 | 44819.0 |
| 2018-03-01 | C | Futures | 1443.0 | 1470.0 | 1437.0 | 1465.0 | 7229.0 |
| 2018-03-01 | CB | Futures | 285.293 | 286.745 | 282.915 | 282.915 | 37.0 |
| 2018-03-01 | CC | Futures | 1622.0 | 1672.0 | 1611.0 | 1651.0 | 29638.0 |
| 2018-03-01 | CNH | Futures | 6.4672 | 6.4933 | 6.4672 | 6.4773 | 119.0 |
| 2018-03-01 | CSC | Futures | 3.346 | 3.346 | 3.335 | 3.337 | 19.0 |
| 2018-03-01 | CT | Futures | 95.07 | 95.47 | 92.73 | 94.04 | 27301.0 |
| 2018-03-01 | DC | Futures | 26.49 | 26.49 | 26.15 | 26.33 | 65.0 |
| 2018-03-01 | DX | Futures | 85.134 | 85.35 | 84.669 | 84.783 | 39784.0 |
| 2018-03-01 | E1 | Futures | 1.287 | 1.29149 | 1.28068 | 1.28918 | 41203.0 |
| 2018-03-01 | E6 | Futures | 1.38376 | 1.39277 | 1.37922 | 1.3905 | 272621.0 |
| 2018-03-01 | E7 | Futures | 1.377 | 1.3858 | 1.3722 | 1.3836 | 4072.0 |
| 2018-03-01 | EBM | Futures | 179.63 | 180.71 | 178.01 | 180.44 | 10123.0 |
| 2018-03-01 | ED | Futures | 95.0664 | 95.1174 | 95.064 | 95.1149 | 614865.0 |
| 2018-03-01 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.337 | 38260.0 |
| 2018-03-01 | EW | Futures | 1979.3 | 1993.6 | 1953.6 | 1970.3 | 28158.0 |
| 2018-03-01 | FBON | Futures | 126.51 | 126.95 | 126.47 | 126.86 | 771.0 |
| 2018-03-01 | FBTP | Futures | 111.78 | 112.2 | 111.69 | 112.13 | 154004.0 |
| 2018-03-01 | FBTS | Futures | 103.695 | 103.714 | 103.659 | 103.704 | 77758.0 |
| 2018-03-01 | FCE | Futures | 4674.8 | 4696.0 | 4587.4 | 4647.4 | 108085.0 |
| 2018-03-01 | FDAX | Futures | 12813.3 | 12861.6 | 12455.9 | 12610.0 | 156276.0 |
| 2018-03-01 | FDXM | Futures | 12834.5 | 12883.4 | 12477.0 | 12631.4 | 64383.0 |
| 2018-03-01 | FESX | Futures | 2790.6 | 2805.3 | 2735.9 | 2770.2 | 1644871.0 |
| 2018-03-01 | FEU3 | Futures | 99.006 | 99.006 | 99.006 | 99.006 | 99.0 |
| 2018-03-01 | FGBL | Futures | 147.78 | 148.37 | 147.77 | 148.01 | 959559.0 |
| 2018-03-01 | FGBM | Futures | 128.84 | 129.0 | 128.82 | 128.9 | 766564.0 |
| 2018-03-01 | FGBS | Futures | 112.367 | 112.412 | 112.367 | 112.397 | 829625.0 |
| 2018-03-01 | FGBX | Futures | 166.34 | 167.47 | 166.15 | 166.75 | 76741.0 |
| 2018-03-01 | FMWO | Futures | 6942.2 | 6981.9 | 6853.5 | 6936.3 | 2919.0 |
| 2018-03-01 | FOAT | Futures | 136.83 | 137.11 | 136.78 | 136.96 | 191104.0 |
| 2018-03-01 | FTDX | Futures | 2621.2 | 2628.6 | 2523.9 | 2548.3 | 351.0 |
| 2018-03-01 | FTI | Futures | 488.68 | 490.06 | 479.27 | 486.2 | 35414.0 |
| 2018-03-01 | FTUK | Futures | 6294.2 | 6306.8 | 6189.8 | 6245.7 | 157945.0 |
| 2018-03-01 | FVSA | Futures | 434.59 | 497.37 | 428.43 | 455.51 | 37548.0 |
| 2018-03-01 | FXXP | Futures | 322.1 | 322.4 | 315.1 | 318.5 | 56485.0 |
| 2018-03-01 | G | Futures | 112.8 | 113.34 | 112.77 | 113.09 | 247092.0 |
| 2018-03-01 | GF | Futures | 318.196 | 319.458 | 315.341 | 318.525 | 2666.0 |
| 2018-03-01 | GSCI | Futures | 502.63 | 503.82 | 497.34 | 501.89 | 1186.0 |
| 2018-03-01 | HE | Futures | 86.675 | 87.092 | 85.872 | 86.001 | 20884.0 |
> showing 50 of 111 rows — these rows as CSV