PREVIEW / futures_daily / 2013-06-05
file: by_date/futures_daily/2013/2013-06-05.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-06-05 | ES | Futures | 1672.69 | 1675.77 | 1648.3 | 1650.87 | 2648546.0 |
| 2013-06-05 | NQ | Futures | 3431.48 | 3439.57 | 3386.72 | 3394.23 | 302592.0 |
| 2013-06-05 | YM | Futures | 14937.0 | 14956.7 | 14704.6 | 14730.2 | 253308.0 |
| 2013-06-05 | CL | Futures | 163.68 | 164.76 | 162.9 | 163.47 | 268909.0 |
| 2013-06-05 | GC | Futures | 1856.9 | 1872.2 | 1852.0 | 1856.5 | 139655.0 |
| 2013-06-05 | ZN | Futures | 116.01493 | 116.599318 | 115.973188 | 116.265382 | 102955.0 |
| 2013-06-05 | A6 | Futures | 0.88981 | 0.89073 | 0.87716 | 0.87845 | 163029.0 |
| 2013-06-05 | AD | Futures | 0.9713 | 0.97271 | 0.96768 | 0.9706 | 68313.0 |
| 2013-06-05 | B | Futures | 99.6 | 100.33 | 99.15 | 99.34 | 124750.0 |
| 2013-06-05 | B6 | Futures | 1.6022 | 1.6124 | 1.5999 | 1.6115 | 143513.0 |
| 2013-06-05 | BR | Futures | 0.23215 | 0.23217 | 0.2266 | 0.22794 | 85.0 |
| 2013-06-05 | BZ | Futures | 100.03 | 100.8 | 99.67 | 99.84 | 6453.0 |
| 2013-06-05 | C | Futures | 1639.0 | 1668.0 | 1634.0 | 1665.0 | 13503.0 |
| 2013-06-05 | CB | Futures | 78.933 | 78.933 | 78.933 | 78.933 | 15.0 |
| 2013-06-05 | CC | Futures | 1704.0 | 1728.0 | 1702.0 | 1727.0 | 20671.0 |
| 2013-06-05 | CNH | Futures | 7.1501 | 7.1506 | 7.1467 | 7.1506 | 30.0 |
| 2013-06-05 | CSC | Futures | 3.534 | 3.566 | 3.528 | 3.566 | 7.0 |
| 2013-06-05 | CT | Futures | 101.21 | 101.57 | 99.77 | 100.1 | 15883.0 |
| 2013-06-05 | DC | Futures | 27.15 | 27.42 | 26.95 | 27.38 | 139.0 |
| 2013-06-05 | DX | Futures | 79.63 | 79.683 | 79.294 | 79.397 | 42714.0 |
| 2013-06-05 | E1 | Futures | 1.35883 | 1.36989 | 1.3551 | 1.36616 | 49239.0 |
| 2013-06-05 | E6 | Futures | 1.54254 | 1.54655 | 1.539 | 1.54289 | 250417.0 |
| 2013-06-05 | E7 | Futures | 1.5325 | 1.5365 | 1.5291 | 1.5328 | 3543.0 |
| 2013-06-05 | ED | Futures | 95.2683 | 95.2707 | 95.2659 | 95.2683 | 96636.0 |
| 2013-06-05 | ER | Futures | 97.827 | 97.832 | 97.827 | 97.827 | 29562.0 |
| 2013-06-05 | EW | Futures | 1195.7 | 1196.5 | 1177.6 | 1180.1 | 24882.0 |
| 2013-06-05 | FBTP | Futures | 79.05 | 79.31 | 78.92 | 79.08 | 48877.0 |
| 2013-06-05 | FBTS | Futures | 93.031 | 93.1 | 92.937 | 92.988 | 12006.0 |
| 2013-06-05 | FCE | Futures | 3011.3 | 3026.7 | 2967.5 | 2978.0 | 142050.0 |
| 2013-06-05 | FDAX | Futures | 9164.9 | 9223.3 | 9077.1 | 9123.2 | 132978.0 |
| 2013-06-05 | FDIV | Futures | 124.67 | 124.67 | 124.02 | 124.02 | 60.0 |
| 2013-06-05 | FESX | Futures | 1908.5 | 1925.3 | 1887.5 | 1895.9 | 1139738.0 |
| 2013-06-05 | FEU3 | Futures | 98.433 | 98.433 | 98.428 | 98.428 | 46.0 |
| 2013-06-05 | FGBL | Futures | 120.15 | 120.46 | 119.95 | 120.39 | 1017434.0 |
| 2013-06-05 | FGBM | Futures | 117.43 | 117.66 | 117.39 | 117.59 | 892333.0 |
| 2013-06-05 | FGBS | Futures | 110.323 | 110.392 | 110.323 | 110.362 | 536180.0 |
| 2013-06-05 | FGBX | Futures | 124.84 | 125.99 | 124.82 | 125.7 | 21492.0 |
| 2013-06-05 | FMWO | Futures | 4762.1 | 4762.1 | 4758.3 | 4758.3 | 20.0 |
| 2013-06-05 | FOAT | Futures | 107.69 | 108.02 | 107.66 | 107.97 | 101926.0 |
| 2013-06-05 | FTDX | Futures | 906.5 | 907.5 | 890.9 | 899.0 | 67.0 |
| 2013-06-05 | FTI | Futures | 310.66 | 312.62 | 305.66 | 307.18 | 39262.0 |
| 2013-06-05 | FTUK | Futures | 4841.2 | 4844.5 | 4742.0 | 4765.4 | 120014.0 |
| 2013-06-05 | FVSA | Futures | 3143.22 | 3288.18 | 3120.33 | 3280.55 | 7846.0 |
| 2013-06-05 | FXXP | Futures | 218.5 | 219.8 | 216.6 | 216.9 | 6583.0 |
| 2013-06-05 | G | Futures | 97.4 | 97.64 | 97.16 | 97.54 | 181607.0 |
| 2013-06-05 | GF | Futures | 245.741 | 246.12 | 243.635 | 243.635 | 1745.0 |
| 2013-06-05 | GSCI | Futures | 1017.89 | 1022.02 | 1012.87 | 1013.68 | 190.0 |
| 2013-06-05 | HE | Futures | 94.379 | 94.628 | 93.781 | 94.204 | 18129.0 |
| 2013-06-05 | HG | Futures | 4.2883 | 4.329 | 4.2666 | 4.2953 | 53063.0 |
| 2013-06-05 | HH | Futures | 44.732 | 45.092 | 44.665 | 44.957 | 2404.0 |
> showing 50 of 104 rows — these rows as CSV