PREVIEW / futures_daily / 2015-04-17
file: by_date/futures_daily/2015/2015-04-17.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-04-17 | ES | Futures | 2209.39 | 2209.91 | 2170.74 | 2182.31 | 1822841.0 |
| 2015-04-17 | NQ | Futures | 5127.41 | 5128.86 | 5020.3 | 5049.33 | 302065.0 |
| 2015-04-17 | YM | Futures | 18451.4 | 18456.5 | 18069.8 | 18176.2 | 211029.0 |
| 2015-04-17 | CL | Futures | 98.43 | 99.06 | 96.53 | 97.33 | 259079.0 |
| 2015-04-17 | GC | Futures | 1568.4 | 1580.4 | 1566.3 | 1574.2 | 111545.0 |
| 2015-04-17 | ZN | Futures | 122.737769 | 123.107773 | 122.560167 | 122.959771 | 1177145.0 |
| 2015-04-17 | A6 | Futures | 0.7665 | 0.77094 | 0.76276 | 0.76473 | 103387.0 |
| 2015-04-17 | AD | Futures | 0.83701 | 0.84416 | 0.83139 | 0.83354 | 97197.0 |
| 2015-04-17 | ALI | Futures | 2536.93 | 2536.93 | 2536.93 | 2536.93 | 0.0 |
| 2015-04-17 | B | Futures | 61.77 | 62.23 | 60.74 | 61.22 | 220117.0 |
| 2015-04-17 | B6 | Futures | 1.5716 | 1.5839 | 1.5695 | 1.574 | 97263.0 |
| 2015-04-17 | BFX | Futures | 4631.2 | 4631.2 | 4526.5 | 4535.6 | 43.0 |
| 2015-04-17 | BR | Futures | 0.18779 | 0.18779 | 0.1836 | 0.18431 | 505.0 |
| 2015-04-17 | BZ | Futures | 61.14 | 61.68 | 60.19 | 60.69 | 18872.0 |
| 2015-04-17 | C | Futures | 2135.0 | 2145.0 | 2116.0 | 2118.0 | 4096.0 |
| 2015-04-17 | CB | Futures | 153.738 | 153.738 | 153.738 | 153.738 | 14.0 |
| 2015-04-17 | CC | Futures | 2119.0 | 2127.0 | 2090.0 | 2096.0 | 12757.0 |
| 2015-04-17 | CNH | Futures | 6.9959 | 7.0048 | 6.9959 | 7.0018 | 34.0 |
| 2015-04-17 | CSC | Futures | 4.306 | 4.383 | 4.303 | 4.378 | 48.0 |
| 2015-04-17 | CT | Futures | 82.49 | 82.54 | 80.96 | 81.12 | 9575.0 |
| 2015-04-17 | DC | Futures | 35.4 | 36.01 | 35.31 | 35.94 | 207.0 |
| 2015-04-17 | DX | Futures | 91.916 | 92.047 | 91.24 | 91.744 | 57701.0 |
| 2015-04-17 | E1 | Futures | 1.33673 | 1.34527 | 1.33278 | 1.33953 | 23845.0 |
| 2015-04-17 | E6 | Futures | 1.26683 | 1.27671 | 1.26318 | 1.27 | 302400.0 |
| 2015-04-17 | E7 | Futures | 1.2595 | 1.2694 | 1.2558 | 1.2627 | 7006.0 |
| 2015-04-17 | EBM | Futures | 293.25 | 295.26 | 291.65 | 293.25 | 19795.0 |
| 2015-04-17 | ED | Futures | 95.5429 | 95.5477 | 95.5429 | 95.5477 | 136559.0 |
| 2015-04-17 | ER | Futures | 98.073 | 98.077 | 98.063 | 98.068 | 54935.0 |
| 2015-04-17 | EW | Futures | 1606.8 | 1607.1 | 1579.5 | 1588.0 | 21540.0 |
| 2015-04-17 | FBTP | Futures | 102.96 | 103.06 | 101.87 | 102.3 | 156958.0 |
| 2015-04-17 | FBTS | Futures | 99.59 | 99.608 | 99.492 | 99.572 | 30337.0 |
| 2015-04-17 | FCE | Futures | 4246.7 | 4258.6 | 4159.5 | 4178.9 | 170996.0 |
| 2015-04-17 | FDAX | Futures | 13341.8 | 13371.8 | 12941.9 | 12994.0 | 154554.0 |
| 2015-04-17 | FDIV | Futures | 161.95 | 161.95 | 161.35 | 161.35 | 5.0 |
| 2015-04-17 | FESX | Futures | 2716.1 | 2721.2 | 2646.1 | 2655.6 | 1687402.0 |
| 2015-04-17 | FGBL | Futures | 142.43 | 142.76 | 142.33 | 142.41 | 486837.0 |
| 2015-04-17 | FGBM | Futures | 125.08 | 125.15 | 125.05 | 125.08 | 303523.0 |
| 2015-04-17 | FGBS | Futures | 111.313 | 111.328 | 111.288 | 111.303 | 172117.0 |
| 2015-04-17 | FGBX | Futures | 181.82 | 183.39 | 181.13 | 181.86 | 24525.0 |
| 2015-04-17 | FMWO | Futures | 5902.6 | 5902.6 | 5822.4 | 5824.9 | 219.0 |
| 2015-04-17 | FOAT | Futures | 131.12 | 131.21 | 130.77 | 130.83 | 60842.0 |
| 2015-04-17 | FTDX | Futures | 1546.7 | 1559.3 | 1519.5 | 1520.9 | 550.0 |
| 2015-04-17 | FTI | Futures | 434.84 | 435.49 | 425.09 | 426.74 | 48174.0 |
| 2015-04-17 | FTUK | Futures | 5541.8 | 5563.0 | 5461.0 | 5475.9 | 142460.0 |
| 2015-04-17 | FVSA | Futures | 1638.18 | 1836.03 | 1630.27 | 1808.33 | 26735.0 |
| 2015-04-17 | FXXP | Futures | 311.0 | 311.7 | 305.3 | 305.7 | 16408.0 |
| 2015-04-17 | G | Futures | 105.0 | 105.43 | 104.81 | 104.98 | 144854.0 |
| 2015-04-17 | GF | Futures | 365.869 | 368.018 | 358.308 | 358.351 | 4151.0 |
| 2015-04-17 | GSCI | Futures | 736.97 | 743.1 | 732.38 | 734.59 | 141.0 |
| 2015-04-17 | HE | Futures | 81.371 | 82.007 | 81.198 | 81.574 | 187.0 |
> showing 50 of 107 rows — these rows as CSV