PREVIEW / futures_daily / 2015-06-19
file: by_date/futures_daily/2015/2015-06-19.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-06-19 | ES | Futures | 2241.25 | 2244.43 | 2222.44 | 2223.23 | 1239246.0 |
| 2015-06-19 | NQ | Futures | 5288.86 | 5300.24 | 5249.46 | 5253.54 | 162664.0 |
| 2015-06-19 | YM | Futures | 18534.7 | 18564.4 | 18390.9 | 18395.0 | 100120.0 |
| 2015-06-19 | CL | Futures | 101.68 | 101.77 | 98.94 | 100.16 | 299894.0 |
| 2015-06-19 | GC | Futures | 1569.5 | 1572.4 | 1564.6 | 1569.7 | 86055.0 |
| 2015-06-19 | ZN | Futures | 120.168649 | 120.794605 | 120.138842 | 120.734991 | 957045.0 |
| 2015-06-19 | A6 | Futures | 0.76892 | 0.77051 | 0.76268 | 0.76575 | 53160.0 |
| 2015-06-19 | AD | Futures | 0.83518 | 0.836 | 0.83048 | 0.83283 | 52235.0 |
| 2015-06-19 | ALI | Futures | 2312.03 | 2312.03 | 2312.03 | 2312.03 | 0.0 |
| 2015-06-19 | B | Futures | 60.4 | 60.74 | 58.65 | 59.29 | 216169.0 |
| 2015-06-19 | B6 | Futures | 1.6706 | 1.6721 | 1.6657 | 1.6705 | 58807.0 |
| 2015-06-19 | BFX | Futures | 4376.8 | 4376.8 | 4341.1 | 4341.1 | 5.0 |
| 2015-06-19 | BR | Futures | 0.19088 | 0.191 | 0.18845 | 0.18887 | 16.0 |
| 2015-06-19 | BZ | Futures | 60.4 | 60.85 | 58.78 | 59.41 | 19112.0 |
| 2015-06-19 | C | Futures | 2314.0 | 2323.0 | 2282.0 | 2291.0 | 7028.0 |
| 2015-06-19 | CB | Futures | 158.042 | 159.663 | 157.637 | 158.852 | 23.0 |
| 2015-06-19 | CC | Futures | 2418.0 | 2426.0 | 2385.0 | 2397.0 | 12173.0 |
| 2015-06-19 | CNH | Futures | 7.0138 | 7.0166 | 7.0118 | 7.0118 | 20.0 |
| 2015-06-19 | CSC | Futures | 4.457 | 4.495 | 4.457 | 4.47 | 35.0 |
| 2015-06-19 | CT | Futures | 80.62 | 80.62 | 79.11 | 79.76 | 3643.0 |
| 2015-06-19 | DC | Futures | 35.56 | 36.2 | 35.54 | 35.92 | 148.0 |
| 2015-06-19 | DX | Futures | 88.18 | 88.643 | 88.081 | 88.247 | 28082.0 |
| 2015-06-19 | E1 | Futures | 1.38205 | 1.3903 | 1.3771 | 1.38878 | 13628.0 |
| 2015-06-19 | E6 | Futures | 1.33714 | 1.34113 | 1.32809 | 1.33526 | 166165.0 |
| 2015-06-19 | E7 | Futures | 1.3299 | 1.3335 | 1.3208 | 1.3279 | 4177.0 |
| 2015-06-19 | EBM | Futures | 291.02 | 292.66 | 291.02 | 292.66 | 6327.0 |
| 2015-06-19 | ED | Futures | 95.6175 | 95.627 | 95.6127 | 95.6222 | 132688.0 |
| 2015-06-19 | ER | Futures | 98.063 | 98.073 | 98.053 | 98.063 | 158559.0 |
| 2015-06-19 | EW | Futures | 1616.0 | 1619.5 | 1605.5 | 1606.2 | 11986.0 |
| 2015-06-19 | FBTP | Futures | 96.14 | 96.88 | 95.93 | 96.36 | 87206.0 |
| 2015-06-19 | FBTS | Futures | 99.172 | 99.287 | 99.127 | 99.234 | 17773.0 |
| 2015-06-19 | FCE | Futures | 3974.9 | 4053.7 | 3974.5 | 4005.7 | 113259.0 |
| 2015-06-19 | FDAX | Futures | 12263.4 | 12443.1 | 12160.6 | 12214.8 | 117376.0 |
| 2015-06-19 | FDIV | Futures | 152.0 | 152.0 | 151.45 | 151.45 | 3.0 |
| 2015-06-19 | FESX | Futures | 2546.6 | 2587.3 | 2541.4 | 2554.7 | 1282900.0 |
| 2015-06-19 | FEU3 | Futures | 98.71 | 98.71 | 98.71 | 98.71 | 78.0 |
| 2015-06-19 | FGBL | Futures | 135.1 | 135.81 | 135.06 | 135.65 | 541397.0 |
| 2015-06-19 | FGBM | Futures | 123.7 | 123.93 | 123.66 | 123.88 | 458400.0 |
| 2015-06-19 | FGBS | Futures | 111.153 | 111.178 | 111.138 | 111.168 | 184588.0 |
| 2015-06-19 | FGBX | Futures | 152.44 | 154.2 | 152.42 | 153.84 | 21796.0 |
| 2015-06-19 | FMWO | Futures | 5911.0 | 5911.0 | 5885.2 | 5885.2 | 34.0 |
| 2015-06-19 | FOAT | Futures | 123.07 | 123.77 | 122.8 | 123.45 | 81471.0 |
| 2015-06-19 | FTDX | Futures | 1549.6 | 1563.2 | 1537.3 | 1540.6 | 257.0 |
| 2015-06-19 | FTI | Futures | 413.06 | 418.74 | 411.23 | 414.89 | 45626.0 |
| 2015-06-19 | FTUK | Futures | 5267.0 | 5333.0 | 5267.0 | 5293.3 | 108781.0 |
| 2015-06-19 | FVSA | Futures | 1955.95 | 1955.95 | 1867.41 | 1895.58 | 16513.0 |
| 2015-06-19 | FXXP | Futures | 294.7 | 298.0 | 294.5 | 295.3 | 15441.0 |
| 2015-06-19 | G | Futures | 101.49 | 101.75 | 101.31 | 101.56 | 112391.0 |
| 2015-06-19 | GF | Futures | 377.443 | 380.588 | 377.23 | 379.866 | 2997.0 |
| 2015-06-19 | GSCI | Futures | 721.82 | 721.82 | 715.07 | 720.15 | 258.0 |
> showing 50 of 108 rows — these rows as CSV