PREVIEW / futures_daily / 2014-01-29
file: by_date/futures_daily/2014/2014-01-29.parquet size: 9 KB rows: 103
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-01-29 | ES | Futures | 1851.42 | 1856.83 | 1818.43 | 1825.9 | 2740741.0 |
| 2014-01-29 | NQ | Futures | 4039.15 | 4056.96 | 3971.03 | 3992.59 | 396701.0 |
| 2014-01-29 | YM | Futures | 15908.9 | 15957.8 | 15618.3 | 15673.2 | 284151.0 |
| 2014-01-29 | CL | Futures | 171.6 | 172.62 | 170.1 | 171.93 | 200486.0 |
| 2014-01-29 | GC | Futures | 1655.4 | 1675.0 | 1645.5 | 1663.8 | 126698.0 |
| 2014-01-29 | ZN | Futures | 114.319685 | 115.135232 | 114.205222 | 115.035077 | 1982503.0 |
| 2014-01-29 | A6 | Futures | 0.8351 | 0.83862 | 0.82871 | 0.83081 | 102991.0 |
| 2014-01-29 | AD | Futures | 0.90671 | 0.91106 | 0.90418 | 0.9063 | 59147.0 |
| 2014-01-29 | B | Futures | 109.73 | 110.35 | 109.26 | 110.12 | 112950.0 |
| 2014-01-29 | B6 | Futures | 1.739 | 1.744 | 1.7353 | 1.7406 | 92040.0 |
| 2014-01-29 | BR | Futures | 0.21207 | 0.21207 | 0.20992 | 0.21096 | 2893.0 |
| 2014-01-29 | BZ | Futures | 111.93 | 112.57 | 111.52 | 112.34 | 7034.0 |
| 2014-01-29 | C | Futures | 1925.0 | 1948.0 | 1911.0 | 1944.0 | 8179.0 |
| 2014-01-29 | CB | Futures | 91.02 | 91.02 | 90.529 | 90.529 | 7.0 |
| 2014-01-29 | CC | Futures | 2157.0 | 2169.0 | 2126.0 | 2166.0 | 15547.0 |
| 2014-01-29 | CNH | Futures | 6.9489 | 6.9526 | 6.9469 | 6.9509 | 80.0 |
| 2014-01-29 | CSC | Futures | 4.215 | 4.222 | 4.205 | 4.222 | 7.0 |
| 2014-01-29 | CT | Futures | 96.2 | 98.75 | 95.78 | 97.55 | 18659.0 |
| 2014-01-29 | DC | Futures | 32.64 | 32.9 | 32.26 | 32.81 | 431.0 |
| 2014-01-29 | DX | Futures | 76.752 | 76.932 | 76.566 | 76.629 | 22059.0 |
| 2014-01-29 | E1 | Futures | 1.4271 | 1.43724 | 1.42531 | 1.43583 | 38591.0 |
| 2014-01-29 | E6 | Futures | 1.61191 | 1.61534 | 1.60566 | 1.61286 | 257429.0 |
| 2014-01-29 | E7 | Futures | 1.6015 | 1.6048 | 1.5952 | 1.6023 | 7970.0 |
| 2014-01-29 | EBM | Futures | 267.65 | 267.99 | 264.17 | 264.51 | 17064.0 |
| 2014-01-29 | ED | Futures | 95.3662 | 95.371 | 95.3566 | 95.3662 | 238478.0 |
| 2014-01-29 | ER | Futures | 97.852 | 97.862 | 97.842 | 97.852 | 83091.0 |
| 2014-01-29 | EW | Futures | 1347.7 | 1350.8 | 1323.8 | 1326.1 | 26856.0 |
| 2014-01-29 | FBTP | Futures | 83.63 | 83.87 | 83.35 | 83.57 | 61600.0 |
| 2014-01-29 | FBTS | Futures | 96.17 | 96.178 | 96.065 | 96.108 | 11725.0 |
| 2014-01-29 | FCE | Futures | 3282.2 | 3302.8 | 3192.0 | 3233.6 | 237955.0 |
| 2014-01-29 | FDAX | Futures | 10533.4 | 10584.4 | 10231.7 | 10368.1 | 199468.0 |
| 2014-01-29 | FESX | Futures | 2151.3 | 2166.1 | 2091.6 | 2120.4 | 1717783.0 |
| 2014-01-29 | FGBL | Futures | 121.15 | 121.94 | 121.05 | 121.6 | 1010650.0 |
| 2014-01-29 | FGBM | Futures | 118.64 | 119.04 | 118.57 | 118.86 | 559102.0 |
| 2014-01-29 | FGBS | Futures | 110.563 | 110.628 | 110.538 | 110.588 | 369538.0 |
| 2014-01-29 | FGBX | Futures | 122.99 | 124.19 | 122.83 | 123.61 | 18561.0 |
| 2014-01-29 | FMWO | Futures | 5310.1 | 5310.1 | 5271.1 | 5271.1 | 24.0 |
| 2014-01-29 | FOAT | Futures | 109.63 | 110.03 | 109.46 | 109.91 | 56129.0 |
| 2014-01-29 | FTDX | Futures | 1158.2 | 1169.5 | 1136.6 | 1142.7 | 542.0 |
| 2014-01-29 | FTI | Futures | 337.51 | 338.92 | 328.6 | 332.8 | 52252.0 |
| 2014-01-29 | FTUK | Futures | 4962.8 | 4990.1 | 4865.2 | 4911.7 | 167449.0 |
| 2014-01-29 | FVSA | Futures | 1923.04 | 2111.77 | 1882.23 | 2030.16 | 13209.0 |
| 2014-01-29 | FXXP | Futures | 239.4 | 240.2 | 233.7 | 236.2 | 7316.0 |
| 2014-01-29 | G | Futures | 92.38 | 92.98 | 92.25 | 92.87 | 268660.0 |
| 2014-01-29 | GF | Futures | 271.063 | 273.118 | 268.483 | 272.836 | 4768.0 |
| 2014-01-29 | GSCI | Futures | 1025.47 | 1028.26 | 1018.75 | 1027.85 | 124.0 |
| 2014-01-29 | HE | Futures | 112.982 | 113.556 | 112.801 | 113.284 | 10296.0 |
| 2014-01-29 | HG | Futures | 4.1067 | 4.1288 | 4.0884 | 4.0928 | 38917.0 |
| 2014-01-29 | HH | Futures | 53.58 | 58.191 | 52.72 | 58.064 | 2167.0 |
| 2014-01-29 | HO | Futures | 2.397 | 2.4173 | 2.3855 | 2.4147 | 65981.0 |
> showing 50 of 103 rows — these rows as CSV