PREVIEW / futures_daily / 2014-08-13
file: by_date/futures_daily/2014/2014-08-13.parquet size: 9 KB rows: 103
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-13 | ES | Futures | 2007.21 | 2022.02 | 2005.66 | 2020.2 | 1120054.0 |
| 2014-08-13 | NQ | Futures | 4506.66 | 4556.85 | 4502.33 | 4552.52 | 201984.0 |
| 2014-08-13 | YM | Futures | 16685.6 | 16783.5 | 16667.4 | 16768.3 | 104074.0 |
| 2014-08-13 | CL | Futures | 178.94 | 180.01 | 178.11 | 179.66 | 253703.0 |
| 2014-08-13 | GC | Futures | 1717.7 | 1726.7 | 1713.0 | 1724.2 | 98471.0 |
| 2014-08-13 | ZN | Futures | 117.454834 | 117.848733 | 117.236002 | 117.775789 | 1333778.0 |
| 2014-08-13 | A6 | Futures | 0.89354 | 0.89866 | 0.89325 | 0.89711 | 78327.0 |
| 2014-08-13 | AD | Futures | 0.9288 | 0.93043 | 0.92759 | 0.92952 | 47047.0 |
| 2014-08-13 | ALI | Futures | 2935.75 | 2935.75 | 2935.75 | 2935.75 | 0.0 |
| 2014-08-13 | B | Futures | 108.94 | 110.41 | 108.45 | 110.34 | 312682.0 |
| 2014-08-13 | B6 | Futures | 1.7666 | 1.7705 | 1.7536 | 1.7538 | 161992.0 |
| 2014-08-13 | BFX | Futures | 3746.1 | 3760.0 | 3736.8 | 3760.0 | 83.0 |
| 2014-08-13 | BR | Futures | 0.23036 | 0.23178 | 0.22909 | 0.22973 | 944.0 |
| 2014-08-13 | BZ | Futures | 109.85 | 111.26 | 109.32 | 111.2 | 18153.0 |
| 2014-08-13 | C | Futures | 2131.0 | 2156.0 | 2127.0 | 2153.0 | 4845.0 |
| 2014-08-13 | CB | Futures | 135.825 | 138.62 | 135.825 | 138.62 | 19.0 |
| 2014-08-13 | CC | Futures | 2390.0 | 2391.0 | 2372.0 | 2385.0 | 15967.0 |
| 2014-08-13 | CSC | Futures | 4.678 | 4.685 | 4.667 | 4.685 | 21.0 |
| 2014-08-13 | CT | Futures | 79.83 | 81.57 | 79.83 | 80.76 | 59.0 |
| 2014-08-13 | DC | Futures | 38.06 | 38.28 | 38.01 | 38.21 | 191.0 |
| 2014-08-13 | DX | Futures | 77.433 | 77.585 | 77.281 | 77.511 | 21239.0 |
| 2014-08-13 | E1 | Futures | 1.41263 | 1.41801 | 1.40917 | 1.41327 | 35445.0 |
| 2014-08-13 | E6 | Futures | 1.57757 | 1.58312 | 1.5745 | 1.57757 | 196545.0 |
| 2014-08-13 | E7 | Futures | 1.5673 | 1.5728 | 1.5644 | 1.5673 | 1832.0 |
| 2014-08-13 | ED | Futures | 95.421 | 95.421 | 95.4162 | 95.4162 | 67658.0 |
| 2014-08-13 | ER | Futures | 97.901 | 97.911 | 97.896 | 97.906 | 38918.0 |
| 2014-08-13 | EW | Futures | 1432.7 | 1445.6 | 1432.2 | 1444.1 | 11142.0 |
| 2014-08-13 | FBTP | Futures | 92.39 | 92.8 | 92.28 | 92.55 | 46048.0 |
| 2014-08-13 | FBTS | Futures | 98.614 | 98.659 | 98.561 | 98.623 | 9901.0 |
| 2014-08-13 | FCE | Futures | 3325.0 | 3347.7 | 3324.6 | 3339.7 | 110383.0 |
| 2014-08-13 | FDAX | Futures | 10020.8 | 10149.1 | 10020.8 | 10143.0 | 91961.0 |
| 2014-08-13 | FESX | Futures | 2180.0 | 2203.1 | 2180.0 | 2199.5 | 775673.0 |
| 2014-08-13 | FGBL | Futures | 129.77 | 130.32 | 129.63 | 130.2 | 695009.0 |
| 2014-08-13 | FGBM | Futures | 122.03 | 122.29 | 122.0 | 122.23 | 389078.0 |
| 2014-08-13 | FGBS | Futures | 110.813 | 110.838 | 110.813 | 110.828 | 128222.0 |
| 2014-08-13 | FGBX | Futures | 138.31 | 139.28 | 137.68 | 138.94 | 22402.0 |
| 2014-08-13 | FMWO | Futures | 5685.8 | 5685.8 | 5684.6 | 5684.6 | 32.0 |
| 2014-08-13 | FOAT | Futures | 119.74 | 120.25 | 119.55 | 120.08 | 51482.0 |
| 2014-08-13 | FTDX | Futures | 1112.6 | 1115.4 | 1093.9 | 1109.3 | 255.0 |
| 2014-08-13 | FTI | Futures | 339.76 | 341.31 | 338.94 | 340.24 | 43715.0 |
| 2014-08-13 | FTUK | Futures | 5080.0 | 5116.2 | 5078.5 | 5113.9 | 71909.0 |
| 2014-08-13 | FVSA | Futures | 1574.91 | 1574.91 | 1523.55 | 1527.83 | 3184.0 |
| 2014-08-13 | FXXP | Futures | 248.5 | 248.9 | 247.6 | 248.8 | 5004.0 |
| 2014-08-13 | G | Futures | 95.46 | 96.05 | 95.25 | 95.99 | 179868.0 |
| 2014-08-13 | GF | Futures | 331.596 | 332.643 | 328.338 | 331.286 | 4244.0 |
| 2014-08-13 | GSCI | Futures | 1025.49 | 1029.52 | 1021.05 | 1028.76 | 1667.0 |
| 2014-08-13 | HE | Futures | 116.936 | 118.417 | 116.12 | 117.752 | 20952.0 |
| 2014-08-13 | HG | Futures | 4.0282 | 4.0359 | 3.9746 | 3.9778 | 62877.0 |
| 2014-08-13 | HH | Futures | 49.217 | 49.217 | 48.557 | 48.633 | 800.0 |
| 2014-08-13 | HO | Futures | 2.2764 | 2.3184 | 2.2677 | 2.3171 | 65284.0 |
> showing 50 of 103 rows — these rows as CSV