PREVIEW / futures_daily / 2015-12-03
file: by_date/futures_daily/2015/2015-12-03.parquet size: 9 KB rows: 110
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-12-03 | ES | Futures | 2216.06 | 2228.83 | 2170.05 | 2182.02 | 2655148.0 |
| 2015-12-03 | NQ | Futures | 5493.82 | 5530.65 | 5353.81 | 5391.22 | 379530.0 |
| 2015-12-03 | YM | Futures | 18333.7 | 18437.9 | 17962.2 | 18041.7 | 244078.0 |
| 2015-12-03 | CL | Futures | 62.01 | 64.53 | 61.89 | 63.45 | 496884.0 |
| 2015-12-03 | GC | Futures | 1358.7 | 1372.9 | 1348.2 | 1368.6 | 173771.0 |
| 2015-12-03 | ZN | Futures | 121.880471 | 121.940341 | 120.68307 | 120.877648 | 86929.0 |
| 2015-12-03 | A6 | Futures | 0.72983 | 0.73664 | 0.72823 | 0.73474 | 118136.0 |
| 2015-12-03 | AD | Futures | 0.76697 | 0.77045 | 0.76431 | 0.76779 | 82050.0 |
| 2015-12-03 | ALI | Futures | 2134.56 | 2134.56 | 2134.56 | 2134.56 | 0.0 |
| 2015-12-03 | B | Futures | 37.9 | 39.47 | 37.72 | 38.72 | 160262.0 |
| 2015-12-03 | B6 | Futures | 1.5738 | 1.5964 | 1.5693 | 1.5955 | 156266.0 |
| 2015-12-03 | BFX | Futures | 4442.8 | 4442.8 | 4428.2 | 4428.2 | 4.0 |
| 2015-12-03 | BR | Futures | 0.15994 | 0.16343 | 0.15994 | 0.1634 | 111.0 |
| 2015-12-03 | BZ | Futures | 37.48 | 39.09 | 37.43 | 38.38 | 18739.0 |
| 2015-12-03 | C | Futures | 2420.0 | 2431.0 | 2412.0 | 2430.0 | 8691.0 |
| 2015-12-03 | CB | Futures | 247.052 | 247.361 | 244.299 | 245.815 | 30.0 |
| 2015-12-03 | CC | Futures | 2461.0 | 2498.0 | 2454.0 | 2496.0 | 20307.0 |
| 2015-12-03 | CNH | Futures | 7.1725 | 7.1725 | 7.1385 | 7.1385 | 77.0 |
| 2015-12-03 | CSC | Futures | 4.005 | 4.01 | 3.998 | 4.003 | 104.0 |
| 2015-12-03 | CT | Futures | 74.27 | 75.32 | 73.97 | 74.91 | 20363.0 |
| 2015-12-03 | DC | Futures | 32.14 | 32.14 | 32.06 | 32.1 | 128.0 |
| 2015-12-03 | DX | Futures | 93.61 | 94.087 | 91.272 | 91.313 | 125217.0 |
| 2015-12-03 | E1 | Futures | 1.24573 | 1.28493 | 1.23546 | 1.28366 | 64036.0 |
| 2015-12-03 | E6 | Futures | 1.24278 | 1.2867 | 1.22884 | 1.28553 | 750906.0 |
| 2015-12-03 | E7 | Futures | 1.236 | 1.2796 | 1.2244 | 1.2784 | 16885.0 |
| 2015-12-03 | EBM | Futures | 257.96 | 259.05 | 252.84 | 254.3 | 12456.0 |
| 2015-12-03 | ED | Futures | 95.6487 | 95.6511 | 95.6319 | 95.6415 | 268504.0 |
| 2015-12-03 | ER | Futures | 98.264 | 98.283 | 98.19 | 98.195 | 356556.0 |
| 2015-12-03 | EW | Futures | 1537.9 | 1546.9 | 1502.4 | 1508.2 | 26862.0 |
| 2015-12-03 | FBON | Futures | 117.63 | 117.93 | 115.25 | 115.58 | 1229.0 |
| 2015-12-03 | FBTP | Futures | 106.27 | 106.57 | 103.95 | 104.35 | 288167.0 |
| 2015-12-03 | FBTS | Futures | 100.91 | 100.91 | 100.481 | 100.57 | 60144.0 |
| 2015-12-03 | FCE | Futures | 4085.8 | 4158.5 | 3894.8 | 3952.0 | 235248.0 |
| 2015-12-03 | FDAX | Futures | 12280.2 | 12471.3 | 11719.7 | 11924.5 | 200673.0 |
| 2015-12-03 | FDXM | Futures | 11471.3 | 11650.3 | 10949.6 | 11141.0 | 32387.0 |
| 2015-12-03 | FESX | Futures | 2588.7 | 2650.9 | 2468.0 | 2513.7 | 2601077.0 |
| 2015-12-03 | FEU3 | Futures | 98.922 | 98.927 | 98.843 | 98.843 | 4.0 |
| 2015-12-03 | FGBL | Futures | 140.86 | 141.15 | 138.08 | 138.91 | 1546177.0 |
| 2015-12-03 | FGBM | Futures | 126.3 | 126.47 | 125.08 | 125.39 | 1232766.0 |
| 2015-12-03 | FGBS | Futures | 111.633 | 111.718 | 111.333 | 111.363 | 904040.0 |
| 2015-12-03 | FGBX | Futures | 158.24 | 159.63 | 153.84 | 155.29 | 83959.0 |
| 2015-12-03 | FMWO | Futures | 5699.1 | 5700.3 | 5647.1 | 5665.7 | 828.0 |
| 2015-12-03 | FOAT | Futures | 129.43 | 129.7 | 126.95 | 127.45 | 210400.0 |
| 2015-12-03 | FTDX | Futures | 1779.5 | 1795.6 | 1724.9 | 1746.7 | 512.0 |
| 2015-12-03 | FTI | Futures | 404.16 | 409.93 | 384.61 | 390.91 | 80510.0 |
| 2015-12-03 | FTUK | Futures | 5144.2 | 5184.0 | 4984.6 | 5059.4 | 186363.0 |
| 2015-12-03 | FVSA | Futures | 2053.89 | 2238.45 | 1954.5 | 2068.08 | 20235.0 |
| 2015-12-03 | FXXP | Futures | 298.3 | 303.3 | 286.0 | 290.3 | 35221.0 |
| 2015-12-03 | G | Futures | 105.41 | 105.48 | 104.24 | 104.46 | 213737.0 |
| 2015-12-03 | GF | Futures | 307.01 | 310.919 | 302.619 | 308.361 | 6996.0 |
> showing 50 of 110 rows — these rows as CSV