PREVIEW / futures_daily / 2013-02-07
file: by_date/futures_daily/2013/2013-02-07.parquet size: 9 KB rows: 102
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-07 | ES | Futures | 1542.21 | 1546.05 | 1529.17 | 1540.17 | 1960681.0 |
| 2013-02-07 | NQ | Futures | 3159.85 | 3170.52 | 3128.99 | 3162.73 | 273081.0 |
| 2013-02-07 | YM | Futures | 13661.6 | 13687.1 | 13534.2 | 13628.3 | 140869.0 |
| 2013-02-07 | CL | Futures | 170.69 | 171.31 | 168.36 | 168.87 | 275474.0 |
| 2013-02-07 | GC | Futures | 2230.4 | 2238.2 | 2210.9 | 2221.5 | 183505.0 |
| 2013-02-07 | ZN | Futures | 116.101051 | 116.362912 | 115.880536 | 116.211308 | 1497021.0 |
| 2013-02-07 | A6 | Futures | 0.94099 | 0.94337 | 0.93742 | 0.93816 | 112642.0 |
| 2013-02-07 | AD | Futures | 1.0062 | 1.00861 | 1.00229 | 1.0038 | 63307.0 |
| 2013-02-07 | B | Futures | 109.75 | 110.62 | 109.55 | 110.05 | 197615.0 |
| 2013-02-07 | B6 | Futures | 1.6367 | 1.6476 | 1.6346 | 1.6415 | 190908.0 |
| 2013-02-07 | BFX | Futures | 3012.2 | 3012.2 | 2997.8 | 2997.8 | 4.0 |
| 2013-02-07 | BR | Futures | 0.24648 | 0.25016 | 0.24648 | 0.24837 | 2548.0 |
| 2013-02-07 | BZ | Futures | 112.45 | 113.35 | 112.31 | 112.79 | 5457.0 |
| 2013-02-07 | C | Futures | 1552.0 | 1578.0 | 1550.0 | 1562.0 | 3414.0 |
| 2013-02-07 | CB | Futures | 84.029 | 84.029 | 83.403 | 83.729 | 9.0 |
| 2013-02-07 | CC | Futures | 1685.0 | 1710.0 | 1678.0 | 1692.0 | 21735.0 |
| 2013-02-07 | CSC | Futures | 3.683 | 3.683 | 3.644 | 3.653 | 80.0 |
| 2013-02-07 | CT | Futures | 102.58 | 103.36 | 101.44 | 102.44 | 27530.0 |
| 2013-02-07 | DC | Futures | 27.58 | 27.71 | 27.36 | 27.49 | 384.0 |
| 2013-02-07 | DX | Futures | 76.967 | 77.488 | 76.75 | 77.403 | 46427.0 |
| 2013-02-07 | E1 | Futures | 1.41483 | 1.42062 | 1.39951 | 1.40299 | 45262.0 |
| 2013-02-07 | E6 | Futures | 1.59491 | 1.60175 | 1.57734 | 1.58123 | 451520.0 |
| 2013-02-07 | E7 | Futures | 1.5843 | 1.5908 | 1.5664 | 1.5704 | 8188.0 |
| 2013-02-07 | EBM | Futures | 273.39 | 274.51 | 271.72 | 272.56 | 15054.0 |
| 2013-02-07 | ED | Futures | 95.2342 | 95.2342 | 95.2295 | 95.2295 | 57360.0 |
| 2013-02-07 | ER | Futures | 97.744 | 97.764 | 97.739 | 97.759 | 196240.0 |
| 2013-02-07 | EW | Futures | 1124.5 | 1126.1 | 1114.8 | 1122.1 | 15426.0 |
| 2013-02-07 | FBTP | Futures | 75.11 | 75.59 | 74.98 | 75.25 | 35282.0 |
| 2013-02-07 | FBTS | Futures | 91.239 | 91.349 | 91.146 | 91.29 | 5174.0 |
| 2013-02-07 | FCE | Futures | 2731.8 | 2746.0 | 2695.0 | 2702.9 | 114989.0 |
| 2013-02-07 | FDAX | Futures | 8278.1 | 8368.8 | 8262.3 | 8289.0 | 138029.0 |
| 2013-02-07 | FESX | Futures | 1785.2 | 1799.5 | 1762.7 | 1770.9 | 1272224.0 |
| 2013-02-07 | FEU3 | Futures | 98.359 | 98.364 | 98.359 | 98.364 | 6.0 |
| 2013-02-07 | FGBL | Futures | 117.82 | 118.21 | 117.49 | 118.05 | 1024089.0 |
| 2013-02-07 | FGBM | Futures | 116.06 | 116.43 | 115.88 | 116.35 | 778799.0 |
| 2013-02-07 | FGBS | Futures | 110.058 | 110.178 | 110.028 | 110.153 | 687213.0 |
| 2013-02-07 | FGBX | Futures | 124.24 | 124.67 | 123.75 | 124.44 | 15402.0 |
| 2013-02-07 | FOAT | Futures | 104.14 | 104.51 | 103.78 | 104.41 | 76918.0 |
| 2013-02-07 | FTDX | Futures | 827.9 | 832.7 | 827.5 | 829.8 | 107.0 |
| 2013-02-07 | FTI | Futures | 297.32 | 298.44 | 294.65 | 295.21 | 33387.0 |
| 2013-02-07 | FTUK | Futures | 4603.5 | 4614.2 | 4541.3 | 4557.9 | 121051.0 |
| 2013-02-07 | FVSA | Futures | 3602.24 | 3738.34 | 3484.28 | 3738.34 | 3591.0 |
| 2013-02-07 | FXXP | Futures | 204.5 | 205.8 | 203.7 | 204.0 | 5827.0 |
| 2013-02-07 | G | Futures | 96.79 | 96.86 | 96.23 | 96.54 | 197366.0 |
| 2013-02-07 | GF | Futures | 275.521 | 275.894 | 273.746 | 275.007 | 3713.0 |
| 2013-02-07 | GSCI | Futures | 1087.59 | 1090.56 | 1080.52 | 1081.32 | 1716.0 |
| 2013-02-07 | HE | Futures | 96.397 | 97.126 | 96.117 | 96.929 | 24905.0 |
| 2013-02-07 | HG | Futures | 4.8156 | 4.8252 | 4.7784 | 4.7861 | 54506.0 |
| 2013-02-07 | HH | Futures | 40.223 | 40.223 | 38.342 | 38.377 | 544.0 |
| 2013-02-07 | HO | Futures | 2.5721 | 2.5957 | 2.5687 | 2.5812 | 59465.0 |
> showing 50 of 102 rows — these rows as CSV