PREVIEW / futures_daily / 2015-09-03
file: by_date/futures_daily/2015/2015-09-03.parquet size: 9 KB rows: 108
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-09-03 | ES | Futures | 2063.99 | 2091.55 | 2058.17 | 2062.4 | 2054305.0 |
| 2015-09-03 | NQ | Futures | 4973.92 | 5025.29 | 4926.64 | 4938.02 | 332566.0 |
| 2015-09-03 | YM | Futures | 16772.3 | 16982.8 | 16738.4 | 16789.7 | 217955.0 |
| 2015-09-03 | CL | Futures | 75.21 | 78.97 | 74.46 | 76.25 | 539450.0 |
| 2015-09-03 | GC | Futures | 1462.8 | 1463.6 | 1447.1 | 1451.6 | 106471.0 |
| 2015-09-03 | ZN | Futures | 121.852769 | 122.210458 | 121.837865 | 122.046517 | 72459.0 |
| 2015-09-03 | A6 | Futures | 0.69691 | 0.69939 | 0.69236 | 0.69434 | 77712.0 |
| 2015-09-03 | AD | Futures | 0.77066 | 0.77864 | 0.76933 | 0.77485 | 84363.0 |
| 2015-09-03 | ALI | Futures | 2218.63 | 2218.63 | 2218.63 | 2218.63 | 0.0 |
| 2015-09-03 | B | Futures | 46.49 | 48.27 | 45.91 | 46.7 | 157986.0 |
| 2015-09-03 | B6 | Futures | 1.6106 | 1.6117 | 1.6017 | 1.6057 | 95037.0 |
| 2015-09-03 | BFX | Futures | 4153.6 | 4194.1 | 4153.6 | 4179.0 | 10.0 |
| 2015-09-03 | BR | Futures | 0.15946 | 0.15961 | 0.157 | 0.15961 | 124.0 |
| 2015-09-03 | BZ | Futures | 46.34 | 48.25 | 45.92 | 46.7 | 19573.0 |
| 2015-09-03 | C | Futures | 2241.0 | 2256.0 | 2235.0 | 2241.0 | 6386.0 |
| 2015-09-03 | CB | Futures | 186.465 | 187.474 | 186.465 | 187.474 | 11.0 |
| 2015-09-03 | CC | Futures | 2282.0 | 2301.0 | 2273.0 | 2283.0 | 14176.0 |
| 2015-09-03 | CNH | Futures | 7.2503 | 7.2582 | 7.2486 | 7.2524 | 52.0 |
| 2015-09-03 | CSC | Futures | 4.478 | 4.488 | 4.478 | 4.488 | 12.0 |
| 2015-09-03 | CT | Futures | 76.97 | 77.44 | 76.97 | 77.24 | 5.0 |
| 2015-09-03 | DC | Futures | 35.52 | 35.77 | 35.45 | 35.68 | 20.0 |
| 2015-09-03 | DX | Futures | 89.874 | 90.459 | 89.687 | 90.26 | 56012.0 |
| 2015-09-03 | E1 | Futures | 1.31081 | 1.3117 | 1.29964 | 1.30434 | 18219.0 |
| 2015-09-03 | E6 | Futures | 1.31881 | 1.32104 | 1.3026 | 1.30601 | 303145.0 |
| 2015-09-03 | E7 | Futures | 1.3114 | 1.3138 | 1.2954 | 1.2988 | 7036.0 |
| 2015-09-03 | EBM | Futures | 249.62 | 250.03 | 239.37 | 240.6 | 3558.0 |
| 2015-09-03 | ED | Futures | 95.6462 | 95.6558 | 95.6414 | 95.6486 | 155560.0 |
| 2015-09-03 | ER | Futures | 98.126 | 98.131 | 98.126 | 98.126 | 34492.0 |
| 2015-09-03 | EW | Futures | 1466.9 | 1483.3 | 1463.6 | 1467.5 | 17973.0 |
| 2015-09-03 | FBTP | Futures | 99.98 | 100.66 | 99.79 | 100.46 | 188536.0 |
| 2015-09-03 | FBTS | Futures | 100.017 | 100.151 | 100.008 | 100.115 | 54555.0 |
| 2015-09-03 | FCE | Futures | 3844.2 | 3930.1 | 3837.5 | 3896.2 | 128936.0 |
| 2015-09-03 | FDAX | Futures | 11193.8 | 11475.7 | 11177.8 | 11414.4 | 115842.0 |
| 2015-09-03 | FDIV | Futures | 139.18 | 139.18 | 138.49 | 138.49 | 1.0 |
| 2015-09-03 | FESX | Futures | 2386.0 | 2440.0 | 2381.6 | 2421.5 | 1401525.0 |
| 2015-09-03 | FEU3 | Futures | 98.774 | 98.774 | 98.774 | 98.774 | 2.0 |
| 2015-09-03 | FGBL | Futures | 136.65 | 137.47 | 136.55 | 137.27 | 1195014.0 |
| 2015-09-03 | FGBM | Futures | 124.45 | 124.81 | 124.45 | 124.76 | 815289.0 |
| 2015-09-03 | FGBS | Futures | 111.188 | 111.268 | 111.183 | 111.248 | 778242.0 |
| 2015-09-03 | FGBX | Futures | 154.42 | 156.58 | 154.26 | 155.11 | 92872.0 |
| 2015-09-03 | FMWO | Futures | 5386.8 | 5429.8 | 5385.5 | 5418.8 | 1492.0 |
| 2015-09-03 | FOAT | Futures | 124.5 | 125.33 | 124.4 | 125.18 | 203569.0 |
| 2015-09-03 | FTDX | Futures | 1596.7 | 1625.4 | 1596.2 | 1619.7 | 461.0 |
| 2015-09-03 | FTI | Futures | 376.13 | 385.34 | 374.84 | 382.28 | 46008.0 |
| 2015-09-03 | FTUK | Futures | 4868.8 | 4936.8 | 4857.3 | 4921.7 | 110863.0 |
| 2015-09-03 | FVSA | Futures | 2565.64 | 2595.52 | 2407.69 | 2446.11 | 21991.0 |
| 2015-09-03 | FXXP | Futures | 274.0 | 279.9 | 274.0 | 278.5 | 21352.0 |
| 2015-09-03 | G | Futures | 103.79 | 104.17 | 103.72 | 103.97 | 148202.0 |
| 2015-09-03 | GF | Futures | 346.381 | 351.036 | 346.381 | 349.226 | 1221.0 |
| 2015-09-03 | GSCI | Futures | 606.95 | 619.23 | 604.14 | 609.42 | 537.0 |
> showing 50 of 108 rows — these rows as CSV