PREVIEW / futures_daily / 2015-05-27
file: by_date/futures_daily/2015/2015-05-27.parquet size: 9 KB rows: 107
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-05-27 | ES | Futures | 2214.12 | 2233.57 | 2209.39 | 2230.15 | 1290556.0 |
| 2015-05-27 | NQ | Futures | 5203.17 | 5283.86 | 5193.3 | 5273.7 | 198538.0 |
| 2015-05-27 | YM | Futures | 18464.7 | 18582.3 | 18438.1 | 18555.7 | 117045.0 |
| 2015-05-27 | CL | Futures | 98.01 | 99.07 | 96.39 | 96.65 | 314917.0 |
| 2015-05-27 | GC | Futures | 1550.9 | 1555.8 | 1546.2 | 1549.6 | 151427.0 |
| 2015-05-27 | ZN | Futures | 121.139351 | 121.198552 | 120.843348 | 121.139351 | 2737708.0 |
| 2015-05-27 | A6 | Futures | 0.76197 | 0.76542 | 0.75773 | 0.76059 | 70360.0 |
| 2015-05-27 | AD | Futures | 0.82088 | 0.82343 | 0.8171 | 0.81853 | 65523.0 |
| 2015-05-27 | ALI | Futures | 2362.61 | 2362.61 | 2362.61 | 2362.61 | 15.0 |
| 2015-05-27 | B | Futures | 60.68 | 61.37 | 58.87 | 58.95 | 114968.0 |
| 2015-05-27 | B6 | Futures | 1.6189 | 1.6247 | 1.6104 | 1.6141 | 96620.0 |
| 2015-05-27 | BFX | Futures | 4494.7 | 4540.6 | 4494.7 | 4540.6 | 8.0 |
| 2015-05-27 | BR | Futures | 0.18306 | 0.18444 | 0.18258 | 0.18444 | 375.0 |
| 2015-05-27 | BZ | Futures | 60.84 | 61.46 | 59.0 | 59.07 | 13094.0 |
| 2015-05-27 | C | Futures | 2288.0 | 2300.0 | 2274.0 | 2297.0 | 6362.0 |
| 2015-05-27 | CB | Futures | 158.285 | 161.284 | 158.285 | 160.635 | 9.0 |
| 2015-05-27 | CC | Futures | 2324.0 | 2327.0 | 2296.0 | 2312.0 | 16137.0 |
| 2015-05-27 | CSC | Futures | 4.569 | 4.569 | 4.559 | 4.566 | 19.0 |
| 2015-05-27 | CT | Futures | 79.76 | 80.48 | 79.4 | 79.42 | 16891.0 |
| 2015-05-27 | DC | Futures | 37.17 | 37.62 | 37.17 | 37.49 | 50.0 |
| 2015-05-27 | DX | Futures | 91.376 | 91.906 | 91.085 | 91.525 | 55132.0 |
| 2015-05-27 | E1 | Futures | 1.33762 | 1.34692 | 1.33596 | 1.34017 | 21110.0 |
| 2015-05-27 | E6 | Futures | 1.27894 | 1.28553 | 1.27247 | 1.28082 | 322754.0 |
| 2015-05-27 | E7 | Futures | 1.2718 | 1.278 | 1.265 | 1.2734 | 7022.0 |
| 2015-05-27 | EBM | Futures | 295.12 | 295.12 | 291.84 | 293.07 | 10926.0 |
| 2015-05-27 | ED | Futures | 95.5549 | 95.5597 | 95.5525 | 95.5573 | 103832.0 |
| 2015-05-27 | ER | Futures | 98.077 | 98.082 | 98.073 | 98.077 | 50255.0 |
| 2015-05-27 | EW | Futures | 1598.5 | 1613.0 | 1596.0 | 1612.4 | 15833.0 |
| 2015-05-27 | FBTP | Futures | 99.09 | 99.69 | 98.82 | 99.62 | 114272.0 |
| 2015-05-27 | FBTS | Futures | 99.759 | 99.803 | 99.741 | 99.777 | 19313.0 |
| 2015-05-27 | FCE | Futures | 4213.0 | 4296.1 | 4204.7 | 4284.8 | 122382.0 |
| 2015-05-27 | FDAX | Futures | 12933.5 | 13095.5 | 12872.5 | 13070.0 | 104599.0 |
| 2015-05-27 | FDIV | Futures | 158.53 | 159.5 | 158.29 | 159.5 | 45.0 |
| 2015-05-27 | FESX | Futures | 2667.4 | 2713.8 | 2658.6 | 2707.9 | 1100545.0 |
| 2015-05-27 | FEU3 | Futures | 98.72 | 98.72 | 98.72 | 98.72 | 2.0 |
| 2015-05-27 | FGBL | Futures | 137.45 | 137.84 | 137.14 | 137.45 | 712914.0 |
| 2015-05-27 | FGBM | Futures | 124.16 | 124.25 | 124.07 | 124.18 | 469622.0 |
| 2015-05-27 | FGBS | Futures | 111.228 | 111.233 | 111.213 | 111.223 | 250623.0 |
| 2015-05-27 | FGBX | Futures | 161.49 | 162.74 | 160.64 | 161.39 | 43487.0 |
| 2015-05-27 | FMWO | Futures | 5911.2 | 5930.9 | 5900.1 | 5930.9 | 383.0 |
| 2015-05-27 | FOAT | Futures | 126.15 | 126.55 | 125.98 | 126.23 | 83384.0 |
| 2015-05-27 | FTDX | Futures | 1611.9 | 1618.9 | 1606.7 | 1615.2 | 541.0 |
| 2015-05-27 | FTI | Futures | 432.98 | 440.08 | 432.59 | 438.9 | 36466.0 |
| 2015-05-27 | FTUK | Futures | 5480.3 | 5553.2 | 5466.5 | 5537.0 | 111350.0 |
| 2015-05-27 | FVSA | Futures | 1662.11 | 1669.84 | 1580.94 | 1600.26 | 8899.0 |
| 2015-05-27 | FXXP | Futures | 309.8 | 314.0 | 309.5 | 313.5 | 18972.0 |
| 2015-05-27 | G | Futures | 102.45 | 102.67 | 102.25 | 102.43 | 259582.0 |
| 2015-05-27 | GF | Futures | 373.745 | 377.655 | 371.28 | 376.465 | 6637.0 |
| 2015-05-27 | GSCI | Futures | 732.16 | 732.5 | 725.2 | 725.54 | 227.0 |
| 2015-05-27 | HE | Futures | 90.689 | 91.775 | 90.553 | 90.987 | 9847.0 |
> showing 50 of 107 rows — these rows as CSV