PREVIEW / futures_daily / 2014-02-27
file: by_date/futures_daily/2014/2014-02-27.parquet size: 9 KB rows: 105
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-02-27 | ES | Futures | 1900.64 | 1913.01 | 1889.3 | 1911.21 | 1615828.0 |
| 2014-02-27 | NQ | Futures | 4230.84 | 4261.31 | 4209.0 | 4255.27 | 264249.0 |
| 2014-02-27 | YM | Futures | 16166.5 | 16262.3 | 16076.6 | 16246.3 | 161929.0 |
| 2014-02-27 | CL | Futures | 182.52 | 183.43 | 181.06 | 182.22 | 196494.0 |
| 2014-02-27 | GC | Futures | 1752.5 | 1761.6 | 1745.3 | 1755.6 | 120165.0 |
| 2014-02-27 | ZN | Futures | 115.507236 | 115.750469 | 115.421389 | 115.664622 | 1414793.0 |
| 2014-02-27 | A6 | Futures | 0.85292 | 0.85406 | 0.84758 | 0.8532 | 103994.0 |
| 2014-02-27 | AD | Futures | 0.90944 | 0.91045 | 0.90691 | 0.90823 | 44642.0 |
| 2014-02-27 | B | Futures | 112.04 | 112.12 | 111.29 | 111.66 | 128580.0 |
| 2014-02-27 | B6 | Futures | 1.7505 | 1.754 | 1.7454 | 1.7526 | 85049.0 |
| 2014-02-27 | BR | Futures | 0.2218 | 0.2218 | 0.22154 | 0.22154 | 2674.0 |
| 2014-02-27 | BZ | Futures | 114.29 | 114.33 | 113.52 | 113.9 | 8095.0 |
| 2014-02-27 | C | Futures | 1913.0 | 1928.0 | 1905.0 | 1926.0 | 5237.0 |
| 2014-02-27 | CB | Futures | 89.227 | 90.75 | 89.227 | 90.737 | 9.0 |
| 2014-02-27 | CC | Futures | 2173.0 | 2195.0 | 2167.0 | 2194.0 | 7814.0 |
| 2014-02-27 | CNH | Futures | 7.0338 | 7.0341 | 7.021 | 7.0251 | 81.0 |
| 2014-02-27 | CSC | Futures | 4.366 | 4.388 | 4.366 | 4.383 | 17.0 |
| 2014-02-27 | CT | Futures | 97.01 | 99.11 | 96.8 | 98.69 | 12914.0 |
| 2014-02-27 | DC | Futures | 34.51 | 34.77 | 34.46 | 34.77 | 54.0 |
| 2014-02-27 | DX | Futures | 76.476 | 76.647 | 76.319 | 76.368 | 19966.0 |
| 2014-02-27 | E1 | Futures | 1.4411 | 1.44726 | 1.43943 | 1.44533 | 33155.0 |
| 2014-02-27 | E6 | Futures | 1.61522 | 1.62041 | 1.6105 | 1.61852 | 196496.0 |
| 2014-02-27 | E7 | Futures | 1.6048 | 1.6098 | 1.6 | 1.608 | 4400.0 |
| 2014-02-27 | EBM | Futures | 277.39 | 281.22 | 276.35 | 280.87 | 11019.0 |
| 2014-02-27 | ED | Futures | 95.3853 | 95.3853 | 95.3829 | 95.3853 | 78048.0 |
| 2014-02-27 | ER | Futures | 97.876 | 97.886 | 97.871 | 97.881 | 65981.0 |
| 2014-02-27 | EW | Futures | 1395.8 | 1402.6 | 1387.2 | 1401.6 | 13714.0 |
| 2014-02-27 | FBTP | Futures | 85.55 | 86.08 | 85.55 | 85.96 | 73427.0 |
| 2014-02-27 | FBTS | Futures | 96.731 | 96.818 | 96.731 | 96.766 | 9379.0 |
| 2014-02-27 | FCE | Futures | 3405.6 | 3417.2 | 3374.2 | 3407.9 | 122102.0 |
| 2014-02-27 | FDAX | Futures | 10709.1 | 10731.3 | 10527.8 | 10649.8 | 130897.0 |
| 2014-02-27 | FESX | Futures | 2213.3 | 2217.5 | 2184.4 | 2209.0 | 1171836.0 |
| 2014-02-27 | FEU3 | Futures | 98.497 | 98.497 | 98.492 | 98.497 | 405.0 |
| 2014-02-27 | FGBL | Futures | 123.08 | 123.67 | 123.03 | 123.45 | 896174.0 |
| 2014-02-27 | FGBM | Futures | 119.55 | 119.83 | 119.52 | 119.7 | 529891.0 |
| 2014-02-27 | FGBS | Futures | 110.648 | 110.683 | 110.648 | 110.653 | 452155.0 |
| 2014-02-27 | FGBX | Futures | 125.79 | 126.77 | 125.66 | 126.3 | 18191.0 |
| 2014-02-27 | FMWO | Futures | 5442.2 | 5488.7 | 5442.2 | 5484.9 | 80.0 |
| 2014-02-27 | FOAT | Futures | 111.78 | 112.3 | 111.66 | 112.14 | 73298.0 |
| 2014-02-27 | FTDX | Futures | 1189.7 | 1189.7 | 1168.1 | 1186.4 | 202.0 |
| 2014-02-27 | FTI | Futures | 340.36 | 341.94 | 337.2 | 340.27 | 34292.0 |
| 2014-02-27 | FTUK | Futures | 5120.2 | 5145.6 | 5075.2 | 5139.9 | 125234.0 |
| 2014-02-27 | FVSA | Futures | 1756.93 | 1851.5 | 1756.93 | 1791.77 | 11446.0 |
| 2014-02-27 | FXXP | Futures | 247.9 | 248.2 | 245.2 | 247.4 | 6842.0 |
| 2014-02-27 | G | Futures | 93.41 | 93.89 | 93.4 | 93.68 | 223344.0 |
| 2014-02-27 | GF | Futures | 278.036 | 278.479 | 276.101 | 277.028 | 2665.0 |
| 2014-02-27 | GSCI | Futures | 1063.95 | 1065.75 | 1060.99 | 1061.98 | 212.0 |
| 2014-02-27 | HE | Futures | 121.979 | 125.633 | 121.949 | 125.421 | 30611.0 |
| 2014-02-27 | HG | Futures | 4.0509 | 4.0724 | 4.0344 | 4.0566 | 49753.0 |
| 2014-02-27 | HH | Futures | 58.781 | 59.316 | 58.012 | 58.807 | 400.0 |
> showing 50 of 105 rows — these rows as CSV