PREVIEW / futures_daily / 2015-01-16
file: by_date/futures_daily/2015/2015-01-16.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-01-16 | ES | Futures | 2076.08 | 2111.19 | 2065.07 | 2109.88 | 2017979.0 |
| 2015-01-16 | NQ | Futures | 4725.29 | 4801.87 | 4689.32 | 4796.64 | 359021.0 |
| 2015-01-16 | YM | Futures | 17538.2 | 17780.6 | 17441.4 | 17754.1 | 219257.0 |
| 2015-01-16 | CL | Futures | 89.8 | 94.82 | 89.17 | 94.41 | 404879.0 |
| 2015-01-16 | GC | Futures | 1653.8 | 1678.6 | 1643.0 | 1671.4 | 219412.0 |
| 2015-01-16 | ZN | Futures | 123.19129 | 123.367951 | 122.234379 | 122.352153 | 1609859.0 |
| 2015-01-16 | A6 | Futures | 0.79973 | 0.80542 | 0.79679 | 0.80297 | 82109.0 |
| 2015-01-16 | AD | Futures | 0.84977 | 0.85079 | 0.84437 | 0.85028 | 66396.0 |
| 2015-01-16 | ALI | Futures | 2865.69 | 2865.69 | 2865.69 | 2865.69 | 0.0 |
| 2015-01-16 | B | Futures | 49.27 | 51.48 | 49.09 | 51.23 | 293492.0 |
| 2015-01-16 | B6 | Futures | 1.595 | 1.6012 | 1.5844 | 1.594 | 108071.0 |
| 2015-01-16 | BFX | Futures | 3986.5 | 4063.2 | 3986.5 | 4063.2 | 24.0 |
| 2015-01-16 | BR | Futures | 0.20811 | 0.20855 | 0.20811 | 0.20841 | 28.0 |
| 2015-01-16 | BZ | Futures | 49.29 | 51.7 | 49.28 | 51.51 | 29134.0 |
| 2015-01-16 | C | Futures | 2216.0 | 2229.0 | 2208.0 | 2217.0 | 5161.0 |
| 2015-01-16 | CB | Futures | 132.673 | 132.673 | 132.263 | 132.263 | 5.0 |
| 2015-01-16 | CC | Futures | 2195.0 | 2197.0 | 2167.0 | 2171.0 | 12037.0 |
| 2015-01-16 | CNH | Futures | 7.0854 | 7.1324 | 7.0818 | 7.1324 | 67.0 |
| 2015-01-16 | CSC | Futures | 4.282 | 4.285 | 4.239 | 4.239 | 97.0 |
| 2015-01-16 | CT | Futures | 75.88 | 76.44 | 75.56 | 75.65 | 9988.0 |
| 2015-01-16 | DC | Futures | 33.29 | 33.29 | 32.73 | 32.77 | 182.0 |
| 2015-01-16 | DX | Futures | 87.619 | 88.566 | 87.444 | 87.927 | 60076.0 |
| 2015-01-16 | E1 | Futures | 1.50357 | 1.51468 | 1.45135 | 1.49399 | 78513.0 |
| 2015-01-16 | E6 | Futures | 1.36881 | 1.37104 | 1.34881 | 1.36328 | 527783.0 |
| 2015-01-16 | E7 | Futures | 1.3606 | 1.3627 | 1.3406 | 1.3551 | 8375.0 |
| 2015-01-16 | EBM | Futures | 315.9 | 321.17 | 315.49 | 320.36 | 21311.0 |
| 2015-01-16 | ED | Futures | 95.4641 | 95.4689 | 95.4546 | 95.4594 | 164545.0 |
| 2015-01-16 | ER | Futures | 98.058 | 98.082 | 98.058 | 98.068 | 75189.0 |
| 2015-01-16 | EW | Futures | 1465.3 | 1494.4 | 1456.2 | 1491.9 | 21772.0 |
| 2015-01-16 | FBTP | Futures | 99.84 | 100.6 | 99.7 | 100.3 | 98822.0 |
| 2015-01-16 | FBTS | Futures | 98.836 | 98.978 | 98.828 | 98.952 | 14631.0 |
| 2015-01-16 | FCE | Futures | 3496.5 | 3606.6 | 3493.7 | 3572.0 | 154320.0 |
| 2015-01-16 | FDAX | Futures | 11058.6 | 11452.7 | 11039.7 | 11325.0 | 169660.0 |
| 2015-01-16 | FDIV | Futures | 141.59 | 144.74 | 141.59 | 144.74 | 53.0 |
| 2015-01-16 | FESX | Futures | 2253.7 | 2328.0 | 2253.0 | 2307.8 | 1525699.0 |
| 2015-01-16 | FEU3 | Futures | 98.69 | 98.695 | 98.675 | 98.685 | 83.0 |
| 2015-01-16 | FGBL | Futures | 138.03 | 138.31 | 137.79 | 137.85 | 760319.0 |
| 2015-01-16 | FGBM | Futures | 124.15 | 124.2 | 124.09 | 124.11 | 366251.0 |
| 2015-01-16 | FGBS | Futures | 111.078 | 111.103 | 111.058 | 111.093 | 346484.0 |
| 2015-01-16 | FGBX | Futures | 161.83 | 163.21 | 161.17 | 161.47 | 30692.0 |
| 2015-01-16 | FMWO | Futures | 5455.4 | 5493.7 | 5455.4 | 5487.6 | 570.0 |
| 2015-01-16 | FOAT | Futures | 127.13 | 127.61 | 127.08 | 127.26 | 81555.0 |
| 2015-01-16 | FTDX | Futures | 1343.5 | 1355.2 | 1336.4 | 1352.9 | 165.0 |
| 2015-01-16 | FTI | Futures | 364.76 | 376.1 | 364.63 | 373.55 | 54206.0 |
| 2015-01-16 | FTUK | Futures | 4979.9 | 5090.2 | 4971.7 | 5058.6 | 117511.0 |
| 2015-01-16 | FVSA | Futures | 2173.68 | 2251.16 | 2160.77 | 2195.2 | 13622.0 |
| 2015-01-16 | FXXP | Futures | 261.2 | 266.8 | 260.0 | 265.6 | 12943.0 |
| 2015-01-16 | G | Futures | 105.56 | 105.7 | 104.84 | 104.95 | 202674.0 |
| 2015-01-16 | GF | Futures | 345.112 | 350.046 | 340.936 | 345.575 | 6594.0 |
| 2015-01-16 | GSCI | Futures | 667.96 | 676.15 | 667.19 | 674.0 | 204.0 |
> showing 50 of 108 rows — these rows as CSV