PREVIEW / futures_daily / 2018-12-07
file: by_date/futures_daily/2018/2018-12-07.parquet size: 10 KB rows: 114
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-12-07 | ES | Futures | 2921.94 | 2938.75 | 2844.94 | 2858.77 | 2596155.0 |
| 2018-12-07 | NQ | Futures | 7939.61 | 7964.0 | 7659.97 | 7693.37 | 854199.0 |
| 2018-12-07 | YM | Futures | 26239.7 | 26446.1 | 25585.8 | 25728.0 | 396882.0 |
| 2018-12-07 | CL | Futures | 54.76 | 57.37 | 53.54 | 55.66 | 987717.0 |
| 2018-12-07 | GC | Futures | 1566.3 | 1582.3 | 1565.7 | 1578.3 | 225556.0 |
| 2018-12-07 | ZN | Futures | 119.884179 | 120.319952 | 119.775236 | 120.288825 | 45301.0 |
| 2018-12-07 | A6 | Futures | 0.74424 | 0.74527 | 0.74054 | 0.74187 | 103832.0 |
| 2018-12-07 | AD | Futures | 0.75535 | 0.76308 | 0.75469 | 0.76137 | 117930.0 |
| 2018-12-07 | B | Futures | 44.24 | 46.79 | 43.39 | 45.28 | 423077.0 |
| 2018-12-07 | B6 | Futures | 1.3146 | 1.3158 | 1.3076 | 1.3119 | 99646.0 |
| 2018-12-07 | BR | Futures | 0.20535 | 0.20535 | 0.2046 | 0.2046 | 13.0 |
| 2018-12-07 | BTC | Futures | 5454.9 | 5485.4 | 4783.5 | 5035.3 | 6081.0 |
| 2018-12-07 | BZ | Futures | 43.71 | 46.18 | 42.84 | 44.7 | 59861.0 |
| 2018-12-07 | C | Futures | 1393.0 | 1439.0 | 1383.0 | 1431.0 | 5387.0 |
| 2018-12-07 | CB | Futures | 266.913 | 267.277 | 266.336 | 266.913 | 37.0 |
| 2018-12-07 | CC | Futures | 1470.0 | 1548.0 | 1466.0 | 1533.0 | 30127.0 |
| 2018-12-07 | CNH | Futures | 6.9225 | 6.9255 | 6.9033 | 6.9213 | 477.0 |
| 2018-12-07 | CSC | Futures | 2.827 | 2.832 | 2.823 | 2.829 | 81.0 |
| 2018-12-07 | CT | Futures | 85.95 | 88.16 | 85.84 | 87.4 | 19461.0 |
| 2018-12-07 | DC | Futures | 23.81 | 23.86 | 23.7 | 23.75 | 64.0 |
| 2018-12-07 | DX | Futures | 91.915 | 92.044 | 91.64 | 91.65 | 20044.0 |
| 2018-12-07 | E1 | Futures | 1.19485 | 1.19924 | 1.18525 | 1.19888 | 21697.0 |
| 2018-12-07 | E6 | Futures | 1.26577 | 1.27094 | 1.26382 | 1.27077 | 224989.0 |
| 2018-12-07 | E7 | Futures | 1.2596 | 1.2647 | 1.2577 | 1.2646 | 3612.0 |
| 2018-12-07 | EBM | Futures | 207.94 | 209.74 | 207.94 | 209.48 | 20605.0 |
| 2018-12-07 | ED | Futures | 94.9182 | 94.9328 | 94.9133 | 94.9255 | 393339.0 |
| 2018-12-07 | ER | Futures | 98.386 | 98.391 | 98.386 | 98.391 | 28863.0 |
| 2018-12-07 | EW | Futures | 1910.2 | 1923.7 | 1861.4 | 1872.0 | 23595.0 |
| 2018-12-07 | FBON | Futures | 129.02 | 129.08 | 128.93 | 129.06 | 135.0 |
| 2018-12-07 | FBTP | Futures | 107.45 | 108.13 | 107.26 | 107.98 | 57748.0 |
| 2018-12-07 | FBTS | Futures | 103.544 | 103.78 | 103.468 | 103.704 | 45823.0 |
| 2018-12-07 | FCE | Futures | 4332.6 | 4358.6 | 4267.3 | 4300.8 | 114896.0 |
| 2018-12-07 | FDAX | Futures | 11491.1 | 11497.4 | 11226.7 | 11373.9 | 126530.0 |
| 2018-12-07 | FDXM | Futures | 11285.9 | 11298.3 | 11032.8 | 11176.9 | 60070.0 |
| 2018-12-07 | FESX | Futures | 2586.5 | 2598.3 | 2543.7 | 2571.4 | 1469053.0 |
| 2018-12-07 | FGBL | Futures | 155.2 | 155.42 | 154.91 | 155.14 | 620254.0 |
| 2018-12-07 | FGBM | Futures | 131.82 | 131.89 | 131.68 | 131.75 | 380904.0 |
| 2018-12-07 | FGBS | Futures | 112.729 | 112.744 | 112.663 | 112.688 | 376017.0 |
| 2018-12-07 | FGBX | Futures | 182.66 | 183.72 | 181.95 | 182.74 | 52366.0 |
| 2018-12-07 | FMWO | Futures | 6591.7 | 6667.0 | 6534.9 | 6577.8 | 5156.0 |
| 2018-12-07 | FOAT | Futures | 141.73 | 141.82 | 141.35 | 141.52 | 145506.0 |
| 2018-12-07 | FTDX | Futures | 2489.0 | 2508.6 | 2452.2 | 2475.2 | 462.0 |
| 2018-12-07 | FTI | Futures | 467.8 | 472.85 | 463.39 | 467.67 | 37119.0 |
| 2018-12-07 | FTUK | Futures | 6065.5 | 6140.1 | 6018.6 | 6071.3 | 154948.0 |
| 2018-12-07 | FVSA | Futures | 374.97 | 407.23 | 371.95 | 395.13 | 45603.0 |
| 2018-12-07 | FXXP | Futures | 300.4 | 302.4 | 296.4 | 299.5 | 76077.0 |
| 2018-12-07 | G | Futures | 117.14 | 117.19 | 116.75 | 116.95 | 247931.0 |
| 2018-12-07 | GF | Futures | 310.889 | 312.02 | 308.468 | 310.782 | 5478.0 |
| 2018-12-07 | GSCI | Futures | 474.24 | 474.24 | 468.66 | 468.66 | 2411.0 |
| 2018-12-07 | HE | Futures | 81.263 | 81.714 | 79.46 | 81.624 | 19587.0 |
> showing 50 of 114 rows — these rows as CSV