PREVIEW / futures_daily / 2013-11-18
file: by_date/futures_daily/2013/2013-11-18.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-11-18 | ES | Futures | 1842.33 | 1848.75 | 1833.34 | 1837.45 | 1559073.0 |
| 2013-11-18 | NQ | Futures | 3923.94 | 3934.57 | 3882.31 | 3886.61 | 223476.0 |
| 2013-11-18 | YM | Futures | 15833.4 | 15914.0 | 15815.5 | 15858.2 | 125387.0 |
| 2013-11-18 | CL | Futures | 167.07 | 167.97 | 165.21 | 165.74 | 137135.0 |
| 2013-11-18 | GC | Futures | 1704.6 | 1705.0 | 1678.6 | 1682.7 | 112201.0 |
| 2013-11-18 | ZN | Futures | 114.838564 | 115.249258 | 114.796079 | 115.150125 | 739043.0 |
| 2013-11-18 | A6 | Futures | 0.88377 | 0.88802 | 0.88235 | 0.88386 | 65090.0 |
| 2013-11-18 | AD | Futures | 0.96763 | 0.96965 | 0.96692 | 0.96813 | 41874.0 |
| 2013-11-18 | B | Futures | 108.46 | 108.69 | 107.49 | 108.43 | 185490.0 |
| 2013-11-18 | B6 | Futures | 1.6916 | 1.6948 | 1.6878 | 1.6894 | 66409.0 |
| 2013-11-18 | BR | Futures | 0.22179 | 0.22535 | 0.22168 | 0.22357 | 493.0 |
| 2013-11-18 | BZ | Futures | 109.18 | 109.4 | 108.23 | 109.15 | 4900.0 |
| 2013-11-18 | C | Futures | 1851.0 | 1886.0 | 1834.0 | 1884.0 | 3065.0 |
| 2013-11-18 | CB | Futures | 73.903 | 74.214 | 73.903 | 74.095 | 11.0 |
| 2013-11-18 | CC | Futures | 2026.0 | 2066.0 | 2008.0 | 2063.0 | 16500.0 |
| 2013-11-18 | CNH | Futures | 7.0062 | 7.0062 | 7.0009 | 7.0009 | 1.0 |
| 2013-11-18 | CSC | Futures | 3.412 | 3.42 | 3.412 | 3.418 | 28.0 |
| 2013-11-18 | CT | Futures | 90.44 | 90.61 | 89.51 | 89.59 | 4547.0 |
| 2013-11-18 | DC | Futures | 26.11 | 26.18 | 26.02 | 26.05 | 161.0 |
| 2013-11-18 | DX | Futures | 77.057 | 77.143 | 76.795 | 77.011 | 13749.0 |
| 2013-11-18 | E1 | Futures | 1.4046 | 1.41321 | 1.40293 | 1.40691 | 24926.0 |
| 2013-11-18 | E6 | Futures | 1.59233 | 1.59823 | 1.5902 | 1.59315 | 122314.0 |
| 2013-11-18 | E7 | Futures | 1.5819 | 1.5879 | 1.5801 | 1.5829 | 2280.0 |
| 2013-11-18 | ED | Futures | 95.3662 | 95.3686 | 95.3662 | 95.3686 | 57763.0 |
| 2013-11-18 | ER | Futures | 97.886 | 97.891 | 97.881 | 97.886 | 20173.0 |
| 2013-11-18 | EW | Futures | 1334.5 | 1339.7 | 1322.9 | 1325.4 | 17410.0 |
| 2013-11-18 | FBTP | Futures | 81.58 | 81.78 | 81.44 | 81.75 | 21101.0 |
| 2013-11-18 | FBTS | Futures | 95.425 | 95.451 | 95.356 | 95.442 | 5006.0 |
| 2013-11-18 | FCE | Futures | 3324.5 | 3361.4 | 3313.7 | 3347.8 | 88575.0 |
| 2013-11-18 | FDAX | Futures | 10170.2 | 10272.3 | 10142.4 | 10247.8 | 100237.0 |
| 2013-11-18 | FESX | Futures | 2139.3 | 2167.3 | 2131.5 | 2160.3 | 797703.0 |
| 2013-11-18 | FEU3 | Futures | 98.512 | 98.512 | 98.507 | 98.507 | 50.0 |
| 2013-11-18 | FGBL | Futures | 120.66 | 120.87 | 120.45 | 120.79 | 384690.0 |
| 2013-11-18 | FGBM | Futures | 118.55 | 118.65 | 118.47 | 118.61 | 267906.0 |
| 2013-11-18 | FGBS | Futures | 110.598 | 110.613 | 110.583 | 110.608 | 133852.0 |
| 2013-11-18 | FGBX | Futures | 120.95 | 121.38 | 120.68 | 121.26 | 8316.0 |
| 2013-11-18 | FMWO | Futures | 5374.9 | 5374.9 | 5363.5 | 5363.5 | 100.0 |
| 2013-11-18 | FOAT | Futures | 108.65 | 108.75 | 108.4 | 108.72 | 23159.0 |
| 2013-11-18 | FTDX | Futures | 1089.7 | 1094.0 | 1087.8 | 1091.6 | 185.0 |
| 2013-11-18 | FTI | Futures | 341.34 | 343.41 | 340.05 | 342.51 | 20570.0 |
| 2013-11-18 | FTUK | Futures | 5013.1 | 5044.2 | 4996.9 | 5037.1 | 77396.0 |
| 2013-11-18 | FVSA | Futures | 2063.41 | 2075.52 | 2002.9 | 2021.06 | 8229.0 |
| 2013-11-18 | FXXP | Futures | 235.2 | 237.4 | 235.0 | 236.9 | 4175.0 |
| 2013-11-18 | G | Futures | 92.39 | 92.55 | 92.06 | 92.51 | 100784.0 |
| 2013-11-18 | GF | Futures | 267.201 | 267.523 | 264.182 | 264.504 | 4626.0 |
| 2013-11-18 | GSCI | Futures | 1019.16 | 1023.71 | 1015.34 | 1017.5 | 281.0 |
| 2013-11-18 | HE | Futures | 108.725 | 109.268 | 108.242 | 108.574 | 8052.0 |
| 2013-11-18 | HG | Futures | 4.0151 | 4.0278 | 3.9886 | 3.9918 | 15457.0 |
| 2013-11-18 | HH | Futures | 37.674 | 37.704 | 37.048 | 37.109 | 1732.0 |
| 2013-11-18 | HO | Futures | 2.3539 | 2.3546 | 2.328 | 2.3386 | 8106.0 |
> showing 50 of 104 rows — these rows as CSV