PREVIEW / futures_daily / 2014-10-16
file: by_date/futures_daily/2014/2014-10-16.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-10-16 | ES | Futures | 1929.09 | 1953.11 | 1896.18 | 1933.01 | 3368379.0 |
| 2014-10-16 | NQ | Futures | 4347.32 | 4388.46 | 4269.67 | 4336.31 | 695840.0 |
| 2014-10-16 | YM | Futures | 16239.5 | 16370.4 | 16014.3 | 16247.6 | 430281.0 |
| 2014-10-16 | CL | Futures | 154.31 | 161.43 | 151.87 | 157.34 | 259581.0 |
| 2014-10-16 | GC | Futures | 1629.3 | 1633.8 | 1620.2 | 1628.0 | 180590.0 |
| 2014-10-16 | ZN | Futures | 120.179461 | 121.424161 | 119.754798 | 120.003739 | 3200040.0 |
| 2014-10-16 | A6 | Futures | 0.85275 | 0.85314 | 0.8406 | 0.84838 | 142090.0 |
| 2014-10-16 | AD | Futures | 0.90036 | 0.90331 | 0.89264 | 0.90138 | 88282.0 |
| 2014-10-16 | ALI | Futures | 2929.48 | 2929.48 | 2929.48 | 2929.48 | 0.0 |
| 2014-10-16 | B | Futures | 86.53 | 91.34 | 86.08 | 89.08 | 430684.0 |
| 2014-10-16 | B6 | Futures | 1.6815 | 1.6912 | 1.6748 | 1.6874 | 147837.0 |
| 2014-10-16 | BFX | Futures | 3549.7 | 3551.9 | 3423.0 | 3494.6 | 365.0 |
| 2014-10-16 | BR | Futures | 0.21669 | 0.21731 | 0.21328 | 0.21652 | 938.0 |
| 2014-10-16 | BZ | Futures | 87.21 | 92.01 | 86.73 | 89.74 | 30627.0 |
| 2014-10-16 | C | Futures | 2178.0 | 2194.0 | 2146.0 | 2152.0 | 4279.0 |
| 2014-10-16 | CB | Futures | 132.958 | 136.022 | 132.958 | 133.729 | 27.0 |
| 2014-10-16 | CC | Futures | 2319.0 | 2325.0 | 2262.0 | 2278.0 | 12829.0 |
| 2014-10-16 | CSC | Futures | 4.993 | 5.032 | 4.975 | 4.99 | 90.0 |
| 2014-10-16 | CT | Futures | 80.73 | 81.34 | 80.41 | 80.54 | 8802.0 |
| 2014-10-16 | DC | Futures | 40.43 | 40.87 | 40.32 | 40.55 | 430.0 |
| 2014-10-16 | DX | Futures | 80.688 | 81.191 | 80.532 | 80.727 | 59863.0 |
| 2014-10-16 | E1 | Futures | 1.35857 | 1.36062 | 1.34796 | 1.35614 | 72038.0 |
| 2014-10-16 | E6 | Futures | 1.50964 | 1.51258 | 1.49622 | 1.50729 | 373128.0 |
| 2014-10-16 | E7 | Futures | 1.4999 | 1.503 | 1.4869 | 1.4978 | 5953.0 |
| 2014-10-16 | ED | Futures | 95.447 | 95.447 | 95.423 | 95.4326 | 390328.0 |
| 2014-10-16 | ER | Futures | 97.989 | 97.999 | 97.955 | 97.974 | 163496.0 |
| 2014-10-16 | EW | Futures | 1339.5 | 1365.0 | 1317.5 | 1359.5 | 45747.0 |
| 2014-10-16 | FBTP | Futures | 94.89 | 94.89 | 92.46 | 93.69 | 226919.0 |
| 2014-10-16 | FBTS | Futures | 98.304 | 98.366 | 97.416 | 97.86 | 48137.0 |
| 2014-10-16 | FCE | Futures | 3193.2 | 3215.0 | 3053.2 | 3159.3 | 103888.0 |
| 2014-10-16 | FDAX | Futures | 9449.3 | 9492.1 | 9147.0 | 9426.9 | 265362.0 |
| 2014-10-16 | FDIV | Futures | 121.69 | 122.48 | 121.69 | 122.48 | 50.0 |
| 2014-10-16 | FESX | Futures | 2099.9 | 2113.0 | 2007.2 | 2080.4 | 2988497.0 |
| 2014-10-16 | FEU3 | Futures | 98.596 | 98.596 | 98.591 | 98.596 | 26.0 |
| 2014-10-16 | FGBL | Futures | 133.6 | 134.32 | 132.91 | 133.13 | 1412187.0 |
| 2014-10-16 | FGBM | Futures | 123.18 | 123.32 | 122.92 | 122.98 | 807131.0 |
| 2014-10-16 | FGBS | Futures | 110.918 | 110.983 | 110.908 | 110.918 | 470499.0 |
| 2014-10-16 | FGBX | Futures | 146.88 | 150.13 | 145.68 | 146.16 | 60475.0 |
| 2014-10-16 | FMWO | Futures | 5278.7 | 5295.0 | 5173.4 | 5295.0 | 1865.0 |
| 2014-10-16 | FOAT | Futures | 122.9 | 122.96 | 121.64 | 121.94 | 192758.0 |
| 2014-10-16 | FTDX | Futures | 1068.4 | 1073.6 | 1030.6 | 1052.3 | 711.0 |
| 2014-10-16 | FTI | Futures | 332.77 | 334.83 | 319.82 | 328.05 | 22141.0 |
| 2014-10-16 | FTUK | Futures | 4794.2 | 4836.3 | 4672.0 | 4774.1 | 303805.0 |
| 2014-10-16 | FVSA | Futures | 1983.32 | 2158.32 | 1937.48 | 1991.65 | 27777.0 |
| 2014-10-16 | FXXP | Futures | 236.7 | 237.8 | 228.2 | 234.6 | 25353.0 |
| 2014-10-16 | G | Futures | 100.58 | 101.18 | 99.64 | 99.94 | 379267.0 |
| 2014-10-16 | GF | Futures | 365.107 | 371.212 | 362.759 | 371.212 | 5540.0 |
| 2014-10-16 | GSCI | Futures | 901.96 | 929.22 | 901.96 | 916.4 | 473.0 |
| 2014-10-16 | HE | Futures | 122.746 | 123.621 | 120.324 | 121.569 | 20202.0 |
| 2014-10-16 | HG | Futures | 3.8223 | 3.8388 | 3.745 | 3.7818 | 79233.0 |
> showing 50 of 106 rows — these rows as CSV