PREVIEW / futures_daily / 2014-08-15
file: by_date/futures_daily/2014/2014-08-15.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-08-15 | ES | Futures | 2030.07 | 2037.08 | 2012.41 | 2028.25 | 1813411.0 |
| 2014-08-15 | NQ | Futures | 4583.96 | 4608.77 | 4554.25 | 4597.81 | 362617.0 |
| 2014-08-15 | YM | Futures | 16836.9 | 16892.4 | 16685.6 | 16780.4 | 192441.0 |
| 2014-08-15 | CL | Futures | 174.96 | 177.66 | 174.92 | 177.55 | 195325.0 |
| 2014-08-15 | GC | Futures | 1722.7 | 1726.8 | 1696.0 | 1713.3 | 192112.0 |
| 2014-08-15 | ZN | Futures | 117.877911 | 118.607354 | 117.804967 | 118.242632 | 1606013.0 |
| 2014-08-15 | A6 | Futures | 0.89856 | 0.9004 | 0.89682 | 0.89943 | 64449.0 |
| 2014-08-15 | AD | Futures | 0.93063 | 0.93459 | 0.92952 | 0.93175 | 60861.0 |
| 2014-08-15 | ALI | Futures | 2891.35 | 2891.35 | 2891.35 | 2891.35 | 0.0 |
| 2014-08-15 | B | Futures | 107.18 | 108.97 | 107.18 | 108.73 | 199628.0 |
| 2014-08-15 | B6 | Futures | 1.7534 | 1.7554 | 1.7528 | 1.7549 | 74869.0 |
| 2014-08-15 | BR | Futures | 0.23181 | 0.23239 | 0.23057 | 0.23197 | 439.0 |
| 2014-08-15 | BZ | Futures | 108.09 | 109.82 | 108.05 | 109.58 | 12437.0 |
| 2014-08-15 | C | Futures | 2176.0 | 2188.0 | 2175.0 | 2182.0 | 3621.0 |
| 2014-08-15 | CB | Futures | 144.209 | 144.209 | 144.209 | 144.209 | 12.0 |
| 2014-08-15 | CC | Futures | 2388.0 | 2396.0 | 2384.0 | 2394.0 | 7872.0 |
| 2014-08-15 | CNH | Futures | 7.056 | 7.0626 | 7.056 | 7.0582 | 2.0 |
| 2014-08-15 | CSC | Futures | 4.839 | 4.839 | 4.817 | 4.817 | 2.0 |
| 2014-08-15 | CT | Futures | 80.6 | 81.15 | 80.23 | 80.23 | 9.0 |
| 2014-08-15 | DC | Futures | 39.29 | 39.67 | 39.06 | 39.22 | 201.0 |
| 2014-08-15 | DX | Futures | 77.504 | 77.528 | 77.286 | 77.333 | 22826.0 |
| 2014-08-15 | E1 | Futures | 1.41417 | 1.42083 | 1.41353 | 1.42032 | 38928.0 |
| 2014-08-15 | E6 | Futures | 1.57722 | 1.58276 | 1.57639 | 1.58111 | 162190.0 |
| 2014-08-15 | E7 | Futures | 1.5667 | 1.5724 | 1.5662 | 1.5708 | 1952.0 |
| 2014-08-15 | ED | Futures | 95.421 | 95.421 | 95.4162 | 95.4162 | 67314.0 |
| 2014-08-15 | ER | Futures | 97.911 | 97.911 | 97.906 | 97.906 | 12804.0 |
| 2014-08-15 | EW | Futures | 1450.7 | 1457.2 | 1436.9 | 1448.9 | 17285.0 |
| 2014-08-15 | FBTP | Futures | 93.02 | 93.61 | 93.02 | 93.47 | 38582.0 |
| 2014-08-15 | FBTS | Futures | 98.668 | 98.73 | 98.668 | 98.685 | 6511.0 |
| 2014-08-15 | FCE | Futures | 3356.1 | 3390.3 | 3306.3 | 3322.6 | 143824.0 |
| 2014-08-15 | FDAX | Futures | 10181.0 | 10270.8 | 9958.6 | 9993.3 | 134178.0 |
| 2014-08-15 | FESX | Futures | 2202.3 | 2228.9 | 2163.5 | 2175.0 | 1097433.0 |
| 2014-08-15 | FEU3 | Futures | 98.532 | 98.532 | 98.527 | 98.527 | 16.0 |
| 2014-08-15 | FGBL | Futures | 130.33 | 131.04 | 130.31 | 130.79 | 655657.0 |
| 2014-08-15 | FGBM | Futures | 122.24 | 122.4 | 122.18 | 122.33 | 385008.0 |
| 2014-08-15 | FGBS | Futures | 110.823 | 110.843 | 110.818 | 110.838 | 140538.0 |
| 2014-08-15 | FGBX | Futures | 139.57 | 141.67 | 139.55 | 141.06 | 33284.0 |
| 2014-08-15 | FMWO | Futures | 5731.1 | 5736.1 | 5682.0 | 5682.0 | 156.0 |
| 2014-08-15 | FOAT | Futures | 120.31 | 120.94 | 120.31 | 120.78 | 49174.0 |
| 2014-08-15 | FTDX | Futures | 1129.4 | 1131.8 | 1111.6 | 1112.1 | 241.0 |
| 2014-08-15 | FTI | Futures | 341.44 | 344.84 | 339.16 | 340.36 | 41304.0 |
| 2014-08-15 | FTUK | Futures | 5140.4 | 5176.5 | 5115.0 | 5131.9 | 104928.0 |
| 2014-08-15 | FVSA | Futures | 1493.6 | 1549.23 | 1442.24 | 1532.11 | 14278.0 |
| 2014-08-15 | FXXP | Futures | 249.7 | 251.5 | 246.7 | 247.6 | 6328.0 |
| 2014-08-15 | G | Futures | 96.03 | 96.97 | 96.01 | 96.66 | 170855.0 |
| 2014-08-15 | GF | Futures | 330.355 | 334.738 | 330.239 | 333.69 | 1486.0 |
| 2014-08-15 | GSCI | Futures | 1011.58 | 1018.28 | 1009.48 | 1017.45 | 102.0 |
| 2014-08-15 | HE | Futures | 115.697 | 118.205 | 114.004 | 114.79 | 21402.0 |
| 2014-08-15 | HG | Futures | 3.9432 | 3.9746 | 3.9426 | 3.9663 | 36134.0 |
| 2014-08-15 | HH | Futures | 47.82 | 47.935 | 47.782 | 47.935 | 530.0 |
> showing 50 of 104 rows — these rows as CSV