PREVIEW / futures_daily / 2013-01-18
file: by_date/futures_daily/2013/2013-01-18.parquet size: 9 KB rows: 101
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-01-18 | ES | Futures | 1509.73 | 1515.35 | 1504.61 | 1513.31 | 1487277.0 |
| 2013-01-18 | NQ | Futures | 3155.23 | 3162.44 | 3140.24 | 3153.21 | 171009.0 |
| 2013-01-18 | YM | Futures | 13277.3 | 13322.4 | 13251.8 | 13312.6 | 89755.0 |
| 2013-01-18 | CL | Futures | 168.56 | 169.4 | 168.05 | 169.24 | 210132.0 |
| 2013-01-18 | GC | Futures | 2248.7 | 2258.9 | 2243.2 | 2248.1 | 115543.0 |
| 2013-01-18 | ZN | Futures | 116.280219 | 116.638556 | 116.156179 | 116.555863 | 968424.0 |
| 2013-01-18 | A6 | Futures | 0.96103 | 0.96213 | 0.95536 | 0.95765 | 81902.0 |
| 2013-01-18 | AD | Futures | 1.01613 | 1.01623 | 1.0067 | 1.00901 | 96176.0 |
| 2013-01-18 | B | Futures | 104.21 | 105.03 | 103.62 | 104.95 | 182511.0 |
| 2013-01-18 | B6 | Futures | 1.6715 | 1.6715 | 1.656 | 1.6573 | 160777.0 |
| 2013-01-18 | BFX | Futures | 3056.0 | 3060.1 | 3056.0 | 3056.7 | 111.0 |
| 2013-01-18 | BR | Futures | 0.23887 | 0.23887 | 0.23865 | 0.23865 | 82.0 |
| 2013-01-18 | BZ | Futures | 106.67 | 107.35 | 105.96 | 107.29 | 5410.0 |
| 2013-01-18 | C | Futures | 1605.0 | 1607.0 | 1583.0 | 1588.0 | 6209.0 |
| 2013-01-18 | CB | Futures | 84.446 | 84.576 | 84.446 | 84.446 | 1.0 |
| 2013-01-18 | CC | Futures | 1732.0 | 1745.0 | 1718.0 | 1724.0 | 9733.0 |
| 2013-01-18 | CSC | Futures | 3.723 | 3.723 | 3.648 | 3.653 | 57.0 |
| 2013-01-18 | CT | Futures | 97.85 | 99.27 | 97.6 | 98.86 | 19323.0 |
| 2013-01-18 | DC | Futures | 27.66 | 27.66 | 27.0 | 27.06 | 361.0 |
| 2013-01-18 | DX | Futures | 76.924 | 77.42 | 76.875 | 77.267 | 26102.0 |
| 2013-01-18 | E1 | Futures | 1.38123 | 1.38471 | 1.37183 | 1.3775 | 43863.0 |
| 2013-01-18 | E6 | Futures | 1.57816 | 1.58088 | 1.56696 | 1.57156 | 297890.0 |
| 2013-01-18 | E7 | Futures | 1.5673 | 1.5701 | 1.5564 | 1.5608 | 5540.0 |
| 2013-01-18 | EBM | Futures | 277.56 | 277.84 | 275.62 | 275.9 | 9089.0 |
| 2013-01-18 | ED | Futures | 95.2151 | 95.2295 | 95.2151 | 95.2199 | 128620.0 |
| 2013-01-18 | ER | Futures | 97.71 | 97.759 | 97.695 | 97.734 | 277538.0 |
| 2013-01-18 | EW | Futures | 1089.0 | 1093.0 | 1086.5 | 1092.0 | 11055.0 |
| 2013-01-18 | FBTP | Futures | 77.32 | 77.6 | 77.07 | 77.42 | 16436.0 |
| 2013-01-18 | FBTS | Futures | 91.891 | 91.976 | 91.806 | 91.933 | 3985.0 |
| 2013-01-18 | FCE | Futures | 2807.5 | 2821.8 | 2802.3 | 2804.9 | 101000.0 |
| 2013-01-18 | FDAX | Futures | 8457.2 | 8471.4 | 8416.8 | 8429.4 | 107262.0 |
| 2013-01-18 | FESX | Futures | 1850.6 | 1858.8 | 1841.1 | 1843.8 | 890226.0 |
| 2013-01-18 | FEU3 | Futures | 98.354 | 98.354 | 98.34 | 98.34 | 1053.0 |
| 2013-01-18 | FGBL | Futures | 117.78 | 118.51 | 117.68 | 118.46 | 851014.0 |
| 2013-01-18 | FGBM | Futures | 115.88 | 116.37 | 115.83 | 116.27 | 700168.0 |
| 2013-01-18 | FGBS | Futures | 110.033 | 110.153 | 109.998 | 110.108 | 692569.0 |
| 2013-01-18 | FGBX | Futures | 123.97 | 125.72 | 123.6 | 125.57 | 13263.0 |
| 2013-01-18 | FOAT | Futures | 104.69 | 105.22 | 104.49 | 105.16 | 24727.0 |
| 2013-01-18 | FTDX | Futures | 823.7 | 826.5 | 821.3 | 825.1 | 490.0 |
| 2013-01-18 | FTI | Futures | 301.36 | 302.65 | 301.02 | 301.15 | 33592.0 |
| 2013-01-18 | FTUK | Futures | 4481.0 | 4511.6 | 4477.0 | 4503.5 | 100659.0 |
| 2013-01-18 | FVSA | Futures | 3148.56 | 3203.0 | 3139.48 | 3203.0 | 3413.0 |
| 2013-01-18 | FXXP | Futures | 206.7 | 207.0 | 206.5 | 206.5 | 3576.0 |
| 2013-01-18 | G | Futures | 96.75 | 97.31 | 96.74 | 97.18 | 151223.0 |
| 2013-01-18 | GF | Futures | 274.073 | 274.633 | 269.822 | 273.419 | 5598.0 |
| 2013-01-18 | GSCI | Futures | 1058.51 | 1064.05 | 1056.58 | 1062.44 | 125.0 |
| 2013-01-18 | HE | Futures | 98.638 | 99.366 | 98.442 | 98.666 | 17306.0 |
| 2013-01-18 | HG | Futures | 4.6981 | 4.7482 | 4.6936 | 4.7244 | 40571.0 |
| 2013-01-18 | HH | Futures | 41.431 | 41.971 | 40.962 | 41.866 | 595.0 |
| 2013-01-18 | HO | Futures | 2.435 | 2.4572 | 2.4231 | 2.454 | 35843.0 |
> showing 50 of 101 rows — these rows as CSV