PREVIEW / futures_daily / 2013-07-01
file: by_date/futures_daily/2013/2013-07-01.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-07-01 | ES | Futures | 1648.2 | 1669.06 | 1640.99 | 1654.89 | 1551011.0 |
| 2013-07-01 | NQ | Futures | 3357.75 | 3408.65 | 3347.92 | 3374.24 | 200624.0 |
| 2013-07-01 | YM | Futures | 14701.8 | 14879.3 | 14660.2 | 14750.4 | 140989.0 |
| 2013-07-01 | CL | Futures | 168.23 | 171.19 | 167.34 | 170.69 | 229193.0 |
| 2013-07-01 | GC | Futures | 1636.7 | 1674.9 | 1625.0 | 1667.0 | 204048.0 |
| 2013-07-01 | ZN | Futures | 113.531484 | 113.812224 | 113.166521 | 113.671854 | 852394.0 |
| 2013-07-01 | A6 | Futures | 0.8524 | 0.86348 | 0.85109 | 0.86122 | 95200.0 |
| 2013-07-01 | AD | Futures | 0.95585 | 0.95898 | 0.95464 | 0.95757 | 49860.0 |
| 2013-07-01 | B | Futures | 98.87 | 100.38 | 98.45 | 99.68 | 119458.0 |
| 2013-07-01 | B6 | Futures | 1.5941 | 1.5981 | 1.5911 | 1.5936 | 80183.0 |
| 2013-07-01 | BFX | Futures | 3035.3 | 3056.9 | 3035.3 | 3041.5 | 8.0 |
| 2013-07-01 | BR | Futures | 0.21895 | 0.22029 | 0.21843 | 0.2194 | 139.0 |
| 2013-07-01 | BZ | Futures | 99.53 | 101.03 | 99.53 | 100.35 | 9744.0 |
| 2013-07-01 | C | Futures | 1544.0 | 1544.0 | 1524.0 | 1536.0 | 2995.0 |
| 2013-07-01 | CB | Futures | 73.91 | 75.573 | 73.91 | 75.333 | 32.0 |
| 2013-07-01 | CC | Futures | 1619.0 | 1619.0 | 1598.0 | 1613.0 | 14951.0 |
| 2013-07-01 | CSC | Futures | 3.475 | 3.528 | 3.459 | 3.528 | 32.0 |
| 2013-07-01 | CT | Futures | 101.43 | 103.52 | 101.43 | 103.52 | 9.0 |
| 2013-07-01 | DC | Futures | 26.41 | 27.0 | 26.41 | 26.97 | 281.0 |
| 2013-07-01 | DX | Futures | 79.715 | 79.772 | 79.49 | 79.565 | 25010.0 |
| 2013-07-01 | E1 | Futures | 1.36116 | 1.3627 | 1.35332 | 1.35987 | 25296.0 |
| 2013-07-01 | E6 | Futures | 1.5358 | 1.54264 | 1.53521 | 1.54158 | 189879.0 |
| 2013-07-01 | E7 | Futures | 1.5253 | 1.5325 | 1.5253 | 1.5315 | 2315.0 |
| 2013-07-01 | ED | Futures | 95.2678 | 95.2678 | 95.2582 | 95.263 | 105340.0 |
| 2013-07-01 | ER | Futures | 97.798 | 97.817 | 97.778 | 97.788 | 61385.0 |
| 2013-07-01 | EW | Futures | 1179.5 | 1199.3 | 1174.8 | 1191.6 | 24743.0 |
| 2013-07-01 | FBTP | Futures | 76.64 | 77.19 | 76.36 | 76.88 | 23934.0 |
| 2013-07-01 | FBTS | Futures | 92.258 | 92.507 | 92.232 | 92.421 | 5306.0 |
| 2013-07-01 | FCE | Futures | 2894.2 | 2936.5 | 2887.3 | 2920.6 | 101064.0 |
| 2013-07-01 | FDAX | Futures | 8830.1 | 8911.1 | 8760.1 | 8858.9 | 115715.0 |
| 2013-07-01 | FESX | Futures | 1822.9 | 1848.1 | 1814.5 | 1836.2 | 819128.0 |
| 2013-07-01 | FGBL | Futures | 118.31 | 118.62 | 118.06 | 118.55 | 498871.0 |
| 2013-07-01 | FGBM | Futures | 116.47 | 116.6 | 116.3 | 116.57 | 372620.0 |
| 2013-07-01 | FGBS | Futures | 110.188 | 110.203 | 110.133 | 110.178 | 260071.0 |
| 2013-07-01 | FGBX | Futures | 122.71 | 123.54 | 122.46 | 123.44 | 8134.0 |
| 2013-07-01 | FMWO | Futures | 4755.9 | 4755.9 | 4755.9 | 4755.9 | 0.0 |
| 2013-07-01 | FOAT | Futures | 105.43 | 105.73 | 105.23 | 105.66 | 28686.0 |
| 2013-07-01 | FTDX | Futures | 891.5 | 899.5 | 889.1 | 897.6 | 95.0 |
| 2013-07-01 | FTI | Futures | 299.6 | 304.0 | 298.86 | 302.61 | 29638.0 |
| 2013-07-01 | FTUK | Futures | 4623.8 | 4702.9 | 4616.3 | 4688.7 | 94911.0 |
| 2013-07-01 | FVSA | Futures | 3277.07 | 3410.23 | 3240.08 | 3291.87 | 2734.0 |
| 2013-07-01 | FXXP | Futures | 210.7 | 212.1 | 208.8 | 211.2 | 5187.0 |
| 2013-07-01 | G | Futures | 94.33 | 94.55 | 93.83 | 94.49 | 124337.0 |
| 2013-07-01 | GF | Futures | 252.565 | 254.882 | 252.523 | 254.797 | 3300.0 |
| 2013-07-01 | GSCI | Futures | 1013.1 | 1016.97 | 1011.62 | 1012.36 | 190.0 |
| 2013-07-01 | HE | Futures | 100.878 | 101.73 | 99.948 | 100.206 | 25444.0 |
| 2013-07-01 | HG | Futures | 3.8636 | 4.0279 | 3.8484 | 4.0057 | 67631.0 |
| 2013-07-01 | HH | Futures | 40.022 | 40.134 | 39.409 | 39.844 | 1707.0 |
| 2013-07-01 | HO | Futures | 2.2995 | 2.3332 | 2.2924 | 2.3121 | 17794.0 |
| 2013-07-01 | HRC | Futures | 2193.2 | 2193.2 | 2193.2 | 2193.2 | 0.0 |
> showing 50 of 101 rows — these rows as CSV