PREVIEW / futures_daily / 2013-11-25
file: by_date/futures_daily/2013/2013-11-25.parquet size: 9 KB rows: 102
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-25 | ES | Futures | 1851.06 | 1858.51 | 1847.47 | 1851.57 | 1114352.0 |
| 2013-11-25 | NQ | Futures | 3930.83 | 3947.77 | 3928.25 | 3938.3 | 177967.0 |
| 2013-11-25 | YM | Futures | 15957.7 | 16019.4 | 15947.8 | 15981.6 | 121230.0 |
| 2013-11-25 | CL | Futures | 166.57 | 167.19 | 164.68 | 166.47 | 270860.0 |
| 2013-11-25 | GC | Futures | 1645.4 | 1660.9 | 1623.8 | 1643.9 | 59401.0 |
| 2013-11-25 | ZN | Futures | 114.753593 | 114.937697 | 114.583651 | 114.810241 | 1654732.0 |
| 2013-11-25 | A6 | Futures | 0.86459 | 0.86667 | 0.86025 | 0.86365 | 81299.0 |
| 2013-11-25 | AD | Futures | 0.95965 | 0.95965 | 0.95419 | 0.95672 | 49035.0 |
| 2013-11-25 | B | Futures | 111.01 | 112.84 | 109.31 | 112.2 | 98813.0 |
| 2013-11-25 | B6 | Futures | 1.7036 | 1.7045 | 1.6932 | 1.6948 | 81566.0 |
| 2013-11-25 | BFX | Futures | 3451.4 | 3459.4 | 3449.7 | 3455.5 | 26.0 |
| 2013-11-25 | BR | Futures | 0.22176 | 0.22176 | 0.22176 | 0.22176 | 756.0 |
| 2013-11-25 | BZ | Futures | 111.75 | 114.8 | 111.23 | 114.15 | 9663.0 |
| 2013-11-25 | C | Futures | 1881.0 | 1890.0 | 1875.0 | 1887.0 | 1833.0 |
| 2013-11-25 | CB | Futures | 77.527 | 77.527 | 76.533 | 76.545 | 36.0 |
| 2013-11-25 | CC | Futures | 2071.0 | 2085.0 | 2066.0 | 2080.0 | 7255.0 |
| 2013-11-25 | CSC | Futures | 3.445 | 3.47 | 3.443 | 3.466 | 15.0 |
| 2013-11-25 | CT | Futures | 88.23 | 89.89 | 88.08 | 89.46 | 11977.0 |
| 2013-11-25 | DC | Futures | 26.33 | 26.49 | 26.28 | 26.49 | 149.0 |
| 2013-11-25 | DX | Futures | 76.91 | 77.234 | 76.862 | 77.141 | 14884.0 |
| 2013-11-25 | E1 | Futures | 1.41758 | 1.41835 | 1.40742 | 1.40935 | 27481.0 |
| 2013-11-25 | E6 | Futures | 1.59952 | 1.60023 | 1.59197 | 1.59504 | 136897.0 |
| 2013-11-25 | E7 | Futures | 1.5883 | 1.5898 | 1.5818 | 1.5848 | 2428.0 |
| 2013-11-25 | ED | Futures | 95.3733 | 95.3733 | 95.371 | 95.371 | 49988.0 |
| 2013-11-25 | ER | Futures | 97.871 | 97.871 | 97.862 | 97.871 | 68072.0 |
| 2013-11-25 | EW | Futures | 1333.2 | 1337.0 | 1327.5 | 1331.3 | 14151.0 |
| 2013-11-25 | FBTP | Futures | 81.66 | 81.77 | 81.59 | 81.67 | 22870.0 |
| 2013-11-25 | FBTS | Futures | 95.511 | 95.554 | 95.494 | 95.52 | 2741.0 |
| 2013-11-25 | FCE | Futures | 3325.3 | 3339.3 | 3320.3 | 3333.5 | 71081.0 |
| 2013-11-25 | FDAX | Futures | 10254.5 | 10349.9 | 10250.1 | 10326.1 | 82245.0 |
| 2013-11-25 | FESX | Futures | 2149.8 | 2157.5 | 2144.9 | 2153.3 | 574733.0 |
| 2013-11-25 | FGBL | Futures | 119.94 | 120.39 | 119.93 | 120.34 | 435701.0 |
| 2013-11-25 | FGBM | Futures | 118.22 | 118.41 | 118.19 | 118.37 | 326406.0 |
| 2013-11-25 | FGBS | Futures | 110.533 | 110.578 | 110.528 | 110.563 | 229873.0 |
| 2013-11-25 | FGBX | Futures | 120.31 | 121.13 | 120.31 | 120.93 | 10194.0 |
| 2013-11-25 | FMWO | Futures | 5352.2 | 5352.2 | 5352.2 | 5352.2 | 0.0 |
| 2013-11-25 | FOAT | Futures | 108.4 | 108.73 | 108.4 | 108.63 | 22828.0 |
| 2013-11-25 | FTDX | Futures | 1078.4 | 1079.4 | 1075.6 | 1079.4 | 98.0 |
| 2013-11-25 | FTI | Futures | 342.55 | 343.89 | 341.9 | 342.98 | 18119.0 |
| 2013-11-25 | FTUK | Futures | 5026.9 | 5032.6 | 5006.3 | 5023.2 | 53140.0 |
| 2013-11-25 | FVSA | Futures | 1924.24 | 1930.29 | 1906.09 | 1918.19 | 4606.0 |
| 2013-11-25 | FXXP | Futures | 236.7 | 237.0 | 235.8 | 236.5 | 3099.0 |
| 2013-11-25 | G | Futures | 91.83 | 92.1 | 91.76 | 92.04 | 272946.0 |
| 2013-11-25 | GF | Futures | 263.699 | 263.941 | 262.009 | 262.089 | 2002.0 |
| 2013-11-25 | GSCI | Futures | 1025.78 | 1035.56 | 1023.3 | 1033.66 | 138.0 |
| 2013-11-25 | HE | Futures | 108.362 | 109.389 | 108.121 | 108.453 | 11259.0 |
| 2013-11-25 | HG | Futures | 4.1282 | 4.1282 | 4.0492 | 4.0795 | 27125.0 |
| 2013-11-25 | HH | Futures | 38.659 | 38.699 | 38.078 | 38.488 | 147.0 |
| 2013-11-25 | HO | Futures | 2.4217 | 2.43 | 2.3744 | 2.4163 | 13463.0 |
| 2013-11-25 | HRC | Futures | 2357.0 | 2357.0 | 2357.0 | 2357.0 | 0.0 |
> showing 50 of 102 rows — these rows as CSV