PREVIEW / futures_daily / 2013-04-01
file: by_date/futures_daily/2013/2013-04-01.parquet size: 8 KB rows: 78
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-01 | ES | Futures | 1604.67 | 1606.72 | 1593.89 | 1597.48 | 1135817.0 |
| 2013-04-01 | NQ | Futures | 3246.96 | 3252.44 | 3216.06 | 3220.39 | 145803.0 |
| 2013-04-01 | YM | Futures | 14286.1 | 14310.7 | 14231.9 | 14267.4 | 86213.0 |
| 2013-04-01 | CL | Futures | 169.93 | 170.7 | 167.42 | 169.43 | 192396.0 |
| 2013-04-01 | GC | Futures | 2121.5 | 2126.2 | 2117.7 | 2125.2 | 62176.0 |
| 2013-04-01 | ZN | Futures | 117.308932 | 117.768094 | 117.308932 | 117.656782 | 511658.0 |
| 2013-04-01 | A6 | Futures | 0.95571 | 0.95737 | 0.95322 | 0.95682 | 37480.0 |
| 2013-04-01 | AD | Futures | 0.98647 | 0.98718 | 0.98487 | 0.98667 | 33560.0 |
| 2013-04-01 | B | Futures | 105.76 | 106.93 | 105.1 | 106.7 | 55544.0 |
| 2013-04-01 | B6 | Futures | 1.5894 | 1.5943 | 1.5875 | 1.593 | 43333.0 |
| 2013-04-01 | BR | Futures | 0.24364 | 0.24378 | 0.24302 | 0.24336 | 207.0 |
| 2013-04-01 | BZ | Futures | 106.86 | 108.25 | 106.42 | 108.02 | 2248.0 |
| 2013-04-01 | CB | Futures | 83.447 | 83.57 | 83.077 | 83.324 | 27.0 |
| 2013-04-01 | CC | Futures | 1642.0 | 1663.0 | 1641.0 | 1652.0 | 9220.0 |
| 2013-04-01 | CSC | Futures | 3.74 | 3.758 | 3.74 | 3.746 | 25.0 |
| 2013-04-01 | CT | Futures | 109.13 | 109.83 | 107.35 | 107.51 | 16959.0 |
| 2013-04-01 | DC | Futures | 28.71 | 28.78 | 28.53 | 28.59 | 139.0 |
| 2013-04-01 | DX | Futures | 79.938 | 80.12 | 79.587 | 79.673 | 12022.0 |
| 2013-04-01 | E1 | Futures | 1.35536 | 1.36166 | 1.3515 | 1.35973 | 12079.0 |
| 2013-04-01 | E6 | Futures | 1.5113 | 1.5179 | 1.50647 | 1.51566 | 95747.0 |
| 2013-04-01 | E7 | Futures | 1.5014 | 1.5079 | 1.4969 | 1.5058 | 1778.0 |
| 2013-04-01 | ED | Futures | 95.2157 | 95.2301 | 95.2157 | 95.2205 | 66077.0 |
| 2013-04-01 | EW | Futures | 1173.4 | 1175.7 | 1158.9 | 1161.9 | 15228.0 |
| 2013-04-01 | GF | Futures | 264.74 | 267.957 | 264.74 | 267.451 | 2909.0 |
| 2013-04-01 | GSCI | Futures | 1053.46 | 1053.46 | 1042.38 | 1049.12 | 127.0 |
| 2013-04-01 | HE | Futures | 89.205 | 90.842 | 89.205 | 90.615 | 134.0 |
| 2013-04-01 | HG | Futures | 4.3377 | 4.3415 | 4.2612 | 4.3052 | 35985.0 |
| 2013-04-01 | HH | Futures | 45.011 | 45.747 | 44.637 | 45.487 | 706.0 |
| 2013-04-01 | HO | Futures | 2.447 | 2.4768 | 2.4212 | 2.4612 | 27283.0 |
| 2013-04-01 | HRC | Futures | 2206.9 | 2206.9 | 2206.9 | 2206.9 | 0.0 |
| 2013-04-01 | J1 | Futures | 0.0133164 | 0.0134745 | 0.0133001 | 0.0134444 | 119142.0 |
| 2013-04-01 | J7 | Futures | 0.013278 | 0.013438 | 0.013266 | 0.013408 | 1000.0 |
| 2013-04-01 | JB | Futures | 128.56 | 128.65 | 128.4 | 128.62 | 2323.0 |
| 2013-04-01 | KC | Futures | 279.93 | 288.5 | 276.56 | 282.48 | 15514.0 |
| 2013-04-01 | KE | Futures | 2360.08 | 2369.02 | 2289.4 | 2306.46 | 17609.0 |
| 2013-04-01 | LBS | Futures | 680.6 | 685.1 | 669.3 | 669.3 | 1191.0 |
| 2013-04-01 | LE | Futures | 159.272 | 159.56 | 158.535 | 158.984 | 20695.0 |
| 2013-04-01 | MFS | Futures | 1521.4 | 1529.1 | 1508.6 | 1511.5 | 8170.0 |
| 2013-04-01 | MGC | Futures | 2096.2 | 2101.6 | 2090.2 | 2100.5 | 441.0 |
| 2013-04-01 | MME | Futures | 953.8 | 953.8 | 941.9 | 943.1 | 7542.0 |
| 2013-04-01 | MP | Futures | 0.0473 | 0.04753 | 0.04719 | 0.04728 | 21062.0 |
| 2013-04-01 | N6 | Futures | 0.7141 | 0.71659 | 0.7135 | 0.71608 | 4148.0 |
| 2013-04-01 | NG | Futures | 60.246 | 61.384 | 59.714 | 60.944 | 145340.0 |
| 2013-04-01 | NIY | Futures | 10280.0 | 10296.6 | 9944.9 | 9978.0 | 27198.0 |
| 2013-04-01 | NKD | Futures | 11772.1 | 11790.9 | 11381.2 | 11423.6 | 11247.0 |
| 2013-04-01 | NOK | Futures | 0.177761 | 0.177761 | 0.177761 | 0.177761 | 0.0 |
| 2013-04-01 | OJ | Futures | 117.5 | 119.09 | 113.31 | 115.73 | 2517.0 |
| 2013-04-01 | PA | Futures | 837.73 | 851.62 | 832.84 | 850.69 | 2346.0 |
| 2013-04-01 | PJY | Futures | 118.78 | 118.78 | 118.78 | 118.78 | 9.0 |
| 2013-04-01 | PL | Futures | 1754.8 | 1785.6 | 1747.1 | 1780.2 | 6938.0 |
> showing 50 of 78 rows — these rows as CSV