PREVIEW / futures_daily / 2013-05-22
file: by_date/futures_daily/2013/2013-05-22.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-05-22 | ES | Futures | 1710.16 | 1730.69 | 1690.39 | 1699.63 | 2970647.0 |
| 2013-05-22 | NQ | Futures | 3490.39 | 3527.07 | 3446.5 | 3466.42 | 363785.0 |
| 2013-05-22 | YM | Futures | 15123.1 | 15285.6 | 15007.9 | 15085.7 | 285817.0 |
| 2013-05-22 | CL | Futures | 167.24 | 167.74 | 163.94 | 164.41 | 336497.0 |
| 2013-05-22 | GC | Futures | 1824.7 | 1876.2 | 1796.3 | 1815.3 | 328643.0 |
| 2013-05-22 | ZN | Futures | 117.54547 | 117.879406 | 116.752372 | 116.863684 | 3004542.0 |
| 2013-05-22 | A6 | Futures | 0.90319 | 0.90541 | 0.89018 | 0.89248 | 205427.0 |
| 2013-05-22 | AD | Futures | 0.97783 | 0.97954 | 0.96628 | 0.96738 | 125876.0 |
| 2013-05-22 | B | Futures | 99.6 | 99.86 | 98.35 | 98.72 | 207418.0 |
| 2013-05-22 | B6 | Futures | 1.5853 | 1.5875 | 1.5714 | 1.5733 | 178760.0 |
| 2013-05-22 | BFX | Futures | 3292.4 | 3292.4 | 3283.6 | 3283.6 | 8.0 |
| 2013-05-22 | BR | Futures | 0.242 | 0.24255 | 0.24094 | 0.24163 | 345.0 |
| 2013-05-22 | BZ | Futures | 100.75 | 100.86 | 99.35 | 99.71 | 4718.0 |
| 2013-05-22 | C | Futures | 1681.0 | 1692.0 | 1673.0 | 1676.0 | 7088.0 |
| 2013-05-22 | CB | Futures | 80.859 | 80.966 | 80.512 | 80.847 | 41.0 |
| 2013-05-22 | CC | Futures | 1758.0 | 1760.0 | 1728.0 | 1737.0 | 13955.0 |
| 2013-05-22 | CNH | Futures | 7.1534 | 7.1615 | 7.1492 | 7.1615 | 58.0 |
| 2013-05-22 | CSC | Futures | 3.564 | 3.609 | 3.564 | 3.593 | 3.0 |
| 2013-05-22 | CT | Futures | 100.72 | 101.65 | 99.86 | 99.98 | 14344.0 |
| 2013-05-22 | DC | Futures | 27.27 | 27.54 | 27.19 | 27.49 | 210.0 |
| 2013-05-22 | DX | Futures | 80.601 | 81.221 | 80.269 | 81.172 | 70879.0 |
| 2013-05-22 | E1 | Futures | 1.32603 | 1.32924 | 1.30776 | 1.31329 | 86851.0 |
| 2013-05-22 | E6 | Futures | 1.52191 | 1.53264 | 1.51319 | 1.51425 | 397720.0 |
| 2013-05-22 | E7 | Futures | 1.5119 | 1.5225 | 1.5033 | 1.5044 | 5851.0 |
| 2013-05-22 | ED | Futures | 95.2707 | 95.2731 | 95.2683 | 95.2707 | 165849.0 |
| 2013-05-22 | ER | Futures | 97.832 | 97.837 | 97.827 | 97.832 | 49549.0 |
| 2013-05-22 | EW | Futures | 1237.4 | 1248.2 | 1211.2 | 1216.9 | 36401.0 |
| 2013-05-22 | FBTP | Futures | 80.03 | 80.19 | 79.98 | 80.09 | 24226.0 |
| 2013-05-22 | FBTS | Futures | 93.143 | 93.186 | 93.091 | 93.151 | 7673.0 |
| 2013-05-22 | FCE | Futures | 3109.2 | 3129.7 | 3079.8 | 3121.9 | 124591.0 |
| 2013-05-22 | FDAX | Futures | 9416.7 | 9517.3 | 9378.9 | 9482.9 | 120677.0 |
| 2013-05-22 | FDIV | Futures | 128.35 | 128.79 | 128.35 | 128.79 | 30.0 |
| 2013-05-22 | FESX | Futures | 1970.7 | 1984.7 | 1949.7 | 1977.0 | 1129500.0 |
| 2013-05-22 | FGBL | Futures | 121.24 | 121.7 | 120.91 | 121.19 | 1116981.0 |
| 2013-05-22 | FGBM | Futures | 117.94 | 118.18 | 117.88 | 118.0 | 643494.0 |
| 2013-05-22 | FGBS | Futures | 110.527 | 110.577 | 110.527 | 110.552 | 307082.0 |
| 2013-05-22 | FGBX | Futures | 126.15 | 127.48 | 125.66 | 126.4 | 11965.0 |
| 2013-05-22 | FMWO | Futures | 5004.3 | 5004.3 | 4999.3 | 5004.3 | 44.0 |
| 2013-05-22 | FOAT | Futures | 109.35 | 109.64 | 109.06 | 109.31 | 36275.0 |
| 2013-05-22 | FTDX | Futures | 917.4 | 926.9 | 916.9 | 923.1 | 243.0 |
| 2013-05-22 | FTI | Futures | 322.18 | 324.18 | 320.18 | 323.66 | 24460.0 |
| 2013-05-22 | FTUK | Futures | 5032.1 | 5097.5 | 5013.5 | 5065.2 | 125479.0 |
| 2013-05-22 | FVSA | Futures | 2891.46 | 2899.09 | 2784.65 | 2815.17 | 8893.0 |
| 2013-05-22 | FXXP | Futures | 227.1 | 228.4 | 226.0 | 227.8 | 3726.0 |
| 2013-05-22 | G | Futures | 98.61 | 99.26 | 98.53 | 98.81 | 234493.0 |
| 2013-05-22 | GF | Futures | 246.794 | 247.3 | 242.034 | 243.172 | 2970.0 |
| 2013-05-22 | GSCI | Futures | 1020.57 | 1022.51 | 1011.41 | 1012.47 | 53.0 |
| 2013-05-22 | HE | Futures | 90.961 | 92.8 | 90.74 | 92.751 | 16834.0 |
| 2013-05-22 | HG | Futures | 4.2507 | 4.3545 | 4.25 | 4.3067 | 73350.0 |
| 2013-05-22 | HH | Futures | 46.923 | 47.08 | 46.687 | 47.036 | 1849.0 |
> showing 50 of 104 rows — these rows as CSV