PREVIEW / futures_daily / 2020-05-26
file: by_date/futures_daily/2020/2020-05-26.parquet size: 10 KB rows: 119
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 |
|---|---|---|---|---|---|---|---|
| 2020-05-26 | ES | Futures | 3262.47 | 3341.31 | 3261.37 | 3313.37 | 1797241.0 |
| 2020-05-26 | NQ | Futures | 10772.24 | 11010.41 | 10745.58 | 10783.99 | 486546.0 |
| 2020-05-26 | YM | Futures | 26047.8 | 26811.8 | 26010.5 | 26678.5 | 252113.0 |
| 2020-05-26 | CL | Futures | 24.14 | 25.24 | 23.55 | 24.9 | 466737.0 |
| 2020-05-26 | GC | Futures | 2104.7 | 2107.8 | 2066.5 | 2074.9 | 152501.0 |
| 2020-05-26 | ZN | Futures | 137.500532 | 137.562275 | 137.114642 | 137.268998 | 3549623.0 |
| 2020-05-26 | A6 | Futures | 0.67127 | 0.68586 | 0.66973 | 0.68576 | 124592.0 |
| 2020-05-26 | AD | Futures | 0.72419 | 0.73666 | 0.72343 | 0.73656 | 94146.0 |
| 2020-05-26 | ALI | Futures | 1822.19 | 1822.19 | 1822.19 | 1822.19 | 0.0 |
| 2020-05-26 | B | Futures | 23.76 | 24.38 | 23.45 | 24.05 | 195005.0 |
| 2020-05-26 | B6 | Futures | 1.2354 | 1.255 | 1.2348 | 1.2529 | 127637.0 |
| 2020-05-26 | BR | Futures | 0.14714 | 0.14766 | 0.14714 | 0.14766 | 511.0 |
| 2020-05-26 | BTC | Futures | 12684.4 | 12698.3 | 12093.3 | 12315.8 | 2493.0 |
| 2020-05-26 | BZ | Futures | 22.59 | 23.8 | 22.39 | 23.49 | 25769.0 |
| 2020-05-26 | C | Futures | 1895.0 | 1904.0 | 1858.0 | 1859.0 | 6733.0 |
| 2020-05-26 | CC | Futures | 1564.0 | 1600.0 | 1562.0 | 1564.0 | 20819.0 |
| 2020-05-26 | CNH | Futures | 7.0876 | 7.1711 | 7.0771 | 7.0794 | 904.0 |
| 2020-05-26 | CSC | Futures | 3.293 | 3.356 | 3.278 | 3.354 | 166.0 |
| 2020-05-26 | CT | Futures | 56.34 | 57.95 | 56.21 | 56.76 | 11820.0 |
| 2020-05-26 | DC | Futures | 27.08 | 27.82 | 26.93 | 27.75 | 143.0 |
| 2020-05-26 | DX | Futures | 96.465 | 96.49 | 95.629 | 95.64 | 18167.0 |
| 2020-05-26 | E1 | Futures | 1.17281 | 1.18123 | 1.17041 | 1.18078 | 22899.0 |
| 2020-05-26 | E6 | Futures | 1.17176 | 1.18224 | 1.1687 | 1.18203 | 203562.0 |
| 2020-05-26 | E7 | Futures | 1.1656 | 1.1761 | 1.1627 | 1.1758 | 8383.0 |
| 2020-05-26 | EBM | Futures | 225.74 | 225.74 | 223.65 | 224.84 | 17131.0 |
| 2020-05-26 | ED | Futures | 96.3726 | 96.3726 | 96.3581 | 96.3678 | 214219.0 |
| 2020-05-26 | ER | Futures | 98.274 | 98.274 | 98.259 | 98.259 | 35134.0 |
| 2020-05-26 | ESG | Futures | 272.32 | 272.32 | 269.88 | 270.03 | 138.0 |
| 2020-05-26 | EW | Futures | 1794.3 | 1869.8 | 1791.8 | 1855.4 | 11197.0 |
| 2020-05-26 | FBON | Futures | 141.69 | 142.11 | 141.69 | 141.89 | 580.0 |
| 2020-05-26 | FBTP | Futures | 126.03 | 126.58 | 125.91 | 126.39 | 88595.0 |
| 2020-05-26 | FBTS | Futures | 107.432 | 107.595 | 107.432 | 107.576 | 65059.0 |
| 2020-05-26 | FCE | Futures | 4447.5 | 4478.1 | 4432.0 | 4463.6 | 68488.0 |
| 2020-05-26 | FDAX | Futures | 12016.9 | 12208.4 | 12005.3 | 12177.2 | 79263.0 |
| 2020-05-26 | FDIV | Futures | 128.83 | 130.18 | 128.83 | 130.18 | 200.0 |
| 2020-05-26 | FDXM | Futures | 12085.0 | 12266.7 | 12063.7 | 12235.4 | 61340.0 |
| 2020-05-26 | FESX | Futures | 2711.3 | 2755.3 | 2709.4 | 2748.0 | 1050256.0 |
| 2020-05-26 | FGBL | Futures | 168.27 | 168.32 | 167.2 | 167.35 | 705392.0 |
| 2020-05-26 | FGBM | Futures | 134.74 | 134.74 | 134.33 | 134.38 | 450693.0 |
| 2020-05-26 | FGBS | Futures | 112.79 | 112.8 | 112.719 | 112.729 | 493898.0 |
| 2020-05-26 | FGBX | Futures | 226.97 | 227.05 | 223.36 | 224.32 | 54055.0 |
| 2020-05-26 | FMWO | Futures | 7352.7 | 7392.7 | 7329.2 | 7370.3 | 5938.0 |
| 2020-05-26 | FOAT | Futures | 153.06 | 153.06 | 152.3 | 152.47 | 163882.0 |
| 2020-05-26 | FTDX | Futures | 3207.0 | 3219.6 | 3154.9 | 3209.5 | 800.0 |
| 2020-05-26 | FTI | Futures | 500.11 | 501.65 | 491.82 | 494.39 | 21049.0 |
| 2020-05-26 | FTUK | Futures | 5729.5 | 5809.2 | 5693.6 | 5718.2 | 107243.0 |
| 2020-05-26 | FVSA | Futures | 251.99 | 263.75 | 251.08 | 255.15 | 10207.0 |
| 2020-05-26 | FXXP | Futures | 322.7 | 324.6 | 321.0 | 323.0 | 141863.0 |
| 2020-05-26 | G | Futures | 126.88 | 127.1 | 126.63 | 126.7 | 352824.0 |
| 2020-05-26 | GF | Futures | 251.566 | 258.399 | 251.227 | 258.399 | 3973.0 |
> showing 50 of 119 rows — these rows as CSV