PREVIEW / futures_daily / 2013-06-21
file: by_date/futures_daily/2013/2013-06-21.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 |
|---|---|---|---|---|---|---|---|
| 2013-06-21 | ES | Futures | 1631.72 | 1645.11 | 1617.56 | 1631.46 | 2982380.0 |
| 2013-06-21 | NQ | Futures | 3331.73 | 3353.71 | 3292.11 | 3314.09 | 399203.0 |
| 2013-06-21 | YM | Futures | 14574.0 | 14670.1 | 14479.8 | 14580.9 | 262577.0 |
| 2013-06-21 | CL | Futures | 165.41 | 166.94 | 162.2 | 163.2 | 340903.0 |
| 2013-06-21 | GC | Futures | 1696.0 | 1728.0 | 1684.2 | 1715.2 | 190154.0 |
| 2013-06-21 | ZN | Futures | 114.16315 | 114.429853 | 113.208632 | 113.433224 | 1891970.0 |
| 2013-06-21 | A6 | Futures | 0.85813 | 0.86329 | 0.85616 | 0.86226 | 120875.0 |
| 2013-06-21 | AD | Futures | 0.96855 | 0.97016 | 0.95857 | 0.96139 | 111907.0 |
| 2013-06-21 | B | Futures | 98.73 | 99.69 | 96.74 | 97.58 | 263371.0 |
| 2013-06-21 | B6 | Futures | 1.6247 | 1.6276 | 1.6105 | 1.6168 | 131906.0 |
| 2013-06-21 | BR | Futures | 0.21668 | 0.21828 | 0.21519 | 0.21767 | 1489.0 |
| 2013-06-21 | BZ | Futures | 99.17 | 100.19 | 97.26 | 98.07 | 7294.0 |
| 2013-06-21 | C | Futures | 1519.0 | 1525.0 | 1512.0 | 1524.0 | 4383.0 |
| 2013-06-21 | CB | Futures | 77.546 | 77.606 | 76.565 | 76.9 | 21.0 |
| 2013-06-21 | CC | Futures | 1614.0 | 1624.0 | 1603.0 | 1607.0 | 13146.0 |
| 2013-06-21 | CNH | Futures | 7.1538 | 7.1674 | 7.1538 | 7.1621 | 2.0 |
| 2013-06-21 | CSC | Futures | 3.515 | 3.518 | 3.509 | 3.509 | 14.0 |
| 2013-06-21 | CT | Futures | 101.28 | 102.58 | 100.92 | 102.05 | 5810.0 |
| 2013-06-21 | DC | Futures | 26.87 | 26.89 | 26.8 | 26.83 | 160.0 |
| 2013-06-21 | DX | Futures | 78.281 | 79.079 | 78.143 | 78.861 | 53829.0 |
| 2013-06-21 | E1 | Futures | 1.38725 | 1.39188 | 1.37298 | 1.37722 | 32747.0 |
| 2013-06-21 | E6 | Futures | 1.56141 | 1.56483 | 1.54642 | 1.55138 | 274016.0 |
| 2013-06-21 | E7 | Futures | 1.551 | 1.5546 | 1.5363 | 1.5413 | 4834.0 |
| 2013-06-21 | ED | Futures | 95.2678 | 95.2773 | 95.2295 | 95.2534 | 338876.0 |
| 2013-06-21 | ER | Futures | 97.783 | 97.798 | 97.734 | 97.754 | 212034.0 |
| 2013-06-21 | EW | Futures | 1159.0 | 1163.3 | 1143.8 | 1153.2 | 37270.0 |
| 2013-06-21 | FBTP | Futures | 76.31 | 76.87 | 75.98 | 76.25 | 43664.0 |
| 2013-06-21 | FBTS | Futures | 92.163 | 92.352 | 92.051 | 92.137 | 7532.0 |
| 2013-06-21 | FCE | Futures | 2867.1 | 2898.5 | 2826.7 | 2832.5 | 183316.0 |
| 2013-06-21 | FDAX | Futures | 8810.1 | 8868.4 | 8632.5 | 8688.0 | 158404.0 |
| 2013-06-21 | FDIV | Futures | 119.95 | 119.95 | 118.11 | 118.11 | 5.0 |
| 2013-06-21 | FESX | Futures | 1810.3 | 1829.2 | 1778.7 | 1789.9 | 1590665.0 |
| 2013-06-21 | FEU3 | Futures | 98.384 | 98.384 | 98.364 | 98.364 | 300.0 |
| 2013-06-21 | FGBL | Futures | 118.85 | 118.97 | 118.12 | 118.39 | 914565.0 |
| 2013-06-21 | FGBM | Futures | 116.34 | 116.51 | 116.04 | 116.19 | 665573.0 |
| 2013-06-21 | FGBS | Futures | 110.063 | 110.128 | 110.008 | 110.053 | 526505.0 |
| 2013-06-21 | FGBX | Futures | 123.17 | 123.59 | 122.44 | 122.85 | 21855.0 |
| 2013-06-21 | FMWO | Futures | 4664.7 | 4697.6 | 4633.0 | 4633.0 | 100.0 |
| 2013-06-21 | FOAT | Futures | 106.03 | 106.11 | 105.48 | 105.58 | 53490.0 |
| 2013-06-21 | FTDX | Futures | 876.4 | 883.0 | 867.9 | 870.3 | 126.0 |
| 2013-06-21 | FTI | Futures | 297.6 | 300.99 | 293.76 | 294.42 | 47156.0 |
| 2013-06-21 | FTUK | Futures | 4558.1 | 4647.0 | 4537.9 | 4557.4 | 156140.0 |
| 2013-06-21 | FVSA | Futures | 3388.03 | 3550.78 | 3328.85 | 3543.38 | 11229.0 |
| 2013-06-21 | FXXP | Futures | 208.5 | 210.1 | 205.1 | 205.6 | 8959.0 |
| 2013-06-21 | G | Futures | 95.13 | 95.38 | 94.3 | 94.52 | 199970.0 |
| 2013-06-21 | GF | Futures | 242.413 | 247.594 | 242.119 | 247.552 | 3988.0 |
| 2013-06-21 | GSCI | Futures | 1016.89 | 1016.89 | 1000.68 | 1003.31 | 730.0 |
| 2013-06-21 | HE | Futures | 99.434 | 99.658 | 98.836 | 99.359 | 7986.0 |
| 2013-06-21 | HG | Futures | 3.8763 | 3.948 | 3.8408 | 3.9334 | 31834.0 |
| 2013-06-21 | HH | Futures | 43.283 | 43.328 | 42.327 | 42.372 | 3289.0 |
> showing 50 of 103 rows — these rows as CSV