PREVIEW / futures_daily / 2014-08-14
file: by_date/futures_daily/2014/2014-08-14.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-14 | ES | Futures | 2021.5 | 2030.85 | 2017.34 | 2029.29 | 967191.0 |
| 2014-08-14 | NQ | Futures | 4553.39 | 4585.98 | 4545.31 | 4578.19 | 176296.0 |
| 2014-08-14 | YM | Futures | 16775.4 | 16842.0 | 16746.1 | 16831.9 | 88746.0 |
| 2014-08-14 | CL | Futures | 179.66 | 180.08 | 174.81 | 175.24 | 219244.0 |
| 2014-08-14 | GC | Futures | 1722.7 | 1733.7 | 1718.3 | 1725.7 | 103416.0 |
| 2014-08-14 | ZN | Futures | 117.7612 | 118.052977 | 117.659078 | 117.921678 | 1286432.0 |
| 2014-08-14 | A6 | Futures | 0.89702 | 0.89963 | 0.89576 | 0.89856 | 54731.0 |
| 2014-08-14 | AD | Futures | 0.92982 | 0.93226 | 0.92921 | 0.93053 | 33235.0 |
| 2014-08-14 | ALI | Futures | 2891.35 | 2891.35 | 2891.35 | 2891.35 | 0.0 |
| 2014-08-14 | B | Futures | 110.17 | 110.37 | 107.03 | 107.2 | 301854.0 |
| 2014-08-14 | B6 | Futures | 1.7538 | 1.7549 | 1.7507 | 1.7536 | 80980.0 |
| 2014-08-14 | BFX | Futures | 3763.8 | 3766.3 | 3763.8 | 3766.3 | 7.0 |
| 2014-08-14 | BR | Futures | 0.2301 | 0.23157 | 0.2301 | 0.23097 | 196.0 |
| 2014-08-14 | BZ | Futures | 110.72 | 111.23 | 107.89 | 108.04 | 16214.0 |
| 2014-08-14 | C | Futures | 2152.0 | 2180.0 | 2152.0 | 2179.0 | 3946.0 |
| 2014-08-14 | CB | Futures | 141.415 | 141.415 | 141.415 | 141.415 | 2.0 |
| 2014-08-14 | CC | Futures | 2383.0 | 2398.0 | 2376.0 | 2388.0 | 13203.0 |
| 2014-08-14 | CNH | Futures | 7.0677 | 7.0677 | 7.0649 | 7.0649 | 2.0 |
| 2014-08-14 | CSC | Futures | 4.692 | 4.806 | 4.692 | 4.803 | 34.0 |
| 2014-08-14 | CT | Futures | 81.2 | 81.24 | 80.17 | 80.6 | 7.0 |
| 2014-08-14 | DC | Futures | 38.27 | 39.41 | 38.27 | 39.32 | 466.0 |
| 2014-08-14 | DX | Futures | 77.519 | 77.609 | 77.315 | 77.502 | 18883.0 |
| 2014-08-14 | E1 | Futures | 1.41289 | 1.41904 | 1.41122 | 1.41468 | 32278.0 |
| 2014-08-14 | E6 | Futures | 1.57698 | 1.58229 | 1.57521 | 1.57733 | 149068.0 |
| 2014-08-14 | E7 | Futures | 1.5666 | 1.572 | 1.5651 | 1.5671 | 1812.0 |
| 2014-08-14 | ED | Futures | 95.4162 | 95.421 | 95.4162 | 95.4162 | 72977.0 |
| 2014-08-14 | ER | Futures | 97.906 | 97.911 | 97.906 | 97.906 | 14360.0 |
| 2014-08-14 | EW | Futures | 1443.7 | 1452.2 | 1441.8 | 1451.6 | 9806.0 |
| 2014-08-14 | FBTP | Futures | 92.55 | 93.13 | 92.55 | 93.07 | 44309.0 |
| 2014-08-14 | FBTS | Futures | 98.596 | 98.694 | 98.596 | 98.685 | 9603.0 |
| 2014-08-14 | FCE | Futures | 3339.3 | 3360.0 | 3316.7 | 3348.9 | 73717.0 |
| 2014-08-14 | FDAX | Futures | 10143.6 | 10204.7 | 10067.1 | 10163.4 | 96332.0 |
| 2014-08-14 | FESX | Futures | 2198.0 | 2210.2 | 2179.3 | 2200.2 | 841058.0 |
| 2014-08-14 | FGBL | Futures | 130.33 | 130.57 | 130.25 | 130.36 | 719442.0 |
| 2014-08-14 | FGBM | Futures | 122.26 | 122.33 | 122.19 | 122.23 | 347101.0 |
| 2014-08-14 | FGBS | Futures | 110.828 | 110.838 | 110.803 | 110.828 | 214264.0 |
| 2014-08-14 | FGBX | Futures | 139.24 | 140.09 | 139.24 | 139.65 | 24059.0 |
| 2014-08-14 | FMWO | Futures | 5678.3 | 5699.7 | 5678.3 | 5698.4 | 165.0 |
| 2014-08-14 | FOAT | Futures | 120.26 | 120.49 | 120.22 | 120.36 | 52991.0 |
| 2014-08-14 | FTDX | Futures | 1108.8 | 1129.0 | 1107.9 | 1128.0 | 731.0 |
| 2014-08-14 | FTI | Futures | 340.67 | 341.66 | 338.73 | 340.8 | 17712.0 |
| 2014-08-14 | FTUK | Futures | 5109.6 | 5141.9 | 5096.9 | 5130.0 | 82601.0 |
| 2014-08-14 | FVSA | Futures | 1553.51 | 1553.51 | 1493.6 | 1502.15 | 16079.0 |
| 2014-08-14 | FXXP | Futures | 248.2 | 249.7 | 247.6 | 249.3 | 4513.0 |
| 2014-08-14 | G | Futures | 96.16 | 96.4 | 95.93 | 96.07 | 153675.0 |
| 2014-08-14 | GF | Futures | 330.937 | 332.954 | 329.308 | 330.51 | 2610.0 |
| 2014-08-14 | GSCI | Futures | 1025.91 | 1025.91 | 1009.06 | 1009.32 | 582.0 |
| 2014-08-14 | HE | Futures | 116.18 | 116.301 | 114.125 | 115.153 | 24533.0 |
| 2014-08-14 | HG | Futures | 3.9778 | 3.988 | 3.94 | 3.9509 | 43065.0 |
| 2014-08-14 | HH | Futures | 49.585 | 49.585 | 49.585 | 49.585 | 641.0 |
> showing 50 of 104 rows — these rows as CSV