PREVIEW / futures_daily / 2014-07-24
file: by_date/futures_daily/2014/2014-07-24.parquet size: 9 KB rows: 104
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-07-24 | ES | Futures | 2057.86 | 2062.79 | 2053.44 | 2057.6 | 1165644.0 |
| 2014-07-24 | NQ | Futures | 4589.73 | 4605.02 | 4573.0 | 4582.52 | 209687.0 |
| 2014-07-24 | YM | Futures | 17184.0 | 17216.3 | 17117.4 | 17150.7 | 119190.0 |
| 2014-07-24 | CL | Futures | 189.98 | 190.19 | 187.55 | 187.9 | 194404.0 |
| 2014-07-24 | GC | Futures | 1718.5 | 1720.2 | 1696.4 | 1700.7 | 178767.0 |
| 2014-07-24 | ZN | Futures | 117.090113 | 117.148469 | 116.667037 | 116.75457 | 1174382.0 |
| 2014-07-24 | A6 | Futures | 0.90968 | 0.91219 | 0.90649 | 0.90668 | 80960.0 |
| 2014-07-24 | AD | Futures | 0.94556 | 0.94638 | 0.94333 | 0.94384 | 34368.0 |
| 2014-07-24 | ALI | Futures | 2966.49 | 2966.49 | 2962.45 | 2962.45 | 15.0 |
| 2014-07-24 | B | Futures | 113.75 | 113.81 | 112.36 | 112.62 | 179569.0 |
| 2014-07-24 | B6 | Futures | 1.7905 | 1.7921 | 1.7828 | 1.7847 | 102901.0 |
| 2014-07-24 | BFX | Futures | 3871.6 | 3872.5 | 3871.6 | 3872.5 | 1.0 |
| 2014-07-24 | BR | Futures | 0.23526 | 0.23529 | 0.23468 | 0.23503 | 98.0 |
| 2014-07-24 | BZ | Futures | 114.41 | 114.53 | 113.08 | 113.33 | 8726.0 |
| 2014-07-24 | C | Futures | 2093.0 | 2103.0 | 2077.0 | 2089.0 | 8683.0 |
| 2014-07-24 | CB | Futures | 132.471 | 134.707 | 131.354 | 131.912 | 45.0 |
| 2014-07-24 | CC | Futures | 2346.0 | 2376.0 | 2343.0 | 2350.0 | 17484.0 |
| 2014-07-24 | CNH | Futures | 7.1175 | 7.1218 | 7.116 | 7.1198 | 1.0 |
| 2014-07-24 | CSC | Futures | 4.506 | 4.509 | 4.457 | 4.466 | 59.0 |
| 2014-07-24 | CT | Futures | 86.89 | 86.89 | 83.39 | 83.76 | 56.0 |
| 2014-07-24 | DC | Futures | 36.55 | 36.62 | 36.15 | 36.22 | 435.0 |
| 2014-07-24 | DX | Futures | 76.783 | 76.873 | 76.712 | 76.851 | 17425.0 |
| 2014-07-24 | E1 | Futures | 1.42083 | 1.4234 | 1.41878 | 1.42058 | 32971.0 |
| 2014-07-24 | E6 | Futures | 1.58854 | 1.59126 | 1.58571 | 1.58878 | 146497.0 |
| 2014-07-24 | E7 | Futures | 1.5781 | 1.5809 | 1.5755 | 1.5784 | 1795.0 |
| 2014-07-24 | ED | Futures | 95.4162 | 95.4162 | 95.4115 | 95.4162 | 56996.0 |
| 2014-07-24 | ER | Futures | 97.876 | 97.881 | 97.876 | 97.876 | 17971.0 |
| 2014-07-24 | EW | Futures | 1464.0 | 1472.1 | 1460.5 | 1464.4 | 12805.0 |
| 2014-07-24 | FBTP | Futures | 92.33 | 92.47 | 92.19 | 92.3 | 40564.0 |
| 2014-07-24 | FBTS | Futures | 98.41 | 98.445 | 98.383 | 98.419 | 8333.0 |
| 2014-07-24 | FCE | Futures | 3477.7 | 3512.3 | 3457.0 | 3508.3 | 99039.0 |
| 2014-07-24 | FDAX | Futures | 10743.3 | 10813.7 | 10655.7 | 10789.0 | 92137.0 |
| 2014-07-24 | FESX | Futures | 2291.5 | 2318.8 | 2278.6 | 2315.2 | 962851.0 |
| 2014-07-24 | FGBL | Futures | 128.97 | 129.03 | 128.5 | 128.59 | 604109.0 |
| 2014-07-24 | FGBM | Futures | 121.76 | 121.76 | 121.58 | 121.61 | 362641.0 |
| 2014-07-24 | FGBS | Futures | 110.768 | 110.768 | 110.743 | 110.748 | 144295.0 |
| 2014-07-24 | FGBX | Futures | 135.93 | 136.07 | 135.08 | 135.2 | 19433.0 |
| 2014-07-24 | FMWO | Futures | 5809.1 | 5839.3 | 5809.1 | 5839.3 | 76.0 |
| 2014-07-24 | FOAT | Futures | 119.03 | 119.09 | 118.65 | 118.7 | 71727.0 |
| 2014-07-24 | FTDX | Futures | 1185.6 | 1191.7 | 1180.0 | 1188.4 | 156.0 |
| 2014-07-24 | FTI | Futures | 352.43 | 354.38 | 350.26 | 354.07 | 28912.0 |
| 2014-07-24 | FTUK | Futures | 5191.2 | 5215.0 | 5168.1 | 5207.3 | 69979.0 |
| 2014-07-24 | FVSA | Futures | 1383.91 | 1409.38 | 1349.95 | 1379.67 | 6506.0 |
| 2014-07-24 | FXXP | Futures | 257.9 | 259.3 | 256.8 | 259.1 | 5051.0 |
| 2014-07-24 | G | Futures | 94.92 | 94.98 | 94.46 | 94.51 | 137909.0 |
| 2014-07-24 | GF | Futures | 333.416 | 335.792 | 329.393 | 333.071 | 4898.0 |
| 2014-07-24 | GSCI | Futures | 1062.23 | 1063.48 | 1054.95 | 1055.7 | 23.0 |
| 2014-07-24 | HE | Futures | 130.127 | 130.363 | 127.661 | 129.288 | 16805.0 |
| 2014-07-24 | HG | Futures | 4.0979 | 4.1784 | 4.0928 | 4.1752 | 58539.0 |
| 2014-07-24 | HH | Futures | 47.836 | 48.785 | 47.659 | 48.645 | 3166.0 |
> showing 50 of 104 rows — these rows as CSV