PREVIEW / futures_daily / 2018-02-08
file: by_date/futures_daily/2018/2018-02-08.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 |
|---|---|---|---|---|---|---|---|
| 2018-02-08 | ES | Futures | 2896.26 | 2919.9 | 2800.89 | 2818.82 | 3121915.0 |
| 2018-02-08 | NQ | Futures | 7661.86 | 7751.45 | 7379.6 | 7398.63 | 640585.0 |
| 2018-02-08 | YM | Futures | 26065.7 | 26289.2 | 25099.6 | 25278.9 | 492406.0 |
| 2018-02-08 | CL | Futures | 61.69 | 62.08 | 60.26 | 61.14 | 929578.0 |
| 2018-02-08 | GC | Futures | 1687.0 | 1691.8 | 1672.0 | 1684.8 | 365934.0 |
| 2018-02-08 | ZN | Futures | 119.537845 | 119.707534 | 118.997927 | 119.35273 | 3081009.0 |
| 2018-02-08 | A6 | Futures | 0.80357 | 0.80666 | 0.79966 | 0.80193 | 168776.0 |
| 2018-02-08 | AD | Futures | 0.80777 | 0.80955 | 0.80513 | 0.80681 | 107309.0 |
| 2018-02-08 | B | Futures | 46.84 | 47.07 | 46.0 | 46.51 | 346318.0 |
| 2018-02-08 | B6 | Futures | 1.4444 | 1.4651 | 1.4419 | 1.4498 | 248825.0 |
| 2018-02-08 | BR | Futures | 0.23089 | 0.23245 | 0.22937 | 0.22983 | 4440.0 |
| 2018-02-08 | BTC | Futures | 10136.6 | 11307.7 | 9947.9 | 10832.8 | 906.0 |
| 2018-02-08 | BZ | Futures | 46.34 | 46.45 | 45.4 | 45.9 | 37936.0 |
| 2018-02-08 | C | Futures | 1315.0 | 1342.0 | 1314.0 | 1335.0 | 10421.0 |
| 2018-02-08 | CB | Futures | 262.901 | 263.518 | 261.912 | 262.067 | 36.0 |
| 2018-02-08 | CC | Futures | 1489.0 | 1522.0 | 1485.0 | 1511.0 | 35691.0 |
| 2018-02-08 | CNH | Futures | 6.4408 | 6.5153 | 6.4408 | 6.5049 | 194.0 |
| 2018-02-08 | CSC | Futures | 3.169 | 3.18 | 3.169 | 3.178 | 31.0 |
| 2018-02-08 | CT | Futures | 88.66 | 90.54 | 88.64 | 89.49 | 37960.0 |
| 2018-02-08 | DC | Futures | 25.04 | 25.09 | 24.92 | 25.0 | 260.0 |
| 2018-02-08 | DX | Futures | 84.665 | 84.946 | 84.42 | 84.628 | 35270.0 |
| 2018-02-08 | E1 | Futures | 1.28979 | 1.3012 | 1.28542 | 1.29938 | 36725.0 |
| 2018-02-08 | E6 | Futures | 1.3926 | 1.39708 | 1.38761 | 1.39339 | 323227.0 |
| 2018-02-08 | E7 | Futures | 1.3856 | 1.39 | 1.3806 | 1.3864 | 5357.0 |
| 2018-02-08 | EBM | Futures | 172.89 | 173.16 | 172.08 | 172.35 | 29086.0 |
| 2018-02-08 | ED | Futures | 95.2533 | 95.2533 | 95.2193 | 95.2242 | 536452.0 |
| 2018-02-08 | ER | Futures | 98.332 | 98.337 | 98.332 | 98.332 | 63256.0 |
| 2018-02-08 | EW | Futures | 1963.6 | 1977.8 | 1907.6 | 1909.2 | 35047.0 |
| 2018-02-08 | FBON | Futures | 126.75 | 126.99 | 126.39 | 126.49 | 335.0 |
| 2018-02-08 | FBTP | Futures | 111.68 | 112.01 | 110.99 | 111.18 | 149805.0 |
| 2018-02-08 | FBTS | Futures | 103.714 | 103.768 | 103.659 | 103.704 | 86546.0 |
| 2018-02-08 | FCE | Futures | 4638.7 | 4678.9 | 4547.3 | 4592.4 | 132954.0 |
| 2018-02-08 | FDAX | Futures | 12968.4 | 13013.0 | 12578.8 | 12648.4 | 131074.0 |
| 2018-02-08 | FDIV | Futures | 142.32 | 142.36 | 140.49 | 140.49 | 50.0 |
| 2018-02-08 | FDXM | Futures | 12995.6 | 13035.1 | 12605.9 | 12669.8 | 59886.0 |
| 2018-02-08 | FESX | Futures | 2793.9 | 2811.0 | 2725.3 | 2743.2 | 2042238.0 |
| 2018-02-08 | FEU3 | Futures | 99.006 | 99.006 | 99.006 | 99.006 | 20.0 |
| 2018-02-08 | FGBL | Futures | 146.36 | 146.65 | 145.75 | 146.19 | 1156970.0 |
| 2018-02-08 | FGBM | Futures | 128.17 | 128.32 | 127.95 | 128.16 | 844106.0 |
| 2018-02-08 | FGBS | Futures | 112.211 | 112.266 | 112.201 | 112.236 | 370527.0 |
| 2018-02-08 | FGBX | Futures | 163.99 | 164.77 | 162.69 | 163.66 | 70751.0 |
| 2018-02-08 | FMWO | Futures | 6924.7 | 6935.2 | 6722.7 | 6819.6 | 7671.0 |
| 2018-02-08 | FOAT | Futures | 135.73 | 136.07 | 135.26 | 135.58 | 162166.0 |
| 2018-02-08 | FTDX | Futures | 2538.9 | 2538.9 | 2420.7 | 2442.6 | 513.0 |
| 2018-02-08 | FTI | Futures | 492.87 | 494.78 | 481.86 | 487.43 | 52829.0 |
| 2018-02-08 | FTUK | Futures | 6256.2 | 6290.2 | 6145.7 | 6207.7 | 208157.0 |
| 2018-02-08 | FVSA | Futures | 363.91 | 498.97 | 344.98 | 455.1 | 83465.0 |
| 2018-02-08 | FXXP | Futures | 320.9 | 322.7 | 314.4 | 316.9 | 64558.0 |
| 2018-02-08 | G | Futures | 112.16 | 112.23 | 111.11 | 111.4 | 325630.0 |
| 2018-02-08 | GF | Futures | 326.595 | 329.944 | 322.917 | 323.356 | 8100.0 |
> showing 50 of 113 rows — these rows as CSV