PREVIEW / futures_daily / 2013-11-22
file: by_date/futures_daily/2013/2013-11-22.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-22 | ES | Futures | 1842.07 | 1852.34 | 1840.79 | 1850.29 | 1240120.0 |
| 2013-11-22 | NQ | Futures | 3905.85 | 3930.83 | 3904.99 | 3927.96 | 163835.0 |
| 2013-11-22 | YM | Futures | 15892.1 | 15962.7 | 15868.2 | 15946.8 | 107021.0 |
| 2013-11-22 | CL | Futures | 168.59 | 169.08 | 166.39 | 167.79 | 257843.0 |
| 2013-11-22 | GC | Futures | 1643.0 | 1650.9 | 1640.4 | 1645.4 | 135215.0 |
| 2013-11-22 | ZN | Futures | 114.555327 | 114.781917 | 114.456194 | 114.725269 | 980192.0 |
| 2013-11-22 | A6 | Futures | 0.87045 | 0.87234 | 0.86233 | 0.8645 | 103263.0 |
| 2013-11-22 | AD | Futures | 0.96005 | 0.96035 | 0.9551 | 0.95904 | 62381.0 |
| 2013-11-22 | B | Futures | 110.03 | 111.36 | 109.61 | 111.01 | 276245.0 |
| 2013-11-22 | B6 | Futures | 1.6995 | 1.703 | 1.6978 | 1.7009 | 69730.0 |
| 2013-11-22 | BFX | Futures | 3428.4 | 3431.3 | 3428.4 | 3431.3 | 20.0 |
| 2013-11-22 | BR | Futures | 0.21919 | 0.22285 | 0.21919 | 0.22176 | 166.0 |
| 2013-11-22 | BZ | Futures | 110.68 | 112.07 | 110.34 | 111.75 | 8917.0 |
| 2013-11-22 | C | Futures | 1891.0 | 1901.0 | 1874.0 | 1884.0 | 3188.0 |
| 2013-11-22 | CB | Futures | 75.564 | 76.055 | 75.564 | 76.055 | 25.0 |
| 2013-11-22 | CC | Futures | 2074.0 | 2092.0 | 2063.0 | 2077.0 | 9044.0 |
| 2013-11-22 | CSC | Futures | 3.433 | 3.447 | 3.433 | 3.445 | 18.0 |
| 2013-11-22 | CT | Futures | 88.28 | 88.43 | 86.56 | 88.23 | 238.0 |
| 2013-11-22 | DC | Futures | 26.36 | 26.46 | 26.21 | 26.33 | 169.0 |
| 2013-11-22 | DX | Futures | 77.215 | 77.305 | 76.876 | 76.931 | 14670.0 |
| 2013-11-22 | E1 | Futures | 1.40678 | 1.41809 | 1.4046 | 1.4168 | 32518.0 |
| 2013-11-22 | E6 | Futures | 1.59044 | 1.60023 | 1.58879 | 1.59917 | 151394.0 |
| 2013-11-22 | E7 | Futures | 1.5803 | 1.5898 | 1.5787 | 1.5889 | 3499.0 |
| 2013-11-22 | ED | Futures | 95.3733 | 95.3733 | 95.371 | 95.371 | 43735.0 |
| 2013-11-22 | ER | Futures | 97.886 | 97.886 | 97.867 | 97.876 | 125296.0 |
| 2013-11-22 | EW | Futures | 1329.7 | 1334.0 | 1326.7 | 1332.0 | 13684.0 |
| 2013-11-22 | FBTP | Futures | 81.67 | 81.77 | 81.48 | 81.68 | 29207.0 |
| 2013-11-22 | FBTS | Futures | 95.503 | 95.546 | 95.425 | 95.494 | 5750.0 |
| 2013-11-22 | FCE | Futures | 3304.7 | 3321.8 | 3293.5 | 3316.4 | 79392.0 |
| 2013-11-22 | FDAX | Futures | 10224.5 | 10244.0 | 10176.8 | 10229.0 | 75812.0 |
| 2013-11-22 | FESX | Futures | 2138.6 | 2146.3 | 2127.3 | 2141.4 | 629701.0 |
| 2013-11-22 | FGBL | Futures | 120.06 | 120.16 | 119.8 | 120.02 | 551717.0 |
| 2013-11-22 | FGBM | Futures | 118.39 | 118.42 | 118.21 | 118.25 | 456059.0 |
| 2013-11-22 | FGBS | Futures | 110.608 | 110.618 | 110.538 | 110.548 | 317411.0 |
| 2013-11-22 | FGBX | Futures | 120.16 | 120.64 | 119.69 | 120.45 | 16145.0 |
| 2013-11-22 | FMWO | Futures | 5338.2 | 5342.0 | 5335.7 | 5340.8 | 155.0 |
| 2013-11-22 | FOAT | Futures | 108.35 | 108.54 | 108.26 | 108.44 | 47267.0 |
| 2013-11-22 | FTDX | Futures | 1071.3 | 1073.2 | 1069.0 | 1070.4 | 43.0 |
| 2013-11-22 | FTI | Futures | 341.73 | 343.28 | 340.35 | 341.43 | 21742.0 |
| 2013-11-22 | FTUK | Futures | 5025.8 | 5033.7 | 4994.3 | 5004.8 | 72712.0 |
| 2013-11-22 | FVSA | Futures | 1948.44 | 1954.49 | 1936.34 | 1948.44 | 4764.0 |
| 2013-11-22 | FXXP | Futures | 235.8 | 236.5 | 235.0 | 235.3 | 3891.0 |
| 2013-11-22 | G | Futures | 91.68 | 91.97 | 91.49 | 91.83 | 154873.0 |
| 2013-11-22 | GF | Futures | 263.015 | 263.538 | 262.733 | 263.216 | 2213.0 |
| 2013-11-22 | GSCI | Futures | 1034.57 | 1038.38 | 1027.94 | 1034.24 | 569.0 |
| 2013-11-22 | HE | Futures | 109.027 | 109.419 | 108.272 | 108.302 | 14428.0 |
| 2013-11-22 | HG | Futures | 4.0391 | 4.0745 | 4.0265 | 4.065 | 28992.0 |
| 2013-11-22 | HH | Futures | 38.577 | 38.73 | 38.515 | 38.659 | 6087.0 |
| 2013-11-22 | HO | Futures | 2.3984 | 2.4256 | 2.3875 | 2.4217 | 15998.0 |
| 2013-11-22 | HRC | Futures | 2357.0 | 2357.0 | 2357.0 | 2357.0 | 0.0 |
> showing 50 of 102 rows — these rows as CSV