PREVIEW / futures_daily / 2016-03-04
file: by_date/futures_daily/2016/2016-03-04.parquet size: 10 KB rows: 111
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-03-04 | ES | Futures | 2126.66 | 2144.28 | 2119.18 | 2130.93 | 2247812.0 |
| 2016-03-04 | NQ | Futures | 5067.89 | 5105.4 | 5038.58 | 5067.3 | 289076.0 |
| 2016-03-04 | YM | Futures | 17515.0 | 17636.1 | 17465.4 | 17557.5 | 166564.0 |
| 2016-03-04 | CL | Futures | 43.55 | 45.66 | 43.22 | 45.13 | 578290.0 |
| 2016-03-04 | GC | Futures | 1624.9 | 1645.6 | 1606.3 | 1632.7 | 361180.0 |
| 2016-03-04 | ZN | Futures | 124.980443 | 125.191025 | 124.514154 | 124.66457 | 46711.0 |
| 2016-03-04 | A6 | Futures | 0.73616 | 0.74638 | 0.73516 | 0.74368 | 116409.0 |
| 2016-03-04 | AD | Futures | 0.76245 | 0.76807 | 0.75887 | 0.76725 | 70249.0 |
| 2016-03-04 | ALI | Futures | 2147.44 | 2152.24 | 2147.44 | 2152.24 | 1.0 |
| 2016-03-04 | B | Futures | 30.85 | 32.44 | 30.66 | 32.25 | 295792.0 |
| 2016-03-04 | B6 | Futures | 1.4912 | 1.4994 | 1.4844 | 1.4957 | 100768.0 |
| 2016-03-04 | BFX | Futures | 3999.7 | 4003.2 | 3999.7 | 4003.2 | 2.0 |
| 2016-03-04 | BR | Futures | 0.17137 | 0.17176 | 0.1676 | 0.16938 | 2183.0 |
| 2016-03-04 | BZ | Futures | 30.47 | 32.13 | 30.36 | 31.92 | 32203.0 |
| 2016-03-04 | C | Futures | 2297.0 | 2337.0 | 2297.0 | 2332.0 | 9989.0 |
| 2016-03-04 | CB | Futures | 256.085 | 258.463 | 255.293 | 255.293 | 5.0 |
| 2016-03-04 | CC | Futures | 2177.0 | 2210.0 | 2169.0 | 2203.0 | 23707.0 |
| 2016-03-04 | CNH | Futures | 7.1458 | 7.1484 | 7.1338 | 7.1364 | 16.0 |
| 2016-03-04 | CSC | Futures | 3.568 | 3.568 | 3.561 | 3.565 | 31.0 |
| 2016-03-04 | CT | Futures | 64.8 | 65.69 | 64.58 | 65.59 | 11436.0 |
| 2016-03-04 | DC | Futures | 28.36 | 28.4 | 28.13 | 28.16 | 67.0 |
| 2016-03-04 | DX | Futures | 91.215 | 91.593 | 90.636 | 90.933 | 33764.0 |
| 2016-03-04 | E1 | Futures | 1.27334 | 1.27826 | 1.26425 | 1.26917 | 24210.0 |
| 2016-03-04 | E6 | Futures | 1.28081 | 1.29162 | 1.27514 | 1.2863 | 331761.0 |
| 2016-03-04 | E7 | Futures | 1.2738 | 1.2843 | 1.2681 | 1.2791 | 5415.0 |
| 2016-03-04 | EBM | Futures | 204.11 | 206.23 | 198.11 | 198.81 | 5953.0 |
| 2016-03-04 | ED | Futures | 95.6313 | 95.6337 | 95.6241 | 95.6265 | 250681.0 |
| 2016-03-04 | ER | Futures | 98.308 | 98.313 | 98.288 | 98.293 | 142967.0 |
| 2016-03-04 | EW | Futures | 1466.8 | 1482.1 | 1463.5 | 1474.8 | 23189.0 |
| 2016-03-04 | FBON | Futures | 117.63 | 117.69 | 117.38 | 117.54 | 745.0 |
| 2016-03-04 | FBTP | Futures | 106.36 | 106.61 | 106.03 | 106.1 | 249990.0 |
| 2016-03-04 | FBTS | Futures | 101.095 | 101.113 | 101.042 | 101.051 | 44985.0 |
| 2016-03-04 | FCE | Futures | 3688.4 | 3731.3 | 3674.3 | 3710.5 | 82026.0 |
| 2016-03-04 | FDAX | Futures | 10605.1 | 10735.3 | 10559.6 | 10646.9 | 103124.0 |
| 2016-03-04 | FDXM | Futures | 10144.2 | 10264.5 | 10097.6 | 10179.5 | 21067.0 |
| 2016-03-04 | FESX | Futures | 2298.5 | 2323.6 | 2288.7 | 2306.9 | 1520094.0 |
| 2016-03-04 | FEU3 | Futures | 98.956 | 98.956 | 98.952 | 98.952 | 10.0 |
| 2016-03-04 | FGBL | Futures | 146.07 | 146.09 | 145.22 | 145.32 | 1087700.0 |
| 2016-03-04 | FGBM | Futures | 127.96 | 127.96 | 127.58 | 127.66 | 944086.0 |
| 2016-03-04 | FGBS | Futures | 111.857 | 111.867 | 111.768 | 111.797 | 688743.0 |
| 2016-03-04 | FGBX | Futures | 170.73 | 170.75 | 168.9 | 169.08 | 78330.0 |
| 2016-03-04 | FMWO | Futures | 5427.4 | 5453.5 | 5427.4 | 5451.0 | 1102.0 |
| 2016-03-04 | FOAT | Futures | 132.52 | 132.57 | 131.94 | 131.98 | 197036.0 |
| 2016-03-04 | FTDX | Futures | 1583.7 | 1604.8 | 1580.3 | 1587.0 | 187.0 |
| 2016-03-04 | FTI | Futures | 386.08 | 390.24 | 384.93 | 387.72 | 36018.0 |
| 2016-03-04 | FTUK | Futures | 5010.2 | 5064.0 | 5006.1 | 5041.6 | 123144.0 |
| 2016-03-04 | FVSA | Futures | 2969.52 | 2992.9 | 2864.3 | 2893.52 | 26171.0 |
| 2016-03-04 | FXXP | Futures | 268.1 | 270.5 | 266.8 | 268.8 | 31495.0 |
| 2016-03-04 | G | Futures | 108.33 | 108.45 | 107.77 | 107.88 | 188041.0 |
| 2016-03-04 | GF | Futures | 309.403 | 312.25 | 308.765 | 311.219 | 1570.0 |
> showing 50 of 111 rows — these rows as CSV