PREVIEW / futures_daily / 2019-03-12
file: by_date/futures_daily/2019/2019-03-12.parquet size: 10 KB rows: 112
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-12 | ES | Futures | 3014.96 | 3029.58 | 3010.36 | 3022.81 | 958317.0 |
| 2019-03-12 | NQ | Futures | 8308.04 | 8362.45 | 8293.28 | 8343.35 | 167990.0 |
| 2019-03-12 | YM | Futures | 27132.0 | 27227.0 | 26966.3 | 27010.6 | 191462.0 |
| 2019-03-12 | CL | Futures | 58.67 | 59.49 | 58.65 | 58.79 | 652798.0 |
| 2019-03-12 | GC | Futures | 1617.0 | 1628.2 | 1615.0 | 1622.6 | 203894.0 |
| 2019-03-12 | ZN | Futures | 121.938301 | 122.295709 | 121.705209 | 122.202472 | 1758776.0 |
| 2019-03-12 | A6 | Futures | 0.72982 | 0.73199 | 0.72858 | 0.73157 | 34252.0 |
| 2019-03-12 | AD | Futures | 0.75645 | 0.75888 | 0.75519 | 0.75817 | 34391.0 |
| 2019-03-12 | B | Futures | 48.38 | 48.88 | 48.12 | 48.36 | 252126.0 |
| 2019-03-12 | B6 | Futures | 1.3572 | 1.3679 | 1.3387 | 1.3464 | 60414.0 |
| 2019-03-12 | BTC | Futures | 5911.1 | 5964.9 | 5826.5 | 5911.1 | 2961.0 |
| 2019-03-12 | BZ | Futures | 47.98 | 48.49 | 47.74 | 47.97 | 37897.0 |
| 2019-03-12 | C | Futures | 1475.0 | 1501.0 | 1465.0 | 1498.0 | 11876.0 |
| 2019-03-12 | CB | Futures | 278.125 | 278.125 | 278.125 | 278.125 | 27.0 |
| 2019-03-12 | CC | Futures | 1486.0 | 1502.0 | 1465.0 | 1496.0 | 17553.0 |
| 2019-03-12 | CNH | Futures | 6.739 | 6.739 | 6.7165 | 6.7165 | 283.0 |
| 2019-03-12 | CSC | Futures | 2.771 | 2.796 | 2.771 | 2.796 | 60.0 |
| 2019-03-12 | CT | Futures | 77.61 | 79.63 | 77.61 | 79.47 | 22548.0 |
| 2019-03-12 | DC | Futures | 23.59 | 23.86 | 23.59 | 23.82 | 82.0 |
| 2019-03-12 | DX | Futures | 92.487 | 92.713 | 92.281 | 92.381 | 9907.0 |
| 2019-03-12 | E1 | Futures | 1.16562 | 1.17006 | 1.16446 | 1.16924 | 14209.0 |
| 2019-03-12 | E6 | Futures | 1.24458 | 1.25078 | 1.24441 | 1.24979 | 154759.0 |
| 2019-03-12 | E7 | Futures | 1.2407 | 1.2444 | 1.2386 | 1.2436 | 2848.0 |
| 2019-03-12 | EBM | Futures | 191.84 | 195.81 | 191.57 | 195.01 | 21046.0 |
| 2019-03-12 | ED | Futures | 95.0965 | 95.1111 | 95.0867 | 95.1111 | 218118.0 |
| 2019-03-12 | ER | Futures | 98.401 | 98.406 | 98.401 | 98.401 | 22989.0 |
| 2019-03-12 | EW | Futures | 2004.8 | 2013.6 | 2001.8 | 2008.4 | 25328.0 |
| 2019-03-12 | FBON | Futures | 134.13 | 134.19 | 133.94 | 133.99 | 254.0 |
| 2019-03-12 | FBTP | Futures | 113.98 | 114.28 | 113.85 | 114.2 | 63382.0 |
| 2019-03-12 | FBTS | Futures | 105.779 | 105.808 | 105.655 | 105.75 | 43548.0 |
| 2019-03-12 | FCE | Futures | 4697.2 | 4702.6 | 4657.6 | 4680.3 | 144368.0 |
| 2019-03-12 | FDAX | Futures | 12195.7 | 12225.6 | 12080.6 | 12122.6 | 184259.0 |
| 2019-03-12 | FDXM | Futures | 12145.5 | 12151.7 | 12016.1 | 12055.2 | 3373.0 |
| 2019-03-12 | FESX | Futures | 2826.4 | 2831.7 | 2802.0 | 2816.8 | 1947700.0 |
| 2019-03-12 | FGBL | Futures | 158.52 | 159.0 | 158.21 | 158.8 | 733723.0 |
| 2019-03-12 | FGBM | Futures | 132.46 | 132.64 | 132.39 | 132.58 | 423568.0 |
| 2019-03-12 | FGBS | Futures | 112.663 | 112.703 | 112.648 | 112.683 | 253927.0 |
| 2019-03-12 | FGBX | Futures | 189.48 | 190.52 | 188.15 | 189.93 | 48766.0 |
| 2019-03-12 | FMWO | Futures | 7007.4 | 7013.2 | 6979.4 | 7009.7 | 16918.0 |
| 2019-03-12 | FOAT | Futures | 145.14 | 145.33 | 144.95 | 145.22 | 162118.0 |
| 2019-03-12 | FTDX | Futures | 2645.0 | 2645.0 | 2610.4 | 2620.3 | 1276.0 |
| 2019-03-12 | FTI | Futures | 502.27 | 502.97 | 498.37 | 500.05 | 46506.0 |
| 2019-03-12 | FTUK | Futures | 6468.8 | 6494.1 | 6415.7 | 6489.0 | 416075.0 |
| 2019-03-12 | FVSA | Futures | 252.53 | 255.79 | 249.27 | 250.9 | 22897.0 |
| 2019-03-12 | FXXP | Futures | 328.9 | 329.1 | 326.1 | 327.2 | 162187.0 |
| 2019-03-12 | G | Futures | 117.02 | 117.63 | 116.59 | 117.41 | 265991.0 |
| 2019-03-12 | GF | Futures | 311.696 | 312.391 | 307.419 | 308.809 | 8794.0 |
| 2019-03-12 | GSCI | Futures | 483.54 | 484.22 | 482.58 | 482.69 | 2226.0 |
| 2019-03-12 | HE | Futures | 71.253 | 72.215 | 70.151 | 71.989 | 33303.0 |
| 2019-03-12 | HG | Futures | 3.3281 | 3.386 | 3.3264 | 3.3533 | 68207.0 |
> showing 50 of 112 rows — these rows as CSV