PREVIEW / futures_daily / 2015-04-21
file: by_date/futures_daily/2015/2015-04-21.parquet size: 9 KB rows: 106
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-04-21 | ES | Futures | 2197.03 | 2213.59 | 2194.67 | 2198.61 | 1052404.0 |
| 2015-04-21 | NQ | Futures | 5111.74 | 5158.18 | 5111.74 | 5141.63 | 190749.0 |
| 2015-04-21 | YM | Futures | 18333.7 | 18485.1 | 18256.0 | 18291.8 | 130186.0 |
| 2015-04-21 | CL | Futures | 98.38 | 98.57 | 95.28 | 96.12 | 354244.0 |
| 2015-04-21 | GC | Futures | 1564.7 | 1575.0 | 1560.4 | 1574.2 | 104705.0 |
| 2015-04-21 | ZN | Futures | 122.693368 | 122.87097 | 122.486166 | 122.530566 | 707522.0 |
| 2015-04-21 | A6 | Futures | 0.7594 | 0.76236 | 0.75536 | 0.75763 | 76349.0 |
| 2015-04-21 | AD | Futures | 0.83456 | 0.83538 | 0.82915 | 0.83027 | 60704.0 |
| 2015-04-21 | ALI | Futures | 2528.69 | 2528.69 | 2528.69 | 2528.69 | 0.0 |
| 2015-04-21 | B | Futures | 61.29 | 61.29 | 59.48 | 59.9 | 218306.0 |
| 2015-04-21 | B6 | Futures | 1.5679 | 1.5754 | 1.5632 | 1.5702 | 57178.0 |
| 2015-04-21 | BFX | Futures | 4611.7 | 4636.1 | 4572.8 | 4587.4 | 49.0 |
| 2015-04-21 | BR | Futures | 0.18614 | 0.18628 | 0.1854 | 0.18568 | 5.0 |
| 2015-04-21 | BZ | Futures | 60.6 | 60.7 | 58.97 | 59.38 | 16815.0 |
| 2015-04-21 | C | Futures | 2083.0 | 2092.0 | 2072.0 | 2078.0 | 3193.0 |
| 2015-04-21 | CB | Futures | 152.929 | 154.547 | 152.929 | 154.142 | 16.0 |
| 2015-04-21 | CC | Futures | 2048.0 | 2057.0 | 2032.0 | 2047.0 | 15562.0 |
| 2015-04-21 | CNH | Futures | 7.0013 | 7.0013 | 6.997 | 6.997 | 1.0 |
| 2015-04-21 | CSC | Futures | 4.492 | 4.636 | 4.487 | 4.506 | 139.0 |
| 2015-04-21 | CT | Futures | 80.88 | 80.89 | 80.12 | 80.28 | 2789.0 |
| 2015-04-21 | DC | Futures | 36.91 | 38.08 | 36.73 | 36.93 | 908.0 |
| 2015-04-21 | DX | Futures | 92.094 | 92.672 | 91.855 | 92.212 | 38929.0 |
| 2015-04-21 | E1 | Futures | 1.33533 | 1.34374 | 1.32692 | 1.33698 | 20381.0 |
| 2015-04-21 | E6 | Futures | 1.26365 | 1.26871 | 1.25436 | 1.26318 | 212133.0 |
| 2015-04-21 | E7 | Futures | 1.2568 | 1.2614 | 1.2472 | 1.2559 | 5148.0 |
| 2015-04-21 | EBM | Futures | 293.65 | 294.46 | 292.85 | 293.25 | 16455.0 |
| 2015-04-21 | ED | Futures | 95.5429 | 95.5525 | 95.5381 | 95.5477 | 166730.0 |
| 2015-04-21 | ER | Futures | 98.068 | 98.073 | 98.058 | 98.068 | 86545.0 |
| 2015-04-21 | EW | Futures | 1597.8 | 1609.6 | 1597.8 | 1599.0 | 11377.0 |
| 2015-04-21 | FBTP | Futures | 102.3 | 102.42 | 101.92 | 102.1 | 99440.0 |
| 2015-04-21 | FBTS | Futures | 99.581 | 99.635 | 99.564 | 99.59 | 21672.0 |
| 2015-04-21 | FCE | Futures | 4220.0 | 4269.3 | 4209.7 | 4227.8 | 97604.0 |
| 2015-04-21 | FDAX | Futures | 13252.5 | 13439.5 | 13247.5 | 13295.2 | 122177.0 |
| 2015-04-21 | FESX | Futures | 2693.2 | 2721.9 | 2684.4 | 2696.2 | 1042291.0 |
| 2015-04-21 | FGBL | Futures | 142.47 | 142.54 | 141.99 | 142.15 | 507052.0 |
| 2015-04-21 | FGBM | Futures | 125.04 | 125.09 | 124.94 | 125.01 | 284447.0 |
| 2015-04-21 | FGBS | Futures | 111.288 | 111.308 | 111.278 | 111.293 | 171609.0 |
| 2015-04-21 | FGBX | Futures | 182.54 | 182.69 | 180.67 | 181.09 | 28918.0 |
| 2015-04-21 | FMWO | Futures | 5892.7 | 5892.7 | 5869.3 | 5884.1 | 50.0 |
| 2015-04-21 | FOAT | Futures | 130.94 | 131.11 | 130.72 | 130.81 | 60678.0 |
| 2015-04-21 | FTDX | Futures | 1554.6 | 1590.3 | 1554.6 | 1564.5 | 204.0 |
| 2015-04-21 | FTI | Futures | 432.06 | 437.24 | 432.01 | 434.54 | 34978.0 |
| 2015-04-21 | FTUK | Futures | 5521.7 | 5564.2 | 5503.9 | 5534.7 | 78698.0 |
| 2015-04-21 | FVSA | Futures | 1677.75 | 1760.85 | 1673.8 | 1733.15 | 14363.0 |
| 2015-04-21 | FXXP | Futures | 309.8 | 312.9 | 309.5 | 310.8 | 23063.0 |
| 2015-04-21 | G | Futures | 105.15 | 105.33 | 104.93 | 105.13 | 154185.0 |
| 2015-04-21 | GF | Futures | 351.52 | 356.117 | 351.52 | 355.687 | 2884.0 |
| 2015-04-21 | GSCI | Futures | 732.89 | 733.57 | 722.68 | 724.46 | 166.0 |
| 2015-04-21 | HE | Futures | 80.822 | 82.991 | 80.822 | 82.817 | 467.0 |
| 2015-04-21 | HG | Futures | 3.4191 | 3.4354 | 3.3789 | 3.3946 | 25292.0 |
> showing 50 of 106 rows — these rows as CSV