PREVIEW / futures_daily / 2015-01-13
file: by_date/futures_daily/2015/2015-01-13.parquet size: 9 KB rows: 106
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-01-13 | ES | Futures | 2121.15 | 2150.5 | 2097.3 | 2113.03 | 2496445.0 |
| 2015-01-13 | NQ | Futures | 4837.84 | 4928.63 | 4788.23 | 4825.07 | 476645.0 |
| 2015-01-13 | YM | Futures | 17910.9 | 18183.9 | 17737.8 | 17859.0 | 274261.0 |
| 2015-01-13 | CL | Futures | 89.49 | 91.64 | 86.57 | 89.88 | 476541.0 |
| 2015-01-13 | GC | Futures | 1614.0 | 1628.9 | 1606.6 | 1615.7 | 179651.0 |
| 2015-01-13 | ZN | Futures | 121.64551 | 122.057718 | 121.395241 | 121.836893 | 1661473.0 |
| 2015-01-13 | A6 | Futures | 0.79503 | 0.79954 | 0.79258 | 0.79513 | 71651.0 |
| 2015-01-13 | AD | Futures | 0.84947 | 0.85273 | 0.84794 | 0.84998 | 67192.0 |
| 2015-01-13 | ALI | Futures | 2804.72 | 2804.72 | 2804.72 | 2804.72 | 0.0 |
| 2015-01-13 | B | Futures | 49.32 | 49.53 | 47.38 | 48.83 | 400976.0 |
| 2015-01-13 | B6 | Futures | 1.5938 | 1.5967 | 1.5846 | 1.5918 | 112876.0 |
| 2015-01-13 | BFX | Futures | 3944.3 | 4004.6 | 3944.3 | 3992.6 | 49.0 |
| 2015-01-13 | BR | Futures | 0.20612 | 0.2072 | 0.2059 | 0.20701 | 249.0 |
| 2015-01-13 | BZ | Futures | 49.82 | 49.88 | 47.68 | 49.1 | 42754.0 |
| 2015-01-13 | C | Futures | 2249.0 | 2251.0 | 2232.0 | 2239.0 | 5368.0 |
| 2015-01-13 | CB | Futures | 134.727 | 135.138 | 133.906 | 133.906 | 11.0 |
| 2015-01-13 | CC | Futures | 2205.0 | 2225.0 | 2195.0 | 2207.0 | 10210.0 |
| 2015-01-13 | CNH | Futures | 7.0844 | 7.0844 | 7.0783 | 7.0783 | 3.0 |
| 2015-01-13 | CSC | Futures | 4.373 | 4.393 | 4.361 | 4.373 | 28.0 |
| 2015-01-13 | CT | Futures | 76.27 | 76.96 | 76.04 | 76.82 | 10114.0 |
| 2015-01-13 | DC | Futures | 34.15 | 34.48 | 33.87 | 34.06 | 208.0 |
| 2015-01-13 | DX | Futures | 87.227 | 87.681 | 87.104 | 87.56 | 34174.0 |
| 2015-01-13 | E1 | Futures | 1.25891 | 1.26236 | 1.251 | 1.25215 | 41576.0 |
| 2015-01-13 | E6 | Futures | 1.39233 | 1.39574 | 1.38316 | 1.38457 | 185152.0 |
| 2015-01-13 | E7 | Futures | 1.3838 | 1.3874 | 1.375 | 1.3763 | 5537.0 |
| 2015-01-13 | EBM | Futures | 315.09 | 319.95 | 315.09 | 317.11 | 18066.0 |
| 2015-01-13 | ED | Futures | 95.4498 | 95.4594 | 95.4498 | 95.4546 | 205577.0 |
| 2015-01-13 | ER | Futures | 98.028 | 98.033 | 98.028 | 98.028 | 13474.0 |
| 2015-01-13 | EW | Futures | 1497.4 | 1521.2 | 1478.0 | 1491.5 | 28376.0 |
| 2015-01-13 | FBTP | Futures | 99.35 | 99.69 | 99.19 | 99.41 | 81904.0 |
| 2015-01-13 | FBTS | Futures | 98.783 | 98.828 | 98.739 | 98.783 | 16560.0 |
| 2015-01-13 | FCE | Futures | 3440.7 | 3516.5 | 3422.3 | 3497.8 | 109298.0 |
| 2015-01-13 | FDAX | Futures | 10866.0 | 11086.4 | 10831.6 | 11038.1 | 145057.0 |
| 2015-01-13 | FESX | Futures | 2215.5 | 2264.5 | 2204.0 | 2252.3 | 1322658.0 |
| 2015-01-13 | FEU3 | Futures | 98.65 | 98.65 | 98.645 | 98.65 | 211.0 |
| 2015-01-13 | FGBL | Futures | 137.21 | 137.5 | 137.08 | 137.18 | 606258.0 |
| 2015-01-13 | FGBM | Futures | 123.9 | 123.95 | 123.87 | 123.89 | 297515.0 |
| 2015-01-13 | FGBS | Futures | 111.003 | 111.018 | 110.998 | 111.008 | 168167.0 |
| 2015-01-13 | FGBX | Futures | 160.54 | 162.09 | 160.04 | 160.22 | 32220.0 |
| 2015-01-13 | FMWO | Futures | 5537.0 | 5572.9 | 5537.0 | 5567.9 | 327.0 |
| 2015-01-13 | FOAT | Futures | 126.35 | 126.67 | 126.35 | 126.45 | 67690.0 |
| 2015-01-13 | FTDX | Futures | 1332.7 | 1352.4 | 1331.8 | 1347.7 | 151.0 |
| 2015-01-13 | FTI | Futures | 360.61 | 366.75 | 358.1 | 365.58 | 23043.0 |
| 2015-01-13 | FTUK | Futures | 4998.2 | 5064.9 | 4982.6 | 5051.2 | 92540.0 |
| 2015-01-13 | FVSA | Futures | 2143.55 | 2147.85 | 2061.77 | 2070.38 | 8629.0 |
| 2015-01-13 | FXXP | Futures | 256.2 | 260.4 | 254.7 | 259.5 | 9365.0 |
| 2015-01-13 | G | Futures | 104.99 | 105.27 | 104.44 | 104.51 | 181492.0 |
| 2015-01-13 | GF | Futures | 359.535 | 362.361 | 353.125 | 355.824 | 6311.0 |
| 2015-01-13 | GSCI | Futures | 656.67 | 661.84 | 651.85 | 657.62 | 2646.0 |
| 2015-01-13 | HE | Futures | 102.831 | 103.233 | 100.651 | 100.852 | 29047.0 |
> showing 50 of 106 rows — these rows as CSV