PREVIEW / futures_daily / 2014-06-18
file: by_date/futures_daily/2014/2014-06-18.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-06-18 | ES | Futures | 2008.51 | 2025.91 | 2004.1 | 2024.61 | 1759084.0 |
| 2014-06-18 | NQ | Futures | 4353.5 | 4384.65 | 4332.44 | 4379.46 | 277906.0 |
| 2014-06-18 | YM | Futures | 16881.3 | 16983.2 | 16799.6 | 16969.1 | 147246.0 |
| 2014-06-18 | CL | Futures | 193.74 | 194.49 | 192.46 | 192.88 | 235784.0 |
| 2014-06-18 | GC | Futures | 1676.1 | 1685.5 | 1668.7 | 1676.9 | 87914.0 |
| 2014-06-18 | ZN | Futures | 115.660406 | 116.24396 | 115.572873 | 115.981361 | 1335184.0 |
| 2014-06-18 | A6 | Futures | 0.89663 | 0.90407 | 0.89508 | 0.89914 | 72615.0 |
| 2014-06-18 | AD | Futures | 0.93307 | 0.93541 | 0.92515 | 0.93236 | 50099.0 |
| 2014-06-18 | ALI | Futures | 2769.99 | 2769.99 | 2769.99 | 2769.99 | 5.0 |
| 2014-06-18 | B | Futures | 118.75 | 119.88 | 118.32 | 119.59 | 240752.0 |
| 2014-06-18 | B6 | Futures | 1.7817 | 1.7863 | 1.7763 | 1.7811 | 113514.0 |
| 2014-06-18 | BFX | Futures | 3834.8 | 3837.9 | 3818.3 | 3818.3 | 662.0 |
| 2014-06-18 | BR | Futures | 0.22936 | 0.23168 | 0.22854 | 0.23128 | 1164.0 |
| 2014-06-18 | BZ | Futures | 119.6 | 120.88 | 119.38 | 120.64 | 12588.0 |
| 2014-06-18 | C | Futures | 2044.0 | 2049.0 | 2036.0 | 2048.0 | 3622.0 |
| 2014-06-18 | CB | Futures | 117.38 | 119.755 | 117.38 | 119.755 | 17.0 |
| 2014-06-18 | CC | Futures | 2284.0 | 2294.0 | 2277.0 | 2291.0 | 6127.0 |
| 2014-06-18 | CNH | Futures | 7.1805 | 7.1823 | 7.1744 | 7.1744 | 1.0 |
| 2014-06-18 | CSC | Futures | 4.645 | 4.645 | 4.622 | 4.622 | 2.0 |
| 2014-06-18 | CT | Futures | 101.36 | 102.95 | 101.36 | 102.64 | 9144.0 |
| 2014-06-18 | DC | Futures | 36.52 | 36.85 | 36.46 | 36.74 | 216.0 |
| 2014-06-18 | DX | Futures | 76.603 | 76.859 | 76.384 | 76.574 | 20252.0 |
| 2014-06-18 | E1 | Futures | 1.42635 | 1.43263 | 1.42558 | 1.4275 | 37033.0 |
| 2014-06-18 | E6 | Futures | 1.59893 | 1.60565 | 1.59834 | 1.60034 | 168189.0 |
| 2014-06-18 | E7 | Futures | 1.5885 | 1.5952 | 1.5879 | 1.5899 | 3095.0 |
| 2014-06-18 | ED | Futures | 95.4067 | 95.4115 | 95.3971 | 95.4067 | 165536.0 |
| 2014-06-18 | ER | Futures | 97.916 | 97.92 | 97.906 | 97.911 | 65421.0 |
| 2014-06-18 | EW | Futures | 1462.7 | 1473.5 | 1458.9 | 1472.8 | 20989.0 |
| 2014-06-18 | FBTP | Futures | 90.69 | 90.91 | 90.4 | 90.61 | 55729.0 |
| 2014-06-18 | FBTS | Futures | 97.921 | 97.948 | 97.832 | 97.859 | 14921.0 |
| 2014-06-18 | FCE | Futures | 3620.3 | 3638.3 | 3610.8 | 3611.6 | 112279.0 |
| 2014-06-18 | FDAX | Futures | 10959.7 | 11027.9 | 10933.8 | 10949.8 | 79676.0 |
| 2014-06-18 | FESX | Futures | 2356.2 | 2374.2 | 2349.7 | 2354.0 | 1525561.0 |
| 2014-06-18 | FEU3 | Futures | 98.537 | 98.537 | 98.527 | 98.532 | 65.0 |
| 2014-06-18 | FGBL | Futures | 126.21 | 126.68 | 126.01 | 126.49 | 580060.0 |
| 2014-06-18 | FGBM | Futures | 120.94 | 121.13 | 120.88 | 121.06 | 379337.0 |
| 2014-06-18 | FGBS | Futures | 110.723 | 110.743 | 110.713 | 110.733 | 162496.0 |
| 2014-06-18 | FGBX | Futures | 129.43 | 130.67 | 129.15 | 130.22 | 17667.0 |
| 2014-06-18 | FMWO | Futures | 5743.7 | 5750.0 | 5742.4 | 5742.4 | 488.0 |
| 2014-06-18 | FOAT | Futures | 115.82 | 116.17 | 115.72 | 116.14 | 54607.0 |
| 2014-06-18 | FTDX | Futures | 1230.5 | 1241.2 | 1230.5 | 1240.8 | 964.0 |
| 2014-06-18 | FTI | Futures | 358.96 | 361.29 | 358.53 | 359.22 | 32418.0 |
| 2014-06-18 | FTUK | Futures | 5175.8 | 5201.5 | 5173.9 | 5178.1 | 127984.0 |
| 2014-06-18 | FVSA | Futures | 1383.91 | 1383.91 | 1328.04 | 1332.34 | 11679.0 |
| 2014-06-18 | FXXP | Futures | 260.7 | 261.0 | 259.7 | 259.8 | 33973.0 |
| 2014-06-18 | G | Futures | 92.8 | 93.29 | 92.8 | 93.18 | 147565.0 |
| 2014-06-18 | GF | Futures | 317.286 | 318.397 | 313.952 | 313.952 | 4057.0 |
| 2014-06-18 | GSCI | Futures | 1106.58 | 1107.58 | 1103.5 | 1106.16 | 24.0 |
| 2014-06-18 | HE | Futures | 131.102 | 133.127 | 130.444 | 131.97 | 16200.0 |
| 2014-06-18 | HG | Futures | 3.9113 | 3.9266 | 3.8966 | 3.9126 | 13554.0 |
> showing 50 of 105 rows — these rows as CSV