PREVIEW / futures_daily / 2014-10-24
file: by_date/futures_daily/2014/2014-10-24.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 |
|---|---|---|---|---|---|---|---|
| 2014-10-24 | ES | Futures | 2032.76 | 2048.69 | 2017.88 | 2047.13 | 1601260.0 |
| 2014-10-24 | NQ | Futures | 4630.98 | 4680.52 | 4601.71 | 4676.18 | 288628.0 |
| 2014-10-24 | YM | Futures | 16860.4 | 16990.2 | 16753.8 | 16979.1 | 160537.0 |
| 2014-10-24 | CL | Futures | 157.34 | 157.34 | 154.29 | 155.54 | 272509.0 |
| 2014-10-24 | GC | Futures | 1617.9 | 1619.5 | 1611.6 | 1615.7 | 93371.0 |
| 2014-10-24 | ZN | Futures | 119.081196 | 119.447284 | 119.022622 | 119.051909 | 1355117.0 |
| 2014-10-24 | A6 | Futures | 0.84818 | 0.8545 | 0.8443 | 0.85178 | 85606.0 |
| 2014-10-24 | AD | Futures | 0.903 | 0.90625 | 0.90229 | 0.90341 | 40436.0 |
| 2014-10-24 | ALI | Futures | 3006.53 | 3006.53 | 3006.53 | 3006.53 | 0.0 |
| 2014-10-24 | B | Futures | 90.08 | 90.08 | 88.53 | 89.4 | 208221.0 |
| 2014-10-24 | B6 | Futures | 1.6841 | 1.6915 | 1.6822 | 1.6892 | 68776.0 |
| 2014-10-24 | BFX | Futures | 3713.3 | 3728.3 | 3713.3 | 3725.1 | 8.0 |
| 2014-10-24 | BR | Futures | 0.2125 | 0.21858 | 0.2125 | 0.21674 | 924.0 |
| 2014-10-24 | BZ | Futures | 90.6 | 90.71 | 89.26 | 90.06 | 19344.0 |
| 2014-10-24 | C | Futures | 2156.0 | 2167.0 | 2105.0 | 2113.0 | 10266.0 |
| 2014-10-24 | CB | Futures | 136.041 | 137.043 | 132.958 | 133.151 | 13.0 |
| 2014-10-24 | CC | Futures | 2300.0 | 2311.0 | 2242.0 | 2252.0 | 17661.0 |
| 2014-10-24 | CSC | Futures | 4.746 | 4.791 | 4.723 | 4.77 | 45.0 |
| 2014-10-24 | CT | Futures | 79.88 | 81.93 | 79.49 | 80.86 | 14516.0 |
| 2014-10-24 | DC | Futures | 38.76 | 39.03 | 38.3 | 38.78 | 251.0 |
| 2014-10-24 | DX | Futures | 81.566 | 81.652 | 81.272 | 81.465 | 25213.0 |
| 2014-10-24 | E1 | Futures | 1.34029 | 1.34681 | 1.3399 | 1.3431 | 23977.0 |
| 2014-10-24 | E6 | Futures | 1.48904 | 1.49493 | 1.48763 | 1.49116 | 145116.0 |
| 2014-10-24 | E7 | Futures | 1.4794 | 1.4854 | 1.4783 | 1.4818 | 2114.0 |
| 2014-10-24 | ED | Futures | 95.4374 | 95.4422 | 95.4326 | 95.4374 | 113421.0 |
| 2014-10-24 | ER | Futures | 97.979 | 97.984 | 97.97 | 97.974 | 33196.0 |
| 2014-10-24 | EW | Futures | 1427.5 | 1434.3 | 1415.9 | 1432.5 | 14953.0 |
| 2014-10-24 | FBTP | Futures | 94.17 | 94.55 | 94.09 | 94.23 | 56732.0 |
| 2014-10-24 | FBTS | Futures | 98.215 | 98.295 | 98.153 | 98.188 | 13959.0 |
| 2014-10-24 | FCE | Futures | 3332.3 | 3349.7 | 3318.2 | 3331.1 | 87102.0 |
| 2014-10-24 | FDAX | Futures | 9854.1 | 9907.2 | 9808.1 | 9852.5 | 100489.0 |
| 2014-10-24 | FDIV | Futures | 128.08 | 128.45 | 128.08 | 128.45 | 6.0 |
| 2014-10-24 | FESX | Futures | 2184.0 | 2198.5 | 2176.7 | 2190.5 | 945835.0 |
| 2014-10-24 | FGBL | Futures | 132.5 | 132.8 | 132.38 | 132.45 | 615975.0 |
| 2014-10-24 | FGBM | Futures | 122.92 | 123.02 | 122.82 | 122.87 | 334011.0 |
| 2014-10-24 | FGBS | Futures | 110.908 | 110.928 | 110.883 | 110.893 | 201826.0 |
| 2014-10-24 | FGBX | Futures | 143.78 | 144.62 | 143.49 | 143.76 | 19026.0 |
| 2014-10-24 | FMWO | Futures | 5510.7 | 5534.5 | 5510.7 | 5532.0 | 144.0 |
| 2014-10-24 | FOAT | Futures | 121.7 | 121.86 | 121.41 | 121.49 | 59040.0 |
| 2014-10-24 | FTDX | Futures | 1141.7 | 1142.6 | 1135.1 | 1137.9 | 141.0 |
| 2014-10-24 | FTI | Futures | 344.24 | 346.95 | 342.88 | 345.72 | 27559.0 |
| 2014-10-24 | FTUK | Futures | 4935.7 | 4943.0 | 4907.5 | 4921.4 | 88630.0 |
| 2014-10-24 | FVSA | Futures | 1704.15 | 1774.99 | 1695.82 | 1724.99 | 16001.0 |
| 2014-10-24 | FXXP | Futures | 247.8 | 248.5 | 246.7 | 247.8 | 6650.0 |
| 2014-10-24 | G | Futures | 98.8 | 99.08 | 98.72 | 98.78 | 113043.0 |
| 2014-10-24 | GF | Futures | 371.29 | 372.386 | 366.79 | 367.299 | 4201.0 |
| 2014-10-24 | GSCI | Futures | 915.38 | 915.38 | 909.35 | 912.83 | 84.0 |
| 2014-10-24 | HE | Futures | 118.877 | 122.006 | 118.069 | 121.468 | 14230.0 |
| 2014-10-24 | HG | Futures | 3.8496 | 3.8801 | 3.8426 | 3.8572 | 30525.0 |
| 2014-10-24 | HH | Futures | 43.256 | 43.837 | 43.039 | 43.8 | 8464.0 |
> showing 50 of 104 rows — these rows as CSV