PREVIEW / futures_daily / 2016-06-17
file: by_date/futures_daily/2016/2016-06-17.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-06-17 | ES | Futures | 2233.61 | 2240.09 | 2216.87 | 2223.08 | 1833560.0 |
| 2016-06-17 | NQ | Futures | 5204.41 | 5224.74 | 5131.62 | 5138.7 | 250757.0 |
| 2016-06-17 | YM | Futures | 18420.1 | 18473.3 | 18284.3 | 18340.7 | 168089.0 |
| 2016-06-17 | CL | Futures | 54.07 | 56.8 | 53.9 | 56.41 | 417372.0 |
| 2016-06-17 | GC | Futures | 1649.8 | 1675.9 | 1645.2 | 1665.8 | 211622.0 |
| 2016-06-17 | ZN | Futures | 127.65257 | 127.682752 | 127.305483 | 127.350756 | 1170164.0 |
| 2016-06-17 | A6 | Futures | 0.7475 | 0.75137 | 0.74669 | 0.74974 | 77227.0 |
| 2016-06-17 | AD | Futures | 0.78943 | 0.79782 | 0.78933 | 0.79506 | 56108.0 |
| 2016-06-17 | ALI | Futures | 2130.96 | 2132.23 | 2130.96 | 2132.23 | 3.0 |
| 2016-06-17 | B | Futures | 38.32 | 40.04 | 38.3 | 39.85 | 222734.0 |
| 2016-06-17 | B6 | Futures | 1.4986 | 1.5179 | 1.4984 | 1.5139 | 132886.0 |
| 2016-06-17 | BFX | Futures | 3924.3 | 3924.3 | 3923.1 | 3923.1 | 1.0 |
| 2016-06-17 | BZ | Futures | 38.02 | 39.93 | 37.95 | 39.76 | 22172.0 |
| 2016-06-17 | C | Futures | 2402.0 | 2413.0 | 2374.0 | 2391.0 | 4525.0 |
| 2016-06-17 | CB | Futures | 283.674 | 286.604 | 282.502 | 286.604 | 48.0 |
| 2016-06-17 | CC | Futures | 2255.0 | 2264.0 | 2227.0 | 2248.0 | 19512.0 |
| 2016-06-17 | CNH | Futures | 7.1682 | 7.1682 | 7.1617 | 7.1617 | 3.0 |
| 2016-06-17 | CSC | Futures | 3.564 | 3.589 | 3.498 | 3.555 | 93.0 |
| 2016-06-17 | CT | Futures | 71.97 | 74.05 | 71.79 | 73.45 | 8001.0 |
| 2016-06-17 | DC | Futures | 28.49 | 28.83 | 27.99 | 28.55 | 223.0 |
| 2016-06-17 | DX | Futures | 87.881 | 88.114 | 87.579 | 87.742 | 23065.0 |
| 2016-06-17 | E1 | Futures | 1.30384 | 1.31236 | 1.30296 | 1.30973 | 22298.0 |
| 2016-06-17 | E6 | Futures | 1.31175 | 1.31943 | 1.31076 | 1.31635 | 149148.0 |
| 2016-06-17 | E7 | Futures | 1.3048 | 1.3123 | 1.3039 | 1.3093 | 3035.0 |
| 2016-06-17 | EBM | Futures | 196.97 | 197.27 | 195.17 | 196.07 | 10352.0 |
| 2016-06-17 | ED | Futures | 95.7859 | 95.7859 | 95.7763 | 95.7811 | 207189.0 |
| 2016-06-17 | ER | Futures | 98.264 | 98.274 | 98.264 | 98.269 | 66187.0 |
| 2016-06-17 | EW | Futures | 1564.0 | 1569.8 | 1556.7 | 1562.1 | 17782.0 |
| 2016-06-17 | FBON | Futures | 118.76 | 119.12 | 118.73 | 118.95 | 390.0 |
| 2016-06-17 | FBTP | Futures | 106.59 | 106.92 | 106.48 | 106.62 | 98648.0 |
| 2016-06-17 | FBTS | Futures | 100.943 | 101.015 | 100.898 | 100.997 | 43651.0 |
| 2016-06-17 | FCE | Futures | 3651.8 | 3682.7 | 3625.6 | 3646.5 | 119349.0 |
| 2016-06-17 | FDAX | Futures | 10279.0 | 10335.4 | 10178.5 | 10216.8 | 117554.0 |
| 2016-06-17 | FDXM | Futures | 10025.0 | 10073.8 | 9920.3 | 9958.6 | 21699.0 |
| 2016-06-17 | FESX | Futures | 2228.0 | 2243.7 | 2209.2 | 2217.8 | 1657419.0 |
| 2016-06-17 | FEU3 | Futures | 98.922 | 98.922 | 98.922 | 98.922 | 109.0 |
| 2016-06-17 | FGBL | Futures | 148.52 | 148.73 | 148.2 | 148.35 | 604686.0 |
| 2016-06-17 | FGBM | Futures | 128.4 | 128.57 | 128.4 | 128.48 | 594299.0 |
| 2016-06-17 | FGBS | Futures | 111.817 | 111.852 | 111.813 | 111.842 | 255651.0 |
| 2016-06-17 | FGBX | Futures | 184.5 | 184.83 | 182.43 | 182.8 | 44707.0 |
| 2016-06-17 | FMWO | Futures | 5584.3 | 5584.3 | 5550.7 | 5550.7 | 104.0 |
| 2016-06-17 | FOAT | Futures | 135.26 | 135.5 | 135.04 | 135.15 | 80360.0 |
| 2016-06-17 | FTDX | Futures | 1520.9 | 1527.2 | 1513.7 | 1513.7 | 258.0 |
| 2016-06-17 | FTI | Futures | 379.69 | 382.7 | 376.81 | 378.79 | 39417.0 |
| 2016-06-17 | FTUK | Futures | 4890.7 | 5003.8 | 4890.7 | 4965.4 | 155632.0 |
| 2016-06-17 | FVSA | Futures | 3089.56 | 3089.56 | 2912.58 | 2958.09 | 26373.0 |
| 2016-06-17 | FXXP | Futures | 260.8 | 264.5 | 260.1 | 261.0 | 52255.0 |
| 2016-06-17 | G | Futures | 111.47 | 111.78 | 111.26 | 111.53 | 168664.0 |
| 2016-06-17 | GF | Futures | 278.658 | 281.154 | 273.666 | 274.415 | 3891.0 |
| 2016-06-17 | GSCI | Futures | 541.67 | 548.49 | 541.67 | 546.96 | 382.0 |
> showing 50 of 109 rows — these rows as CSV