PREVIEW / futures_daily / 2015-12-07
file: by_date/futures_daily/2015/2015-12-07.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 |
|---|---|---|---|---|---|---|---|
| 2015-12-07 | ES | Futures | 2225.63 | 2229.09 | 2196.12 | 2213.67 | 1699318.0 |
| 2015-12-07 | NQ | Futures | 5520.13 | 5530.36 | 5460.79 | 5496.45 | 224657.0 |
| 2015-12-07 | YM | Futures | 18416.2 | 18436.8 | 18186.1 | 18320.2 | 148528.0 |
| 2015-12-07 | CL | Futures | 61.93 | 62.01 | 57.92 | 58.15 | 635413.0 |
| 2015-12-07 | GC | Futures | 1400.0 | 1400.7 | 1373.5 | 1386.7 | 109372.0 |
| 2015-12-07 | ZN | Futures | 121.176998 | 121.715829 | 121.117128 | 121.596088 | 30109.0 |
| 2015-12-07 | A6 | Futures | 0.73344 | 0.73384 | 0.72553 | 0.72623 | 77149.0 |
| 2015-12-07 | AD | Futures | 0.76585 | 0.76605 | 0.75724 | 0.75786 | 82852.0 |
| 2015-12-07 | ALI | Futures | 2143.06 | 2143.06 | 2143.06 | 2143.06 | 0.0 |
| 2015-12-07 | B | Futures | 38.1 | 38.15 | 35.82 | 35.9 | 205298.0 |
| 2015-12-07 | B6 | Futures | 1.5909 | 1.5917 | 1.5842 | 1.5861 | 70786.0 |
| 2015-12-07 | BFX | Futures | 4442.2 | 4451.9 | 4442.2 | 4451.9 | 2.0 |
| 2015-12-07 | BR | Futures | 0.16365 | 0.16365 | 0.16183 | 0.16271 | 44.0 |
| 2015-12-07 | BZ | Futures | 37.73 | 37.77 | 35.49 | 35.58 | 22813.0 |
| 2015-12-07 | C | Futures | 2441.0 | 2454.0 | 2438.0 | 2450.0 | 1776.0 |
| 2015-12-07 | CB | Futures | 252.309 | 252.309 | 251.999 | 251.999 | 17.0 |
| 2015-12-07 | CC | Futures | 2493.0 | 2528.0 | 2488.0 | 2519.0 | 14749.0 |
| 2015-12-07 | CNH | Futures | 7.1619 | 7.1947 | 7.1619 | 7.1856 | 55.0 |
| 2015-12-07 | CSC | Futures | 3.993 | 3.993 | 3.976 | 3.983 | 77.0 |
| 2015-12-07 | CT | Futures | 75.87 | 75.88 | 75.05 | 75.64 | 17411.0 |
| 2015-12-07 | DC | Futures | 32.01 | 32.03 | 31.86 | 31.99 | 120.0 |
| 2015-12-07 | DX | Futures | 91.964 | 92.502 | 91.908 | 92.281 | 29004.0 |
| 2015-12-07 | E1 | Futures | 1.27237 | 1.27339 | 1.26463 | 1.26933 | 29931.0 |
| 2015-12-07 | E6 | Futures | 1.27394 | 1.27558 | 1.2648 | 1.27066 | 226990.0 |
| 2015-12-07 | E7 | Futures | 1.2671 | 1.2684 | 1.2578 | 1.2636 | 3089.0 |
| 2015-12-07 | EBM | Futures | 252.84 | 255.31 | 252.49 | 253.19 | 13989.0 |
| 2015-12-07 | ED | Futures | 95.627 | 95.6294 | 95.615 | 95.6198 | 219620.0 |
| 2015-12-07 | ER | Futures | 98.2 | 98.205 | 98.195 | 98.205 | 53421.0 |
| 2015-12-07 | EW | Futures | 1530.1 | 1532.4 | 1504.1 | 1515.1 | 17540.0 |
| 2015-12-07 | FBON | Futures | 115.46 | 116.34 | 115.46 | 116.25 | 1011.0 |
| 2015-12-07 | FBTP | Futures | 104.26 | 104.93 | 104.13 | 104.79 | 115265.0 |
| 2015-12-07 | FBTS | Futures | 100.588 | 100.713 | 100.579 | 100.686 | 19946.0 |
| 2015-12-07 | FCE | Futures | 3984.6 | 4014.7 | 3954.1 | 3974.2 | 90844.0 |
| 2015-12-07 | FDAX | Futures | 11979.6 | 12109.0 | 11900.3 | 11970.2 | 95973.0 |
| 2015-12-07 | FDXM | Futures | 11195.5 | 11312.8 | 11118.3 | 11183.2 | 14737.0 |
| 2015-12-07 | FESX | Futures | 2526.4 | 2545.2 | 2507.7 | 2513.7 | 1109170.0 |
| 2015-12-07 | FGBL | Futures | 138.56 | 139.86 | 138.49 | 139.71 | 847352.0 |
| 2015-12-07 | FGBM | Futures | 125.22 | 125.67 | 125.21 | 125.61 | 642094.0 |
| 2015-12-07 | FGBS | Futures | 111.343 | 111.413 | 111.343 | 111.388 | 405165.0 |
| 2015-12-07 | FGBX | Futures | 154.25 | 157.25 | 154.17 | 156.92 | 58178.0 |
| 2015-12-07 | FMWO | Futures | 5680.5 | 5695.3 | 5627.4 | 5627.4 | 562.0 |
| 2015-12-07 | FOAT | Futures | 127.14 | 128.37 | 127.14 | 128.25 | 108292.0 |
| 2015-12-07 | FTDX | Futures | 1754.3 | 1794.2 | 1754.3 | 1770.5 | 251.0 |
| 2015-12-07 | FTI | Futures | 392.39 | 394.73 | 388.13 | 389.61 | 34249.0 |
| 2015-12-07 | FTUK | Futures | 5054.1 | 5056.6 | 4992.2 | 4998.3 | 86206.0 |
| 2015-12-07 | FVSA | Futures | 2082.28 | 2105.94 | 2006.56 | 2077.55 | 10434.0 |
| 2015-12-07 | FXXP | Futures | 291.9 | 293.5 | 289.6 | 289.9 | 21368.0 |
| 2015-12-07 | G | Futures | 104.16 | 105.05 | 104.03 | 104.87 | 202354.0 |
| 2015-12-07 | GF | Futures | 303.922 | 305.9 | 299.096 | 301.991 | 5706.0 |
| 2015-12-07 | GSCI | Futures | 515.98 | 515.98 | 505.29 | 505.45 | 1583.0 |
> showing 50 of 109 rows — these rows as CSV