PREVIEW / futures_daily / 2014-04-30
file: by_date/futures_daily/2014/2014-04-30.parquet size: 9 KB rows: 105
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-30 | ES | Futures | 1935.29 | 1945.38 | 1930.89 | 1943.05 | 1502102.0 |
| 2014-04-30 | NQ | Futures | 4094.77 | 4118.65 | 4073.76 | 4113.19 | 288746.0 |
| 2014-04-30 | YM | Futures | 16527.5 | 16593.8 | 16499.4 | 16578.7 | 134484.0 |
| 2014-04-30 | CL | Futures | 182.5 | 182.5 | 179.95 | 180.66 | 282979.0 |
| 2014-04-30 | GC | Futures | 1707.1 | 1710.8 | 1693.0 | 1707.5 | 139271.0 |
| 2014-04-30 | ZN | Futures | 114.982681 | 115.388314 | 114.794351 | 115.35934 | 1531195.0 |
| 2014-04-30 | A6 | Futures | 0.88742 | 0.89068 | 0.88597 | 0.8903 | 69689.0 |
| 2014-04-30 | AD | Futures | 0.92515 | 0.92556 | 0.92242 | 0.92536 | 46235.0 |
| 2014-04-30 | B | Futures | 112.08 | 112.08 | 110.78 | 111.31 | 97921.0 |
| 2014-04-30 | B6 | Futures | 1.7678 | 1.7757 | 1.7654 | 1.7742 | 84051.0 |
| 2014-04-30 | BFX | Futures | 3717.0 | 3718.0 | 3706.1 | 3706.1 | 83.0 |
| 2014-04-30 | BR | Futures | 0.23339 | 0.23423 | 0.23268 | 0.23415 | 659.0 |
| 2014-04-30 | BZ | Futures | 114.1 | 114.1 | 112.99 | 113.53 | 6046.0 |
| 2014-04-30 | C | Futures | 1924.0 | 1939.0 | 1913.0 | 1924.0 | 11098.0 |
| 2014-04-30 | CB | Futures | 97.985 | 100.015 | 97.985 | 100.015 | 19.0 |
| 2014-04-30 | CC | Futures | 2176.0 | 2225.0 | 2170.0 | 2197.0 | 16402.0 |
| 2014-04-30 | CNH | Futures | 7.1907 | 7.1958 | 7.1757 | 7.1757 | 22.0 |
| 2014-04-30 | CSC | Futures | 4.533 | 4.549 | 4.509 | 4.549 | 26.0 |
| 2014-04-30 | CT | Futures | 105.85 | 106.5 | 105.63 | 106.17 | 11896.0 |
| 2014-04-30 | DC | Futures | 36.21 | 37.07 | 36.19 | 36.76 | 525.0 |
| 2014-04-30 | DX | Futures | 75.874 | 76.021 | 75.537 | 75.558 | 21867.0 |
| 2014-04-30 | E1 | Futures | 1.45265 | 1.46112 | 1.45021 | 1.45907 | 37221.0 |
| 2014-04-30 | E6 | Futures | 1.63033 | 1.63824 | 1.62537 | 1.63741 | 227572.0 |
| 2014-04-30 | E7 | Futures | 1.6197 | 1.6273 | 1.6148 | 1.6265 | 4616.0 |
| 2014-04-30 | EBM | Futures | 302.62 | 303.68 | 301.92 | 303.33 | 8379.0 |
| 2014-04-30 | ED | Futures | 95.4091 | 95.4186 | 95.4091 | 95.4091 | 88672.0 |
| 2014-04-30 | ER | Futures | 97.852 | 97.852 | 97.837 | 97.847 | 122050.0 |
| 2014-04-30 | EW | Futures | 1387.6 | 1398.0 | 1380.5 | 1396.3 | 19261.0 |
| 2014-04-30 | FBTP | Futures | 88.7 | 89.01 | 88.56 | 88.91 | 54673.0 |
| 2014-04-30 | FBTS | Futures | 97.443 | 97.495 | 97.39 | 97.469 | 9055.0 |
| 2014-04-30 | FCE | Futures | 3515.5 | 3529.4 | 3509.5 | 3524.6 | 84966.0 |
| 2014-04-30 | FDAX | Futures | 10585.9 | 10643.9 | 10571.0 | 10620.2 | 86375.0 |
| 2014-04-30 | FDIV | Futures | 144.24 | 144.34 | 144.24 | 144.29 | 18.0 |
| 2014-04-30 | FESX | Futures | 2254.9 | 2267.1 | 2251.3 | 2259.2 | 726567.0 |
| 2014-04-30 | FGBL | Futures | 124.54 | 124.89 | 124.26 | 124.73 | 774996.0 |
| 2014-04-30 | FGBM | Futures | 120.0 | 120.08 | 119.83 | 120.03 | 464323.0 |
| 2014-04-30 | FGBS | Futures | 110.568 | 110.583 | 110.523 | 110.563 | 327331.0 |
| 2014-04-30 | FGBX | Futures | 128.66 | 129.39 | 128.02 | 129.25 | 26898.0 |
| 2014-04-30 | FMWO | Futures | 5567.0 | 5579.7 | 5567.0 | 5579.7 | 180.0 |
| 2014-04-30 | FOAT | Futures | 113.71 | 114.11 | 113.57 | 114.07 | 97863.0 |
| 2014-04-30 | FTDX | Futures | 1148.0 | 1153.1 | 1146.6 | 1153.1 | 129.0 |
| 2014-04-30 | FTI | Futures | 339.48 | 343.55 | 339.31 | 342.81 | 28618.0 |
| 2014-04-30 | FTUK | Futures | 5120.2 | 5158.8 | 5114.1 | 5142.7 | 112876.0 |
| 2014-04-30 | FVSA | Futures | 1761.27 | 1775.55 | 1746.99 | 1756.51 | 4972.0 |
| 2014-04-30 | FXXP | Futures | 250.2 | 251.5 | 250.2 | 250.9 | 6105.0 |
| 2014-04-30 | G | Futures | 93.98 | 94.17 | 93.7 | 94.06 | 160301.0 |
| 2014-04-30 | GF | Futures | 287.434 | 288.747 | 286.32 | 288.389 | 2188.0 |
| 2014-04-30 | GSCI | Futures | 1084.39 | 1085.14 | 1077.35 | 1082.9 | 323.0 |
| 2014-04-30 | HE | Futures | 138.435 | 138.814 | 136.801 | 137.268 | 1064.0 |
| 2014-04-30 | HG | Futures | 3.9279 | 3.9349 | 3.8525 | 3.8685 | 51014.0 |
> showing 50 of 105 rows — these rows as CSV