PREVIEW / futures_daily / 2014-03-06
file: by_date/futures_daily/2014/2014-03-06.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-03-06 | ES | Futures | 1931.57 | 1939.04 | 1928.73 | 1934.14 | 1283006.0 |
| 2014-03-06 | NQ | Futures | 4289.76 | 4296.37 | 4264.18 | 4278.84 | 217906.0 |
| 2014-03-06 | YM | Futures | 16340.2 | 16413.1 | 16318.2 | 16389.1 | 120220.0 |
| 2014-03-06 | CL | Futures | 179.8 | 181.65 | 178.18 | 180.72 | 291849.0 |
| 2014-03-06 | GC | Futures | 1762.4 | 1784.7 | 1754.9 | 1781.9 | 142468.0 |
| 2014-03-06 | ZN | Futures | 115.27831 | 115.321234 | 114.906306 | 115.020769 | 32307.0 |
| 2014-03-06 | A6 | Futures | 0.8553 | 0.86797 | 0.85454 | 0.86626 | 106402.0 |
| 2014-03-06 | AD | Futures | 0.91754 | 0.92412 | 0.91643 | 0.92169 | 74960.0 |
| 2014-03-06 | B | Futures | 110.2 | 111.08 | 109.94 | 110.67 | 155424.0 |
| 2014-03-06 | B6 | Futures | 1.7564 | 1.7625 | 1.7527 | 1.7584 | 111364.0 |
| 2014-03-06 | BR | Futures | 0.22312 | 0.22359 | 0.2219 | 0.22225 | 63.0 |
| 2014-03-06 | BZ | Futures | 112.8 | 113.28 | 112.16 | 112.88 | 9001.0 |
| 2014-03-06 | C | Futures | 1934.0 | 1938.0 | 1926.0 | 1930.0 | 6275.0 |
| 2014-03-06 | CB | Futures | 92.095 | 92.527 | 92.095 | 92.527 | 20.0 |
| 2014-03-06 | CC | Futures | 2203.0 | 2209.0 | 2192.0 | 2198.0 | 8404.0 |
| 2014-03-06 | CNH | Futures | 7.0373 | 7.0373 | 7.0197 | 7.0237 | 49.0 |
| 2014-03-06 | CSC | Futures | 4.287 | 4.337 | 4.287 | 4.337 | 24.0 |
| 2014-03-06 | CT | Futures | 99.59 | 103.1 | 99.41 | 102.97 | 23604.0 |
| 2014-03-06 | DC | Futures | 34.09 | 34.8 | 34.09 | 34.61 | 91.0 |
| 2014-03-06 | DX | Futures | 76.191 | 76.276 | 75.687 | 75.758 | 35468.0 |
| 2014-03-06 | E1 | Futures | 1.44739 | 1.45971 | 1.44392 | 1.45817 | 50323.0 |
| 2014-03-06 | E6 | Futures | 1.62147 | 1.63765 | 1.61852 | 1.63623 | 328406.0 |
| 2014-03-06 | E7 | Futures | 1.6108 | 1.627 | 1.6079 | 1.6256 | 7474.0 |
| 2014-03-06 | EBM | Futures | 289.59 | 290.64 | 287.83 | 290.64 | 17660.0 |
| 2014-03-06 | ED | Futures | 95.3829 | 95.3853 | 95.3829 | 95.3853 | 37096.0 |
| 2014-03-06 | ER | Futures | 97.876 | 97.881 | 97.837 | 97.842 | 184600.0 |
| 2014-03-06 | EW | Futures | 1414.6 | 1420.3 | 1412.7 | 1416.2 | 14008.0 |
| 2014-03-06 | FBTP | Futures | 86.57 | 86.67 | 85.95 | 85.98 | 75033.0 |
| 2014-03-06 | FBTS | Futures | 97.029 | 97.073 | 96.88 | 96.897 | 13816.0 |
| 2014-03-06 | FCE | Futures | 3410.2 | 3433.9 | 3407.1 | 3421.9 | 109034.0 |
| 2014-03-06 | FDAX | Futures | 10611.0 | 10635.4 | 10538.3 | 10581.0 | 84906.0 |
| 2014-03-06 | FESX | Futures | 2211.1 | 2223.1 | 2204.1 | 2211.1 | 886929.0 |
| 2014-03-06 | FEU3 | Futures | 98.492 | 98.492 | 98.458 | 98.458 | 350.0 |
| 2014-03-06 | FGBL | Futures | 123.12 | 123.13 | 122.48 | 122.69 | 822342.0 |
| 2014-03-06 | FGBM | Futures | 119.58 | 119.58 | 119.15 | 119.3 | 633193.0 |
| 2014-03-06 | FGBS | Futures | 110.603 | 110.613 | 110.473 | 110.503 | 486941.0 |
| 2014-03-06 | FGBX | Futures | 125.89 | 125.91 | 124.75 | 125.1 | 24229.0 |
| 2014-03-06 | FMWO | Futures | 5559.1 | 5559.1 | 5559.1 | 5559.1 | 31.0 |
| 2014-03-06 | FOAT | Futures | 111.68 | 111.68 | 111.09 | 111.22 | 109450.0 |
| 2014-03-06 | FTDX | Futures | 1205.6 | 1215.0 | 1205.6 | 1212.7 | 223.0 |
| 2014-03-06 | FTI | Futures | 340.87 | 342.41 | 340.4 | 341.6 | 23677.0 |
| 2014-03-06 | FTUK | Futures | 5115.7 | 5139.9 | 5108.9 | 5120.2 | 78202.0 |
| 2014-03-06 | FVSA | Futures | 1831.59 | 1836.57 | 1796.75 | 1806.71 | 4378.0 |
| 2014-03-06 | FXXP | Futures | 248.1 | 249.0 | 247.6 | 247.7 | 4642.0 |
| 2014-03-06 | G | Futures | 93.23 | 93.23 | 92.69 | 92.83 | 164907.0 |
| 2014-03-06 | GF | Futures | 276.907 | 277.31 | 276.061 | 276.343 | 1044.0 |
| 2014-03-06 | GSCI | Futures | 1062.55 | 1070.92 | 1060.91 | 1068.54 | 155.0 |
| 2014-03-06 | HE | Futures | 134.691 | 136.442 | 134.691 | 135.747 | 22214.0 |
| 2014-03-06 | HG | Futures | 4.0572 | 4.0794 | 4.0477 | 4.0781 | 32413.0 |
| 2014-03-06 | HH | Futures | 59.12 | 61.141 | 58.755 | 60.776 | 162.0 |
> showing 50 of 106 rows — these rows as CSV