PREVIEW / futures_daily / 2015-05-21
file: by_date/futures_daily/2015/2015-05-21.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-05-21 | ES | Futures | 2229.89 | 2241.72 | 2223.84 | 2237.51 | 794479.0 |
| 2015-05-21 | NQ | Futures | 5224.65 | 5267.02 | 5208.97 | 5258.03 | 123530.0 |
| 2015-05-21 | YM | Futures | 18662.1 | 18711.2 | 18613.0 | 18675.4 | 75211.0 |
| 2015-05-21 | CL | Futures | 98.83 | 102.41 | 98.63 | 102.04 | 329765.0 |
| 2015-05-21 | GC | Futures | 1582.5 | 1586.4 | 1571.2 | 1575.5 | 139665.0 |
| 2015-05-21 | ZN | Futures | 120.547344 | 120.991349 | 120.458543 | 120.976549 | 1331658.0 |
| 2015-05-21 | A6 | Futures | 0.77538 | 0.77952 | 0.77489 | 0.77755 | 50513.0 |
| 2015-05-21 | AD | Futures | 0.83599 | 0.83864 | 0.83364 | 0.8363 | 35828.0 |
| 2015-05-21 | ALI | Futures | 2412.46 | 2412.46 | 2412.46 | 2412.46 | 0.0 |
| 2015-05-21 | B | Futures | 61.77 | 63.66 | 61.71 | 63.34 | 250909.0 |
| 2015-05-21 | B6 | Futures | 1.6346 | 1.6522 | 1.6337 | 1.6494 | 105941.0 |
| 2015-05-21 | BFX | Futures | 4518.9 | 4536.4 | 4518.9 | 4536.4 | 3.0 |
| 2015-05-21 | BR | Futures | 0.18865 | 0.18865 | 0.18682 | 0.18745 | 543.0 |
| 2015-05-21 | BZ | Futures | 61.27 | 63.03 | 61.26 | 62.73 | 22573.0 |
| 2015-05-21 | C | Futures | 2253.0 | 2274.0 | 2250.0 | 2265.0 | 8212.0 |
| 2015-05-21 | CB | Futures | 160.818 | 161.829 | 160.818 | 160.818 | 5.0 |
| 2015-05-21 | CC | Futures | 2319.0 | 2347.0 | 2317.0 | 2333.0 | 16683.0 |
| 2015-05-21 | CNH | Futures | 6.9778 | 6.9778 | 6.9694 | 6.9694 | 14.0 |
| 2015-05-21 | CSC | Futures | 4.487 | 4.535 | 4.471 | 4.519 | 91.0 |
| 2015-05-21 | CT | Futures | 80.82 | 81.79 | 80.14 | 80.28 | 19482.0 |
| 2015-05-21 | DC | Futures | 37.02 | 37.4 | 36.86 | 37.27 | 334.0 |
| 2015-05-21 | DX | Futures | 89.798 | 89.911 | 89.249 | 89.511 | 39457.0 |
| 2015-05-21 | E1 | Futures | 1.36183 | 1.37037 | 1.35941 | 1.36336 | 14831.0 |
| 2015-05-21 | E6 | Futures | 1.30469 | 1.31528 | 1.30316 | 1.30928 | 241783.0 |
| 2015-05-21 | E7 | Futures | 1.2968 | 1.3077 | 1.2956 | 1.3017 | 6810.0 |
| 2015-05-21 | EBM | Futures | 297.17 | 303.32 | 297.17 | 303.32 | 19734.0 |
| 2015-05-21 | ED | Futures | 95.5621 | 95.5645 | 95.5573 | 95.5621 | 108498.0 |
| 2015-05-21 | ER | Futures | 98.077 | 98.082 | 98.073 | 98.082 | 43655.0 |
| 2015-05-21 | EW | Futures | 1611.9 | 1619.0 | 1607.8 | 1614.8 | 8743.0 |
| 2015-05-21 | FBTP | Futures | 99.59 | 99.87 | 99.22 | 99.49 | 86351.0 |
| 2015-05-21 | FBTS | Futures | 99.83 | 99.839 | 99.786 | 99.794 | 17202.0 |
| 2015-05-21 | FCE | Futures | 4232.1 | 4257.8 | 4213.4 | 4248.7 | 62208.0 |
| 2015-05-21 | FDAX | Futures | 13148.8 | 13205.4 | 13053.9 | 13173.7 | 70749.0 |
| 2015-05-21 | FDIV | Futures | 161.16 | 161.9 | 160.93 | 161.9 | 31.0 |
| 2015-05-21 | FESX | Futures | 2697.6 | 2714.6 | 2685.1 | 2707.2 | 643794.0 |
| 2015-05-21 | FEU3 | Futures | 98.72 | 98.724 | 98.72 | 98.724 | 202.0 |
| 2015-05-21 | FGBL | Futures | 136.53 | 136.81 | 135.93 | 136.46 | 858331.0 |
| 2015-05-21 | FGBM | Futures | 123.9 | 124.01 | 123.85 | 123.93 | 512450.0 |
| 2015-05-21 | FGBS | Futures | 111.213 | 111.228 | 111.208 | 111.213 | 215819.0 |
| 2015-05-21 | FGBX | Futures | 159.63 | 160.24 | 157.27 | 159.05 | 44747.0 |
| 2015-05-21 | FMWO | Futures | 5976.5 | 5997.5 | 5976.5 | 5997.5 | 52.0 |
| 2015-05-21 | FOAT | Futures | 125.56 | 125.8 | 125.0 | 125.47 | 125783.0 |
| 2015-05-21 | FTDX | Futures | 1627.4 | 1632.5 | 1622.7 | 1632.5 | 245.0 |
| 2015-05-21 | FTI | Futures | 436.9 | 437.77 | 434.94 | 437.16 | 17837.0 |
| 2015-05-21 | FTUK | Futures | 5505.1 | 5532.3 | 5502.7 | 5523.2 | 57444.0 |
| 2015-05-21 | FVSA | Futures | 1561.61 | 1604.13 | 1546.15 | 1550.01 | 9338.0 |
| 2015-05-21 | FXXP | Futures | 311.0 | 312.9 | 310.0 | 312.7 | 5607.0 |
| 2015-05-21 | G | Futures | 101.92 | 102.05 | 101.53 | 101.84 | 188428.0 |
| 2015-05-21 | GF | Futures | 369.962 | 371.365 | 368.942 | 370.174 | 3696.0 |
| 2015-05-21 | GSCI | Futures | 759.52 | 763.0 | 759.52 | 762.41 | 67.0 |
> showing 50 of 108 rows — these rows as CSV