PREVIEW / futures_daily / 2013-04-19
file: by_date/futures_daily/2013/2013-04-19.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 |
|---|---|---|---|---|---|---|---|
| 2013-04-19 | ES | Futures | 1577.98 | 1592.09 | 1576.18 | 1588.76 | 1879483.0 |
| 2013-04-19 | NQ | Futures | 3172.17 | 3210.57 | 3161.19 | 3197.58 | 273830.0 |
| 2013-04-19 | YM | Futures | 14203.4 | 14283.2 | 14186.7 | 14248.7 | 153797.0 |
| 2013-04-19 | CL | Futures | 154.59 | 155.33 | 153.16 | 153.95 | 231562.0 |
| 2013-04-19 | GC | Futures | 1849.2 | 1891.3 | 1839.1 | 1852.7 | 199699.0 |
| 2013-04-19 | ZN | Futures | 118.533364 | 118.547278 | 118.352482 | 118.435966 | 878731.0 |
| 2013-04-19 | A6 | Futures | 0.94676 | 0.95211 | 0.94427 | 0.94473 | 105032.0 |
| 2013-04-19 | AD | Futures | 0.97803 | 0.98065 | 0.97703 | 0.97753 | 52539.0 |
| 2013-04-19 | B | Futures | 95.85 | 96.61 | 95.37 | 95.96 | 175359.0 |
| 2013-04-19 | B6 | Futures | 1.5985 | 1.6077 | 1.5924 | 1.5931 | 108907.0 |
| 2013-04-19 | BFX | Futures | 2977.6 | 2985.1 | 2977.3 | 2985.1 | 6.0 |
| 2013-04-19 | BR | Futures | 0.24443 | 0.24579 | 0.24443 | 0.24532 | 71.0 |
| 2013-04-19 | BZ | Futures | 96.98 | 97.81 | 96.56 | 97.14 | 4312.0 |
| 2013-04-19 | C | Futures | 1651.0 | 1651.0 | 1636.0 | 1649.0 | 3511.0 |
| 2013-04-19 | CB | Futures | 92.075 | 92.075 | 90.732 | 91.706 | 37.0 |
| 2013-04-19 | CC | Futures | 1752.0 | 1761.0 | 1741.0 | 1749.0 | 11513.0 |
| 2013-04-19 | CNH | Futures | 7.212 | 7.2168 | 7.2094 | 7.2149 | 78.0 |
| 2013-04-19 | CSC | Futures | 3.885 | 3.885 | 3.835 | 3.853 | 31.0 |
| 2013-04-19 | CT | Futures | 102.72 | 103.45 | 102.26 | 102.7 | 3124.0 |
| 2013-04-19 | DC | Futures | 29.83 | 30.0 | 29.42 | 29.57 | 201.0 |
| 2013-04-19 | DX | Futures | 79.452 | 79.669 | 79.193 | 79.622 | 30426.0 |
| 2013-04-19 | E1 | Futures | 1.37993 | 1.38739 | 1.37684 | 1.3789 | 30669.0 |
| 2013-04-19 | E6 | Futures | 1.53995 | 1.54855 | 1.53865 | 1.54042 | 218846.0 |
| 2013-04-19 | E7 | Futures | 1.5297 | 1.5385 | 1.5287 | 1.5304 | 3545.0 |
| 2013-04-19 | EBM | Futures | 285.84 | 286.43 | 285.26 | 286.13 | 5818.0 |
| 2013-04-19 | ED | Futures | 95.2587 | 95.2587 | 95.254 | 95.254 | 56733.0 |
| 2013-04-19 | ER | Futures | 97.832 | 97.842 | 97.827 | 97.832 | 95186.0 |
| 2013-04-19 | EW | Futures | 1126.5 | 1143.3 | 1126.2 | 1138.5 | 22024.0 |
| 2013-04-19 | FBTP | Futures | 77.63 | 77.83 | 77.51 | 77.76 | 19394.0 |
| 2013-04-19 | FBTS | Futures | 92.321 | 92.407 | 92.313 | 92.381 | 3406.0 |
| 2013-04-19 | FCE | Futures | 2733.4 | 2765.0 | 2730.0 | 2759.6 | 148599.0 |
| 2013-04-19 | FDAX | Futures | 8343.4 | 8381.7 | 8251.1 | 8296.1 | 136752.0 |
| 2013-04-19 | FDIV | Futures | 111.05 | 111.05 | 110.45 | 110.45 | 10.0 |
| 2013-04-19 | FESX | Futures | 1753.2 | 1770.7 | 1749.7 | 1758.8 | 1141937.0 |
| 2013-04-19 | FGBL | Futures | 122.49 | 122.54 | 122.24 | 122.39 | 597943.0 |
| 2013-04-19 | FGBM | Futures | 118.28 | 118.3 | 118.14 | 118.21 | 322048.0 |
| 2013-04-19 | FGBS | Futures | 110.497 | 110.512 | 110.482 | 110.497 | 209185.0 |
| 2013-04-19 | FGBX | Futures | 129.32 | 129.8 | 128.98 | 129.15 | 7071.0 |
| 2013-04-19 | FMWO | Futures | 4617.5 | 4632.7 | 4616.3 | 4632.7 | 139.0 |
| 2013-04-19 | FOAT | Futures | 109.12 | 109.2 | 108.94 | 109.05 | 43881.0 |
| 2013-04-19 | FTDX | Futures | 849.2 | 858.7 | 849.2 | 855.9 | 112.0 |
| 2013-04-19 | FTI | Futures | 292.33 | 293.59 | 290.81 | 292.72 | 29837.0 |
| 2013-04-19 | FTUK | Futures | 4602.3 | 4639.9 | 4599.4 | 4630.6 | 102323.0 |
| 2013-04-19 | FVSA | Futures | 3485.59 | 3485.59 | 3319.24 | 3335.08 | 11407.0 |
| 2013-04-19 | FXXP | Futures | 206.8 | 208.0 | 205.6 | 206.8 | 3435.0 |
| 2013-04-19 | G | Futures | 100.57 | 100.71 | 100.4 | 100.64 | 99295.0 |
| 2013-04-19 | GF | Futures | 252.427 | 253.016 | 250.751 | 252.246 | 2869.0 |
| 2013-04-19 | GSCI | Futures | 976.7 | 977.19 | 972.29 | 975.58 | 114.0 |
| 2013-04-19 | HE | Futures | 88.45 | 88.526 | 87.897 | 88.45 | 134.0 |
| 2013-04-19 | HG | Futures | 4.1016 | 4.1023 | 3.98 | 4.0296 | 26339.0 |
> showing 50 of 104 rows — these rows as CSV