PREVIEW / futures_daily / 2015-07-20
file: by_date/futures_daily/2015/2015-07-20.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-07-20 | ES | Futures | 2244.69 | 2253.44 | 2243.1 | 2248.93 | 937630.0 |
| 2015-07-20 | NQ | Futures | 5427.8 | 5470.99 | 5424.88 | 5453.77 | 169781.0 |
| 2015-07-20 | YM | Futures | 18479.2 | 18545.9 | 18466.9 | 18489.5 | 81454.0 |
| 2015-07-20 | CL | Futures | 84.86 | 85.64 | 83.27 | 83.75 | 288564.0 |
| 2015-07-20 | GC | Futures | 1478.9 | 1479.0 | 1410.5 | 1445.5 | 261352.0 |
| 2015-07-20 | ZN | Futures | 120.302783 | 120.33259 | 119.900383 | 120.079227 | 769583.0 |
| 2015-07-20 | A6 | Futures | 0.72821 | 0.73049 | 0.72356 | 0.72811 | 67086.0 |
| 2015-07-20 | AD | Futures | 0.78712 | 0.78896 | 0.78467 | 0.7859 | 46030.0 |
| 2015-07-20 | ALI | Futures | 2277.06 | 2277.06 | 2277.06 | 2277.06 | 0.0 |
| 2015-07-20 | B | Futures | 53.15 | 53.45 | 52.42 | 52.72 | 161060.0 |
| 2015-07-20 | B6 | Futures | 1.6417 | 1.6442 | 1.6347 | 1.6379 | 55727.0 |
| 2015-07-20 | BFX | Futures | 4638.6 | 4661.6 | 4638.6 | 4661.6 | 4.0 |
| 2015-07-20 | BR | Futures | 0.1848 | 0.18494 | 0.18315 | 0.18474 | 912.0 |
| 2015-07-20 | BZ | Futures | 53.09 | 53.41 | 52.39 | 52.68 | 20026.0 |
| 2015-07-20 | C | Futures | 2379.0 | 2384.0 | 2363.0 | 2382.0 | 5557.0 |
| 2015-07-20 | CB | Futures | 150.849 | 151.619 | 150.849 | 151.558 | 6.0 |
| 2015-07-20 | CC | Futures | 2459.0 | 2471.0 | 2440.0 | 2466.0 | 8700.0 |
| 2015-07-20 | CSC | Futures | 4.255 | 4.277 | 4.252 | 4.262 | 9.0 |
| 2015-07-20 | CT | Futures | 80.24 | 81.65 | 79.65 | 80.58 | 41.0 |
| 2015-07-20 | DC | Futures | 34.2 | 34.4 | 33.99 | 34.18 | 156.0 |
| 2015-07-20 | DX | Futures | 91.821 | 92.027 | 91.61 | 91.887 | 26102.0 |
| 2015-07-20 | E1 | Futures | 1.3225 | 1.32478 | 1.31754 | 1.31919 | 14130.0 |
| 2015-07-20 | E6 | Futures | 1.27346 | 1.27793 | 1.27076 | 1.27311 | 131930.0 |
| 2015-07-20 | E7 | Futures | 1.2663 | 1.2709 | 1.2637 | 1.2661 | 2622.0 |
| 2015-07-20 | EBM | Futures | 313.56 | 313.56 | 310.7 | 311.11 | 20968.0 |
| 2015-07-20 | ED | Futures | 95.6366 | 95.6366 | 95.6127 | 95.6175 | 199942.0 |
| 2015-07-20 | ER | Futures | 98.112 | 98.112 | 98.107 | 98.112 | 14519.0 |
| 2015-07-20 | EW | Futures | 1574.1 | 1580.0 | 1572.5 | 1577.0 | 14440.0 |
| 2015-07-20 | FBTP | Futures | 100.31 | 100.74 | 100.14 | 100.31 | 59738.0 |
| 2015-07-20 | FBTS | Futures | 99.964 | 99.999 | 99.946 | 99.973 | 13799.0 |
| 2015-07-20 | FCE | Futures | 4280.0 | 4324.6 | 4277.9 | 4288.4 | 67299.0 |
| 2015-07-20 | FDAX | Futures | 12998.6 | 13052.7 | 12953.3 | 12996.4 | 56483.0 |
| 2015-07-20 | FESX | Futures | 2723.5 | 2748.6 | 2721.2 | 2730.1 | 645926.0 |
| 2015-07-20 | FEU3 | Futures | 98.754 | 98.754 | 98.749 | 98.749 | 10.0 |
| 2015-07-20 | FGBL | Futures | 136.18 | 136.8 | 135.99 | 136.42 | 410866.0 |
| 2015-07-20 | FGBM | Futures | 124.25 | 124.4 | 124.18 | 124.31 | 285522.0 |
| 2015-07-20 | FGBS | Futures | 111.198 | 111.208 | 111.188 | 111.198 | 96639.0 |
| 2015-07-20 | FGBX | Futures | 153.02 | 155.13 | 152.84 | 154.06 | 20262.0 |
| 2015-07-20 | FMWO | Futures | 5904.9 | 5908.6 | 5902.4 | 5903.7 | 305.0 |
| 2015-07-20 | FOAT | Futures | 124.56 | 125.37 | 124.56 | 125.02 | 47492.0 |
| 2015-07-20 | FTDX | Futures | 1711.6 | 1735.1 | 1711.6 | 1721.0 | 270.0 |
| 2015-07-20 | FTI | Futures | 430.7 | 434.5 | 429.71 | 431.13 | 18857.0 |
| 2015-07-20 | FTUK | Futures | 5345.3 | 5375.1 | 5339.4 | 5357.6 | 51000.0 |
| 2015-07-20 | FVSA | Futures | 1780.86 | 1780.86 | 1723.83 | 1728.22 | 23574.0 |
| 2015-07-20 | FXXP | Futures | 312.9 | 313.7 | 311.4 | 312.5 | 12648.0 |
| 2015-07-20 | G | Futures | 100.98 | 101.46 | 100.84 | 101.1 | 118445.0 |
| 2015-07-20 | GF | Futures | 366.902 | 368.474 | 366.391 | 367.794 | 2322.0 |
| 2015-07-20 | GSCI | Futures | 669.32 | 670.15 | 665.32 | 665.74 | 31.0 |
| 2015-07-20 | HE | Futures | 84.671 | 84.978 | 83.303 | 83.666 | 12468.0 |
| 2015-07-20 | HG | Futures | 3.1162 | 3.1237 | 3.0769 | 3.0969 | 38906.0 |
> showing 50 of 106 rows — these rows as CSV