PREVIEW / futures_daily / 2014-12-12
file: by_date/futures_daily/2014/2014-12-12.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-12-12 | ES | Futures | 2119.99 | 2122.86 | 2085.52 | 2086.3 | 1487564.0 |
| 2014-12-12 | NQ | Futures | 4905.95 | 4931.15 | 4853.79 | 4855.53 | 245579.0 |
| 2014-12-12 | YM | Futures | 17815.2 | 17830.5 | 17504.6 | 17508.6 | 202476.0 |
| 2014-12-12 | CL | Futures | 114.06 | 114.83 | 110.54 | 111.44 | 414224.0 |
| 2014-12-12 | GC | Futures | 1607.2 | 1608.5 | 1590.1 | 1600.2 | 121177.0 |
| 2014-12-12 | ZN | Futures | 119.584471 | 120.408887 | 119.569749 | 120.173339 | 1525258.0 |
| 2014-12-12 | A6 | Futures | 0.80404 | 0.80757 | 0.80052 | 0.80257 | 76371.0 |
| 2014-12-12 | AD | Futures | 0.88226 | 0.88257 | 0.87676 | 0.8785 | 71395.0 |
| 2014-12-12 | ALI | Futures | 2915.5 | 2915.5 | 2915.5 | 2915.5 | 0.0 |
| 2014-12-12 | B | Futures | 65.49 | 66.07 | 63.72 | 64.22 | 216699.0 |
| 2014-12-12 | B6 | Futures | 1.6526 | 1.6545 | 1.6491 | 1.6504 | 73236.0 |
| 2014-12-12 | BR | Futures | 0.20345 | 0.20466 | 0.20171 | 0.20312 | 49.0 |
| 2014-12-12 | BZ | Futures | 65.99 | 66.62 | 64.31 | 64.79 | 23542.0 |
| 2014-12-12 | C | Futures | 2054.0 | 2069.0 | 2048.0 | 2061.0 | 5295.0 |
| 2014-12-12 | CB | Futures | 136.391 | 137.603 | 135.549 | 136.37 | 87.0 |
| 2014-12-12 | CC | Futures | 2100.0 | 2119.0 | 2098.0 | 2108.0 | 6579.0 |
| 2014-12-12 | CNH | Futures | 7.1098 | 7.1115 | 7.103 | 7.1115 | 5.0 |
| 2014-12-12 | CSC | Futures | 4.66 | 4.688 | 4.577 | 4.586 | 152.0 |
| 2014-12-12 | CT | Futures | 77.24 | 78.23 | 77.17 | 77.32 | 10191.0 |
| 2014-12-12 | DC | Futures | 36.63 | 36.96 | 35.88 | 35.95 | 223.0 |
| 2014-12-12 | DX | Futures | 84.079 | 84.155 | 83.63 | 83.862 | 42834.0 |
| 2014-12-12 | E1 | Futures | 1.31982 | 1.32889 | 1.31778 | 1.32519 | 55083.0 |
| 2014-12-12 | E6 | Futures | 1.45997 | 1.46949 | 1.4575 | 1.46549 | 212364.0 |
| 2014-12-12 | E7 | Futures | 1.4511 | 1.4607 | 1.4488 | 1.4567 | 3642.0 |
| 2014-12-12 | EBM | Futures | 301.3 | 308.19 | 301.3 | 307.79 | 29455.0 |
| 2014-12-12 | ED | Futures | 95.4354 | 95.445 | 95.4306 | 95.4354 | 268319.0 |
| 2014-12-12 | ER | Futures | 97.994 | 98.004 | 97.994 | 97.999 | 46176.0 |
| 2014-12-12 | EW | Futures | 1476.8 | 1479.5 | 1456.7 | 1457.4 | 37882.0 |
| 2014-12-12 | FBTP | Futures | 97.52 | 97.84 | 97.3 | 97.53 | 51390.0 |
| 2014-12-12 | FBTS | Futures | 98.473 | 98.526 | 98.269 | 98.349 | 19204.0 |
| 2014-12-12 | FCE | Futures | 3420.3 | 3426.8 | 3328.9 | 3352.9 | 17109.0 |
| 2014-12-12 | FDAX | Futures | 10702.5 | 10737.0 | 10455.5 | 10504.8 | 163673.0 |
| 2014-12-12 | FESX | Futures | 2250.1 | 2262.4 | 2187.4 | 2203.3 | 462034.0 |
| 2014-12-12 | FGBL | Futures | 135.09 | 135.54 | 135.04 | 135.47 | 555938.0 |
| 2014-12-12 | FGBM | Futures | 123.35 | 123.42 | 123.32 | 123.4 | 254753.0 |
| 2014-12-12 | FGBS | Futures | 110.848 | 110.873 | 110.843 | 110.873 | 125735.0 |
| 2014-12-12 | FGBX | Futures | 152.24 | 153.91 | 152.22 | 153.63 | 28771.0 |
| 2014-12-12 | FMWO | Futures | 5612.2 | 5619.7 | 5588.4 | 5589.6 | 1654.0 |
| 2014-12-12 | FOAT | Futures | 124.68 | 125.03 | 124.61 | 125.01 | 53408.0 |
| 2014-12-12 | FTDX | Futures | 1258.1 | 1259.0 | 1250.1 | 1250.1 | 51.0 |
| 2014-12-12 | FTI | Futures | 356.97 | 358.96 | 351.22 | 351.87 | 1377.0 |
| 2014-12-12 | FTUK | Futures | 4963.9 | 4973.7 | 4804.9 | 4868.8 | 47740.0 |
| 2014-12-12 | FVSA | Futures | 1718.62 | 1846.64 | 1718.62 | 1835.0 | 30559.0 |
| 2014-12-12 | FXXP | Futures | 253.0 | 253.3 | 248.4 | 248.8 | 20288.0 |
| 2014-12-12 | G | Futures | 101.86 | 102.62 | 101.86 | 102.56 | 165681.0 |
| 2014-12-12 | GF | Futures | 365.222 | 365.222 | 361.972 | 361.972 | 4562.0 |
| 2014-12-12 | GSCI | Futures | 768.09 | 768.09 | 761.18 | 761.86 | 852.0 |
| 2014-12-12 | HE | Futures | 112.859 | 113.664 | 111.45 | 111.685 | 12654.0 |
| 2014-12-12 | HG | Futures | 3.6991 | 3.7353 | 3.6946 | 3.727 | 26959.0 |
| 2014-12-12 | HH | Futures | 45.115 | 45.691 | 44.73 | 45.583 | 3035.0 |
> showing 50 of 105 rows — these rows as CSV