PREVIEW / futures_daily / 2015-05-08
file: by_date/futures_daily/2015/2015-05-08.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-05-08 | ES | Futures | 2192.56 | 2222.27 | 2191.25 | 2217.01 | 1379447.0 |
| 2015-05-08 | NQ | Futures | 5113.19 | 5181.4 | 5109.7 | 5165.14 | 216447.0 |
| 2015-05-08 | YM | Futures | 18304.1 | 18570.0 | 18291.8 | 18535.2 | 155957.0 |
| 2015-05-08 | CL | Futures | 100.22 | 101.71 | 98.72 | 100.85 | 434575.0 |
| 2015-05-08 | GC | Futures | 1548.9 | 1561.0 | 1544.7 | 1555.7 | 143614.0 |
| 2015-05-08 | ZN | Futures | 120.606545 | 121.435354 | 120.517744 | 121.08015 | 1678106.0 |
| 2015-05-08 | A6 | Futures | 0.77854 | 0.78475 | 0.774 | 0.77932 | 117280.0 |
| 2015-05-08 | AD | Futures | 0.84232 | 0.84732 | 0.84038 | 0.84375 | 69718.0 |
| 2015-05-08 | ALI | Futures | 2563.54 | 2563.54 | 2563.54 | 2563.54 | 0.0 |
| 2015-05-08 | B | Futures | 62.98 | 63.66 | 61.87 | 62.98 | 194398.0 |
| 2015-05-08 | B6 | Futures | 1.6222 | 1.6335 | 1.6157 | 1.626 | 187265.0 |
| 2015-05-08 | BFX | Futures | 4380.8 | 4428.2 | 4380.8 | 4428.2 | 4.0 |
| 2015-05-08 | BR | Futures | 0.18825 | 0.19019 | 0.18602 | 0.18979 | 840.0 |
| 2015-05-08 | BZ | Futures | 62.45 | 62.98 | 61.29 | 62.37 | 17248.0 |
| 2015-05-08 | C | Futures | 2171.0 | 2180.0 | 2158.0 | 2163.0 | 8073.0 |
| 2015-05-08 | CB | Futures | 165.066 | 165.47 | 165.066 | 165.47 | 13.0 |
| 2015-05-08 | CC | Futures | 2186.0 | 2187.0 | 2150.0 | 2173.0 | 14292.0 |
| 2015-05-08 | CNH | Futures | 6.9941 | 6.9941 | 6.9909 | 6.9909 | 6.0 |
| 2015-05-08 | CSC | Futures | 4.607 | 4.762 | 4.599 | 4.706 | 146.0 |
| 2015-05-08 | CT | Futures | 82.55 | 83.42 | 82.23 | 83.34 | 10028.0 |
| 2015-05-08 | DC | Futures | 38.21 | 39.54 | 38.05 | 39.0 | 1062.0 |
| 2015-05-08 | DX | Futures | 88.963 | 89.366 | 88.498 | 89.112 | 57612.0 |
| 2015-05-08 | E1 | Futures | 1.38426 | 1.38719 | 1.36821 | 1.37012 | 26285.0 |
| 2015-05-08 | E6 | Futures | 1.32421 | 1.32915 | 1.31516 | 1.31822 | 329016.0 |
| 2015-05-08 | E7 | Futures | 1.3164 | 1.321 | 1.3076 | 1.3106 | 9002.0 |
| 2015-05-08 | EBM | Futures | 282.82 | 285.69 | 282.41 | 284.05 | 5388.0 |
| 2015-05-08 | ED | Futures | 95.5525 | 95.5669 | 95.5429 | 95.5573 | 245304.0 |
| 2015-05-08 | ER | Futures | 98.068 | 98.077 | 98.068 | 98.073 | 25987.0 |
| 2015-05-08 | EW | Futures | 1577.3 | 1596.0 | 1576.2 | 1586.1 | 17707.0 |
| 2015-05-08 | FBTP | Futures | 99.78 | 100.49 | 99.43 | 100.3 | 130650.0 |
| 2015-05-08 | FBTS | Futures | 99.643 | 99.697 | 99.626 | 99.67 | 14851.0 |
| 2015-05-08 | FCE | Futures | 4057.6 | 4167.4 | 4057.2 | 4162.0 | 121196.0 |
| 2015-05-08 | FDAX | Futures | 12697.8 | 13030.6 | 12675.0 | 12981.2 | 110740.0 |
| 2015-05-08 | FESX | Futures | 2590.1 | 2664.5 | 2587.8 | 2654.9 | 1205418.0 |
| 2015-05-08 | FGBL | Futures | 137.14 | 137.67 | 136.43 | 137.49 | 988226.0 |
| 2015-05-08 | FGBM | Futures | 123.84 | 124.09 | 123.75 | 124.01 | 584330.0 |
| 2015-05-08 | FGBS | Futures | 111.203 | 111.218 | 111.183 | 111.203 | 218821.0 |
| 2015-05-08 | FGBX | Futures | 162.64 | 164.6 | 160.02 | 163.13 | 45497.0 |
| 2015-05-08 | FMWO | Futures | 5873.0 | 5935.8 | 5868.0 | 5935.8 | 237.0 |
| 2015-05-08 | FOAT | Futures | 125.77 | 126.45 | 125.3 | 126.3 | 127538.0 |
| 2015-05-08 | FTDX | Futures | 1517.6 | 1560.3 | 1517.6 | 1557.9 | 195.0 |
| 2015-05-08 | FTI | Futures | 415.47 | 426.13 | 415.25 | 425.26 | 31750.0 |
| 2015-05-08 | FTUK | Futures | 5470.8 | 5544.1 | 5469.2 | 5527.6 | 149998.0 |
| 2015-05-08 | FVSA | Futures | 1784.59 | 1800.42 | 1657.97 | 1669.84 | 12504.0 |
| 2015-05-08 | FXXP | Futures | 298.2 | 305.9 | 298.2 | 304.9 | 19576.0 |
| 2015-05-08 | G | Futures | 103.24 | 103.45 | 102.09 | 102.61 | 277962.0 |
| 2015-05-08 | GF | Futures | 370.166 | 371.197 | 369.392 | 370.982 | 2394.0 |
| 2015-05-08 | GSCI | Futures | 755.27 | 757.14 | 745.14 | 754.85 | 2246.0 |
| 2015-05-08 | HE | Futures | 91.123 | 92.372 | 90.037 | 92.128 | 21728.0 |
| 2015-05-08 | HG | Futures | 3.6575 | 3.68 | 3.6236 | 3.6644 | 40317.0 |
> showing 50 of 106 rows — these rows as CSV