PREVIEW / futures_daily / 2015-05-06
file: by_date/futures_daily/2015/2015-05-06.parquet size: 9 KB rows: 108
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-06 | ES | Futures | 2192.83 | 2201.5 | 2167.33 | 2181.0 | 1756254.0 |
| 2015-05-06 | NQ | Futures | 5118.99 | 5135.83 | 5040.62 | 5077.19 | 335134.0 |
| 2015-05-06 | YM | Futures | 18283.6 | 18384.9 | 18071.9 | 18184.4 | 209550.0 |
| 2015-05-06 | CL | Futures | 103.1 | 106.26 | 102.8 | 103.46 | 423583.0 |
| 2015-05-06 | GC | Futures | 1560.4 | 1566.1 | 1553.7 | 1557.5 | 105946.0 |
| 2015-05-06 | ZN | Futures | 120.665746 | 120.754547 | 120.206941 | 120.384542 | 1614071.0 |
| 2015-05-06 | A6 | Futures | 0.78169 | 0.79037 | 0.77932 | 0.78396 | 114894.0 |
| 2015-05-06 | AD | Futures | 0.84569 | 0.85468 | 0.84436 | 0.84712 | 64639.0 |
| 2015-05-06 | ALI | Futures | 2609.16 | 2609.16 | 2609.16 | 2609.16 | 0.0 |
| 2015-05-06 | B | Futures | 65.14 | 66.97 | 64.77 | 65.18 | 182444.0 |
| 2015-05-06 | B6 | Futures | 1.5976 | 1.6093 | 1.5942 | 1.604 | 116973.0 |
| 2015-05-06 | BFX | Futures | 4364.4 | 4364.4 | 4353.4 | 4353.4 | 3.0 |
| 2015-05-06 | BR | Futures | 0.1834 | 0.18688 | 0.1834 | 0.18531 | 933.0 |
| 2015-05-06 | BZ | Futures | 64.72 | 66.26 | 64.18 | 64.55 | 13722.0 |
| 2015-05-06 | C | Futures | 2185.0 | 2192.0 | 2170.0 | 2173.0 | 3083.0 |
| 2015-05-06 | CB | Futures | 155.761 | 158.593 | 155.761 | 157.379 | 31.0 |
| 2015-05-06 | CC | Futures | 2167.0 | 2180.0 | 2148.0 | 2153.0 | 15053.0 |
| 2015-05-06 | CNH | Futures | 6.9929 | 6.9941 | 6.9845 | 6.9867 | 20.0 |
| 2015-05-06 | CSC | Futures | 4.626 | 4.626 | 4.57 | 4.602 | 47.0 |
| 2015-05-06 | CT | Futures | 83.56 | 84.0 | 82.6 | 82.96 | 12895.0 |
| 2015-05-06 | DC | Futures | 37.47 | 38.19 | 37.42 | 37.96 | 462.0 |
| 2015-05-06 | DX | Futures | 89.484 | 89.526 | 88.226 | 88.428 | 77820.0 |
| 2015-05-06 | E1 | Futures | 1.37827 | 1.40032 | 1.37522 | 1.39395 | 26536.0 |
| 2015-05-06 | E6 | Futures | 1.31622 | 1.33785 | 1.31481 | 1.3355 | 384584.0 |
| 2015-05-06 | E7 | Futures | 1.3085 | 1.33 | 1.3072 | 1.3278 | 9970.0 |
| 2015-05-06 | EBM | Futures | 280.77 | 284.46 | 280.77 | 284.05 | 9607.0 |
| 2015-05-06 | ED | Futures | 95.5429 | 95.5525 | 95.5381 | 95.5477 | 205654.0 |
| 2015-05-06 | ER | Futures | 98.068 | 98.077 | 98.063 | 98.068 | 62870.0 |
| 2015-05-06 | EW | Futures | 1569.8 | 1577.3 | 1560.4 | 1568.8 | 18574.0 |
| 2015-05-06 | FBTP | Futures | 99.35 | 100.2 | 98.23 | 98.62 | 211683.0 |
| 2015-05-06 | FBTS | Futures | 99.581 | 99.661 | 99.439 | 99.581 | 41590.0 |
| 2015-05-06 | FCE | Futures | 4076.5 | 4094.6 | 4029.6 | 4068.7 | 139872.0 |
| 2015-05-06 | FDAX | Futures | 12636.8 | 12731.6 | 12483.7 | 12615.7 | 131413.0 |
| 2015-05-06 | FDIV | Futures | 155.98 | 156.44 | 155.1 | 156.03 | 16.0 |
| 2015-05-06 | FESX | Futures | 2587.8 | 2607.7 | 2562.8 | 2587.8 | 1312502.0 |
| 2015-05-06 | FEU3 | Futures | 98.71 | 98.715 | 98.71 | 98.715 | 547.0 |
| 2015-05-06 | FGBL | Futures | 137.47 | 137.68 | 136.55 | 136.75 | 1301171.0 |
| 2015-05-06 | FGBM | Futures | 123.98 | 124.05 | 123.75 | 123.8 | 842659.0 |
| 2015-05-06 | FGBS | Futures | 111.198 | 111.213 | 111.188 | 111.203 | 312182.0 |
| 2015-05-06 | FGBX | Futures | 164.78 | 164.85 | 159.69 | 160.66 | 60457.0 |
| 2015-05-06 | FMWO | Futures | 5860.6 | 5869.3 | 5845.8 | 5845.8 | 48.0 |
| 2015-05-06 | FOAT | Futures | 126.08 | 126.49 | 125.15 | 125.4 | 153719.0 |
| 2015-05-06 | FTDX | Futures | 1501.6 | 1507.7 | 1484.7 | 1491.8 | 636.0 |
| 2015-05-06 | FTI | Futures | 418.95 | 419.52 | 411.46 | 413.94 | 40568.0 |
| 2015-05-06 | FTUK | Futures | 5449.5 | 5470.0 | 5408.1 | 5438.5 | 107170.0 |
| 2015-05-06 | FVSA | Futures | 1832.08 | 1895.39 | 1820.2 | 1851.86 | 21912.0 |
| 2015-05-06 | FXXP | Futures | 298.6 | 299.0 | 294.0 | 296.3 | 15060.0 |
| 2015-05-06 | G | Futures | 101.67 | 102.2 | 101.39 | 101.7 | 265365.0 |
| 2015-05-06 | GF | Futures | 370.08 | 370.681 | 367.975 | 368.619 | 1450.0 |
| 2015-05-06 | GSCI | Futures | 776.12 | 778.76 | 764.97 | 767.1 | 835.0 |
> showing 50 of 108 rows — these rows as CSV