PREVIEW / futures_daily / 2015-06-01
file: by_date/futures_daily/2015/2015-06-01.parquet size: 9 KB rows: 107
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 |
|---|---|---|---|---|---|---|---|
| 2015-06-01 | ES | Futures | 2215.43 | 2226.73 | 2208.33 | 2217.8 | 1338859.0 |
| 2015-06-01 | NQ | Futures | 5240.9 | 5269.06 | 5208.39 | 5249.61 | 216323.0 |
| 2015-06-01 | YM | Futures | 18431.9 | 18518.9 | 18377.7 | 18435.0 | 136304.0 |
| 2015-06-01 | CL | Futures | 101.32 | 101.91 | 99.71 | 101.17 | 292189.0 |
| 2015-06-01 | GC | Futures | 1553.9 | 1573.3 | 1546.3 | 1552.4 | 171248.0 |
| 2015-06-01 | ZN | Futures | 121.376154 | 121.524155 | 120.784147 | 120.828547 | 166148.0 |
| 2015-06-01 | A6 | Futures | 0.75339 | 0.75575 | 0.74865 | 0.74954 | 78158.0 |
| 2015-06-01 | AD | Futures | 0.82026 | 0.82026 | 0.8125 | 0.81495 | 50192.0 |
| 2015-06-01 | ALI | Futures | 2399.44 | 2399.44 | 2399.44 | 2399.44 | 0.0 |
| 2015-06-01 | B | Futures | 62.66 | 62.66 | 61.02 | 61.63 | 133238.0 |
| 2015-06-01 | B6 | Futures | 1.6089 | 1.6109 | 1.5966 | 1.6002 | 89052.0 |
| 2015-06-01 | BFX | Futures | 4482.0 | 4482.0 | 4468.1 | 4469.3 | 4.0 |
| 2015-06-01 | BR | Futures | 0.18096 | 0.18336 | 0.18039 | 0.18246 | 273.0 |
| 2015-06-01 | BZ | Futures | 61.98 | 62.51 | 61.16 | 61.76 | 11435.0 |
| 2015-06-01 | C | Futures | 2277.0 | 2280.0 | 2262.0 | 2263.0 | 7840.0 |
| 2015-06-01 | CB | Futures | 168.578 | 168.781 | 168.578 | 168.578 | 7.0 |
| 2015-06-01 | CC | Futures | 2280.0 | 2280.0 | 2250.0 | 2252.0 | 17849.0 |
| 2015-06-01 | CNH | Futures | 6.9731 | 6.9772 | 6.9696 | 6.9757 | 11.0 |
| 2015-06-01 | CSC | Futures | 4.64 | 4.67 | 4.594 | 4.66 | 41.0 |
| 2015-06-01 | CT | Futures | 81.06 | 82.07 | 80.23 | 80.31 | 19822.0 |
| 2015-06-01 | DC | Futures | 37.99 | 38.37 | 37.79 | 38.27 | 117.0 |
| 2015-06-01 | DX | Futures | 91.071 | 91.794 | 91.057 | 91.524 | 50327.0 |
| 2015-06-01 | E1 | Futures | 1.35546 | 1.35661 | 1.34425 | 1.34807 | 15312.0 |
| 2015-06-01 | E6 | Futures | 1.2914 | 1.29152 | 1.28047 | 1.28588 | 243563.0 |
| 2015-06-01 | E7 | Futures | 1.2828 | 1.2843 | 1.2729 | 1.2784 | 5785.0 |
| 2015-06-01 | EBM | Futures | 288.97 | 296.76 | 288.97 | 296.35 | 10913.0 |
| 2015-06-01 | ED | Futures | 95.5621 | 95.5621 | 95.5597 | 95.5597 | 84967.0 |
| 2015-06-01 | ER | Futures | 98.073 | 98.077 | 98.068 | 98.073 | 36082.0 |
| 2015-06-01 | EW | Futures | 1597.6 | 1606.4 | 1589.6 | 1599.2 | 16725.0 |
| 2015-06-01 | FBTP | Futures | 99.7 | 99.7 | 98.57 | 99.0 | 136033.0 |
| 2015-06-01 | FBTS | Futures | 99.794 | 99.794 | 99.714 | 99.75 | 22475.0 |
| 2015-06-01 | FCE | Futures | 4169.4 | 4189.7 | 4130.3 | 4159.4 | 98855.0 |
| 2015-06-01 | FDAX | Futures | 12757.7 | 12773.8 | 12587.9 | 12692.8 | 98923.0 |
| 2015-06-01 | FESX | Futures | 2644.6 | 2651.9 | 2612.9 | 2630.6 | 929271.0 |
| 2015-06-01 | FEU3 | Futures | 98.715 | 98.715 | 98.715 | 98.715 | 4.0 |
| 2015-06-01 | FGBL | Futures | 138.12 | 138.41 | 137.33 | 137.93 | 866354.0 |
| 2015-06-01 | FGBM | Futures | 124.27 | 124.36 | 124.01 | 124.23 | 803017.0 |
| 2015-06-01 | FGBS | Futures | 111.203 | 111.223 | 111.168 | 111.203 | 337514.0 |
| 2015-06-01 | FGBX | Futures | 163.9 | 165.19 | 161.94 | 163.53 | 53250.0 |
| 2015-06-01 | FMWO | Futures | 5918.6 | 5918.6 | 5870.5 | 5873.0 | 152.0 |
| 2015-06-01 | FOAT | Futures | 126.74 | 126.93 | 126.0 | 126.49 | 85787.0 |
| 2015-06-01 | FTDX | Futures | 1590.8 | 1605.8 | 1587.0 | 1592.7 | 243.0 |
| 2015-06-01 | FTI | Futures | 433.46 | 435.24 | 428.14 | 428.92 | 33618.0 |
| 2015-06-01 | FTUK | Futures | 5527.6 | 5541.8 | 5460.6 | 5464.1 | 107194.0 |
| 2015-06-01 | FVSA | Futures | 1696.9 | 1766.47 | 1677.57 | 1751.01 | 15058.0 |
| 2015-06-01 | FXXP | Futures | 307.9 | 309.5 | 306.1 | 306.8 | 8769.0 |
| 2015-06-01 | G | Futures | 103.04 | 103.12 | 102.6 | 102.78 | 136177.0 |
| 2015-06-01 | GF | Futures | 378.633 | 380.886 | 378.335 | 380.078 | 2730.0 |
| 2015-06-01 | GSCI | Futures | 743.89 | 748.64 | 740.66 | 745.93 | 388.0 |
| 2015-06-01 | HE | Futures | 91.042 | 91.912 | 90.498 | 91.749 | 12493.0 |
> showing 50 of 107 rows — these rows as CSV