PREVIEW / futures_daily / 2016-02-18
file: by_date/futures_daily/2016/2016-02-18.parquet size: 9 KB rows: 109
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-18 | ES | Futures | 2058.03 | 2065.24 | 2041.48 | 2047.08 | 1615605.0 |
| 2016-02-18 | NQ | Futures | 4933.36 | 4955.93 | 4858.04 | 4870.94 | 254579.0 |
| 2016-02-18 | YM | Futures | 17020.4 | 17089.7 | 16924.2 | 16961.4 | 158898.0 |
| 2016-02-18 | CL | Futures | 42.15 | 42.98 | 40.77 | 41.37 | 432126.0 |
| 2016-02-18 | GC | Futures | 1554.1 | 1594.1 | 1543.6 | 1575.7 | 182120.0 |
| 2016-02-18 | ZN | Futures | 125.567064 | 126.213852 | 125.446731 | 126.033353 | 1335348.0 |
| 2016-02-18 | A6 | Futures | 0.71813 | 0.71883 | 0.71402 | 0.71652 | 68939.0 |
| 2016-02-18 | AD | Futures | 0.74721 | 0.74885 | 0.74353 | 0.74415 | 57146.0 |
| 2016-02-18 | ALI | Futures | 2066.85 | 2066.85 | 2066.85 | 2066.85 | 0.0 |
| 2016-02-18 | B | Futures | 29.34 | 30.02 | 28.39 | 28.81 | 324096.0 |
| 2016-02-18 | B6 | Futures | 1.5034 | 1.5146 | 1.5002 | 1.5064 | 76398.0 |
| 2016-02-18 | BFX | Futures | 3931.2 | 3971.0 | 3916.6 | 3916.6 | 23.0 |
| 2016-02-18 | BR | Futures | 0.15843 | 0.15843 | 0.15463 | 0.15494 | 2045.0 |
| 2016-02-18 | BZ | Futures | 29.12 | 29.8 | 28.19 | 28.59 | 33585.0 |
| 2016-02-18 | C | Futures | 2177.0 | 2221.0 | 2173.0 | 2220.0 | 7515.0 |
| 2016-02-18 | CB | Futures | 258.493 | 262.235 | 258.493 | 258.524 | 29.0 |
| 2016-02-18 | CC | Futures | 2101.0 | 2145.0 | 2098.0 | 2137.0 | 17952.0 |
| 2016-02-18 | CNH | Futures | 7.1755 | 7.1935 | 7.1755 | 7.1862 | 16.0 |
| 2016-02-18 | CSC | Futures | 3.723 | 3.748 | 3.723 | 3.743 | 5.0 |
| 2016-02-18 | CT | Futures | 70.04 | 71.27 | 69.92 | 70.18 | 10823.0 |
| 2016-02-18 | DC | Futures | 29.72 | 29.87 | 29.68 | 29.74 | 242.0 |
| 2016-02-18 | DX | Futures | 90.458 | 90.706 | 90.337 | 90.575 | 13496.0 |
| 2016-02-18 | E1 | Futures | 1.27334 | 1.27574 | 1.26753 | 1.27018 | 15846.0 |
| 2016-02-18 | E6 | Futures | 1.30209 | 1.30449 | 1.29519 | 1.29835 | 179893.0 |
| 2016-02-18 | E7 | Futures | 1.2946 | 1.2971 | 1.288 | 1.2911 | 3071.0 |
| 2016-02-18 | EBM | Futures | 216.11 | 216.82 | 214.7 | 215.76 | 12341.0 |
| 2016-02-18 | ED | Futures | 95.6361 | 95.6434 | 95.6361 | 95.6385 | 144450.0 |
| 2016-02-18 | ER | Futures | 98.293 | 98.308 | 98.288 | 98.303 | 89097.0 |
| 2016-02-18 | EW | Futures | 1382.0 | 1388.2 | 1370.3 | 1378.3 | 16266.0 |
| 2016-02-18 | FBON | Futures | 116.0 | 116.34 | 115.93 | 116.07 | 620.0 |
| 2016-02-18 | FBTP | Futures | 104.94 | 105.59 | 104.86 | 105.21 | 100916.0 |
| 2016-02-18 | FBTS | Futures | 100.766 | 100.855 | 100.766 | 100.819 | 24755.0 |
| 2016-02-18 | FCE | Futures | 3532.3 | 3563.1 | 3506.1 | 3529.0 | 68326.0 |
| 2016-02-18 | FDAX | Futures | 10183.3 | 10354.1 | 10130.7 | 10254.4 | 107918.0 |
| 2016-02-18 | FDXM | Futures | 9746.1 | 9899.5 | 9687.0 | 9805.2 | 21755.0 |
| 2016-02-18 | FESX | Futures | 2208.8 | 2232.4 | 2190.6 | 2198.2 | 1485424.0 |
| 2016-02-18 | FGBL | Futures | 144.88 | 145.61 | 144.76 | 145.45 | 674525.0 |
| 2016-02-18 | FGBM | Futures | 127.42 | 127.55 | 127.35 | 127.53 | 456518.0 |
| 2016-02-18 | FGBS | Futures | 111.763 | 111.778 | 111.743 | 111.773 | 249283.0 |
| 2016-02-18 | FGBX | Futures | 170.25 | 172.49 | 169.7 | 171.79 | 32167.0 |
| 2016-02-18 | FMWO | Futures | 5224.4 | 5251.8 | 5208.2 | 5215.7 | 1063.0 |
| 2016-02-18 | FOAT | Futures | 131.45 | 132.16 | 131.44 | 132.12 | 120602.0 |
| 2016-02-18 | FTDX | Futures | 1530.9 | 1563.5 | 1530.9 | 1550.5 | 448.0 |
| 2016-02-18 | FTI | Futures | 366.69 | 370.8 | 365.0 | 366.11 | 15579.0 |
| 2016-02-18 | FTUK | Futures | 4893.6 | 4898.0 | 4828.7 | 4849.5 | 126056.0 |
| 2016-02-18 | FVSA | Futures | 3331.94 | 3413.77 | 3296.86 | 3402.08 | 8517.0 |
| 2016-02-18 | FXXP | Futures | 257.6 | 260.8 | 256.7 | 258.2 | 27047.0 |
| 2016-02-18 | G | Futures | 108.17 | 108.36 | 107.76 | 108.31 | 164706.0 |
| 2016-02-18 | GF | Futures | 307.587 | 309.256 | 304.494 | 307.243 | 2707.0 |
| 2016-02-18 | GSCI | Futures | 462.4 | 463.93 | 455.54 | 456.53 | 99.0 |
> showing 50 of 109 rows — these rows as CSV