PREVIEW / futures_daily / 2013-04-08
file: by_date/futures_daily/2013/2013-04-08.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-04-08 | ES | Futures | 1586.7 | 1604.41 | 1584.14 | 1600.82 | 1444510.0 |
| 2013-04-08 | NQ | Futures | 3191.8 | 3220.68 | 3184.58 | 3212.3 | 176139.0 |
| 2013-04-08 | YM | Futures | 14257.6 | 14364.9 | 14211.3 | 14340.3 | 118391.0 |
| 2013-04-08 | CL | Futures | 162.36 | 163.63 | 161.38 | 162.95 | 212117.0 |
| 2013-04-08 | GC | Futures | 2098.5 | 2101.3 | 2079.7 | 2087.5 | 111703.0 |
| 2013-04-08 | ZN | Futures | 118.491622 | 118.58902 | 118.199428 | 118.31074 | 1005707.0 |
| 2013-04-08 | A6 | Futures | 0.95248 | 0.95719 | 0.95017 | 0.9559 | 84598.0 |
| 2013-04-08 | AD | Futures | 0.98637 | 0.98768 | 0.98205 | 0.98577 | 59054.0 |
| 2013-04-08 | B | Futures | 100.15 | 101.67 | 99.8 | 100.89 | 247712.0 |
| 2013-04-08 | B6 | Futures | 1.6038 | 1.6058 | 1.5939 | 1.5954 | 96787.0 |
| 2013-04-08 | BFX | Futures | 3070.1 | 3070.1 | 3054.5 | 3057.4 | 21.0 |
| 2013-04-08 | BR | Futures | 0.24849 | 0.24849 | 0.24685 | 0.24723 | 389.0 |
| 2013-04-08 | BZ | Futures | 101.84 | 102.9 | 101.05 | 102.13 | 4504.0 |
| 2013-04-08 | C | Futures | 1511.0 | 1561.0 | 1510.0 | 1559.0 | 11372.0 |
| 2013-04-08 | CB | Futures | 87.515 | 88.254 | 87.515 | 88.254 | 3.0 |
| 2013-04-08 | CC | Futures | 1614.0 | 1659.0 | 1607.0 | 1654.0 | 19808.0 |
| 2013-04-08 | CNH | Futures | 7.2532 | 7.2539 | 7.2468 | 7.2493 | 20.0 |
| 2013-04-08 | CSC | Futures | 3.845 | 3.865 | 3.835 | 3.865 | 26.0 |
| 2013-04-08 | CT | Futures | 106.77 | 107.51 | 104.84 | 105.04 | 27697.0 |
| 2013-04-08 | DC | Futures | 29.5 | 29.76 | 29.5 | 29.62 | 230.0 |
| 2013-04-08 | DX | Futures | 79.529 | 79.726 | 79.39 | 79.644 | 19373.0 |
| 2013-04-08 | E1 | Futures | 1.3789 | 1.38005 | 1.37504 | 1.37594 | 26986.0 |
| 2013-04-08 | E6 | Futures | 1.53252 | 1.53783 | 1.52969 | 1.5337 | 185838.0 |
| 2013-04-08 | E7 | Futures | 1.5232 | 1.5278 | 1.5197 | 1.5237 | 2801.0 |
| 2013-04-08 | EBM | Futures | 285.84 | 288.76 | 285.55 | 286.43 | 13305.0 |
| 2013-04-08 | ED | Futures | 95.2492 | 95.2492 | 95.2349 | 95.2444 | 60191.0 |
| 2013-04-08 | ER | Futures | 97.813 | 97.822 | 97.783 | 97.803 | 131169.0 |
| 2013-04-08 | EW | Futures | 1143.2 | 1157.3 | 1140.0 | 1155.3 | 14494.0 |
| 2013-04-08 | FBTP | Futures | 76.81 | 77.4 | 76.72 | 77.01 | 36210.0 |
| 2013-04-08 | FBTS | Futures | 92.013 | 92.158 | 91.996 | 92.03 | 4592.0 |
| 2013-04-08 | FCE | Futures | 2761.5 | 2782.9 | 2758.1 | 2763.7 | 83131.0 |
| 2013-04-08 | FDAX | Futures | 8530.7 | 8571.3 | 8512.3 | 8521.2 | 88529.0 |
| 2013-04-08 | FESX | Futures | 1763.7 | 1777.7 | 1763.0 | 1764.4 | 670645.0 |
| 2013-04-08 | FEU3 | Futures | 98.413 | 98.413 | 98.404 | 98.404 | 97.0 |
| 2013-04-08 | FGBL | Futures | 122.63 | 122.65 | 122.24 | 122.43 | 598166.0 |
| 2013-04-08 | FGBM | Futures | 118.33 | 118.37 | 118.17 | 118.22 | 363392.0 |
| 2013-04-08 | FGBS | Futures | 110.512 | 110.517 | 110.462 | 110.492 | 276550.0 |
| 2013-04-08 | FGBX | Futures | 131.7 | 132.23 | 131.14 | 131.51 | 15210.0 |
| 2013-04-08 | FMWO | Futures | 4630.2 | 4630.2 | 4630.2 | 4630.2 | 0.0 |
| 2013-04-08 | FOAT | Futures | 109.35 | 109.76 | 109.25 | 109.43 | 41357.0 |
| 2013-04-08 | FTDX | Futures | 860.1 | 868.7 | 860.1 | 863.5 | 113.0 |
| 2013-04-08 | FTI | Futures | 293.64 | 294.54 | 292.82 | 293.34 | 24286.0 |
| 2013-04-08 | FTUK | Futures | 4630.6 | 4642.8 | 4609.0 | 4620.9 | 74004.0 |
| 2013-04-08 | FVSA | Futures | 3497.24 | 3614.38 | 3488.88 | 3505.61 | 5308.0 |
| 2013-04-08 | FXXP | Futures | 207.9 | 209.1 | 207.8 | 207.8 | 4700.0 |
| 2013-04-08 | G | Futures | 100.81 | 100.81 | 100.25 | 100.33 | 118529.0 |
| 2013-04-08 | GF | Futures | 261.938 | 263.73 | 261.386 | 262.351 | 1630.0 |
| 2013-04-08 | GSCI | Futures | 1017.34 | 1017.82 | 1008.99 | 1016.61 | 2868.0 |
| 2013-04-08 | HE | Futures | 87.494 | 88.123 | 87.443 | 87.897 | 725.0 |
| 2013-04-08 | HG | Futures | 4.2631 | 4.33 | 4.2599 | 4.3007 | 54318.0 |
> showing 50 of 104 rows — these rows as CSV