PREVIEW / futures_daily / 2015-05-26
file: by_date/futures_daily/2015/2015-05-26.parquet size: 9 KB rows: 108
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-26 | ES | Futures | 2233.83 | 2236.46 | 2203.87 | 2213.33 | 1589652.0 |
| 2015-05-26 | NQ | Futures | 5256.57 | 5269.35 | 5172.4 | 5201.14 | 228084.0 |
| 2015-05-26 | YM | Futures | 18646.7 | 18671.3 | 18374.6 | 18465.7 | 177518.0 |
| 2015-05-26 | CL | Futures | 100.92 | 101.25 | 96.98 | 97.52 | 330128.0 |
| 2015-05-26 | GC | Futures | 1575.4 | 1578.8 | 1548.4 | 1551.3 | 93072.0 |
| 2015-05-26 | ZN | Futures | 120.798947 | 121.198552 | 120.606545 | 121.154151 | 2478344.0 |
| 2015-05-26 | A6 | Futures | 0.76946 | 0.77242 | 0.76128 | 0.76157 | 91762.0 |
| 2015-05-26 | AD | Futures | 0.82956 | 0.8315 | 0.81996 | 0.82108 | 72469.0 |
| 2015-05-26 | ALI | Futures | 2381.03 | 2381.03 | 2381.03 | 2381.03 | 0.0 |
| 2015-05-26 | B | Futures | 62.32 | 62.32 | 60.12 | 60.5 | 96523.0 |
| 2015-05-26 | B6 | Futures | 1.6278 | 1.632 | 1.6159 | 1.6191 | 103136.0 |
| 2015-05-26 | BFX | Futures | 4509.2 | 4514.0 | 4472.9 | 4484.5 | 13.0 |
| 2015-05-26 | BR | Futures | 0.18545 | 0.18701 | 0.18414 | 0.18417 | 1776.0 |
| 2015-05-26 | BZ | Futures | 62.22 | 62.93 | 60.27 | 60.63 | 9968.0 |
| 2015-05-26 | C | Futures | 2276.0 | 2290.0 | 2265.0 | 2290.0 | 6342.0 |
| 2015-05-26 | CB | Futures | 157.231 | 158.589 | 156.421 | 158.022 | 34.0 |
| 2015-05-26 | CC | Futures | 2305.0 | 2326.0 | 2302.0 | 2324.0 | 12058.0 |
| 2015-05-26 | CNH | Futures | 6.9791 | 6.9849 | 6.9791 | 6.9841 | 22.0 |
| 2015-05-26 | CSC | Futures | 4.5 | 4.526 | 4.5 | 4.516 | 13.0 |
| 2015-05-26 | CT | Futures | 79.78 | 81.45 | 79.7 | 79.75 | 17506.0 |
| 2015-05-26 | DC | Futures | 37.0 | 37.19 | 36.95 | 37.02 | 50.0 |
| 2015-05-26 | DX | Futures | 90.648 | 91.521 | 90.639 | 91.462 | 62434.0 |
| 2015-05-26 | E1 | Futures | 1.35024 | 1.35584 | 1.33737 | 1.33826 | 19183.0 |
| 2015-05-26 | E6 | Futures | 1.29199 | 1.29505 | 1.27776 | 1.2787 | 316539.0 |
| 2015-05-26 | E7 | Futures | 1.2856 | 1.2874 | 1.2705 | 1.2713 | 7655.0 |
| 2015-05-26 | EBM | Futures | 300.86 | 301.27 | 294.3 | 296.76 | 11471.0 |
| 2015-05-26 | ED | Futures | 95.5549 | 95.5573 | 95.5525 | 95.5573 | 114529.0 |
| 2015-05-26 | ER | Futures | 98.068 | 98.077 | 98.068 | 98.077 | 38183.0 |
| 2015-05-26 | EW | Futures | 1614.7 | 1617.6 | 1592.9 | 1599.2 | 16563.0 |
| 2015-05-26 | FBTP | Futures | 98.99 | 99.46 | 98.58 | 98.99 | 105081.0 |
| 2015-05-26 | FBTS | Futures | 99.768 | 99.786 | 99.661 | 99.75 | 18876.0 |
| 2015-05-26 | FCE | Futures | 4227.9 | 4257.0 | 4185.1 | 4204.7 | 117927.0 |
| 2015-05-26 | FDAX | Futures | 13089.4 | 13244.7 | 12860.9 | 12893.0 | 115235.0 |
| 2015-05-26 | FDIV | Futures | 158.43 | 158.43 | 158.06 | 158.06 | 2.0 |
| 2015-05-26 | FESX | Futures | 2691.0 | 2702.8 | 2648.3 | 2658.6 | 1087149.0 |
| 2015-05-26 | FEU3 | Futures | 98.715 | 98.72 | 98.715 | 98.72 | 780.0 |
| 2015-05-26 | FGBL | Futures | 137.05 | 137.66 | 136.85 | 137.5 | 634981.0 |
| 2015-05-26 | FGBM | Futures | 124.03 | 124.24 | 123.98 | 124.17 | 474346.0 |
| 2015-05-26 | FGBS | Futures | 111.213 | 111.233 | 111.208 | 111.223 | 234637.0 |
| 2015-05-26 | FGBX | Futures | 160.38 | 161.9 | 159.9 | 161.43 | 39591.0 |
| 2015-05-26 | FMWO | Futures | 5933.4 | 5933.4 | 5887.8 | 5893.9 | 204.0 |
| 2015-05-26 | FOAT | Futures | 125.89 | 126.47 | 125.65 | 126.22 | 80629.0 |
| 2015-05-26 | FTDX | Futures | 1622.7 | 1631.6 | 1605.3 | 1605.8 | 298.0 |
| 2015-05-26 | FTI | Futures | 436.42 | 438.25 | 431.37 | 432.63 | 31884.0 |
| 2015-05-26 | FTUK | Futures | 5535.5 | 5550.4 | 5452.7 | 5468.1 | 105993.0 |
| 2015-05-26 | FVSA | Futures | 1573.21 | 1665.97 | 1557.74 | 1646.65 | 9919.0 |
| 2015-05-26 | FXXP | Futures | 312.2 | 313.7 | 308.5 | 309.2 | 12097.0 |
| 2015-05-26 | G | Futures | 102.25 | 102.7 | 102.13 | 102.52 | 346438.0 |
| 2015-05-26 | GF | Futures | 372.512 | 373.957 | 372.47 | 373.362 | 3871.0 |
| 2015-05-26 | GSCI | Futures | 740.15 | 742.1 | 733.27 | 735.39 | 181.0 |
> showing 50 of 108 rows — these rows as CSV