PREVIEW / futures_daily / 2014-10-07
file: by_date/futures_daily/2014/2014-10-07.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 |
|---|---|---|---|---|---|---|---|
| 2014-10-07 | ES | Futures | 2040.34 | 2043.47 | 2010.04 | 2013.96 | 2166031.0 |
| 2014-10-07 | NQ | Futures | 4637.64 | 4647.78 | 4575.64 | 4585.2 | 383802.0 |
| 2014-10-07 | YM | Futures | 17126.2 | 17149.5 | 16860.4 | 16892.8 | 206162.0 |
| 2014-10-07 | CL | Futures | 170.38 | 170.61 | 166.48 | 167.37 | 300113.0 |
| 2014-10-07 | GC | Futures | 1584.2 | 1592.5 | 1577.9 | 1590.2 | 142509.0 |
| 2014-10-07 | ZN | Futures | 117.572912 | 118.202584 | 117.485051 | 118.085436 | 1568816.0 |
| 2014-10-07 | A6 | Futures | 0.84721 | 0.85421 | 0.84371 | 0.85188 | 137785.0 |
| 2014-10-07 | AD | Futures | 0.91072 | 0.91093 | 0.90564 | 0.90768 | 73066.0 |
| 2014-10-07 | ALI | Futures | 2911.32 | 2942.24 | 2911.32 | 2942.24 | 20.0 |
| 2014-10-07 | B | Futures | 96.91 | 97.04 | 95.43 | 96.09 | 250827.0 |
| 2014-10-07 | B6 | Futures | 1.6895 | 1.6943 | 1.6836 | 1.691 | 99286.0 |
| 2014-10-07 | BFX | Futures | 3806.3 | 3806.9 | 3769.8 | 3771.5 | 137.0 |
| 2014-10-07 | BR | Futures | 0.21976 | 0.22252 | 0.21966 | 0.22149 | 2880.0 |
| 2014-10-07 | BZ | Futures | 97.68 | 97.75 | 96.14 | 96.8 | 19406.0 |
| 2014-10-07 | C | Futures | 2139.0 | 2141.0 | 2110.0 | 2115.0 | 9137.0 |
| 2014-10-07 | CB | Futures | 141.051 | 143.152 | 140.473 | 140.839 | 34.0 |
| 2014-10-07 | CC | Futures | 2272.0 | 2278.0 | 2248.0 | 2252.0 | 14349.0 |
| 2014-10-07 | CNH | Futures | 7.0806 | 7.0806 | 7.0789 | 7.0789 | 1.0 |
| 2014-10-07 | CSC | Futures | 5.182 | 5.182 | 5.066 | 5.082 | 13.0 |
| 2014-10-07 | CT | Futures | 81.68 | 82.73 | 81.38 | 82.63 | 14254.0 |
| 2014-10-07 | DC | Futures | 41.22 | 41.76 | 40.7 | 40.99 | 135.0 |
| 2014-10-07 | DX | Futures | 81.571 | 81.851 | 81.3 | 81.427 | 42700.0 |
| 2014-10-07 | E1 | Futures | 1.3353 | 1.33875 | 1.32929 | 1.33658 | 52101.0 |
| 2014-10-07 | E6 | Futures | 1.49046 | 1.49352 | 1.48198 | 1.4914 | 284945.0 |
| 2014-10-07 | E7 | Futures | 1.481 | 1.484 | 1.4725 | 1.482 | 3551.0 |
| 2014-10-07 | ED | Futures | 95.4422 | 95.4422 | 95.4374 | 95.4374 | 87172.0 |
| 2014-10-07 | ER | Futures | 98.004 | 98.014 | 98.004 | 98.009 | 22003.0 |
| 2014-10-07 | EW | Futures | 1410.2 | 1412.2 | 1390.0 | 1393.2 | 23440.0 |
| 2014-10-07 | FBTP | Futures | 95.3 | 95.44 | 95.07 | 95.26 | 76027.0 |
| 2014-10-07 | FBTS | Futures | 98.668 | 98.694 | 98.615 | 98.632 | 16014.0 |
| 2014-10-07 | FCE | Futures | 3401.0 | 3405.3 | 3321.7 | 3352.4 | 124768.0 |
| 2014-10-07 | FDAX | Futures | 10045.3 | 10058.4 | 9870.0 | 9953.2 | 149691.0 |
| 2014-10-07 | FESX | Futures | 2253.5 | 2256.4 | 2201.4 | 2224.5 | 1297621.0 |
| 2014-10-07 | FEU3 | Futures | 98.626 | 98.631 | 98.626 | 98.631 | 55.0 |
| 2014-10-07 | FGBL | Futures | 132.29 | 132.45 | 131.99 | 132.24 | 841263.0 |
| 2014-10-07 | FGBM | Futures | 122.97 | 123.0 | 122.87 | 122.94 | 407390.0 |
| 2014-10-07 | FGBS | Futures | 110.943 | 110.953 | 110.923 | 110.933 | 175265.0 |
| 2014-10-07 | FGBX | Futures | 143.51 | 143.76 | 142.51 | 143.09 | 28249.0 |
| 2014-10-07 | FMWO | Futures | 5569.6 | 5572.1 | 5533.2 | 5535.7 | 309.0 |
| 2014-10-07 | FOAT | Futures | 121.89 | 121.97 | 121.52 | 121.75 | 67771.0 |
| 2014-10-07 | FTDX | Futures | 1157.3 | 1158.2 | 1122.8 | 1137.0 | 323.0 |
| 2014-10-07 | FTI | Futures | 354.82 | 355.25 | 348.13 | 351.15 | 39423.0 |
| 2014-10-07 | FTUK | Futures | 5046.3 | 5056.7 | 4965.5 | 5007.2 | 121216.0 |
| 2014-10-07 | FVSA | Futures | 1522.33 | 1611.64 | 1522.33 | 1611.64 | 9689.0 |
| 2014-10-07 | FXXP | Futures | 253.5 | 253.5 | 248.4 | 250.3 | 15224.0 |
| 2014-10-07 | G | Futures | 97.69 | 98.25 | 97.6 | 98.12 | 277794.0 |
| 2014-10-07 | GF | Futures | 374.391 | 377.347 | 374.158 | 375.675 | 1835.0 |
| 2014-10-07 | GSCI | Futures | 958.78 | 958.78 | 954.15 | 956.01 | 1298.0 |
| 2014-10-07 | HE | Futures | 129.341 | 130.956 | 126.38 | 126.986 | 18840.0 |
| 2014-10-07 | HG | Futures | 3.8579 | 3.8604 | 3.8274 | 3.8547 | 32817.0 |
> showing 50 of 106 rows — these rows as CSV