PREVIEW / futures_daily / 2016-03-15
file: by_date/futures_daily/2016/2016-03-15.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-03-15 | ES | Futures | 2157.37 | 2158.17 | 2142.07 | 2154.41 | 1910850.0 |
| 2016-03-15 | NQ | Futures | 5118.04 | 5128.61 | 5087.19 | 5118.62 | 226022.0 |
| 2016-03-15 | YM | Futures | 17808.9 | 17842.2 | 17699.7 | 17829.7 | 103915.0 |
| 2016-03-15 | CL | Futures | 47.35 | 47.44 | 45.78 | 46.22 | 246022.0 |
| 2016-03-15 | GC | Futures | 1589.4 | 1591.6 | 1575.3 | 1581.7 | 185326.0 |
| 2016-03-15 | ZN | Futures | 124.001191 | 124.37837 | 123.880494 | 123.986104 | 919809.0 |
| 2016-03-15 | A6 | Futures | 0.75705 | 0.75887 | 0.75047 | 0.75087 | 80524.0 |
| 2016-03-15 | AD | Futures | 0.77094 | 0.77104 | 0.76296 | 0.76593 | 56055.0 |
| 2016-03-15 | ALI | Futures | 2092.44 | 2092.44 | 2092.44 | 2092.44 | 0.0 |
| 2016-03-15 | B | Futures | 33.04 | 33.1 | 31.91 | 32.26 | 224361.0 |
| 2016-03-15 | B6 | Futures | 1.5063 | 1.5067 | 1.4891 | 1.491 | 73318.0 |
| 2016-03-15 | BFX | Futures | 4011.4 | 4011.4 | 3996.8 | 4004.4 | 58.0 |
| 2016-03-15 | BR | Futures | 0.17143 | 0.17143 | 0.16932 | 0.16932 | 1836.0 |
| 2016-03-15 | BZ | Futures | 32.76 | 32.79 | 31.59 | 31.94 | 24741.0 |
| 2016-03-15 | C | Futures | 2381.0 | 2393.0 | 2379.0 | 2382.0 | 9024.0 |
| 2016-03-15 | CB | Futures | 245.72 | 245.72 | 243.891 | 245.11 | 74.0 |
| 2016-03-15 | CC | Futures | 2247.0 | 2252.0 | 2233.0 | 2236.0 | 9805.0 |
| 2016-03-15 | CNH | Futures | 7.1005 | 7.1152 | 7.1005 | 7.1152 | 41.0 |
| 2016-03-15 | CSC | Futures | 3.522 | 3.537 | 3.501 | 3.501 | 59.0 |
| 2016-03-15 | CT | Futures | 66.96 | 67.18 | 66.61 | 66.89 | 13940.0 |
| 2016-03-15 | DC | Futures | 27.62 | 27.72 | 27.45 | 27.45 | 81.0 |
| 2016-03-15 | DX | Futures | 90.108 | 90.346 | 89.959 | 90.125 | 12477.0 |
| 2016-03-15 | E1 | Futures | 1.2772 | 1.28059 | 1.27469 | 1.27783 | 10705.0 |
| 2016-03-15 | E6 | Futures | 1.29849 | 1.301 | 1.29482 | 1.29902 | 132907.0 |
| 2016-03-15 | E7 | Futures | 1.2914 | 1.2939 | 1.2877 | 1.292 | 2567.0 |
| 2016-03-15 | EBM | Futures | 201.38 | 202.67 | 200.42 | 202.35 | 21846.0 |
| 2016-03-15 | ED | Futures | 95.61 | 95.6196 | 95.5955 | 95.6003 | 312358.0 |
| 2016-03-15 | ER | Futures | 98.244 | 98.244 | 98.234 | 98.239 | 70086.0 |
| 2016-03-15 | EW | Futures | 1477.4 | 1477.8 | 1461.5 | 1465.4 | 30585.0 |
| 2016-03-15 | FBON | Futures | 118.14 | 118.14 | 117.58 | 117.59 | 354.0 |
| 2016-03-15 | FBTP | Futures | 107.16 | 107.43 | 106.67 | 106.73 | 90121.0 |
| 2016-03-15 | FBTS | Futures | 101.042 | 101.051 | 100.952 | 100.961 | 27996.0 |
| 2016-03-15 | FCE | Futures | 3737.2 | 3737.2 | 3698.8 | 3718.8 | 136978.0 |
| 2016-03-15 | FDAX | Futures | 10793.8 | 10817.7 | 10723.3 | 10778.6 | 151959.0 |
| 2016-03-15 | FDXM | Futures | 10334.4 | 10348.9 | 10266.1 | 10318.9 | 3149.0 |
| 2016-03-15 | FESX | Futures | 2340.8 | 2343.1 | 2319.7 | 2331.4 | 1857041.0 |
| 2016-03-15 | FEU3 | Futures | 98.897 | 98.897 | 98.892 | 98.892 | 1500.0 |
| 2016-03-15 | FGBL | Futures | 144.39 | 144.7 | 144.02 | 144.15 | 581601.0 |
| 2016-03-15 | FGBM | Futures | 127.01 | 127.06 | 126.88 | 126.91 | 464641.0 |
| 2016-03-15 | FGBS | Futures | 111.583 | 111.598 | 111.563 | 111.568 | 196547.0 |
| 2016-03-15 | FGBX | Futures | 167.66 | 168.69 | 166.44 | 166.82 | 29046.0 |
| 2016-03-15 | FMWO | Futures | 5461.0 | 5471.0 | 5461.0 | 5471.0 | 1324.0 |
| 2016-03-15 | FOAT | Futures | 131.98 | 132.31 | 131.59 | 131.76 | 73618.0 |
| 2016-03-15 | FTDX | Futures | 1559.9 | 1560.4 | 1552.8 | 1553.3 | 959.0 |
| 2016-03-15 | FTI | Futures | 391.63 | 392.25 | 389.18 | 391.23 | 22098.0 |
| 2016-03-15 | FTUK | Futures | 5030.8 | 5030.8 | 4987.9 | 5011.8 | 287398.0 |
| 2016-03-15 | FVSA | Futures | 2804.86 | 2876.64 | 2788.29 | 2821.42 | 18567.0 |
| 2016-03-15 | FXXP | Futures | 270.0 | 270.0 | 267.5 | 268.1 | 212291.0 |
| 2016-03-15 | G | Futures | 107.43 | 107.95 | 107.38 | 107.57 | 185470.0 |
| 2016-03-15 | GF | Futures | 319.514 | 323.931 | 318.385 | 323.539 | 3673.0 |
> showing 50 of 109 rows — these rows as CSV